| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| LOCATION_ITEM_ID |
number |
20 |
|
|
|
|
|
| ITEM_ID |
number |
22 |
|
|
|
|
| ITEM.ITEM_ID
|
SYS_C00913499 R |
|
| LOCATION_ID |
number |
22 |
|
|
|
|
|
| EXT_DATA_IND |
char |
1 |
|
|
|
|
|
| ALT_ITEM_DESCRIPTION |
varchar2 |
60 |
√ |
|
null |
|
|
| ALT_IMGLNK |
varchar2 |
255 |
√ |
|
null |
|
|
| STATUS |
char |
1 |
|
|
|
|
|
| ITEM_REPL_NO |
number |
22 |
√ |
|
null |
|
| ITEM.ITEM_ID
|
SYS_C00913501 R |
|
| EXTERNAL_STATUS |
char |
1 |
√ |
|
null |
|
|
| UOM |
varchar2 |
4 |
√ |
|
null |
|
|
| PAR_LEVEL |
number |
13,4 |
√ |
|
null |
|
|
| PREFER_BIN |
varchar2 |
7 |
√ |
|
null |
|
|
| PAR_BIN_SEQ |
number |
6 |
√ |
|
null |
|
|
| REPL_FROM_LOC_ID |
number |
22 |
√ |
|
null |
|
|
| REPL_FROM_BIN |
varchar2 |
7 |
√ |
|
null |
|
|
| LOT_TRACK_FL |
varchar2 |
1 |
√ |
|
null |
|
|
| SER_TRACK_FL |
varchar2 |
1 |
√ |
|
null |
|
|
| BIN_TRK_FL |
varchar2 |
1 |
√ |
|
null |
|
|
| EACH_COST |
number |
15,4 |
√ |
|
null |
|
|
| CREATION_DT |
date |
7 |
|
|
|
|
|
| LAST_MODIFIED_DT |
date |
7 |
|
|
|
|
|
| QUANTITY_OO |
number |
15,4 |
√ |
|
null |
|
|
| SERIAL_TRACKED_IND |
char |
1 |
√ |
|
('N') |
|
|
| MIN_ORDER |
number |
17,4 |
√ |
|
0 |
|
|
| BIN_LOCATION |
varchar2 |
7 |
√ |
|
'' |
|
|
| CHARGEABLE_FL |
char |
1 |
|
|
'N' |
|
|
| ALLOW_ISS_FL |
char |
1 |
|
|
'Y' |
|
|
| TRACKING_FL |
char |
1 |
|
|
'Y' |
|
|
| AVG_COST |
number |
13,5 |
√ |
|
null |
|
|
| STD_COST |
number |
13,5 |
√ |
|
null |
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
