| RCRDTYPE |
smallint
|
Field Type...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| CUSTNAME |
char(65)
|
Field Type...(more) Join Now
|
|
|
|
| CUSTCLAS |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| CPRCSTNM |
char(15)
|
Corporate ...(more) Join Now
|
RM00101.CPRCSTNM
|
|
|
| CNTCPRSN |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| STMTNAME |
char(65)
|
Statement ...(more) Join Now
|
RM00101.STMTNAME
|
|
|
| SHRTNAME |
char(15)
|
Short Name...(more) Join Now
|
RM00101.SHRTNAME
|
|
|
| ADRSCODE |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| TAXSCHID |
char(15)
|
|
|
|
join ... more text available
|
| ADDRESS1 |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| CITY |
char(35)
|
Field Type...(more) Join Now
|
|
|
|
| STATE |
char(29)
|
Field Type...(more) Join Now
|
|
|
|
| ZIP |
char(11)
|
Field Type...(more) Join Now
|
|
|
|
| PHONE1 |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| PHONE2 |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| FAX |
char(21)
|
Fax: Same...(more) Join Now
|
RM00101.FAX
|
|
|
| PRBTADCD |
char(15)
|
Primary Bi...(more) Join Now
|
RM00101.PRBTADCD
|
|
join ... more text available
|
| PRSTADCD |
char(15)
|
Primary Sh...(more) Join Now
|
RM00101.PRSTADCD
|
|
join ... more text available
|
| STADDRCD |
char(15)
|
Statement ...(more) Join Now
|
RM00101.STADDRCD
|
|
|
| SLPRSNID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| CHEKBKID |
char(15)
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| PYMTRMID |
char(21)
|
Payment Te...(more) Join Now
|
|
|
SY033... more text available
|
| CRLMTTYP |
smallint
|
Credit Lim...(more) Join Now
|
RM00101.CRLMTTYP
|
|
|
| CRLMTAMT |
numeric(19,5)
|
Credit Lim...(more) Join Now
|
RM00101.CRLMTAMT
|
|
|
| CRLMTPER |
smallint
|
Credit Lim...(more) Join Now
|
RM00101.CRLMTPER
|
|
|
| CRLMTPAM |
numeric(19,5)
|
Credit Lim...(more) Join Now
|
RM00101.CRLMTPAM
|
|
|
| CURNCYID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| CUSTDISC |
smallint
|
Customer D...(more) Join Now
|
RM00101.CUSTDISC
|
|
|
| PRICELVL |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| TAXEXMT1 |
char(25)
|
Field Type...(more) Join Now
|
|
|
|
| TAXEXMT2 |
char(25)
|
Field Type...(more) Join Now
|
|
|
|
| TXRGNNUM |
char(25)
|
Tax Regist...(more) Join Now
|
RM00101.TXRGNNUM
|
|
|
| BALNCTYP |
smallint
|
Balance Ty...(more) Join Now
|
RM00101.BALNCTYP
|
|
|
| STMTCYCL |
smallint
|
Statement ...(more) Join Now
|
RM00101.STMTCYCL
|
|
|
| SALSTERR |
char(15)
|
Sales Terr...(more) Join Now
|
RM10301.SALSTERR
|
|
join ... more text available
|
| INACTIVE |
tinyint
|
Inactive: ...(more) Join Now
|
RM00101.INACTIVE
|
|
|
| HOLD |
tinyint
|
Hold: 1 i...(more) Join Now
|
RM00101.HOLD
|
|
|
| NOTEINDX |
numeric(19,5)
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| Technician_ID |
char(15)
|
|
|
|
|
| Technician_Team |
char(15)
|
|
|
|
|
| PO_Required |
tinyint
|
|
|
|
|
| Contact_Name |
char(15)
|
|
|
|
|
| User_Define_1a |
char(31)
|
|
|
|
|
| User_Define_2a |
char(31)
|
|
|
|
|
| User_Define_3a |
char(31)
|
|
|
|
|
| User_Define_4a |
char(31)
|
|
|
|
|
| User_Define_5a |
char(31)
|
|
|
|
|
| User_Define_6a |
char(31)
|
|
|
|
|
| Time_Zone |
char(3)
|
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Supervisors_ID |
char(15)
|
|
|
|
|
| Hold_Transaction_ID |
int
|
|
|
|
|
| Blanket_PO_CB |
tinyint
|
|
|
|
|
| Blanket_PO_Number |
char(17)
|
|
|
|
|
| Orig_Blanket_PO_Amt |
numeric(19,5)
|
|
|
|
|
| Blanket_PO_Amt_Spent |
numeric(19,5)
|
|
|
|
|
| Blanket_PO_Amt__Remainin |
numeric(19,5)
|
|
|
|
|
| Blanket_PO_Exp_Date |
datetime
|
|
|
|
|
| Import_Journal_Number |
char(15)
|
|
|
|
|
| Import_Journal_Number_Count |
smallint
|
|
|
|
|
| Import_Status |
char(15)
|
|
|
|
|
| Import_Status_Descriptio |
char(89)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|