| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ITEM_GROUP |
varchar2 |
5 |
|
|
|
|
|
| ITEM |
varchar2 |
32 |
|
|
|
|
|
| DESCRIPTION |
varchar2 |
30 |
√ |
|
null |
|
|
| DESCRIPTION2 |
varchar2 |
30 |
√ |
|
null |
|
|
| STOCK_UOM |
varchar2 |
4 |
√ |
|
null |
|
|
| MANUF_CODE |
varchar2 |
4 |
√ |
|
null |
|
|
| MANUF_DIV |
varchar2 |
4 |
√ |
|
null |
|
|
| MANUF_NBR |
varchar2 |
35 |
√ |
|
null |
|
|
| ACTIVE_STATUS |
char |
1 |
√ |
|
null |
|
|
| USE_IDENTIFIER |
char |
1 |
√ |
|
null |
|
|
| TRACKING_FL |
varchar2 |
20 |
√ |
|
null |
|
|
| TRANS_FL |
varchar2 |
20 |
√ |
|
null |
|
|
| ALT_UOM |
varchar2 |
80 |
√ |
|
null |
|
|
| MAJOR_CLASS |
varchar2 |
4 |
√ |
|
null |
|
|
| MINOR_CLASS |
varchar2 |
4 |
√ |
|
null |
|
|
| CREATION_DT |
date |
7 |
|
|
|
|
|
| LAST_MODIFIED_DT |
date |
7 |
√ |
|
null |
|
|
| SER_TRACK_FL |
char |
1 |
√ |
|
('N') |
|
|
| LOT_TRACK_FL |
char |
1 |
√ |
|
('N') |
|
|
| ALT_UOM_MULT |
varchar2 |
200 |
√ |
|
null |
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
