Get all interface invoice lines
get
/fscmRestApi/resources/11.13.18.05/payablesInterfaceInvoices/{payablesInterfaceInvoicesUniqID}/child/interfaceInvoiceLines
Request
Path Parameters
-
payablesInterfaceInvoicesUniqID(required): string
This is the hash key of the attributes which make up the composite key--- InvoiceId and LoadRequestId ---for the Payables Interface Invoices resource and used to uniquely identify an instance of Payables Interface Invoices. The client should not generate the hash key value. Instead, the client should query on the Payables Interface Invoices collection resource with a filter on the primary key values in order to navigate to a specific instance of Payables Interface Invoices.
For example: payablesInterfaceInvoices?q=InvoiceId=<value1>;LoadRequestId=<value2>
Query Parameters
-
dependency: string
This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
Format: <attr1>=<val1>,<attr2>=<value2> -
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables- PrimaryKey Find the interface invoice lines with the specified primary key.
Finder Variables- InvoiceLineId; integer; The unique identifier of the interface invoice line.
- findBySpreadsheetSearch Finds the interface invoice lines that match the specified criteria.
Finder Variables- bindErrorLinesOnly; string; Finds the interface invoice lines that have rejections.
- bindHeadersOnly; integer; The unique identifier of the interface invoice.
- bindLineNumFrom; integer; The starting line number of the range within which the interface invoice lines are searched.
- bindLineNumTo; integer; The ending line number of the range within which the interface invoice lines are searched.
- PrimaryKey Find the interface invoice lines with the specified primary key.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- AccountSegment; string; Overrides account segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield.
- AccountingDate; string; 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.
- Amount; number; The line amount in invoice currency. The value must be provided while creating an invoice line.
- ApplicationId; integer; The unique identifier of the application on the interface invoice.
- AssessableValue; number; The deemed price at which a product is valued by a tax authority for tax calculation purposes.
- 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; integer; 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.
- AssetsTrackingFlag; boolean; 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.
- Attribute1; 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.
- 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.
- AttributeCategory; string; The descriptive flexfield context name for the interface invoice line.
- AwardId; integer; The unique identifier of the awards configured in Oracle Projects.
- AwtGroupId; integer; The unique identifier of the withholding tax group.
- 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.
- BalancingSegment; string; Overrides balancing segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield.
- BudgetDate; string; The budgetary calendar period date applicable for funds check.
- ConsumptionAdviceHeaderId; integer; The unique identifier of the consignment advice associated with the invoice line.
- ConsumptionAdviceLineId; integer; The unique identifier of the line number of the consignment advice associated with the invoice line.
- ConsumptionAdviceLineNumber; integer; 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.
- ControlAmount; number; The user-enterable value to ensure that the calculated tax will be the same as on the physical document.
- 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.
- CostFactorId; integer; 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.
- CreationDate; string; The date when the record was created.
- CreditCardTrxId; integer; The unique identifier of the credit card transaction associated to an item line of a Payment request from Expenses.
- DefAcctgAccrualCcid; integer; The accrual account that's initially debited for deferred expenses.
- DefAcctgEndDate; string; The multiperiod accounting end date on the invoice line.
- DefAcctgStartDate; string; The multiperiod accounting start date on the invoice line.
- DefaultDistCcid; integer; 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.
- 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.
- DistCodeCombinationId; integer; The code combination identifier of the GL account associated with the transaction line.
- DistCodeConcatenated; string; Accounting flexfield value for a distribution line. Use the valid segment separator from the accounting key flexfield definition.
- DistributionSetId; integer; The unique identifier of the distribution set. If the identifier isn't available, use the DistributionSetName.
- DistributionSetName; string; The name of the distribution set. You can review the valid values using the Manage Distribution Sets task.
- ExpenditureItemDate; string; The expenditure date for expenses related to project.
- ExpenditureOrganizationId; integer; The name of the project organization.
- ExpenditureType; string; The type of project expense.
- ExternalDocumentLineReference; string; Internal document reference number from Accounts Receivables system.
- FinalDischargeLocationCode; string; The code that identifies the location of final discharge.
- FinalDischargeLocationId; integer; The unique identifier of the final discharge location.
- FinalMatchFlag; boolean; 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.
- FiscalChargeType; string; The subclassification of invoice line type. For example, Freight or Miscellaneous. Valid values are defined in lookup ZX_CHARGE_TYPE.
- GlobalAttribute1; 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.
- GlobalAttribute2; string; A segment for the interface invoice lines global descriptive flexfield.
- GlobalAttribute20; 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.
- GlobalAttributeCategory; string; The global descriptive flexfield context name for the interface invoice line.
- InclInTaxableLineFlag; boolean; Indicates whether the amount in the tax line is included in the taxable line.
- 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.
- InventoryItemId; integer; The unique identifier of the inventory item.
- InvoiceId; integer; The unique identifier of the interface invoice.
- InvoiceLineId; integer; The unique identifier of the interface invoice line.
- ItemDescription; string; A description of the item in the invoice line. The default value is populated from the inventory item.
- LastUpdateDate; string; The date when the record was last updated.
- LcmEnabledFlag; boolean; Indicates if the invoice line is enabled for landed cost.
- LineGroupNumber; integer; The number of the Line group. Used to prorate charges across a group of lines. Must be a positive integer.
- LineNumber; integer; 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.
- LoadRequestId; integer; The unique identifier of the interface load job request that created the row.
- Manufacturer; string; Name of the manufacturer of an asset or item. This is a free text field.
- MatchOption; string; Indicates whether the invoice for the shipment should be matched to the purchase order or the receipt.
- ModelNumber; string; The model number of the invoice line item.
- OrgId; integer; The unique identifier of the invoice business unit name.
- PJC_RESERVED_ATTRIBUTE1; string; Reserved for Projects standard cost collection flexfield.
- PJC_RESERVED_ATTRIBUTE10; 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_USER_DEF_ATTRIBUTE1; string; User defined segment for Projects standard cost collection flexfield.
- PJC_USER_DEF_ATTRIBUTE10; 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.
- PODistributionId; integer; The unique identifier of the purchase order distribution line number that's matched to the invoice distribution.
- PODistributionNumber; integer; The purchase order distribution line number that's matched to the invoice distribution.
- POHeaderId; integer; The unique identifier of the purchase order document number that's matched to the invoice.
- POLineId; integer; The unique identifier of the purchase order line number that's matched to the invoice line.
- POLineLocationId; integer; The unique identifier of the purchase order schedule line number that's matched to the invoice line.
- POLineNumber; number; The purchase order line number that's matched to the invoice line.
- PONumber; string; The purchase order document number that's matched to the invoice.
- POReleaseId; integer; The unique identifier of the blanket purchase order release for purchase order matching.
- POShipmentNumber; number; The purchase order schedule line number that's matched to the invoice line.
- PaAdditionFlag; boolean; Indicates whether project related invoice distributions have been transferred to Oracle Projects.
- PaCcArInvoiceId; integer; The unique identifier of the invoice for Projects intercompany invoice.
- PaCcArInvoiceLineNumber; integer; 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; number; The project item quantity used to build accounting flexfield for project-related distribution line.
- PackingSlip; string; The packing slip associated with the invoice line.
- PjcBillableFlag; boolean; Indicates whether the project related item is available for customer billing
- PjcCapitalizableFlag; boolean; Indicates whether the project related item is eligible for capitalization.
- PjcContextCategory; string; Identifies descriptive flexfield application context for project-related standardized code collection.
- PjcContractId; number; The identifier of the contract that's used while installing Oracle Project Billing or Oracle Project Billing or Oracle Grants Accounting.
- PjcContractLineId; number; The identifier of the contract line.
- 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.
- PjcExpenditureItemDate; string; Date on which project-related transaction occurred.
- PjcExpenditureTypeId; number; Identifies descriptive flexfield application context for project-related standardized code collection.
- PjcExpenditureTypeName; string; A classification of cost that's assigned to each expenditure item.
- PjcFundingAllocationId; number; Name of the project funding override.
- PjcFundingSourceName; string; Name of the source funding the project.
- PjcFundingSourceNumber; string; Number of the source funding the project.
- PjcOrganizationId; number; The identifier of the organization to build transaction descriptive flexfield for project-related transaction distributions.
- PjcOrganizationName; string; The name of the organization to which the project is assigned.
- PjcProjectId; number; Identifies descriptive flexfield application context for project-related standardized code collection.
- PjcProjectName; string; The name of the project to which the invoice expense is charged.
- PjcProjectNumber; string; The number of the project to which the invoice expense is charged.
- PjcTaskId; number; Identifies descriptive flexfield application context for project-related standardized code collection.
- PjcTaskName; string; The name of the task used to build the transaction descriptive flexfield for project-related transaction distributions.
- PjcTaskNumber; string; A subdivision of project work. Task Number uniquely identifies the element within a project or structure.
- PjcWorkType; string; Classification of project-related work performed.
- PjcWorkTypeId; number; The identifier of the project-related classification.
- PriceCorrectInvLineNumber; integer; The number of the invoice line that price correction invoice is updating.
- PriceCorrectInvNumber; string; The number of the invoice that price correction invoice is updating.
- PriceCorrectionFlag; boolean; Indicates if a line creates a price correction.
- 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.
- 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.
- ProductFiscClassification; string; The user-entered product fiscal classification that helps to uniquely identify a product fiscal classification.
- ProductTable; string; The name of the product source table used to generate the invoice.
- 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.
- ProjectId; integer; The unique identifier of the project referenced on the invoice line.
- ProrateAcrossFlag; boolean; 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.
- PurchasingCategory; string; The item category referenced on the invoice line.
- PurchasingCategoryId; integer; The unique identifier for the item category.
- QuantityInvoiced; number; The quantity that was invoiced.
- RcvTransactionId; integer; The receipt identifier used for receipt matching.
- ReceiptLineNumber; string; The line number of the receipt associated with the invoice line.
- ReceiptNumber; string; The receipt number of the material associated with the invoice line.
- 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.
- 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.
- ReleaseNumber; integer; The release number of the blanket purchase order for matching.
- RequesterEmailAddress; string; The email address of the employee for the requested items.
- RequesterEmployeeNumber; string; The employee's unique identifier who made the request for the products or services.
- 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.
- RequesterId; integer; The unique identifier of the requester.
- 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.
- SerialNumber; string; The serial number for an item.
- ShipFromLocationCode; string; The code that identifies the ship-from location.
- ShipFromLocationId; integer; The unique identifier of the ship-from location.
- ShipToLocationCode; string; The user-entered ship to location code that helps to uniquely identify a ship to location.
- ShipToLocationId; integer; The unique identifier of the ship to location code that helps to uniquely identify a ship to location.
- SourceApplicationId; integer; 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; integer; The identifier of the lowest level for tax calculation.
- SourceTrxId; integer; The identifier of the source document transaction.
- SourceTrxLevelType; string; The type of the source document transaction level.
- StatAmount; number; The amount associated with a distribution line for measuring statistical quantities.
- TaskId; integer; The unique identifier of the project task.
- Tax; string; The classification name of the charge imposed by a government through a fiscal or tax authority.
- 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.
- TaxCode; string; The unique code of the tax charge imposed by a government through a fiscal or tax authority.
- TaxCodeId; integer; The unique identifier of the tax 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.
- TaxRate; number; The rate specified for a tax rate.
- TaxRateCode; string; The tax rate code associated with the tax rate identifier.
- TaxRateId; integer; The internal identifier of the tax rate that's effective on the invoice date.
- TaxRegimeCode; string; The name of the set of tax rules that determines the treatment of one or more taxes administered by a tax authority.
- TaxStatusCode; string; The code that represent the tax status.
- TaxableFlag; boolean; Indicates whether a line is taxable.
- 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.
- TransientAccrualAccount; string; The accrual account used in multiperiod accounting to accrue deferred expenses.
- TransientProjectDFF; string; Additional information for project standard cost collection flexfield.
- 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.
- 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.
- UnitOfMeasLookupCode; string; The unit of measure for the quantity invoiced.
- UnitPrice; number; The price charged per unit of a good or service.
- 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.
- VendorItemNumber; string; The number that identifies the supplier's item.
- WarrantyNumber; string; The warranty number of the item on the invoice line.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : payablesInterfaceInvoices-interfaceInvoiceLines
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : payablesInterfaceInvoices-interfaceInvoiceLines-item-response
Type:
Show Source
object-
AccountingDate: string
(date)
Title:
Accounting DateThe 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. -
AccountSegment: string
Title:
Overlay Account SegmentMaximum Length:25Overrides account segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield. -
Amount: number
Title:
AmountThe line amount in invoice currency. The value must be provided while creating an invoice line. -
ApplicationId: integer
(int64)
Title:
Application IDThe unique identifier of the application on the interface invoice. -
AssessableValue: number
Title:
Assessable ValueThe deemed price at which a product is valued by a tax authority for tax calculation purposes. -
AssetBookTypeCode: string
Title:
BookMaximum Length:30The asset book associated with the row. The value is populated by default to the distributions candidate for transfer to Oracle Fusion Assets. -
AssetCategoryId: integer
(int64)
Title:
Asset CategoryThe 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. -
AssetsTrackingFlag: boolean
Title:
Track as AssetMaximum Length:1Indicates 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. -
Attribute1: string
Title:
Attribute 1Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute10: string
Title:
Attribute 10Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute11: string
Title:
Attribute 11Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute12: string
Title:
Attribute 12Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute13: string
Title:
Attribute 13Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute14: string
Title:
Attribute 14Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute15: string
Title:
Attribute 15Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute2: string
Title:
Attribute 2Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute3: string
Title:
Attribute 3Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute4: string
Title:
Attribute 4Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute5: string
Title:
Attribute 5Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute6: string
Title:
Attribute 6Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute7: string
Title:
Attribute 7Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute8: string
Title:
Attribute 8Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute9: string
Title:
Attribute 9Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
AttributeCategory: string
Title:
Context ValueMaximum Length:150The descriptive flexfield context name for the interface invoice line. -
AwardId: integer
(int64)
The unique identifier of the awards configured in Oracle Projects.
-
AwtGroupId: integer
(int64)
Title:
Withholding Tax Group IDThe unique identifier of the withholding tax group. -
AwtGroupName: string
Title:
Withholding Tax GroupMaximum Length:25The 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. -
BalancingSegment: string
Title:
Overlay Primary Balancing SegmentMaximum Length:25Overrides balancing segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield. -
BudgetDate: string
(date)
Title:
Budget DateThe budgetary calendar period date applicable for funds check. -
ConsumptionAdviceHeaderId: integer
(int64)
Title:
Consumption AdviceThe unique identifier of the consignment advice associated with the invoice line. -
ConsumptionAdviceLineId: integer
(int64)
Title:
Consumption Advice Line NumberThe unique identifier of the line number of the consignment advice associated with the invoice line. -
ConsumptionAdviceLineNumber: integer
Title:
Consumption Advice Line NumberThe line number of the consignment advice associated with the invoice line. -
ConsumptionAdviceNumber: string
Title:
Consumption AdviceMaximum Length:20The number of the consignment advice associated with the invoice line. -
ControlAmount: number
Title:
Tax Control AmountThe user-enterable value to ensure that the calculated tax will be the same as on the physical document. -
CostCenterSegment: string
Title:
Overlay Cost Center SegmentMaximum Length:25Overrides cost center segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield. -
CostFactorId: integer
(int64)
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.
-
CreationDate: string
(date-time)
Read Only:
trueThe date when the record was created. -
CreditCardTrxId: integer
(int64)
The unique identifier of the credit card transaction associated to an item line of a Payment request from Expenses.
-
DefAcctgAccrualCcid: integer
Title:
Multiperiod Accounting Accrual AccountThe accrual account that's initially debited for deferred expenses. -
DefAcctgEndDate: string
(date)
Title:
Multiperiod Accounting End DateThe multiperiod accounting end date on the invoice line. -
DefAcctgStartDate: string
(date)
Title:
Multiperiod Accounting Start DateThe multiperiod accounting start date on the invoice line. -
DefaultDistCcid: integer
(int64)
Title:
Default Distribution Combination IDThe 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. -
Description: string
Title:
DescriptionMaximum Length:240A 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. -
DistCodeCombinationId: integer
(int64)
Title:
Distribution Combination IDThe code combination identifier of the GL account associated with the transaction line. -
DistCodeConcatenated: string
Title:
Overlay Distribution CombinationMaximum Length:250Accounting flexfield value for a distribution line. Use the valid segment separator from the accounting key flexfield definition. -
DistributionSetId: integer
(int64)
Title:
Distribution Set IDThe unique identifier of the distribution set. If the identifier isn't available, use the DistributionSetName. -
DistributionSetName: string
Title:
Distribution SetMaximum Length:50The name of the distribution set. You can review the valid values using the Manage Distribution Sets task. -
ExpenditureItemDate: string
(date)
The expenditure date for expenses related to project.
-
ExpenditureOrganizationId: integer
(int64)
The name of the project organization.
-
ExpenditureType: string
Maximum Length:
30The type of project expense. -
ExternalDocumentLineReference: string
Maximum Length:
240Internal document reference number from Accounts Receivables system. -
FinalDischargeLocationCode: string
Title:
Location of Final DischargeMaximum Length:60The code that identifies the location of final discharge. -
FinalDischargeLocationId: integer
(int64)
Title:
Location of Final Discharge IDThe unique identifier of the final discharge location. -
FinalMatchFlag: boolean
Title:
Final MatchMaximum Length:1Indicates 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. -
FiscalChargeType: string
Title:
Fiscal Charge TypeMaximum Length:30The subclassification of invoice line type. For example, Freight or Miscellaneous. Valid values are defined in lookup ZX_CHARGE_TYPE. -
GlobalAttribute1: string
Title:
Global Attribute 1Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute10: string
Title:
Global Attribute 10Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute11: string
Title:
Global Attribute 11Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute12: string
Title:
Global Attribute 12Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute13: string
Title:
Global Attribute 13Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute14: string
Title:
Global Attribute 14Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute15: string
Title:
Global Attribute 15Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute16: string
Title:
Global Attribute 16Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute17: string
Title:
Global Attribute 17Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute18: string
Title:
Global Attribute 18Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute19: string
Title:
Global Attribute 19Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute2: string
Title:
Global Attribute 2Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute20: string
Title:
Global Attribute 20Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute3: string
Title:
Global Attribute 3Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute4: string
Title:
Global Attribute 4Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute5: string
Title:
Global Attribute 5Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute6: string
Title:
Global Attribute 6Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute7: string
Title:
Global Attribute 7Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute8: string
Title:
Global Attribute 8Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute9: string
Title:
Global Attribute 9Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttributeCategory: string
Title:
Global Attribute CategoryMaximum Length:150The global descriptive flexfield context name for the interface invoice line. -
InclInTaxableLineFlag: boolean
Title:
Included in Taxable Line IndicatorMaximum Length:1Indicates whether the amount in the tax line is included in the taxable line. -
IncomeTaxRegion: string
Title:
Income Tax RegionMaximum Length:10The 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. -
interfaceInvoiceLineRejections: array
Interface Invoice Line Rejections
Title:
Interface Invoice Line RejectionsThe payables interface invoice line rejections resource is used to view the interface invoice line attributes rejections. Note that the service endpoints in this resource are specifically designed to only work with the visual builder add-in for Excel. -
InventoryItemId: integer
Title:
Item IDThe unique identifier of the inventory item. -
InvoiceId: integer
(int64)
Title:
Invoice IDRead Only:trueThe unique identifier of the interface invoice. -
InvoiceLineId: integer
(int64)
Title:
Invoice Line IDRead Only:trueThe unique identifier of the interface invoice line. -
ItemDescription: string
Title:
Item DescriptionMaximum Length:240A description of the item in the invoice line. The default value is populated from the inventory item. -
LastUpdateDate: string
(date-time)
Read Only:
trueThe date when the record was last updated. -
LcmEnabledFlag: boolean
Title:
Landed Cost EnabledMaximum Length:1Indicates if the invoice line is enabled for landed cost. -
LineGroupNumber: integer
Title:
Line Group NumberThe number of the Line group. Used to prorate charges across a group of lines. Must be a positive integer. -
LineNumber: integer
(int64)
Title:
LineThe 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
Title:
Line TypeMaximum Length:25The 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. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoadRequestId: integer
(int64)
Title:
Load Process IDRead Only:trueThe unique identifier of the interface load job request that created the row. -
Manufacturer: string
Title:
ManufacturerMaximum Length:30Name of the manufacturer of an asset or item. This is a free text field. -
MatchOption: string
Title:
Match OptionMaximum Length:25Indicates whether the invoice for the shipment should be matched to the purchase order or the receipt. -
ModelNumber: string
Title:
ModelMaximum Length:40The model number of the invoice line item. -
OrgId: integer
(int64)
Title:
Business UnitThe unique identifier of the invoice business unit name. -
PaAdditionFlag: boolean
Maximum Length:
1Default Value:falseIndicates whether project related invoice distributions have been transferred to Oracle Projects. -
PaCcArInvoiceId: integer
(int64)
The unique identifier of the invoice for Projects intercompany invoice.
-
PaCcArInvoiceLineNumber: integer
(int64)
The invoice line number of the Projects intercompany invoice.
-
PaCcProcessedCode: string
Maximum Length:
1The processing status of an invoice line by Oracle Projects in the receiver business unit. -
PackingSlip: string
Maximum Length:
25The packing slip associated with the invoice line. -
PaQuantity: number
The project item quantity used to build accounting flexfield for project-related distribution line.
-
PJC_RESERVED_ATTRIBUTE1: string
Title:
Project Reserved Attribute 1Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE10: string
Title:
Project Reserved Attribute 10Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE2: string
Title:
Project Reserved Attribute 2Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE3: string
Title:
Project Reserved Attribute 3Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE4: string
Title:
Project Reserved Attribute 4Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE5: string
Title:
Project Reserved Attribute 5Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE6: string
Title:
Project Reserved Attribute 6Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE7: string
Title:
Project Reserved Attribute 7Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE8: string
Title:
Project Reserved Attribute 8Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE9: string
Title:
Project Reserved Attribute 9Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE1: string
Title:
Project User-Defined Attribute 1Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE10: string
Title:
Project User-Defined Attribute 10Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE2: string
Title:
Project User-Defined Attribute 2Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE3: string
Title:
Project User-Defined Attribute 3Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE4: string
Title:
Project User-Defined Attribute 4Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE5: string
Title:
Project User-Defined Attribute 5Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE6: string
Title:
Project User-Defined Attribute 6Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE7: string
Title:
Project User-Defined Attribute 7Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE8: string
Title:
Project User-Defined Attribute 8Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE9: string
Title:
Project User-Defined Attribute 9Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PjcBillableFlag: boolean
Title:
BillableMaximum Length:1Indicates whether the project related item is available for customer billing -
PjcCapitalizableFlag: boolean
Title:
CapitalizableMaximum Length:1Indicates whether the project related item is eligible for capitalization. -
PjcContextCategory: string
Title:
Project Context CategoryMaximum Length:40Default Value:AP_Invoice_LineIdentifies descriptive flexfield application context for project-related standardized code collection. -
PjcContractId: number
Title:
Project Contract IDThe identifier of the contract that's used while installing Oracle Project Billing or Oracle Project Billing or Oracle Grants Accounting. -
PjcContractLineId: number
Title:
Project Contract Line IDThe identifier of the contract line. -
PjcContractName: string
Title:
Contract NameMaximum Length:300The name of the contract used in Oracle Contract Billing or Oracle Grants Accounting. -
PjcContractNumber: string
Title:
Contract NumberMaximum Length:120The number of the Contract used in Oracle Contract Billing or Oracle Grants Accounting. -
PjcExpenditureItemDate: string
(date)
Title:
Project Expenditure Item DateDate on which project-related transaction occurred. -
PjcExpenditureTypeId: number
Title:
Project Expenditure Type IDIdentifies descriptive flexfield application context for project-related standardized code collection. -
PjcExpenditureTypeName: string
Title:
Expenditure TypeMaximum Length:240A classification of cost that's assigned to each expenditure item. -
PjcFundingAllocationId: number
Title:
Project Funding Allocation IDName of the project funding override. -
PjcFundingSourceName: string
Title:
Funding Source NameMaximum Length:360Name of the source funding the project. -
PjcFundingSourceNumber: string
Title:
Funding Source NumberMaximum Length:50Number of the source funding the project. -
PjcOrganizationId: number
Title:
Expenditure Organization IDThe identifier of the organization to build transaction descriptive flexfield for project-related transaction distributions. -
PjcOrganizationName: string
Title:
Expenditure OrganizationMaximum Length:240The name of the organization to which the project is assigned. -
PjcProjectId: number
Title:
Project IDIdentifies descriptive flexfield application context for project-related standardized code collection. -
PjcProjectName: string
Title:
Project NameMaximum Length:240The name of the project to which the invoice expense is charged. -
PjcProjectNumber: string
Title:
Project NumberMaximum Length:25The number of the project to which the invoice expense is charged. -
PjcTaskId: number
Title:
Task IDIdentifies descriptive flexfield application context for project-related standardized code collection. -
PjcTaskName: string
Title:
Task NameMaximum Length:255The name of the task used to build the transaction descriptive flexfield for project-related transaction distributions. -
PjcTaskNumber: string
Title:
Task NumberMaximum Length:100A subdivision of project work. Task Number uniquely identifies the element within a project or structure. -
PjcWorkType: string
Title:
Work TypeMaximum Length:240Classification of project-related work performed. -
PjcWorkTypeId: number
Title:
Project Work Type IDThe identifier of the project-related classification. -
PODistributionId: integer
Title:
Purchase Order Distribution IDThe unique identifier of the purchase order distribution line number that's matched to the invoice distribution. -
PODistributionNumber: integer
Title:
Purchase Order Distribution NumberThe purchase order distribution line number that's matched to the invoice distribution. -
POHeaderId: integer
Title:
Purchase Order Header IDThe unique identifier of the purchase order document number that's matched to the invoice. -
POLineId: integer
Title:
Purchase Order Line IDThe unique identifier of the purchase order line number that's matched to the invoice line. -
POLineLocationId: integer
Title:
Purchase Order Line Location IDThe unique identifier of the purchase order schedule line number that's matched to the invoice line. -
POLineNumber: number
Title:
Purchase Order Line NumberThe purchase order line number that's matched to the invoice line. -
PONumber: string
Title:
Purchase OrderMaximum Length:30The purchase order document number that's matched to the invoice. -
POReleaseId: integer
The unique identifier of the blanket purchase order release for purchase order matching.
-
POShipmentNumber: number
Title:
Purchase Order ScheduleThe purchase order schedule line number that's matched to the invoice line. -
PriceCorrectInvLineNumber: integer
Title:
Price Correction Invoice LineThe number of the invoice line that price correction invoice is updating. -
PriceCorrectInvNumber: string
Title:
Price Correction InvoiceMaximum Length:50The number of the invoice that price correction invoice is updating. -
PriceCorrectionFlag: boolean
Title:
Price Correction IndicatorMaximum Length:1Indicates if a line creates a price correction. -
PrimaryIntendedUse: string
Title:
Intended UseMaximum Length:30A 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. -
ProductCategory: string
Title:
Product CategoryMaximum Length:240Identifies 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. -
ProductFiscClassification: string
Title:
Product Fiscal ClassificationMaximum Length:240The user-entered product fiscal classification that helps to uniquely identify a product fiscal classification. -
ProductTable: string
Title:
Product TableMaximum Length:30The name of the product source table used to generate the invoice. -
ProductType: string
Title:
Product TypeMaximum Length:240The 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. -
ProjectId: integer
(int64)
The unique identifier of the project referenced on the invoice line.
-
ProrateAcrossFlag: boolean
Title:
Prorate Across All Item LinesMaximum Length:1Indicates 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. -
PurchasingCategory: string
Title:
Purchasing CategoryMaximum Length:2000The item category referenced on the invoice line. -
PurchasingCategoryId: integer
(int64)
Title:
Purchasing Category IDThe unique identifier for the item category. -
QuantityInvoiced: number
Title:
Invoiced QuantityThe quantity that was invoiced. -
Queues: string
Title:
Queue NameMaximum Length:255Queue name assigned to the invoice line rejection. -
RcvShipmentHeaderId: integer
The receipt shipment number used for receipt matching.
-
RcvTransactionId: integer
The receipt identifier used for receipt matching.
-
ReceiptLineNumber: string
Title:
Receipt LineMaximum Length:25The line number of the receipt associated with the invoice line. -
ReceiptNumber: string
Title:
ReceiptMaximum Length:30The receipt number of the material associated with the invoice line. -
Reference1: string
Maximum Length:
30Reference information from a non-Oracle application. This is a free text field. -
Reference2: string
Maximum Length:
30Reference information from a non-Oracle application. This is a free text field. -
ReferenceKey1: string
Title:
Reference Key 1Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey2: string
Title:
Reference Key 2Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey3: string
Title:
Reference Key 3Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey4: string
Title:
Reference Key 4Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey5: string
Title:
Reference Key 5Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReleaseNumber: integer
The release number of the blanket purchase order for matching.
-
RequesterEmailAddress: string
Title:
Requester Email AddressMaximum Length:240The email address of the employee for the requested items. -
RequesterEmployeeNumber: string
Title:
Requester Employee NumberMaximum Length:30The employee's unique identifier who made the request for the products or services. -
RequesterFirstName: string
Title:
Requester First NameMaximum Length:150The 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. -
RequesterId: integer
(int64)
Title:
Requester IDThe unique identifier of the requester. -
RequesterLastName: string
Title:
Requester Last NameMaximum Length:150The 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. -
SerialNumber: string
Title:
Serial NumberMaximum Length:35The serial number for an item. -
ShipFromLocationCode: string
Title:
Ship-from LocationMaximum Length:60The code that identifies the ship-from location. -
ShipFromLocationId: integer
(int64)
Title:
Ship-from Location IDThe unique identifier of the ship-from location. -
ShipToLocationCode: string
Title:
Ship-to LocationMaximum Length:60The user-entered ship to location code that helps to uniquely identify a ship to location. -
ShipToLocationId: integer
(int64)
Title:
Ship-to Location IDThe unique identifier of the ship to location code that helps to uniquely identify a ship to location. -
SourceApplicationId: integer
The unique identifier of the source document application.
-
SourceEntityCode: string
Maximum Length:
30The entity code of the source document. -
SourceEventClassCode: string
Maximum Length:
30The event class code of the source document. -
SourceLineId: integer
The identifier of the lowest level for tax calculation.
-
SourceTrxId: integer
The identifier of the source document transaction.
-
SourceTrxLevelType: string
Maximum Length:
30The type of the source document transaction level. -
StatAmount: number
Title:
Statistical QuantityThe amount associated with a distribution line for measuring statistical quantities. -
TaskId: integer
(int64)
The unique identifier of the project task.
-
Tax: string
Title:
Tax NameMaximum Length:30The classification name of the charge imposed by a government through a fiscal or tax authority. -
TaxableFlag: boolean
Title:
Taxable IndicatorMaximum Length:1Indicates whether a line is taxable. -
TaxClassificationCode: string
Title:
Tax ClassificationMaximum Length:30The 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. -
TaxCode: string
Maximum Length:
15The unique code of the tax charge imposed by a government through a fiscal or tax authority. -
TaxCodeId: integer
(int64)
The unique identifier of the tax charge imposed by a government through a fiscal or tax authority.
-
TaxJurisdictionCode: string
Title:
Tax Jurisdiction CodeMaximum Length:30The code of the tax jurisdiction associated with the tax rate on the invoice line. -
TaxRate: number
Title:
Tax RateThe rate specified for a tax rate. -
TaxRateCode: string
Title:
Tax Rate CodeMaximum Length:150The tax rate code associated with the tax rate identifier. -
TaxRateId: integer
(int64)
Title:
Tax Rate IDThe internal identifier of the tax rate that's effective on the invoice date. -
TaxRegimeCode: string
Title:
Tax Regime CodeMaximum Length:30The name of the set of tax rules that determines the treatment of one or more taxes administered by a tax authority. -
TaxStatusCode: string
Title:
Tax Status CodeMaximum Length:30The code that represent the tax status. -
TransientAccount: string
Title:
Distribution CombinationThe 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. -
TransientAccrualAccount: string
Title:
Multiperiod Accounting Accrual AccountThe accrual account used in multiperiod accounting to accrue deferred expenses. -
TransientProjectDFF: string
Title:
Project InformationAdditional information for project standard cost collection flexfield. -
TrxBusinessCategory: string
Title:
Transaction Business CategoryMaximum Length:240The 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. -
Type1099: string
Title:
Income Tax TypeMaximum Length:10The 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. -
UnitOfMeasLookupCode: string
Title:
UOMMaximum Length:25The unit of measure for the quantity invoiced. -
UnitPrice: number
Title:
Unit PriceThe price charged per unit of a good or service. -
UserDefinedFiscClass: string
Title:
User-Defined Fiscal ClassificationMaximum Length:240A 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. -
VendorItemNumber: string
Title:
Supplier Item NumberMaximum Length:300The number that identifies the supplier's item. -
WarrantyNumber: string
Maximum Length:
15The warranty number of the item on the invoice line.
Nested Schema : Interface Invoice Line Rejections
Type:
arrayTitle:
Interface Invoice Line RejectionsThe payables interface invoice line rejections resource is used to view the interface invoice line attributes rejections. Note that the service endpoints in this resource are specifically designed to only work with the visual builder add-in for Excel.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : payablesInterfaceInvoices-interfaceInvoiceLines-interfaceInvoiceLineRejections-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RejectionDescription: string
Read Only:
trueMaximum Length:255The reason for rejection of the interface invoice line.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Links
- submitImportInvoices
-
Parameters:
- payablesInterfaceInvoicesUniqID:
$request.path.payablesInterfaceInvoicesUniqID
You can create invoices from the data in the payables open interface tables using import payables invoices. - payablesInterfaceInvoicesUniqID: