Invoice Lines

The invoice lines view object contains information about invoice lines for a supplier invoice such as line number, line type lookup code, amount, description and so on. An invoice can have one or more invoice lines. The combination of ApInvoiceLinesAllInvoiceId and ApInvoiceLinesAllLineNumber forms the primary key for this view object.

Data Store Key : FscmTopModelAM.FinExtractAM.ApBiccExtractAM.InvoiceLineExtractPVO

Primary Keys : ApInvoiceLinesAllInvoiceId, ApInvoiceLinesAllLineNumber

Initial Extract Date : ApInvoiceLinesAllCreationDate

Incremental Extract Date : ApInvoiceLinesAllLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ApInvoiceLinesAllAccountSegment	The overlay account segment value overwrites the defaulted account segment value for an invoice line. The account segment is that part of the distribution combination that determines whether an account is an asset, liability, owner's equity, revenue, or expense account.
ApInvoiceLinesAllAccountingDate	The accounting date for the invoice line. It is used to default the accounting date to invoice distributions.
ApInvoiceLinesAllAdjustmentReason	The reason for the invoice line adjustment.
ApInvoiceLinesAllAmount	The line amount in the invoice currency.
ApInvoiceLinesAllApplicationId	The unique identifier of the application from which the invoice originated.
ApInvoiceLinesAllAssessableValue	The deemed price at which a product is valued by a tax authority, for tax calculation purposes.
ApInvoiceLinesAllAssetBookTypeCode	The asset book associated with the row. The value is populated by default to the distributions candidate for transfer to Oracle Fusion Assets.
ApInvoiceLinesAllAssetCategoryId	The asset category under which this asset line will be grouped. The value is populated by default to the invoice distributions for transferring to Oracle Fusion Assets.
ApInvoiceLinesAllAssetsTrackingFlag	Indicates if the item should be transferred to Oracle Fusion Assets. The value can either be provided while creating an invoice line or populated by default to true if an asset account is provided in the distribution combination. If the value if true, then it indicates the item should be transferred to Oracle Fusion Assets.
ApInvoiceLinesAllAttribute1	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute10	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute11	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute12	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute13	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute14	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute15	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute2	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute3	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute4	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute5	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute6	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute7	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute8	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttribute9	A segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeCategory	The context name for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeDate1	A date segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeDate2	A date segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeDate3	A date segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeDate4	A date segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeDate5	A date segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeNumber1	A number segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeNumber2	A number segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeNumber3	A number segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeNumber4	A number segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAttributeNumber5	A number segment for the Payables Invoice Lines descriptive flexfield.
ApInvoiceLinesAllAwardId	The identifier for the award associated with the invoice line. Used by Oracle Fusion Grants Management.
ApInvoiceLinesAllAwtGroupId	The identifier of the withholding tax group.
ApInvoiceLinesAllBalancingSegment	The overlay balancing segment overwrites the defaulted balancing segment for an invoice line. A balancing segment is a segment that you define so that Oracle Fusion General Ledger automatically balances all journal entries for each value of this segment.
ApInvoiceLinesAllBaseAmount	The invoice line amount in the ledger currency.
ApInvoiceLinesAllBudgetDate	The budgetary calendar period date applicable for funds checking.
ApInvoiceLinesAllCancelledFlag	Indicates whether an invoice line is canceled. Possible values are null, Y or N. If the value is Y, then it indicates that the line has been canceled.
ApInvoiceLinesAllCcReversalFlag	Indicates if the prepaid credit card transaction line distributions are reversed or not. A value of Y indicates that the distributions are reversed.
ApInvoiceLinesAllCompanyPrepaidInvoiceId	The identifier of the invoice for prepaid credit card transactions.
ApInvoiceLinesAllConsumptionAdviceHeaderId	The identifier of the consignment advice associated with the invoice line.
ApInvoiceLinesAllConsumptionAdviceLineId	The identifier of the consignment advice line associated with the invoice line.
ApInvoiceLinesAllControlAmount	The user-entered value to ensure that the calculated tax will be the same as the tax on the physical document.
ApInvoiceLinesAllCorrectedInvId	The identifier of the invoice corrected by this invoice line. Used for price, quantity, or invoice line corrections.
ApInvoiceLinesAllCorrectedLineNumber	The line number of the invoice line corrected by this line. Used for price, quantity, or invoice line corrections.
ApInvoiceLinesAllCostCenterSegment	The overlay cost center segment overwrites the defaulted cost center segment for an invoice line. The cost center segment is an organizational element of a chart of accounts typically used for assigning revenues and expenses.
ApInvoiceLinesAllCostFactorId	The identifier of the cost component class. This is used to validate imported invoices for cost component classes. Cost component classes are used to identify the individual buckets or component costs that make up the total cost of an item like direct material costs, freight costs, labor costs, production or conversion costs and so on.
ApInvoiceLinesAllCountryOfSupply	The country where services or goods were originated. Used for expense reports.
ApInvoiceLinesAllCreatedBy	The user who created the invoice line.
ApInvoiceLinesAllCreationDate	The date and time when the invoice line was created.
ApInvoiceLinesAllCreditCardTrxId	The identifier of the credit card transaction.
ApInvoiceLinesAllDailyAmount	The amount of the daily expense receipt. Used for expense reports.
ApInvoiceLinesAllDefAcctgAclCcid	The accrual account used in multiperiod accounting to accrue deferred expenses.
ApInvoiceLinesAllDefAcctgEndDate	The multiperiod accounting end date on the invoice line.
ApInvoiceLinesAllDefAcctgNumberOfPeriods	The number of periods for multiperiod accounting to accrue deferred expenses.
ApInvoiceLinesAllDefAcctgPeriodType	The period type for multiperiod accounting to accrue deferred expenses.
ApInvoiceLinesAllDefAcctgStartDate	The multiperiod accounting start date on the invoice line.
ApInvoiceLinesAllDefaultDistCcid	The accounting flexfield used for automatic generation of a single distribution.
ApInvoiceLinesAllDeferredAcctgFlag	Indicates whether the expense is allocated across multiple accounting periods.
ApInvoiceLinesAllDescription	The description of the invoice line.
ApInvoiceLinesAllDiscardedFlag	Indicates that the line is canceled when an invoice is canceled. When a line is canceled all its distributions are reversed and the amount is set to 0. The default value is false. If the value is true, then it indicates that the line has been canceled.
ApInvoiceLinesAllDisputableFlag	Indicates whether the line is disputable.
ApInvoiceLinesAllDistributionSetId	The identifier of the distribution set used to generate distributions for an invoice line.
ApInvoiceLinesAllEndExpenseDate	The last day of an expense that spans multiple days. Used for expense reports.
ApInvoiceLinesAllExpenditureItemDate	The expenditure item date for project-related invoice lines.
ApInvoiceLinesAllExpenditureOrganizationId	The identifier for the project expenditure organization associated with the invoice line.
ApInvoiceLinesAllExpenditureType	The expenditure type for project-related invoice lines.
ApInvoiceLinesAllExpenseGroup	The expense group associated with the invoice line.
ApInvoiceLinesAllFinalDischargeLocationId	The location of the final destination for the purchases made.
ApInvoiceLinesAllFinalMatchFlag	Indicates if an invoice is the last one being matched to a purchase order, making the purchase order schedule no longer available for matching to other invoices. A value of Y indicates the purchase order schedule is finally closed and invoices can no longer be matched to it.
ApInvoiceLinesAllFosXfaceFlag	Indicates whether the invoice line information has been interfaced to Supply Chain Financial Flow Orchestration.
ApInvoiceLinesAllFundsStatus	The status of the funds check and reservation for the invoice line. A list of accepted values is defined in the lookup type XCC_BC_FUNDS_STATUSES.
ApInvoiceLinesAllGenerateDists	Indicates whether distributions for the invoice line should be generated dynamically whenever possible.
ApInvoiceLinesAllGlobalAttribute1	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute10	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute11	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute12	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute13	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute14	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute15	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute16	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute17	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute18	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute19	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute2	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute20	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute3	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute4	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute5	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute6	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute7	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute8	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttribute9	A segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeCategory	The context name for the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeDate1	A date segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeDate2	A date segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeDate3	A date segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeDate4	A date segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeDate5	A date segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeNumber1	A number segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeNumber2	A number segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeNumber3	A number segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeNumber4	A number segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllGlobalAttributeNumber5	A number segment of the Payables Invoice Lines global descriptive flexfield.
ApInvoiceLinesAllHistoricalFlag	Indicates whether the invoice has been upgraded from a prior release or has been newly created.
ApInvoiceLinesAllIncludedTaxAmount	The amount of tax that is included in the invoice.
ApInvoiceLinesAllIncomeTaxRegion	The reporting region for the invoice line for the 1099 supplier.
ApInvoiceLinesAllIntendedUseClassifId	The identifier of the tax driver used to determine and calculate the applicable taxes for the line.
ApInvoiceLinesAllInventoryItemId	The identifier of the inventory item on the invoice line.
ApInvoiceLinesAllInvoiceId	The unique invoice identifier that is generated while creating an invoice. This attribute is part of the primary key for the Invoice Lines view object.
ApInvoiceLinesAllInvoiceIncludesPrepayFlag	Indicates whether the prepayment is included in the invoice amount. Possible values are Y and N. A value of Y indicates that prepayment is included.
ApInvoiceLinesAllItemDescription	The description of the item on the invoice line.
ApInvoiceLinesAllJustification	The reason an expense was incurred. Used for expense reports.
ApInvoiceLinesAllLastUpdateDate	The date and time when the invoice line was last updated.
ApInvoiceLinesAllLastUpdateLogin	The session login of the user of the user who last updated the invoice line.
ApInvoiceLinesAllLastUpdatedBy	The use who last updated the invoice line.
ApInvoiceLinesAllLcmEnabledFlag	Indicates if the invoice line is enabled for landed cost.
ApInvoiceLinesAllLineGroupNumber	The line group number assigned to the line during the Import Payables Invoices process. This is used for allocation of charge lines during the import process.
ApInvoiceLinesAllLineNumber	The unique number for the invoice line. This attribute is part of the primary key for the Invoice Lines view object.
ApInvoiceLinesAllLineSelectedForApplFlag	Indicates if the line on the prepayment invoice is selected for prepayment application.
ApInvoiceLinesAllLineSelectedForReleaseFlag	Indicates that the invoice line is being processed for retainage release. A value of Y indicates that the line is under processing.
ApInvoiceLinesAllLineSource	The source of the invoice line. A list of accepted values is defined in the lookup type LINE SOURCE.
ApInvoiceLinesAllLineTypeLookupCode	The type of invoice line. The value must be provided while creating an invoice line. A list of accepted values is defined in the lookup type INVOICE LINE TYPE
ApInvoiceLinesAllManufacturer	The name of the manufacturer of the asset or item on the invoice line.
ApInvoiceLinesAllMatchType	Indicates if the invoice is matched to a purchase order or to a receipt of material. A list of accepted values is defined in the lookup type INVOICE LINE MATCH TYPE.
ApInvoiceLinesAllMerchantDocumentNumber	The number on the receipt issued by the merchant. Used for expense reports.
ApInvoiceLinesAllMerchantName	Name of the merchant where the expense was incurred. Used for expense reports.
ApInvoiceLinesAllMerchantReference	Purchase identification of a transaction provided by the merchant at the point of sale. Used for expense reports.
ApInvoiceLinesAllMerchantTaxRegNumber	Unique sequence of letters or numbers assigned to the merchant by a tax authority when it is registered and by which the merchant registration is identified.
ApInvoiceLinesAllMerchantTaxpayerId	The unique identifier of the merchant tax payer.
ApInvoiceLinesAllModelNumber	The model number of the invoice line item.
ApInvoiceLinesAllObjectVersionNumber	The number of times that the invoice line has been updated.
ApInvoiceLinesAllOrgId	The identifier of the business unit associated with the invoice line.
ApInvoiceLinesAllOriginalAmount	The original amount of the invoice line before the line or invoice was canceled.
ApInvoiceLinesAllOriginalBaseAmount	The original amount of the invoice line before the line or invoice was canceled in the ledger currency.
ApInvoiceLinesAllOriginalRoundingAmt	The rounding amount of the invoice line before it was canceled.
ApInvoiceLinesAllOverlayDistCodeConcat	The distribution combination that overwrites the intended distribution combination for an invoice line.
ApInvoiceLinesAllPaCcArInvoiceId	For an intercompany invoice from Oracle Fusion Projects, this is the identifier of the corresponding receivable intercompany invoice in Oracle Fusion Receivables.
ApInvoiceLinesAllPaCcArInvoiceLineNum	For an intercompany invoice from Oracle Fusion Projects, this is the line number of the corresponding receivable intercompany invoice in Oracle Fusion Receivables.
ApInvoiceLinesAllPaCcProcessedCode	The processing status of the invoice line by Oracle Fusion Projects in the receiving business unit.
ApInvoiceLinesAllPaQuantity	The quantity billed to a project.
ApInvoiceLinesAllPeriodName	The accounting period for the invoice line.
ApInvoiceLinesAllPjcBillableFlag	Indicates whether a project-related item is available to be billed to customers.
ApInvoiceLinesAllPjcCapitalizableFlag	Indicates whether a project-related item is eligible for capitalization.
ApInvoiceLinesAllPjcContextCategory	The segment used to identify the descriptive flexfield application context for project-related standardized code collection.
ApInvoiceLinesAllPjcContractId	The identifier of the project contract associated with the expenditure. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.
ApInvoiceLinesAllPjcContractLineId	The identifier of the project contract line. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.
ApInvoiceLinesAllPjcExpenditureItemDate	The date on which work is performed and is charged to a project and task.
ApInvoiceLinesAllPjcExpenditureTypeId	The identifier of the expenditure type. An expenditure type is a classification of cost that you assign to each expenditure item. Expenditure types are grouped into cost groups or expenditure categories and revenue groups or revenue categories.
ApInvoiceLinesAllPjcFundingAllocationId	The identifier of the project funding allocation.
ApInvoiceLinesAllPjcOrganizationId	The organization that the incurring employee is assigned unless overridden by organization overrides for time cards and expense reports. Additionally, the incurring organization entered on the expenditure for usage, supplier invoices, and purchasing commitments.
ApInvoiceLinesAllPjcProjectId	The identifier of the number assigned to a project.
ApInvoiceLinesAllPjcReservedAttribute1	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute10	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute2	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute3	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute4	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute5	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute6	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute7	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute8	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcReservedAttribute9	Reserved for future project-related functionality. This attribute is currently unused.
ApInvoiceLinesAllPjcTaskId	The identifier of the project task used to build the transaction descriptive flexfield for project related invoice line distributions.
ApInvoiceLinesAllPjcUserDefAttribute1	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute10	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute2	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute3	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute4	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute5	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute6	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute7	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute8	Reserved for user-defined project information.
ApInvoiceLinesAllPjcUserDefAttribute9	Reserved for user-defined project information.
ApInvoiceLinesAllPjcWorkTypeId	The identifier of the project work type classification of the work performed on a project.
ApInvoiceLinesAllPoDistributionId	The identifier of the purchase order distribution line which is associated with the invoice line.
ApInvoiceLinesAllPoHeaderId	The identifier of the purchase order document number that is matched to the invoice line.
ApInvoiceLinesAllPoLineId	The identifier of the purchase order line number that is matched to the invoice line.
ApInvoiceLinesAllPoLineLocationId	The identifier of the ship-to location for the purchase order schedule.
ApInvoiceLinesAllPoReleaseId	The identifier of the purchase order release associated with the invoice correction.
ApInvoiceLinesAllPrepayApplRequestId	The request identifier of the Import Payables Invoices process that is used to lock a particular invoice line in the database while processing it.
ApInvoiceLinesAllPrepayInvoiceId	The identifier of the prepayment invoice applied to the invoice line.
ApInvoiceLinesAllPrepayLineNumber	The line number of the prepayment line applied to the invoice line.
ApInvoiceLinesAllPrimaryIntendedUse	A tax driver used to determine and calculate the applicable taxes for the line.
ApInvoiceLinesAllProdFcCategId	The identifier of the tax classification used by a tax authority to categorize a product.
ApInvoiceLinesAllProductCategory	The taxable nature of a noninventory based item to determine tax or tax reporting purposes.
ApInvoiceLinesAllProductFiscClassification	The tax classification used by a tax authority to categorize a product.
ApInvoiceLinesAllProductTable	The name of the product source table used for generating the invoice line. This is used during Import Payables Invoices process.
ApInvoiceLinesAllProductType	The type of product that defaults from the inventory item attributes. Possible values are Goods or Services.
ApInvoiceLinesAllProgramApplicationId	The application that last updated the invoice line.
ApInvoiceLinesAllProgramId	The process that last updated the invoice line.
ApInvoiceLinesAllProgramUpdateDate	The date on which the process last updated the invoice line.
ApInvoiceLinesAllProjectId	The unique identifier of the project associated with the invoice line.
ApInvoiceLinesAllProrateAcrossAllItems	Indicates that the Freight or Miscellaneous type line should be prorated across all existing Item type lines. The default value is false. If the value if true, then it indicates the charge line should be prorated across all item type lines.
ApInvoiceLinesAllPurchasingCategoryId	The unique identifier for the item category.
ApInvoiceLinesAllQuantityInvoiced	The quantity of items invoiced including matched invoice lines, price corrections, quantity corrections, and unmatched invoice lines.
ApInvoiceLinesAllRcvShipmentLineId	The unique identifier of the receipt shipment line. This is used for receipt matching for the invoice line.
ApInvoiceLinesAllRcvTransactionId	The unique identifier of the shipment receipt to which the invoice line is matched.
ApInvoiceLinesAllReceiptConversionRate	The conversion rate used for conversion from receipt currency to ledger currency. Used for expense reports.
ApInvoiceLinesAllReceiptCurrencyAmount	The line amount in the expense receipt currency. Used for expense reports.
ApInvoiceLinesAllReceiptCurrencyCode	The currency of the expense receipt. Used for expense reports.
ApInvoiceLinesAllReceiptMissingFlag	Indicates whether receipts are missing for an expense. Used for expense reports.
ApInvoiceLinesAllReceiptRequiredFlag	Indicates whether an expense requires a receipt. Used for expense reports.
ApInvoiceLinesAllReceiptVerifiedFlag	Indicates whether an auditor verified the receipt for an expense. Used for expense reports.
ApInvoiceLinesAllReference1	Reference to a record in another application.
ApInvoiceLinesAllReference2	Reference to a record in another application.
ApInvoiceLinesAllReferenceKey1	The primary key information that uniquely identifies a record in another product's view.
ApInvoiceLinesAllReferenceKey2	The primary key information that uniquely identifies a record in another product's view.
ApInvoiceLinesAllReferenceKey3	The primary key information that uniquely identifies a record in another product's view.
ApInvoiceLinesAllReferenceKey4	The primary key information that uniquely identifies a record in another product's view.
ApInvoiceLinesAllReferenceKey5	The primary key information that uniquely identifies a record in another product's view.
ApInvoiceLinesAllRequestId	The identifier of the schedule process request that created or last updated the invoice line.
ApInvoiceLinesAllRequesterId	The name of the person who requested the goods or services.
ApInvoiceLinesAllRetainedAmount	Retained amount on the invoice line of the standard invoice.
ApInvoiceLinesAllRetainedAmountRemaining	Retained amount available for release on the standard invoice line.
ApInvoiceLinesAllRetainedInvoiceId	The identifier of the original invoice on which the amount was retained. This attribute is populated for the invoice lines of the retainage release invoice.
ApInvoiceLinesAllRetainedLineNumber	The line number of the original invoice on which the amount was retained. This attribute is populated for the invoice lines of the retainage release invoice.
ApInvoiceLinesAllRoundingAmt	The amount that was added to the line to ensure that the total of the line amounts add up to the invoice amount in ledger currency.
ApInvoiceLinesAllSerialNumber	The serial number of an asset or item on the invoice line.
ApInvoiceLinesAllSetOfBooksId	The unique identifier of the ledger associated with the invoice line.
ApInvoiceLinesAllShipFromLocationId	The identifier of the ship-from location.
ApInvoiceLinesAllShipToLocationId	The identifier of the ship-to location. This refers to the location where the goods and services have been shipped to by the supplier.
ApInvoiceLinesAllSourceApplicationId	The identifier of the source document application.
ApInvoiceLinesAllSourceEntityCode	Indicates the source of the invoice lines. This is used during Import Payables Invoices process.
ApInvoiceLinesAllSourceEventClassCode	The class code of the source document event.
ApInvoiceLinesAllSourceLineId	The identifier of the source document transaction line.
ApInvoiceLinesAllSourceTrxId	The identifier of the source document transaction.
ApInvoiceLinesAllSourceTrxLevelType	The level at which the source document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
ApInvoiceLinesAllStartExpenseDate	The date when the expense occurred or the first day of an expense that spans multiple days. Used for expense reports.
ApInvoiceLinesAllStatAmount	The amount associated with a distribution for measuring statistical quantities.
ApInvoiceLinesAllSummaryTaxLineId	The unique identifier of the summary line associated with the tax line.
ApInvoiceLinesAllTaskId	The identifier for the project task for project-related invoice lines.
ApInvoiceLinesAllTax	The classification of a charge imposed by a government through a fiscal or tax authority.
ApInvoiceLinesAllTaxAlreadyCalculatedFlag	Identifies whether tax has already been calculated for the invoice line.
ApInvoiceLinesAllTaxClassificationCode	The tax classification code used for tax calculation.
ApInvoiceLinesAllTaxCodeId	The Identifier for the existing tax code in Payables. This is used for upgrade and reporting purposes.
ApInvoiceLinesAllTaxJurisdictionCode	The code of the tax jurisdiction associated with the tax rate on the invoice line.
ApInvoiceLinesAllTaxRate	The rate specified for a tax rate name.
ApInvoiceLinesAllTaxRateCode	The tax rate code associated with the tax rate identifier.
ApInvoiceLinesAllTaxRateId	The unique identifier of a tax rate associated with the invoice line.
ApInvoiceLinesAllTaxRegimeCode	The code of the tax regime associated with the tax rate on the invoice line.
ApInvoiceLinesAllTaxStatusCode	The code of the tax status associated with the tax rate on the invoice line.
ApInvoiceLinesAllTotalNrecTaxAmount	The total nonrecoverable tax allocated to this taxable invoice line.
ApInvoiceLinesAllTotalNrecTaxAmtFunclCurr	The total nonrecoverable tax amount in the ledger currency.
ApInvoiceLinesAllTotalRecTaxAmount	The total recoverable tax allocated to this taxable invoice line.
ApInvoiceLinesAllTotalRecTaxAmtFunclCurr	The total recoverable tax amount in ledger currency.
ApInvoiceLinesAllTrxBusinessCategory	The transaction category assigned to the invoice line. Used to identify and classify business transactions for the purpose of tax calculation.
ApInvoiceLinesAllType1099	The income tax type associated to the invoice line, which is populated when 1099 type payments are made to a supplier.
ApInvoiceLinesAllUnitMeasLookupCode	The unit of measure for the quantity invoiced.
ApInvoiceLinesAllUnitPrice	The unit price of a good or service.
ApInvoiceLinesAllUserDefinedFiscClass	A classification for any tax requirement that you cannot define using the existing fiscal classification types.
ApInvoiceLinesAllUssglTransactionCode	The USSGL transaction code for creating US Standard General Ledger journal entries. This is used for Oracle Public Sector Payables.
ApInvoiceLinesAllWarrantyNumber	The warranty number of the item on the invoice line.
ApInvoiceLinesAllWebParameterId	The parameter identifier of the self-service web application associated with the invoice line.
ApInvoiceLinesAllWfapprovalStatus	The status indicating the state of the invoice line in the approval process. A list of accepted values is defined in the lookup AP_WFAPPROVAL_STATUS.