Here are the other 2 files, RV_AR_CUS and RV_ICPRIC (below):

John

=========================
Structure for view: RV_ARCUS (Remote)
View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
Connection Name/#: C_DeFediSDATA (1)
Parameters:
Source Name: RV_ARCUS
Tables: ARCUS
======================================================================================================================

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 * FROM ARCUS



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

F# FieldName Struct Upd UpdateName


1 IDCUST C(12) Yes ARCUS.IDCUST
2 AUDTDATE N(11,0) Yes ARCUS.AUDTDATE

3 AUDTTIME N(11,0) Yes ARCUS.AUDTTIME

4 AUDTUSER C(8) Yes ARCUS.AUDTUSER

5 AUDTORG C(6) Yes ARCUS.AUDTORG
6 TEXTSNAM C(10) Yes ARCUS.TEXTSNAM

7 IDGRP C(6) Yes ARCUS.IDGRP

8 IDNATACCT C(12) Yes ARCUS.IDNATACCT

9 SWACTV I Yes ARCUS.SWACTV
10 DATEINAC N(11,0) Yes ARCUS.DATEINAC

11 DATELASTMN N(11,0) Yes ARCUS.DATELASTMN

12 SWHOLD I Yes ARCUS.SWHOLD

13 DATESTART N(11,0) Yes ARCUS.DATESTART

14 IDPPNT C(12) Yes ARCUS.IDPPNT
15 CODEDAB C(9) Yes ARCUS.CODEDAB

16 CODEDABRTG C(5) Yes ARCUS.CODEDABRTG

17 DATEDAB N(11,0) Yes ARCUS.DATEDAB

18 NAMECUST C(60) Yes ARCUS.NAMECUST
19 TEXTSTRE1 C(60) Yes ARCUS.TEXTSTRE1


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

Structure for view: RV_ARCUS (Remote)

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

Connection Name/#: C_DeFediSDATA (1)
Parameters:

Source Name: RV_ARCUS

Tables: ARCUS
======================================================================================================================

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 * FROM ARCUS



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

F# FieldName Struct Upd UpdateName


20 TEXTSTRE2 C(60) Yes ARCUS.TEXTSTRE2
21 TEXTSTRE3 C(60) Yes ARCUS.TEXTSTRE3

22 TEXTSTRE4 C(60) Yes ARCUS.TEXTSTRE4

23 NAMECITY C(30) Yes ARCUS.NAMECITY

24 CODESTTE C(30) Yes ARCUS.CODESTTE
25 CODEPSTL C(20) Yes ARCUS.CODEPSTL

26 CODECTRY C(30) Yes ARCUS.CODECTRY

27 NAMECTAC C(60) Yes ARCUS.NAMECTAC

28 TEXTPHON1 C(30) Yes ARCUS.TEXTPHON1
29 TEXTPHON2 C(30) Yes ARCUS.TEXTPHON2

30 CODETERR C(6) Yes ARCUS.CODETERR

31 IDACCTSET C(6) Yes ARCUS.IDACCTSET

32 IDAUTOCASH C(6) Yes ARCUS.IDAUTOCASH

33 IDBILLCYCL C(6) Yes ARCUS.IDBILLCYCL
34 IDSVCCHRG C(6) Yes ARCUS.IDSVCCHRG

35 IDDLNQ C(6) Yes ARCUS.IDDLNQ

36 CODECURN C(3) Yes ARCUS.CODECURN

37 SWPRTSTMT I Yes ARCUS.SWPRTSTMT
38 SWPRTDLNQ I Yes ARCUS.SWPRTDLNQ


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

Structure for view: RV_ARCUS (Remote)

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

Connection Name/#: C_DeFediSDATA (1)
Parameters:

Source Name: RV_ARCUS

Tables: ARCUS
======================================================================================================================

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 * FROM ARCUS



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

F# FieldName Struct Upd UpdateName


39 SWBALFWD I Yes ARCUS.SWBALFWD
40 CODETERM C(6) Yes ARCUS.CODETERM

41 IDRATETYPE C(2) Yes ARCUS.IDRATETYPE

42 CODETAXGRP C(12) Yes ARCUS.CODETAXGRP

43 IDTAXREGI1 C(20) Yes ARCUS.IDTAXREGI1
44 IDTAXREGI2 C(20) Yes ARCUS.IDTAXREGI2

45 IDTAXREGI3 C(20) Yes ARCUS.IDTAXREGI3

46 IDTAXREGI4 C(20) Yes ARCUS.IDTAXREGI4

47 IDTAXREGI5 C(20) Yes ARCUS.IDTAXREGI5
48 TAXSTTS1 I Yes ARCUS.TAXSTTS1

