# DW_PROJECT_SLA_COST_CF

This table stores SLA level data for the smallest categorized expenditure units charged to projects and tasks.

## Details

Module: Project Costing

## Key Columns

LINE_NUM, TEMP_LINE_NUM , EXPENDITURE_ITEM_ID, ACCOUNTING_CLASS_CODE, AE_HEADER_ID, REF_AE_HEADER_ID , APPLICATION_ID

## Columns

Columns
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 |  |  | This column is for Oracle Internal use only. System Generated Unique Identifier |  |
SUBLEDGER_FACT_LINKAGE_ID | VARCHAR2 | 128 |  |  | Column concat of ae_header_id, ref_ae_header_id, temp_line_num |  |
SEEDED_ACCT_CLASS_CODE_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates whether the accounting class code is relevant as per seed mapping | DW_Y_N_D_TL | CODE
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
EXPENDITURE_COMMENT | VARCHAR2 | 256 |  |  | The free text comment entered for an expenditure item |  |
PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 |  |  | Purchase order number |  |
PURCHASE_ORDER_LINE_NUMBER | NUMBER |  |  |  | Line number |  |
PURCHASE_ORDER_DIST_NUMBER | NUMBER |  |  |  | Distribution number |  |
SUPPLIER_INVOICE_NUM | VARCHAR2 | 64 |  |  | Unique number for supplier invoice. |  |
SUPPLIER_INVOICE_LINE_NUM | NUMBER |  |  |  | The unique number for the invoice line associated with the invoice distribution. |  |
SUPPLIER_INVOICE_DIST_LINE_NUM | NUMBER | 38 | 0 |  | The line number associated with the invoice distribution. |  |
INVENTORY_TRANSACTION | VARCHAR2 | 512 |  |  | Inventory Transaction |  |
SALES_ORDER_NUMBER | VARCHAR2 | 512 |  |  | Sales Order Number |  |
SHIPMENT_NUMBER | VARCHAR2 | 512 |  |  | Shipment Number |  |
TRANSFER_ORDER_NUMBER | VARCHAR2 | 512 |  |  | Transfer Order Number |  |
WORK_ORDER_NUMBER | VARCHAR2 | 512 |  |  | Work Order Number |  |
EXPENDITURE_GROUP_ID | NUMBER | 38 | 0 |  | EXP_GROUP_ID |  |
ORIGINAL_TRANSACTION_REFERENCE | VARCHAR2 | 128 |  |  | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. |  |
RECEIPT_NUMBER | VARCHAR2 | 512 |  |  | Source Document Reference 3 |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.