DW_PROJECT_ASSET_LINE_DTL_CF (Preview)

This table requires activation of Project Asset functional area. 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     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, 2023, Oracle and/or its affiliates.