| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| LINE_ID |
number |
20 |
|
|
|
|
|
| PO_ID |
number |
20 |
|
|
|
|
|
| LINE_NO |
number |
6 |
|
|
|
|
|
| ITEM_NO |
varchar2 |
32 |
|
|
|
|
|
| ITEM_DESC |
varchar2 |
32 |
|
|
|
|
|
| TYPE |
char |
1 |
|
|
|
|
|
| SHIP_TO_LOC |
number |
38 |
|
|
|
|
|
| BIN_TRACKED |
char |
1 |
|
|
|
|
|
| LOT_TRACKED |
char |
1 |
|
|
|
|
|
| SER_TRACKED |
char |
1 |
|
|
|
|
|
| INV_TRACKED |
char |
1 |
|
|
|
|
|
| MFR_ID |
number |
22 |
√ |
|
null |
|
| MFGR.MFR_ID
|
Implied Constraint R |
|
| CATALOG_NO |
varchar2 |
35 |
√ |
|
null |
|
|
| VENDOR |
varchar2 |
40 |
√ |
|
null |
|
|
| TRANS_UOM |
varchar2 |
4 |
|
|
|
|
|
| ORD_QTY |
number |
30,4 |
|
|
|
|
|
| REC_QTY |
number |
30,4 |
|
|
|
|
|
| REM_QTY |
number |
30,4 |
|
|
|
|
|
| PREF_BIN |
varchar2 |
7 |
√ |
|
null |
|
|
| NEED_INSP |
char |
1 |
|
|
|
|
|
| IS_CANCELED |
char |
1 |
|
|
|
|
|
| IS_CLOSED |
char |
1 |
|
|
|
|
|
| INT_STATUS |
char |
1 |
|
|
|
|
|
| EXT_STATUS |
char |
1 |
|
|
|
|
|
| CTW |
char |
1 |
|
|
|
|
|
| NBR_DEC |
number |
22 |
√ |
|
null |
|
|
| UND_SHP_TOL |
number |
22 |
√ |
|
null |
|
|
| CAN_BACK_ORD |
char |
1 |
|
|
'B' |
|
|
| BO_REM_QTY |
number |
30,4 |
√ |
|
null |
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
