| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Burden Indicator | Indicates if costs came from burdens 0=No 1=Yes | Formula Cost.Burden Indicator | BURDEN_INDICATOR | BURDEN_INDICATOR | 120536 |
| Calendar Code | Costing calendar code. | Formula Cost.Calendar Code | CALENDAR_CODE | CALENDAR_CODE | 121333 |
| Calendar Description | Costing Calendar description | Formula Cost.Calendar Description | CALENDAR_DESCRIPTION | CALENDAR_DESCRIPTION | 121341 |
| Component Cost | | Formula Cost.Component Cost | COMPONENT_COST | COMPONENT_COST | 122917 |
| Component Cost ID | Surrogate ID for the Cost Component | Formula Cost.Component Cost ID | COMPONENT_COST_ID | COMPONENT_COST_ID | 122921 |
| Component Group | | Formula Cost.Component Group | CMPNT_GROUP | CMPNT_GROUP | 122280 |
| Cost Analysis Code | | Formula Cost.Cost Analysis Code | COST_ANALYSIS_CODE | COST_ANALYSIS_CODE | 123634 |
| Cost Level | Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Actual Cost Process, 1= Costs via Ingredient calculated by Cost Rollup Process. | Formula Cost.Cost Level | COST_LEVEL | COST_LEVEL | 123713 |
| Cost Method Code | Cost method for accounting cost. | Formula Cost.Cost Method Code | COST_MTHD_CODE | COST_MTHD_CODE | 123718 |
| Cost calculation origin | Cost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development Process | Formula Cost.Cost calculation origin | COSTCALC_ORIG | COSTCALC_ORIG | 123590 |
| Cost component class ID | Unique item cost component class identifier. | Formula Cost.Cost component class ID | COST_CMPNTCLS_ID | COST_CMPNTCLS_ID | 123657 |
| Cost component class code | Cost component class | Formula Cost.Cost component class code | COST_CMPNTCLS_CODE | COST_CMPNTCLS_CODE | 123648 |
| Cost component class description | | Formula Cost.Cost component class description | COST_CMPNTCLS_DESC | COST_CMPNTCLS_DESC | 123652 |
| Costing Total Quantity | Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs. | Formula Cost.Costing Total Quantity | COSTING_TOTAL_QTY | COSTING_TOTAL_QTY | 123603 |
| Created By | | Formula Cost.Created By | CREATED_BY | CREATED_BY | 125188 |
| Creation Date | | Formula Cost.Creation Date | CREATION_DATE | CREATION_DATE | 126615 |
| Customer Name | | Formula Cost.Customer Name | CUSTOMER_NAME | CUSTOMER_NAME | 127695 |
| Customer Number | Unique identifier of a customer. | Formula Cost.Customer Number | CUSTOMER_NO | CUSTOMER_NO | 127707 |
| Efectivity Routing ID | Surrogate key for the routing. | Formula Cost.Efectivity Routing ID | EFECTIVITY_ROUTING_ID | EFECTIVITY_ROUTING_ID | 130748 |
| Effectivity Customer ID | Surrogate key for the customer for which this effectivity is used, if any. | Formula Cost.Effectivity Customer ID | EFFECTIVITY_CUST_ID | EFFECTIVITY_CUST_ID | 131317 |
| Effectivity End Date | The end date of the effectivity. | Formula Cost.Effectivity End Date | EFFECTIVITY_END_DATE | EFFECTIVITY_END_DATE | 131320 |
| Effectivity Formula ID | Surrogate key for the formula. | Formula Cost.Effectivity Formula ID | EFFECTIVITY_FORMULA_ID | EFFECTIVITY_FORMULA_ID | 131322 |
| Effectivity Formula Use | The purpose for which the formula/routing can be used. 0=Production, 1=Planning, 2=Costing, 3=MSDS. | Formula Cost.Effectivity Formula Use | EFFECTIVITY_FORMULA_USE | EFFECTIVITY_FORMULA_USE | 131324 |
| Effectivity Formula Use Meaning | The purpose for which the formula/routing can be used. 0=Production, 1=Planning, 2=Costing, 3=MSDS. | Formula Cost.Effectivity Formula Use Meaning | EFF_FORMULA_USE_MEANING | EFF_FORMULA_USE_MEANING | 131338 |
| Effectivity Item ID | Surrogate key for the item which is produced by the formula. | Formula Cost.Effectivity Item ID | EFFECTIVITY_ITEM_ID | EFFECTIVITY_ITEM_ID | 131326 |
| Effectivity Preference | Preference indicator used by Planning to select which effectiviity to use if more than one meets the requirements. | Formula Cost.Effectivity Preference | EFFECTIVITY_PREFERENCE | EFFECTIVITY_PREFERENCE | 131328 |
| Effectivity Start Date | The start date of the effectivity. | Formula Cost.Effectivity Start Date | EFFECTIVITY_START_DATE | EFFECTIVITY_START_DATE | 131330 |
| Formula Class | | Formula Cost.Formula Class | FORMULA_CLASS | FORMULA_CLASS | 134540 |
| Formula Comment | | Formula Cost.Formula Comment | FORMULA_DESC2 | FORMULA_DESC2 | 134556 |
| Formula Control Class | Not currently used. | Formula Cost.Formula Control Class | FORMULA_CONTROL_CLASS | FORMULA_CONTROL_CLASS | 134545 |
| Formula Description | | Formula Cost.Formula Description | FORMULA_DESC1 | FORMULA_DESC1 | 134551 |
| Formula Efectivity ID | Surrogate key for this effectivity row. | Formula Cost.Formula Efectivity ID | FORMULA_EFECTIVITY_ID | FORMULA_EFECTIVITY_ID | 134560 |
| Formula ID | Surrogate for formula. | Formula Cost.Formula ID | FORMULA_ID | FORMULA_ID | 134579 |
| Formula Number | Alphanumeric formula name or number. | Formula Cost.Formula Number | FORMULA_NO | FORMULA_NO | 134596 |
| Formula Type | 0=standard formula; 1=packaged item formula (these are not currently used). | Formula Cost.Formula Type | FORMULA_TYPE | FORMULA_TYPE | 134612 |
| Formula Version | | Formula Cost.Formula Version | FORMULA_VERSION | FORMULA_VERSION | 134632 |
| Formule Type Meaning | 0=Standard formula; 1=packaged item formula (these are not currently used). | Formula Cost.Formule Type Meaning | FORMULE_TYPE_MEANING | FORMULE_TYPE_MEANING | 134640 |
| Last Update Date | | Formula Cost.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 141142 |
| Last Updated By | | Formula Cost.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139768 |
| Ledger Component Cost | Ingredient/byproduct Component cost | Formula Cost.Ledger Component Cost | LEDGER_COMPONENT_COST | LEDGER_COMPONENT_COST | 141741 |
| Ledger Cost allocation | Cost allocation percentage - The percentage of the ingredient costs that contribute towards the Product cost | Formula Cost.Ledger Cost allocation | LEDGER_COST_ALLOC | LEDGER_COST_ALLOC | 141742 |
| Ledger Item Description | Short description of the item that is displayed during the item look up. | Formula Cost.Ledger Item Description | LEDGER_ITEM_DESCRIPTION | LEDGER_ITEM_DESCRIPTION | 141772 |
| Ledger Item Formula Quantity | Ingredient/byproduct quantity at formula UOM | Formula Cost.Ledger Item Formula Quantity | LEDGER_ITEM_FMQTY | LEDGER_ITEM_FMQTY | 141773 |
| Ledger Item Formula UOM | Ingredient/byproduct formula UOM | Formula Cost.Ledger Item Formula UOM | LEDGER_ITEM_FMQTY_UM | LEDGER_ITEM_FMQTY_UM | 141774 |
| Ledger Item ID | Surrogate for the ingedient/byproduct | Formula Cost.Ledger Item ID | LEDGER_ITEM_ID | LEDGER_ITEM_ID | 141775 |
| Ledger Item Number | Name of the item. | Formula Cost.Ledger Item Number | LEDGER_ITEM_NUMBER | LEDGER_ITEM_NUMBER | 141776 |
| Ledger Item Quantity | Ingredient/byproduct quantity converted to inventory UOM | Formula Cost.Ledger Item Quantity | LEDGER_ITEM_QTY | LEDGER_ITEM_QTY | 141777 |
| Ledger Item Secondary UOM | Second UOM for in which inventory balances are maintained, for dual UOM items. | Formula Cost.Ledger Item Secondary UOM | LEDGER_ITEM_UOM2 | LEDGER_ITEM_UOM2 | 141779 |
| Ledger Item UOM | Uom of the item by which the inventory balances are maintained. | Formula Cost.Ledger Item UOM | LEDGER_ITEM_UOM | LEDGER_ITEM_UOM | 141778 |
| Ledger Line Type | Type of line 1=ingredient, -1=byproduct | Formula Cost.Ledger Line Type | LEDGER_LINE_TYPE | LEDGER_LINE_TYPE | 141781 |
| Ledger Line Type Meaning | Type of line 1=ingredient, -1=byproduct | Formula Cost.Ledger Line Type Meaning | LEDGER_LINE_TYPE_MEANING | LEDGER_LINE_TYPE_MEANING | 141782 |
| Ledger Nominal Cost | Nominal cost for the resource at usage UOM | Formula Cost.Ledger Nominal Cost | LEDGER_NOMINAL_COST | LEDGER_NOMINAL_COST | 141784 |
| Ledger Product Formula UOM | UOM of the product within the formula | Formula Cost.Ledger Product Formula UOM | LEDGER_FORM_PROD_UOM | LEDGER_FORM_PROD_UOM | 141744 |
| Ledger Product Quantity | Product qty converted to product inventory UOM | Formula Cost.Ledger Product Quantity | LEDGER_PRODUCT_QTY | LEDGER_PRODUCT_QTY | 141785 |
| Ledger Resource Count | Resource count from the operation details | Formula Cost.Ledger Resource Count | LEDGER_RESOURCE_COUNT | LEDGER_RESOURCE_COUNT | 141787 |
| Ledger Resource Usage | Resource usage from the operation details | Formula Cost.Ledger Resource Usage | LEDGER_RESOURCE_USAGE | LEDGER_RESOURCE_USAGE | 141788 |
| Ledger Resources | Resource | Formula Cost.Ledger Resources | LEDGER_RESOURCES | LEDGER_RESOURCES | 141786 |
| Ledger Rollup Detail ID | Surrogate for this row | Formula Cost.Ledger Rollup Detail ID | LEDGER_RUDTL_ID | LEDGER_RUDTL_ID | 141790 |
| Ledger Routing Quantity | Routing quantity converted to product inventory UOM | Formula Cost.Ledger Routing Quantity | LEDGER_ROUTING_QTY | LEDGER_ROUTING_QTY | 141789 |
| Ledger Standard Quantity | Effectivity standard quantity converted to an item inventory UOM. | Formula Cost.Ledger Standard Quantity | LEDGER_STD_QTY | LEDGER_STD_QTY | 141791 |
| Ledger Usage UOM | Standard resource uom | Formula Cost.Ledger Usage UOM | LEDGER_USAGE_UOM | LEDGER_USAGE_UOM | 141792 |
| Ledger Warehouse Code | Warehouse code | Formula Cost.Ledger Warehouse Code | LEDGER_WHSE_CODE | LEDGER_WHSE_CODE | 141793 |
| Maximum Output Quantity in Effectivity UOM | The maximum qty for which this effectivity can be used, expressed in the Effectivity UOM. | Formula Cost.Maximum Output Quantity in Effectivity UOM | MAX_OUTPUT_QTY_EFF_UOM | MAX_OUTPUT_QTY_EFF_UOM | 146463 |
| Maximum Output Quantity in Primary UOM | The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item. | Formula Cost.Maximum Output Quantity in Primary UOM | MAX_OUTPUT_QTY_PRIMARY_UOM | MAX_OUTPUT_QTY_PRIMARY_UOM | 146465 |
| Minimum Output Quantity in Effectivity UOM | The minimum qty for which this effectivity can be used, expressed in the Effectivity UOM. | Formula Cost.Minimum Output Quantity in Effectivity UOM | MIN_OUTPUT_QTY_EFF_UOM | MIN_OUTPUT_QTY_EFF_UOM | 147193 |
| Minimum Output Quantity in Primary UOM | The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item. | Formula Cost.Minimum Output Quantity in Primary UOM | MIN_OUTPUT_QTY_PRIMARY_UOM | MIN_OUTPUT_QTY_PRIMARY_UOM | 147195 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Formula Cost.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150188 |
| Period Code | Costing period code. | Formula Cost.Period Code | PERIOD_CODE | PERIOD_CODE | 153011 |
| Period Description | Costing Period Description | Formula Cost.Period Description | PERIOD_DESCRIPTION | PERIOD_DESCRIPTION | 153036 |
| Primary Component Class ID | Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. Default is Primary Class. | Formula Cost.Primary Component Class ID | PRIMARY_COMPONENT_CLASS_ID | PRIMARY_COMPONENT_CLASS_ID | 155474 |
| Product Comment | Short description of the item that is not displayed during the item look up. | Formula Cost.Product Comment | PRODUCT_DESC2 | PRODUCT_DESC2 | 155886 |
| Product Cost Indicator | This field indicates whether the component class will affect the cost of a product or not. Valid values are: 0 = Not a product cost , 1 = Product Cost. | Formula Cost.Product Cost Indicator | PRODUCT_COST_IND | PRODUCT_COST_IND | 155879 |
| Product Description | Short description of the item that is displayed during the item look up. | Formula Cost.Product Description | PRODUCT_DESC1 | PRODUCT_DESC1 | 155882 |
| Product Item Number | Name of the item. | Formula Cost.Product Item Number | PRODUCT_ITEM_NO | PRODUCT_ITEM_NO | 155934 |
| Product Primary UOM | UOM of the item by which the inventory balances are maintained. | Formula Cost.Product Primary UOM | PRODUCT_PRIMARY_UOM | PRODUCT_PRIMARY_UOM | 155983 |
| Product Quantity | Standard batch size | Formula Cost.Product Quantity | PRODUCT_QTY | PRODUCT_QTY | 155986 |
| Product Secondary UOM | Second UOM for in which inventory balances are maintained, for dual UOM items. | Formula Cost.Product Secondary UOM | PRODUCT_SECONDARY_UOM | PRODUCT_SECONDARY_UOM | 155991 |
| Product UOM | | Formula Cost.Product UOM | PRODUCT_UOM | PRODUCT_UOM | 156028 |
| Purchase Price Variance Indicator | Purchase Price Variance calculations should use this component cost if it is set to 1. | Formula Cost.Purchase Price Variance Indicator | PPV_IND | PPV_IND | 155124 |
| Raw Material Cost Calculation Type | Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI | Formula Cost.Raw Material Cost Calculation Type | RMCALC_TYPE | RMCALC_TYPE | 159622 |
| Reference number of the Cost Rollup | Reference number of the Cost Rollup process that calculated this cost | Formula Cost.Reference number of the Cost Rollup | ROLLUP_REF_NO | ROLLUP_REF_NO | 159760 |
| Rollover Indicator | Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated. | Formula Cost.Rollover Indicator | ROLLOVER_INDICATOR | ROLLOVER_INDICATOR | 159742 |
| Routing Class | User defined class for routings. | Formula Cost.Routing Class | ROUTING_CLASS | ROUTING_CLASS | 159802 |
| Routing Description | | Formula Cost.Routing Description | ROUTING_DESCRIPTION | ROUTING_DESCRIPTION | 159807 |
| Routing Id | | Formula Cost.Routing Id | ROUTING_ID | ROUTING_ID | 159813 |
| Routing Item UOM | Uom of routing qty. | Formula Cost.Routing Item UOM | ROUTING_ITEM_UOM | ROUTING_ITEM_UOM | 159822 |
| Routing Number | Routing name. | Formula Cost.Routing Number | ROUTING_NO | ROUTING_NO | 159828 |
| Routing Quantity | Used in ratio with formula and batch qty to scale individual step requirements. | Formula Cost.Routing Quantity | ROUTING_QTY | ROUTING_QTY | 159842 |
| Routing Version | | Formula Cost.Routing Version | ROUTING_VERSION | ROUTING_VERSION | 159868 |
| Scale Type | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. | Formula Cost.Scale Type | SCALE_TYPE | SCALE_TYPE | 160769 |
| Sort Sequence | Sequence the component costs are sorted by on Cost details screen | Formula Cost.Sort Sequence | SORT_SEQUENCE | SORT_SEQUENCE | 162306 |
| Update Cost Indicator | This field indicates whether the component cost will be updated to the GL area. Valid Values are 0 = Do not update to GL area, 1 = Update to GL Area. | Formula Cost.Update Cost Indicator | UPDATE_COST_IND | UPDATE_COST_IND | 166579 |
| Usage Indicator | Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment | Formula Cost.Usage Indicator | USAGE_IND | USAGE_IND | 166627 |
| Warehouse Code | Warehouse from which the item was taken. | Formula Cost.Warehouse Code | WHSE_CODE | WHSE_CODE | 167772 |
| Warehouse Name | Name of the warehouse. | Formula Cost.Warehouse Name | WHSE_NAME | WHSE_NAME | 167786 |