| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Accounting Class | Accounting class identifier | Accounting Classes.Accounting Class | ACCOUNTING_CLASS | ACCOUNTING_CLASS | 114077 |
| Accounting Class Description | Descriptive text | Accounting Classes.Accounting Class Description | ACCOUNTING_CLASS_DESCRIPTION | ACCOUNTING_CLASS_DESCRIPTION | 114080 |
| Accounting Class Type | Lookup meaning | Accounting Classes.Accounting Class Type | ACCOUNTING_CLASS_TYPE | ACCOUNTING_CLASS_TYPE | 114081 |
| Average Costing Option | Lookup meaning | Accounting Classes.Average Costing Option | AVERAGE_COSTING_OPTION | AVERAGE_COSTING_OPTION | 118704 |
| Bridging Account | | Accounting Classes.Bridging Account | BRIDGING_ACCOUNT | BRIDGING_ACCOUNT | 120267 |
| Bridging Account Number | | Accounting Classes.Bridging Account Number | BRIDGING_ACCT_NUM | BRIDGING_ACCOUNT_NUMBER | 120268 |
| Completion Cost Source | Lookup meaning | Accounting Classes.Completion Cost Source | COMPLETION_COST_SOURCE | COMPLETION_COST_SOURCE | 122887 |
| Cost Type | Type of cost. 0=other; 1=std; 2=avg actual; 3=current. Not currently used. | Accounting Classes.Cost Type | COST_TYPE | COST_TYPE | 123756 |
| Cost Type Id | Cost type identifier for average costing | Accounting Classes.Cost Type Id | COST_TYPE_ID | COST_TYPE_ID | 123776 |
| Created By | Standard Who column. | Accounting Classes.Created By | CREATED_BY | CREATED_BY | 124816 |
| Creation Date | | Accounting Classes.Creation Date | CREATION_DATE | CREATION_DATE | 126250 |
| Disable Date | Accounting class disable date | Accounting Classes.Disable Date | DISABLE_DATE | DISABLE_DATE | 130131 |
| Disable Date - Day | | Accounting Classes.Disable Date | | DISABLE_DATE_DAY | 176181 |
| Disable Date - Month | | Accounting Classes.Disable Date | | DISABLE_DATE_MONTH | 176203 |
| Disable Date - Quarter | | Accounting Classes.Disable Date | | DISABLE_DATE_QUARTER | 176225 |
| Disable Date - Year | | Accounting Classes.Disable Date | | DISABLE_DATE_YEAR | 176247 |
| Expense Account | General ledger account to accumulate expense charges for a job or schedule | Accounting Classes.Expense Account | EXPENSE_ACCOUNT | EXPENSE_ACCOUNT | 134053 |
| Expense Account Number | | Accounting Classes.Expense Account Number | EXPENSE_ACCT_NUM | EXPENSE_ACCOUNT_NUMBER | 134059 |
| Last Update Date | | Accounting Classes.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140771 |
| Material Account | General ledger account to accumulate material charges for a job or schedule | Accounting Classes.Material Account | MATERIAL_ACCOUNT | MATERIAL_ACCOUNT | 146343 |
| Material Overhead Account | General ledger account to accumulate material overhead charges for a job or schedule | Accounting Classes.Material Overhead Account | MATERIAL_OVERHEAD_ACCOUNT | MATERIAL_OVERHEAD_ACCOUNT | 146358 |
| Material Overhead Account Number | | Accounting Classes.Material Overhead Account Number | MTL_OVHD_ACCT_NUM | MATERIAL_OVERHEAD_ACCOUNT_NUMBER | 146361 |
| Material Variance Account | General ledger account to accumulate material variance charges for a job or schedule | Accounting Classes.Material Variance Account | MATERIAL_VARIANCE_ACCOUNT | MATERIAL_VARIANCE_ACCOUNT | 146368 |
| Mtl Acct Num | | Accounting Classes.Mtl Acct Num | MTL_ACCT_NUM | MTL_ACCT_NUM | 273876 |
| Mtl Var Acct Num | | Accounting Classes.Mtl Var Acct Num | MTL_VAR_ACCT_NUM | MTL_VAR_ACCT_NUM | 273877 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Accounting Classes.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150159 |
| Organization Id | | Accounting Classes.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150426 |
| Organization Name | | Accounting Classes.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150723 |
| Outside Processing Account | General ledger account to accumulate outside processing charges for a job or schedule | Accounting Classes.Outside Processing Account | OUTSIDE_PROCESSING_ACCOUNT | OUTSIDE_PROCESSING_ACCOUNT | 151652 |
| Outside Processing Account Number | | Accounting Classes.Outside Processing Account Number | OSP_ACCT_NUM | OUTSIDE_PROCESSING_ACCOUNT_NUMBER | 151654 |
| Outside Processing Variance Account | General ledger account to accumulate outside processing variance charges for a job or schedule | Accounting Classes.Outside Processing Variance Account | OUTSIDE_PROC_VARIANCE_ACCOUNT | OUTSIDE_PROC_VARIANCE_ACCOUNT | 151659 |
| Outside Processing Variance Account Number | | Accounting Classes.Outside Processing Variance Account Number | OSP_VAR_ACCT_NUM | OUTSIDE_PROCESSING_VARIANCE_ACCOUNT_NUMBER | 151658 |
| Overhead Account | General ledger account to accumulate overhead charges for a job or schedule | Accounting Classes.Overhead Account | OVERHEAD_ACCOUNT | OVERHEAD_ACCOUNT | 151690 |
| Overhead Account Number | | Accounting Classes.Overhead Account Number | OVHD_ACCT_NUM | OVERHEAD_ACCOUNT_NUMBER | 151693 |
| Overhead Variance Account | General ledger account to accumulate overhead variance charges for a job or schedule | Accounting Classes.Overhead Variance Account | OVERHEAD_VARIANCE_ACCOUNT | OVERHEAD_VARIANCE_ACCOUNT | 151702 |
| Overhead Variance Account Number | | Accounting Classes.Overhead Variance Account Number | OVHD_VAR_ACCT_NUM | OVERHEAD_VARIANCE_ACCOUNT_NUMBER | 151704 |
| Resource Account | General ledger account to accumulate resource charges for a job or schedule | Accounting Classes.Resource Account | RESOURCE_ACCOUNT | RESOURCE_ACCOUNT | 158919 |
| Resource Account Number | | Accounting Classes.Resource Account Number | RSRC_ACCT_NUM | RESOURCE_ACCOUNT_NUMBER | 158922 |
| Resource Variance Account | General ledger account to accumulate resource variance charges for a job or schedule | Accounting Classes.Resource Variance Account | RESOURCE_VARIANCE_ACCOUNT | RESOURCE_VARIANCE_ACCOUNT | 159206 |
| Resource Variance Account Number | | Accounting Classes.Resource Variance Account Number | RSRC_VAR_ACCT_NUM | RESOURCE_VARIANCE_ACCOUNT_NUMBER | 159208 |
| Standard Cost Adjustment Account Number | | Accounting Classes.Standard Cost Adjustment Account Number | STD_CSTADJ_ACCT_NUM | STD_COST_ADJUSTMENT_ACCOUNT_NUMBER | 163647 |
| Std Cost Adjustment Account | General ledger account to accumulate standard cost adjustment charges for a job or schedule | Accounting Classes.Std Cost Adjustment Account | STD_COST_ADJUSTMENT_ACCOUNT | STD_COST_ADJUSTMENT_ACCOUNT | 163645 |
| Updated By | | Accounting Classes.Updated By | UPDATED_BY | UPDATED_BY | 166515 |
| Accounting Class | Accounting class identifier | Accounting Classes.Accounting Class | ACCOUNTING_CLASS | ACCOUNTING_CLASS | 114077 |
| Accounting Class Description | Descriptive text | Accounting Classes.Accounting Class Description | ACCOUNTING_CLASS_DESCRIPTION | ACCOUNTING_CLASS_DESCRIPTION | 114080 |
| Accounting Class Type | Lookup meaning | Accounting Classes.Accounting Class Type | ACCOUNTING_CLASS_TYPE | ACCOUNTING_CLASS_TYPE | 114081 |
| Average Costing Option | Lookup meaning | Accounting Classes.Average Costing Option | AVERAGE_COSTING_OPTION | AVERAGE_COSTING_OPTION | 118704 |
| Bridging Account | | Accounting Classes.Bridging Account | BRIDGING_ACCOUNT | BRIDGING_ACCOUNT | 120267 |
| Bridging Account Number | | Accounting Classes.Bridging Account Number | BRIDGING_ACCT_NUM | BRIDGING_ACCOUNT_NUMBER | 120268 |
| Completion Cost Source | Lookup meaning | Accounting Classes.Completion Cost Source | COMPLETION_COST_SOURCE | COMPLETION_COST_SOURCE | 122887 |
| Cost Type | Type of cost. 0=other; 1=std; 2=avg actual; 3=current. Not currently used. | Accounting Classes.Cost Type | COST_TYPE | COST_TYPE | 123756 |
| Cost Type Id | Cost type identifier for average costing | Accounting Classes.Cost Type Id | COST_TYPE_ID | COST_TYPE_ID | 123776 |
| Created By | Standard Who column. | Accounting Classes.Created By | CREATED_BY | CREATED_BY | 124816 |
| Creation Date | | Accounting Classes.Creation Date | CREATION_DATE | CREATION_DATE | 126250 |
| Disable Date | Accounting class disable date | Accounting Classes.Disable Date | DISABLE_DATE | DISABLE_DATE | 130131 |
| Disable Date - Day | | Accounting Classes.Disable Date | | DISABLE_DATE_DAY | 176181 |
| Disable Date - Month | | Accounting Classes.Disable Date | | DISABLE_DATE_MONTH | 176203 |
| Disable Date - Quarter | | Accounting Classes.Disable Date | | DISABLE_DATE_QUARTER | 176225 |
| Disable Date - Year | | Accounting Classes.Disable Date | | DISABLE_DATE_YEAR | 176247 |
| Expense Account | General ledger account to accumulate expense charges for a job or schedule | Accounting Classes.Expense Account | EXPENSE_ACCOUNT | EXPENSE_ACCOUNT | 134053 |
| Expense Account Number | | Accounting Classes.Expense Account Number | EXPENSE_ACCT_NUM | EXPENSE_ACCOUNT_NUMBER | 134059 |
| Last Update Date | | Accounting Classes.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140771 |
| Material Account | General ledger account to accumulate material charges for a job or schedule | Accounting Classes.Material Account | MATERIAL_ACCOUNT | MATERIAL_ACCOUNT | 146343 |
| Material Overhead Account | General ledger account to accumulate material overhead charges for a job or schedule | Accounting Classes.Material Overhead Account | MATERIAL_OVERHEAD_ACCOUNT | MATERIAL_OVERHEAD_ACCOUNT | 146358 |
| Material Overhead Account Number | | Accounting Classes.Material Overhead Account Number | MTL_OVHD_ACCT_NUM | MATERIAL_OVERHEAD_ACCOUNT_NUMBER | 146361 |
| Material Variance Account | General ledger account to accumulate material variance charges for a job or schedule | Accounting Classes.Material Variance Account | MATERIAL_VARIANCE_ACCOUNT | MATERIAL_VARIANCE_ACCOUNT | 146368 |
| Mtl Acct Num | | Accounting Classes.Mtl Acct Num | MTL_ACCT_NUM | MTL_ACCT_NUM | 273876 |
| Mtl Var Acct Num | | Accounting Classes.Mtl Var Acct Num | MTL_VAR_ACCT_NUM | MTL_VAR_ACCT_NUM | 273877 |
| Organization Code | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | Accounting Classes.Organization Code | ORGANIZATION_CODE | ORGANIZATION_CODE | 150159 |
| Organization Id | | Accounting Classes.Organization Id | ORGANIZATION_ID | ORGANIZATION_ID | 150426 |
| Organization Name | | Accounting Classes.Organization Name | ORGANIZATION_NAME | ORGANIZATION_NAME | 150723 |
| Outside Processing Account | General ledger account to accumulate outside processing charges for a job or schedule | Accounting Classes.Outside Processing Account | OUTSIDE_PROCESSING_ACCOUNT | OUTSIDE_PROCESSING_ACCOUNT | 151652 |
| Outside Processing Account Number | | Accounting Classes.Outside Processing Account Number | OSP_ACCT_NUM | OUTSIDE_PROCESSING_ACCOUNT_NUMBER | 151654 |
| Outside Processing Variance Account | General ledger account to accumulate outside processing variance charges for a job or schedule | Accounting Classes.Outside Processing Variance Account | OUTSIDE_PROC_VARIANCE_ACCOUNT | OUTSIDE_PROC_VARIANCE_ACCOUNT | 151659 |
| Outside Processing Variance Account Number | | Accounting Classes.Outside Processing Variance Account Number | OSP_VAR_ACCT_NUM | OUTSIDE_PROCESSING_VARIANCE_ACCOUNT_NUMBER | 151658 |
| Overhead Account | General ledger account to accumulate overhead charges for a job or schedule | Accounting Classes.Overhead Account | OVERHEAD_ACCOUNT | OVERHEAD_ACCOUNT | 151690 |
| Overhead Account Number | | Accounting Classes.Overhead Account Number | OVHD_ACCT_NUM | OVERHEAD_ACCOUNT_NUMBER | 151693 |
| Overhead Variance Account | General ledger account to accumulate overhead variance charges for a job or schedule | Accounting Classes.Overhead Variance Account | OVERHEAD_VARIANCE_ACCOUNT | OVERHEAD_VARIANCE_ACCOUNT | 151702 |
| Overhead Variance Account Number | | Accounting Classes.Overhead Variance Account Number | OVHD_VAR_ACCT_NUM | OVERHEAD_VARIANCE_ACCOUNT_NUMBER | 151704 |
| Resource Account | General ledger account to accumulate resource charges for a job or schedule | Accounting Classes.Resource Account | RESOURCE_ACCOUNT | RESOURCE_ACCOUNT | 158919 |
| Resource Account Number | | Accounting Classes.Resource Account Number | RSRC_ACCT_NUM | RESOURCE_ACCOUNT_NUMBER | 158922 |
| Resource Variance Account | General ledger account to accumulate resource variance charges for a job or schedule | Accounting Classes.Resource Variance Account | RESOURCE_VARIANCE_ACCOUNT | RESOURCE_VARIANCE_ACCOUNT | 159206 |
| Resource Variance Account Number | | Accounting Classes.Resource Variance Account Number | RSRC_VAR_ACCT_NUM | RESOURCE_VARIANCE_ACCOUNT_NUMBER | 159208 |
| Standard Cost Adjustment Account Number | | Accounting Classes.Standard Cost Adjustment Account Number | STD_CSTADJ_ACCT_NUM | STD_COST_ADJUSTMENT_ACCOUNT_NUMBER | 163647 |
| Std Cost Adjustment Account | General ledger account to accumulate standard cost adjustment charges for a job or schedule | Accounting Classes.Std Cost Adjustment Account | STD_COST_ADJUSTMENT_ACCOUNT | STD_COST_ADJUSTMENT_ACCOUNT | 163645 |
| Updated By | | Accounting Classes.Updated By | UPDATED_BY | UPDATED_BY | 166515 |