| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Created By | | Formula Summary.Created By | CREATED_BY | CREATED_BY | 125189 |
| Creation Date | | Formula Summary.Creation Date | CREATION_DATE | CREATION_DATE | 126616 |
| Customer Name | | Formula Summary.Customer Name | CUSTOMER_NAME | CUSTOMER_NAME | 127696 |
| Customer Number | Unique identifier of a customer. | Formula Summary.Customer Number | CUSTOMER_NO | CUSTOMER_NO | 127708 |
| Efectivity Routing ID | Surrogate key for the routing/routing version to be used, if any. | Formula Summary.Efectivity Routing ID | EFECTIVITY_ROUTING_ID | EFECTIVITY_ROUTING_ID | 130749 |
| Effectivity Customer ID | Surrogate key for the customer for which this effectivity is used, if any. | Formula Summary.Effectivity Customer ID | EFFECTIVITY_CUST_ID | EFFECTIVITY_CUST_ID | 131318 |
| Effectivity End Date | The end date of the effectivity. | Formula Summary.Effectivity End Date | EFFECTIVITY_END_DATE | EFFECTIVITY_END_DATE | 131321 |
| Effectivity Formula ID | Surrogate key for the formula /formula version to be used. | Formula Summary.Effectivity Formula ID | EFFECTIVITY_FORMULA_ID | EFFECTIVITY_FORMULA_ID | 131323 |
| Effectivity Formula Use | The purpose for which the formula/routing can be used. 0=Production, 1=Planning, 2=Costing, 3=MSDS. | Formula Summary.Effectivity Formula Use | EFFECTIVITY_FORMULA_USE | EFFECTIVITY_FORMULA_USE | 131325 |
| Effectivity Formula Use Meaning | The purpose for which the formula/routing can be used. 0=Production, 1=Planning, 2=Costing, 3=MSDS. | Formula Summary.Effectivity Formula Use Meaning | EFF_FORMULA_USE_MEANING | EFF_FORMULA_USE_MEANING | 131339 |
| Effectivity Item ID | Surrogate key for the item which is produced by the formula. | Formula Summary.Effectivity Item ID | EFFECTIVITY_ITEM_ID | EFFECTIVITY_ITEM_ID | 131327 |
| Effectivity Preference | Material Resource Planning uses lowest Preference indicator number to find effectiviity. | Formula Summary.Effectivity Preference | EFFECTIVITY_PREFERENCE | EFFECTIVITY_PREFERENCE | 131329 |
| Effectivity Start Date | The start date of the effectivity. | Formula Summary.Effectivity Start Date | EFFECTIVITY_START_DATE | EFFECTIVITY_START_DATE | 131331 |
| Formula Class | | Formula Summary.Formula Class | FORMULA_CLASS | FORMULA_CLASS | 134541 |
| Formula Comment | | Formula Summary.Formula Comment | FORMULA_DESC2 | FORMULA_DESC2 | 134557 |
| Formula Control Class | Not currently used. | Formula Summary.Formula Control Class | FORMULA_CONTROL_CLASS | FORMULA_CONTROL_CLASS | 134546 |
| Formula Description | | Formula Summary.Formula Description | FORMULA_DESC1 | FORMULA_DESC1 | 134552 |
| Formula Efectivity ID | Surrogate key for this effectivity row. | Formula Summary.Formula Efectivity ID | FORMULA_EFECTIVITY_ID | FORMULA_EFECTIVITY_ID | 134561 |
| Formula ID | Surrogate key for formula number appended with formula versions. | Formula Summary.Formula ID | FORMULA_ID | FORMULA_ID | 134580 |
| Formula Number | Alphanumeric formula name or number. | Formula Summary.Formula Number | FORMULA_NO | FORMULA_NO | 134597 |
| Formula Type | 0=std formula; 1=packaged item formula (these are not currently used). | Formula Summary.Formula Type | FORMULA_TYPE | FORMULA_TYPE | 134613 |
| Formula Type Meaning | 0=standard formula; 1=packaged item formula | Formula Summary.Formula Type Meaning | FORMULA_TYPE_MEANING | FORMULA_TYPE_MEANING | 134620 |
| Formula Version | | Formula Summary.Formula Version | FORMULA_VERSION | FORMULA_VERSION | 134633 |
| Last Update Date | | Formula Summary.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 141143 |
| Last Updated By | | Formula Summary.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139769 |
| Maximum Output Qantity in Primary UOM | The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item. | Formula Summary.Maximum Output Qantity in Primary UOM | MAX_OUTPUT_QTY_PRIMARY_UOM | MAX_OUTPUT_QTY_PRIMARY_UOM | 146466 |
| Maximum Output Quantity in Effectivity UOM | The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | Formula Summary.Maximum Output Quantity in Effectivity UOM | MAX_OUTPUT_QTY_EFF_UOM | MAX_OUTPUT_QTY_EFF_UOM | 146464 |
| Minimum Output Quantity in Effectivity UOM | The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | Formula Summary.Minimum Output Quantity in Effectivity UOM | MIN_OUTPUT_QTY_EFF_UOM | MIN_OUTPUT_QTY_EFF_UOM | 147194 |
| Minmun Output Quantity in Primary UOM | The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item. | Formula Summary.Minmun Output Quantity in Primary UOM | MIN_OUTPUT_QTY_PRIMARY_UOM | MIN_OUTPUT_QTY_PRIMARY_UOM | 147196 |
| Orgnization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Formula Summary.Orgnization Code | ORGNIZATION_CODE | ORGNIZATION_CODE | 150801 |
| Product Comment | Short description of the item that is not displayed during the item look up. | Formula Summary.Product Comment | PRODUCT_DESC2 | PRODUCT_DESC2 | 155887 |
| Product Description | Short description of the item that is displayed during the item look up. | Formula Summary.Product Description | PRODUCT_DESC1 | PRODUCT_DESC1 | 155883 |
| Product Item Number | Name of the item. | Formula Summary.Product Item Number | PRODUCT_ITEM_NO | PRODUCT_ITEM_NO | 155935 |
| Product Quantity | Standard batch size for this rec. | Formula Summary.Product Quantity | PRODUCT_QTY | PRODUCT_QTY | 155987 |
| Product UOM | UOM for min qty and max qty. | Formula Summary.Product UOM | PRODUCT_UOM | PRODUCT_UOM | 156029 |
| Routing Class | User defined class for routings. | Formula Summary.Routing Class | ROUTING_CLASS | ROUTING_CLASS | 159803 |
| Routing Description | | Formula Summary.Routing Description | ROUTING_DESCRIPTION | ROUTING_DESCRIPTION | 159808 |
| Routing Item UOM | Uom of routing qty. | Formula Summary.Routing Item UOM | ROUTING_ITEM_UOM | ROUTING_ITEM_UOM | 159823 |
| Routing Number | Routing name. | Formula Summary.Routing Number | ROUTING_NO | ROUTING_NO | 159829 |
| Routing Quantity | Used in ratio with formula and batch qty to scale individual step requirements. | Formula Summary.Routing Quantity | ROUTING_QTY | ROUTING_QTY | 159843 |
| Routing Version | | Formula Summary.Routing Version | ROUTING_VERSION | ROUTING_VERSION | 159869 |
| Scale Type | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. | Formula Summary.Scale Type | SCALE_TYPE | SCALE_TYPE | 160770 |