FA_ASSET_INVOICES
FA_ASSET_INVOICES contains the invoice information from Oracle Fusion Payables and Oracle Fusion Purchasing for the assets to track the source asset information. This table also stores all costs interfaced from projects including labor and expenses. Oracle Fusion Assets inserts a row into this table for each asset added with source line information.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FA_ASSET_INVOICES_PK |
SOURCE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number. | ||
| PO_VENDOR_ID | NUMBER | 18 | Identifier of the purchase order vendor. | |||
| ASSET_INVOICE_ID | NUMBER | 18 | Identifier of the asset invoice. | |||
| FIXED_ASSETS_COST | NUMBER | Cost of the asset for the lines. | ||||
| DATE_EFFECTIVE | DATE | Yes | Date when the row became effective. | |||
| DATE_INEFFECTIVE | DATE | Date when the row became inactive. | ||||
| INVOICE_TRANSACTION_ID_IN | NUMBER | 18 | Identifier of the source line transaction that created the row. | |||
| INVOICE_TRANSACTION_ID_OUT | NUMBER | 18 | Identifier of the source line transaction that terminated the row. | |||
| DELETED_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether or not to include the row in the current total asset cost. | ||
| PO_NUMBER | VARCHAR2 | 30 | Identifier of the purchase order for the mass addition line. | |||
| INVOICE_NUMBER | VARCHAR2 | 50 | Invoice number from Oracle Fusion Payables. | |||
| PAYABLES_BATCH_NAME | VARCHAR2 | 50 | Payables batch name in the mass addition lines. | |||
| PAYABLES_CODE_COMBINATION_ID | NUMBER | 18 | Identifier of the clearing account used in Payables invoice distributions for the line. | |||
| FEEDER_SYSTEM_NAME | VARCHAR2 | 40 | Name of the feeder system that created the FA_MASS_ADDITIONS row. | |||
| CREATE_BATCH_DATE | DATE | Who column: indicates the date and time of the creation of the mass additions batch. | ||||
| CREATE_BATCH_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the mass additions create job that last created the row. | |||
| INVOICE_DATE | DATE | Invoice date for asset invoices from Oracle Fusion Payables. | ||||
| PAYABLES_COST | NUMBER | Invoice cost from Oracle Fusion Payables. | ||||
| POST_BATCH_ID | NUMBER | 18 | Identifier of the post mass additions request for the row. | |||
| INVOICE_ID | NUMBER | 18 | Identifier of the Oracle Fusion Payables invoice. | |||
| AP_DISTRIBUTION_LINE_NUMBER | NUMBER | 18 | Distribution line number from Oracle Fusion Payables. | |||
| PAYABLES_UNITS | NUMBER | Units from Payables invoice distribution. | ||||
| SPLIT_MERGED_CODE | VARCHAR2 | 3 | Indicator to determine whether the invoice line is split or merged. | |||
| DESCRIPTION | VARCHAR2 | 80 | Description of the asset invoice. | |||
| PARENT_MASS_ADDITION_ID | NUMBER | 18 | Identifier of the parent mass addition line. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Assets Invoices (FA_ASSET_INVOICES) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| UNREVALUED_COST | NUMBER | Cost without regard to any revaluations. | ||||
| MERGED_CODE | VARCHAR2 | 3 | Source line merge status which indicates whether the mass addition is a merge parent or a merge child. | |||
| SPLIT_CODE | VARCHAR2 | 3 | Mass addition indicator to determine whether it is a split parent or a split child. | |||
| MERGE_PARENT_MASS_ADDITIONS_ID | NUMBER | 18 | Identifier of the merge parent mass addition line. | |||
| SPLIT_PARENT_MASS_ADDITIONS_ID | NUMBER | 18 | Identifier of the split parent mass addition line. | |||
| PROJECT_ASSET_LINE_ID | NUMBER | 18 | Identifier of the summarized asset cost line transferred from Oracle Fusion Projects to create this line. | |||
| PROJECT_ID | NUMBER | 18 | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Fusion Projects. | |||
| TASK_ID | NUMBER | 18 | 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. | |||
| SOURCE_LINE_ID | NUMBER | 18 | Yes | Identifier of the asset source line. | ||
| DEPRECIATE_IN_GROUP_FLAG | VARCHAR2 | 1 | Option indicating whether the source line will be included in the depreciation basis of any associated group asset. | |||
| MATERIAL_INDICATOR_FLAG | VARCHAR2 | 1 | Option indicating whether the source line is material or nonmaterial in nature. | |||
| PRIOR_SOURCE_LINE_ID | NUMBER | 18 | Identifier of the source line corresponding to the row terminated by the invoice transaction which created the row. | |||
| INVOICE_DISTRIBUTION_ID | NUMBER | 18 | Identifier of the distribution line for the Oracle Fusion Payables invoice. | |||
| INVOICE_LINE_NUMBER | NUMBER | Identifier for the line of the Oracle Fusion Payables invoice. | ||||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Identifier of the clearing account used in purchase order distributions for the line. | |||
| INVOICE_LINE_TYPE | VARCHAR2 | 30 | Type of invoice line. It is based on INVOICE LINE TYPE lookup codes like FREIGHT,TAX,ITEM etc. | |||
| LINE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Type of invoice distribution. It is based on INVOICE DISTRIBUTION TYPE lookup codes like ITEM,ERV, FREIGHT, TAX, etc. | |||
| INVOICE_LINE_DESCRIPTION | VARCHAR2 | 240 | Description of the invoice line. | |||
| PROJECT_ORGANIZATION_ID | NUMBER | 18 | The organization that is responsible for the project work. | |||
| TASK_ORGANIZATION_ID | NUMBER | 18 | The task organization that is responsible for the work task. This is a task-specific attribute. | |||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | The expenditure expendature organization that is responsible for the work task. This is a task-specific attribute. | |||
| PROJECT_TXN_DOC_ENTRY_ID | NUMBER | 18 | Identifies a project document entry. | |||
| INVOICE_PAYMENT_ID | NUMBER | 18 | The invoice payment made to the supplier for each invoice. | |||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | The project expenditure classification type. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | The name of the asset book. | |||
| CORP_SOURCE_LINE_ID | NUMBER | 18 | The source line's unique identifier in the corporate book. | |||
| VENDOR_NUMBER | VARCHAR2 | 30 | Number of the purchase order vendor. | |||
| VENDOR_NAME | VARCHAR2 | 360 | Name of the purchase order vendor. | |||
| INVOICE_VOUCHER_NUMBER | VARCHAR2 | 50 | Invoice voucher number from Oracle Fusion Payables. | |||
| INVOICE_PAYMENT_NUMBER | NUMBER | 18 | The invoice payment number made to the supplier for each invoice. | |||
| PROJECT_NUMBER | VARCHAR2 | 25 | Number of the project from which the costs are collected, summarized, and transferred from Oracle Fusion Projects. | |||
| PROJECT_TASK_NUMBER | VARCHAR2 | 100 | 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. | |||
| SHIP_TO_CUST_LOCATION_ID | NUMBER | 18 | Customer location identifier indicating where the supplier shipped the goods. | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Internal location identifier indicating where the supplier shipped the goods. | |||
| IB_REFERENCE_ID | NUMBER | 18 | The reference identifier used to link a fixed asset with an installed base asset. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FA_ASSET_INVOICES | fa_additions_b | ASSET_ID |
| FA_ASSET_INVOICES | ap_invoices_all | INVOICE_ID |
| FA_ASSET_INVOICES | ap_invoice_distributions_all | INVOICE_DISTRIBUTION_ID |
| FA_ASSET_INVOICES | fa_invoice_transactions | INVOICE_TRANSACTION_ID_OUT |
| FA_ASSET_INVOICES | pjf_proj_elements_b | TASK_ID |
| FA_ASSET_INVOICES | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
| FA_ASSET_INVOICES | fa_mass_additions | PARENT_MASS_ADDITION_ID |
| FA_ASSET_INVOICES | fa_mass_additions | MERGE_PARENT_MASS_ADDITIONS_ID |
| FA_ASSET_INVOICES | fa_mass_additions | SPLIT_PARENT_MASS_ADDITIONS_ID |
| FA_ASSET_INVOICES | fa_invoice_transactions | INVOICE_TRANSACTION_ID_IN |
| FA_ASSET_INVOICES | po_distributions_all | PO_DISTRIBUTION_ID |
| FA_ASSET_INVOICES | pjf_projects_all_b | PROJECT_ID |
| FA_ASSET_INVOICES | gl_code_combinations | PAYABLES_CODE_COMBINATION_ID |
| FA_ASSET_INVOICES | ap_invoice_lines_all | INVOICE_ID, INVOICE_LINE_NUMBER |
| FA_ASSET_INVOICES | poz_suppliers | PO_VENDOR_ID |
| fa_adj_src_lines_t | fa_asset_invoices | SOURCE_LINE_ID |
| fa_adjustments | fa_asset_invoices | SOURCE_LINE_ID |
| fa_mc_adjustments | fa_asset_invoices | SOURCE_LINE_ID |
| fa_ret_src_lines_t | fa_asset_invoices | SOURCE_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_ASSET_INVOICES_N1 | Non Unique | Default | ASSET_ID, PO_VENDOR_ID, INVOICE_NUMBER |
| FA_ASSET_INVOICES_N2 | Non Unique | Default | ASSET_ID, PO_VENDOR_ID, PO_NUMBER |
| FA_ASSET_INVOICES_N3 | Non Unique | Default | PO_NUMBER |
| FA_ASSET_INVOICES_N4 | Non Unique | Default | ASSET_INVOICE_ID |
| FA_ASSET_INVOICES_N5 | Non Unique | Default | PO_VENDOR_ID |
| FA_ASSET_INVOICES_N6 | Non Unique | Default | PROJECT_ASSET_LINE_ID |
| FA_ASSET_INVOICES_N7 | Non Unique | Default | INVOICE_DISTRIBUTION_ID |
| FA_ASSET_INVOICES_U1 | Unique | Default | SOURCE_LINE_ID |