Thanks Naomi,

All mt tables are Remote Views of CONNECTIONS I have made to Pervasive tables using ODBC:

Here is the structure of the first file UX_DETAIL:

2 More to come ...

===============================

Structure for view: RV_UXDETAIL (Remote)

View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO

Connection Name/#: c_DeFedisUniDATA (2)
Parameters:

Source Name: RV_UXDETAIL

Tables: UXDETAIL
======================================================================================================================

Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255

Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No

======================================================================================================================
SQL Statement: SELECT Uxdetail.* FROM UXDETAIL Uxdetail



======================================================================================================================

F# FieldName Struct Upd UpdateName


1 SEQ I Yes UXDETAIL.Seq
2 AUDITDATE N(11,0) Yes UXDETAIL.AuditDate

3 AUDITTIME N(11,0) Yes UXDETAIL.AuditTime

4 CUSTCODE C(12) Yes UXDETAIL.CustCode

5 CUSTNAME C(60) Yes UXDETAIL.CustName
6 SHIPTOCODE C(6) Yes UXDETAIL.ShipToCode

7 CUSTNATACCT C(12) Yes UXDETAIL.CustNatAcct

8 FMTITEMNUM C(35) Yes UXDETAIL.FmtItemNum

9 ITEMNUMBER C(24) Yes UXDETAIL.ItemNumber
10 ITEMDESC C(60) Yes UXDETAIL.ItemDesc

11 CATCODE C(6) Yes UXDETAIL.CatCode

12 CATDESC C(60) Yes UXDETAIL.CatDesc

13 LOCATION C(6) Yes UXDETAIL.Location

14 LOCDESC C(60) Yes UXDETAIL.LocDesc
15 DOCUMENTNUMBER C(22) Yes UXDETAIL.DocumentNumber

16 ORDERNUMBER C(22) Yes UXDETAIL.OrderNumber

17 INVOICENUMBER C(22) Yes UXDETAIL.InvoiceNumber

18 SALESPERSONCODE C(8) Yes UXDETAIL.SalespersonCode
19 SALESPERSONNAME C(60) Yes UXDETAIL.SalespersonName


LS 3.1 - John Koziol (5/9/2001)

Structure for view: RV_UXDETAIL (Remote)

View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO

Connection Name/#: c_DeFedisUniDATA (2)
Parameters:

Source Name: RV_UXDETAIL

Tables: UXDETAIL
======================================================================================================================

Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255

Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No

======================================================================================================================
SQL Statement: SELECT Uxdetail.* FROM UXDETAIL Uxdetail



======================================================================================================================

F# FieldName Struct Upd UpdateName


20 SALESPERSONSPLIT Y Yes UXDETAIL.SalespersonSplit
21 SOURCE C(2) Yes UXDETAIL.Source

22 TERRITORY C(6) Yes UXDETAIL.Territory

23 INVOICEDATE N(11,0) Yes UXDETAIL.InvoiceDate

24 FISCALYEAR C(4) Yes UXDETAIL.FiscalYear
25 FISCALPERIOD I Yes UXDETAIL.FiscalPeriod

26 QUANTITY Y Yes UXDETAIL.Quantity

27 UOM C(10) Yes UXDETAIL.UOM

28 CONVERSIONFACTOR Y Yes UXDETAIL.ConversionFactor
29 SOLDHOME Y Yes UXDETAIL.SoldHome

30 COSTHOME Y Yes UXDETAIL.CostHome

31 SOLDSOURCE Y Yes UXDETAIL.SoldSource

32 COSTSOURCE Y Yes UXDETAIL.CostSource

33 UNITPRICE Y Yes UXDETAIL.UnitPrice
34 BASEPRICE Y Yes UXDETAIL.BasePrice

35 PRICEDEC I Yes UXDETAIL.PriceDec

36 PRICELISTCODE C(6) Yes UXDETAIL.PriceListCode

37 HOMECURRCODE C(3) Yes UXDETAIL.HomeCurrCode
38 RATETYPE C(2) Yes UXDETAIL.RateType


LS 3.1 - John Koziol (5/9/2001)

Structure for view: RV_UXDETAIL (Remote)

View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO

Connection Name/#: c_DeFedisUniDATA (2)
Parameters:

Source Name: RV_UXDETAIL

Tables: UXDETAIL
======================================================================================================================

Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255

Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No

