| DSCRIPTN |
char(31)
''
|
Descriptio...(more) Join Now
|
CM20300.DSCRIPTN
|
|
|
| STMNTID |
char(15)
''
|
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer I...(more) Join Now
|
|
|
join ... more text available
|
| STMTNAME |
char(65)
''
|
Statement ...(more) Join Now
|
RM00101.STMTNAME
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CNTCPRSN |
char(61)
''
|
Contact Pe...(more) Join Now
|
RM00101.CNTCPRSN
|
|
|
| ADDRESS1 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| PHONE1 |
char(21)
''
|
10 digit p...(more) Join Now
|
|
|
|
| PHONE2 |
char(21)
''
|
Phone 2: ...(more) Join Now
|
RM00101.PHONE2
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: ...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
City: City...(more) Join Now
|
RM00101.CITY
|
|
|
| STATE |
char(29)
''
|
4 characte...(more) Join Now
|
|
|
|
| ZIP |
char(11)
''
|
|
|
|
|
| DATE1 |
datetime
'1/1/1900'
|
Date: Date...(more) Join Now
|
SY03900.DATE1
|
|
|
| MINPYDUE |
numeric(19,5)
0.00
|
|
|
|
|
| CUSTMSGS_1 |
char(41)
''
|
|
|
|
|
| CUSTMSGS_2 |
char(41)
''
|
|
|
|
|
| CUSTMSGS_3 |
char(41)
''
|
|
|
|
|
| AMNTDUE |
numeric(19,5)
0.00
|
|
|
|
|
| STMTMSGS_1 |
char(51)
''
|
|
|
|
|
| STMTMSGS_2 |
char(51)
''
|
|
|
|
|
| STMTMSGS_3 |
char(51)
''
|
|
|
|
|
| STMTMSGS_4 |
char(51)
''
|
|
|
|
|
| STMTMSGS_5 |
char(51)
''
|
|
|
|
|
| STMTMSGS_6 |
char(51)
''
|
|
|
|
|
| STMTMSGS_7 |
char(51)
''
|
|
|
|
|
| STMTMSGS_8 |
char(51)
''
|
|
|
|
|
| STMTMSGS_9 |
char(51)
''
|
|
|
|
|
| STMTMSGS_10 |
char(51)
''
|
|
|
|
|
| STMTMSGS_11 |
char(51)
''
|
|
|
|
|
| STMTMSGS_12 |
char(51)
''
|
|
|
|
|
| STMTMSGS_13 |
char(51)
''
|
|
|
|
|
| STMTMSGS_14 |
char(51)
''
|
|
|
|
|
| STMTMSGS_15 |
char(51)
''
|
|
|
|
|
| DOCARABR_1 |
char(3)
''
|
|
|
|
|
| DOCARABR_2 |
char(3)
''
|
|
|
|
|
| DOCARABR_3 |
char(3)
''
|
|
|
|
|
| DOCARABR_4 |
char(3)
''
|
|
|
|
|
| DOCARABR_5 |
char(3)
''
|
|
|
|
|
| DOCARABR_6 |
char(3)
''
|
|
|
|
|
| DOCARABR_7 |
char(3)
''
|
|
|
|
|
| DOCARABR_8 |
char(3)
''
|
|
|
|
|
| DOCARABR_9 |
char(3)
''
|
|
|
|
|
| DOCARDSC_1 |
char(21)
''
|
|
|
|
|
| DOCARDSC_2 |
char(21)
''
|
|
|
|
|
| DOCARDSC_3 |
char(21)
''
|
|
|
|
|
| DOCARDSC_4 |
char(21)
''
|
|
|
|
|
| DOCARDSC_5 |
char(21)
''
|
|
|
|
|
| DOCARDSC_6 |
char(21)
''
|
|
|
|
|
| DOCARDSC_7 |
char(21)
''
|
|
|
|
|
| DOCARDSC_8 |
char(21)
''
|
|
|
|
|
| DOCARDSC_9 |
char(21)
''
|
|
|
|
|
| AGPERAMT_1 |
numeric(19,5)
0.00
|
|
|
|
|
| AGPERAMT_2 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
B3910505.AGPERAMT_2
|
|
|
| AGPERAMT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| AGPERAMT_4 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
B3910505.AGPERAMT_4
|
|
|
| AGPERAMT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| AGPERAMT_6 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
B3910505.AGPERAMT_6
|
|
|
| AGPERAMT_7 |
numeric(19,5)
0.00
|
|
|
|
|
| AGPERDSC_1 |
char(15)
''
|
|
|
|
|
| AGPERDSC_2 |
char(15)
''
|
|
|
|
|
| AGPERDSC_3 |
char(15)
''
|
|
|
|
|
| AGPERDSC_4 |
char(15)
''
|
|
|
|
|
| AGPERDSC_5 |
char(15)
''
|
|
|
|
|
| AGPERDSC_6 |
char(15)
''
|
|
|
|
|
| AGPERDSC_7 |
char(15)
''
|
|
|
|
|
| CMPANYID |
smallint
0
|
Company ID...(more) Join Now
|
POP10100.CMPANYID
|
|
join ... more text available
|
| LOCATNID |
char(15)
''
|
Location I...(more) Join Now
|
UPR00100.LOCATNID
|
|
join ... more text available
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
|
|
SY033... more text available
|
| CUSTBLNC |
numeric(19,5)
0.00
|
Current Cu...(more) Join Now
|
B3910505.CUSTBLNC
|
|
|
| DEPRECV |
numeric(19,5)
0.00
|
|
|
|
|
| RNNMBR |
int
0
|
|
|
|
|
| PRNTSTUS |
smallint
0
|
|
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| Process_Index |
int
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|