| USERID |
char
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| CMPANYID |
smallint
|
Company ID...(more) Join Now
|
WPPU0114.CMPANYID
|
|
join ... more text available
|
| PApurordnum |
char
|
Purchase O...(more) Join Now
|
PA01101.PApurordnum
|
|
|
| ORD |
int
|
|
|
|
|
| BRKFLD1 |
smallint
|
Break Fiel...(more) Join Now
|
gpUPRCPR.BRKFLD1
|
|
|
| BRKFLD2 |
smallint
|
|
|
|
|
| BRKFLD3 |
smallint
|
|
|
|
|
| ITEMNMBR |
char
|
span style...(more) Join Now
|
JC00701.ITEMNMBR
|
|
join ... more text available
|
| ITEMDESC |
char
|
Item Descr...(more) Join Now
|
WO010116.ITEMDESC
|
|
|
| VNDITNUM |
char
|
Vendor Ite...(more) Join Now
|
QAD10532.VNDITNUM
|
|
|
| VNDITDSC |
char
|
|
|
|
|
| REQDATE |
datetime
|
Required D...(more) Join Now
|
OSRC1100.REQDATE
|
|
|
| UOFM |
char
|
U of M The...(more) Join Now
|
gpItmCus.UOFM
|
|
See I... more text available
|
| QTYORDER |
numeric
|
|
|
|
|
| QTYCANCE |
numeric
|
QTY Cancel...(more) Join Now
|
ENC10111.QTYCANCE
|
|
|
| UNITCOST |
numeric
|
Unit Cost:...(more) Join Now
|
SEE30303.UNITCOST
|
|
|
| ORUNTCST |
numeric
|
Unit Price...(more) Join Now
|
PA11801.ORUNTCST
|
|
|
| EXTDCOST |
numeric
|
Extended C...(more) Join Now
|
SEE30303.EXTDCOST
|
|
|
| OREXTCST |
numeric
|
Originatin...(more) Join Now
|
PTE30501.OREXTCST
|
|
|
| COMMNTID |
char
|
|
|
|
join ... more text available
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| ODECPLCU |
smallint
|
|
|
|
|
| DOCTYPE |
smallint
|
Document T...(more) Join Now
|
PM30300.DOCTYPE
|
|
|
| POLNESTA |
smallint
|
PO Line St...(more) Join Now
|
POP30110.POLNESTA
|
|
|
| PA_Change_Order_Flag |
tinyint
|
|
|
|
|
| TAXDTLID |
char
|
Tax Detail...(more) Join Now
|
PM30300.TAXDTLID
|
|
|
| RELEASEBYDATE |
datetime
|
Release By...(more) Join Now
|
OSRC1110.RELEASEBYDATE
|
|
|
| Released_Date |
datetime
|
|
|
|
|
| FREEONBOARD |
smallint
|
|
|
|
|
| PACOSTCATID |
char
|
PA Cost Ca...(more) Join Now
|
PA11801.PACOSTCATID
|
|
|
| PAPROJNUMBER |
char
|
PA Project...(more) Join Now
|
PA11801.PAPROJNUMBER
|
|
join ... more text available
|
| PAbillnoteidx |
numeric
|
PA Billing...(more) Join Now
|
PA01101.PAbillnoteidx
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|