======================================================================================================================
SQL Statement: SELECT Uxdetail.* FROM UXDETAIL Uxdetail



======================================================================================================================

F# FieldName Struct Upd UpdateName


39 SOURCECURRCODE C(3) Yes UXDETAIL.SourceCurrCode
40 RATEDATE N(11,0) Yes UXDETAIL.RateDate

41 RATE Y Yes UXDETAIL.Rate

42 DATEMATCH I Yes UXDETAIL.DateMatch

43 RATEREP I Yes UXDETAIL.RateRep
44 TRANSACTIONTYPE C(2) Yes UXDETAIL.TransactionType

45 LINETYPE C(1) Yes UXDETAIL.LineType

46 ICITEMOPT1 C(2) Yes UXDETAIL.ICITEMOPT1

47 ICITEMOPT2 C(3) Yes UXDETAIL.ICITEMOPT2
48 ICITEMOPT3 C(4) Yes UXDETAIL.ICITEMOPT3

49 ICITEMOPT4 C(12) Yes UXDETAIL.ICITEMOPT4

50 ICITEMOPT5 C(15) Yes UXDETAIL.ICITEMOPT5

51 ICITEMOPT6 C(30) Yes UXDETAIL.ICITEMOPT6

52 ICITEMDATEOPT N(11,0) Yes UXDETAIL.ICITEMDATEOPT
53 ICITEMAMTOPT Y Yes UXDETAIL.ICITEMAMTOPT

54 ARCUSOPT1 C(2) Yes UXDETAIL.ARCUSOPT1

55 ARCUSOPT2 C(3) Yes UXDETAIL.ARCUSOPT2

56 ARCUSOPT3 C(4) Yes UXDETAIL.ARCUSOPT3
57 ARCUSOPT4 C(12) Yes UXDETAIL.ARCUSOPT4


LS 3.1 - John Koziol (5/9/2001)

Structure for view: RV_UXDETAIL (Remote)

View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO

Connection Name/#: c_DeFedisUniDATA (2)
Parameters:

Source Name: RV_UXDETAIL

Tables: UXDETAIL
======================================================================================================================

Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255

Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No

======================================================================================================================
SQL Statement: SELECT Uxdetail.* FROM UXDETAIL Uxdetail



======================================================================================================================

F# FieldName Struct Upd UpdateName


58 ARCUSOPT5 C(15) Yes UXDETAIL.ARCUSOPT5
59 ARCUSOPT6 C(30) Yes UXDETAIL.ARCUSOPT6

60 ARCUSDATEOPT N(11,0) Yes UXDETAIL.ARCUSDATEOPT

61 ARCUSAMTOPT N(20,0) Yes UXDETAIL.ARCUSAMTOPT

62 ARCSPOPT1 C(2) Yes UXDETAIL.ARCSPOPT1
63 ARCSPOPT2 C(3) Yes UXDETAIL.ARCSPOPT2

64 ARCSPOPT3 C(4) Yes UXDETAIL.ARCSPOPT3

65 ARCSPOPT4 C(12) Yes UXDETAIL.ARCSPOPT4

66 ARCSPOPT5 C(15) Yes UXDETAIL.ARCSPOPT5
67 ARCSPOPT6 C(30) Yes UXDETAIL.ARCSPOPT6

68 ARCSPDATEOPT N(11,0) Yes UXDETAIL.ARCSPDATEOPT

69 ARCSPAMTOPT N(20,0) Yes UXDETAIL.ARCSPAMTOPT

70 OEINVOPT1 C(2) Yes UXDETAIL.OEINVOPT1

71 OEINVOPT2 C(3) Yes UXDETAIL.OEINVOPT2
72 OEINVOPT3 C(4) Yes UXDETAIL.OEINVOPT3

73 OEINVOPT4 C(12) Yes UXDETAIL.OEINVOPT4

74 OEINVOPT5 C(15) Yes UXDETAIL.OEINVOPT5

75 OEINVOPT6 C(30) Yes UXDETAIL.OEINVOPT6
76 OEINVDATEOPT N(11,0) Yes UXDETAIL.OEINVDATEOPT


LS 3.1 - John Koziol (5/9/2001)

Structure for view: RV_UXDETAIL (Remote)

View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO

Connection Name/#: c_DeFedisUniDATA (2)
Parameters:

Source Name: RV_UXDETAIL

Tables: UXDETAIL
======================================================================================================================

Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255

Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No

