This table stores information about the cost distribution of expenditure items.
Module: Project Costing
LINE_NUM, EXPENDITURE_ITEM_ID
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 |