Field Name

Description

Type

Length

cuIdxAcCode

Account Code

String

10

idxAcCode

Account Code

String

6

idxAcType

C

String

1

cuType

C

String

1

cuCompany

Company Name

Lstring

46

cuIdxCompany

Company Name

String

45

cuArea

Area Code

Lstring

5

cuAccType

Customer Type

Lstring

5

cuStateTo

Statement to

String

6

cuVATRegNo

VAT Reg No

Lstring

31

cuIdxVATRegNo

VAT Reg No

String

5

cuAddr1

Address Line 1

Lstring

31

cuAddr2

Address Line 2

Lstring

31

cuAddr3

Address Line 3

Lstring

31

cuAddr4

Address Line 4

Lstring

31

cuAddr5

Address Line 5

Lstring

31

cuDespAddr

Delivery Address Y/N

Logical

1

cuDelAddr1

Delivery Address Line 1

Lstring

31

cuDelAddr2

Delivery Address Line 2

Lstring

31

cuDelAddr3

Delivery Address Line 3

Lstring

31

cuDelAddr4

Delivery Address Line 4

Lstring

31

cuDelAddr5

Delivery Address Line 5

Lstring

31

cuContact

Contact Name

Lstring

26

cuPhone

Telephone Number

Lstring

31

cuIdxPhone

Telephone Number

String

30

cuFax

Fax Number

Lstring

31

cuTheirAcc

Their Account for Us

Lstring

11

cuIdxTheirAcc

Their Account for Us

String

10

cuOwnTerms

Trading Terms Y/N

Logical

1

cuTradeTerm1

Trading Terms Line 1

Lstring

81

cuTradeTerm2

Trading Terms Line 2

Lstring

81

cuCurrency

Customer Currency

Integer

1

cuVATCode

Vat Rate

String

1

cuPayTerms

Payment Terms

Integer

2

cuCredLim

Credit Limit

float

15

cuDiscount

Discount

float

15

cuCreditStatus

Credit Status Weeks

Integer

2

cuCostCentre

Cost Centre

String

3

cuDiscBand

Discount Band

String

1

cuSettleDays

Settlement Discount Days

integer

2

cuDepartment

Department

String

3

cuInEC

EC Member

Logical

1

cuStatement

Print Statements

Logical

1

cuSalesGL

Sales GL Code

Integer

4

cuLocation

Default Stock Location

String

3

cuAccStatus

0 = Open

1 = Notes

2 = On Hold

3 = Closed

Account Status

Integer

1

cuPayType

Pay Type

String

1

cuBankSort

Bank Sort Code

Lstring

16

cuBankAccount

Bank Account Number

Lstring

21

cuBankRef

Bank Reference

Lstring

29

cuMobile

Telephone Number 2

Lstring

31

cuCOSGL

Cost of Sales GL Code

Integer

4

cuDebtGL

Control GL Code

Integer

4

cuLastUpdate

Last Used Date

date

8

cuUser1

User Defined Field 1

Lstring

31

cuUser2

User Defined Field 2

Lstring

31

cuIdxInvoiceTo

Invoice To Account

String

10

cuInvoiceTo

Invoice To Account

String

6

cuAutoWOff

Auto Write Off

Logical

1

cuFormSet

Form Set number

Integer

1

cuBookOrderVal

Float

8

cuDirDebMode

Integer

1

cuCreditCardStart

Credit Card Start

Lstring

9

cuCreditCardEnd

Credit Card Expiry

Lstring

9

cuCreditCardName

Credit Card Name

Lstring

51

cuCreditCardNo

Credit Card Number

Lstring

31

cuCreditCardRef

Credit Card Switch Reference

Lstring

5

cuIdxPostCode

Post Code

String

20

cuIdxAltCode

Alternative Customer Code

String

20

cuUser3

User Defined Field 3

Lstring

31

cuUser4

User Defined Field 4

Lstring

31

cuWebCatalogs

Web Catalogue

Lstring

21

cuTimeChange

Lstring

7

cuIdxEmailAddr

Email Address

String

100

cuHeadOffice

Integer

1

cuDefaultTagNo

Default Tag No

Integer

1

cuSpare

Future Use

String

109

cuSpare2

Future Use

String

255

cuSpare3

Future Use

String

255

cuSpare4

Future Use

String

90