| CLASSID |
char(15)
''
|
The class ...(more) Join Now
|
|
|
|
| CLASDSCR |
char(31)
''
|
A 30 chara...(more) Join Now
|
|
|
|
| CRLMTTYP |
smallint
0
|
Credit Lim...(more) Join Now
|
|
|
|
| CRLMTAMT |
numeric(19,5)
0.00
|
Credit Lim...(more) Join Now
|
|
|
|
| CRLMTPER |
smallint
0
|
Credit Lim...(more) Join Now
|
|
|
|
| CRLMTPAM |
numeric(19,5)
0.00
|
Credit Lim...(more) Join Now
|
|
|
|
| DEFLTCLS |
tinyint
0
|
Default Cl...(more) Join Now
|
|
|
|
| BALNCTYP |
smallint
0
|
Balance Ty...(more) Join Now
|
|
|
|
| CHEKBKID |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
join ... more text available
|
| BANKNAME |
char(31)
''
|
Bank Name:...(more) Join Now
|
|
|
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
|
|
join ... more text available
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
|
|
SY033... more text available
|
| CUSTDISC |
smallint
0
|
Customer D...(more) Join Now
|
|
|
|
| CSTPRLVL |
char(11)
''
|
|
|
|
|
| MINPYTYP |
smallint
0
|
Minimum Pa...(more) Join Now
|
|
|
|
| MINPYDLR |
numeric(19,5)
0.00
|
Minimum Pa...(more) Join Now
|
|
|
|
| MINPYPCT |
smallint
0
|
Minimum Pa...(more) Join Now
|
|
|
|
| MXWOFTYP |
smallint
0
|
Maximum Wr...(more) Join Now
|
|
|
|
| MXWROFAM |
numeric(19,5)
0.00
|
Max Writeo...(more) Join Now
|
|
|
|
| FINCHARG |
tinyint
0
|
|
|
|
|
| FNCHATYP |
smallint
0
|
Finance Ch...(more) Join Now
|
|
|
|
| FINCHDLR |
numeric(19,5)
0.00
|
Finance Ch...(more) Join Now
|
|
|
|
| FNCHPCNT |
smallint
0
|
Finance Ch...(more) Join Now
|
|
|
|
| PRCLEVEL |
char(11)
''
|
Price Leve...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
A valid Ra...(more) Join Now
|
|
|
|
| DEFCACTY |
smallint
0
|
Default Ca...(more) Join Now
|
|
|
|
| RMCSHACC |
int
0
|
RM Cash Ac...(more) Join Now
|
|
|
|
| RMARACC |
int
0
|
RM AR Acco...(more) Join Now
|
|
|
|
| RMCOSACC |
int
0
|
RM Cost of...(more) Join Now
|
|
|
|
| RMIVACC |
int
0
|
RM IV Acco...(more) Join Now
|
|
|
|
| RMSLSACC |
int
0
|
RM Sales A...(more) Join Now
|
|
|
|
| RMAVACC |
int
0
|
RM Discoun...(more) Join Now
|
|
|
|
| RMTAKACC |
int
0
|
RM Discoun...(more) Join Now
|
|
|
|
| RMFCGACC |
int
0
|
RM Finance...(more) Join Now
|
|
|
|
| RMWRACC |
int
0
|
RM Writeof...(more) Join Now
|
|
|
|
| RMSORACC |
int
0
|
RM Sales O...(more) Join Now
|
|
|
|
| SALSTERR |
char(15)
''
|
Territory ...(more) Join Now
|
|
|
join ... more text available
|
| SLPRSNID |
char(15)
''
|
The salesp...(more) Join Now
|
|
|
join ... more text available
|
| STMTCYCL |
smallint
0
|
Statement ...(more) Join Now
|
|
|
|
| SNDSTMNT |
tinyint
0
|
Flag to in...(more) Join Now
|
|
|
|
| INACTIVE |
tinyint
0
|
1 if inact...(more) Join Now
|
|
|
|
| KPCALHST |
tinyint
0
|
1 to keep ...(more) Join Now
|
|
|
|
| KPDSTHST |
tinyint
0
|
Keep Distr...(more) Join Now
|
|
|
|
| KPERHIST |
tinyint
0
|
1 to keep ...(more) Join Now
|
|
|
|
| KPTRXHST |
tinyint
0
|
Keep Trx H...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| CREATDDT |
datetime
'1/1/1900'
|
Date this ...(more) Join Now
|
|
|
|
| Revalue_Customer |
tinyint
0
|
Revalue Cu...(more) Join Now
|
|
|
|
| Post_Results_To |
smallint
0
|
Post Resul...(more) Join Now
|
|
|
|
| DISGRPER |
smallint
0
|
Discount G...(more) Join Now
|
|
|
|
| DUEGRPER |
smallint
0
|
Due Date G...(more) Join Now
|
|
|
|
| ORDERFULFILLDEFAULT |
smallint
0
|
Order Fulf...(more) Join Now
|
|
|
|
| CUSTPRIORITY |
smallint
0
|
Customer P...(more) Join Now
|
|
|
|
| RMOvrpymtWrtoffAcctIdx |
int
0
|
RM Overpay...(more) Join Now
|
|
|
|
| CBVAT |
tinyint
0
|
Cash Based...(more) Join Now
|
|
|
|
| INCLUDEINDP |
tinyint
0
|
Include in...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|