DW_PJC_PAYROLL_DISTRIBUTION_EN

This table stores the labor distribution transaction details.

Details

Module: Project Costing

Key Columns

LD_TXN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LD_TXN_ID NUMBER 38 0 True The identifier of the expenditure item that is cost distributed by the distribution line    
SOURCE_RECORD_ID VARCHAR2 32          
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 32     The identifier of the expenditure item that is cost distributed by the distribution line    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 32     The identifier of the expenditure item that is cost distributed by the distribution line    
ALLOC_TXN_ID NUMBER 38 0        
RUN_ID NUMBER 38 0   The sequential number that identifies the cost distribution line for an expenditure item    
RULE_ID NUMBER 38 0   System Generated Unique Identifier    
LINE_NUM 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.    
RUN_TARGET_ID NUMBER 38 0   Flag that indicates if the item is held from invoicing. Upon entry, this flag is defaulted to 'N'.    
RUN_SOURCE_DET_ID NUMBER 38 0   The burdened cost rate of the item. Burdened cost rate = (burden cost / quantity ).    
ORG_ID NUMBER 38 0   Indicates the processing status of the Expenditure Item by the Distribute Borrowed and Lent Accounts process    
INTERFACE_ID NUMBER 38 0   Cross Charge Type    
PERIOD_START_DATE DATE       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    
PERIOD_END_DATE DATE       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    
PERSON_ID NUMBER 38 0   Unique Identifier of the contract.    
ELEMENT_TYPE VARCHAR2 128     Unique Identifier of the contract line.    
ASSIGNMENT_ID NUMBER 38 0   Projects-relates sub-categorication of the document type that is creating this transaction.    
PROCESSING_START_DATE DATE       Source Document Reference 1. In the case of sales order issue transactions, this is the shipment number.    
PROCESSING_END_DATE DATE       Source Document Reference 2. In the case of sales order issue transactions, this is the sales order number.    
TOTAL_POOL_AMOUNT NUMBER       Projects-related categorization of the document type that is creating this transaction.    
CURRENCY_CODE VARCHAR2 16     EXP_GROUP_ID    
LINE_PERCENT NUMBER 38 0   EXPENDITURE_ENDING_DATE    
CREATION_DATE TIMESTAMP       The date on which the work occurred    
CREATED_BY VARCHAR2 128     EXPENDITURE_ORGANIZATION_ID for the Exp item which holds the value NVL(OVERRIDE_TO_ORGANIZATION_ID,INCURRED_BY_ORGANIZATION_ID)    
LAST_UPDATE_DATE TIMESTAMP       Identifier of the expenditure type    
LAST_UPDATED_BY VARCHAR2 128     IC_BILL_HOLD_FLAG    
LAST_UPDATE_LOGIN VARCHAR2 64     Flag that indicates if transaction is eligible for Intercompany billing.    
OBJECT_VERSION_NUMBER NUMBER 38 0   IC_INVOICED_FLAG    
TOTAL_ALLOCATION NUMBER       IC_REVENUE_HOLD_FLAG    
ACCT_EVENT_ID NUMBER 38 0   IC_REVENUE_RECOGNIZED_FLAG    
PROJECT_ID NUMBER 38 0   INCURRED_BY_ORGANIZATION_ID    
TASK_ID NUMBER 38 0   INCURRED_BY_PERSON_ID    
EXPENDITURE_ITEM_ID NUMBER 38 0   Inventory item identifier    
EXPENDITURE_TYPE_ID NUMBER 38 0   INVOICED_FLAG    
CONTRACT_ID NUMBER 38 0   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    
ADJUSTED_ALLOC_TXN_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.    
TARGET_CCID NUMBER 38 0   ORIGINAL_HEADER_ID    
CONTEXT_CATEGORY VARCHAR2 64     ORIGINAL_LINE_NUMBER    
EXPENDITURE_ITEM_DATE DATE       PARENT_DIST_ID    
ORGANIZATION_ID NUMBER 38 0   PARENT_HEADER_ID    
BILLABLE_FLAG VARCHAR2 16     PARENT_LINE_NUMBER    
CAPITALIZABLE_FLAG VARCHAR2 16     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.    
WORK_TYPE_ID NUMBER 38 0   Identifies the type of person - employee or contingent worker.    
CONTRACT_LINE_ID NUMBER 38 0   PRVDR_LEGAL_ENTITY_ID    
FUNDING_ALLOCATION_ID NUMBER 38 0   The raw cost rate used to cost the item    
LD_ELEMENT_TYPE_ID NUMBER 38 0   Receiver Operating Unit Identifier