======================================================================================================================
SQL Statement: SELECT Uxdetail.* FROM UXDETAIL Uxdetail



======================================================================================================================

F# FieldName Struct Upd UpdateName


77 OEINVAMTOPT Y Yes UXDETAIL.OEINVAMTOPT
78 QUARTER I Yes UXDETAIL.Quarter

79 CRDNOTETYPE I Yes UXDETAIL.CRDNoteType

80 TAXGROUP C(6) Yes UXDETAIL.TaxGroup

81 LINENO I Yes UXDETAIL.LineNo
82 SEGMENT1 C(24) Yes UXDETAIL.Segment1

83 SEGMENT2 C(24) Yes UXDETAIL.Segment2

84 SEGMENT3 C(24) Yes UXDETAIL.Segment3

85 SEGMENT4 C(24) Yes UXDETAIL.Segment4
86 SEGMENT5 C(24) Yes UXDETAIL.Segment5

87 SEGMENT6 C(24) Yes UXDETAIL.Segment6

88 SEGMENT7 C(24) Yes UXDETAIL.Segment7

89 SEGMENT8 C(24) Yes UXDETAIL.Segment8

90 SEGMENT9 C(24) Yes UXDETAIL.Segment9
91 SEGMENT10 C(24) Yes UXDETAIL.Segment10

92 REFERENCE C(60) Yes UXDETAIL.Reference

93 CUSTOMERGROUP C(6) Yes UXDETAIL.CustomerGroup

94 CUSTGROUPDESC C(60) Yes UXDETAIL.CustGroupDesc
95 STANDARDCOST Y Yes UXDETAIL.StandardCost


LS 3.1 - John Koziol (5/9/2001)

Structure for view: RV_UXDETAIL (Remote)

View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO

Connection Name/#: c_DeFedisUniDATA (2)
Parameters:

Source Name: RV_UXDETAIL

Tables: UXDETAIL
======================================================================================================================

Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255

Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No

======================================================================================================================
SQL Statement: SELECT Uxdetail.* FROM UXDETAIL Uxdetail



======================================================================================================================

F# FieldName Struct Upd UpdateName


96 DISCOUNTAMOUNT Y Yes UXDETAIL.DiscountAmount
97 CUSTOMERPO C(22) Yes UXDETAIL.CustomerPO

98 ACCOUNTSET C(6) Yes UXDETAIL.AccountSet

99 WEIGHT Y Yes UXDETAIL.Weight

100 BILLTOSTATE C(30) Yes UXDETAIL.BillToState
101 BILLTOCOUNTRY C(30) Yes UXDETAIL.BillToCountry

102 SHIPTOSTATE C(30) Yes UXDETAIL.ShipToState

103 SHIPTOCOUNTRY C(30) Yes UXDETAIL.ShipToCountry

104 SHIPTOCUSTNAME C(60) Yes UXDETAIL.ShipToCustName
105 ARDISTRIBUTIONCODE C(6) Yes UXDETAIL.ARDistributionCode

106 GLACCOUNT C(45) Yes UXDETAIL.GLAccount

107 CALENDARMONTH I Yes UXDETAIL.CalendarMonth

108 CALENDARYEAR I Yes UXDETAIL.CalendarYear

109 CALENDARYEAR_MONTH C(7) Yes UXDETAIL.CalendarYear_Month
110 FISCALYEAR_PERIOD C(7) Yes UXDETAIL.FiscalYear_Period

111 BILLTOZIP C(20) Yes UXDETAIL.BillToZip

112 SHIPTOZIP C(20) Yes UXDETAIL.ShipToZip

113 TEMPLATE C(6) Yes UXDETAIL.Template
114 SHIPMENTNUMBER C(22) Yes UXDETAIL.ShipmentNumber


LS 3.1 - John Koziol (5/9/2001)

Structure for view: RV_UXDETAIL (Remote)

View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO

Connection Name/#: c_DeFedisUniDATA (2)
Parameters:

Source Name: RV_UXDETAIL

Tables: UXDETAIL
======================================================================================================================

Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255

Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No

======================================================================================================================
SQL Statement: SELECT Uxdetail.* FROM UXDETAIL Uxdetail



======================================================================================================================

F# FieldName Struct Upd UpdateName


115 MOSTRECENTCOST N(20,0) Yes UXDETAIL.MostRecentCost

























LS 3.1 - John Koziol (5/9/2001)