| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| COMPANY |
number |
4 |
|
|
|
|
|
| LOCATION |
varchar2 |
5 |
|
|
|
|
|
| ITEM |
varchar2 |
32 |
|
|
|
|
|
| UOM |
varchar2 |
4 |
√ |
|
null |
|
|
| REORDER_POINT |
number |
13,4 |
√ |
|
null |
|
|
| PREFER_BIN |
varchar2 |
7 |
√ |
|
null |
|
|
| LOT_TRACK_FL |
char |
1 |
√ |
|
null |
|
|
| SER_TRACK_FL |
char |
1 |
√ |
|
null |
|
|
| BIN_TRACK_FL |
char |
1 |
√ |
|
null |
|
|
| ACTIVE_STATUS |
char |
1 |
√ |
|
null |
|
|
| MIN_ORDER |
number |
17,4 |
√ |
|
0 |
|
|
| TRACKING_FL |
char |
1 |
√ |
|
null |
|
|
| CREATION_DT |
date |
7 |
|
|
|
|
|
| LAST_MODIFIED_DT |
date |
7 |
√ |
|
null |
|
|
| CHARGEABLE_FL |
char |
1 |
|
|
'N' |
|
|
| ALLOW_ISS_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
|
