This table stores the labor distribution transaction details.
Module: Project Costing
LD_TXN_ID
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 |