| PONUMBER |
char(17)
''
|
PO Number ...(more) Join Now
|
|
|
|
| POLNENUM |
int
0
|
PO Line Nu...(more) Join Now
|
|
|
|
| POPRCTNM |
char(17)
''
|
POP Receip...(more) Join Now
|
|
|
|
| RCPTLNNM |
int
0
|
Receipt Li...(more) Join Now
|
|
|
|
| QTYSHPPD |
numeric(19,5)
0.00
|
QTY Shippe...(more) Join Now
|
|
|
|
| QTYINVCD |
numeric(19,5)
0.00
|
QTY Invoic...(more) Join Now
|
|
|
|
| QTYREJ |
numeric(19,5)
0.00
|
QTY Reject...(more) Join Now
|
|
|
|
| QTYMATCH |
numeric(19,5)
0.00
|
QTY Matche...(more) Join Now
|
|
|
|
| QTYRESERVED |
numeric(19,5)
0.00
|
QTY Reserv...(more) Join Now
|
|
|
|
| QTYINVRESERVE |
numeric(19,5)
0.00
|
QTY Invoic...(more) Join Now
|
|
|
|
| Status |
smallint
0
|
Status Ind...(more) Join Now
|
|
|
|
| UMQTYINB |
numeric(19,5)
0.00
|
U Of M QTY...(more) Join Now
|
ENC10111.UMQTYINB
|
|
|
| OLDCUCST |
numeric(19,5)
0.00
|
Old Curren...(more) Join Now
|
|
|
|
| JOBNUMBR |
char(17)
''
|
Job Number...(more) Join Now
|
|
|
|
| COSTCODE |
char(27)
''
|
Cost Code ...(more) Join Now
|
|
|
|
| COSTTYPE |
smallint
0
|
Cost Code ...(more) Join Now
|
|
|
|
| ORCPTCOST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OSTDCOST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| APPYTYPE |
smallint
0
|
Apply Type...(more) Join Now
|
|
|
|
| POPTYPE |
smallint
0
|
POP Type 1...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| UOFM |
char(9)
''
|
U Of M The...(more) Join Now
|
|
|
See I... more text available
|
| TRXLOCTN |
char(11)
''
|
TRX Locati...(more) Join Now
|
|
|
|
| DATERECD |
datetime
'1/1/1900'
|
Date Recei...(more) Join Now
|
|
|
|
| RCTSEQNM |
int
0
|
Receipt SE...(more) Join Now
|
|
|
|
| SPRCTSEQ |
int
0
|
Split Rece...(more) Join Now
|
|
|
|
| PCHRPTCT |
numeric(19,5)
0.00
|
Purchase R...(more) Join Now
|
|
|
|
| SPRCPTCT |
numeric(19,5)
0.00
|
Split Rece...(more) Join Now
|
|
|
|
| OREXTCST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| RUPPVAMT |
numeric(19,5)
0.00
|
Remaining ...(more) Join Now
|
|
|
|
| ACPURIDX |
int
0
|
Accrued Pu...(more) Join Now
|
|
|
|
| INVINDX |
int
0
|
Inventory ...(more) Join Now
|
|
|
|
| UPPVIDX |
int
0
|
Unrealized...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| RATECALC |
smallint
0
|
Rate Calc ...(more) Join Now
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| RATETPID |
char(15)
''
|
Rate Type ...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
|
|
|
| Capital_Item |
tinyint
0
|
Capital It...(more) Join Now
|
|
|
|
| Product_Indicator |
smallint
0
|
Product In...(more) Join Now
|
|
|
|
| Total_Landed_Cost_Amount |
numeric(19,5)
0.00
|
Total Land...(more) Join Now
|
|
|
|
| QTYTYPE |
smallint
0
|
QTY Type 1...(more) Join Now
|
|
|
|
| Posted_LC_PPV_Amount |
numeric(19,5)
0.00
|
Posted LC ...(more) Join Now
|
|
|
|
| QTYREPLACED |
numeric(19,5)
0.00
|
QTY Replac...(more) Join Now
|
|
|
|
| QTYINVADJ |
numeric(19,5)
0.00
|
QTY Invoic...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|