DW_MFG_MA_ASSIGNMENTS_MAP_G (Preview)
This table requires activation of Component Shortage functional area. This table contains Material Assignments and Shortage Details for a Work Order Operation Material.
Details
Module:
Key Columns
ASSIGNMENT_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Material Availability Assignments Identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System Generated | ||||
| MA_SEQ_ASSIGNMENT_SEQUENCE_ID | NUMBER | 38 | 0 | Material Availability Assignment Sequences Identifier | |||
| MA_SEQ_ASSIGNMENT_SEQ_NUMBER | NUMBER | Priority sequence number assigned for the work order. | |||||
| WORK_ORDER_ID | NUMBER | 38 | 0 | The unique identifier of work order record | DW_MFG_WORK_ORDERS_TL | WORK_ORDER_ID | |
| WO_OPERATION_ID | NUMBER | 38 | 0 | The unique identifier of the operation that uses this material. | DW_MFG_OPERATIONS_TL | WO_OPERATION_ID | |
| WO_OPERATION_MATERIAL_ID | NUMBER | 38 | 0 | The unique identifier of the Operation Material. | |||
| ORGANIZATION_ID | NUMBER | 38 | 0 | The organization identifier that represents the manufacturing plant to which this work order belongs. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| REQUIRED_ITEM_ID | NUMBER | 38 | 0 | The unique identifier of the Required Material used in the operation. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| CALCULATION_TIMESTAMP | TIMESTAMP | Represents the timestamp at which the material has been assigned. | |||||
| CALCULATION_DATE | DATE | Represents the date at which the material has been assigned. | DW_DAY_D | CALENDAR_DATE | |||
| WORK_ORDER_MATERIAL_UOM_CODE | VARCHAR2 | 16 | Represents the unit of measure code of the material quantities. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| AVAILABLE_QUANTITY | NUMBER | Available on-hand quantity for an item. | |||||
| PROJECTED_AVAILABLE_QUANTITY | NUMBER | Quantity assigned for this workorder based on priority | |||||
| REQUIRED_QUANTITY | NUMBER | Work Order Material quantity. | |||||
| OPEN_QUANTITY | NUMBER | Quantity required for that operation | |||||
| RESERVED_QUANTITY | NUMBER | Quantity Reserved for that work order material | |||||
| ALLOCATED_QUANTITY | NUMBER | Quantity allocated for that work order material | |||||
| PICKED_QUANTITY | NUMBER | Quantity picked for that work order material | |||||
| SHORTAGE_QUANTITY | NUMBER | Shortage quantity for that work order material | |||||
| EXPECTED_QUANTITY | NUMBER | Expected Quantity supply for that material | |||||
| SUBSTITUTE_FLAG | VARCHAR2 | 16 | Flag used indicate whether this component is a substitute or not. Valid values: Y - Substitute, N or null - Primary component | ||||
| CREATED_BY | VARCHAR2 | 128 | Material Assignments Created By | DW_USER_D | USERNAME | ||
| CREATION_TIMESTAMP | TIMESTAMP | Creation Date of Material Availability Assignments | |||||
| LAST_UPDATE_TIMESTAMP | TIMESTAMP | Last Update Date of Material Availability Assignments | |||||
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | The unique identifier of the Work Order's Finished Item i.e. the primary product #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| WORK_ORDER_UOM_CODE | VARCHAR2 | 16 | Represents the unit of measure code of the work order quantities. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| PLANNED_START_QUANTITY | NUMBER | Refers to the planned work order quantity which should be greater than zero for standard work orders, and can be equal to or greater than zero for non standard work orders | |||||
| MA_SEQ_PUOM_CONVERSION_FACTOR | NUMBER | PUOM Conversion factor from Work Order UOM to Finished Item's Primary UOM | |||||
| MA_SEQ_PUOM_CODE | VARCHAR2 | 16 | PUOM Code for Finished Item's Primary UOM | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| MA_SEQ_PUOM_PLANNED_START_QUANTITY | NUMBER | Refers to the planned work order quantity in the Finished Item's Primary UOM | |||||
| MA_SEQ_CREATION_TIMESTAMP | TIMESTAMP | Creation date of Material Availability Assignments Sequence | |||||
| MA_SEQ_LAST_UPDATE_TIMESTAMP | TIMESTAMP | Last Update Date of Material Availability Assignments Sequence | |||||
| BOM_RATIO | NUMBER | BOM Ratio using the Primary UOM for Finished Item and Operation Materials | |||||
| MA_SEQ_PUOM_EXPECTED_PRODUCTION_QUANTITY | NUMBER | Expected Production Quantity for Finished Item in Primary UOM at Operation Materials level |
Notes
#1 In these cases in addition to the Item ID columns, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D