| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Activity Adds Value Flag | | Manufacturing Activities.Activity Adds Value Flag | ACTIVITY_ADDS_VALUE_FLAG | ACTIVITY_ADDS_VALUE_FLAG | 114636 |
| Activity Id | Activity Id. Repetitive tasks performed within an organisation. | Manufacturing Activities.Activity Id | ACTIVITY_ID | ACTIVITY_ID | 114720 |
| Activity Measure Unit | | Manufacturing Activities.Activity Measure Unit | ACTIVITY_MEASURE_UNIT | ACTIVITY_MEASURE_UNIT | 114731 |
| Activity Name | The name of the course taught in the training class. | Manufacturing Activities.Activity Name | ACTIVITY_NAME | ACTIVITY_NAME | 114764 |
| Created By | Standard Who column. | Manufacturing Activities.Created By | CREATED_BY | CREATED_BY | 124741 |
| Created Date | | Manufacturing Activities.Created Date | CREATED_DATE | CREATED_DATE | 125374 |
| Created Date - Day | | Manufacturing Activities.Created Date | | CREATED_DATE_DAY | 171181 |
| Created Date - Month | | Manufacturing Activities.Created Date | | CREATED_DATE_MONTH | 171335 |
| Created Date - Quarter | | Manufacturing Activities.Created Date | | CREATED_DATE_QUARTER | 171489 |
| Created Date - Year | | Manufacturing Activities.Created Date | | CREATED_DATE_YEAR | 171643 |
| Default Basis Type | | Manufacturing Activities.Default Basis Type | DEFAULT_BASIS_TYPE | DEFAULT_BASIS_TYPE | 273492 |
| Description | The accounting period description. | Manufacturing Activities.Description | DESCRIPTION | DESCRIPTION | 129624 |
| Inactive Date | Date on which bank account becomes inactive. | Manufacturing Activities.Inactive Date | INACTIVE_DATE | INACTIVE_DATE | 136197 |
| Inactive Date - Day | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_DAY | 181177 |
| Inactive Date - Month | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_MONTH | 181247 |
| Inactive Date - Quarter | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_QUARTER | 181317 |
| Inactive Date - Year | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_YEAR | 181387 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Manufacturing Activities.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150112 |
| Organization Id | | Manufacturing Activities.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150369 |
| Organization Name | | Manufacturing Activities.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150671 |
| Updated By | | Manufacturing Activities.Updated By | UPDATED_BY | UPDATED_BY | 166495 |
| Updated Date | | Manufacturing Activities.Updated Date | UPDATED_DATE | UPDATED_DATE | 166531 |
| Updated Date - Day | | Manufacturing Activities.Updated Date | | UPDATED_DATE_DAY | 192689 |
| Updated Date - Month | | Manufacturing Activities.Updated Date | | UPDATED_DATE_MONTH | 192705 |
| Updated Date - Quarter | | Manufacturing Activities.Updated Date | | UPDATED_DATE_QUARTER | 192721 |
| Updated Date - Year | | Manufacturing Activities.Updated Date | | UPDATED_DATE_YEAR | 192737 |
| Activity Adds Value Flag | | Manufacturing Activities.Activity Adds Value Flag | ACTIVITY_ADDS_VALUE_FLAG | ACTIVITY_ADDS_VALUE_FLAG | 114636 |
| Activity Id | Activity Id. Repetitive tasks performed within an organisation. | Manufacturing Activities.Activity Id | ACTIVITY_ID | ACTIVITY_ID | 114720 |
| Activity Measure Unit | | Manufacturing Activities.Activity Measure Unit | ACTIVITY_MEASURE_UNIT | ACTIVITY_MEASURE_UNIT | 114731 |
| Activity Name | The name of the course taught in the training class. | Manufacturing Activities.Activity Name | ACTIVITY_NAME | ACTIVITY_NAME | 114764 |
| Created By | Standard Who column. | Manufacturing Activities.Created By | CREATED_BY | CREATED_BY | 124741 |
| Created Date | | Manufacturing Activities.Created Date | CREATED_DATE | CREATED_DATE | 125374 |
| Created Date - Day | | Manufacturing Activities.Created Date | | CREATED_DATE_DAY | 171181 |
| Created Date - Month | | Manufacturing Activities.Created Date | | CREATED_DATE_MONTH | 171335 |
| Created Date - Quarter | | Manufacturing Activities.Created Date | | CREATED_DATE_QUARTER | 171489 |
| Created Date - Year | | Manufacturing Activities.Created Date | | CREATED_DATE_YEAR | 171643 |
| Default Basis Type | | Manufacturing Activities.Default Basis Type | DEFAULT_BASIS_TYPE | DEFAULT_BASIS_TYPE | 273492 |
| Description | The accounting period description. | Manufacturing Activities.Description | DESCRIPTION | DESCRIPTION | 129624 |
| Inactive Date | Date on which bank account becomes inactive. | Manufacturing Activities.Inactive Date | INACTIVE_DATE | INACTIVE_DATE | 136197 |
| Inactive Date - Day | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_DAY | 181177 |
| Inactive Date - Month | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_MONTH | 181247 |
| Inactive Date - Quarter | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_QUARTER | 181317 |
| Inactive Date - Year | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_YEAR | 181387 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Manufacturing Activities.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150112 |
| Organization Id | | Manufacturing Activities.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150369 |
| Organization Name | | Manufacturing Activities.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150671 |
| Updated By | | Manufacturing Activities.Updated By | UPDATED_BY | UPDATED_BY | 166495 |
| Updated Date | | Manufacturing Activities.Updated Date | UPDATED_DATE | UPDATED_DATE | 166531 |
| Updated Date - Day | | Manufacturing Activities.Updated Date | | UPDATED_DATE_DAY | 192689 |
| Updated Date - Month | | Manufacturing Activities.Updated Date | | UPDATED_DATE_MONTH | 192705 |
| Updated Date - Quarter | | Manufacturing Activities.Updated Date | | UPDATED_DATE_QUARTER | 192721 |
| Updated Date - Year | | Manufacturing Activities.Updated Date | | UPDATED_DATE_YEAR | 192737 |
| Activity Adds Value Flag | | Manufacturing Activities.Activity Adds Value Flag | ACTIVITY_ADDS_VALUE_FLAG | ACTIVITY_ADDS_VALUE_FLAG | 114636 |
| Activity Id | Activity Id. Repetitive tasks performed within an organisation. | Manufacturing Activities.Activity Id | ACTIVITY_ID | ACTIVITY_ID | 114720 |
| Activity Measure Unit | | Manufacturing Activities.Activity Measure Unit | ACTIVITY_MEASURE_UNIT | ACTIVITY_MEASURE_UNIT | 114731 |
| Activity Name | The name of the course taught in the training class. | Manufacturing Activities.Activity Name | ACTIVITY_NAME | ACTIVITY_NAME | 114764 |
| Created By | Standard Who column. | Manufacturing Activities.Created By | CREATED_BY | CREATED_BY | 124741 |
| Created Date | | Manufacturing Activities.Created Date | CREATED_DATE | CREATED_DATE | 125374 |
| Created Date - Day | | Manufacturing Activities.Created Date | | CREATED_DATE_DAY | 171181 |
| Created Date - Month | | Manufacturing Activities.Created Date | | CREATED_DATE_MONTH | 171335 |
| Created Date - Quarter | | Manufacturing Activities.Created Date | | CREATED_DATE_QUARTER | 171489 |
| Created Date - Year | | Manufacturing Activities.Created Date | | CREATED_DATE_YEAR | 171643 |
| Default Basis Type | | Manufacturing Activities.Default Basis Type | DEFAULT_BASIS_TYPE | DEFAULT_BASIS_TYPE | 273492 |
| Description | The accounting period description. | Manufacturing Activities.Description | DESCRIPTION | DESCRIPTION | 129624 |
| Inactive Date | Date on which bank account becomes inactive. | Manufacturing Activities.Inactive Date | INACTIVE_DATE | INACTIVE_DATE | 136197 |
| Inactive Date - Day | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_DAY | 181177 |
| Inactive Date - Month | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_MONTH | 181247 |
| Inactive Date - Quarter | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_QUARTER | 181317 |
| Inactive Date - Year | | Manufacturing Activities.Inactive Date | | INACTIVE_DATE_YEAR | 181387 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Manufacturing Activities.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150112 |
| Organization Id | | Manufacturing Activities.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150369 |
| Organization Name | | Manufacturing Activities.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150671 |
| Updated By | | Manufacturing Activities.Updated By | UPDATED_BY | UPDATED_BY | 166495 |
| Updated Date | | Manufacturing Activities.Updated Date | UPDATED_DATE | UPDATED_DATE | 166531 |
| Updated Date - Day | | Manufacturing Activities.Updated Date | | UPDATED_DATE_DAY | 192689 |
| Updated Date - Month | | Manufacturing Activities.Updated Date | | UPDATED_DATE_MONTH | 192705 |
| Updated Date - Quarter | | Manufacturing Activities.Updated Date | | UPDATED_DATE_QUARTER | 192721 |
| Updated Date - Year | | Manufacturing Activities.Updated Date | | UPDATED_DATE_YEAR | 192737 |
| Join Name | Join Condition | Join Details | Optional Join Configuration | Auto |
| Manufacturing Activities -> Item Unit Cost Details | Manufacturing Activities.Activity Id = Item Unit Cost Details.Activity Id | Always exist in master folder | None | No |
| Manufacturing Activities -> Manufacturing Activity Costs | Manufacturing Activities.Activity Id = Manufacturing Activity Costs.Activity Id | Always exist in master folder | None | No |
| Manufacturing Activities -> Manufacturing Department Overheads | Manufacturing Activities.Activity Id = Manufacturing Department Overheads.Activity Id | Always exist in master folder | None | No |
| Manufacturing Activities -> Manufacturing Resource Transactions | Manufacturing Activities.Activity Id = Manufacturing Resource Transactions.Activity Id | Might not exist in master folder | Outer join on master
| No |
| Manufacturing Activities -> Manufacturing Transaction Distributions | Manufacturing Activities.Activity Id = Manufacturing Transaction Distributions.Activity Id | Always exist in master folder | None | No |
| Manufacturing Activities -> Manufacturing Transactions | Manufacturing Activities.Activity Id = Manufacturing Transactions.Activity Id | Might not exist in master folder | Outer join on master
| No |
| Manufacturing Activities -> Material Cost Sub Elements | Manufacturing Activities.Activity Id = Material Cost Sub Elements.Default Activity Id | Always exist in master folder | None | No |
| Manufacturing Activities -> Material Overhead Cost Sub Elements | Manufacturing Activities.Activity Id = Material Overhead Cost Sub Elements.Default Activity Id | Always exist in master folder | None | No |
| Manufacturing Activities -> Material Transaction Distributions | Manufacturing Activities.Activity Id = Material Transaction Distributions.Activity Id | Always exist in master folder | None | No |
| Manufacturing Activities -> Outside Processing Mfg Transactions | Manufacturing Activities.Activity Id = Outside Processing Manufacturing Transactions.Activity Id | Might not exist in master folder | Outer join on master
| No |
| Manufacturing Activities -> Routing Overhead Cost Sub Elements | Manufacturing Activities.Activity Id = Routing Overhead Cost Sub Elements.Default Activity Id | Always exist in master folder | None | No |
| Manufacturing Activities -> Wip Operation Resources | Manufacturing Activities.Activity Id = Wip Operation Resources.Activity Id | Might not exist in master folder | Outer join on master
| No |