DW_FA_MC_ASSET_SOURCE_LINES_D

This is the Dimension table for Fixed asset source lines details

Details

Module: Assets

Key Columns

LEDGER_ID, SOURCE_LINE_ID, MC_FLAG

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SOURCE_LINE_ID NUMBER 38 0 True Identifier of the asset source line.
LEDGER_ID NUMBER 38 0 True Identifier of the accounting ledger
MC_FLAG VARCHAR2 16 True Flag to indicate the source of data is MC or Regular dataset
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of invoice identifier.
FEEDER_SYSTEM_NAME VARCHAR2 64 Name of the feeder system that created the FA_MASS_ADDITIONS row.
FIXED_ASSETS_COST NUMBER Cost of the asset for the lines.
PAYABLES_COST NUMBER Invoice cost from Oracle Fusion Payables.
PAYABLES_UNITS NUMBER Units from Payables invoice distribution.
INVOICE_ID NUMBER 38 0 Identifier of the Oracle Fusion Payables invoice.
INVOICE_NUMBER VARCHAR2 64 Invoice number from Oracle Fusion Payables.
DESCRIPTION VARCHAR2 128 Description of the asset invoice.
INVOICE_DATE DATE Invoice date for asset invoices from Oracle Fusion Payables.
INVOICE_LINE_NUMBER NUMBER Identifier for the line of the Oracle Fusion Payables invoice.
INVOICE_LINE_TYPE VARCHAR2 32 Type of invoice line. It is based on INVOICE LINE TYPE lookup codes like FREIGHT,TAX,ITEM etc.
INVOICE_LINE_DESCRIPTION VARCHAR2 256 Description of the invoice line.
VENDOR_NAME VARCHAR2 512 Name of the purchase order vendor.
PO_NUMBER VARCHAR2 32 Identifier of the purchase order for the mass addition line.
INVOICE_PAYMENT_NUMBER NUMBER 38 0 The invoice payment number made to the supplier for each invoice.
PROJECT_ID NUMBER 38 0 Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Fusion Projects.
PROJECT_NUMBER VARCHAR2 32 Number of the project from which the costs are collected, summarized, and transferred from Oracle Fusion Projects.
PROJECT_TASK_NUMBER VARCHAR2 128 User-defined number of the task from which costs are collected, summarized, and transferred from Oracle Fusion Project Costing. This column is populated only if the costs were summarized by task.
PROJECT_ORGANIZATION_ID NUMBER 38 0 The organization that is responsible for the project work.
TASK_ORGANIZATION_ID NUMBER 38 0 The task organization that is responsible for the work task. This is a task-specific attribute.
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0 The expenditure expendature organization that is responsible for the work task. This is a task-specific attribute.
PROJECT_TXN_DOC_ENTRY_ID NUMBER 38 0 Identifies a project document entry.
EXPENDITURE_TYPE_ID NUMBER 38 0 The project expenditure classification type.
ASSET_ID NUMBER 38 0 Identifier of the asset number.
DATE_EFFECTIVE DATE Date when the row became effective.
DATE_INEFFECTIVE DATE Date when the row became inactive.
TASK_ID NUMBER 38 0 Identifier of the task from which costs are collected, summarized, and transferred from Oracle Fusion Project Costing. This column is populated only if the costs were summarized by task.
BOOK_TYPE_CODE VARCHAR2 32 Unique book identification name
LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency of the ledger.
INVOICE_LINE_TYPE_LKP_CODE VARCHAR2 128
CREATION_DATE TIMESTAMP Creation Date