| CMPANYID |
smallint
|
Company ID...(more) Join Now
|
WPPU0114.CMPANYID
|
|
join ... more text available
|
| USERID |
char
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| PApurordnum |
char
|
Purchase O...(more) Join Now
|
PA01101.PApurordnum
|
|
|
| ORD |
int
|
|
|
|
|
| BRKFLD1 |
smallint
|
Break Fiel...(more) Join Now
|
gpUPRCPR.BRKFLD1
|
|
|
| BCKTXAMT |
numeric
|
Backout Ta...(more) Join Now
|
POP10600.BCKTXAMT
|
|
|
| BackoutTradeDiscTax |
numeric
|
|
|
|
|
| Capital_Item |
tinyint
|
|
|
|
|
| FRTAMNT |
numeric
|
Freight Am...(more) Join Now
|
PA11801.FRTAMNT
|
|
|
| ITMTSHID |
char
|
Item Tax S...(more) Join Now
|
PA11801.ITMTSHID
|
|
|
| ITMTRKOP |
smallint
|
Item Track...(more) Join Now
|
WO010400.ITMTRKOP
|
|
|
| MSCCHAMT |
numeric
|
Misc Charg...(more) Join Now
|
PA11801.MSCCHAMT
|
|
|
| OBTAXAMT |
numeric
|
Originatin...(more) Join Now
|
POP10600.OBTAXAMT
|
|
|
| OrigBackoutTradeDiscTax |
numeric
|
|
|
|
|
| ORFRTAMT |
numeric
|
Originatin...(more) Join Now
|
PTE30500.ORFRTAMT
|
|
|
| OMISCAMT |
numeric
|
Originatin...(more) Join Now
|
PTE30500.OMISCAMT
|
|
|
| OPOSTSUB |
numeric
|
|
|
|
|
| ORTAXAMT |
numeric
|
Originatin...(more) Join Now
|
PTE30501.ORTAXAMT
|
|
|
| ORTDISAM |
numeric
|
|
|
|
|
| PABase_Qty |
numeric
|
PA Base Qt...(more) Join Now
|
PA11801.PABase_Qty
|
|
|
| PABase_Unit_Cost |
numeric
|
PA Base Un...(more) Join Now
|
PA11801.PABase_Unit_Cost
|
|
|
| PAbillnoteidx |
numeric
|
PA Billing...(more) Join Now
|
PA01101.PAbillnoteidx
|
|
|
| PA_Change_Order_Flag |
tinyint
|
|
|
|
|
| PACogs_Idx |
int
|
ACTIDX of ...(more) Join Now
|
PA30101.PACogs_Idx
|
|
|
| PACOSTCATID |
char
|
PA Cost Ca...(more) Join Now
|
PA11801.PACOSTCATID
|
|
|
| PAIV_Item_Checkbox |
tinyint
|
|
|
|
|
| PALineItemSeq |
int
|
PA Line It...(more) Join Now
|
PA02101.PALineItemSeq
|
|
|
| PAprojname |
char
|
|
|
|
|
| PAPROJNUMBER |
char
|
PA Project...(more) Join Now
|
PA11801.PAPROJNUMBER
|
|
join ... more text available
|
| PAProjectType |
smallint
|
1= TIME AN...(more) Join Now
|
PA01101.PAProjectType
|
|
|
| PAPurchase_Tax_Options |
smallint
|
PA Purchas...(more) Join Now
|
PA11801.PAPurchase_Tax_Options
|
|
|
| PATU |
smallint
|
PA Transac...(more) Join Now
|
PA11801.PATU
|
|
|
| PACGBWIPIDX |
int
|
ACTIDX of ...(more) Join Now
|
PA30101.PACGBWIPIDX
|
|
|
| PO_Line_Status_Orig |
smallint
|
|
|
|
|
| PostedSubtotal |
numeric
|
|
|
|
|
| PRICELVL |
char
|
Field Type...(more) Join Now
|
PA11801.PRICELVL
|
|
|
| QTY_Canceled_Orig |
numeric
|
|
|
|
|
| QTYCMTBASE |
numeric
|
|
|
|
|
| QTYUNCMTBASE |
numeric
|
|
|
|
|
| Source_Document_Line_Num |
smallint
|
|
|
|
|
| Source_Document_Number |
char
|
|
|
|
|
| TAXAMNT |
numeric
|
Tax Amount...(more) Join Now
|
PA11801.TAXAMNT
|
|
|
| TRDISAMT |
numeric
|
Trade Disc...(more) Join Now
|
PA11801.TRDISAMT
|
|
|
| UOMSCHDL |
char
|
p>U of M S...(more) Join Now
|
SVC8005.UOMSCHDL
|
|
join ... more text available
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|