| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Average Cost Variance Account | Average cost variance code combination identifier | Cost Groups.Average Cost Variance Account | AVERAGE_COST_VARIANCE_ACCOUNT | AVERAGE_COST_VARIANCE_ACCOUNT | 118705 |
| Avg Cost Var Acc No | | Cost Groups.Avg Cost Var Acc No | AVG_COST_VAR_ACC_NO | AVG_COST_VAR_ACC_NO | 273453 |
| Cost Group Description | | Cost Groups.Cost Group Description | DESCRIPTION | COST_GROUP_DESCRIPTION | 123686 |
| Cost Group Id | The id of the cost group to which the organization is assigned. | Cost Groups.Cost Group Id | COST_GROUP_ID | COST_GROUP_ID | 123688 |
| Cost Group Name | Name of the Cost Group | Cost Groups.Cost Group Name | COST_GROUP_NAME | COST_GROUP_NAME | 123699 |
| Cost Group Type | | Cost Groups.Cost Group Type | COST_GROUP_TYPE | COST_GROUP_TYPE | 273447 |
| Cost Group Type Id | | Cost Groups.Cost Group Type Id | COST_GROUP_TYPE_ID | COST_GROUP_TYPE_ID | 123708 |
| Created By | Standard Who column. | Cost Groups.Created By | CREATED_BY | CREATED_BY | 124730 |
| Creation Date | | Cost Groups.Creation Date | CREATED_DATE | CREATION_DATE | 126168 |
| Creation Date - Day | | Cost Groups.Creation Date | | CREATION_DATE_DAY | 172327 |
| Creation Date - Month | | Cost Groups.Creation Date | | CREATION_DATE_MONTH | 172781 |
| Creation Date - Quarter | | Cost Groups.Creation Date | | CREATION_DATE_QUARTER | 173235 |
| Creation Date - Year | | Cost Groups.Creation Date | | CREATION_DATE_YEAR | 173689 |
| Disable Date | | Cost Groups.Disable Date | DISABLE_DATE | DISABLE_DATE | 130124 |
| Disable Date - Day | | Cost Groups.Disable Date | | DISABLE_DATE_DAY | 176167 |
| Disable Date - Month | | Cost Groups.Disable Date | | DISABLE_DATE_MONTH | 176189 |
| Disable Date - Quarter | | Cost Groups.Disable Date | | DISABLE_DATE_QUARTER | 176211 |
| Disable Date - Year | | Cost Groups.Disable Date | | DISABLE_DATE_YEAR | 176233 |
| Encumbrance Acc No | | Cost Groups.Encumbrance Acc No | ENCUMBRANCE_ACC_NO | ENCUMBRANCE_ACC_NO | 273454 |
| Encumbrance Account | Encumberance account code combination identifier | Cost Groups.Encumbrance Account | ENCUMBRANCE_ACCOUNT | ENCUMBRANCE_ACCOUNT | 132688 |
| Last Updated Date | | Cost Groups.Last Updated Date | UPDATED_DATE | LAST_UPDATED_DATE | 139951 |
| Last Updated Date - Day | | Cost Groups.Last Updated Date | | LAST_UPDATED_DATE_DAY | 182852 |
| Last Updated Date - Month | | Cost Groups.Last Updated Date | | LAST_UPDATED_DATE_MONTH | 183014 |
| Last Updated Date - Quarter | | Cost Groups.Last Updated Date | | LAST_UPDATED_DATE_QUARTER | 183176 |
| Last Updated Date - Year | | Cost Groups.Last Updated Date | | LAST_UPDATED_DATE_YEAR | 183338 |
| Legal Entity | | Cost Groups.Legal Entity | LEGAL_ENTITY | LEGAL_ENTITY | 141801 |
| Legal Entity Name | | Cost Groups.Legal Entity Name | LEGAL_ENTITY_NAME | LEGAL_ENTITY_NAME | 141813 |
| Material Account | Inventory material account code combination identifier | Cost Groups.Material Account | MATERIAL_ACCOUNT | MATERIAL_ACCOUNT | 146340 |
| Material Overhead Account | Inventory material overheadaccount code combination identifier | Cost Groups.Material Overhead Account | MATERIAL_OVERHEAD_ACCOUNT | MATERIAL_OVERHEAD_ACCOUNT | 146355 |
| Matl Acc No | | Cost Groups.Matl Acc No | MATL_ACC_NO | MATL_ACC_NO | 273448 |
| Mtl Overhead Acc No | | Cost Groups.Mtl Overhead Acc No | MTL_OVERHEAD_ACC_NO | MTL_OVERHEAD_ACC_NO | 273449 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Cost Groups.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150102 |
| Organization Id | | Cost Groups.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150360 |
| Organization Name | | Cost Groups.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150661 |
| Outside Processing Account | Outside processing account code combination identifier | Cost Groups.Outside Processing Account | OUTSIDE_PROCESSING_ACCOUNT | OUTSIDE_PROCESSING_ACCOUNT | 151649 |
| Outside Procs Acc No | | Cost Groups.Outside Procs Acc No | OUTSIDE_PROCS_ACC_NO | OUTSIDE_PROCS_ACC_NO | 273452 |
| Overhead Acc No | | Cost Groups.Overhead Acc No | OVERHEAD_ACC_NO | OVERHEAD_ACC_NO | 273451 |
| Overhead Account | Inventory overhead account code combination identifier | Cost Groups.Overhead Account | OVERHEAD_ACCOUNT | OVERHEAD_ACCOUNT | 151687 |
| Payback Material Overhead Variance Account | | Cost Groups.Payback Material Overhead Variance Account | PAYBACK_MOH_VAR_ACCOUNT | PAYBACK_MOH_VAR_ACCOUNT | 152111 |
| Payback Material Variance Account | | Cost Groups.Payback Material Variance Account | PAYBACK_MAT_VAR_ACCOUNT | PAYBACK_MAT_VAR_ACCOUNT | 152110 |
| Payback Outside Processing Variance Account | | Cost Groups.Payback Outside Processing Variance Account | PAYBACK_OSP_VAR_ACCOUNT | PAYBACK_OSP_VAR_ACCOUNT | 152112 |
| Payback Overhead Variance Account | | Cost Groups.Payback Overhead Variance Account | PAYBACK_OVH_VAR_ACCOUNT | PAYBACK_OVH_VAR_ACCOUNT | 152113 |
| Payback Resource Variance Account | | Cost Groups.Payback Resource Variance Account | PAYBACK_RES_VAR_ACCOUNT | PAYBACK_RES_VAR_ACCOUNT | 152114 |
| Paybk Mat Var Acc No | | Cost Groups.Paybk Mat Var Acc No | PAYBK_MAT_VAR_ACC_NO | PAYBK_MAT_VAR_ACC_NO | 273455 |
| Paybk Moh Var Acc No | | Cost Groups.Paybk Moh Var Acc No | PAYBK_MOH_VAR_ACC_NO | PAYBK_MOH_VAR_ACC_NO | 273458 |
| Paybk Osp Var Acc No | | Cost Groups.Paybk Osp Var Acc No | PAYBK_OSP_VAR_ACC_NO | PAYBK_OSP_VAR_ACC_NO | 273457 |
| Paybk Ovh Var Acc No | | Cost Groups.Paybk Ovh Var Acc No | PAYBK_OVH_VAR_ACC_NO | PAYBK_OVH_VAR_ACC_NO | 273459 |
| Paybk Res Var Acc No | | Cost Groups.Paybk Res Var Acc No | PAYBK_RES_VAR_ACC_NO | PAYBK_RES_VAR_ACC_NO | 273456 |
| Resource Acc No | | Cost Groups.Resource Acc No | RESOURCE_ACC_NO | RESOURCE_ACC_NO | 273450 |
| Resource Account | Resource labor account code combination identifier | Cost Groups.Resource Account | RESOURCE_ACCOUNT | RESOURCE_ACCOUNT | 158916 |
| Updated By | | Cost Groups.Updated By | UPDATED_BY | UPDATED_BY | 166489 |
| Average Cost Variance Account | Average cost variance code combination identifier | Cost Groups.Average Cost Variance Account | AVERAGE_COST_VARIANCE_ACCOUNT | AVERAGE_COST_VARIANCE_ACCOUNT | 118705 |
| Avg Cost Var Acc No | | Cost Groups.Avg Cost Var Acc No | AVG_COST_VAR_ACC_NO | AVG_COST_VAR_ACC_NO | 273453 |
| Cost Group Description | | Cost Groups.Cost Group Description | DESCRIPTION | COST_GROUP_DESCRIPTION | 123686 |
| Cost Group Id | The id of the cost group to which the organization is assigned. | Cost Groups.Cost Group Id | COST_GROUP_ID | COST_GROUP_ID | 123688 |
| Cost Group Name | Name of the Cost Group | Cost Groups.Cost Group Name | COST_GROUP_NAME | COST_GROUP_NAME | 123699 |
| Cost Group Type | | Cost Groups.Cost Group Type | COST_GROUP_TYPE | COST_GROUP_TYPE | 273447 |
| Cost Group Type Id | | Cost Groups.Cost Group Type Id | COST_GROUP_TYPE_ID | COST_GROUP_TYPE_ID | 123708 |
| Created By | Standard Who column. | Cost Groups.Created By | CREATED_BY | CREATED_BY | 124730 |
| Creation Date | | Cost Groups.Creation Date | CREATED_DATE | CREATION_DATE | 126168 |
| Creation Date - Day | | Cost Groups.Creation Date | | CREATION_DATE_DAY | 172327 |
| Creation Date - Month | | Cost Groups.Creation Date | | CREATION_DATE_MONTH | 172781 |
| Creation Date - Quarter | | Cost Groups.Creation Date | | CREATION_DATE_QUARTER | 173235 |
| Creation Date - Year | | Cost Groups.Creation Date | | CREATION_DATE_YEAR | 173689 |
| Disable Date | | Cost Groups.Disable Date | DISABLE_DATE | DISABLE_DATE | 130124 |
| Disable Date - Day | | Cost Groups.Disable Date | | DISABLE_DATE_DAY | 176167 |
| Disable Date - Month | | Cost Groups.Disable Date | | DISABLE_DATE_MONTH | 176189 |
| Disable Date - Quarter | | Cost Groups.Disable Date | | DISABLE_DATE_QUARTER | 176211 |
| Disable Date - Year | | Cost Groups.Disable Date | | DISABLE_DATE_YEAR | 176233 |
| Encumbrance Acc No | | Cost Groups.Encumbrance Acc No | ENCUMBRANCE_ACC_NO | ENCUMBRANCE_ACC_NO | 273454 |
| Encumbrance Account | Encumberance account code combination identifier | Cost Groups.Encumbrance Account | ENCUMBRANCE_ACCOUNT | ENCUMBRANCE_ACCOUNT | 132688 |
| Last Updated Date | | Cost Groups.Last Updated Date | UPDATED_DATE | LAST_UPDATED_DATE | 139951 |
| Last Updated Date - Day | | Cost Groups.Last Updated Date | | LAST_UPDATED_DATE_DAY | 182852 |
| Last Updated Date - Month | | Cost Groups.Last Updated Date | | LAST_UPDATED_DATE_MONTH | 183014 |
| Last Updated Date - Quarter | | Cost Groups.Last Updated Date | | LAST_UPDATED_DATE_QUARTER | 183176 |
| Last Updated Date - Year | | Cost Groups.Last Updated Date | | LAST_UPDATED_DATE_YEAR | 183338 |
| Legal Entity | | Cost Groups.Legal Entity | LEGAL_ENTITY | LEGAL_ENTITY | 141801 |
| Legal Entity Name | | Cost Groups.Legal Entity Name | LEGAL_ENTITY_NAME | LEGAL_ENTITY_NAME | 141813 |
| Material Account | Inventory material account code combination identifier | Cost Groups.Material Account | MATERIAL_ACCOUNT | MATERIAL_ACCOUNT | 146340 |
| Material Overhead Account | Inventory material overheadaccount code combination identifier | Cost Groups.Material Overhead Account | MATERIAL_OVERHEAD_ACCOUNT | MATERIAL_OVERHEAD_ACCOUNT | 146355 |
| Matl Acc No | | Cost Groups.Matl Acc No | MATL_ACC_NO | MATL_ACC_NO | 273448 |
| Mtl Overhead Acc No | | Cost Groups.Mtl Overhead Acc No | MTL_OVERHEAD_ACC_NO | MTL_OVERHEAD_ACC_NO | 273449 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Cost Groups.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150102 |
| Organization Id | | Cost Groups.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150360 |
| Organization Name | | Cost Groups.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150661 |
| Outside Processing Account | Outside processing account code combination identifier | Cost Groups.Outside Processing Account | OUTSIDE_PROCESSING_ACCOUNT | OUTSIDE_PROCESSING_ACCOUNT | 151649 |
| Outside Procs Acc No | | Cost Groups.Outside Procs Acc No | OUTSIDE_PROCS_ACC_NO | OUTSIDE_PROCS_ACC_NO | 273452 |
| Overhead Acc No | | Cost Groups.Overhead Acc No | OVERHEAD_ACC_NO | OVERHEAD_ACC_NO | 273451 |
| Overhead Account | Inventory overhead account code combination identifier | Cost Groups.Overhead Account | OVERHEAD_ACCOUNT | OVERHEAD_ACCOUNT | 151687 |
| Payback Material Overhead Variance Account | | Cost Groups.Payback Material Overhead Variance Account | PAYBACK_MOH_VAR_ACCOUNT | PAYBACK_MOH_VAR_ACCOUNT | 152111 |
| Payback Material Variance Account | | Cost Groups.Payback Material Variance Account | PAYBACK_MAT_VAR_ACCOUNT | PAYBACK_MAT_VAR_ACCOUNT | 152110 |
| Payback Outside Processing Variance Account | | Cost Groups.Payback Outside Processing Variance Account | PAYBACK_OSP_VAR_ACCOUNT | PAYBACK_OSP_VAR_ACCOUNT | 152112 |
| Payback Overhead Variance Account | | Cost Groups.Payback Overhead Variance Account | PAYBACK_OVH_VAR_ACCOUNT | PAYBACK_OVH_VAR_ACCOUNT | 152113 |
| Payback Resource Variance Account | | Cost Groups.Payback Resource Variance Account | PAYBACK_RES_VAR_ACCOUNT | PAYBACK_RES_VAR_ACCOUNT | 152114 |
| Paybk Mat Var Acc No | | Cost Groups.Paybk Mat Var Acc No | PAYBK_MAT_VAR_ACC_NO | PAYBK_MAT_VAR_ACC_NO | 273455 |
| Paybk Moh Var Acc No | | Cost Groups.Paybk Moh Var Acc No | PAYBK_MOH_VAR_ACC_NO | PAYBK_MOH_VAR_ACC_NO | 273458 |
| Paybk Osp Var Acc No | | Cost Groups.Paybk Osp Var Acc No | PAYBK_OSP_VAR_ACC_NO | PAYBK_OSP_VAR_ACC_NO | 273457 |
| Paybk Ovh Var Acc No | | Cost Groups.Paybk Ovh Var Acc No | PAYBK_OVH_VAR_ACC_NO | PAYBK_OVH_VAR_ACC_NO | 273459 |
| Paybk Res Var Acc No | | Cost Groups.Paybk Res Var Acc No | PAYBK_RES_VAR_ACC_NO | PAYBK_RES_VAR_ACC_NO | 273456 |
| Resource Acc No | | Cost Groups.Resource Acc No | RESOURCE_ACC_NO | RESOURCE_ACC_NO | 273450 |
| Resource Account | Resource labor account code combination identifier | Cost Groups.Resource Account | RESOURCE_ACCOUNT | RESOURCE_ACCOUNT | 158916 |
| Updated By | | Cost Groups.Updated By | UPDATED_BY | UPDATED_BY | 166489 |
| Join Name | Join Condition | Join Details | Optional Join Configuration | Auto |
| Cost Groups -> Average Item Costs | Cost Groups.Cost Group Id = Average Item Costs.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Cost Group Assignments | Cost Groups.Cost Group Id = Cost Group Assignments.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Period Close Detail Balances | Cost Groups.Cost Group Id = Period Close Detail Balances.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Periodic Actual Costing Layer Quantity | Cost Groups.Cost Group Id = Periodic Actual Costing Layer Quantity.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Periodic Actual Costing Period Balances | Cost Groups.Cost Group Id = Periodic Actual Costing Period Balances.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Periodic Actual Item Cost Details | Cost Groups.Cost Group Id = Periodic Actual Item Cost Details.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Periodic Actual Item Costs | Cost Groups.Cost Group Id = Periodic Actual Item Costs.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Product Line Accounts | Cost Groups.Cost Group Id = Product Line Accounts.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Project Manufacturing Information | Cost Groups.Cost Group Id = Project Manufacturing Information.Cost Group Id | Might not exist in master folder | Outer join on master
| No |
| Cost Groups -> Receiving Acquisition Costs | Cost Groups.Cost Group Id = Receiving Acquisition Costs.Cost Group Id | Always exist in master folder | None | No |
| Cost Groups -> Receiving Acquisiton Cost Details | Cost Groups.Cost Group Id = Receiving Acquisiton Cost Details.Cost Group Id | Always exist in master folder | None | No |