CData Python Connector for Oracle Fusion Cloud Financials

Build 26.0.9770

PayablesInterfaceInvoicesInterfaceInvoiceLines

Returns the invoice lines of payables interface invoices staged for import in Oracle Financials.

Columns

Name Type SupportedFinders Description
PayablesInterfaceInvoicesInvoiceId [KEY] Long The unique identifier of the interface invoice.
PayablesInterfaceInvoicesLoadRequestId [KEY] Long The unique identifier of the load request.
InvoiceId Long PrimaryKey The unique identifier of the interface invoice.
LoadRequestId Long PrimaryKey The unique identifier of the interface load job request that created the row.
LineNumber Int The unique number for the invoice line. The value must be provided while creating an invoice line. It can't be updated once the invoice line is created.
LineTypeLookupCode String The type of the invoice line. The value must be provided while creating an invoice line. The valid values are Item, Freight, and Miscellaneous. A list of accepted values is defined in the lookup type INVOICE LINE TYPE and can be reviewed using the Setup and Maintenance work area, and the Manage Payables Lookups task.
Amount Decimal The line amount in invoice currency. The value must be provided while creating an invoice line.
QuantityInvoiced Decimal The quantity that was invoiced.
UnitPrice Decimal The price charged per unit of a good or service.
UnitOfMeasLookupCode String The unit of measure for the quantity invoiced.
Description String A brief description of the invoice line. The value can either be provided while creating an invoice line or populated by default from the invoice header.
PONumber String The purchase order document number that's matched to the invoice.
POLineNumber Decimal The purchase order line number that's matched to the invoice line.
POShipmentNumber Decimal The purchase order schedule line number that's matched to the invoice line.
PODistributionNumber Int The purchase order distribution line number that's matched to the invoice distribution.
ItemDescription String A description of the item in the invoice line. The default value is populated from the inventory item.
PurchasingCategory String The item category referenced on the invoice line.
ReceiptNumber String The receipt number of the material associated with the invoice line.
ReceiptLineNumber String The line number of the receipt associated with the invoice line.
ConsumptionAdviceHeaderId Long The unique identifier of the consignment advice associated with the invoice line.
ConsumptionAdviceLineId Long The unique identifier of the line number of the consignment advice associated with the invoice line.
LcmEnabledFlag Bool Indicates if the invoice line is enabled for landed cost.
FinalMatchFlag Bool 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 can no longer match invoices to it.
DistributionSetName String The name of the distribution set. You can review the valid values using the Manage Distribution Sets task.
TransientAccount String The accounting flexfield used for automatic generation of a single distribution. The value can be provided while creating an invoice line. In case of Prepayment invoice or charge lines the value is populated by default from the Supplier Site Assignment or from Manage Common Options for Payables and Procurement options for the invoicing business unit.
AccountingDate Date The accounting date of an invoice line. It's defaulted to the invoice distributions. The value can either be provided while creating an invoice installment or populated by default from the invoice header.
BudgetDate Date The budgetary calendar period date applicable for funds check.
AccountSegment String Overrides account segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield.
BalancingSegment String Overrides balancing segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield.
CostCenterSegment String Overrides cost center segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield.
DistCodeConcatenated String Accounting flexfield value for a distribution line. Use the valid segment separator from the accounting key flexfield definition.
TaxClassificationCode String The tax classification code used for tax calculation. The value can either be provided while creating an invoice line or populated by default from the Tax Classification Code from the Transaction Tax tab in the Supplier Profile or Address or as per the Tax setups.
ShipToLocationCode String The user-entered ship to location code that helps to uniquely identify a ship to location.
TaxRegimeCode String The name of the set of tax rules that determines the treatment of one or more taxes administered by a tax authority.
Tax String The classification name of the charge imposed by a government through a fiscal or tax authority.
TaxJurisdictionCode String The code of the tax jurisdiction associated with the tax rate on the invoice line.
TaxStatusCode String The code that represent the tax status.
TaxRateCode String The tax rate code associated with the tax rate identifier.
TaxRate Decimal The rate specified for a tax rate.
AwtGroupName String The name of the withholding tax group. The value can either be provided while creating an invoice line or populated by default from the Withholding from Site Assignments in the Supplier Site or Address or Profile level.
Type1099 String The payments of type 1099 made to a supplier. A 1099 supplier may receive payments of more than one type. The value can either be provided while creating an invoice line or populated by default from the Federal Income Tax Type from the Income Tax tab from Supplier Profile.
IncomeTaxRegion String The reporting region of the invoice line for 1099 suppliers. The value can either be provided while creating an invoice line or populated by default to the State code from the address associated with supplier site.
ProrateAcrossFlag Bool Indicates whether 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.
LineGroupNumber Int The number of the Line group. Used to prorate charges across a group of lines. Must be a positive integer.
TrxBusinessCategory String The transaction category assigned to the invoice line. Used to identify and classify business transactions for the purpose of tax calculation. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
ProductFiscClassification String The user-entered product fiscal classification that helps to uniquely identify a product fiscal classification.
PrimaryIntendedUse String A tax driver used to determine and calculate the applicable taxes for the line. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
UserDefinedFiscClass String A classification for any tax requirement that you can't define using the existing fiscal classification types. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
ProductType String The product type of the product item. Valid values are Goods and Services. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
AssessableValue Decimal The deemed price at which a product is valued by a tax authority for tax calculation purposes.
ProductCategory String Identifies the taxable nature of a non-Inventory based item to determine tax or tax reporting purposes. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
ControlAmount Decimal The user-enterable value to ensure that the calculated tax will be the same as on the physical document.
StatAmount Decimal The amount associated with a distribution line for measuring statistical quantities.
AssetsTrackingFlag Bool Indicates whether the item should be transferred to Oracle 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 Assets.
AssetBookTypeCode String The asset book associated with the row. The value is populated by default to the distributions candidate for transfer to Oracle Fusion Assets.
AssetCategoryId Long The unique identifier of the asset category under which the asset line will be grouped. The value is populated by default to the invoice distributions for transferring to Oracle Assets.
SerialNumber String The serial number for an item.
Manufacturer String Name of the manufacturer of an asset or item. This is a free text field.
ModelNumber String The model number of the invoice line item.
PriceCorrectInvNumber String The number of the invoice that price correction invoice is updating.
PriceCorrectInvLineNumber Int The number of the invoice line that price correction invoice is updating.
PriceCorrectionFlag Bool Indicates if a line creates a price correction.
MatchOption String Indicates whether the invoice for the shipment should be matched to the purchase order or the receipt.
TaxableFlag Bool Indicates whether a line is taxable.
InclInTaxableLineFlag Bool Indicates whether the amount in the tax line is included in the taxable line.
RequesterFirstName String The first name of the person who made the request for the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers.
RequesterLastName String The last name of the person who made the request for the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers.
RequesterEmployeeNumber String The employee's unique identifier who made the request for the products or services.
POHeaderId Long The unique identifier of the purchase order document number that's matched to the invoice.
POLineId Long The unique identifier of the purchase order line number that's matched to the invoice line.
POLineLocationId Long The unique identifier of the purchase order schedule line number that's matched to the invoice line.
PODistributionId Long The unique identifier of the purchase order distribution line number that's matched to the invoice distribution.
ShipToLocationId Long The unique identifier of the ship to location code that helps to uniquely identify a ship to location.
ShipFromLocationCode String The code that identifies the ship-from location.
ShipFromLocationId Long The unique identifier of the ship-from location.
FinalDischargeLocationCode String The code that identifies the location of final discharge.
FinalDischargeLocationId Long The unique identifier of the final discharge location.
InventoryItemId Long The unique identifier of the inventory item.
PurchasingCategoryId Long The unique identifier for the item category.
AttributeCategory String The descriptive flexfield context name for the interface invoice line.
Attribute1 String A segment for the interface invoice lines descriptive flexfield.
Attribute2 String A segment for the interface invoice lines descriptive flexfield.
Attribute3 String A segment for the interface invoice lines descriptive flexfield.
Attribute4 String A segment for the interface invoice lines descriptive flexfield.
Attribute5 String A segment for the interface invoice lines descriptive flexfield.
Attribute6 String A segment for the interface invoice lines descriptive flexfield.
Attribute7 String A segment for the interface invoice lines descriptive flexfield.
Attribute8 String A segment for the interface invoice lines descriptive flexfield.
Attribute9 String A segment for the interface invoice lines descriptive flexfield.
Attribute10 String A segment for the interface invoice lines descriptive flexfield.
Attribute11 String A segment for the interface invoice lines descriptive flexfield.
Attribute12 String A segment for the interface invoice lines descriptive flexfield.
Attribute13 String A segment for the interface invoice lines descriptive flexfield.
Attribute14 String A segment for the interface invoice lines descriptive flexfield.
Attribute15 String A segment for the interface invoice lines descriptive flexfield.
GlobalAttributeCategory String The global descriptive flexfield context name for the interface invoice line.
GlobalAttribute1 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute2 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute3 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute4 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute5 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute6 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute7 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute8 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute9 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute10 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute11 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute12 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute13 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute14 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute15 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute16 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute17 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute18 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute19 String A segment for the interface invoice lines global descriptive flexfield.
GlobalAttribute20 String A segment for the interface invoice lines global descriptive flexfield.
DistCodeCombinationId Long The code combination identifier of the GL account associated with the transaction line.
DistributionSetId Long The unique identifier of the distribution set. If the identifier isn't available, use the DistributionSetName.
TaxRateId Long The internal identifier of the tax rate that's effective on the invoice date.
AwtGroupId Long The unique identifier of the withholding tax group.
RequesterId Long The unique identifier of the requester.
ApplicationId Long The unique identifier of the application on the interface invoice.
ProductTable String The name of the product source table used to generate the invoice.
ReferenceKey1 String The primary key information that uniquely identifies the record in another product's view.
ReferenceKey2 String The primary key information that uniquely identifies the record in another product's view.
ReferenceKey3 String The primary key information that uniquely identifies the record in another product's view.
ReferenceKey4 String The primary key information that uniquely identifies the record in another product's view.
ReferenceKey5 String The primary key information that uniquely identifies the record in another product's view.
TransientProjectDFF String Additional information for project standard cost collection flexfield.
PjcBillableFlag Bool Indicates whether the project related item is available for customer billing
PjcCapitalizableFlag Bool Indicates whether the project related item is eligible for capitalization.
PjcWorkTypeId Decimal The identifier of the project-related classification.
PjcContractId Decimal The identifier of the contract that's used while installing Oracle Project Billing or Oracle Project Billing or Oracle Grants Accounting.
PjcContractLineId Decimal The identifier of the contract line.
PjcFundingAllocationId Decimal Name of the project funding override.
FiscalChargeType String The subclassification of invoice line type. For example, Freight or Miscellaneous. Valid values are defined in lookup ZX_CHARGE_TYPE.
DefAcctgStartDate Date The multiperiod accounting start date on the invoice line.
DefAcctgEndDate Date The multiperiod accounting end date on the invoice line.
TransientAccrualAccount String The accrual account used in multiperiod accounting to accrue deferred expenses.
VendorItemNumber String The number that identifies the supplier's item.
RequesterEmailAddress String The email address of the employee for the requested items.
InvoiceLineId [KEY] Long The unique identifier of the interface invoice line.
CreationDate Datetime The date when the record was created.
LastUpdateDate Datetime The date when the record was last updated.
Queues String Queue name assigned to the invoice line rejection.
AwardId Long The unique identifier of the awards configured in Oracle Projects.
CostFactorId Long The identifier of the component that make up to the total cost of an item. For example, direct material costs and freight costs. If the identifier isn't available, use the COST_FACTOR_NAME column.
CreditCardTrxId Long The unique identifier of the credit card transaction associated to an item line of a Payment request from Expenses.
DefaultDistCcid Long The accounting flexfield used for automatic generation of a single distribution. The value can be provided while creating an invoice line. In case of Prepayment invoice or charge lines the value is populated by default from the Supplier Site Assignment or from Manage Common Options for Payables and Procurement options for the invoicing business unit.
ExpenditureItemDate Date The expenditure date for expenses related to project.
ExpenditureOrganizationId Long The name of the project organization.
ExpenditureType String The type of project expense.
ExternalDocumentLineReference String Internal document reference number from Accounts Receivables system.
OrgId Long The unique identifier of the invoice business unit name.
PjcContextCategory String Identifies descriptive flexfield application context for project-related standardized code collection.
PjcExpenditureItemDate Date Date on which project-related transaction occurred.
PjcOrganizationId Decimal The identifier of the organization to build transaction descriptive flexfield for project-related transaction distributions.
PjcProjectId Decimal Identifies descriptive flexfield application context for project-related standardized code collection.
PJC_RESERVED_ATTRIBUTE1 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE2 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE3 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE4 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE5 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE6 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE7 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE8 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE9 String Reserved for Projects standard cost collection flexfield.
PJC_RESERVED_ATTRIBUTE10 String Reserved for Projects standard cost collection flexfield.
PjcTaskId Decimal Identifies descriptive flexfield application context for project-related standardized code collection.
PJC_USER_DEF_ATTRIBUTE1 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE2 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE3 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE4 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE5 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE6 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE7 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE8 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE9 String User defined segment for Projects standard cost collection flexfield.
PJC_USER_DEF_ATTRIBUTE10 String User defined segment for Projects standard cost collection flexfield.
PaAdditionFlag Bool Indicates whether project related invoice distributions have been transferred to Oracle Projects.
PaCcArInvoiceId Long The unique identifier of the invoice for Projects intercompany invoice.
PaCcArInvoiceLineNumber Int The invoice line number of the Projects intercompany invoice.
PaCcProcessedCode String The processing status of an invoice line by Oracle Projects in the receiver business unit.
PaQuantity Decimal The project item quantity used to build accounting flexfield for project-related distribution line.
PackingSlip String The packing slip associated with the invoice line.
POReleaseId Long The unique identifier of the blanket purchase order release for purchase order matching.
ProjectId Long The unique identifier of the project referenced on the invoice line.
RcvTransactionId Long The receipt identifier used for receipt matching.
Reference1 String Reference information from a non-Oracle application. This is a free text field.
Reference2 String Reference information from a non-Oracle application. This is a free text field.
ReleaseNumber Int The release number of the blanket purchase order for matching.
SourceApplicationId Long The unique identifier of the source document application.
SourceEntityCode String The entity code of the source document.
SourceEventClassCode String The event class code of the source document.
SourceLineId Long The identifier of the lowest level for tax calculation.
SourceTrxId Long The identifier of the source document transaction.
SourceTrxLevelType String The type of the source document transaction level.
TaskId Long The unique identifier of the project task.
TaxCode String The unique code of the tax charge imposed by a government through a fiscal or tax authority.
TaxCodeId Long The unique identifier of the tax charge imposed by a government through a fiscal or tax authority.
WarrantyNumber String The warranty number of the item on the invoice line.
ConsumptionAdviceLineNumber Int The line number of the consignment advice associated with the invoice line.
ConsumptionAdviceNumber String The number of the consignment advice associated with the invoice line.
PjcExpenditureTypeName String A classification of cost that's assigned to each expenditure item.
PjcOrganizationName String The name of the organization to which the project is assigned.
PjcProjectName String The name of the project to which the invoice expense is charged.
PjcTaskNumber String A subdivision of project work. Task Number uniquely identifies the element within a project or structure.
PjcProjectNumber String The number of the project to which the invoice expense is charged.
PjcTaskName String The name of the task used to build the transaction descriptive flexfield for project-related transaction distributions.
PjcWorkType String Classification of project-related work performed.
PjcContractName String The name of the contract used in Oracle Contract Billing or Oracle Grants Accounting.
PjcContractNumber String The number of the Contract used in Oracle Contract Billing or Oracle Grants Accounting.
PjcFundingSourceName String Name of the source funding the project.
PjcFundingSourceNumber String Number of the source funding the project.
PjcExpenditureTypeId Decimal Identifies descriptive flexfield application context for project-related standardized code collection.
RcvShipmentHeaderId Long The receipt shipment number used for receipt matching.
DefAcctgAccrualCcid Long The accrual account that's initially debited for deferred expenses.
BusinessUnit String FindBySpreadsheetSearch The business unit name supplied as input to the spreadsheet search finder.
BusinessUnitId Long FindBySpreadsheetSearch The business unit identifier supplied as input to the spreadsheet search finder.
ChannelPartnerReference String FindByB2BInvoiceStatus, findByProcessedStatus The channel partner reference supplied as input to the invoice status finders.
CreationDateFrom Datetime FindByB2BInvoiceStatus, findByProcessedStatus, findBySpreadsheetSearch The start of the creation date range supplied as input to the invoice search finders.
CreationDateTo Datetime FindByB2BInvoiceStatus, findByProcessedStatus, findBySpreadsheetSearch The end of the creation date range supplied as input to the invoice search finders.
ExceptionCategory String FindBySpreadsheetSearch The exception category supplied as input to the spreadsheet search finder.
Finder String A named finder reference used to filter or locate specific payables interface invoice lines when querying.
HeadersOnly String FindBySpreadsheetSearch The headers-only indicator supplied as input to the spreadsheet search finder.
ImportError String FindBySpreadsheetSearch The import error value supplied as input to the spreadsheet search finder.
ImportRequestNumber Long FindByB2BInvoiceStatus, findByProcessedStatus The import request number supplied as input to the invoice status finders.
ImportSet String FindByB2BInvoiceStatus, findByProcessedStatus, findBySpreadsheetSearch The import set supplied as input to the invoice search finders.
InvoiceNumber String FindBySpreadsheetSearch The invoice number supplied as input to the spreadsheet search finder.
InvoiceSource String FindByProcessedStatus, findBySpreadsheetSearch The invoice source supplied as input to the invoice search finders.
LedgerId Long FindBySpreadsheetSearch The ledger identifier supplied as input to the spreadsheet search finder.
LineNumberFrom Long FindBySpreadsheetSearch The start of the line number range supplied as input to the spreadsheet search finder.
LineNumberTo Long FindBySpreadsheetSearch The end of the line number range supplied as input to the spreadsheet search finder.
NoOfInvoices Long FindBySpreadsheetSearch The number of invoices value supplied as input to the spreadsheet search finder.
Owner String FindBySpreadsheetSearch The owner value supplied as input to the spreadsheet search finder.
Queue String FindBySpreadsheetSearch The queue value supplied as input to the spreadsheet search finder.
ShowOnlyErrorLines String FindBySpreadsheetSearch The show-only-error-lines indicator supplied as input to the spreadsheet search finder.
Supplier String FindBySpreadsheetSearch The supplier name supplied as input to the spreadsheet search finder.
SupplierId Long FindBySpreadsheetSearch The supplier identifier supplied as input to the spreadsheet search finder.
SupplierNotified String FindByB2BInvoiceStatus The supplier-notified indicator supplied as input to the B2B invoice status finder.
SupplierSite String FindBySpreadsheetSearch The supplier site supplied as input to the spreadsheet search finder.
SupplierSiteId Long FindBySpreadsheetSearch The supplier site identifier supplied as input to the spreadsheet search finder.
TotalNoOfInvoiceLines Long FindBySpreadsheetSearch The total number of invoice lines value supplied as input to the spreadsheet search finder.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770