| CUSTNMBR |
char(15)
''
|
Customer I...(more) Join Now
|
|
|
|
| CUSTNAME |
char(65)
''
|
Customer N...(more) Join Now
|
|
|
|
| CUSTCLAS |
char(15)
''
|
Customer C...(more) Join Now
|
|
|
|
| CPRCSTNM |
char(15)
''
|
Corporate ...(more) Join Now
|
|
|
|
| CNTCPRSN |
char(61)
''
|
Contact Pe...(more) Join Now
|
|
|
|
| STMTNAME |
char(65)
''
|
Statement ...(more) Join Now
|
|
|
|
| SHRTNAME |
char(15)
''
|
Short Name...(more) Join Now
|
|
|
|
| ADRSCODE |
char(15)
''
|
Address Co...(more) Join Now
|
|
|
|
| UPSZONE |
char(3)
''
|
UPS Zone: ...(more) Join Now
|
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
|
|
join ... more text available
|
| ADDRESS1 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Country: C...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
City: City...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
4 characte...(more) Join Now
|
|
|
|
| ZIP |
char(11)
''
|
|
|
|
|
| PHONE1 |
char(21)
''
|
10 digit p...(more) Join Now
|
|
|
|
| PHONE2 |
char(21)
''
|
Phone 2: ...(more) Join Now
|
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: ...(more) Join Now
|
|
|
|
| FAX |
char(21)
''
|
Fax: Same...(more) Join Now
|
|
|
|
| PRBTADCD |
char(15)
''
|
Primary Bi...(more) Join Now
|
|
|
join ... more text available
|
| PRSTADCD |
char(15)
''
|
Primary Sh...(more) Join Now
|
|
|
join ... more text available
|
| STADDRCD |
char(15)
''
|
Statement ...(more) Join Now
|
|
|
|
| SLPRSNID |
char(15)
''
|
The salesp...(more) Join Now
|
|
|
join ... more text available
|
| CHEKBKID |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
join ... more text available
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
|
|
SY033... more text available
|
| 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
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
Rate Type ...(more) Join Now
|
|
|
|
| CUSTDISC |
smallint
0
|
Customer D...(more) Join Now
|
|
|
|
| PRCLEVEL |
char(11)
''
|
Price Leve...(more) Join Now
|
|
|
|
| MINPYTYP |
smallint
0
|
Minimum
...(more) Join Now
|
|
|
|
| MINPYDLR |
numeric(19,5)
0.00
|
Minimum Pa...(more) Join Now
|
|
|
|
| MINPYPCT |
smallint
0
|
Minimum Pa...(more) Join Now
|
|
|
|
| FNCHATYP |
smallint
0
|
Finance Ch...(more) Join Now
|
|
|
|
| FNCHPCNT |
smallint
0
|
Finance Ch...(more) Join Now
|
|
|
|
| FINCHDLR |
numeric(19,5)
0.00
|
|
|
|
|
| MXWOFTYP |
smallint
0
|
Maximum Wr...(more) Join Now
|
|
|
|
| MXWROFAM |
numeric(19,5)
0.00
|
If MXWOFTY...(more) Join Now
|
|
|
|
| COMMENT1 |
char(31)
''
|
Comment 1:...(more) Join Now
|
|
|
|
| COMMENT2 |
char(31)
''
|
Comment 2:...(more) Join Now
|
|
|
|
| USERDEF1 |
char(21)
''
|
User Defin...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
User Defin...(more) Join Now
|
|
|
|
| TAXEXMT1 |
char(25)
''
|
Tax Exempt...(more) Join Now
|
|
|
|
| TAXEXMT2 |
char(25)
''
|
Tax Exempt...(more) Join Now
|
|
|
|
| TXRGNNUM |
char(25)
''
|
Tax Regist...(more) Join Now
|
|
|
|
| BALNCTYP |
smallint
0
|
Balance Ty...(more) Join Now
|
|
|
|
| STMTCYCL |
smallint
0
|
Statement ...(more) Join Now
|
|
|
|
| BANKNAME |
char(31)
''
|
Bank Name:...(more) Join Now
|
|
|
|
| BNKBRNCH |
char(21)
''
|
Bank Branc...(more) Join Now
|
|
|
|
| SALSTERR |
char(15)
''
|
Territory ...(more) Join Now
|
|
|
join ... more text available
|
| DEFCACTY |
smallint
0
|
Default Ca...(more) Join Now
|
|
|
|
| RMCSHACC |
int
0
|
RM Cash
...(more) Join Now
|
|
|
|
| RMARACC |
int
0
|
RM AR
Ac...(more) Join Now
|
|
|
|
| RMSLSACC |
int
0
|
RM Sales
...(more) Join Now
|
|
|
|
| RMIVACC |
int
0
|
RM IV Acco...(more) Join Now
|
|
|
|
| RMCOSACC |
int
0
|
RM Cost of...(more) Join Now
|
|
|
|
| RMTAKACC |
int
0
|
RM Discoun...(more) Join Now
|
|
|
|
| RMAVACC |
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
|
|
|
|
| FRSTINDT |
datetime
'1/1/1900'
|
The date o...(more) Join Now
|
|
|
|
| INACTIVE |
tinyint
0
|
1 if inact...(more) Join Now
|
|
|
|
| HOLD |
tinyint
0
|
Hold: 1 i...(more) Join Now
|
|
|
|
| CRCARDID |
char(15)
''
|
Credit Car...(more) Join Now
|
|
|
|
| CRCRDNUM |
char(21)
''
|
Credit Car...(more) Join Now
|
|
|
|
| CCRDXPDT |
datetime
'1/1/1900'
|
Credit Car...(more) Join Now
|
|
|
|
| KPDSTHST |
tinyint
0
|
Keep Distr...(more) Join Now
|
|
|
|
| KPCALHST |
tinyint
0
|
1 to keep ...(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
|
| CREATDDT |
datetime
'1/1/1900'
|
Date this ...(more) Join Now
|
|
|
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| Revalue_Customer |
tinyint
0
|
Revalue Cu...(more) Join Now
|
|
|
|
| Post_Results_To |
smallint
0
|
Post Resul...(more) Join Now
|
|
|
|
| FINCHID |
char(15)
''
|
Finance Ch...(more) Join Now
|
|
|
|
| GOVCRPID |
char(31)
''
|
Government...(more) Join Now
|
|
|
|
| GOVINDID |
char(31)
''
|
Government...(more) Join Now
|
|
|
|
| DISGRPER |
smallint
0
|
Discount G...(more) Join Now
|
|
|
|
| DUEGRPER |
smallint
0
|
Due Date G...(more) Join Now
|
|
|
|
| DOCFMTID |
char(15)
''
|
Document F...(more) Join Now
|
|
|
|
| Send_Email_Statements |
tinyint
0
|
Send Email...(more) Join Now
|
|
|
|
| USERLANG |
smallint
0
|
User Langu...(more) Join Now
|
|
|
|
| GPSFOINTEGRATIONID |
char(31)
''
|
GPSFO Inte...(more) Join Now
|
|
|
|
| INTEGRATIONSOURCE |
smallint
0
|
Integratio...(more) Join Now
|
|
|
|
| INTEGRATIONID |
char(31)
''
|
Integratio...(more) Join Now
|
|
|
|
| ORDERFULFILLDEFAULT |
smallint
0
|
Order Fulf...(more) Join Now
|
|
|
|
| CUSTPRIORITY |
smallint
0
|
Customer P...(more) Join Now
|
|
|
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
|
|
|
| DECLID |
char(15)
''
|
Declarant ...(more) Join Now
|
|
|
|
| RMOvrpymtWrtoffAcctIdx |
int
0
|
RM Overpay...(more) Join Now
|
|
|
|
| SHIPCOMPLETE |
tinyint
0
|
Ship Compl...(more) Join Now
|
|
|
|
| CBVAT |
tinyint
0
|
Cash Based...(more) Join Now
|
|
|
|
| INCLUDEINDP |
tinyint
0
|
Include in...(more) Join Now
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|