| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Acct Period Id | | Manufacturing Accounting Periods.Acct Period Id | ACCT_PERIOD_ID | ACCT_PERIOD_ID | 114420 |
| Created By | Standard Who column. | Manufacturing Accounting Periods.Created By | CREATED_BY | CREATED_BY | 124740 |
| Created Date | | Manufacturing Accounting Periods.Created Date | CREATED_DATE | CREATED_DATE | 125373 |
| Created Date - Day | | Manufacturing Accounting Periods.Created Date | | CREATED_DATE_DAY | 171179 |
| Created Date - Month | | Manufacturing Accounting Periods.Created Date | | CREATED_DATE_MONTH | 171333 |
| Created Date - Quarter | | Manufacturing Accounting Periods.Created Date | | CREATED_DATE_QUARTER | 171487 |
| Created Date - Year | | Manufacturing Accounting Periods.Created Date | | CREATED_DATE_YEAR | 171641 |
| Open Flag | | Manufacturing Accounting Periods.Open Flag | OPEN_FLAG | OPEN_FLAG | 149478 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Manufacturing Accounting Periods.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150111 |
| Organization Id | | Manufacturing Accounting Periods.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150368 |
| Organization Name | | Manufacturing Accounting Periods.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150670 |
| Period Close Date | | Manufacturing Accounting Periods.Period Close Date | PERIOD_CLOSE_DATE | PERIOD_CLOSE_DATE | 153007 |
| Period Close Date - Day | | Manufacturing Accounting Periods.Period Close Date | | PERIOD_CLOSE_DATE_DAY | 188021 |
| Period Close Date - Month | | Manufacturing Accounting Periods.Period Close Date | | PERIOD_CLOSE_DATE_MONTH | 188025 |
| Period Close Date - Quarter | | Manufacturing Accounting Periods.Period Close Date | | PERIOD_CLOSE_DATE_QUARTER | 188029 |
| Period Close Date - Year | | Manufacturing Accounting Periods.Period Close Date | | PERIOD_CLOSE_DATE_YEAR | 188033 |
| Period Name | The name of an accounting period. | Manufacturing Accounting Periods.Period Name | PERIOD_NAME | PERIOD_NAME | 153126 |
| Period Num | | Manufacturing Accounting Periods.Period Num | PERIOD_NUM | PERIOD_NUM | 153161 |
| Period Set Name | Calendar associated with Set of Books. | Manufacturing Accounting Periods.Period Set Name | PERIOD_SET_NAME | PERIOD_SET_NAME | 153231 |
| Period Start Date | The date on which an accounting period begins. | Manufacturing Accounting Periods.Period Start Date | PERIOD_START_DATE | PERIOD_START_DATE | 153246 |
| Period Start Date - Day | | Manufacturing Accounting Periods.Period Start Date | | PERIOD_START_DATE_DAY | 188103 |
| Period Start Date - Month | | Manufacturing Accounting Periods.Period Start Date | | PERIOD_START_DATE_MONTH | 188109 |
| Period Start Date - Quarter | | Manufacturing Accounting Periods.Period Start Date | | PERIOD_START_DATE_QUARTER | 188115 |
| Period Start Date - Year | | Manufacturing Accounting Periods.Period Start Date | | PERIOD_START_DATE_YEAR | 188121 |
| Period Year | The accounting period year. | Manufacturing Accounting Periods.Period Year | PERIOD_YEAR | PERIOD_YEAR | 153323 |
| Schedule Close Date | | Manufacturing Accounting Periods.Schedule Close Date | SCHEDULE_CLOSE_DATE | SCHEDULE_CLOSE_DATE | 160795 |
| Schedule Close Date - Day | | Manufacturing Accounting Periods.Schedule Close Date | | SCHEDULE_CLOSE_DATE_DAY | 190146 |
| Schedule Close Date - Month | | Manufacturing Accounting Periods.Schedule Close Date | | SCHEDULE_CLOSE_DATE_MONTH | 190148 |
| Schedule Close Date - Quarter | | Manufacturing Accounting Periods.Schedule Close Date | | SCHEDULE_CLOSE_DATE_QUARTER | 190150 |
| Schedule Close Date - Year | | Manufacturing Accounting Periods.Schedule Close Date | | SCHEDULE_CLOSE_DATE_YEAR | 190152 |
| Updated By | | Manufacturing Accounting Periods.Updated By | UPDATED_BY | UPDATED_BY | 166494 |
| Updated Date | | Manufacturing Accounting Periods.Updated Date | UPDATED_DATE | UPDATED_DATE | 166530 |
| Updated Date - Day | | Manufacturing Accounting Periods.Updated Date | | UPDATED_DATE_DAY | 192687 |
| Updated Date - Month | | Manufacturing Accounting Periods.Updated Date | | UPDATED_DATE_MONTH | 192703 |
| Updated Date - Quarter | | Manufacturing Accounting Periods.Updated Date | | UPDATED_DATE_QUARTER | 192719 |
| Updated Date - Year | | Manufacturing Accounting Periods.Updated Date | | UPDATED_DATE_YEAR | 192735 |
| Acct Period Id | | Manufacturing Accounting Periods.Acct Period Id | ACCT_PERIOD_ID | ACCT_PERIOD_ID | 114420 |
| Created By | Standard Who column. | Manufacturing Accounting Periods.Created By | CREATED_BY | CREATED_BY | 124740 |
| Created Date | | Manufacturing Accounting Periods.Created Date | CREATED_DATE | CREATED_DATE | 125373 |
| Created Date - Day | | Manufacturing Accounting Periods.Created Date | | CREATED_DATE_DAY | 171179 |
| Created Date - Month | | Manufacturing Accounting Periods.Created Date | | CREATED_DATE_MONTH | 171333 |
| Created Date - Quarter | | Manufacturing Accounting Periods.Created Date | | CREATED_DATE_QUARTER | 171487 |
| Created Date - Year | | Manufacturing Accounting Periods.Created Date | | CREATED_DATE_YEAR | 171641 |
| Open Flag | | Manufacturing Accounting Periods.Open Flag | OPEN_FLAG | OPEN_FLAG | 149478 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Manufacturing Accounting Periods.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150111 |
| Organization Id | | Manufacturing Accounting Periods.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150368 |
| Organization Name | | Manufacturing Accounting Periods.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150670 |
| Period Close Date | | Manufacturing Accounting Periods.Period Close Date | PERIOD_CLOSE_DATE | PERIOD_CLOSE_DATE | 153007 |
| Period Close Date - Day | | Manufacturing Accounting Periods.Period Close Date | | PERIOD_CLOSE_DATE_DAY | 188021 |
| Period Close Date - Month | | Manufacturing Accounting Periods.Period Close Date | | PERIOD_CLOSE_DATE_MONTH | 188025 |
| Period Close Date - Quarter | | Manufacturing Accounting Periods.Period Close Date | | PERIOD_CLOSE_DATE_QUARTER | 188029 |
| Period Close Date - Year | | Manufacturing Accounting Periods.Period Close Date | | PERIOD_CLOSE_DATE_YEAR | 188033 |
| Period Name | The name of an accounting period. | Manufacturing Accounting Periods.Period Name | PERIOD_NAME | PERIOD_NAME | 153126 |
| Period Num | | Manufacturing Accounting Periods.Period Num | PERIOD_NUM | PERIOD_NUM | 153161 |
| Period Set Name | Calendar associated with Set of Books. | Manufacturing Accounting Periods.Period Set Name | PERIOD_SET_NAME | PERIOD_SET_NAME | 153231 |
| Period Start Date | The date on which an accounting period begins. | Manufacturing Accounting Periods.Period Start Date | PERIOD_START_DATE | PERIOD_START_DATE | 153246 |
| Period Start Date - Day | | Manufacturing Accounting Periods.Period Start Date | | PERIOD_START_DATE_DAY | 188103 |
| Period Start Date - Month | | Manufacturing Accounting Periods.Period Start Date | | PERIOD_START_DATE_MONTH | 188109 |
| Period Start Date - Quarter | | Manufacturing Accounting Periods.Period Start Date | | PERIOD_START_DATE_QUARTER | 188115 |
| Period Start Date - Year | | Manufacturing Accounting Periods.Period Start Date | | PERIOD_START_DATE_YEAR | 188121 |
| Period Year | The accounting period year. | Manufacturing Accounting Periods.Period Year | PERIOD_YEAR | PERIOD_YEAR | 153323 |
| Schedule Close Date | | Manufacturing Accounting Periods.Schedule Close Date | SCHEDULE_CLOSE_DATE | SCHEDULE_CLOSE_DATE | 160795 |
| Schedule Close Date - Day | | Manufacturing Accounting Periods.Schedule Close Date | | SCHEDULE_CLOSE_DATE_DAY | 190146 |
| Schedule Close Date - Month | | Manufacturing Accounting Periods.Schedule Close Date | | SCHEDULE_CLOSE_DATE_MONTH | 190148 |
| Schedule Close Date - Quarter | | Manufacturing Accounting Periods.Schedule Close Date | | SCHEDULE_CLOSE_DATE_QUARTER | 190150 |
| Schedule Close Date - Year | | Manufacturing Accounting Periods.Schedule Close Date | | SCHEDULE_CLOSE_DATE_YEAR | 190152 |
| Updated By | | Manufacturing Accounting Periods.Updated By | UPDATED_BY | UPDATED_BY | 166494 |
| Updated Date | | Manufacturing Accounting Periods.Updated Date | UPDATED_DATE | UPDATED_DATE | 166530 |
| Updated Date - Day | | Manufacturing Accounting Periods.Updated Date | | UPDATED_DATE_DAY | 192687 |
| Updated Date - Month | | Manufacturing Accounting Periods.Updated Date | | UPDATED_DATE_MONTH | 192703 |
| Updated Date - Quarter | | Manufacturing Accounting Periods.Updated Date | | UPDATED_DATE_QUARTER | 192719 |
| Updated Date - Year | | Manufacturing Accounting Periods.Updated Date | | UPDATED_DATE_YEAR | 192735 |
| Join Name | Join Condition | Join Details | Optional Join Configuration | Auto |
| Manufacturing Accounting Periods -> Job Close Variance Transactions | Manufacturing Accounting Periods.Organization Id = Job Close Variance Transactions.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Job Close Variance Transactions.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Manufacturing Cost Update Transactions | Manufacturing Accounting Periods.Organization Id = Manufacturing Cost Update Transactions.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Manufacturing Cost Update Transactions.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Manufacturing GL Batches | Manufacturing Accounting Periods.Organization Id = Manufacturing GL Batches.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Manufacturing GL Batches.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Manufacturing Resource Transactions | Manufacturing Accounting Periods.Organization Id = Manufacturing Resource Transactions.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Manufacturing Resource Transactions.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Manufacturing Transactions | Manufacturing Accounting Periods.Organization Id = Manufacturing Transactions.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Manufacturing Transactions.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Outside Processing Mfg Transactions | Manufacturing Accounting Periods.Organization Id = Outside Processing Manufacturing Transactions.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Outside Processing Manufacturing Transactions.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Overhead Manufacturing Transactions | Manufacturing Accounting Periods.Organization Id = Overhead Manufacturing Transactions.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Overhead Manufacturing Transactions.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Period Close Detail Balances | Manufacturing Accounting Periods.Organization Id = Period Close Detail Balances.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Period Close Detail Balances.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Period Close Summary Balances | Manufacturing Accounting Periods.Organization Id = Period Close Summary Balances.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Period Close Summary Balances.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> Period Close Variance Transactions | Manufacturing Accounting Periods.Organization Id = Period Close Variance Transactions.Organization Id
Manufacturing Accounting Periods.Acct Period Id = Period Close Variance Transactions.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> WIP Move Transactions | Manufacturing Accounting Periods.Organization Id = WIP Move Transactions.Organization Id
Manufacturing Accounting Periods.Acct Period Id = WIP Move Transactions.Acct Period Id | Always exist in master folder | None | No |
| Manufacturing Accounting Periods -> WIP Period Balances | Manufacturing Accounting Periods.Organization Id = WIP Period Balances.Organization Id
Manufacturing Accounting Periods.Acct Period Id = WIP Period Balances.Account Period Id | Always exist in master folder | None | No |