| VNDCLSID |
char(11)
''
|
Vendor Cla...(more) Join Now
|
|
|
|
| VNDCLDSC |
char(31)
''
|
Vendor Cla...(more) Join Now
|
|
|
|
| DEFLTCLS |
tinyint
0
|
Default Cl...(more) Join Now
|
|
|
|
| MXIAFVND |
smallint
0
|
Maximum In...(more) Join Now
|
PM00200.MXIAFVND
|
|
|
| MXINVAMT |
numeric(19,5)
0.00
|
Maximum In...(more) Join Now
|
|
|
|
| WRITEOFF |
smallint
0
|
Writeoff: ...(more) Join Now
|
PM00200.WRITEOFF
|
|
|
| CREDTLMT |
smallint
0
|
Credit Lim...(more) Join Now
|
PM00200.CREDTLMT
|
|
|
| TEN99TYPE |
smallint
0
|
1099 Type:...(more) Join Now
|
|
|
|
| PTCSHACF |
smallint
0
|
Post To Ca...(more) Join Now
|
PM00200.PTCSHACF
|
|
|
| MXWOFAMT |
numeric(19,5)
0.00
|
Maximum Wr...(more) Join Now
|
|
|
|
| MINORDER |
numeric(19,5)
0.00
|
Minimum Or...(more) Join Now
|
|
|
|
| CRLMTDLR |
numeric(19,5)
0.00
|
Credit Lim...(more) Join Now
|
|
|
|
| PYMNTPRI |
char(3)
''
|
Payment Pr...(more) Join Now
|
PM00200.PYMNTPRI
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| PYMTRMID |
char(21)
''
|
Payment Te...(more) Join Now
|
PM10000.PYMTRMID
|
|
SY033... more text available
|
| MINPYTYP |
smallint
0
|
Minimum
...(more) Join Now
|
RM00101.MINPYTYP
|
|
|
| MINPYDLR |
numeric(19,5)
0.00
|
Minimum Pa...(more) Join Now
|
|
|
|
| MINPYPCT |
smallint
0
|
Finance Ch...(more) Join Now
|
RM00101.MINPYPCT
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
PM10000.TAXSCHID
|
|
join ... more text available
|
| KPCALHST |
tinyint
0
|
Keep Calen...(more) Join Now
|
RM00101.KPCALHST
|
|
|
| KGLDSTHS |
tinyint
0
|
Keep GL Di...(more) Join Now
|
PM00200.KGLDSTHS
|
|
|
| KPERHIST |
tinyint
0
|
Keep Perio...(more) Join Now
|
RM00101.KPERHIST
|
|
|
| KPTRXHST |
tinyint
0
|
Keep Trx H...(more) Join Now
|
RM00101.KPTRXHST
|
|
|
| TRDDISCT |
smallint
0
|
Trade Disc...(more) Join Now
|
RM10301.TRDDISCT
|
|
|
| USERDEF1 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| PMAPINDX |
int
0
|
PM AP Inde...(more) Join Now
|
PM00200.PMAPINDX
|
|
|
| PMCSHIDX |
int
0
|
PM Cash In...(more) Join Now
|
PM00200.PMCSHIDX
|
|
|
| PMDAVIDX |
int
0
|
PM Discoun...(more) Join Now
|
PM00200.PMDAVIDX
|
|
|
| PMDTKIDX |
int
0
|
PM Discoun...(more) Join Now
|
PM00200.PMDTKIDX
|
|
|
| PMFINIDX |
int
0
|
PM Finance...(more) Join Now
|
PM00200.PMFINIDX
|
|
|
| PMMSCHIX |
int
0
|
PM Misc Ch...(more) Join Now
|
PM00200.PMMSCHIX
|
|
|
| PMFRTIDX |
int
0
|
PM Freight...(more) Join Now
|
PM00200.PMFRTIDX
|
|
|
| PMTAXIDX |
int
0
|
PM Tax Ind...(more) Join Now
|
PM00200.PMTAXIDX
|
|
|
| PMWRTIDX |
int
0
|
PM Writeof...(more) Join Now
|
PM00200.PMWRTIDX
|
|
|
| PMPRCHIX |
int
0
|
PM Purchas...(more) Join Now
|
PM00200.PMPRCHIX
|
|
|
| PMRTNGIX |
int
0
|
PM Retaina...(more) Join Now
|
PM00200.PMRTNGIX
|
|
|
| PMTDSCIX |
int
0
|
PM Trade
...(more) Join Now
|
PM00200.PMTDSCIX
|
|
|
| ACPURIDX |
int
0
|
Accrued Pu...(more) Join Now
|
PM00200.ACPURIDX
|
|
|
| PURPVIDX |
int
0
|
Purchase P...(more) Join Now
|
IV00101.PURPVIDX
|
|
|
| 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
|
RM00101.CREATDDT
|
|
|
| RATETPID |
char(15)
''
|
A valid Ra...(more) Join Now
|
|
|
|
| Revalue_Vendor |
tinyint
0
|
Revalue Ve...(more) Join Now
|
PM00200.Revalue_Vendor
|
|
|
| Post_Results_To |
smallint
0
|
Post Resul...(more) Join Now
|
RM00101.Post_Results_To
|
|
|
| FREEONBOARD |
smallint
0
|
Free On Bo...(more) Join Now
|
IV00103.FREEONBOARD
|
|
|
| DISGRPER |
smallint
0
|
Discount G...(more) Join Now
|
RM10301.DISGRPER
|
|
|
| DUEGRPER |
smallint
0
|
Due Date G...(more) Join Now
|
RM10301.DUEGRPER
|
|
|
| TaxInvRecvd |
tinyint
0
|
Tax Invoic...(more) Join Now
|
POP10300.TaxInvRecvd
|
|
|
| CBVAT |
tinyint
0
|
Cash Based...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|