Asset Invoices
The Asset Invoices view object contains invoice information from Oracle Fusion Payables and Oracle Fusion Purchasing to track source asset information. It stores all costs imported from projects, including labor and expenses. Oracle Fusion Assets inserts a row into this table for each asset added with source line information.
Data Store Key : FscmTopModelAM.FinExtractAM.FaBiccExtractAM.AssetInvoiceExtractPVO
Primary Keys : AssetInvoiceSourceLineId
Initial Extract Date : AssetInvoiceCreationDate
Incremental Extract Date : AssetInvoiceLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AssetInvoiceApDistributionLineNumber | Distribution line number from Oracle Fusion Payables. |
| AssetInvoiceAssetId | Identifier of the asset number. |
| AssetInvoiceAssetInvoiceId | Identifier of the asset invoice. |
| AssetInvoiceAttribute1 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute10 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute11 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute12 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute13 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute14 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute15 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute2 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute3 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute4 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute5 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute6 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute7 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute8 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttribute9 | A segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeCategoryCode | The context name for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeDate1 | A date segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeDate2 | A date segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeDate3 | A date segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeDate4 | A date segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeDate5 | A date segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeNumber1 | A number segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeNumber2 | A number segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeNumber3 | A number segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeNumber4 | A number segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceAttributeNumber5 | A number segment for the Asset Invoices descriptive flexfield. |
| AssetInvoiceBookTypeCode | The name of the asset book. |
| AssetInvoiceCorpSourceLineId | Unique identifier of the source line in the corporate book. |
| AssetInvoiceCreateBatchDate | The date the mass additions batch was created. |
| AssetInvoiceCreateBatchId | The request ID of the Mass Additions Create process that last created the row. |
| AssetInvoiceCreatedBy | The user who created the Asset Invoice. |
| AssetInvoiceCreationDate | The date the asset invoice was created. |
| AssetInvoiceDateEffective | The date that the invoice is effective. |
| AssetInvoiceDateIneffective | The date that the invoice is ineffective. |
| AssetInvoiceDeletedFlag | Indicates whether the invoice line is deleted. |
| AssetInvoiceDepreciateInGroupFlag | Indicates whether the invoice line amount is included in the group asset cost. |
| AssetInvoiceDescription | The user-entered description for the transaction line. |
| AssetInvoiceExpenditureOrganizationId | The expenditure organization that is responsible for the work task. This is a task-specific attribute. |
| AssetInvoiceExpenditureTypeId | The project expenditure classification type. |
| AssetInvoiceFeederSystemName | Identifies the application that originated the mass addition. |
| AssetInvoiceFixedAssetsCost | Cost of the asset for the lines. |
| AssetInvoiceGlobalAttribute1 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute10 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute11 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute12 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute13 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute14 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute15 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute16 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute17 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute18 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute19 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute2 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute20 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute3 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute4 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute5 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute6 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute7 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute8 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttribute9 | A segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeCategory | The context name for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeDate1 | A date segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeDate2 | A date segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeDate3 | A date segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeDate4 | A date segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeDate5 | A date segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeNumber1 | A number segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeNumber2 | A number segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeNumber3 | A number segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeNumber4 | A number segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceGlobalAttributeNumber5 | A number segment for the Asset Invoices Regional Information global descriptive flexfield. |
| AssetInvoiceInvoiceDate | The date of the asset purchase invoice. |
| AssetInvoiceInvoiceDistributionId | Identifier of the distribution line for the Oracle Fusion Payables invoice. |
| AssetInvoiceInvoiceId | Identifier of the Oracle Fusion Payables invoice. |
| AssetInvoiceInvoiceLineDescription | Description of the invoice line. |
| AssetInvoiceInvoiceLineNumber | Identifier for the line of the Oracle Fusion Payables invoice. |
| AssetInvoiceInvoiceLineType | Indicates whether the invoice line corresponds to an item, tax, freight, or a miscellaneous line. |
| AssetInvoiceInvoiceNumber | Invoice number from Oracle Fusion Payables. |
| AssetInvoiceInvoicePaymentId | The invoice payment made to the supplier for each invoice. |
| AssetInvoiceInvoicePaymentNumber | Unique identifier of the invoice payment. |
| AssetInvoiceInvoiceTransactionIdIn | Identifier of the source line transaction that created the row. |
| AssetInvoiceInvoiceTransactionIdOut | Identifier of the source line transaction that terminated the row. |
| AssetInvoiceInvoiceVoucherNumber | Invoice voucher number from Oracle Fusion Payables. |
| AssetInvoiceLastUpdateDate | The date the invoice line was last updated. |
| AssetInvoiceLastUpdateLogin | The session login associated with the user who last updated the invoice. |
| AssetInvoiceLastUpdatedBy | The user who last updated the invoice. |
| AssetInvoiceLineTypeLookupCode | The type of invoice distribution. It is based on Invoice Distribution Type lookup codes, such as ITEM, ERV, FREIGHT, or TAX. |
| AssetInvoiceMaterialIndicatorFlag | Indicates whether the source line is economically material in nature. |
| AssetInvoiceMergeParentMassAdditionsId | Identifier of the merge parent mass addition line. |
| AssetInvoiceMergedCode | Indicates whether the invoice line is split or merged. |
| AssetInvoiceObjectVersionNumber | The number of times the asset invoice row has been updated. |
| AssetInvoiceParentMassAdditionId | Identifier of the parent mass addition line. |
| AssetInvoicePayablesBatchName | Payables batch name in the mass addition lines. |
| AssetInvoicePayablesCodeCombinationId | Identifier of the clearing account used in Payables invoice distributions for the line. |
| AssetInvoicePayablesCost | Indicates the asset cost in Payables. |
| AssetInvoicePayablesUnits | The number of units that Payables provides for the asset source lines. |
| AssetInvoicePoDistributionId | Identifier of the clearing account used in purchase order distributions for the line. |
| AssetInvoicePoNumber | The identifier of the purchase order. |
| AssetInvoicePoVendorId | Identifier of the purchase order supplier. |
| AssetInvoicePostBatchId | Identifier of the post mass additions request for the row. |
| AssetInvoicePriorSourceLineId | Identifier of the source line corresponding to the row terminated by the invoice transaction that created the row. |
| AssetInvoiceProjectAssetLineId | Identifier of the summarized asset cost line transferred from Oracle Fusion Projects to create this line. |
| AssetInvoiceProjectId | Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Fusion Projects. |
| AssetInvoiceProjectNumber | Number of the project from which the costs are collected, summarized, and transferred from Oracle Fusion Projects. |
| AssetInvoiceProjectOrganizationId | The organization that is assigned to manage the work on a task. |
| AssetInvoiceProjectTaskNumber | 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. |
| AssetInvoiceProjectTxnDocEntryId | The source document from which the expenditure item originated. |
| AssetInvoiceSourceLineId | Identifier of the asset source line. |
| AssetInvoiceSplitCode | Oracle Internal use only. Indicates if the mass addition is a split parent or a split child. |
| AssetInvoiceSplitMergedCode | Indicates if the invoice line is split or merged. |
| AssetInvoiceSplitParentMassAdditionsId | Identifier of the split parent mass addition line. |
| AssetInvoiceTaskId | 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. |
| AssetInvoiceTaskOrganizationId | The task organization that is responsible for the work task. This is a task-specific attribute. |
| AssetInvoiceUnrevaluedCost | Cost without regard to any revaluations. |
| AssetInvoiceVendorName | The name of the purchase order supplier. |
| AssetInvoiceVendorNumber | The supplier number of the purchase order supplier. |