# DW_FA_MC_ASSET_SOURCE_LINES_D

This is the Dimension table for Fixed asset source lines details

## Details

Module: Assets

## Key Columns

SOURCE_LINE_ID, MC_FLAG, LEDGER_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 |  |
VENDOR_NUMBER | VARCHAR2 | 32 |  |  | Number of the purchase order vendor. |  |
LINE_TYPE_LOOKUP_CODE | VARCHAR2 | 32 |  |  | Type of invoice distribution. It is based on INVOICE DISTRIBUTION TYPE lookup codes like ITEM,ERV, FREIGHT, TAX, etc. |  |
AP_DISTRIBUTION_LINE_NUMBER | NUMBER | 38 | 0 |  | Distribution line number from Oracle Fusion Payables. |  |
PROJECT_ASSET_LINE_ID | NUMBER | 38 | 0 |  | Identifier of the summarized asset cost line transferred from Oracle Fusion Project Costing to create the line. |  |
INVOICE_VOUCHER_NUMBER | VARCHAR2 | 64 |  |  | Invoice voucher number from Oracle Fusion Payables. |  |
INVOICE_DISTRIBUTION_ID | NUMBER | 38 | 0 |  | Identifier of the distribution line for the Oracle Fusion Payables invoice. |  |
PO_DISTRIBUTION_ID | NUMBER | 38 | 0 |  | Identifier of the purchase order distribution. |  |
PO_VENDOR_ID | NUMBER | 38 | 0 |  | Identifier of the purchase order vendor. |  |

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