This table stores aggregated SLA data for theAccounted 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 | |
| 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 | |
| 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 | |
| RESOURCE_CLASS_CODE | VARCHAR2 | 32 | Resource Class name. | ||||
| INCURRED_BY_PERSON_TYPE | VARCHAR2 | 32 | Identifies the type of person - employee or contingent worker. | DW_EXP_PERSON_TYPE_LKP_TL | PERSON_TYPE | ||
| UOM_CODE | VARCHAR2 | 32 | Base unit of measure | DW_UNIT_OF_MEASURE_D_TL | UOM_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 | ||
| 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 | DW_Y_N_D_TL | CODE | ||
| CAPITALIZABLE_FLAG | VARCHAR2 | 16 | Capitalizable Flag | DW_Y_N_D_TL | CODE | ||
| GL_CODE_COMBINATION_ID | NUMBER | 38 | 0 | Accounting code combination identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
| GL_BALANCING_SEGMENT | VARCHAR2 | 32 | Balancing segment for the ledger. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT | ||
| GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE | ||
| COST_CENTER_SEGMENT | VARCHAR2 | 32 | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT | ||
| COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE | ||
| NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT | ||
| NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE | ||
| XLA_LEDGER_ID | NUMBER | 38 | 0 | Self-contained accounting information set for single or multiple legal or management entities. | DW_LEDGER_D | LEDGER_ID | |
| XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| XLA_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Entered currency for the transaction data | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | The GL period type in which the transaction is posted. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | GL Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| COST_TYPE_CODE | VARCHAR2 | 16 | Code to identify RAW Cost Accounting lines. | ||||
| 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 | |
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global Currency Code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| FISCAL_PERIOD_START_DATE | DATE | Fiscal Period Start Date for XLA Ledger. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| FISCAL_PERIOD_END_DATE | DATE | Fiscal Period End Date for XLA Ledger. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| XLA_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line. | ||||
| XLA_LEDGER_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line. | ||||
| XLA_ENTERED_DR | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line. | ||||
| XLA_ENTERED_CR | BIGDECIMAL | 10 | Unrounded entered credit amount for the journal line. | ||||
| XLA_ACCOUNTED_DR | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line. | ||||
| XLA_ACCOUNTED_CR | BIGDECIMAL | 10 | Unrounded accounted credit for journal entry line. | ||||
| XLA_GLOBAL_AMOUNT | BIGDECIMAL | 10 | XLA Amount in Global Currency | ||||
| XLA_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded debit amount for the journal line in Global Currency. | ||||
| XLA_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded Credit amount for the journal line in Global Currency. |
Copyright © 2019, 2024, Oracle and/or its affiliates.