| PApurordnum |
char(17)
''
|
The purcha...(more) Join Now
|
|
|
|
| ORD |
int
0
|
|
|
|
|
| BRKFLD1 |
smallint
0
|
Break Fiel...(more) Join Now
|
SOP10200.BRKFLD1
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Number.
|
WO010615.ITEMNMBR
|
|
join ... more text available
|
| VNDITNUM |
char(31)
''
|
Vendor Ite...(more) Join Now
|
POP10110.VNDITNUM
|
|
|
| BackoutTradeDiscTax |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
POP10100.BackoutTradeDiscTax
|
|
|
| Capital_Item |
tinyint
0
|
Capital It...(more) Join Now
|
POP10110.Capital_Item
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
MC40200.CURNCYID
|
|
join ... more text available
|
| DENXRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
MC00100.XCHGRATE
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
|
|
|
| ITMTSHID |
char(15)
''
|
Item Tax S...(more) Join Now
|
|
|
|
| ITMTRKOP |
smallint
0
|
Item Track...(more) Join Now
|
BM10400.ITMTRKOP
|
|
|
| MSCCHAMT |
numeric(19,5)
0.00
|
Misc Charg...(more) Join Now
|
|
|
|
| OrigBackoutTradeDiscTax |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
POP10100.OrigBackoutTradeDiscTax
|
|
|
| ORFRTAMT |
numeric(19,5)
0.00
|
Orig Freig...(more) Join Now
|
POP10300.ORFRTAMT
|
|
|
| OMISCAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
POP10100.OMISCAMT
|
|
|
| ORTDISAM |
numeric(19,5)
0.00
|
Orig Trade...(more) Join Now
|
POP30300.ORTDISAM
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PACBADDFRMFLY |
tinyint
0
|
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| PACogs_Idx |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PAIV_Item_Checkbox |
tinyint
0
|
|
|
|
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| PAprojname |
char(31)
''
|
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PAProjectType |
smallint
0
|
Project ty...(more) Join Now
|
|
|
|
| PAPurchase_Tax_Options |
smallint
0
|
PA Purchas...(more) Join Now
|
|
|
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PACGBWIPIDX |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PRICELVL |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| QTYCMTBASE |
numeric(19,5)
0.00
|
QTY Commit...(more) Join Now
|
POP10110.QTYCMTBASE
|
|
|
| QTYUNCMTBASE |
numeric(19,5)
0.00
|
QTY Uncomm...(more) Join Now
|
POP10110.QTYUNCMTBASE
|
|
|
| RATECALC |
smallint
0
|
Rate Calc ...(more) Join Now
|
POP10100.RATECALC
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|