49 TAXSTTS2 I Yes ARCUS.TAXSTTS2

50 TAXSTTS3 I Yes ARCUS.TAXSTTS3

51 TAXSTTS4 I Yes ARCUS.TAXSTTS4

52 TAXSTTS5 I Yes ARCUS.TAXSTTS5
53 AMTCRLIMT Y Yes ARCUS.AMTCRLIMT

54 AMTBALDUET Y Yes ARCUS.AMTBALDUET

55 AMTBALDUEH Y Yes ARCUS.AMTBALDUEH

56 DATELASTST N(11,0) Yes ARCUS.DATELASTST
57 AMTLASTSTT Y Yes ARCUS.AMTLASTSTT


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

Structure for view: RV_ARCUS (Remote)

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

Connection Name/#: C_DeFediSDATA (1)
Parameters:

Source Name: RV_ARCUS

Tables: ARCUS
======================================================================================================================

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 * FROM ARCUS



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

F# FieldName Struct Upd UpdateName


58 AMTLASTSTH Y Yes ARCUS.AMTLASTSTH
59 DTBEGBALFW N(11,0) Yes ARCUS.DTBEGBALFW

60 AMTBALFWDT Y Yes ARCUS.AMTBALFWDT

61 AMTBALFWDH Y Yes ARCUS.AMTBALFWDH

62 DTLASTRVAL N(11,0) Yes ARCUS.DTLASTRVAL
63 AMTBALLARV Y Yes ARCUS.AMTBALLARV

64 CNTOPENINV N(9,0) Yes ARCUS.CNTOPENINV

65 CNTINVPAID N(9,0) Yes ARCUS.CNTINVPAID

66 DAYSTOPAY N(9,0) Yes ARCUS.DAYSTOPAY
67 DATEINVCHI N(11,0) Yes ARCUS.DATEINVCHI

68 DATEBALHI N(11,0) Yes ARCUS.DATEBALHI

69 DATEINVHIL N(11,0) Yes ARCUS.DATEINVHIL

70 DATEBALHIL N(11,0) Yes ARCUS.DATEBALHIL

71 DATELASTAC N(11,0) Yes ARCUS.DATELASTAC
72 DATELASTIV N(11,0) Yes ARCUS.DATELASTIV

73 DATELASTCR N(11,0) Yes ARCUS.DATELASTCR

74 DATELASTDR N(11,0) Yes ARCUS.DATELASTDR

75 DATELASTPA N(11,0) Yes ARCUS.DATELASTPA
76 DATELASTDI N(11,0) Yes ARCUS.DATELASTDI


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

Structure for view: RV_ARCUS (Remote)

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

Connection Name/#: C_DeFediSDATA (1)
Parameters:

Source Name: RV_ARCUS

Tables: ARCUS
======================================================================================================================

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 * FROM ARCUS



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

F# FieldName Struct Upd UpdateName


77 DATELASTAD N(11,0) Yes ARCUS.DATELASTAD
78 DATELASTWR N(11,0) Yes ARCUS.DATELASTWR

79 DATELASTRI N(11,0) Yes ARCUS.DATELASTRI

80 DATELASTIN N(11,0) Yes ARCUS.DATELASTIN

81 DATELASTDQ N(11,0) Yes ARCUS.DATELASTDQ
82 IDINVCHI C(22) Yes ARCUS.IDINVCHI

83 IDINVCHILY C(22) Yes ARCUS.IDINVCHILY

84 AMTINVHIT Y Yes ARCUS.AMTINVHIT

85 AMTBALHIT Y Yes ARCUS.AMTBALHIT
86 AMTINVHILT Y Yes ARCUS.AMTINVHILT

87 AMTBALHILT Y Yes ARCUS.AMTBALHILT

88 AMTLASTIVT Y Yes ARCUS.AMTLASTIVT

89 AMTLASTCRT Y Yes ARCUS.AMTLASTCRT

90 AMTLASTDRT Y Yes ARCUS.AMTLASTDRT
91 AMTLASTPYT Y Yes ARCUS.AMTLASTPYT

92 AMTLASTDIT Y Yes ARCUS.AMTLASTDIT

93 AMTLASTADT Y Yes ARCUS.AMTLASTADT

94 AMTLASTWRT Y Yes ARCUS.AMTLASTWRT
95 AMTLASTRIT Y Yes ARCUS.AMTLASTRIT


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

Structure for view: RV_ARCUS (Remote)

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

Connection Name/#: C_DeFediSDATA (1)
Parameters:

Source Name: RV_ARCUS

Tables: ARCUS
======================================================================================================================

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 * FROM ARCUS



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

F# FieldName Struct Upd UpdateName


