| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| EVENT_HEADER_ID |
number |
20 |
|
|
|
|
|
| EVENT_DETAIL_SEQ |
number |
6 |
|
|
|
|
|
| ITEM_ID |
number |
22 |
√ |
|
null |
|
| ITEM.ITEM_ID
|
Implied Constraint R |
|
| SOURCE_LOCATION_ID |
number |
22 |
√ |
|
null |
|
|
| SOURCE_BIN_NO |
varchar2 |
7 |
√ |
|
null |
|
|
| REQUESTING_LOCATION_ID |
number |
22 |
√ |
|
null |
|
|
| REQUIRING_BIN_NO |
varchar2 |
7 |
√ |
|
null |
|
|
| QUANTITY |
number |
13,4 |
√ |
|
null |
|
|
| UOM |
varchar2 |
4 |
√ |
|
null |
|
|
| LOT_NO |
varchar2 |
10 |
√ |
|
null |
|
|
| SERIAL_NO |
varchar2 |
16 |
√ |
|
null |
|
|
| EVENT_TIMESTAMP |
date |
7 |
|
|
|
|
|
| DETAIL_UPLOAD_IND |
varchar2 |
8 |
|
|
|
|
|
| TASK_ID |
number |
20 |
√ |
|
null |
|
| TASK.TASK_ID
|
Implied Constraint R |
|
| EVENT_DETAIL_GT_01 |
varchar2 |
100 |
√ |
|
null |
|
|
| EVENT_DETAIL_GT_02 |
varchar2 |
100 |
√ |
|
null |
|
|
| EVENT_DETAIL_GT_03 |
varchar2 |
100 |
√ |
|
null |
|
|
| EVENT_DETAIL_GT_04 |
varchar2 |
100 |
√ |
|
null |
|
|
| EVENT_DETAIL_GT_05 |
varchar2 |
100 |
√ |
|
null |
|
|
| EVENT_DETAIL_GT_06 |
varchar2 |
100 |
√ |
|
null |
|
|
| EVENT_DETAIL_GN_01 |
number |
36,4 |
√ |
|
null |
|
|
| EVENT_DETAIL_GN_02 |
number |
36,4 |
√ |
|
null |
|
|
| EVENT_DETAIL_GN_03 |
number |
32 |
√ |
|
null |
|
|
| EVENT_DETAIL_GN_04 |
number |
32 |
√ |
|
null |
|
|
| EVENT_DETAIL_GD_01 |
date |
7 |
√ |
|
null |
|
|
| EVENT_DETAIL_GD_02 |
date |
7 |
√ |
|
null |
|
|
| RETRY_COUNT |
number |
4 |
√ |
|
null |
|
|
| CREATION_DT |
date |
7 |
|
|
|
|
|
| LAST_MODIFIED_DT |
date |
7 |
|
|
|
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
