| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Actual Completion Date | | Batch Material.Actual Completion Date | ACTUAL_COMPLETION_DATE | ACTUAL_COMPLETION_DATE | 114857 |
| Actual Quantity | Sum of Transaction Quantity of completed transactions for line, in the batch UOM. | Batch Material.Actual Quantity | ACTUAL_QTY | ACTUAL_QTY | 114899 |
| Actual Quantity in Secondary UOM | Sum of Transaction Quantity of completed transactions for line, in the secondary UOM of an item. | Batch Material.Actual Quantity in Secondary UOM | ACTUAL_QTY2 | ACTUAL_QTY2 | 114901 |
| Actual Start Date | Actual start date/time for this step. | Batch Material.Actual Start Date | ACTUAL_START_DATE | ACTUAL_START_DATE | 114919 |
| Allocation Indicator | Allocation indicator. 0=Not fully allocated, 1=Fully allocated. | Batch Material.Allocation Indicator | ALLOC_IND | ALLOC_IND | 115530 |
| Batch Close Date | Date/time the batch was closed. | Batch Material.Batch Close Date | BATCH_CLOSE_DATE | BATCH_CLOSE_DATE | 119362 |
| Batch ID | Surrogate key for the batch for which results are recorded. | Batch Material.Batch ID | BATCH_ID | BATCH_ID | 119383 |
| Batch Number | Batch or Firm Plan Order number. | Batch Material.Batch Number | BATCH_NUMBER | BATCH_NUMBER | 119412 |
| Batch Status | Batch or Firm Plan Order status. -3=Converted Firm Plan Order, -1=Cancelled,1=Pending; 2=WIP , 3=Certified , 4=Closed. | Batch Material.Batch Status | BATCH_STATUS | BATCH_STATUS | 119422 |
| Batch Status Meaning | Batch or Firm Plan Order status. -3=Converted Firm Plan Order, -1=Cancelled,1=Pending; 2=WIP , 3=Certified, 4=Closed. | Batch Material.Batch Status Meaning | BATCH_STATUS_MEANING | BATCH_STATUS_MEANING | 119427 |
| Batch Type | Differentiates between Firm Planned Order and batches . This Field will have a value of 10 for Firm Planned Order and 0 for regular batches | Batch Material.Batch Type | BATCH_TYPE | BATCH_TYPE | 119430 |
| Cost | Not currently used. | Batch Material.Cost | COST | COST | 123582 |
| Cost Allocation | For products, fraction of cost allocated to this product. | Batch Material.Cost Allocation | COST_ALLOC | COST_ALLOC | 123604 |
| Created By | | Batch Material.Created By | CREATED_BY | CREATED_BY | 125185 |
| Creation Date | | Batch Material.Creation Date | CREATION_DATE | CREATION_DATE | 126612 |
| Due Date | Required batch completion date/time, notational. | Batch Material.Due Date | DUE_DATE | DUE_DATE | 130643 |
| Expect Completion Date | Planned batch completion date/time. | Batch Material.Expect Completion Date | EXPECT_COMPLETION_DATE | EXPECT_COMPLETION_DATE | 133971 |
| Formula Effectivity ID | Surrogate key to the formula effectivity the batch or FPO was based on. | Batch Material.Formula Effectivity ID | FORMULA_EFFECTIVITY_ID | FORMULA_EFFECTIVITY_ID | 134562 |
| Formula ID | Surrogate for formula. | Batch Material.Formula ID | FORMULA_ID | FORMULA_ID | 134577 |
| Formula control Class | Not currently used. | Batch Material.Formula control Class | FMCONTROL_CLASS | FMCONTROL_CLASS | 134457 |
| Formula line ID | Surrogate key for the formula line for which results are recorded. | Batch Material.Formula line ID | FORMULALINE_ID | FORMULALINE_ID | 134535 |
| Item Description | Short description of the item that is displayed during the item look up. | Batch Material.Item Description | ITEM_DESCRIPTION | ITEM_DESCRIPTION | 137737 |
| Item ID | Surrogate key for the item for which results are recorded. | Batch Material.Item ID | ITEM_ID | ITEM_ID | 137773 |
| Item Number | Name of the item. | Batch Material.Item Number | ITEM_NUMBER | ITEM_NUMBER | 137844 |
| Item Secondary UOM | Second UOM for in which inventory balances are maintained, for dual UOM items. | Batch Material.Item Secondary UOM | ITEM_UOM2 | ITEM_UOM2 | 137945 |
| Item UOM | UOM of the item by which the inventory balances are maintained. | Batch Material.Item UOM | ITEM_UOM | ITEM_UOM | 137931 |
| Last Update Date | | Batch Material.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 141139 |
| Last Updated By | | Batch Material.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139765 |
| Line ID | | Batch Material.Line ID | LINE_ID | LINE_ID | 144656 |
| Line Number | Sequential line number for each line type in a batch or Firm Planned Order. | Batch Material.Line Number | LINE_NO | LINE_NO | 144702 |
| Line Type | The type of line : course payment / pre-purchase / delegate etc. | Batch Material.Line Type | LINE_TYPE | LINE_TYPE | 144790 |
| Line Type Meaning | Line type. | Batch Material.Line Type Meaning | LINE_TYPE_MEANING | LINE_TYPE_MEANING | 144803 |
| Parent line ID | For phantom batches. Surrogate key to the batch ingredient line for which this phantom batch produces product. | Batch Material.Parent line ID | PARENTLINE_ID | PARENTLINE_ID | 151851 |
| Phantom ID | For phantoms. Surrogate key of the phantom batch which produces the ingredient. | Batch Material.Phantom ID | PHANTOM_ID | PHANTOM_ID | 153999 |
| Phantom Type | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. | Batch Material.Phantom Type | PHANTOM_TYPE | PHANTOM_TYPE | 154000 |
| Plan Start Date | Planned start date/time for this step. | Batch Material.Plan Start Date | PLAN_START_DATE | PLAN_START_DATE | 154329 |
| Planned Quantity | The quantity that this line was planned to produce or consume, in the batch UOM. | Batch Material.Planned Quantity | PLAN_QTY | PLAN_QTY | 154320 |
| Planned in Secondary UOM | The quantity that this line was planned to produce or consume, in the secondary UOM of an item(for dual UOM items). | Batch Material.Planned in Secondary UOM | PLAN_QTY2 | PLAN_QTY2 | 154322 |
| Plant Code | Production organization. | Batch Material.Plant Code | PLANT_CODE | PLANT_CODE | 154262 |
| Print Count | Number of times batch ticket was printed. | Batch Material.Print Count | PRINT_COUNT | PRINT_COUNT | 155635 |
| Priority Code | Not currently used. | Batch Material.Priority Code | PRIORITY_CODE | PRIORITY_CODE | 155669 |
| Priority Value | Not currently used. | Batch Material.Priority Value | PRIORITY_VALUE | PRIORITY_VALUE | 155672 |
| Production ID | Reserved for future use. | Batch Material.Production ID | PRODUCTION_ID | PRODUCTION_ID | 155850 |
| Production Sequence | Reserved for future use. | Batch Material.Production Sequence | PRODUCTION_SEQUENCE | PRODUCTION_SEQUENCE | 155854 |
| Release Type | Release (or certification) type. 0=Automatic release (certification), 1=Manual release (certification). | Batch Material.Release Type | RELEASE_TYPE | RELEASE_TYPE | 158463 |
| Routing ID | Surrogate key for the routing for which results are recorded. | Batch Material.Routing ID | ROUTING_ID | ROUTING_ID | 159812 |
| Scale Type | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. | Batch Material.Scale Type | SCALE_TYPE | SCALE_TYPE | 160768 |
| Scrap Factor | Scrap factor decimal used to a trans_qty that allows for scrap. | Batch Material.Scrap Factor | SCRAP_FACTOR | SCRAP_FACTOR | 160877 |
| Work in Progress Warehouse Code | Warehouse used to cost production activity. | Batch Material.Work in Progress Warehouse Code | WIP_WAREHOUSEE_CODE | WIP_WAREHOUSEE_CODE | 167894 |