| Name |
Type |
Length |
Decimal |
Relation |
Description |
| COMMRATE1 |
Decimal |
10 |
0 |
|
AR COMMRATE1 |
| NUMBER |
String |
10 |
|
|
AR CUSTOMER MASTER NUMBER - Customer number |
| NAME |
String |
40 |
|
|
AR CUST MAST NAME - Name |
| ADDRESS1 |
String |
40 |
|
|
AR CUSTOMER MASTER ADDRESS1 - Customer address line 1 |
| ADDRESS2 |
String |
40 |
|
|
AR CUSTOMER MASTER ADDRESS2 - Customer address line 2 |
| CITY |
String |
20 |
|
|
AR CUSTOMER MASTER CITY - City |
| STATE |
String |
2 |
|
|
AR CUSTOMER MASTER STATE - State |
| ZIP |
String |
10 |
|
|
AR CUSTOMER MASTER ZIP - Zip code |
| COUNTRY |
String |
30 |
|
|
AR CUSTOMER MASTER COUNTRY - Country |
| USERID |
String |
4 |
|
|
AR CUST MAST USERID - Userid |
| PHONE |
String |
15 |
|
|
AR CUSTOMER MASTER PHONE - Phone number |
| EXT |
String |
5 |
|
|
AR CUSTOMER MASTER EXT - Extension number |
| FAX |
String |
20 |
|
|
AR CUSTOMER MASTER FAX - Fax number |
| PHONE2 |
String |
15 |
|
|
AR CUSTOMER MASTER PHONE2 - Alternate phone number |
| EXT2 |
String |
5 |
|
|
AR CUSTOMER MASTER EXT2 - Alternate extension number
|
| EMAIL |
String |
4 |
|
|
AR CUSTOMER MASTER EMAIL - E-mail address |
| CONCODE |
String |
5 |
|
|
AR CUST MAST CONCODE - Concode |
| CONTACT |
String |
30 |
|
|
AR CUSTOMER MASTER CONTACT - Customer Contact |
| SALUTATION |
String |
15 |
|
|
AR CUST MAST SALUTATIO - Salutation |
| TITLE |
String |
20 |
|
|
AR CUSTOMER MASTER TITLE - Contact title |
| DIVISION |
String |
3 |
|
|
AR CUSTOMER MASTER DIVISION - Divison code |
| CUSTYPE |
String |
10 |
|
|
AR CUSTOMER MASTER CUSTYPE - Customer type |
| SLPCODE |
String |
5 |
|
|
AR CUSTOMER MASTER SLPCODE - Salesperson code |
| STMCYCLE |
String |
1 |
|
|
AR CUST MAST STMCYCLE - Stmcycle |
| OPENITEM |
String |
1 |
|
|
AR CUST MAST OPENITEM - Openitem |
| TAXEXEMPT |
String |
15 |
|
|
AR CUST MAST TAXEXEMPT - Taxexempt |
| DEFSALES |
String |
12 |
|
|
AR CUST MAST DEFSALES - Defsales |
| DEFAR |
String |
12 |
|
|
AR CUST MAST DEFAR - Defar |
| DEFFREIGHT |
String |
12 |
|
|
AR CUST MAST DEFFREIGH - Deffreight |
| DEFMISC |
String |
12 |
|
|
AR CUST MAST DEFMISC - Defmisc |
| DEFSTAXPAY |
String |
12 |
|
|
AR CUST MAST DEFSTAXPA - Defstaxpay |
| DEFFINANCE |
String |
12 |
|
|
AR CUST MAST DEFFINANC - Deffinance |
| DEFDISC |
String |
12 |
|
|
AR CUST MAST DEFDISC - Defdisc |
| DEFDEPOSIT |
String |
12 |
|
|
AR CUST MAST DEFDEPOSI - Defdeposit |
| TCODE_1 |
String |
3 |
|
|
AR CUST MAST TCODE_1 - Tcode_1 |
| TCODE_2 |
String |
3 |
|
|
AR CUST MAST TCODE_2 - Tcode_2 |
| TCODE_3 |
String |
3 |
|
|
AR CUST MAST TCODE_3 - Tcode_3 |
| TERMCODE |
String |
2 |
|
|
AR CUST MAST TERMCODE - Termcode |
| CURCODE |
String |
3 |
|
|
AR CUST MAST CURCODE - Curcode |
| PRCLEVEL |
String |
1 |
|
|
AR CUST MAST PRCLEVEL - Prclevel |
| CREDCARD1 |
String |
4 |
|
|
AR CUST MAST CREDCARD1 - Credcard1 |
| CREDCARD2 |
String |
4 |
|
|
AR CUST MAST CREDCARD2 - Credcard2 |
| CREDNUM1 |
String |
22 |
|
|
AR CUST MAST CREDNUM1 - Crednum1 |
| CREDNUM2 |
String |
22 |
|
|
AR CUST MAST CREDNUM2 - Crednum2 |
| CREDDATE1 |
String |
8 |
|
|
AR CUST MAST CREDDATE1 - Creddate1 |
| CREDDATE2 |
String |
8 |
|
|
AR CUST MAST CREDDATE2 - Creddate2 |
| CRED1LINE1 |
String |
30 |
|
|
AR CUST MAST CRED1LINE - Cred1line1 |
| CRED2LINE1 |
String |
30 |
|
|
AR CUST MAST CRED2LINE - Cred2line1 |
| CRED1LINE2 |
String |
30 |
|
|
AR CUST MAST CRED1LINE - Cred1line2 |
| CRED2LINE2 |
String |
30 |
|
|
AR CUST MAST CRED2LINE - Cred2line2 |
| CICCODE |
String |
7 |
|
|
AR CUSTOMER MASTER CICCODE - Customer industry code |
| STARTDATE |
DateTime |
8 |
|
|
AR CUST MAST STARTDATE - Startdate |
| CALLBACK |
DateTime |
8 |
|
|
AR CUST MAST CALLBACK - Callback |
| LPAYDATE |
DateTime |
8 |
|
|
AR CUST MAST LPAYDATE - Lpaydate |
| LINVDATE |
DateTime |
8 |
|
|
AR CUST MAST LINVDATE - Linvdate |
| COMMENT |
String |
4 |
|
|
AR CUSTOMER MASTER COMMENT - Notes |
| CRLIMIT |
Decimal |
13 |
2 |
|
AR CUST MAST CRLIMIT - Crlimit |
| CRLIMITDAY |
Decimal |
3 |
0 |
|
AR CUST MAST CRLIMITDA - Crlimitday |
| DISCPERC |
Decimal |
6 |
2 |
|
AR CUST MAST DISCPERC - Discperc |
| FINPERC |
Decimal |
6 |
2 |
|
AR CUST MAST FINPERC - Finperc |
| TAXRATE |
Decimal |
6 |
2 |
|
AR CUST MAST TAXRATE - Taxrate |
| NOINVYTD |
Decimal |
8 |
0 |
|
AR CUST MAST NOINVYTD - Noinvytd |
| ISINACTIVE |
Boolean |
1 |
|
|
AR CUST MAST ISINACTIV - Isinactive |
| AREACODE |
String |
10 |
|
|
AR CUSTOMER MASTER AREACODE - Area Code |
| AREAFAX |
String |
10 |
|
|
AR CUSTOMER MASTER AREAFAX - Area code for the fax |
| AREAALT |
String |
10 |
|
|
AR CUSTOMER MASTER AREAALT - Alternate phone number area code |
| SHIPTOCODE |
String |
5 |
|
|
AR CUST MAST SHIPTOCOD - Shiptocode |
| SHIPTOCORR |
String |
5 |
|
|
AR CUST MAST SHIPTOCOR - Shiptocorr |
| EXEMPTTAX |
Boolean |
1 |
|
|
AR CUST MAST EXEMPTTAX - Exempttax |
| SALESCAT |
String |
3 |
|
|
AR SALESCAT |
| STMTCONT |
String |
30 |
|
|
AR STMTCONT |
| EMAILPRT |
Boolean |
1 |
|
|
AR EMAILPRT |
| FAXPRT |
Boolean |
1 |
|
|
AR FAXPRT |
| STMTNOTES |
String |
4 |
|
|
AR STMTNOTES |
| CREDITHOLD |
Boolean |
1 |
|
|
AR CREDITHOLD |
| TPCODE01 |
String |
5 |
|
|
AR TPCODE01 |
| TPVEND01 |
String |
15 |
|
|
AR TPVEND01 |
| TPNETID01 |
String |
15 |
|
|
AR TPNETID01 |
| TP85001 |
Boolean |
1 |
|
|
AR TP85001 |
| TP81001 |
Boolean |
1 |
|
|
AR TP81001 |
| TP82001 |
Boolean |
1 |
|
|
AR TP82001 |
| TP85601 |
Boolean |
1 |
|
|
AR TP85601 |
| TP83201 |
Boolean |
1 |
|
|
AR TP83201 |
| LBL_NAME |
String |
20 |
|
|
AR LBL_NAME |
| RESIDENCE |
Boolean |
1 |
|
|
AR RESIDENCE |
| SOURCE |
String |
4 |
|
|
AR SOURCE |
| AGGINVOICE |
Boolean |
1 |
|
|
AR AGGINVOICE |
| HIGHAR |
Decimal |
12 |
2 |
|
AR HIGHAR |
| COMMRATE |
Decimal |
5 |
2 |
|
AR COMMRATE |
| REPCODE |
String |
5 |
|
|
AR REPCODE |
| SHIPVIA |
String |
15 |
|
|
AR SHIPVIA |
| ORDERNOTES |
String |
4 |
|
|
AR ORDERNOTES |
| TRANSNOTES |
Boolean |
1 |
|
|
AR TRANSNOTES |
| HANDFEE |
Decimal |
5 |
1 |
|
AR HANDFEE |
| RESTOCKFEE |
Decimal |
5 |
1 |
|
AR RESTOCKFEE |
| FREEFRTMIN |
Decimal |
10 |
2 |
|
AR FREEFRTMIN |
| BACKORDERS |
Boolean |
1 |
|
|
AR BACKORDERS |
| HANDMETHOD |
Int32 |
4 |
|
|
AR HANDMETHOD |
| RSTKMETHOD |
Int32 |
4 |
|
|
AR RSTKMETHOD |
| FFRTMETHOD |
Int32 |
4 |
|
|
AR FFRTMETHOD |
| NOBACKORD |
Boolean |
1 |
|
|
AR NOBACKORD |
| CUSTREP |
String |
4 |
|
|
AR CUSTREP |
| TAXZONE |
String |
9 |
|
|
AR TAXZONE |
| PAYCODE |
String |
5 |
|
|
AR PAYCODE |
| STMTINV |
Boolean |
1 |
|
|
AR STMTINV |
| ROYMETHOD |
String |
1 |
|
|
AR ROYMETHOD |
| SENDINV |
Boolean |
1 |
|
|
AR SENDINV |