This table stores aggregated data for the smallest categorized expenditure units charged to projects and tasks.
Module: Project Costing
SYSTEM_GEN_PK
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SYSTEM_GEN_PK | VARCHAR2 | 128 | True | System Generated Unique Identifier | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | ||
| 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 | ||
| UOM_CODE | VARCHAR2 | 32 | Base unit of measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| PRVDR_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional Currency Code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| RECVR_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Project functional currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 16 | Project currency code of the transaction | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global Currency Code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| 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 | ||
| 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 | ||||
| RESOURCE_CLASS_CODE | VARCHAR2 | 32 | Resource Class name. | ||||
| 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 | |
| PRVDR_PERIOD_START_DATE | DATE | GL Period Start Date for Provider Ledger. | DW_DAY_D | CALENDAR_DATE | |||
| PRVDR_PERIOD_END_DATE | DATE | GL Period End Date for Provider Ledger. | DW_DAY_D | CALENDAR_DATE | |||
| RECVR_PERIOD_START_DATE | DATE | GL Period Start Date for Receiver Ledger. | DW_DAY_D | CALENDAR_DATE | |||
| RECVR_PERIOD_END_DATE | DATE | GL Period End Date for Receiver Ledger. | DW_DAY_D | CALENDAR_DATE | |||
| 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 | |||||
| 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 | |||||
| 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 | |||||
| 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. | |||||
| 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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.