96 AMTLASTINT Y Yes ARCUS.AMTLASTINT
97 AMTINVHIH Y Yes ARCUS.AMTINVHIH

98 AMTBALHIH Y Yes ARCUS.AMTBALHIH

99 AMTINVHILH Y Yes ARCUS.AMTINVHILH

100 AMTBALHILH Y Yes ARCUS.AMTBALHILH
101 AMTLASTIVH Y Yes ARCUS.AMTLASTIVH

102 AMTLASTCRH Y Yes ARCUS.AMTLASTCRH

103 AMTLASTDRH Y Yes ARCUS.AMTLASTDRH

104 AMTLASTPYH Y Yes ARCUS.AMTLASTPYH
105 AMTLASTDIH Y Yes ARCUS.AMTLASTDIH

106 AMTLASTADH Y Yes ARCUS.AMTLASTADH

107 AMTLASTWRH Y Yes ARCUS.AMTLASTWRH

108 AMTLASTRIH Y Yes ARCUS.AMTLASTRIH

109 AMTLASTINH Y Yes ARCUS.AMTLASTINH
110 CODESLSP1 C(8) Yes ARCUS.CODESLSP1

111 CODESLSP2 C(8) Yes ARCUS.CODESLSP2

112 CODESLSP3 C(8) Yes ARCUS.CODESLSP3

113 CODESLSP4 C(8) Yes ARCUS.CODESLSP4
114 CODESLSP5 C(8) Yes ARCUS.CODESLSP5


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

Structure for view: RV_ARCUS (Remote)

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

Connection Name/#: C_DeFediSDATA (1)
Parameters:

Source Name: RV_ARCUS

Tables: ARCUS
======================================================================================================================

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 * FROM ARCUS



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

F# FieldName Struct Upd UpdateName


115 PCTSASPLT1 Y Yes ARCUS.PCTSASPLT1
116 PCTSASPLT2 Y Yes ARCUS.PCTSASPLT2

117 PCTSASPLT3 Y Yes ARCUS.PCTSASPLT3

118 PCTSASPLT4 Y Yes ARCUS.PCTSASPLT4

119 PCTSASPLT5 Y Yes ARCUS.PCTSASPLT5
120 PRICLIST C(6) Yes ARCUS.PRICLIST

121 CUSTTYPE I Yes ARCUS.CUSTTYPE

122 AMTPDUE Y Yes ARCUS.AMTPDUE

123 EMAIL1 C(50) Yes ARCUS.EMAIL1
124 EMAIL2 C(50) Yes ARCUS.EMAIL2

125 WEBSITE C(100) Yes ARCUS.WEBSITE

126 BILLMETHOD I Yes ARCUS.BILLMETHOD

127 CCNUMBER C(30) Yes ARCUS.CCNUMBER

128 CCEXP N(11,0) Yes ARCUS.CCEXP
129 CCNAME C(50) Yes ARCUS.CCNAME

130 CODPAYMTYP C(6) Yes ARCUS.CODPAYMTYP

131 FOB C(60) Yes ARCUS.FOB

132 SHPVIACODE C(6) Yes ARCUS.SHPVIACODE
133 SHPVIADESC C(60) Yes ARCUS.SHPVIADESC


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

Structure for view: RV_ARCUS (Remote)

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

Connection Name/#: C_DeFediSDATA (1)
Parameters:

Source Name: RV_ARCUS

Tables: ARCUS
======================================================================================================================

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 * FROM ARCUS



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

F# FieldName Struct Upd UpdateName


134 DELMETHOD I Yes ARCUS.DELMETHOD
135 PRIMSHIPTO C(6) Yes ARCUS.PRIMSHIPTO

136 CTACPHONE C(30) Yes ARCUS.CTACPHONE

137 CTACFAX C(30) Yes ARCUS.CTACFAX

138 SWPARTSHIP I Yes ARCUS.SWPARTSHIP
139 SWWEBSHOP I Yes ARCUS.SWWEBSHOP

140 RTGPERCENT Y Yes ARCUS.RTGPERCENT

141 RTGDAYS I Yes ARCUS.RTGDAYS

142 RTGTERMS C(6) Yes ARCUS.RTGTERMS
143 RTGAMTTC Y Yes ARCUS.RTGAMTTC

144 RTGAMTHC Y Yes ARCUS.RTGAMTHC

145 VALUES I Yes ARCUS.VALUES

146 CNTPPDINVC N(9,0) Yes ARCUS.CNTPPDINVC

147 AMTPPDINVT Y Yes ARCUS.AMTPPDINVT
148 AMTPPDINVH Y Yes ARCUS.AMTPPDINVH

