DW_MFG_MA_RULES_G (Preview)
This table requires activation of Component Shortage functional area. This table contains Material Availability Rules.
Details
Module:
Key Columns
MA_RULE_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| MA_RULE_ID | NUMBER | 38 | 0 | True | Material Availability Rule Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System Generated | ||||
| ORGANIZATION_ID | NUMBER | 38 | 0 | The organization identifier that represents the manufacturing plant to which this material availability rule belongs. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| RULE_TYPE | VARCHAR2 | 32 | Represents the type of rule for this material availability rule. Values represent either a work order assignment sequence or force assignment or exclude material. | ||||
| RULE_SEQ_NUMBER | NUMBER | Used to store the rule sequence entered by the user for calculating work order assignment sequence. | |||||
| MA_RULE_ATTRIBUTE_ID | NUMBER | 38 | 0 | Represents the corresponding rule attribute used by this rule line. | DW_MFG_MA_RULE_ATTRIBUTES_TL | MA_RULE_ATTRIBUTE_ID | |
| RULE_ATTRIBUTE_VALUE | VARCHAR2 | 999 | Stores the attribute value for the corresponding rule attribute record. It is not applicable and will be null for rules based on sort order. | ||||
| SORT_ORDER_CODE | VARCHAR2 | 32 | Indicates whether the rule line is sort based or not. If it is sort based then it records the appropriate sort order as ORA_ASC (ascending) or ORA_DESC (descending). Null value in this column indicates that the rule is based on RULE_ATTRIBUTE_VALUE. | DW_ORA_WIE_MA_RULE_SORTORDER_LKP_TL | ORA_WIE_MA_RULE_SORTORDER_CODE | ||
| CREATED_BY | VARCHAR2 | 128 | Indicates the user who created the row. | DW_USER_D | USERNAME | ||
| CREATION_DATE | TIMESTAMP | Creation Timestamp | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Last Update Timestamp |