This table requires activation of Project Asset functional area. Fact table to show Project Asset Line details
Module: Project Costing
PROJ_ASSET_LINE_DTL_UNIQ_ID
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, 2022, Oracle and/or its affiliates.