| 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
|
| PONUMBER |
char
''
|
PO Number ...(more) Join Now
|
SEE30303.PONUMBER
|
|
|
| ORD |
int
0
|
|
|
|
|
| POLNESTA |
smallint
0
|
PO Line St...(more) Join Now
|
POP30110.POLNESTA
|
|
|
| POTYPE |
smallint
0
|
PO Type T...(more) Join Now
|
ENCAA10111.POTYPE
|
|
|
| VOIDED |
tinyint
0
|
|
|
|
|
| ITEMNMBR |
char
''
|
span style...(more) Join Now
|
JC00701.ITEMNMBR
|
|
join ... more text available
|
| ITEMDESC |
char
''
|
Item Descr...(more) Join Now
|
WO010116.ITEMDESC
|
|
|
| VENDORID |
char
''
|
Vendor ID:...(more) Join Now
|
PM00200.VENDORID
|
|
join ... more text available
|
| VNDITNUM |
char
''
|
Vendor Ite...(more) Join Now
|
QAD10532.VNDITNUM
|
|
|
| VNDITDSC |
char
''
|
|
|
|
|
| NONINVEN |
smallint
0
|
|
|
|
|
| LOCNCODE |
char
''
|
Location C...(more) Join Now
|
PA11801.LOCNCODE
|
|
join ... more text available
|
| UOFM |
char
''
|
U of M The...(more) Join Now
|
gpItmCus.UOFM
|
|
See I... more text available
|
| UMQTYINB |
numeric
0.00
|
U Of M QTY...(more) Join Now
|
ENC10111.UMQTYINB
|
|
|
| QTYORDER |
numeric
0.00
|
|
|
|
|
| QTYCANCE |
numeric
0.00
|
QTY Cancel...(more) Join Now
|
ENC10111.QTYCANCE
|
|
|
| UNITCOST |
numeric
0.00
|
Unit Cost:...(more) Join Now
|
SEE30303.UNITCOST
|
|
|
| EXTDCOST |
numeric
0.00
|
Extended C...(more) Join Now
|
SEE30303.EXTDCOST
|
|
|
| INVINDX |
int
0
|
Inventory ...(more) Join Now
|
POP10600.INVINDX
|
|
|
| REQDATE |
datetime
'1/1/1900'
|
Required D...(more) Join Now
|
OSRC1100.REQDATE
|
|
|
| PRMDATE |
datetime
'1/1/1900'
|
|
|
|
|
| PRMSHPDTE |
datetime
'1/1/1900'
|
|
|
|
|
| REQSTDBY |
char
''
|
|
|
|
|
| COMMNTID |
char
''
|
|
|
|
join ... more text available
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
PM30300.DOCTYPE
|
|
|
| POLNEARY_1 |
numeric
0.00
|
|
|
|
|
| POLNEARY_2 |
numeric
0.00
|
|
|
|
|
| POLNEARY_3 |
numeric
0.00
|
|
|
|
|
| POLNEARY_4 |
numeric
0.00
|
|
|
|
|
| POLNEARY_5 |
numeric
0.00
|
|
|
|
|
| POLNEARY_6 |
numeric
0.00
|
|
|
|
|
| POLNEARY_7 |
numeric
0.00
|
|
|
|
|
| POLNEARY_8 |
numeric
0.00
|
|
|
|
|
| POLNEARY_9 |
numeric
0.00
|
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| BRKFLD1 |
smallint
0
|
Break Fiel...(more) Join Now
|
gpUPRCPR.BRKFLD1
|
|
|
| BRKFLD2 |
smallint
0
|
|
|
|
|
| BRKFLD3 |
smallint
0
|
|
|
|
|
| JOBNUMBR |
char
''
|
Job Number...(more) Join Now
|
SF010601.JOBNUMBR
|
|
|
| COSTCODE |
char
''
|
|
|
|
|
| COSTTYPE |
smallint
0
|
|
|
|
|
| CURNCYID |
char
''
|
Currency I...(more) Join Now
|
RM20102.CURNCYID
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
RM20102.CURRNIDX
|
|
join ... more text available
|
| XCHGRATE |
numeric
0.00
|
Exchange R...(more) Join Now
|
MC00100.XCHGRATE
|
|
|
| RATECALC |
smallint
0
|
Rate Calc ...(more) Join Now
|
PM20100.RATECALC
|
|
|
| DENXRATE |
numeric
0.00
|
Exchange R...(more) Join Now
|
PTE30501.DENXRATE
|
|
|
| ORUNTCST |
numeric
0.00
|
Unit Price...(more) Join Now
|
PA11801.ORUNTCST
|
|
|
| OREXTCST |
numeric
0.00
|
Originatin...(more) Join Now
|
PTE30501.OREXTCST
|
|
|
| LINEORIGIN |
smallint
0
|
Line Origi...(more) Join Now
|
ENCAA10111.LINEORIGIN
|
|
|
| FREEONBOARD |
smallint
0
|
|
|
|
|
| BOLPRONUMBER |
char
''
|
|
|
|
|
| ODECPLCU |
smallint
0
|
|
|
|
|
| Product_Indicator |
smallint
0
|
|
|
|
|
| Released_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Change_Order_Flag |
smallint
0
|
|
|
|
|
| Landed_Cost_Group_ID |
char
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| ProjNum |
char
|
|
|
|
|
| CostCatID |
char
|
|
|
|
|
| LineNumber |
smallint
|
|
|
|
|