| TNSFCLIF |
numeric(19,5)
0.00
|
The lifeti...(more) Join Now
|
|
|
|
| NONSFLIF |
int
0
|
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer N...(more) Join Now
|
POP10100.CUSTNMBR
|
|
join ... more text available
|
| CUSTBLNC |
numeric(19,5)
0.00
|
Current Cu...(more) Join Now
|
|
|
|
| AGPERAMT_1 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
RM50103.AGPERAMT_1
|
|
|
| AGPERAMT_2 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
|
|
|
| AGPERAMT_3 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
RM50103.AGPERAMT_3
|
|
|
| AGPERAMT_4 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
|
|
|
| AGPERAMT_5 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
RM50103.AGPERAMT_5
|
|
|
| AGPERAMT_6 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
|
|
|
| AGPERAMT_7 |
numeric(19,5)
0.00
|
Array fiel...(more) Join Now
|
RM50103.AGPERAMT_7
|
|
|
| LASTAGED |
datetime
'1/1/1900'
|
|
|
|
|
| FRSTINDT |
datetime
'1/1/1900'
|
|
|
|
|
| LSTNSFCD |
datetime
'1/1/1900'
|
|
|
|
|
| LPYMTAMT |
numeric(19,5)
0.00
|
The amount...(more) Join Now
|
|
|
|
| LASTPYDT |
datetime
'1/1/1900'
|
|
|
|
|
| LSTTRXDT |
datetime
'1/1/1900'
|
|
|
|
|
| LSTTRXAM |
numeric(19,5)
0.00
|
The amount...(more) Join Now
|
|
|
|
| LSTFCHAM |
numeric(19,5)
0.00
|
The financ...(more) Join Now
|
|
|
|
| UPFCHYTD |
numeric(19,5)
0.00
|
Current ba...(more) Join Now
|
|
|
|
| AVDTPLYR |
smallint
0
|
|
|
|
|
| AVDTPLIF |
smallint
0
|
|
|
|
|
| AVGDTPYR |
smallint
0
|
|
|
|
|
| NUMADTPL |
int
0
|
|
|
|
|
| NUMADTPY |
int
0
|
|
|
|
|
| NUMADTPR |
int
0
|
|
|
|
|
| TDTKNYTD |
numeric(19,5)
0.00
|
The dollar...(more) Join Now
|
|
|
|
| TDTKNLYR |
numeric(19,5)
0.00
|
The dollar...(more) Join Now
|
|
|
|
| TDTKNLTD |
numeric(19,5)
0.00
|
The dollar...(more) Join Now
|
|
|
|
| TDISAYTD |
numeric(19,5)
0.00
|
The discou...(more) Join Now
|
|
|
|
| RETAINAG |
numeric(19,5)
0.00
|
Dollar amo...(more) Join Now
|
|
|
|
| TNSFCYTD |
numeric(19,5)
0.00
|
The YTD to...(more) Join Now
|
|
|
|
| NONSFYTD |
int
0
|
|
|
|
|
| UNPSTDSA |
numeric(19,5)
0.00
|
Dollar Amo...(more) Join Now
|
|
|
|
| UNPSTDCA |
numeric(19,5)
0.00
|
Dollar Amo...(more) Join Now
|
|
|
|
| UNPSTOSA |
numeric(19,5)
0.00
|
N/A...(more) Join Now
|
|
|
|
| UNPSTOCA |
numeric(19,5)
0.00
|
N/A...(more) Join Now
|
|
|
|
| NCSCHPMT |
numeric(19,5)
0.00
|
Not used (...(more) Join Now
|
|
|
|
| TTLSLYTD |
numeric(19,5)
0.00
|
Total doll...(more) Join Now
|
|
|
|
| TTLSLLTD |
numeric(19,5)
0.00
|
Total doll...(more) Join Now
|
|
|
|
| TTLSLLYR |
numeric(19,5)
0.00
|
Total doll...(more) Join Now
|
|
|
|
| TCOSTYTD |
numeric(19,5)
0.00
|
Total COGS...(more) Join Now
|
|
|
|
| TCOSTLTD |
numeric(19,5)
0.00
|
Total COGS...(more) Join Now
|
|
|
|
| TCOSTLYR |
numeric(19,5)
0.00
|
Total COGS...(more) Join Now
|
|
|
|
| TCSHRYTD |
numeric(19,5)
0.00
|
Total of t...(more) Join Now
|
|
|
|
| TCSHRLTD |
numeric(19,5)
0.00
|
Total of t...(more) Join Now
|
|
|
|
| TCSHRLYR |
numeric(19,5)
0.00
|
Total of t...(more) Join Now
|
|
|
|
| TFNCHYTD |
numeric(19,5)
0.00
|
Finance ch...(more) Join Now
|
|
|
|
| TFNCHLTD |
numeric(19,5)
0.00
|
Finance ch...(more) Join Now
|
|
|
|
| TFNCHLYR |
numeric(19,5)
0.00
|
Finance ch...(more) Join Now
|
|
|
|
| FNCHCYTD |
numeric(19,5)
0.00
|
Finance ch...(more) Join Now
|
|
|
|
| FNCHLYRC |
numeric(19,5)
0.00
|
Finance ch...(more) Join Now
|
|
|
|
| TBDDTYTD |
numeric(19,5)
0.00
|
N/A...(more) Join Now
|
|
|
|
| TBDDTLYR |
numeric(19,5)
0.00
|
N/A...(more) Join Now
|
|
|
|
| TBDDTLTD |
numeric(19,5)
0.00
|
N/A...(more) Join Now
|
|
|
|
| TWVFCYTD |
numeric(19,5)
0.00
|
Finance ch...(more) Join Now
|
|
|
|
| TWVFCLTD |
numeric(19,5)
0.00
|
Finance ch...(more) Join Now
|
|
|
|
| TWVFCLYR |
numeric(19,5)
0.00
|
Finance ch...(more) Join Now
|
|
|
|
| TWROFYTD |
numeric(19,5)
0.00
|
Dollar amo...(more) Join Now
|
|
|
|
| TWROFLTD |
numeric(19,5)
0.00
|
Dollar amo...(more) Join Now
|
|
|
|
| TWROFLYR |
numeric(19,5)
0.00
|
Dollar amo...(more) Join Now
|
|
|
|
| TTLINYTD |
int
0
|
|
|
|
|
| TTLINLTD |
int
0
|
|
|
|
|
| TTLINLYR |
int
0
|
|
|
|
|
| TTLFCYTD |
int
0
|
|
|
|
|
| TTLFCLTD |
int
0
|
|
|
|
|
| TTLFCLYR |
int
0
|
|
|
|
|
| WROFSLIF |
numeric(19,5)
0.00
|
Write Offs...(more) Join Now
|
|
|
|
| WROFSLYR |
numeric(19,5)
0.00
|
Amount wri...(more) Join Now
|
|
|
|
| WROFSYTD |
numeric(19,5)
0.00
|
Amount wri...(more) Join Now
|
|
|
|
| HIBALLYR |
numeric(19,5)
0.00
|
Highest Ba...(more) Join Now
|
|
|
|
| HIBALYTD |
numeric(19,5)
0.00
|
Highest Ba...(more) Join Now
|
|
|
|
| HIBALLTD |
numeric(19,5)
0.00
|
Highest Ba...(more) Join Now
|
|
|
|
| LASTSTDT |
datetime
'1/1/1900'
|
|
|
|
|
| LSTSTAMT |
numeric(19,5)
0.00
|
Dollar amo...(more) Join Now
|
|
|
|
| DEPRECV |
numeric(19,5)
0.00
|
Dollar Amo...(more) Join Now
|
RM50103.DEPRECV
|
|
|
| ONORDAMT |
numeric(19,5)
0.00
|
Dollar amo...(more) Join Now
|
|
|
|
| TTLRTYTD |
numeric(19,5)
0.00
|
Total retu...(more) Join Now
|
|
|
|
| TTLRTLTD |
numeric(19,5)
0.00
|
Total retu...(more) Join Now
|
|
|
|
| TTLRTLYR |
numeric(19,5)
0.00
|
Total retu...(more) Join Now
|
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|