This table stores SLA level data for the smallest categorized expenditure units charged to projects and tasks.
Module: Project Costing
TEMP_LINE_NUM , LINE_NUM, REF_AE_HEADER_ID , APPLICATION_ID , AE_HEADER_ID, ACCOUNTING_CLASS_CODE, EXPENDITURE_ITEM_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
EXPENDITURE_ITEM_ID | NUMBER | 38 | 0 | True | The identifier of the expenditure item that is cost distributed by the distribution line | ||
LINE_NUM | NUMBER | 38 | 0 | True | The sequential number that identifies the cost distribution line for an expenditure item | ||
AE_HEADER_ID | NUMBER | 38 | 0 | True | Subledger journal entry identifier. | ||
TEMP_LINE_NUM | NUMBER | 38 | 0 | True | Intermediary line number generated by the accounting engine when the entries are in most detail form. | ||
APPLICATION_ID | NUMBER | 38 | 0 | True | Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. | ||
REF_AE_HEADER_ID | NUMBER | 38 | 0 | True | Reversed subledger journal entry header identifier. | ||
ACCOUNTING_CLASS_CODE | VARCHAR2 | 32 | True | Short name of a lookup type that is shared across application used to classify journal entry lines. | |||
SOURCE_RECORD_ID | VARCHAR2 | 256 | System Generated Unique Identifier | ||||
SUBLEDGER_FACT_LINKAGE_ID | VARCHAR2 | 128 | Column concat of ae_header_id, ref_ae_header_id, temp_line_num | ||||
PROJECT_ID | NUMBER | 38 | 0 | Identifier of the project | DW_PROJECT_D | PROJECT_ID | |
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 | Identifier of the project organization. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
DOCUMENT_ENTRY_ID | NUMBER | 38 | 0 | Projects-relates sub-categorication of the document type that is creating this transaction. | DW_PROJECT_TXN_DOC_ENTRY_TL | DOCUMENT_ENTRY_ID | |
DOCUMENT_ID | NUMBER | 38 | 0 | Projects-related categorization of the document type that is creating this transaction. | DW_PROJECT_TXN_DOCUMENT_TL | DOCUMENT_ID | |
EXPENDITURE_ORGANIZATION_ID | NUMBER | 38 | 0 | Expenditure Organization for the Expenditure item. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 | Identifier of the expenditure type | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID | |
NON_LABOR_RESOURCE_ID | NUMBER | 38 | 0 | Identifier of the non labor resource | DW_PROJECT_NON_LABOR_RES_TL | NON_LABOR_RESOURCE_ID | |
NON_LABOR_RESOURCE_ORG_ID | NUMBER | 38 | 0 | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
TRANSACTION_SOURCE_ID | NUMBER | 38 | 0 | Identifier of Transaction Source. | DW_PROJECT_TXN_SOURCE_TL | TRANSACTION_SOURCE_ID | |
PROJECT_UNIT_ID | NUMBER | 38 | 0 | Project unit assigned to the project | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
TASK_ID | NUMBER | 38 | 0 | Identifier of the task | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID | |
TASK_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization that is responsible for the work | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
WORK_TYPE_ID | NUMBER | 38 | 0 | Identifier for a work type assigned to the transaction. | DW_PROJECT_WORK_TYPE_TL | WORK_TYPE_ID | |
TRANSFER_PRICE_JOB_ID | NUMBER | 38 | 0 | Borrowed/Lent Job ID | DW_JOB_D | JOB_ID | |
SUPPLIER_ID | NUMBER | 38 | 0 | This column indicates the vendor identifier for supplier cost transactions. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICES_ALL.VENDOR_ID. If the expenditure item originated in Oracle Purchasing, it holds the | DW_PARTY_D | SUPPLIER_ID | |
PRVDR_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
PRVDR_LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity assigned to the Provider business unit. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
RECVR_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Receiver Operating Unit Identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
RECVR_LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity assigned to the Receiver business unit. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
PERSON_JOB_ID | NUMBER | 38 | 0 | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | DW_JOB_D | JOB_ID | |
INCURRED_BY_PERSON_ID | NUMBER | 38 | 0 | Identifier of employee. | DW_PERSON_D | PERSON_ID | |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Inventory item identifier | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
CC_PRVDR_ORGANIZATION_ID | NUMBER | 38 | 0 | Identifier of the provider organization. This may be different than the expenditure organization or the non-labor resource organization, if it is overridden by the client extension to derive provider organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
CC_RECVR_ORGANIZATION_ID | NUMBER | 38 | 0 | Identifier of the receiver organization. This may be different than the project organization, if it is overridden by the client extension to derive receiver organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
LINE_TYPE | VARCHAR2 | 16 | The type of the cost distribution line | DW_COST_DIST_LINE_TYPE_LKP_TL | LINE_TYPE | ||
REVERSED_FLAG | VARCHAR2 | 16 | Flag that indicates if the distribution line is reversed by another distribution line | DW_Y_N_D_TL | CODE | ||
REVERSED_LINE_NUMBER | NUMBER | 38 | 0 | The distribution line number that is reversed by this distribution line | |||
RESOURCE_CLASS_CODE | VARCHAR2 | 32 | Resource Class name. | ||||
INCURRED_BY_PERSON_TYPE | VARCHAR2 | 32 | Identifies the type of person - employee or contingent worker. | DW_EXP_PERSON_TYPE_LKP_TL | PERSON_TYPE | ||
RAW_COST_RATE | NUMBER | The raw cost rate used to cost the item | |||||
BURDEN_COST_RATE | NUMBER | The burdened cost rate of the item. Burdened cost rate = (burden cost / quantity ). | |||||
UOM_CODE | VARCHAR2 | 32 | Base unit of measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
EXPENDITURE_ITEM_DATE | DATE | The date on which the work occurred | DW_DAY_D | CALENDAR_DATE | |||
EXPENDITURE_ENDING_DATE | DATE | Expenditure End date. | |||||
EXPENDITURE_CREATION_DATE | TIMESTAMP | indicates the date and time of the creation of expenditure row | |||||
COST_DIST_LINE_CREATION_DATE | TIMESTAMP | indicates the date and time of the creation of the cost distribution row | |||||
COST_DIST_LINE_CREATED_BY | VARCHAR2 | 128 | indicates the user who created the cost distribution row. | DW_USER_D | USERNAME | ||
ACCOUNTING_STATUS_CODE | VARCHAR2 | 16 | The status of the distribution line as the cost information is transferred to another application | ||||
ACCOUNT_SOURCE_CODE | VARCHAR2 | 16 | Code used to identify accounting transactions, which are not migrated to SLA | ||||
EXPENDITURE_CLASS_CODE | VARCHAR2 | 16 | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | DW_PROJECT_SYSTEM_LINKAGE_TL | SYSTEM_LINKAGE_FUNCTION | ||
BILLABLE_FLAG | VARCHAR2 | 16 | Flag that indicates whether the cost amount is billable. The flag is set from the expenditure item billable flag when the distribution line is created and is used for determining billable/non-billable costs in the accumulation tables | DW_Y_N_D_TL | CODE | ||
CAPITALIZABLE_FLAG | VARCHAR2 | 16 | Capitalizable Flag | DW_Y_N_D_TL | CODE | ||
GL_CODE_COMBINATION_ID | NUMBER | 38 | 0 | Accounting code combination identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
GL_BALANCING_SEGMENT | VARCHAR2 | 32 | Balancing segment for the ledger. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT | ||
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE | ||
COST_CENTER_SEGMENT | VARCHAR2 | 32 | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT | ||
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE | ||
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT | ||
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE | ||
GL_SEGMENT1 | VARCHAR2 | 32 | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT2 | VARCHAR2 | 32 | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT3 | VARCHAR2 | 32 | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT4 | VARCHAR2 | 32 | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT5 | VARCHAR2 | 32 | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT6 | VARCHAR2 | 32 | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT7 | VARCHAR2 | 32 | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT8 | VARCHAR2 | 32 | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT9 | VARCHAR2 | 32 | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT10 | VARCHAR2 | 32 | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
XLA_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line. | ||||
XLA_LEDGER_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line. | ||||
XLA_ENTERED_DR | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line. | ||||
XLA_ENTERED_CR | BIGDECIMAL | 10 | Unrounded entered credit amount for the journal line. | ||||
XLA_ACCOUNTED_DR | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line. | ||||
XLA_ACCOUNTED_CR | BIGDECIMAL | 10 | Unrounded accounted credit for journal entry line. | ||||
XLA_MANUAL_OVERRIDE_FLAG | VARCHAR2 | 16 | Flag to identify if the CCID is overridden. | DW_Y_N_D_TL | CODE | ||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global Currency Code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
XLA_GLOBAL_AMOUNT | BIGDECIMAL | 10 | XLA Amount in Global Currency | ||||
XLA_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded debit amount for the journal line in Global Currency. | ||||
XLA_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded Credit amount for the journal line in Global Currency. | ||||
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | 32 | Classification of transaction source distribution | ||||
ACCOUNTING_LINE_CODE | VARCHAR2 | 32 | Short name of a rule to convert transactional data into a journal entry line. | ||||
ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | 16 | Type of journal line rule: Debit, Credit, Gain or Loss. | ||||
AE_LINE_NUM | NUMBER | 38 | 0 | Number that is associated with each subledger journal entry line. | |||
XLA_LINE_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | XLA Line Amount in transaction Currency | ||||
XLA_LINE_ENTERED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line. | ||||
XLA_LINE_ENTERED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered credit amount for the journal line. | ||||
XLA_LINE_LEDGER_AMOUNT | BIGDECIMAL | 10 | XLA Line Amount in Ledger Currency | ||||
XLA_LINE_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit amount of the journal entry line. | ||||
XLA_LINE_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted credit amount of the journal entry line. | ||||
XLA_LINE_GLOBAL_AMOUNT | BIGDECIMAL | 10 | XLA Line Amount in Global Currency | ||||
XLA_LINE_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded Global debit amount of the journal entry line. | ||||
XLA_LINE_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded Global credit amount of the journal entry line. | ||||
XLA_LEDGER_ID | NUMBER | 38 | 0 | Self-contained accounting information set for single or multiple legal or management entities. | DW_LEDGER_D | LEDGER_ID | |
XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
XLA_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Entered currency for the transaction data | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
XLA_ACCOUNTING_DATE | DATE | Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | The GL period type in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | GL Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
COST_TYPE_CODE | VARCHAR2 | 16 | Code to identify RAW Cost Accounting lines. | ||||
DISTRIBUTION_ACCOUNT_SOURCE | VARCHAR2 | 16 | Identifier for RAW Cost Accounting source. | ||||
ACCOUNTING_CREATION_DATE | TIMESTAMP | indicates the date and time of the creation of the cost accounting row | |||||
AWARD_BUDGET_PERIOD_ID | NUMBER | 38 | 0 | Identifier of Budget Period for which the funding is made | DW_AWARD_BUDGET_PERIOD_D | AWARD_BUDGET_PERIO_ID | |
AWARD_FUNDING_SOURCE_ID | NUMBER | 38 | 0 | Unique identifier of the funding source | DW_AWARD_FUNDING_SOURCE_D | FUNDING_SOURCE_ID | |
CONTRACT_HEADER_ID | NUMBER | 38 | 0 | Unique identifier of the contract | DW_PROJECT_AWARD_D | AWARD_ID |
Copyright © 2019, 2023, Oracle and/or its affiliates.