| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| TASK_ID |
number |
20 |
|
|
|
|
|
| TASK_TYPE |
varchar2 |
3 |
|
|
|
|
|
| ITEM_ID |
number |
22 |
√ |
|
null |
|
| ITEM.ITEM_ID
|
SYS_C00913562 R |
|
| REQUESTING_LOCATION_ID |
number |
22 |
√ |
|
null |
|
|
| REQUESTING_BIN_NO |
varchar2 |
7 |
√ |
|
null |
|
|
| REQUESTED_QTY |
number |
13,4 |
√ |
|
null |
|
|
| REQUESTED_UOM |
varchar2 |
4 |
√ |
|
null |
|
|
| REQUESTED_LOT_NO |
varchar2 |
10 |
√ |
|
null |
|
|
| ACTUAL_QTY |
number |
13,4 |
√ |
|
null |
|
|
| ACTUAL_UOM |
varchar2 |
4 |
√ |
|
null |
|
|
| PARENT_TASK_ID |
number |
20 |
√ |
|
null |
|
|
| TASK_GT_01 |
varchar2 |
100 |
√ |
|
null |
|
|
| TASK_GT_02 |
varchar2 |
100 |
√ |
|
null |
|
|
| TASK_GT_03 |
varchar2 |
100 |
√ |
|
null |
|
|
| TASK_GT_04 |
varchar2 |
100 |
√ |
|
null |
|
|
| TASK_GN_01 |
number |
32 |
√ |
|
null |
|
|
| TASK_GN_02 |
number |
32 |
√ |
|
null |
|
|
| TASK_GN_03 |
number |
36,4 |
√ |
|
null |
|
|
| TASK_GN_04 |
number |
32 |
√ |
|
null |
|
|
| TASK_GD_O1 |
date |
7 |
√ |
|
null |
|
|
| TASK_GD_02 |
date |
7 |
√ |
|
null |
|
|
| TASK_STATUS_CD |
varchar2 |
3 |
|
|
|
|
|
| CREATION_DT |
date |
7 |
|
|
|
|
|
| LAST_MODIFIED_DT |
date |
7 |
|
|
|
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
