DW_PROJECT_COST_CF

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

Details

Module: Project Costing

Key Columns

LINE_NUM, 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    
SOURCE_RECORD_ID VARCHAR2 128     System Generated Unique Identifier    
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
EXPENDITURE_GROUP_ID NUMBER 38 0   Indicates the Expenditure Group ID. DW_PROJECT_EXPENDITURE_BATCH_D EXPENDITURE_GROUP_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
PRVDR_LEDGER_ID NUMBER 38 0   Ledger of Provider Organization DW_LEDGER_D LEDGER_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
RECVR_LEDGER_ID NUMBER 38 0   Ledger of Receiver Organization DW_LEDGER_D LEDGER_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
FISCAL_PERIOD_NAME VARCHAR2 16     The GL period in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
PRVDR_GL_DATE DATE       Date used to determine the correct general ledger accounting period in the provider operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date. For supplier invoices this date is copied from AP. DW_DAY_D CALENDAR_DATE
PRVDR_GL_PERIOD_NAME VARCHAR2 16     The GL period in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
PRVDR_GL_PERIOD_TYPE VARCHAR2 16     The GL period type in which the transaction is posted. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
PRVDR_GL_PERIOD_SET_NAME VARCHAR2 16     GL Calendar Name for Provider business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
PRVDR_PA_DATE DATE       Date used to determine the correct project accounting period in the provider operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date DW_DAY_D CALENDAR_DATE
PRVDR_PA_PERIOD_NAME VARCHAR2 16     The PA period for Provider business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
PRVDR_PA_PERIOD_TYPE VARCHAR2 16     The PA period type for Provider business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
PRVDR_PA_PERIOD_SET_NAME VARCHAR2 16     PA Calendar Name for Provider business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
RECVR_GL_DATE DATE       Date used to determine the correct general ledgert accounting period in the receiver operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date DW_DAY_D CALENDAR_DATE
RECVR_GL_PERIOD_NAME VARCHAR2 16     The GL period in which the transaction is posted on the receiving ledger. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
RECVR_GL_PERIOD_TYPE VARCHAR2 16     The GL period type in which the transaction is posted on the receiving ledger. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
RECVR_GL_PERIOD_SET_NAME VARCHAR2 16     The GL period in which the transaction is posted on the receiving ledger. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
RECVR_PA_DATE DATE       Date used to determine the correct project accounting period in the receiver operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date DW_DAY_D CALENDAR_DATE
RECVR_PA_PERIOD_NAME VARCHAR2 16     The PA period for Receiver business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
RECVR_PA_PERIOD_TYPE VARCHAR2 16     The PA period type for Receiver business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
RECVR_PA_PERIOD_SET_NAME VARCHAR2 16     PA Calendar Name for Receiver business unit. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
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    
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER 38 0   The identifier of the expenditure item from which this expenditure item originated. This expenditure item is the new item that is system created when an item is transferred and is charged to the new project/task    
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 ).    
QUANTITY NUMBER       The number of units that are costed in the distribution line cost. The quantity is set from the expenditure item quantity when the distribution line is created and is used for populating the quantities in the accumulation tables    
UOM_CODE VARCHAR2 32     Base unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PRVDR_LEDGER_RAW_COST NUMBER       The amount in functional currency to be charged to the gl account for the expenditure item The amount is stored as a debit, so the burden credit amounts and adjustment amounts are negative    
PRVDR_LEDGER_BURDENED_COST NUMBER       Burdened cost in functional currency    
PRVDR_LEDGER_BURDEN_COST NUMBER       Burden cost in functional currency    
PRVDR_LEDGER_CURRENCY_CODE VARCHAR2 16     Functional Currency Code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PRVDR_LEDGER_EXCHANGE_RATE NUMBER       Conversion rate used to convert raw cost from transaction currency to functional currency    
PRVDR_LEDGER_RATE_DATE DATE       Conversion rate date used to convert raw cost from transaction currency to functional currency    
PRVDR_LEDGER_RATE_TYPE VARCHAR2 32     Conversion rate type used to convert raw cost from transaction currency to functional currency    
PRVDR_LEDGER_TRANSFER_PRICE NUMBER       Transfer price in functional currency of the provider operating unit    
PROJACCT_TRANSFER_PRICE NUMBER       Transfer price in the functional currency of cross charged project (receiver operating unit)    
RECVR_LEDGER_RAW_COST NUMBER       Amount in project functional currency. Derrived by converting raw cost in transaction currency to project functional currency    
RECVR_LEDGER_BURDENED_COST NUMBER       Amount of the burdened cost in project functional currency    
RECVR_LEDGER_BURDEN_COST NUMBER       Amount of the burden cost in project functional currency    
RECVR_LEDGER_CURRENCY_CODE VARCHAR2 16     Project functional currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
RECVR_LEDGER_EXCHANGE_RATE NUMBER       Exchange rate used to convert costs from the transaction currency to the project functional currency.    
RECVR_LEDGER_RATE_DATE DATE       Rate date used to convert costs from the transaction currency to the project functional currency.    
RECVR_LEDGER_RATE_TYPE VARCHAR2 32     Rate type used to convert costs from the transaction currency to the project functional currency.    
RECVR_LEDGER_TRANSFER_PRICE NUMBER       Transfer price in project functional currency.    
PROJECT_RAW_COST NUMBER       Raw cost in project currency.    
PROJECT_BURDENED_COST NUMBER       Burdened cost in project currency.    
PROJECT_BURDEN_COST NUMBER       Burden cost in project currency.    
PROJECT_CURRENCY_CODE VARCHAR2 16     Project currency code of the transaction DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
PROJECT_EXCHANGE_RATE NUMBER       Exchange rate used to convert costs from the transaction currency to the project currency.    
PROJECT_RATE_DATE DATE       Rate date used to convert costs from the transaction currency to the project currency.    
PROJECT_RATE_TYPE VARCHAR2 32     Rate type used to convert costs from the transaction currency to the project currency.    
PROJECT_TRANSFER_PRICE NUMBER       Transfer price in project currency.    
TRANSACTION_RAW_COST NUMBER       The raw cost in transaction currency    
TRANSACTION_BURDENED_COST NUMBER       The amount of the burdened cost in transaction currency It is only populated for raw cost distribution lines    
TRANSACTION_BURDEN_COST NUMBER       The amount of the burdend cost in transaction currency It is only populated for raw cost distribution lines    
TRANSACTION_CURRENCY_CODE VARCHAR2 16     Transaction Currency code of the transaction DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
TRANSACTION_TRANSFER_PRICE NUMBER       Transfer price in the transaction currency    
GLOBAL_RAW_COST NUMBER       The raw cost in Global currency    
GLOBAL_BURDENED_COST NUMBER       The amount of the burdened cost in Global currency.    
GLOBAL_BURDEN_COST NUMBER       The amount of the burden cost in Global currency.    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global Currency Code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_EXCHANGE_RATE NUMBER       Exchange rate used to convert costs from the transaction currency to the Global currency.    
GLOBAL_RATE_DATE DATE       Rate date used to convert costs from the transaction currency to the Global currency.    
GLOBAL_RATE_TYPE VARCHAR2 32     Rate type used to convert costs from the transaction currency to the Global currency.    
GLOBAL_TRANSFER_PRICE_AMOUNT NUMBER       Transfer price in Global currency.    
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
INCURRED_BY_PERSON_TYPE VARCHAR2 32     Identifies the type of person - employee or contingent worker. DW_EXP_PERSON_TYPE_LKP_TL PERSON_TYPE
TRANSFER_REJECTION_REASON VARCHAR2 256     The reason why the distribution line was rejected by the PA Cost Transfer program or rejected by the other application's interface program    
TRANSFER_STATUS_CODE VARCHAR2 16     It contain Y or N for Extracted and non extracted records.    
EXPENDITURE_COMMENT VARCHAR2 256     The free text comment entered for an expenditure item    
LABOR_COST_MULTIPLIER_NAME VARCHAR2 32     The labor cost multiplier specified for a premium labor expenditure item in order to determine the premium labor cost. Cost = (cost rate*quantity*LCM). This is populated by the timecard entry forms or the Overtime Calculation program    
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    
CAPITALIZABLE_FLAG VARCHAR2 16     Capitalizable Flag    
BILL_HOLD_FLAG VARCHAR2 16     Flag that indicates if the item is held from invoicing. Upon entry, this flag is defaulted to 'N'. DW_PROJ_BILL_HOLD_LKP_TL BILL_HOLD_FLAG
INVOICED_FLAG VARCHAR2 16     Indicates the Invoice status of event. DW_EVT_INVOICED_FLAG_LKP_TL INVOICED_FLAG
REVENUE_HOLD_FLAG VARCHAR2 16     Indicates the Revenue status of event. DW_PROJ_REVENUE_HOLD_LKP_TL REVENUE_HOLD_FLAG
REVENUE_RECOGNIZED_FLAG VARCHAR2 16     Identify if Revenue Recognition is on Hold. DW_REVENUE_RECOGNIZED_LKP_TL REVENUE_RECOGNIZED_FLAG
IC_BILL_HOLD_FLAG VARCHAR2 16     Flag that indicates if the item is held from invoicing DW_PROJ_BILL_HOLD_LKP_TL BILL_HOLD_FLAG
IC_BILLABLE_FLAG VARCHAR2 16     Flag that indicates if transaction is eligible for Intercompany billing.    
IC_INVOICED_FLAG VARCHAR2 16     Indicates the Invoice status of event. DW_EVT_INVOICED_FLAG_LKP_TL INVOICED_FLAG
IC_REVENUE_HOLD_FLAG VARCHAR2 16     Indicates the Revenue status of event. DW_PROJ_REVENUE_HOLD_LKP_TL REVENUE_HOLD_FLAG
IC_REVENUE_RECOGNIZED_FLAG VARCHAR2 16     Identify if Revenue Recognition is on Hold. DW_REVENUE_RECOGNIZED_LKP_TL REVENUE_RECOGNIZED_FLAG
CC_BL_DISTRIBUTED_CODE VARCHAR2 16     Indicates the processing status of the Expenditure Item by the Distribute Borrowed and Lent Accounts process DW_CC_PROCESSED_CODE_LKP_TL CC_PROCESSED_CODE
CC_CROSS_CHARGE_TYPE VARCHAR2 16     Cross Charge Type DW_CC_CHARGE_TYPE_LKP_TL CC_CROSS_CHARGE_TYPE
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.    
SOURCE_TRNX_DIST_ID NUMBER 38 0   Source Transaction Distribution Reference which is the identifier used to retrieve the account for the inventory and receipt costs imported into Project Costing. For example, in the case of miscellaneous issue to project transactions, this is the offset account identifier.    
SOURCE_TRNX_HEADER_ID NUMBER 38 0   Source Transaction Header Reference    
SOURCE_TRNX_LINE_NUMBER NUMBER 38 0   Source Transaction Line Reference    
SOURCE_TRNX_PARENT_DIST_ID NUMBER 38 0   Source Transaction DIstribution Reference    
SOURCE_TRNX_PARENT_HEADER_ID NUMBER 38 0   Source Transaction Parent Header Reference    
SOURCE_TRNX_PARENT_LINE_NUMBER NUMBER 38 0   Source Transaction Parent Line Reference    
PARENT_LINE_NUMBER NUMBER 38 0   Line Number for the raw cost distribution line. Valid for I line types only.    
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.    
PURCHASE_ORDER_NUMBER VARCHAR2 32     Purchase order number    
PURCHASE_ORDER_LINE_NUMBER NUMBER       Line number    
PURCHASE_ORDER_DIST_NUMBER NUMBER       Distribution number    
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    
RESOURCE_CLASS_CODE VARCHAR2 32     Resource Class name.    
COST_ELEMENT_ID NUMBER 38 0   Unique identifier of the cost element DW_CST_COST_ELEMENTS_D COST_ELEMENT_ID
RECEIPT_NUMBER VARCHAR2 512     Receipt Number    
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.