DW_PJC_COST_DIST_LINES_EN

This table stores information about the cost distribution of expenditure items.

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    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 128     Subledger Linkage Distribution Entity ID    
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER 38 0   The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item.    
BILL_HOLD_FLAG VARCHAR2 16     Flag that indicates if the item is held from invoicing. Upon entry, this flag is defaulted to 'N'.    
BURDEN_COST_RATE NUMBER       The burdened cost rate of the item. Burdened cost rate = (burden cost / quantity ).    
CC_BL_DISTRIBUTED_CODE VARCHAR2 16     Indicates the processing status of the Expenditure Item by the Distribute Borrowed and Lent Accounts process    
CC_CROSS_CHARGE_TYPE VARCHAR2 16     Cross Charge Type    
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    
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    
CONTRACT_ID NUMBER 38 0   Unique Identifier of the contract.    
CONTRACT_LINE_ID NUMBER 38 0   Unique Identifier of the contract line.    
DOC_ENTRY_ID NUMBER 38 0   Projects-relates sub-categorication of the document type that is creating this transaction.    
DOC_REF_ID1 VARCHAR2 512     Source Document Reference 1. In the case of sales order issue transactions, this is the shipment number.    
DOC_REF_ID2 VARCHAR2 512     Source Document Reference 2. In the case of sales order issue transactions, this is the sales order number.    
DOCUMENT_ID NUMBER 38 0   Projects-related categorization of the document type that is creating this transaction.    
EXP_GROUP_ID NUMBER 38 0   EXP_GROUP_ID    
EXPENDITURE_ENDING_DATE DATE       EXPENDITURE_ENDING_DATE    
EXPENDITURE_ITEM_DATE DATE       The date on which the work occurred    
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0   EXPENDITURE_ORGANIZATION_ID for the Exp item which holds the value NVL(OVERRIDE_TO_ORGANIZATION_ID,INCURRED_BY_ORGANIZATION_ID)    
EXPENDITURE_TYPE_ID NUMBER 38 0   Identifier of the expenditure type    
IC_BILL_HOLD_FLAG VARCHAR2 16     IC_BILL_HOLD_FLAG    
IC_BILLABLE_FLAG VARCHAR2 16     Flag that indicates if transaction is eligible for Intercompany billing.    
IC_INVOICED_FLAG VARCHAR2 16     IC_INVOICED_FLAG    
IC_REVENUE_HOLD_FLAG VARCHAR2 16     IC_REVENUE_HOLD_FLAG    
IC_REVENUE_RECOGNIZED_FLAG VARCHAR2 16     IC_REVENUE_RECOGNIZED_FLAG    
INCURRED_BY_ORGANIZATION_ID NUMBER 38 0   INCURRED_BY_ORGANIZATION_ID    
INCURRED_BY_PERSON_ID NUMBER 38 0   INCURRED_BY_PERSON_ID    
INVENTORY_ITEM_ID NUMBER 38 0   Inventory item identifier    
INVOICED_FLAG VARCHAR2 16     INVOICED_FLAG    
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    
ORIGINAL_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.    
ORIGINAL_HEADER_ID NUMBER 38 0   ORIGINAL_HEADER_ID    
ORIGINAL_LINE_NUMBER NUMBER 38 0   ORIGINAL_LINE_NUMBER    
PARENT_DIST_ID NUMBER 38 0   PARENT_DIST_ID    
PARENT_HEADER_ID NUMBER 38 0   PARENT_HEADER_ID    
PARENT_LINE_NUMBER NUMBER 38 0   PARENT_LINE_NUMBER    
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.    
PERSON_TYPE VARCHAR2 32     Identifies the type of person - employee or contingent worker.    
PRVDR_LEGAL_ENTITY_ID NUMBER 38 0   PRVDR_LEGAL_ENTITY_ID    
RAW_COST_RATE NUMBER       The raw cost rate used to cost the item    
RECVR_ORG_ID NUMBER 38 0   Receiver Operating Unit Identifier    
REVENUE_HOLD_FLAG VARCHAR2 16     REVENUE_HOLD_FLAG    
REVENUE_RECOGNIZED_FLAG VARCHAR2 16     REVENUE_RECOGNIZED_FLAG    
TP_JOB_ID NUMBER 38 0   Borrowed/Lent Job ID    
TRANSACTION_SOURCE_ID NUMBER 38 0   TRANSACTION_SOURCE_ID    
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    
UNIT_OF_MEASURE VARCHAR2 32     Base unit of measure    
VENDOR_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    
DOC_REF_ID5 VARCHAR2 128     Source Document Reference 5.    
ORIGINAL_DIST_ID2 NUMBER 38 0   Peer Source Transaction Distribution Reference which is the identifier used to retrieve the counterpart account of the source transaction distribution reference    
REFERENCE_ID5 NUMBER 38 0   Source Document Reference Identifier 5.    
ACCOUNTING_STATUS_CODE VARCHAR2 16     The status of the distribution line as the cost information is transferred to another application    
ACCT_BURDENED_COST NUMBER       Burdened cost in functional currency    
ACCT_CURRENCY_CODE VARCHAR2 16     Functional Currency Code    
ACCT_EVENT_ID NUMBER 38 0   Identifier of Accounting Event    
ACCT_EXCHANGE_RATE NUMBER       Conversion rate used to convert raw cost from transaction currency to functional currency    
ACCT_RATE_DATE DATE       Conversion rate date used to convert raw cost from transaction currency to functional currency    
ACCT_RATE_TYPE VARCHAR2 32     Conversion rate type used to convert raw cost from transaction currency to functional currency    
ACCT_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    
ACCT_SOURCE_CODE VARCHAR2 16     Code used to identify accounting transactions, which are not migrated to SLA    
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    
BURDEN_COST_CR_CCID NUMBER 38 0   BURDEN_COST_CR_CCID    
BURDEN_COST_DR_CCID NUMBER 38 0   BURDEN_COST_DR_CCID    
BURDENED_COST_CR_CCID NUMBER 38 0   BURDENED_COST_CR_CCID    
BURDENED_COST_DR_CCID NUMBER 38 0   BURDENED_COST_DR_CCID    
CAPITALIZABLE_FLAG VARCHAR2 16     CAPITALIZABLE_FLAG    
COST_SCHEDULE_ID NUMBER 38 0   Cost rate schedule identifier    
COST_SCHEDULE_LINE_ID NUMBER 38 0   Cost rate schedule line identifier    
DENOM_BURDENED_COST NUMBER       The amount of the burdened cost in transaction currency It is only populated for raw cost distribution lines    
DENOM_CURRENCY_CODE VARCHAR2 16     Transaction Currency code of the transaction    
DENOM_RAW_COST NUMBER       The raw cost in transaction currency    
LINE_NUM_REVERSED NUMBER 38 0   The distribution line number that is reversed by this distribution line    
LINE_TYPE VARCHAR2 16     The type of the cost distribution line    
ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
PARENT_LINE_NUM NUMBER 38 0   Line Number for the raw cost distribution line. Valid for I line types only.    
PROJECT_BURDENED_COST NUMBER       Burdened cost in project currency.    
PROJECT_CURRENCY_CODE VARCHAR2 16     Project currency code of the transaction    
PROJECT_EXCHANGE_RATE NUMBER       Conversion rate date used to convert raw cost from transaction currency to project currency    
PROJECT_ID NUMBER 38 0   Identifier of the project    
PROJECT_RATE_DATE DATE       Conversion rate date used to convert raw cost from transaction currency to project currency    
PROJECT_RATE_TYPE VARCHAR2 32     Conversion rate date used to convert raw cost from transaction currency to project currency    
PROJECT_RAW_COST NUMBER       Raw cost in project currency.    
PROJECT_UNIT_ID NUMBER 38 0   PROJECT_UNIT_ID    
PROJFUNC_BURDENED_COST NUMBER       Amount of the burdened cost in project functional currency    
PROJFUNC_COST_EXCHANGE_RATE NUMBER       Exchange rate used to convert costs from the transaction currency to the project functional currency.    
PROJFUNC_COST_RATE_DATE DATE       Rate date used to convert costs from the transaction currency to the project functional currency.    
PROJFUNC_COST_RATE_TYPE VARCHAR2 32     Rate type used to convert costs from the transaction currency to the project functional currency.    
PROJFUNC_CURRENCY_CODE VARCHAR2 16     Project functional currency code.    
PROJFUNC_RAW_COST NUMBER       Amount in project functional currency. Derrived by converting raw cost in transaction currency to project functional currency    
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.    
PRVDR_GL_PERIOD_NAME VARCHAR2 16     The GL period in which the transaction is posted.    
FISCAL_PERIOD_NAME VARCHAR2 16     The GL period in which the transaction is posted.    
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    
PRVDR_PA_PERIOD_NAME VARCHAR2 16     The PA period in which the transaction is posted.    
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    
RAW_COST_CR_CCID NUMBER 38 0   RAW_COST_CR_CCID    
RAW_COST_DR_CCID NUMBER 38 0   RAW_COST_DR_CCID    
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    
RECVR_GL_PERIOD_NAME VARCHAR2 16     The GL period in which the transaction is posted on the receiving ledger.    
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    
RECVR_PA_PERIOD_NAME VARCHAR2 16     The PA period in which the transaction is posted on the receiving ledger.    
REVERSED_FLAG VARCHAR2 16     Flag that indicates if the distribution line is reversed by another distribution line    
TASK_ID NUMBER 38 0   Identifier of the task    
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     TRANSFER_STATUS_CODE will contain Y or N for Extracted and non extracted records.    
WORK_TYPE_ID NUMBER 38 0   Identifier for a work type assigned to the transaction.    
BUDGET_CCID NUMBER 38 0   Budget account used for budget checking raw cost.    
RATE_OVERRIDE_ID NUMBER 38 0   Identifier of rate_override_id from pjf_rate_overrides table    
RAW_DR_SOURCE_DIST_ID_NUM_1 NUMBER 38 0   Column to be used as Identifier of XLA Accounting.    
RAW_CR_SOURCE_DIST_ID_NUM_1 NUMBER 38 0   Column to be used as Identifier of XLA Accounting.    
RAW_SOURCE_DIST_TYPE VARCHAR2 128     Column to be used as Identifier of XLA Accounting.    
RAW_APPLICATION_ID NUMBER 38 0   Column to be used as Identifier of XLA Accounting.    
COST_DIST_LINE_CREATED_BY VARCHAR2 128     indicates the user who created the Cost distribution row.    
EXPENDITURE_CREATION_DATE TIMESTAMP       Indicates the date and time of the creation of the Expenditure row    
COST_DIST_LINE_CREATION_DATE TIMESTAMP       Indicates the date and time of the creation of the Cost distribution row    
NON_LABOR_RESOURCE_ID NUMBER 38 0   Identifier of the non labor resource    
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    
ORIG_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.    
SYSTEM_LINKAGE_FUNCTION VARCHAR2 16     The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type    
ACCT_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)    
PROJFUNC_TRANSFER_PRICE NUMBER       Transfer price in project functional currency.    
PROJECT_TRANSFER_PRICE NUMBER       Transfer price in project currency.    
DENOM_TRANSFER_PRICE NUMBER       Transfer price in the transaction currency    
GLOBAL_CURRENCY_RATE_DATE DATE       Date to be considered for GLOBAL Currency Conversion rate.    
RESOURCE_CLASS_CODE VARCHAR2 32     Resource Class name.    
RAW_ACCOUNTING_IND VARCHAR2 16     Raw Cost Accounting Source Indicator    
BURDEN_ACCOUNTING_IND VARCHAR2 16     Burden Cost Accounting Source Indicator    
BURDENED_ACCOUNTING_IND VARCHAR2 16     Burdened Cost Accounting Source Indicator    
DOC_REF_ID3 VARCHAR2 512     Source Document Reference 3    
DOC_REF_ID4 VARCHAR2 128     Source Document Reference 4    
REFERENCE_ID4 NUMBER 38 0   Source Document Reference Identifier 4