| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| HIESTBAL |
numeric(19,5)
0.00
|
Highest Ba...(more) Join Now
|
|
|
|
| CURRBLNC |
numeric(19,5)
0.00
|
Current Ba...(more) Join Now
|
|
|
|
| NOINVYTD |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| NOINVLIF |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| NOINVLYR |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| NOPINYTD |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| NOPILIFE |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| AMBLDTYD |
numeric(19,5)
0.00
|
Amount Bil...(more) Join Now
|
|
|
|
| AMBLDLIF |
numeric(19,5)
0.00
|
Amount Bil...(more) Join Now
|
|
|
|
| AMBLDLYR |
numeric(19,5)
0.00
|
Amount Bil...(more) Join Now
|
|
|
|
| AMTPDYTD |
numeric(19,5)
0.00
|
Amount Pai...(more) Join Now
|
|
|
|
| AMTPDLIF |
numeric(19,5)
0.00
|
Amount Pai...(more) Join Now
|
|
|
|
| AMTPDLYR |
numeric(19,5)
0.00
|
Amount Pai...(more) Join Now
|
|
|
|
| TEN99AYTD |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| TEN99ALIF |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| TEN99ALYR |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| DISAVYTD |
numeric(19,5)
0.00
|
Discount
...(more) Join Now
|
|
|
|
| DISAVLIF |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISAVLYR |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISTKYTD |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISTKNLF |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISTKLYR |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISLSYTD |
numeric(19,5)
0.00
|
Discount L...(more) Join Now
|
|
|
|
| DISLSTLF |
numeric(19,5)
0.00
|
Discount L...(more) Join Now
|
|
|
|
| DISLSLYR |
numeric(19,5)
0.00
|
Discount L...(more) Join Now
|
|
|
|
| FINCHLIF |
numeric(19,5)
0.00
|
Finance Ch...(more) Join Now
|
|
|
|
| FINCHLYR |
numeric(19,5)
0.00
|
Finance Ch...(more) Join Now
|
|
|
|
| FINCHYTD |
numeric(19,5)
0.00
|
Finance Ch...(more) Join Now
|
|
|
|
| WROFSYTD |
numeric(19,5)
0.00
|
Write Offs...(more) Join Now
|
|
|
|
| WROFSLIF |
numeric(19,5)
0.00
|
Write Offs...(more) Join Now
|
|
|
|
| WROFSLYR |
numeric(19,5)
0.00
|
Write Offs...(more) Join Now
|
|
|
|
| RTRNSYTD |
numeric(19,5)
0.00
|
Returns YT...(more) Join Now
|
|
|
|
| RTRNSLIF |
numeric(19,5)
0.00
|
Returns Li...(more) Join Now
|
|
|
|
| RTRNSLYR |
numeric(19,5)
0.00
|
Returns LY...(more) Join Now
|
|
|
|
| TRDTKLIF |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| TRDTLYR |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| TRDTYTD |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| NFNCHLIF |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| NFNCHLYR |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| NFNCHYTD |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| RTNGOWED |
numeric(19,5)
0.00
|
Retainage ...(more) Join Now
|
|
|
|
| LSTCHNUM |
char(21)
''
|
Last Check...(more) Join Now
|
|
|
|
| LSTCHKDT |
datetime
'1/1/1900'
|
Last Check...(more) Join Now
|
|
|
|
| LSTCHAMT |
numeric(19,5)
0.00
|
Last Check...(more) Join Now
|
|
|
|
| LSTINNUM |
char(21)
''
|
Last Invoi...(more) Join Now
|
|
|
|
| LSTINVAM |
numeric(19,5)
0.00
|
Last Invoi...(more) Join Now
|
|
|
|
| LSTPURDT |
datetime
'1/1/1900'
|
Last Purch...(more) Join Now
|
|
|
|
| FSTPURDT |
datetime
'1/1/1900'
|
First Purc...(more) Join Now
|
|
|
|
| CURUNPBN |
numeric(19,5)
0.00
|
Current Un...(more) Join Now
|
|
|
|
| UNPDFNCH |
numeric(19,5)
0.00
|
Unpaid Fin...(more) Join Now
|
|
|
|
| DYCHTCLR |
smallint
0
|
Days Check...(more) Join Now
|
|
|
|
| AVGDTPYR |
smallint
0
|
Average Da...(more) Join Now
|
|
|
|
| AVDTPLIF |
smallint
0
|
Average Da...(more) Join Now
|
|
|
|
| ACCRDINV |
numeric(19,5)
0.00
|
Accured In...(more) Join Now
|
|
|
|
| ONORDAMT |
numeric(19,5)
0.00
|
On Order A...(more) Join Now
|
|
|
|
| WITHYTD |
numeric(19,5)
0.00
|
Withholdin...(more) Join Now
|
|
|
|
| WITHLYR |
numeric(19,5)
0.00
|
Withholdin...(more) Join Now
|
|
|
|
| Withholding_LIFE |
numeric(19,5)
0.00
|
Withholdin...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| PrepaymentAmount |
numeric
0.00
|
|
|
|
|