| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
|
| VENDNAME |
char(65)
''
|
Vendor Nam...(more) Join Now
|
|
|
|
| VNDCHKNM |
char(65)
''
|
Vendor Che...(more) Join Now
|
|
|
|
| VENDSHNM |
char(15)
''
|
Vendor Sho...(more) Join Now
|
|
|
|
| VADDCDPR |
char(15)
''
|
Vendor Add...(more) Join Now
|
|
|
join ... more text available
|
| VADCDPAD |
char(15)
''
|
Vendor Add...(more) Join Now
|
|
|
join ... more text available
|
| VADCDSFR |
char(15)
''
|
Vendor Add...(more) Join Now
|
|
|
join ... more text available
|
| VADCDTRO |
char(15)
''
|
Vendor Add...(more) Join Now
|
|
|
join ... more text available
|
| VNDCLSID |
char(11)
''
|
Vendor Cla...(more) Join Now
|
|
|
join ... more text available
|
| VNDCNTCT |
char(61)
''
|
Vendor Con...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Address 1:...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Address 2:...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Address 3:...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
City:...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
State: 4 ...(more) Join Now
|
|
|
|
| ZIPCODE |
char(11)
''
|
Zip Code: ...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Country:...(more) Join Now
|
|
|
|
| PHNUMBR1 |
char(21)
''
|
Phone 1: ...(more) Join Now
|
|
|
|
| PHNUMBR2 |
char(21)
''
|
Phone 2: ...(more) Join Now
|
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: 3...(more) Join Now
|
|
|
|
| FAXNUMBR |
char(21)
''
|
Fax Number...(more) Join Now
|
|
|
|
| UPSZONE |
char(3)
''
|
UPS Zone:...(more) Join Now
|
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
|
|
join ... more text available
|
| ACNMVNDR |
char(21)
''
|
Account Nu...(more) Join Now
|
|
|
|
| TXIDNMBR |
char(11)
''
|
Tax ID Num...(more) Join Now
|
|
|
|
| VENDSTTS |
smallint
0
|
Vendor Sta...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| TXRGNNUM |
char(25)
''
|
Tax Regist...(more) Join Now
|
|
|
|
| PARVENID |
char(15)
''
|
Parent Ven...(more) Join Now
|
|
|
|
| TRDDISCT |
smallint
0
|
Trade Disc...(more) Join Now
|
|
|
|
| TEN99TYPE |
smallint
0
|
1099 Type:...(more) Join Now
|
|
|
|
| TEN99BOXNUMBER |
smallint
0
|
1099 Box N...(more) Join Now
|
|
|
|
| MINORDER |
numeric(19,5)
0.00
|
Minimum Or...(more) Join Now
|
|
|
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
|
|
SY033... more text available
|
| MINPYTYP |
smallint
0
|
Minimum
...(more) Join Now
|
|
|
|
| MINPYPCT |
smallint
0
|
Minimum Pa...(more) Join Now
|
|
|
|
| MINPYDLR |
numeric(19,5)
0.00
|
Minimum Pa...(more) Join Now
|
|
|
|
| MXIAFVND |
smallint
0
|
Maximum In...(more) Join Now
|
|
|
|
| MAXINDLR |
numeric(19,5)
0.00
|
Maximum In...(more) Join Now
|
|
|
|
| COMMENT1 |
char(31)
''
|
Comment 1:...(more) Join Now
|
|
|
|
| COMMENT2 |
char(31)
''
|
Comment 2:...(more) Join Now
|
|
|
|
| USERDEF1 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| CRLMTDLR |
numeric(19,5)
0.00
|
Credit Lim...(more) Join Now
|
|
|
|
| PYMNTPRI |
char(3)
''
|
Payment Pr...(more) Join Now
|
|
|
|
| KPCALHST |
tinyint
0
|
Keep Calen...(more) Join Now
|
|
|
|
| KGLDSTHS |
tinyint
0
|
Keep GL Di...(more) Join Now
|
|
|
|
| KPERHIST |
tinyint
0
|
Keep Perio...(more) Join Now
|
|
|
|
| KPTRXHST |
tinyint
0
|
Keep Trx H...(more) Join Now
|
|
|
|
| HOLD |
tinyint
0
|
Hold: 1 i...(more) Join Now
|
|
|
|
| PTCSHACF |
smallint
0
|
Post To Ca...(more) Join Now
|
|
|
|
| CREDTLMT |
smallint
0
|
Credit Lim...(more) Join Now
|
|
|
|
| WRITEOFF |
smallint
0
|
Writeoff: ...(more) Join Now
|
|
|
|
| MXWOFAMT |
numeric(19,5)
0.00
|
Maximum Wr...(more) Join Now
|
|
|
|
| SBPPSDED |
tinyint
0
|
Subject to...(more) Join Now
|
|
|
|
| PPSTAXRT |
smallint
0
|
PPS Tax Ra...(more) Join Now
|
|
|
|
| DXVARNUM |
char(25)
''
|
Deduction ...(more) Join Now
|
|
|
|
| CRTCOMDT |
datetime
'1/1/1900'
|
Certificat...(more) Join Now
|
|
|
|
| CRTEXPDT |
datetime
'1/1/1900'
|
Certificat...(more) Join Now
|
|
|
|
| RTOBUTKN |
tinyint
0
|
Reporting ...(more) Join Now
|
|
|
|
| XPDTOBLG |
tinyint
0
|
Expiration...(more) Join Now
|
|
|
|
| PRSPAYEE |
tinyint
0
|
Prescribed...(more) Join Now
|
|
|
|
| PMAPINDX |
int
0
|
PM AP Inde...(more) Join Now
|
|
|
|
| PMCSHIDX |
int
0
|
PM Cash In...(more) Join Now
|
|
|
|
| PMDAVIDX |
int
0
|
PM Discoun...(more) Join Now
|
|
|
|
| PMDTKIDX |
int
0
|
PM Discoun...(more) Join Now
|
|
|
|
| PMFINIDX |
int
0
|
PM Finance...(more) Join Now
|
|
|
|
| PMMSCHIX |
int
0
|
PM Misc Ch...(more) Join Now
|
|
|
|
| PMFRTIDX |
int
0
|
PM Freight...(more) Join Now
|
|
|
|
| PMTAXIDX |
int
0
|
PM Tax Ind...(more) Join Now
|
|
|
|
| PMWRTIDX |
int
0
|
PM Writeof...(more) Join Now
|
|
|
|
| PMPRCHIX |
int
0
|
PM Purchas...(more) Join Now
|
|
|
|
| PMRTNGIX |
int
0
|
PM Retaina...(more) Join Now
|
|
|
|
| PMTDSCIX |
int
0
|
PM Trade
...(more) Join Now
|
|
|
|
| ACPURIDX |
int
0
|
Accrued Pu...(more) Join Now
|
|
|
|
| PURPVIDX |
int
0
|
Purchase P...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| CREATDDT |
datetime
'1/1/1900'
|
Created Da...(more) Join Now
|
|
|
|
| RATETPID |
char(15)
''
|
Rate Type ...(more) Join Now
|
|
|
|
| Revalue_Vendor |
tinyint
0
|
Revalue Ve...(more) Join Now
|
|
|
|
| Post_Results_To |
smallint
0
|
Post Resul...(more) Join Now
|
|
|
|
| FREEONBOARD |
smallint
0
|
Free On Bo...(more) Join Now
|
|
|
|
| GOVCRPID |
char(31)
''
|
Government...(more) Join Now
|
|
|
|
| GOVINDID |
char(31)
''
|
Government...(more) Join Now
|
|
|
|
| DISGRPER |
smallint
0
|
Discount G...(more) Join Now
|
|
|
|
| DUEGRPER |
smallint
0
|
Due Date G...(more) Join Now
|
|
|
|
| DOCFMTID |
char(15)
''
|
Document F...(more) Join Now
|
|
|
|
| TaxInvRecvd |
tinyint
0
|
Tax Invoic...(more) Join Now
|
|
|
|
| USERLANG |
smallint
0
|
User Langu...(more) Join Now
|
|
|
|
| WithholdingType |
smallint
0
|
Withholdin...(more) Join Now
|
|
|
|
| WithholdingFormType |
smallint
0
|
Withholdin...(more) Join Now
|
|
|
|
| WithholdingEntityType |
smallint
0
|
Withholdin...(more) Join Now
|
|
|
|
| TaxFileNumMode |
smallint
0
|
Tax File N...(more) Join Now
|
|
|
|
| BRTHDATE |
datetime
'1/1/1900'
|
Birth Date...(more) Join Now
|
|
|
|
| LaborPmtType |
smallint
0
|
Labor Paym...(more) Join Now
|
|
|
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
|
|
|
| DECLID |
char(15)
''
|
Declarant ...(more) Join Now
|
|
|
|
| CBVAT |
tinyint
0
|
Cash Based...(more) Join Now
|
|
|
|
| Workflow_Approval_Status |
smallint
0
|
Workflow A...(more) Join Now
|
|
|
|
| Workflow_Priority |
smallint
0
|
Workflow P...(more) Join Now
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| Workflow_Status |
smallint
0
|
1- Not Sub...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| VADCD1099 |
char
''
|
Vendor Add...(more) Join Now
|
|
|
|