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, MC_FLAG, SOURCE_LINE_ID

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    

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