# DW_PROJECT_ASSET_LINE_DTL_CF

Fact table to show Project Asset Line details

## Details

Module: Project Costing

## Key Columns

PROJ_ASSET_LINE_DTL_UNIQ_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROJ_ASSET_LINE_DTL_UNIQ_ID | NUMBER | 38 | 0 | True | Identifier of the Project asset line details |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
EXPENDITURE_ITEM_ID | NUMBER | 38 | 0 |  | The identifier of the expenditure item summarized into the asset line |  |
LINE_NUM | NUMBER | 38 | 0 |  | The identifier of the cost distribution line summarized into the asset line |  |
PROJECT_ASSET_LINE_DETAIL_ID | NUMBER | 38 | 0 |  | The attribute relating detail records to asset lines |  |
CIP_COST | NUMBER |  |  |  | The cip cost amount from the associated cost distribution line. |  |
REVERSED_FLAG | VARCHAR2 | 16 |  |  | Flag indicating whether or not the related asset line has been reversed. |  |
CREATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
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. | DW_DAY_D | CALENDAR_DATE
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
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 | DW_DAY_D | CALENDAR_DATE
PRVDR_PA_PERIOD_NAME | VARCHAR2 | 16 |  |  | The PA period for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
PRVDR_PA_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The PA period type for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
PRVDR_PA_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | PA Calendar Name for Provider business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
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
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
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 | DW_DAY_D | CALENDAR_DATE
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
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 | DW_DAY_D | CALENDAR_DATE
RECVR_PA_PERIOD_NAME | VARCHAR2 | 16 |  |  | The PA period for Receiver business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
RECVR_PA_PERIOD_TYPE | VARCHAR2 | 16 |  |  | The PA period type for Receiver business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
RECVR_PA_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | PA Calendar Name for Receiver business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
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
RECVR_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Receiver Operating Unit Identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
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
TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Identifier of the expenditure type | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
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
EXPENDITURE_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Expenditure Organization for the Expenditure item. | 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
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory item identifier | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
INCURRED_BY_PERSON_ID | NUMBER | 38 | 0 |  | Identifier of employee. | DW_PERSON_D | PERSON_ID
INCURRED_BY_PERSON_TYPE | VARCHAR2 | 32 |  |  | Identifies the type of person - employee or contingent worker. | DW_EXP_PERSON_TYPE_LKP_TL | PERSON_TYPE
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
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
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 |  |
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 |  |
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project unit assigned to the project | DW_INTERNAL_ORG_D | ORGANIZATION_ID
EXPENDITURE_ITEM_DATE | DATE |  |  |  | The date on which the work occurred | DW_DAY_D | CALENDAR_DATE
RESOURCE_CLASS_CODE | VARCHAR2 | 32 |  |  | Resource Class name. |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.