LS 3.1 - John Koziol (5/9/2001)
==============================================================================================
================================================================================================
Structure for view: RV_ICPRIC (Remote)
View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
Connection Name/#: C_DeFediSDATA (3)
Parameters:
Source Name: RV_ICPRIC
Tables: ICPRIC
======================================================================================================================

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 * FROM ICPRIC



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

F# FieldName Struct Upd UpdateName


1 CURRENCY C(3) Yes ICPRIC.CURRENCY
2 ITEMNO C(24) Yes ICPRIC.ITEMNO

3 PRICELIST C(6) Yes ICPRIC.PRICELIST

4 AUDTDATE N(11,0) Yes ICPRIC.AUDTDATE

5 AUDTTIME N(11,0) Yes ICPRIC.AUDTTIME
6 AUDTUSER C(8) Yes ICPRIC.AUDTUSER

7 AUDTORG C(6) Yes ICPRIC.AUDTORG

8 DESC C(60) Yes ICPRIC.DESC

9 PRICEDECS I Yes ICPRIC.PRICEDECS
10 BASEPRICE Y Yes ICPRIC.BASEPRICE

11 BASEUNIT C(10) Yes ICPRIC.BASEUNIT

12 BASECONV Y Yes ICPRIC.BASECONV

13 SALEPRICE Y Yes ICPRIC.SALEPRICE

14 SALEUNIT C(10) Yes ICPRIC.SALEUNIT
15 SALECONV Y Yes ICPRIC.SALECONV

16 SALESTART N(11,0) Yes ICPRIC.SALESTART

17 SALEEND N(11,0) Yes ICPRIC.SALEEND

18 MARKUPCOST Y Yes ICPRIC.MARKUPCOST
19 MARKUPUNIT C(10) Yes ICPRIC.MARKUPUNIT


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

Structure for view: RV_ICPRIC (Remote)

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

Connection Name/#: C_DeFediSDATA (3)
Parameters:

Source Name: RV_ICPRIC

Tables: ICPRIC
======================================================================================================================

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 * FROM ICPRIC



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

F# FieldName Struct Upd UpdateName


20 MARKUPCONV Y Yes ICPRIC.MARKUPCONV
21 PRICETYPE I Yes ICPRIC.PRICETYPE

22 PRICEFMT I Yes ICPRIC.PRICEFMT

23 PRCNTLVL1 Y Yes ICPRIC.PRCNTLVL1

24 PRCNTLVL2 Y Yes ICPRIC.PRCNTLVL2
25 PRCNTLVL3 Y Yes ICPRIC.PRCNTLVL3

26 PRCNTLVL4 Y Yes ICPRIC.PRCNTLVL4

27 PRCNTLVL5 Y Yes ICPRIC.PRCNTLVL5

28 PRICEBASE I Yes ICPRIC.PRICEBASE
29 PRICEQTY1 Y Yes ICPRIC.PRICEQTY1

30 PRICEQTY2 Y Yes ICPRIC.PRICEQTY2

31 PRICEQTY3 Y Yes ICPRIC.PRICEQTY3

32 PRICEQTY4 Y Yes ICPRIC.PRICEQTY4

33 PRICEQTY5 Y Yes ICPRIC.PRICEQTY5
34 MARKUP Y Yes ICPRIC.MARKUP

35 LASTPRICDT N(11,0) Yes ICPRIC.LASTPRICDT

36 PREVPRICE Y Yes ICPRIC.PREVPRICE

37 LASTMKPDT N(11,0) Yes ICPRIC.LASTMKPDT
38 PREVMKPCST Y Yes ICPRIC.PREVMKPCST


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

Structure for view: RV_ICPRIC (Remote)

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

Connection Name/#: C_DeFediSDATA (3)
Parameters:

Source Name: RV_ICPRIC

Tables: ICPRIC
======================================================================================================================

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 * FROM ICPRIC



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

F# FieldName Struct Upd UpdateName


39 LASTEXCHDT N(11,0) Yes ICPRIC.LASTEXCHDT
40 PREVEXCHRT Y Yes ICPRIC.PREVEXCHRT

41 ROUNDMETHD I Yes ICPRIC.ROUNDMETHD

42 ROUNDAMT Y Yes ICPRIC.ROUNDAMT

43 AMOUNTLVL1 Y Yes ICPRIC.AMOUNTLVL1
44 AMOUNTLVL2 Y Yes ICPRIC.AMOUNTLVL2

45 AMOUNTLVL3 Y Yes ICPRIC.AMOUNTLVL3

46 AMOUNTLVL4 Y Yes ICPRIC.AMOUNTLVL4

47 AMOUNTLVL5 Y Yes ICPRIC.AMOUNTLVL5



















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