Field Name

Description

Type

Length

suIdxAcCode

Account Code

String

10

idxAcCode

Account Code

String

6

suType

S

String

1

idxAcType

S

String

1

suCompany

Company Name

Lstring

46

suIdxCompany

Company Name

String

45

suArea

Area Code

Lstring

5

suAccType

Account Type

Lstring

5

suStateTo

Statement to

String

6

suVatRegNo

VAT Reg No

Lstring

31

suIdxVATRegNo

VAT Reg No

String

5

suAddr1

Address Line 1

Lstring

31

suAddr2

Address Line 2

Lstring

31

suAddr3

Address Line 3

Lstring

31

suAddr4

Address Line 4

Lstring

31

suAddr5

Address Line 5

Lstring

31

suDespAddr

Delivery Address Y/N

Logical

1

suDelAddr1

Delivery Address Line 1

Lstring

31

suDelAddr2

Delivery Address Line 2

Lstring

31

suDelAddr3

Delivery Address Line 3

Lstring

31

suDelAddr4

Delivery Address Line 4

Lstring

31

suDelAddr5

Delivery Address Line 5

Lstring

31

suContact

Contact Name

Lstring

26

suPhone

Telephone Number

Lstring

31

suIdxPhone

Telephone Number

String

30

suFax

Fax Number

Lstring

31

suTheirAcc

Their Account for Us

Lstring

11

suIdxTheirAcc

Their Account for Us

String

10

suOwnTerms

Trading Terms Y/N

Logical

1

suTradeTerm1

Trading Terms Line 1

Lstring

81

suTradeTerm2

Trading Terms Line 2

Lstring

81

suCurrency

Customer Currency

Integer

1

suVATCode

Vat Rate

String

1

suPayTerms

Payment Terms

Integer

2

suCredLim

Credit Limit

Float

suDiscount

Discount

Float

suCreditStatus

Credit Status Weeks

Integer

2

suCostCentre

Cost Centre

String

3

suDiscBand

Discount Band

String

1

suSettleDays

Settlement Discount Days

Integer

2

suBalance

Float

suDepartment

Department

String

3

suInEC

EC Member

Logical

1

suStatement

Print Statements

Logical

1

suSalesGL

Sales GL Code

Integer

4

suLocation

Default Stock Location

String

3

suAccStatus

Account Status

Integer

1

suPayType

Pay Type

String

1

suBankSort

Bank Sort Code

Lstring

16

suBankAccount

Bank Account Number

Lstring

21

suBankRef

Bank Reference

Lstring

29

suMobile

Telephone Number 2

Lstring

31

suCOSGL

Cost of Sales GL Code

Integer

4

suCreditGL

Control GL Code

Integer

4

suLastUpdate

Last Used Date

Date

8

suUser1

User Defined Field 1

Lstring

31

suUser2

User Defined Field 2

Lstring

31

suIdxInvoiceTo

Invoice To Account

String

10

suInvoiceTo

Invoice To Account

String

6

suAutoWOff

Auto Write Off

Logical

1

suFormSet

Form Set number

Integer

1

suBookOrderVal

Float

8

suDirDebMode

Integer

1

suSettledDisc

Float

8

suIdxPostCode

Post Code

String

20

suIdxAltCode

Alternative Customer Code

String

20

suUser3

User Defined Field 3

Lstring

31

suUser4

User Defined Field 4

Lstring

31

suTimeChange

Lstring

7

suIdxEmailAddr

Email Address

String

100

suHeadOffice

Head Office

Integer

1

suDefaultTagNo

Default Tag Number

Integer

1

suSpare

Future Use

String

109

suSpare2

Future Use

String

255

suSpare3

Future Use

String

255

suSpare4

Future Use

String

90