This is the Dimension table for Fixed asset source lines details
Module: Assets
MC_FLAG, LEDGER_ID, SOURCE_LINE_ID
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 | 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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.