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

TEMP_LINE_NUM , LINE_NUM, REF_AE_HEADER_ID , APPLICATION_ID , AE_HEADER_ID, ACCOUNTING_CLASS_CODE, EXPENDITURE_ITEM_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     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.