CLASSID

string

15

Y

Not applicable

Class ID

CLASDSCR

string

30

N

<blank>

Class description

CRLMTTYP

i4

2

N

0

Credit limit type:

0=No credit;

1=Unlimited;

2=Amount

CRLMTAMT

number

21

N

0

Credit amount

CRLMTPER

i4

2

N

0

Credit limit period

CRLMTPAM

number

21

N

0

Credit limit period amount

DEFLTCLS

i4

1

N

0

Default class

BALNCTYP

i4

2

N

0

Balance type:

0=Open item;

1=Balance forward

CHEKBKID

string

15

N

<blank>

Checkbook ID

TAXSCHID

string

15

N

<blank>

Tax schedule ID

SHIPMTHD

string

15

N

<blank>

Shipping method

PYMTRMID

string

20

N

<blank>

Payment term ID

CUSTDISC

i4

2

N

0

Customer discount/trade discount

MINPYTYP

i4

2

N

0

Minimum payment type:

0=No minimum;

1=Percent;

2=Amount

MINPYDLR

number

21

N

0

Minimum payment dollar

MINPYPCT

i4

2

N

0

Minimum payment percent

MXWOFTYP

i4

2

N

0

Maximum write-off type:

0=Not allowed;

1=Unlimited;

2=Maximum

MXWROFAM

number

21

N

0

Maximum write-off amount

FNCHATYP

i4

2

N

0

Finance charge amount type:

0=None;

1=Percent;

2=Amount

FINCHDLR

number

21

N

0

Finance charge dollar

FNCHPCNT

i4

2

N

0

Finance charge percent

PRCLEVEL

string

10

N

<blank>

Price level

CURNCYID

string

15

N

<blank>

Currency ID

RATETPID

string

15

N

<blank>

Rate ID

DEFCACTY

i4

2

N

0

Cash account from:

0=Checkbook;

1=Customer

CASHACCT

string

75

N

<blank>

Cash account

ACCTRECACCT

string

75

N

<blank>

Account Receivable account

SALESACCT

string

75

N

<blank>

Sales account

COSTOFSALESACCT

string

75

N

<blank>

Cost of sales account

IVACCT

string

75

N

<blank>

Inventory account

TERMDISCTAKENACCT

string

75

N

<blank>

Terms discount taken account

TERMDISCAVAILACCT

string

75

N

<blank>

Terms discount available account

FINCHRGACCT

string

75

N

<blank>

Finance charges account

WRITEOFFACCT

string

75

N

<blank>

Write-off account

SALESORDERRETACCT

string

75

N

<blank>

Sales order returns account

SALSTERR

string

15

N

<blank>

Sales territory

SLPRSNID

string

15

N

<blank>

Sales person ID

STMTCYCL

i4

2

N

5

Statement cycle:

1=No statement;

2=Weekly;

3=Biweekly;

4=Semimonthly;

5=Monthly;

6=Bimonthly;

7=Quarterly

KPCALHST

i4

1

N

1

Keep calendar history:

0=False;

1=True

KPDSTHST

i4

1

N

1

Keep distribution history:

0=False;

1=True

KPERHIST

i4

1

N

1

Keep period history:

0=False;

1=True

KPTRXHST

i4

1

N

1

Keep transaction history:

0=False;

1=True

DISGRPER

i4

2

N

0

Discount grace period

DUEGRPER

i4

2

N

0

Due date of grace period

Revalue_Customer

i4

1

N

1

Revalue customer:

0=False;

1=True

Post_Results_To

i4

2

N

0

Post results to: 0=Receivables/discount account 1=Sales offset account

ORDERFULFILLDEFAULT

i4

1

N

1

Order fulfillment shortage default:

1=None;

2=Back order remaining;

3=Cancel remaining

CUSTPRIORITY

i4

2

N

1

Customer priority; valid input values are 1 (none) to 100

RMOvrpymtWrtoffAcct

string

75

N

<blank>

RM overpayment write-off account

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates the requester shadow table)

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only