| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| is_order_created | VARCHAR2 | 3 | Whether order has been created | ||||
| item_supply_plan_id | NUMBER | 39 | 0 | Item supply plan ID | |||
| line_id | NUMBER | 39 | 0 | Line ID | |||
| order_date | TIMESTAMP | Transaction date for created purchase order or work order | |||||
| order_type | VARCHAR2 | 192 | Type of order (purchase order or work order) | ||||
| quantity | NUMBER | 39 | 0 | Recommended quantity to replenish | |||
| receipt_date | TIMESTAMP | Date goods expected to be received | |||||
| source_location_id | NUMBER | 39 | 0 | Source location ID |