| ORDDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| STATUS |
smallint
0
|
p>Field Ty...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| DSCRIPTN |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
|
| UOFM |
char(9)
''
|
Field Type...(more) Join Now
|
|
|
See I... more text available
|
| TRNSFQTY |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| QTYFULFI |
numeric(19,5)
0.00
|
QTY Fulfil...(more) Join Now
|
|
|
|
| QTYSHPPD |
numeric(19,5)
0.00
|
QTY Shippe...(more) Join Now
|
POP10500.QTYSHPPD
|
|
|
| QTY_To_Receive |
numeric(19,5)
0.00
|
|
|
|
|
| QTYRECVD |
numeric(19,5)
0.00
|
QTY Receiv...(more) Join Now
|
SOP10200.QTYRECVD
|
|
|
| CALLNBR |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| SRVRECTYPE |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| SERVLITEMSEQ |
int
0
|
|
|
|
|
| EQPLINE |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| LINITMTYP |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| RETDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| RTV_Number |
char(15)
''
|
|
|
|
|
| WORECTYPE |
smallint
0
|
1 - Quoteb...(more) Join Now
|
|
|
|
| WORKORDNUM |
char(11)
''
|
|
|
|
|
| QTYBSUOM |
numeric(19,5)
0.00
|
QTY In Bas...(more) Join Now
|
|
|
|
| TRNSFLOC |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| ITLOCN |
char(11)
''
|
|
|
|
|
| TRNSTLOC |
char(11)
''
|
Transfer T...(more) Join Now
|
IV10001.TRNSTLOC
|
|
|
| TRFQTYTY |
smallint
0
|
Transfer F...(more) Join Now
|
IV10001.TRFQTYTY
|
|
|
| TRTQTYTY |
smallint
0
|
Transfer T...(more) Join Now
|
IV10001.TRTQTYTY
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| Landed_Cost_Group_ID |
char(15)
''
|
Landed Cos...(more) Join Now
|
IV00102.Landed_Cost_Group_ID
|
|
|
| Reason_Code |
char
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|