Get all interface invoices
get
/fscmRestApi/resources/11.13.18.05/payablesInterfaceInvoices
Request
Query Parameters
-
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 Finds the interface invoice with the specified primary key.
Finder Variables- InvoiceId; integer; The unique identifier of the interface invoice.
- LoadRequestId; integer; The unique identifier of the load request.
- findBySpreadsheetSearch Finds the interface invoices and interface invoice lines that match the specified criteria.
Finder Variables- BusinessUnit; string; The business unit associated with the interface invoice.
- CreationDateFrom; string; The start date of the date range within which the interface invoices created are searched.
- CreationDateTo; string; The end date of the date range within which the interface invoices created are searched.
- ExceptionCategory; string; The exception category associated with the import error of the interface invoice.
- HeadersOnly; string; Indicates that only the interface invoice with import errors are searched.
- ImportError; string; The import error associated with the interface invoice.
- ImportSet; string; The import set associated with the interface invoice.
- InvoiceNumber; string; The invoice number associated with the interface invoice.
- InvoiceSource; string; The source associated with the interface invoice.
- Ledger; string; The ledger associated with the interface invoice.
- LineNumberFrom; integer; The starting line number of the interface invoice line number range that's searched.
- LineNumberTo; integer; The ending line number of the interface invoice line number range that's searched.
- NoOfInvoices; integer; Limits the count of interface invoices to the given number.
- Queue; string; The queue associated to the import error of the interface invoice.
- ShowOnlyErrorLines; string; Indicates that only the interface invoice lines with import errors are searched.
- Supplier; string; The supplier associated with the interface invoice.
- SupplierSite; string; The supplier site associated with the interface invoice.
- TotalNoOfInvoiceLines; integer; Limits the count of interface invoice lines to the given number.
- PrimaryKey Finds the interface invoice 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:- AcctsPayCodeCombinationId; integer; The unique identifier of the account combination to which liability is recorded. Payables uses the liability account combination when accounting entries are created for invoices.
- AddTaxToInvoiceAmountFlag; boolean; Indicates whether the tax amount should be added to the invoice amount.
- AmountApplicableToDiscount; number; The invoice amount that's applicable for discount.
- ApplicationId; integer; The unique identifier of the source application.
- ApplyAdvancesFlag; boolean; Indicates whether the advance should be applied to the expense reports and other invoices.
- Attribute1; string; A segment for the interface invoices descriptive flexfield.
- Attribute10; string; A segment for the interface invoices descriptive flexfield.
- Attribute11; string; A segment for the interface invoices descriptive flexfield.
- Attribute12; string; A segment for the interface invoices descriptive flexfield.
- Attribute13; string; A segment for the interface invoices descriptive flexfield.
- Attribute14; string; A segment for the interface invoices descriptive flexfield.
- Attribute15; string; A segment for the interface invoices descriptive flexfield.
- Attribute2; string; A segment for the interface invoices descriptive flexfield.
- Attribute3; string; A segment for the interface invoices descriptive flexfield.
- Attribute4; string; A segment for the interface invoices descriptive flexfield.
- Attribute5; string; A segment for the interface invoices descriptive flexfield.
- Attribute6; string; A segment for the interface invoices descriptive flexfield.
- Attribute7; string; A segment for the interface invoices descriptive flexfield.
- Attribute8; string; A segment for the interface invoices descriptive flexfield.
- Attribute9; string; A segment for the interface invoices descriptive flexfield.
- AttributeCategory; string; Descriptive flexfield context name for interface invoice.
- AttributeDate1; string; A date segment for the interface invoices descriptive flexfield.
- AttributeDate2; string; A date segment for the interface invoices descriptive flexfield.
- AttributeDate3; string; A date segment for the interface invoices descriptive flexfield.
- AttributeDate4; string; A date segment for the interface invoices descriptive flexfield.
- AttributeDate5; string; A date segment for the interface invoices descriptive flexfield.
- AttributeNumber1; number; A number segment for the interface invoices descriptive flexfield.
- AttributeNumber2; number; A number segment for the interface invoices descriptive flexfield.
- AttributeNumber3; number; A number segment for the interface invoices descriptive flexfield.
- AttributeNumber4; number; A number segment for the interface invoices descriptive flexfield.
- AttributeNumber5; number; A number segment for the interface invoices descriptive flexfield.
- AwtGroupId; integer; The unique identifier of the withholding tax group. If the identifier isn't available, use the attribute AwtGroupName.
- AwtGroupName; string; Name of the withholding tax group. This is used to apply multiple withholding taxes to an invoice line. Valid values are defined in Manage Withholding Groups task.
- BankChargeBearer; string; The bearer of bank charge cost. A list of accepted values are defined in the lookup type IBY_BANK_CHARGE_BEARER. You can review and update the list of acceptable values using the Setup and Maintenance work area, and the Manage Standard Lookups task.
- BudgetDate; string; The budgetary calendar period date applicable for funds checking.
- CalculateTaxDuringImportFlag; boolean; Indicates whether the tax should be calculated for an invoice during import.
- ControlAmount; number; The user-enterable value to ensure that the calculated tax will be the same as on the physical document.
- CorrectionPeriod; string; Correction period for the invoice being corrected.
- CorrectionYear; number; Correction year for the invoice. For example: 2020.
- CreationDate; string; The date when the record was created.
- CustomerRegistrationCode; string; The code representing the customer legal registration. Used to derive customer registration number for an invoice. You can review list of valid values using the Manage Suppliers task, Transaction Tax region.
- CustomerRegistrationNumber; string; The registration number of the customer. You can review list of valid values using the Manage Suppliers task, Transaction Tax region.
- DeliveryChannelCode; string; The code representing the delivery channel entered by an user. This is used as an unique identifier for a delivery channel.
- Description; string; A brief description of an invoice.
- DocumentCategoryCode; string; The document sequence category code used to derive the document sequence of the transaction. This attribute is a mandatory attribute, which is based on the Sequencing setup at Specify Ledger Options for the ledger associated to the invoicing business unit.
- DocumentSubType; string; The classification that categorizes the document associated with an interface invoice for tax or governmental authority.
- ExchangeDate; string; The date as of which a conversion rate is used to convert an amount into another currency for an invoice. It's a mandatory attribute for invoices that aren't in ledger currency. The value can either be provided while creating the invoice or populated by default from the accounting date of the invoice.
- ExchangeRate; number; The conversion rate at which the principal unit of one currency is converted into another currency for an invoice. It's a mandatory attribute for invoices that aren't in ledger currency, which is based on the Require conversion rate entry option in the Manage Common Options for Payables and Procurement options for the invoicing business unit. The value can either be provided while creating the invoice or populated by default from the Manage Daily Rates for the conversion rate type and date, or can be updated later using the Apply Missing Conversion Rates process.
- ExchangeRateType; string; The source of currency conversion rate for an invoice. For example, corporate, user-defined, and spot. This is a mandatory attribute for invoices that aren't in ledger currencies, which is based on the Require conversion rate entry option in the Manage Common Options for Payables and Procurement options for the invoicing business unit. The value can either be provided while creating an invoice or populated by default from the Conversion Rate Type from the Manage Common Options for Payables and Procurement options for the invoicing business unit.
- ExclusivePaymentFlag; boolean; Indicates whether the payment to the invoice is paid on a separate payment document.
- ExternalBankAccountIBANNumber; string; The supplier bank account number to which the payment will be remitted. The value can either be provided while creating an invoice or populated by default from the Supplier Site, Address, or Profile-level payment attributes.
- ExternalBankAccountId; integer; The unique identifier for the supplier bank account. The value can either be provided while creating an invoice or populated by default from the Supplier Site, Address, or Profile-level payment attributes. If you provide values for multiple bank account-related attributes, such as Bank Account, Supplier IBAN, or External Bank Account ID, then all the information provided is validated.
- ExternalDocumentReference; string; The internal document reference number from Accounts Receivables system.
- FirstPartyRegistrationId; integer; The unique identifier of the first party tax registration.
- FirstPartyRegistrationNumber; string; The tax registration number of the first party. The value can either be provided while creating an invoice or populated by default from the first party legal establishment. You can also update the value for the first-party tax registration number.
- GlDate; string; The accounting date captured on the invoice that's finally used to default to invoice lines and distributions. The value can either be provided while creating the invoice or derived based on the Accounting Date Basis option on the Manage Invoice Options for the invoicing business unit.
- GlobalAttribute1; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute10; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute11; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute12; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute13; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute14; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute15; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute16; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute17; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute18; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute19; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute2; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute20; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute3; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute4; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute5; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute6; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute7; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute8; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttribute9; string; A segment for the interface invoices global descriptive flexfield.
- GlobalAttributeCategory; string; The global descriptive flexfield context name for the interface invoice.
- GlobalAttributeDate1; string; A date segment for the interface invoices global descriptive flexfield.
- GlobalAttributeDate2; string; A date segment for the interface invoices global descriptive flexfield.
- GlobalAttributeDate3; string; A date segment for the interface invoices global descriptive flexfield.
- GlobalAttributeDate4; string; A date segment for the interface invoices global descriptive flexfield.
- GlobalAttributeDate5; string; A date segment for the interface invoices global descriptive flexfield.
- GlobalAttributeNumber1; number; A number segment for the interface invoices global descriptive flexfield.
- GlobalAttributeNumber2; number; A number segment for the interface invoices global descriptive flexfield.
- GlobalAttributeNumber3; number; A number segment for the interface invoices global descriptive flexfield.
- GlobalAttributeNumber4; number; A number segment for the interface invoices global descriptive flexfield.
- GlobalAttributeNumber5; number; A number segment for the interface invoices global descriptive flexfield.
- GoodsReceivedDate; string; The date when the goods were received. This date is used to calculate the invoice payment due date. The value can either be provided while creating the invoice or populated by default to the system date.
- GroupId; string; The unique name of the invoice group assigned to a group of invoices used for reporting and payment purposes. It's a mandatory attribute, which is based on the Require invoice grouping option in the Manage Invoice Options for the invoicing business unit.
- ImageDocumentNumber; string; The unique image document number associated with the invoice.
- ImageDocumentUri; string; The unique reference number to identify the image with the invoice.
- ImportDocumentDate; string; The date assigned by the user during import of invoice.
- ImportDocumentNumber; string; The document number assigned by the user.
- ImportRequestId; integer; The request identifier of the job that created or last updated the row.
- InitBusinessUnitTransient; string; The business unit associated with the invoice.
- InitExceptionCategoryTransient; string; Category of the exception associated with the rejection raised on the invoice.
- InitSourceTransient; string; The code that indicates the feeder system from which an invoice is created. The valid values are defined in the SOURCE lookup type. You can review the valid values using the Setup and Maintenance work area and the Manage Payables Lookups task.
- InvoiceAmount; number; The invoice amount in transaction currency. The value must be provided while creating an invoice.
- InvoiceCurrencyCode; string; The three-letter ISO code associated with a currency used on the invoice.
- InvoiceDate; string; The date on the supplier invoice. The value can either be provided while creating an invoice or populated by default to the system date.
- InvoiceId; integer; The unique identifier of the invoice, is generated while creating the invoice.
- InvoiceIncludesPrepayFlag; boolean; Indicates whether the invoice amount includes the prepayment amount and any associated tax that are referenced on the supplier invoice. The default value is false.
- InvoiceNumber; string; The unique number of the supplier invoice.
- InvoiceReceivedDate; string; The date when the invoice was received. This date can be used to calculate the invoice payment due date. The value can either be provided while creating the invoice or populated by default to the system date.
- InvoiceTypeLookupCode; string; The lookup code indicating the type of the invoice. The valid values are Standard, Prepayment, Credit Memo, and Debit Memo.
- LastUpdateDate; string; The date when the record was last updated.
- LegalEntityId; integer; The unique identifier of the legal entity on the interface invoice.
- LegalEntityName; string; The name of the legal entity. The value can either be provided while creating an invoice or derived by the system.
- LoadRequestId; integer; The unique identifier of the request associated with the interface load job that created the row.
- NetOfRetainageFlag; boolean; Indicates whether the retainage amount is deducted from the invoice amount.
- NoXrateBaseAmount; number; Invoice amount in the ledger currency. Used to calculate conversion rate. Used only when Calculate User Exchange Rate option is enabled for foreign currency invoices with exchange rate type of User.
- OperatingUnit; string; The business unit associated with the invoice.
- OrgId; integer; The unique identifier of the business unit associated with the invoice. If the business unit identifier isn't available, use the OperatingUnit attribute.
- PONumber; string; Document number used to request a seller to supply a product or service for payment.
- PaidOnBehalfEmployeeId; integer; The employee ID of the employee associated with the original expense report, when the expense report is split using Both Pay Scenario.
- PartyId; integer; The unique identifier of the party associated with the supplier or party associated with the employee or customers for payment request type of invoices.
- PartySiteId; integer; The unique identifier of the party associated with the supplier site.
- PayGroupLookupCode; string; The code representing a group of supplier or invoices for a single pay run. For example, employees, merchandise, and nonmerchandise. You can review and update the valid values using Manage Payables Lookups task, lookup type PAY GROUP.
- PayProcTrxnTypeCode; string; The code representing the type of payment processing transaction or document.
- PaymentCrossRate; number; Conversion rate used to convert the entered amount to ledger currency if the entered amount isn't in ledger currency.
- PaymentCrossRateDate; string; The date as of which a conversion rate is used to convert the entered amount into ledger currency.
- PaymentCrossRateType; string; The source of a currency conversion rate used to convert the derived amount into ledger currency, such as user defined, spot, or corporate.
- PaymentCurrencyCode; string; The code representing the currency that the payment is made in.
- PaymentFunction; string; The function or purpose of the payment.
- PaymentMethodCode; string; The method of payment, such as check, cash, or credit. Use the Manage Payment Methods task to identify valid values.
- PaymentMethodLookupCode; string; Name of the payment method. Use the Manage Payables Lookups task, lookup type PAYMENT METHOD to identify valid values.
- PaymentPriority; integer; The payment priority for a scheduled payment. Valid values are whole numbers from 1 to 99.
- PaymentReasonCode; string; Code that indicates the reason for payment for payment system or bank with additional details for the payment. You can review the valid values using the Manage Payment Codes task. The corresponding Payment Code Type must be Payment Reason.
- PaymentReasonComments; string; Reason for the payment.
- PortOfEntryCode; string; Identifies the location or port through which the invoiced goods entered the country.
- PrepayApplyAmount; number; Amount of prepayment to apply to the invoice. The prepayment amount must be a positive value and can't exceed the unpaid invoice amount or the amount of available prepayments.
- PrepayGlDate; string; Accounting date for the prepayment application.
- PrepayLineNumber; integer; The line number of the prepayment line applied to the invoice line.
- PrepayNumber; string; Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice.
- ProductTable; string; Name of the product source table used to generate an invoice.
- Reference1; string; Captures invoice reference information from non-Oracle application.
- Reference2; string; Captures invoice reference information from non-Oracle application.
- 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.
- RemitToAddressName; string; The third-party payment related remit-to address where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to address page.
- RemitToSupplierName; string; The third-party payment related remit-to supplier where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to supplier page.
- RemitToSupplierNumber; string; The supplier number of the third party.
- RemittanceMessage1; string; The remittance message for use in payment processing. You can provide the information during invoice creation or update it later.
- RemittanceMessage2; string; The remittance message for use in payment processing. You can provide the information during invoice creation or update it later.
- RemittanceMessage3; string; The remittance message for use in payment processing. You can provide the information during invoice creation or update it later.
- 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.
- RoutingAttribute1; string; Captures additional attributes information that may have been used for routing payables invoice images.
- RoutingAttribute2; string; Captures additional attributes information that may have been used for routing payables invoice images.
- RoutingAttribute3; string; Captures additional attributes information that may have been used for routing payables invoice images.
- RoutingAttribute4; string; Captures additional attributes information that may have been used for routing payables invoice images.
- RoutingAttribute5; string; Captures additional attributes information that may have been used for routing payables invoice images.
- SettlementPriority; string; The priority with which the financial institution or payment system should settle the payment for a document. A list of accepted values is defined in the lookup type IBY_SETTLEMENT_PRIORITY. You can review and update the valid values using Setup and Maintenance work area and the Manage Standard Lookups task.
- ShipToLocation; string; The location where the goods and services have been shipped to by the supplier.
- Source; string; The code that indicates the feeder system from which an invoice is created. The valid values are defined in the SOURCE lookup type. You can review the valid values using the Setup and Maintenance work area and the Manage Payables Lookups task.
- Status; string; Status of the row for the import process.
- SupplierTaxExchangeRate; number; The supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices.
- SupplierTaxInvoiceDate; string; Tax invoice date on the supplier-issued tax invoice.
- SupplierTaxInvoiceNumber; string; The supplier tax invoice number.
- TaxInvoiceInternalSequence; string; The internal sequence number issued by the company for a supplier issued tax invoice.
- TaxInvoiceRecordingDate; string; The date when the supplier issued tax invoice was recorded. Provide value for this attribute if the company-specific tax invoice date and number is captured.
- TaxRelatedInvoiceId; integer; The unique identifier of the related tax invoice.
- TaxationCountry; string; The country where the transaction took place for taxation purposes. Oracle Fusion Tax sets the context of other tax drivers such as the Product Fiscal Classification based on the value of this field. The value can either be provided when creating an invoice or it's populated by default from the setup.
- TermsDate; string; The date used with payment terms to calculate installment along with due date and discount dates. The value can either be provided while creating an invoice or derived based on the Terms Date Basis option from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- TermsId; integer; The unique identifier of the payment terms that's used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice.
- TermsName; string; The name of the payment terms that's used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- ThirdPartyRegistrationId; integer; The unique identifier of the third party tax registration number.
- ThirdPartyRegistrationNumber; string; The tax registration number of the third party. The value can either be provided while creating an invoice or populated by default from the supplier.
- TransientAccount; string; The account combination to which liability is recorded. Payables uses the liability account combination when accounting entries are created for invoices. The value can either be provided while creating an invoice or populated by default from the Supplier Site Assignment or from the Default Distributions from Manage Common Options for Payables and Procurement options for the invoicing business unit.
- UniqueRemittanceIdentifier; string; The unique identifier for the remittance. Contains reference information for a payment.
- UriCheckDigit; string; A check digit used to validate the unique identifier of the remittance.
- VendorEmailAddress; string; The supplier email address on the invoice.
- VendorId; integer; The unique identifier of the supplier on the interface invoice.
- VendorName; string; The supplier name on the invoice. The value must be provided while creating the invoice. It can't be updated once the invoice is created.
- VendorNumber; string; The unique number assigned to a supplier.
- VendorSiteCode; string; The name of the physical location of the supplier from where the goods and services are rendered. The value must be provided during creation action. It can't be updated once the invoice is created.
- VendorSiteId; integer; The unique identifier of the supplier site on the interface invoice.
- VoucherNumber; string; The manual voucher number when document sequential numbering isn't used.
-
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
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-item-response
Type:
Show Source
object
-
AcctsPayCodeCombinationId: integer
(int64)
Title:
Liability Distribution ID
The unique identifier of the account combination to which liability is recorded. Payables uses the liability account combination when accounting entries are created for invoices. -
AddTaxToInvoiceAmountFlag: boolean
Title:
Add Tax to Invoice Amount
Maximum Length:1
Default Value:false
Indicates whether the tax amount should be added to the invoice amount. -
AmountApplicableToDiscount: number
Title:
Discountable Amount
The invoice amount that's applicable for discount. -
ApplicationId: integer
(int64)
Title:
Application ID
Default Value:200
The unique identifier of the source application. -
ApplyAdvancesFlag: boolean
Maximum Length:
1
Indicates whether the advance should be applied to the expense reports and other invoices. -
Attribute1: string
Title:
Attribute 1
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute10: string
Title:
Attribute 10
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute11: string
Title:
Attribute 11
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute12: string
Title:
Attribute 12
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute13: string
Title:
Attribute 13
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute14: string
Title:
Attribute 14
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute15: string
Title:
Attribute 15
Maximum Length:1000
A segment for the interface invoices descriptive flexfield. -
Attribute2: string
Title:
Attribute 2
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute3: string
Title:
Attribute 3
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute4: string
Title:
Attribute 4
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute5: string
Title:
Attribute 5
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute6: string
Title:
Attribute 6
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute7: string
Title:
Attribute 7
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute8: string
Title:
Attribute 8
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
Attribute9: string
Title:
Attribute 9
Maximum Length:150
A segment for the interface invoices descriptive flexfield. -
AttributeCategory: string
Title:
Context Value
Maximum Length:150
Descriptive flexfield context name for interface invoice. -
AttributeDate1: string
(date)
A date segment for the interface invoices descriptive flexfield.
-
AttributeDate2: string
(date)
A date segment for the interface invoices descriptive flexfield.
-
AttributeDate3: string
(date)
A date segment for the interface invoices descriptive flexfield.
-
AttributeDate4: string
(date)
A date segment for the interface invoices descriptive flexfield.
-
AttributeDate5: string
(date)
A date segment for the interface invoices descriptive flexfield.
-
AttributeNumber1: number
A number segment for the interface invoices descriptive flexfield.
-
AttributeNumber2: number
A number segment for the interface invoices descriptive flexfield.
-
AttributeNumber3: number
A number segment for the interface invoices descriptive flexfield.
-
AttributeNumber4: number
A number segment for the interface invoices descriptive flexfield.
-
AttributeNumber5: number
A number segment for the interface invoices descriptive flexfield.
-
AwtGroupId: integer
(int64)
Title:
Withholding Tax Group ID
The unique identifier of the withholding tax group. If the identifier isn't available, use the attribute AwtGroupName. -
AwtGroupName: string
Title:
Withholding Tax Group
Maximum Length:25
Name of the withholding tax group. This is used to apply multiple withholding taxes to an invoice line. Valid values are defined in Manage Withholding Groups task. -
BankAccountNumber: string
Title:
Remit-to Bank Account Number
The supplier bank account number to which the payment will be remitted. The value can either be provided while creating an invoice or populated by default from the Supplier Site, Address, or Profile-level payment attributes. -
BankChargeBearer: string
Title:
Bank Charge Bearer
Maximum Length:30
The bearer of bank charge cost. A list of accepted values are defined in the lookup type IBY_BANK_CHARGE_BEARER. You can review and update the list of acceptable values using the Setup and Maintenance work area, and the Manage Standard Lookups task. -
BudgetDate: string
(date)
Title:
Budget Date
The budgetary calendar period date applicable for funds checking. -
CalculateTaxDuringImportFlag: boolean
Title:
Calculate Tax During Import
Maximum Length:1
Default Value:true
Indicates whether the tax should be calculated for an invoice during import. -
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. -
CorrectionPeriod: string
Title:
Correction Period
Maximum Length:15
Correction period for the invoice being corrected. -
CorrectionYear: number
Title:
Correction Year
Correction year for the invoice. For example: 2020. -
CreationDate: string
(date-time)
Title:
Creation Date
Read Only:true
The date when the record was created. -
CustomerRegistrationCode: string
Title:
Customer Registration Code
Maximum Length:30
The code representing the customer legal registration. Used to derive customer registration number for an invoice. You can review list of valid values using the Manage Suppliers task, Transaction Tax region. -
CustomerRegistrationNumber: string
Title:
Tax Registration Number
Maximum Length:30
The registration number of the customer. You can review list of valid values using the Manage Suppliers task, Transaction Tax region. -
DeliveryChannelCode: string
Title:
Delivery Channel
Maximum Length:30
The code representing the delivery channel entered by an user. This is used as an unique identifier for a delivery channel. -
Description: string
Title:
Description
Maximum Length:240
A brief description of an invoice. -
DocumentCategoryCode: string
Title:
Document Category
Maximum Length:30
The document sequence category code used to derive the document sequence of the transaction. This attribute is a mandatory attribute, which is based on the Sequencing setup at Specify Ledger Options for the ledger associated to the invoicing business unit. -
DocumentSubType: string
Title:
Document Subtype
Maximum Length:150
The classification that categorizes the document associated with an interface invoice for tax or governmental authority. -
ExchangeDate: string
(date)
Title:
Conversion Date
The date as of which a conversion rate is used to convert an amount into another currency for an invoice. It's a mandatory attribute for invoices that aren't in ledger currency. The value can either be provided while creating the invoice or populated by default from the accounting date of the invoice. -
ExchangeRate: number
Title:
Conversion Rate
The conversion rate at which the principal unit of one currency is converted into another currency for an invoice. It's a mandatory attribute for invoices that aren't in ledger currency, which is based on the Require conversion rate entry option in the Manage Common Options for Payables and Procurement options for the invoicing business unit. The value can either be provided while creating the invoice or populated by default from the Manage Daily Rates for the conversion rate type and date, or can be updated later using the Apply Missing Conversion Rates process. -
ExchangeRateType: string
Title:
Conversion Rate Type
Maximum Length:30
The source of currency conversion rate for an invoice. For example, corporate, user-defined, and spot. This is a mandatory attribute for invoices that aren't in ledger currencies, which is based on the Require conversion rate entry option in the Manage Common Options for Payables and Procurement options for the invoicing business unit. The value can either be provided while creating an invoice or populated by default from the Conversion Rate Type from the Manage Common Options for Payables and Procurement options for the invoicing business unit. -
ExclusivePaymentFlag: boolean
Title:
Pay Alone
Maximum Length:1
Indicates whether the payment to the invoice is paid on a separate payment document. -
ExternalBankAccountIBANNumber: string
Title:
Supplier IBAN
Maximum Length:50
The supplier bank account number to which the payment will be remitted. The value can either be provided while creating an invoice or populated by default from the Supplier Site, Address, or Profile-level payment attributes. -
ExternalBankAccountId: integer
(int64)
Title:
Remit-to Account
The unique identifier for the supplier bank account. The value can either be provided while creating an invoice or populated by default from the Supplier Site, Address, or Profile-level payment attributes. If you provide values for multiple bank account-related attributes, such as Bank Account, Supplier IBAN, or External Bank Account ID, then all the information provided is validated. -
ExternalDocumentReference: string
Maximum Length:
240
The internal document reference number from Accounts Receivables system. -
FirstPartyRegistrationId: integer
(int64)
Title:
First-Party Tax Registration ID
The unique identifier of the first party tax registration. -
FirstPartyRegistrationNumber: string
Title:
First-Party Tax Registration Number
Maximum Length:60
The tax registration number of the first party. The value can either be provided while creating an invoice or populated by default from the first party legal establishment. You can also update the value for the first-party tax registration number. -
GlDate: string
(date)
Title:
Accounting Date
The accounting date captured on the invoice that's finally used to default to invoice lines and distributions. The value can either be provided while creating the invoice or derived based on the Accounting Date Basis option on the Manage Invoice Options for the invoicing business unit. -
GlobalAttribute1: string
Title:
Global Attribute 1
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute10: string
Title:
Global Attribute 10
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute11: string
Title:
Global Attribute 11
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute12: string
Title:
Global Attribute 12
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute13: string
Title:
Global Attribute 13
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute14: string
Title:
Global Attribute 14
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute15: string
Title:
Global Attribute 15
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute16: string
Title:
Global Attribute 16
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute17: string
Title:
Global Attribute 17
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute18: string
Title:
Global Attribute 18
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute19: string
Title:
Global Attribute 19
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute2: string
Title:
Global Attribute 2
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute20: string
Title:
Global Attribute 20
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute3: string
Title:
Global Attribute 3
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute4: string
Title:
Global Attribute 4
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute5: string
Title:
Global Attribute 5
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute6: string
Title:
Global Attribute 6
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute7: string
Title:
Global Attribute 7
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute8: string
Title:
Global Attribute 8
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute9: string
Title:
Global Attribute 9
Maximum Length:150
A segment for the interface invoices global descriptive flexfield. -
GlobalAttributeCategory: string
Title:
Global Attribute Category
Maximum Length:150
The global descriptive flexfield context name for the interface invoice. -
GlobalAttributeDate1: string
(date)
Title:
Global Attribute Date 1
A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeDate2: string
(date)
Title:
Global Attribute Date 2
A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeDate3: string
(date)
Title:
Global Attribute Date 3
A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeDate4: string
(date)
Title:
Global Attribute Date 4
A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeDate5: string
(date)
Title:
Global Attribute Date 5
A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber1: number
Title:
Global Attribute Number 1
A number segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber2: number
Title:
Global Attribute Number 2
A number segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber3: number
Title:
Global Attribute Number 3
A number segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber4: number
Title:
Global Attribute Number 4
A number segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber5: number
Title:
Global Attribute Number 5
A number segment for the interface invoices global descriptive flexfield. -
GoodsReceivedDate: string
(date)
Title:
Goods Received
The date when the goods were received. This date is used to calculate the invoice payment due date. The value can either be provided while creating the invoice or populated by default to the system date. -
GroupId: string
Title:
Import Set
Maximum Length:80
The unique name of the invoice group assigned to a group of invoices used for reporting and payment purposes. It's a mandatory attribute, which is based on the Require invoice grouping option in the Manage Invoice Options for the invoicing business unit. -
ImageDocumentNumber: string
Maximum Length:
50
The unique image document number associated with the invoice. -
ImageDocumentUri: string
Title:
URL Attachment
Maximum Length:4000
The unique reference number to identify the image with the invoice. -
ImportDocumentDate: string
(date)
Title:
Import Document Date
The date assigned by the user during import of invoice. -
ImportDocumentNumber: string
Title:
Import Document Number
Maximum Length:50
The document number assigned by the user. -
ImportRequestId: integer
Title:
Request ID
Read Only:true
The request identifier of the job that created or last updated the row. -
InitBusinessUnitTransient: string
Read Only:
true
The business unit associated with the invoice. -
InitExceptionCategoryTransient: string
Read Only:
true
Category of the exception associated with the rejection raised on the invoice. -
InitSourceTransient: string
Read Only:
true
The code that indicates the feeder system from which an invoice is created. The valid values are defined in the SOURCE lookup type. You can review the valid values using the Setup and Maintenance work area and the Manage Payables Lookups task. -
interfaceInvoiceLines: array
Interface Invoice Lines
Title:
Interface Invoice Lines
The payables interface invoice lines resource is used to manage details about goods and services, which includes freight, and miscellaneous charges that can be allocated to item lines. Note that the service endpoints in this resource are specifically designed to only work with the visual builder add-in for Excel. -
interfaceInvoiceRejections: array
Interface Invoice Rejections
Title:
Interface Invoice Rejections
The payables interface invoice rejection resource is used to view the interface invoice attributes rejections. Note that the service endpoints in this resource are specifically designed to only work with the visual builder add-in for Excel. -
InvoiceAmount: number
Title:
Invoice Amount
The invoice amount in transaction currency. The value must be provided while creating an invoice. -
InvoiceCurrencyCode: string
Title:
Invoice Currency
Maximum Length:15
The three-letter ISO code associated with a currency used on the invoice. -
InvoiceDate: string
(date)
Title:
Invoice Date
The date on the supplier invoice. The value can either be provided while creating an invoice or populated by default to the system date. -
InvoiceId: integer
(int64)
Title:
Invoice ID
Read Only:true
The unique identifier of the invoice, is generated while creating the invoice. -
InvoiceIncludesPrepayFlag: boolean
Title:
Invoice Includes Prepayment
Maximum Length:1
Indicates whether the invoice amount includes the prepayment amount and any associated tax that are referenced on the supplier invoice. The default value is false. -
InvoiceNumber: string
Title:
Invoice Number
Maximum Length:50
The unique number of the supplier invoice. -
InvoiceReceivedDate: string
(date)
Title:
Invoice Received
The date when the invoice was received. This date can be used to calculate the invoice payment due date. The value can either be provided while creating the invoice or populated by default to the system date. -
InvoiceRecordNumber: string
Title:
Invoice Header Identifier
The unique sequential number assigned to an invoice. -
InvoiceTypeLookupCode: string
Title:
Type
Maximum Length:25
Default Value:STANDARD
The lookup code indicating the type of the invoice. The valid values are Standard, Prepayment, Credit Memo, and Debit Memo. -
LastUpdateDate: string
(date-time)
Read Only:
true
The date when the record was last updated. -
LegalEntityId: integer
(int64)
Title:
Legal Entity ID
The unique identifier of the legal entity on the interface invoice. -
LegalEntityName: string
Title:
Legal Entity Name
Maximum Length:240
The name of the legal entity. The value can either be provided while creating an invoice or derived by the system. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
LoadRequestId: integer
(int64)
Title:
Load Process ID
Read Only:true
Default Value:-1
The unique identifier of the request associated with the interface load job that created the row. -
NetOfRetainageFlag: boolean
Maximum Length:
1
Indicates whether the retainage amount is deducted from the invoice amount. -
NoXrateBaseAmount: number
Title:
No Conversion Rate Accounted Amount
Invoice amount in the ledger currency. Used to calculate conversion rate. Used only when Calculate User Exchange Rate option is enabled for foreign currency invoices with exchange rate type of User. -
OperatingUnit: string
Title:
Business Unit
Maximum Length:240
The business unit associated with the invoice. -
OrgId: integer
(int64)
Title:
Business Unit
The unique identifier of the business unit associated with the invoice. If the business unit identifier isn't available, use the OperatingUnit attribute. -
PaidOnBehalfEmployeeId: integer
(int64)
The employee ID of the employee associated with the original expense report, when the expense report is split using Both Pay Scenario.
-
PartyId: integer
(int64)
The unique identifier of the party associated with the supplier or party associated with the employee or customers for payment request type of invoices.
-
PartySiteId: integer
(int64)
The unique identifier of the party associated with the supplier site.
-
PayGroupLookupCode: string
Title:
Pay Group
Maximum Length:25
The code representing a group of supplier or invoices for a single pay run. For example, employees, merchandise, and nonmerchandise. You can review and update the valid values using Manage Payables Lookups task, lookup type PAY GROUP. -
PaymentCrossRate: number
Title:
Payment Cross-Conversion Rate
Default Value:1
Conversion rate used to convert the entered amount to ledger currency if the entered amount isn't in ledger currency. -
PaymentCrossRateDate: string
(date)
Title:
Payment Cross-Conversion Date
The date as of which a conversion rate is used to convert the entered amount into ledger currency. -
PaymentCrossRateType: string
Title:
Payment Cross-Conversion Rate Type
Maximum Length:30
The source of a currency conversion rate used to convert the derived amount into ledger currency, such as user defined, spot, or corporate. -
PaymentCurrencyCode: string
Title:
Payment Currency
Maximum Length:15
The code representing the currency that the payment is made in. -
PaymentFunction: string
Maximum Length:
30
The function or purpose of the payment. -
PaymentMethodCode: string
Title:
Payment Method
Maximum Length:30
The method of payment, such as check, cash, or credit. Use the Manage Payment Methods task to identify valid values. -
PaymentMethodLookupCode: string
Title:
Payment Method
Maximum Length:25
Name of the payment method. Use the Manage Payables Lookups task, lookup type PAYMENT METHOD to identify valid values. -
PaymentPriority: integer
(int32)
The payment priority for a scheduled payment. Valid values are whole numbers from 1 to 99.
-
PaymentReasonCode: string
Title:
Payment Reason
Maximum Length:30
Code that indicates the reason for payment for payment system or bank with additional details for the payment. You can review the valid values using the Manage Payment Codes task. The corresponding Payment Code Type must be Payment Reason. -
PaymentReasonComments: string
Title:
Payment Reason Comments
Maximum Length:240
Reason for the payment. -
PayProcTrxnTypeCode: string
Maximum Length:
30
The code representing the type of payment processing transaction or document. -
PONumber: string
Title:
Purchase Order
Maximum Length:30
Document number used to request a seller to supply a product or service for payment. -
PortOfEntryCode: string
Title:
Customs Location Code
Maximum Length:30
Identifies the location or port through which the invoiced goods entered the country. -
PrepayApplyAmount: number
Title:
Prepayment Application Amount
Amount of prepayment to apply to the invoice. The prepayment amount must be a positive value and can't exceed the unpaid invoice amount or the amount of available prepayments. -
PrepayGlDate: string
(date)
Title:
Prepayment Accounting Date
Accounting date for the prepayment application. -
PrepayLineNumber: integer
Title:
Prepayment Line
The line number of the prepayment line applied to the invoice line. -
PrepayNumber: string
Title:
Prepayment Number
Maximum Length:50
Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice. -
ProductTable: string
Title:
Product Table
Maximum Length:30
Name of the product source table used to generate an invoice. -
Queues: string
Title:
Queue Name
Read Only:true
Maximum Length:255
The queue name assigned to the invoice rejection. -
Reference1: string
Maximum Length:
30
Captures invoice reference information from non-Oracle application. -
Reference2: string
Maximum Length:
30
Captures invoice reference information from non-Oracle application. -
ReferenceKey1: string
Title:
Reference Key 1
Maximum Length:4000
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. -
RemittanceMessage1: string
Title:
Remittance Message 1
Maximum Length:150
The remittance message for use in payment processing. You can provide the information during invoice creation or update it later. -
RemittanceMessage2: string
Title:
Remittance Message 2
Maximum Length:150
The remittance message for use in payment processing. You can provide the information during invoice creation or update it later. -
RemittanceMessage3: string
Title:
Remittance Message 3
Maximum Length:150
The remittance message for use in payment processing. You can provide the information during invoice creation or update it later. -
RemitToAddressName: string
Title:
Remit-to Address Name
Maximum Length:240
The third-party payment related remit-to address where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to address page. -
RemitToSupplierName: string
Title:
Remit-to Supplier
Maximum Length:240
The third-party payment related remit-to supplier where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to supplier page. -
RemitToSupplierNumber: string
Title:
Remit-to Supplier Number
Maximum Length:30
The supplier number of the third party. -
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. -
RoutingAttribute1: string
Maximum Length:
270
Captures additional attributes information that may have been used for routing payables invoice images. -
RoutingAttribute2: string
Maximum Length:
270
Captures additional attributes information that may have been used for routing payables invoice images. -
RoutingAttribute3: string
Maximum Length:
270
Captures additional attributes information that may have been used for routing payables invoice images. -
RoutingAttribute4: string
Maximum Length:
270
Captures additional attributes information that may have been used for routing payables invoice images. -
RoutingAttribute5: string
Maximum Length:
270
Captures additional attributes information that may have been used for routing payables invoice images. -
SettlementPriority: string
Title:
Settlement Priority
Maximum Length:30
The priority with which the financial institution or payment system should settle the payment for a document. A list of accepted values is defined in the lookup type IBY_SETTLEMENT_PRIORITY. You can review and update the valid values using Setup and Maintenance work area and the Manage Standard Lookups task. -
ShipToLocation: string
Maximum Length:
40
The location where the goods and services have been shipped to by the supplier. -
Source: string
Title:
Source
Maximum Length:80
Default Value:INVOICE GATEWAY
The code that indicates the feeder system from which an invoice is created. The valid values are defined in the SOURCE lookup type. You can review the valid values using the Setup and Maintenance work area and the Manage Payables Lookups task. -
Status: string
Maximum Length:
25
Status of the row for the import process. -
SupplierTaxExchangeRate: number
Title:
Supplier Tax Invoice Conversion Rate
The supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices. -
SupplierTaxInvoiceDate: string
(date)
Title:
Supplier Tax Invoice Date
Tax invoice date on the supplier-issued tax invoice. -
SupplierTaxInvoiceNumber: string
Title:
Supplier Tax Invoice Number
Maximum Length:150
The supplier tax invoice number. -
TaxationCountry: string
Title:
Taxation Country
Maximum Length:30
The country where the transaction took place for taxation purposes. Oracle Fusion Tax sets the context of other tax drivers such as the Product Fiscal Classification based on the value of this field. The value can either be provided when creating an invoice or it's populated by default from the setup. -
TaxInvoiceInternalSequence: string
Title:
Internal Sequence Number
Maximum Length:150
The internal sequence number issued by the company for a supplier issued tax invoice. -
TaxInvoiceRecordingDate: string
(date)
Title:
Internal Recording Date
The date when the supplier issued tax invoice was recorded. Provide value for this attribute if the company-specific tax invoice date and number is captured. -
TaxRelatedInvoiceId: integer
(int64)
Title:
Tax Related Invoice
The unique identifier of the related tax invoice. -
TermsDate: string
(date)
Title:
Terms Date
The date used with payment terms to calculate installment along with due date and discount dates. The value can either be provided while creating an invoice or derived based on the Terms Date Basis option from the Supplier Site or from the Manage Invoice Options for the invoicing business unit. -
TermsId: integer
(int64)
Title:
Payment Terms ID
The unique identifier of the payment terms that's used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice. -
TermsName: string
Title:
Payment Terms
Maximum Length:50
The name of the payment terms that's used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit. -
ThirdPartyRegistrationId: integer
(int64)
Title:
Supplier Tax Registration ID
The unique identifier of the third party tax registration number. -
ThirdPartyRegistrationNumber: string
Title:
Supplier Tax Registration Number
Maximum Length:60
The tax registration number of the third party. The value can either be provided while creating an invoice or populated by default from the supplier. -
TransientAccount: string
Title:
Liability Distribution
The account combination to which liability is recorded. Payables uses the liability account combination when accounting entries are created for invoices. The value can either be provided while creating an invoice or populated by default from the Supplier Site Assignment or from the Default Distributions from Manage Common Options for Payables and Procurement options for the invoicing business unit. -
UniqueRemittanceIdentifier: string
Title:
Unique Remittance Identifier
Maximum Length:256
The unique identifier for the remittance. Contains reference information for a payment. -
UriCheckDigit: string
Title:
Unique Remittance Identifier Check Digit
Maximum Length:2
A check digit used to validate the unique identifier of the remittance. -
VendorEmailAddress: string
Maximum Length:
2000
The supplier email address on the invoice. -
VendorId: integer
(int64)
Title:
Supplier ID
The unique identifier of the supplier on the interface invoice. -
VendorName: string
Title:
Supplier
Maximum Length:240
The supplier name on the invoice. The value must be provided while creating the invoice. It can't be updated once the invoice is created. -
VendorNumber: string
Title:
Supplier Number
Maximum Length:30
The unique number assigned to a supplier. -
VendorSiteCode: string
Title:
Supplier Site
Maximum Length:240
The name of the physical location of the supplier from where the goods and services are rendered. The value must be provided during creation action. It can't be updated once the invoice is created. -
VendorSiteId: integer
(int64)
Title:
Supplier Site ID
The unique identifier of the supplier site on the interface invoice. -
VoucherNumber: string
Title:
Voucher Number
Maximum Length:50
The manual voucher number when document sequential numbering isn't used.
Nested Schema : Interface Invoice Lines
Type:
array
Title:
Interface Invoice Lines
The payables interface invoice lines resource is used to manage details about goods and services, which includes freight, and miscellaneous charges that can be allocated to item lines. 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 : Interface Invoice Rejections
Type:
array
Title:
Interface Invoice Rejections
The payables interface invoice rejection resource is used to view the interface invoice 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-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.
Nested Schema : payablesInterfaceInvoices-interfaceInvoiceRejections-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.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Links
- submitImportInvoices
-
You can create invoices from the data in the payables open interface tables using import payables invoices.