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:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The 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:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : payablesInterfaceInvoices-interfaceInvoiceLines-item-response
Type:
Show Source
object
-
AccountingDate: string
(date)
Title:
Accounting 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. -
AccountSegment: string
Title:
Overlay Account Segment
Maximum Length:25
Overrides account segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield. -
Amount: number
Title:
Amount
The line amount in invoice currency. The value must be provided while creating an invoice line. -
ApplicationId: integer
(int64)
Title:
Application ID
The unique identifier of the application on the interface invoice. -
AssessableValue: number
Title:
Assessable Value
The deemed price at which a product is valued by a tax authority for tax calculation purposes. -
AssetBookTypeCode: string
Title:
Book
Maximum Length:30
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
(int64)
Title:
Asset Category
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
Title:
Track as Asset
Maximum Length:1
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
Title:
Attribute 1
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute10: string
Title:
Attribute 10
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute11: string
Title:
Attribute 11
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute12: string
Title:
Attribute 12
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute13: string
Title:
Attribute 13
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute14: string
Title:
Attribute 14
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute15: string
Title:
Attribute 15
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute2: string
Title:
Attribute 2
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute3: string
Title:
Attribute 3
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute4: string
Title:
Attribute 4
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute5: string
Title:
Attribute 5
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute6: string
Title:
Attribute 6
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute7: string
Title:
Attribute 7
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute8: string
Title:
Attribute 8
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
Attribute9: string
Title:
Attribute 9
Maximum Length:150
A segment for the interface invoice lines descriptive flexfield. -
AttributeCategory: string
Title:
Context Value
Maximum Length:150
The 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 ID
The unique identifier of the withholding tax group. -
AwtGroupName: string
Title:
Withholding Tax Group
Maximum Length:25
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
Title:
Overlay Primary Balancing Segment
Maximum Length:25
Overrides 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 Date
The budgetary calendar period date applicable for funds check. -
ConsumptionAdviceHeaderId: integer
(int64)
Title:
Consumption Advice
The unique identifier of the consignment advice associated with the invoice line. -
ConsumptionAdviceLineId: integer
(int64)
Title:
Consumption Advice Line Number
The unique identifier of the line number of the consignment advice associated with the invoice line. -
ConsumptionAdviceLineNumber: integer
Title:
Consumption Advice Line Number
The line number of the consignment advice associated with the invoice line. -
ConsumptionAdviceNumber: string
Title:
Consumption Advice
Maximum Length:20
The number of the consignment advice associated with the invoice line. -
ControlAmount: number
Title:
Tax Control Amount
The user-enterable value to ensure that the calculated tax will be the same as on the physical document. -
CostCenterSegment: string
Title:
Overlay Cost Center Segment
Maximum Length:25
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
(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:
true
The 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 Account
The accrual account that's initially debited for deferred expenses. -
DefAcctgEndDate: string
(date)
Title:
Multiperiod Accounting End Date
The multiperiod accounting end date on the invoice line. -
DefAcctgStartDate: string
(date)
Title:
Multiperiod Accounting Start Date
The multiperiod accounting start date on the invoice line. -
DefaultDistCcid: integer
(int64)
Title:
Default Distribution Combination ID
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
Title:
Description
Maximum Length:240
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
(int64)
Title:
Distribution Combination ID
The code combination identifier of the GL account associated with the transaction line. -
DistCodeConcatenated: string
Title:
Overlay Distribution Combination
Maximum Length:250
Accounting flexfield value for a distribution line. Use the valid segment separator from the accounting key flexfield definition. -
DistributionSetId: integer
(int64)
Title:
Distribution Set ID
The unique identifier of the distribution set. If the identifier isn't available, use the DistributionSetName. -
DistributionSetName: string
Title:
Distribution Set
Maximum Length:50
The 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:
30
The type of project expense. -
ExternalDocumentLineReference: string
Maximum Length:
240
Internal document reference number from Accounts Receivables system. -
FinalDischargeLocationCode: string
Title:
Location of Final Discharge
Maximum Length:60
The code that identifies the location of final discharge. -
FinalDischargeLocationId: integer
(int64)
Title:
Location of Final Discharge ID
The unique identifier of the final discharge location. -
FinalMatchFlag: boolean
Title:
Final Match
Maximum Length:1
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
Title:
Fiscal Charge Type
Maximum Length:30
The subclassification of invoice line type. For example, Freight or Miscellaneous. Valid values are defined in lookup ZX_CHARGE_TYPE. -
GlobalAttribute1: string
Title:
Global Attribute 1
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute10: string
Title:
Global Attribute 10
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute11: string
Title:
Global Attribute 11
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute12: string
Title:
Global Attribute 12
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute13: string
Title:
Global Attribute 13
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute14: string
Title:
Global Attribute 14
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute15: string
Title:
Global Attribute 15
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute16: string
Title:
Global Attribute 16
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute17: string
Title:
Global Attribute 17
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute18: string
Title:
Global Attribute 18
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute19: string
Title:
Global Attribute 19
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute2: string
Title:
Global Attribute 2
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute20: string
Title:
Global Attribute 20
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute3: string
Title:
Global Attribute 3
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute4: string
Title:
Global Attribute 4
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute5: string
Title:
Global Attribute 5
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute6: string
Title:
Global Attribute 6
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute7: string
Title:
Global Attribute 7
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute8: string
Title:
Global Attribute 8
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute9: string
Title:
Global Attribute 9
Maximum Length:150
A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttributeCategory: string
Title:
Global Attribute Category
Maximum Length:150
The global descriptive flexfield context name for the interface invoice line. -
InclInTaxableLineFlag: boolean
Title:
Included in Taxable Line Indicator
Maximum Length:1
Indicates whether the amount in the tax line is included in the taxable line. -
IncomeTaxRegion: string
Title:
Income Tax Region
Maximum Length:10
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. -
interfaceInvoiceLineRejections: array
Interface Invoice Line Rejections
Title:
Interface Invoice Line Rejections
The 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 ID
The unique identifier of the inventory item. -
InvoiceId: integer
(int64)
Title:
Invoice ID
Read Only:true
The unique identifier of the interface invoice. -
InvoiceLineId: integer
(int64)
Title:
Invoice Line ID
Read Only:true
The unique identifier of the interface invoice line. -
ItemDescription: string
Title:
Item Description
Maximum Length:240
A description of the item in the invoice line. The default value is populated from the inventory item. -
LastUpdateDate: string
(date-time)
Read Only:
true
The date when the record was last updated. -
LcmEnabledFlag: boolean
Title:
Landed Cost Enabled
Maximum Length:1
Indicates if the invoice line is enabled for landed cost. -
LineGroupNumber: integer
Title:
Line Group Number
The number of the Line group. Used to prorate charges across a group of lines. Must be a positive integer. -
LineNumber: integer
(int64)
Title:
Line
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
Title:
Line Type
Maximum Length:25
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. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
LoadRequestId: integer
(int64)
Title:
Load Process ID
Read Only:true
The unique identifier of the interface load job request that created the row. -
Manufacturer: string
Title:
Manufacturer
Maximum Length:30
Name of the manufacturer of an asset or item. This is a free text field. -
MatchOption: string
Title:
Match Option
Maximum Length:25
Indicates whether the invoice for the shipment should be matched to the purchase order or the receipt. -
ModelNumber: string
Title:
Model
Maximum Length:40
The model number of the invoice line item. -
OrgId: integer
(int64)
Title:
Business Unit
The unique identifier of the invoice business unit name. -
PaAdditionFlag: boolean
Maximum Length:
1
Default Value:false
Indicates 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:
1
The processing status of an invoice line by Oracle Projects in the receiver business unit. -
PackingSlip: string
Maximum Length:
25
The 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 1
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE10: string
Title:
Project Reserved Attribute 10
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE2: string
Title:
Project Reserved Attribute 2
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE3: string
Title:
Project Reserved Attribute 3
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE4: string
Title:
Project Reserved Attribute 4
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE5: string
Title:
Project Reserved Attribute 5
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE6: string
Title:
Project Reserved Attribute 6
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE7: string
Title:
Project Reserved Attribute 7
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE8: string
Title:
Project Reserved Attribute 8
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE9: string
Title:
Project Reserved Attribute 9
Maximum Length:150
Reserved for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE1: string
Title:
Project User-Defined Attribute 1
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE10: string
Title:
Project User-Defined Attribute 10
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE2: string
Title:
Project User-Defined Attribute 2
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE3: string
Title:
Project User-Defined Attribute 3
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE4: string
Title:
Project User-Defined Attribute 4
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE5: string
Title:
Project User-Defined Attribute 5
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE6: string
Title:
Project User-Defined Attribute 6
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE7: string
Title:
Project User-Defined Attribute 7
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE8: string
Title:
Project User-Defined Attribute 8
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE9: string
Title:
Project User-Defined Attribute 9
Maximum Length:150
User defined segment for Projects standard cost collection flexfield. -
PjcBillableFlag: boolean
Title:
Billable
Maximum Length:1
Indicates whether the project related item is available for customer billing -
PjcCapitalizableFlag: boolean
Title:
Capitalizable
Maximum Length:1
Indicates whether the project related item is eligible for capitalization. -
PjcContextCategory: string
Title:
Project Context Category
Maximum Length:40
Default Value:AP_Invoice_Line
Identifies descriptive flexfield application context for project-related standardized code collection. -
PjcContractId: number
Title:
Project Contract ID
The 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 ID
The identifier of the contract line. -
PjcContractName: string
Title:
Contract Name
Maximum Length:300
The name of the contract used in Oracle Contract Billing or Oracle Grants Accounting. -
PjcContractNumber: string
Title:
Contract Number
Maximum Length:120
The number of the Contract used in Oracle Contract Billing or Oracle Grants Accounting. -
PjcExpenditureItemDate: string
(date)
Title:
Project Expenditure Item Date
Date on which project-related transaction occurred. -
PjcExpenditureTypeId: number
Title:
Project Expenditure Type ID
Identifies descriptive flexfield application context for project-related standardized code collection. -
PjcExpenditureTypeName: string
Title:
Expenditure Type
Maximum Length:240
A classification of cost that's assigned to each expenditure item. -
PjcFundingAllocationId: number
Title:
Project Funding Allocation ID
Name of the project funding override. -
PjcFundingSourceName: string
Title:
Funding Source Name
Maximum Length:360
Name of the source funding the project. -
PjcFundingSourceNumber: string
Title:
Funding Source Number
Maximum Length:50
Number of the source funding the project. -
PjcOrganizationId: number
Title:
Expenditure Organization ID
The identifier of the organization to build transaction descriptive flexfield for project-related transaction distributions. -
PjcOrganizationName: string
Title:
Expenditure Organization
Maximum Length:240
The name of the organization to which the project is assigned. -
PjcProjectId: number
Title:
Project ID
Identifies descriptive flexfield application context for project-related standardized code collection. -
PjcProjectName: string
Title:
Project Name
Maximum Length:240
The name of the project to which the invoice expense is charged. -
PjcProjectNumber: string
Title:
Project Number
Maximum Length:25
The number of the project to which the invoice expense is charged. -
PjcTaskId: number
Title:
Task ID
Identifies descriptive flexfield application context for project-related standardized code collection. -
PjcTaskName: string
Title:
Task Name
Maximum Length:255
The name of the task used to build the transaction descriptive flexfield for project-related transaction distributions. -
PjcTaskNumber: string
Title:
Task Number
Maximum Length:100
A subdivision of project work. Task Number uniquely identifies the element within a project or structure. -
PjcWorkType: string
Title:
Work Type
Maximum Length:240
Classification of project-related work performed. -
PjcWorkTypeId: number
Title:
Project Work Type ID
The identifier of the project-related classification. -
PODistributionId: integer
Title:
Purchase Order Distribution ID
The unique identifier of the purchase order distribution line number that's matched to the invoice distribution. -
PODistributionNumber: integer
Title:
Purchase Order Distribution Number
The purchase order distribution line number that's matched to the invoice distribution. -
POHeaderId: integer
Title:
Purchase Order Header ID
The unique identifier of the purchase order document number that's matched to the invoice. -
POLineId: integer
Title:
Purchase Order Line ID
The unique identifier of the purchase order line number that's matched to the invoice line. -
POLineLocationId: integer
Title:
Purchase Order Line Location ID
The unique identifier of the purchase order schedule line number that's matched to the invoice line. -
POLineNumber: number
Title:
Purchase Order Line Number
The purchase order line number that's matched to the invoice line. -
PONumber: string
Title:
Purchase Order
Maximum Length:30
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
Title:
Purchase Order Schedule
The purchase order schedule line number that's matched to the invoice line. -
PriceCorrectInvLineNumber: integer
Title:
Price Correction Invoice Line
The number of the invoice line that price correction invoice is updating. -
PriceCorrectInvNumber: string
Title:
Price Correction Invoice
Maximum Length:50
The number of the invoice that price correction invoice is updating. -
PriceCorrectionFlag: boolean
Title:
Price Correction Indicator
Maximum Length:1
Indicates if a line creates a price correction. -
PrimaryIntendedUse: string
Title:
Intended Use
Maximum Length:30
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
Title:
Product Category
Maximum Length:240
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
Title:
Product Fiscal Classification
Maximum Length:240
The user-entered product fiscal classification that helps to uniquely identify a product fiscal classification. -
ProductTable: string
Title:
Product Table
Maximum Length:30
The name of the product source table used to generate the invoice. -
ProductType: string
Title:
Product Type
Maximum Length:240
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
(int64)
The unique identifier of the project referenced on the invoice line.
-
ProrateAcrossFlag: boolean
Title:
Prorate Across All Item Lines
Maximum Length:1
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
Title:
Purchasing Category
Maximum Length:2000
The item category referenced on the invoice line. -
PurchasingCategoryId: integer
(int64)
Title:
Purchasing Category ID
The unique identifier for the item category. -
QuantityInvoiced: number
Title:
Invoiced Quantity
The quantity that was invoiced. -
Queues: string
Title:
Queue Name
Maximum Length:255
Queue 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 Line
Maximum Length:25
The line number of the receipt associated with the invoice line. -
ReceiptNumber: string
Title:
Receipt
Maximum Length:30
The receipt number of the material associated with the invoice line. -
Reference1: string
Maximum Length:
30
Reference information from a non-Oracle application. This is a free text field. -
Reference2: string
Maximum Length:
30
Reference information from a non-Oracle application. This is a free text field. -
ReferenceKey1: string
Title:
Reference Key 1
Maximum Length:150
The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey2: string
Title:
Reference Key 2
Maximum Length:150
The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey3: string
Title:
Reference Key 3
Maximum Length:150
The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey4: string
Title:
Reference Key 4
Maximum Length:150
The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey5: string
Title:
Reference Key 5
Maximum Length:150
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
Title:
Requester Email Address
Maximum Length:240
The email address of the employee for the requested items. -
RequesterEmployeeNumber: string
Title:
Requester Employee Number
Maximum Length:30
The employee's unique identifier who made the request for the products or services. -
RequesterFirstName: string
Title:
Requester First Name
Maximum Length:150
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
(int64)
Title:
Requester ID
The unique identifier of the requester. -
RequesterLastName: string
Title:
Requester Last Name
Maximum Length:150
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
Title:
Serial Number
Maximum Length:35
The serial number for an item. -
ShipFromLocationCode: string
Title:
Ship-from Location
Maximum Length:60
The code that identifies the ship-from location. -
ShipFromLocationId: integer
(int64)
Title:
Ship-from Location ID
The unique identifier of the ship-from location. -
ShipToLocationCode: string
Title:
Ship-to Location
Maximum Length:60
The user-entered ship to location code that helps to uniquely identify a ship to location. -
ShipToLocationId: integer
(int64)
Title:
Ship-to Location ID
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
Maximum Length:
30
The entity code of the source document. -
SourceEventClassCode: string
Maximum Length:
30
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
Maximum Length:
30
The type of the source document transaction level. -
StatAmount: number
Title:
Statistical Quantity
The amount associated with a distribution line for measuring statistical quantities. -
TaskId: integer
(int64)
The unique identifier of the project task.
-
Tax: string
Title:
Tax Name
Maximum Length:30
The classification name of the charge imposed by a government through a fiscal or tax authority. -
TaxableFlag: boolean
Title:
Taxable Indicator
Maximum Length:1
Indicates whether a line is taxable. -
TaxClassificationCode: string
Title:
Tax Classification
Maximum Length:30
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
Maximum Length:
15
The 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 Code
Maximum Length:30
The code of the tax jurisdiction associated with the tax rate on the invoice line. -
TaxRate: number
Title:
Tax Rate
The rate specified for a tax rate. -
TaxRateCode: string
Title:
Tax Rate Code
Maximum Length:150
The tax rate code associated with the tax rate identifier. -
TaxRateId: integer
(int64)
Title:
Tax Rate ID
The internal identifier of the tax rate that's effective on the invoice date. -
TaxRegimeCode: string
Title:
Tax Regime Code
Maximum Length:30
The 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 Code
Maximum Length:30
The code that represent the tax status. -
TransientAccount: string
Title:
Distribution Combination
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
Title:
Multiperiod Accounting Accrual Account
The accrual account used in multiperiod accounting to accrue deferred expenses. -
TransientProjectDFF: string
Title:
Project Information
Additional information for project standard cost collection flexfield. -
TrxBusinessCategory: string
Title:
Transaction Business Category
Maximum Length:240
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
Title:
Income Tax Type
Maximum Length:10
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
Title:
UOM
Maximum Length:25
The unit of measure for the quantity invoiced. -
UnitPrice: number
Title:
Unit Price
The price charged per unit of a good or service. -
UserDefinedFiscClass: string
Title:
User-Defined Fiscal Classification
Maximum Length:240
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
Title:
Supplier Item Number
Maximum Length:300
The number that identifies the supplier's item. -
WarrantyNumber: string
Maximum Length:
15
The warranty number of the item on the invoice line.
Nested Schema : Interface Invoice Line Rejections
Type:
array
Title:
Interface Invoice Line Rejections
The 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:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : payablesInterfaceInvoices-interfaceInvoiceLines-interfaceInvoiceLineRejections-item-response
Type:
Show Source
object
-
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
RejectionDescription: string
Read Only:
true
Maximum Length:255
The reason for rejection of the interface invoice line.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed 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.