Get an interface invoice
get
/fscmRestApi/resources/11.13.18.05/payablesInterfaceInvoices/{payablesInterfaceInvoicesUniqID}
Request
Path Parameters
-
payablesInterfaceInvoicesUniqID(required): string
This is the hash key of the attributes which make up the composite key--- InvoiceId and LoadRequestId ---for the Payables Interface Invoices resource and used to uniquely identify an instance of Payables Interface Invoices. The client should not generate the hash key value. Instead, the client should query on the Payables Interface Invoices collection resource with a filter on the primary key values in order to navigate to a specific instance of Payables Interface Invoices.
For example: payablesInterfaceInvoices?q=InvoiceId=<value1>;LoadRequestId=<value2>
Query Parameters
-
dependency: string
This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
Format: <attr1>=<val1>,<attr2>=<value2> -
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
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 -
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
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-item-response
Type:
Show Source
object-
AcctsPayCodeCombinationId: integer
(int64)
Title:
Liability Distribution IDThe 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 AmountMaximum Length:1Default Value:falseIndicates whether the tax amount should be added to the invoice amount. -
AmountApplicableToDiscount: number
Title:
Discountable AmountThe invoice amount that's applicable for discount. -
ApplicationId: integer
(int64)
Title:
Application IDDefault Value:200The unique identifier of the source application. -
ApplyAdvancesFlag: boolean
Maximum Length:
1Indicates whether the advance should be applied to the expense reports and other invoices. -
Attribute1: string
Title:
Attribute 1Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute10: string
Title:
Attribute 10Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute11: string
Title:
Attribute 11Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute12: string
Title:
Attribute 12Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute13: string
Title:
Attribute 13Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute14: string
Title:
Attribute 14Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute15: string
Title:
Attribute 15Maximum Length:1000A segment for the interface invoices descriptive flexfield. -
Attribute2: string
Title:
Attribute 2Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute3: string
Title:
Attribute 3Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute4: string
Title:
Attribute 4Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute5: string
Title:
Attribute 5Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute6: string
Title:
Attribute 6Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute7: string
Title:
Attribute 7Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute8: string
Title:
Attribute 8Maximum Length:150A segment for the interface invoices descriptive flexfield. -
Attribute9: string
Title:
Attribute 9Maximum Length:150A segment for the interface invoices descriptive flexfield. -
AttributeCategory: string
Title:
Context ValueMaximum Length:150Descriptive 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 IDThe unique identifier of the withholding tax group. If the identifier isn't available, use the attribute AwtGroupName. -
AwtGroupName: string
Title:
Withholding Tax GroupMaximum Length:25Name 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 NumberThe 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 BearerMaximum Length:30The 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 DateThe budgetary calendar period date applicable for funds checking. -
CalculateTaxDuringImportFlag: boolean
Title:
Calculate Tax During ImportMaximum Length:1Default Value:trueIndicates whether the tax should be calculated for an invoice during import. -
ControlAmount: number
Title:
Tax Control AmountThe user-enterable value to ensure that the calculated tax will be the same as on the physical document. -
CorrectionPeriod: string
Title:
Correction PeriodMaximum Length:15Correction period for the invoice being corrected. -
CorrectionYear: number
Title:
Correction YearCorrection year for the invoice. For example: 2020. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date when the record was created. -
CustomerRegistrationCode: string
Title:
Customer Registration CodeMaximum Length:30The 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 NumberMaximum Length:30The registration number of the customer. You can review list of valid values using the Manage Suppliers task, Transaction Tax region. -
DeliveryChannelCode: string
Title:
Delivery ChannelMaximum Length:30The code representing the delivery channel entered by an user. This is used as an unique identifier for a delivery channel. -
Description: string
Title:
DescriptionMaximum Length:240A brief description of an invoice. -
DocumentCategoryCode: string
Title:
Document CategoryMaximum Length:30The 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 SubtypeMaximum Length:150The classification that categorizes the document associated with an interface invoice for tax or governmental authority. -
ExchangeDate: string
(date)
Title:
Conversion DateThe 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 RateThe 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 TypeMaximum Length:30The 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 AloneMaximum Length:1Indicates whether the payment to the invoice is paid on a separate payment document. -
ExternalBankAccountIBANNumber: string
Title:
Supplier IBANMaximum Length:50The 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 AccountThe 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:
240The internal document reference number from Accounts Receivables system. -
FirstPartyRegistrationId: integer
(int64)
Title:
First-Party Tax Registration IDThe unique identifier of the first party tax registration. -
FirstPartyRegistrationNumber: string
Title:
First-Party Tax Registration NumberMaximum Length:60The 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 DateThe 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 1Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute10: string
Title:
Global Attribute 10Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute11: string
Title:
Global Attribute 11Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute12: string
Title:
Global Attribute 12Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute13: string
Title:
Global Attribute 13Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute14: string
Title:
Global Attribute 14Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute15: string
Title:
Global Attribute 15Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute16: string
Title:
Global Attribute 16Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute17: string
Title:
Global Attribute 17Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute18: string
Title:
Global Attribute 18Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute19: string
Title:
Global Attribute 19Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute2: string
Title:
Global Attribute 2Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute20: string
Title:
Global Attribute 20Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute3: string
Title:
Global Attribute 3Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute4: string
Title:
Global Attribute 4Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute5: string
Title:
Global Attribute 5Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute6: string
Title:
Global Attribute 6Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute7: string
Title:
Global Attribute 7Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute8: string
Title:
Global Attribute 8Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttribute9: string
Title:
Global Attribute 9Maximum Length:150A segment for the interface invoices global descriptive flexfield. -
GlobalAttributeCategory: string
Title:
Global Attribute CategoryMaximum Length:150The global descriptive flexfield context name for the interface invoice. -
GlobalAttributeDate1: string
(date)
Title:
Global Attribute Date 1A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeDate2: string
(date)
Title:
Global Attribute Date 2A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeDate3: string
(date)
Title:
Global Attribute Date 3A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeDate4: string
(date)
Title:
Global Attribute Date 4A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeDate5: string
(date)
Title:
Global Attribute Date 5A date segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber1: number
Title:
Global Attribute Number 1A number segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber2: number
Title:
Global Attribute Number 2A number segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber3: number
Title:
Global Attribute Number 3A number segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber4: number
Title:
Global Attribute Number 4A number segment for the interface invoices global descriptive flexfield. -
GlobalAttributeNumber5: number
Title:
Global Attribute Number 5A number segment for the interface invoices global descriptive flexfield. -
GoodsReceivedDate: string
(date)
Title:
Goods ReceivedThe 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 SetMaximum Length:80The 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:
50The unique image document number associated with the invoice. -
ImageDocumentUri: string
Title:
URL AttachmentMaximum Length:4000The unique reference number to identify the image with the invoice. -
ImportDocumentDate: string
(date)
Title:
Import Document DateThe date assigned by the user during import of invoice. -
ImportDocumentNumber: string
Title:
Import Document NumberMaximum Length:50The document number assigned by the user. -
ImportRequestId: integer
Title:
Request IDRead Only:trueThe request identifier of the job that created or last updated the row. -
InitBusinessUnitTransient: string
Read Only:
trueThe business unit associated with the invoice. -
InitExceptionCategoryTransient: string
Read Only:
trueCategory of the exception associated with the rejection raised on the invoice. -
InitSourceTransient: string
Read Only:
trueThe 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 LinesThe 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 RejectionsThe 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 AmountThe invoice amount in transaction currency. The value must be provided while creating an invoice. -
InvoiceCurrencyCode: string
Title:
Invoice CurrencyMaximum Length:15The three-letter ISO code associated with a currency used on the invoice. -
InvoiceDate: string
(date)
Title:
Invoice DateThe 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 IDRead Only:trueThe unique identifier of the invoice, is generated while creating the invoice. -
InvoiceIncludesPrepayFlag: boolean
Title:
Invoice Includes PrepaymentMaximum Length:1Indicates 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 NumberMaximum Length:50The unique number of the supplier invoice. -
InvoiceReceivedDate: string
(date)
Title:
Invoice ReceivedThe 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 IdentifierThe unique sequential number assigned to an invoice. -
InvoiceTypeLookupCode: string
Title:
TypeMaximum Length:25Default Value:STANDARDThe 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:
trueThe date when the record was last updated. -
LegalEntityId: integer
(int64)
Title:
Legal Entity IDThe unique identifier of the legal entity on the interface invoice. -
LegalEntityName: string
Title:
Legal Entity NameMaximum Length:240The name of the legal entity. The value can either be provided while creating an invoice or derived by the system. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoadRequestId: integer
(int64)
Title:
Load Process IDRead Only:trueDefault Value:-1The unique identifier of the request associated with the interface load job that created the row. -
NetOfRetainageFlag: boolean
Maximum Length:
1Indicates whether the retainage amount is deducted from the invoice amount. -
NoXrateBaseAmount: number
Title:
No Conversion Rate Accounted AmountInvoice 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 UnitMaximum Length:240The business unit associated with the invoice. -
OrgId: integer
(int64)
Title:
Business UnitThe 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 GroupMaximum Length:25The 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 RateDefault Value:1Conversion 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 DateThe date as of which a conversion rate is used to convert the entered amount into ledger currency. -
PaymentCrossRateType: string
Title:
Payment Cross-Conversion Rate TypeMaximum Length:30The 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 CurrencyMaximum Length:15The code representing the currency that the payment is made in. -
PaymentFunction: string
Maximum Length:
30The function or purpose of the payment. -
PaymentMethodCode: string
Title:
Payment MethodMaximum Length:30The method of payment, such as check, cash, or credit. Use the Manage Payment Methods task to identify valid values. -
PaymentMethodLookupCode: string
Title:
Payment MethodMaximum Length:25Name 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 ReasonMaximum Length:30Code 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 CommentsMaximum Length:240Reason for the payment. -
PayProcTrxnTypeCode: string
Maximum Length:
30The code representing the type of payment processing transaction or document. -
PONumber: string
Title:
Purchase OrderMaximum Length:30Document number used to request a seller to supply a product or service for payment. -
PortOfEntryCode: string
Title:
Customs Location CodeMaximum Length:30Identifies the location or port through which the invoiced goods entered the country. -
PrepayApplyAmount: number
Title:
Prepayment Application AmountAmount 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 DateAccounting date for the prepayment application. -
PrepayLineNumber: integer
Title:
Prepayment LineThe line number of the prepayment line applied to the invoice line. -
PrepayNumber: string
Title:
Prepayment NumberMaximum Length:50Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice. -
ProductTable: string
Title:
Product TableMaximum Length:30Name of the product source table used to generate an invoice. -
Queues: string
Title:
Queue NameRead Only:trueMaximum Length:255The queue name assigned to the invoice rejection. -
Reference1: string
Maximum Length:
30Captures invoice reference information from non-Oracle application. -
Reference2: string
Maximum Length:
30Captures invoice reference information from non-Oracle application. -
ReferenceKey1: string
Title:
Reference Key 1Maximum Length:4000The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey2: string
Title:
Reference Key 2Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey3: string
Title:
Reference Key 3Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey4: string
Title:
Reference Key 4Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey5: string
Title:
Reference Key 5Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
RemittanceMessage1: string
Title:
Remittance Message 1Maximum Length:150The remittance message for use in payment processing. You can provide the information during invoice creation or update it later. -
RemittanceMessage2: string
Title:
Remittance Message 2Maximum Length:150The remittance message for use in payment processing. You can provide the information during invoice creation or update it later. -
RemittanceMessage3: string
Title:
Remittance Message 3Maximum Length:150The 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 NameMaximum Length:240The 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 SupplierMaximum Length:240The 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 NumberMaximum Length:30The supplier number of the third party. -
RequesterEmailAddress: string
Title:
Requester Email AddressMaximum Length:240The email address of the employee for the requested items. -
RequesterEmployeeNumber: string
Title:
Requester Employee NumberMaximum Length:30The employee's unique identifier who made the request for the products or services. -
RequesterFirstName: string
Title:
Requester First NameMaximum Length:150The first name of the person who made the request for the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers. -
RequesterId: integer
(int64)
Title:
Requester IDThe unique identifier of the requester. -
RequesterLastName: string
Title:
Requester Last NameMaximum Length:150The last name of the person who made the request for the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers. -
RoutingAttribute1: string
Maximum Length:
270Captures additional attributes information that may have been used for routing payables invoice images. -
RoutingAttribute2: string
Maximum Length:
270Captures additional attributes information that may have been used for routing payables invoice images. -
RoutingAttribute3: string
Maximum Length:
270Captures additional attributes information that may have been used for routing payables invoice images. -
RoutingAttribute4: string
Maximum Length:
270Captures additional attributes information that may have been used for routing payables invoice images. -
RoutingAttribute5: string
Maximum Length:
270Captures additional attributes information that may have been used for routing payables invoice images. -
SettlementPriority: string
Title:
Settlement PriorityMaximum Length:30The 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:
40The location where the goods and services have been shipped to by the supplier. -
Source: string
Title:
SourceMaximum Length:80Default Value:INVOICE GATEWAYThe 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:
25Status of the row for the import process. -
SupplierTaxExchangeRate: number
Title:
Supplier Tax Invoice Conversion RateThe supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices. -
SupplierTaxInvoiceDate: string
(date)
Title:
Supplier Tax Invoice DateTax invoice date on the supplier-issued tax invoice. -
SupplierTaxInvoiceNumber: string
Title:
Supplier Tax Invoice NumberMaximum Length:150The supplier tax invoice number. -
TaxationCountry: string
Title:
Taxation CountryMaximum Length:30The 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 NumberMaximum Length:150The internal sequence number issued by the company for a supplier issued tax invoice. -
TaxInvoiceRecordingDate: string
(date)
Title:
Internal Recording DateThe 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 InvoiceThe unique identifier of the related tax invoice. -
TermsDate: string
(date)
Title:
Terms DateThe 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 IDThe 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 TermsMaximum Length:50The 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 IDThe unique identifier of the third party tax registration number. -
ThirdPartyRegistrationNumber: string
Title:
Supplier Tax Registration NumberMaximum Length:60The 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 DistributionThe 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 IdentifierMaximum Length:256The unique identifier for the remittance. Contains reference information for a payment. -
UriCheckDigit: string
Title:
Unique Remittance Identifier Check DigitMaximum Length:2A check digit used to validate the unique identifier of the remittance. -
VendorEmailAddress: string
Maximum Length:
2000The supplier email address on the invoice. -
VendorId: integer
(int64)
Title:
Supplier IDThe unique identifier of the supplier on the interface invoice. -
VendorName: string
Title:
SupplierMaximum Length:240The 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 NumberMaximum Length:30The unique number assigned to a supplier. -
VendorSiteCode: string
Title:
Supplier SiteMaximum Length:240The 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 IDThe unique identifier of the supplier site on the interface invoice. -
VoucherNumber: string
Title:
Voucher NumberMaximum Length:50The manual voucher number when document sequential numbering isn't used.
Nested Schema : Interface Invoice Lines
Type:
arrayTitle:
Interface Invoice LinesThe 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:
arrayTitle:
Interface Invoice RejectionsThe 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:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : payablesInterfaceInvoices-interfaceInvoiceLines-item-response
Type:
Show Source
object-
AccountingDate: string
(date)
Title:
Accounting DateThe accounting date of an invoice line. It's defaulted to the invoice distributions. The value can either be provided while creating an invoice installment or populated by default from the invoice header. -
AccountSegment: string
Title:
Overlay Account SegmentMaximum Length:25Overrides account segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield. -
Amount: number
Title:
AmountThe line amount in invoice currency. The value must be provided while creating an invoice line. -
ApplicationId: integer
(int64)
Title:
Application IDThe unique identifier of the application on the interface invoice. -
AssessableValue: number
Title:
Assessable ValueThe deemed price at which a product is valued by a tax authority for tax calculation purposes. -
AssetBookTypeCode: string
Title:
BookMaximum Length:30The asset book associated with the row. The value is populated by default to the distributions candidate for transfer to Oracle Fusion Assets. -
AssetCategoryId: integer
(int64)
Title:
Asset CategoryThe unique identifier of the asset category under which the asset line will be grouped. The value is populated by default to the invoice distributions for transferring to Oracle Assets. -
AssetsTrackingFlag: boolean
Title:
Track as AssetMaximum Length:1Indicates whether the item should be transferred to Oracle Assets. The value can either be provided while creating an invoice line or populated by default to true if an asset account is provided in the distribution combination. If the value if true, then it indicates the item should be transferred to Oracle Assets. -
Attribute1: string
Title:
Attribute 1Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute10: string
Title:
Attribute 10Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute11: string
Title:
Attribute 11Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute12: string
Title:
Attribute 12Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute13: string
Title:
Attribute 13Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute14: string
Title:
Attribute 14Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute15: string
Title:
Attribute 15Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute2: string
Title:
Attribute 2Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute3: string
Title:
Attribute 3Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute4: string
Title:
Attribute 4Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute5: string
Title:
Attribute 5Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute6: string
Title:
Attribute 6Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute7: string
Title:
Attribute 7Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute8: string
Title:
Attribute 8Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
Attribute9: string
Title:
Attribute 9Maximum Length:150A segment for the interface invoice lines descriptive flexfield. -
AttributeCategory: string
Title:
Context ValueMaximum Length:150The descriptive flexfield context name for the interface invoice line. -
AwardId: integer
(int64)
The unique identifier of the awards configured in Oracle Projects.
-
AwtGroupId: integer
(int64)
Title:
Withholding Tax Group IDThe unique identifier of the withholding tax group. -
AwtGroupName: string
Title:
Withholding Tax GroupMaximum Length:25The name of the withholding tax group. The value can either be provided while creating an invoice line or populated by default from the Withholding from Site Assignments in the Supplier Site or Address or Profile level. -
BalancingSegment: string
Title:
Overlay Primary Balancing SegmentMaximum Length:25Overrides balancing segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield. -
BudgetDate: string
(date)
Title:
Budget DateThe budgetary calendar period date applicable for funds check. -
ConsumptionAdviceHeaderId: integer
(int64)
Title:
Consumption AdviceThe unique identifier of the consignment advice associated with the invoice line. -
ConsumptionAdviceLineId: integer
(int64)
Title:
Consumption Advice Line NumberThe unique identifier of the line number of the consignment advice associated with the invoice line. -
ConsumptionAdviceLineNumber: integer
Title:
Consumption Advice Line NumberThe line number of the consignment advice associated with the invoice line. -
ConsumptionAdviceNumber: string
Title:
Consumption AdviceMaximum Length:20The number of the consignment advice associated with the invoice line. -
ControlAmount: number
Title:
Tax Control AmountThe user-enterable value to ensure that the calculated tax will be the same as on the physical document. -
CostCenterSegment: string
Title:
Overlay Cost Center SegmentMaximum Length:25Overrides cost center segment of the default expense account combination for the invoice line. Must be a valid value for the accounting flexfield. -
CostFactorId: integer
(int64)
The identifier of the component that make up to the total cost of an item. For example, direct material costs and freight costs. If the identifier isn't available, use the COST_FACTOR_NAME column.
-
CreationDate: string
(date-time)
Read Only:
trueThe date when the record was created. -
CreditCardTrxId: integer
(int64)
The unique identifier of the credit card transaction associated to an item line of a Payment request from Expenses.
-
DefAcctgAccrualCcid: integer
Title:
Multiperiod Accounting Accrual AccountThe accrual account that's initially debited for deferred expenses. -
DefAcctgEndDate: string
(date)
Title:
Multiperiod Accounting End DateThe multiperiod accounting end date on the invoice line. -
DefAcctgStartDate: string
(date)
Title:
Multiperiod Accounting Start DateThe multiperiod accounting start date on the invoice line. -
DefaultDistCcid: integer
(int64)
Title:
Default Distribution Combination IDThe accounting flexfield used for automatic generation of a single distribution. The value can be provided while creating an invoice line. In case of Prepayment invoice or charge lines the value is populated by default from the Supplier Site Assignment or from Manage Common Options for Payables and Procurement options for the invoicing business unit. -
Description: string
Title:
DescriptionMaximum Length:240A brief description of the invoice line. The value can either be provided while creating an invoice line or populated by default from the invoice header. -
DistCodeCombinationId: integer
(int64)
Title:
Distribution Combination IDThe code combination identifier of the GL account associated with the transaction line. -
DistCodeConcatenated: string
Title:
Overlay Distribution CombinationMaximum Length:250Accounting flexfield value for a distribution line. Use the valid segment separator from the accounting key flexfield definition. -
DistributionSetId: integer
(int64)
Title:
Distribution Set IDThe unique identifier of the distribution set. If the identifier isn't available, use the DistributionSetName. -
DistributionSetName: string
Title:
Distribution SetMaximum Length:50The name of the distribution set. You can review the valid values using the Manage Distribution Sets task. -
ExpenditureItemDate: string
(date)
The expenditure date for expenses related to project.
-
ExpenditureOrganizationId: integer
(int64)
The name of the project organization.
-
ExpenditureType: string
Maximum Length:
30The type of project expense. -
ExternalDocumentLineReference: string
Maximum Length:
240Internal document reference number from Accounts Receivables system. -
FinalDischargeLocationCode: string
Title:
Location of Final DischargeMaximum Length:60The code that identifies the location of final discharge. -
FinalDischargeLocationId: integer
(int64)
Title:
Location of Final Discharge IDThe unique identifier of the final discharge location. -
FinalMatchFlag: boolean
Title:
Final MatchMaximum Length:1Indicates if an invoice is the last one being matched to a purchase order, making the purchase order schedule no longer available for matching to other invoices. A value of Y indicates the purchase order schedule is finally closed and can no longer match invoices to it. -
FiscalChargeType: string
Title:
Fiscal Charge TypeMaximum Length:30The subclassification of invoice line type. For example, Freight or Miscellaneous. Valid values are defined in lookup ZX_CHARGE_TYPE. -
GlobalAttribute1: string
Title:
Global Attribute 1Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute10: string
Title:
Global Attribute 10Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute11: string
Title:
Global Attribute 11Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute12: string
Title:
Global Attribute 12Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute13: string
Title:
Global Attribute 13Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute14: string
Title:
Global Attribute 14Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute15: string
Title:
Global Attribute 15Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute16: string
Title:
Global Attribute 16Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute17: string
Title:
Global Attribute 17Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute18: string
Title:
Global Attribute 18Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute19: string
Title:
Global Attribute 19Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute2: string
Title:
Global Attribute 2Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute20: string
Title:
Global Attribute 20Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute3: string
Title:
Global Attribute 3Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute4: string
Title:
Global Attribute 4Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute5: string
Title:
Global Attribute 5Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute6: string
Title:
Global Attribute 6Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute7: string
Title:
Global Attribute 7Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute8: string
Title:
Global Attribute 8Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttribute9: string
Title:
Global Attribute 9Maximum Length:150A segment for the interface invoice lines global descriptive flexfield. -
GlobalAttributeCategory: string
Title:
Global Attribute CategoryMaximum Length:150The global descriptive flexfield context name for the interface invoice line. -
InclInTaxableLineFlag: boolean
Title:
Included in Taxable Line IndicatorMaximum Length:1Indicates whether the amount in the tax line is included in the taxable line. -
IncomeTaxRegion: string
Title:
Income Tax RegionMaximum Length:10The reporting region of the invoice line for 1099 suppliers. The value can either be provided while creating an invoice line or populated by default to the State code from the address associated with supplier site. -
interfaceInvoiceLineRejections: array
Interface Invoice Line Rejections
Title:
Interface Invoice Line RejectionsThe payables interface invoice line rejections resource is used to view the interface invoice line attributes rejections. Note that the service endpoints in this resource are specifically designed to only work with the visual builder add-in for Excel. -
InventoryItemId: integer
Title:
Item IDThe unique identifier of the inventory item. -
InvoiceId: integer
(int64)
Title:
Invoice IDRead Only:trueThe unique identifier of the interface invoice. -
InvoiceLineId: integer
(int64)
Title:
Invoice Line IDRead Only:trueThe unique identifier of the interface invoice line. -
ItemDescription: string
Title:
Item DescriptionMaximum Length:240A description of the item in the invoice line. The default value is populated from the inventory item. -
LastUpdateDate: string
(date-time)
Read Only:
trueThe date when the record was last updated. -
LcmEnabledFlag: boolean
Title:
Landed Cost EnabledMaximum Length:1Indicates if the invoice line is enabled for landed cost. -
LineGroupNumber: integer
Title:
Line Group NumberThe number of the Line group. Used to prorate charges across a group of lines. Must be a positive integer. -
LineNumber: integer
(int64)
Title:
LineThe unique number for the invoice line. The value must be provided while creating an invoice line. It can't be updated once the invoice line is created. -
LineTypeLookupCode: string
Title:
Line TypeMaximum Length:25The type of the invoice line. The value must be provided while creating an invoice line. The valid values are Item, Freight, and Miscellaneous. A list of accepted values is defined in the lookup type INVOICE LINE TYPE and can be reviewed using the Setup and Maintenance work area, and the Manage Payables Lookups task. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoadRequestId: integer
(int64)
Title:
Load Process IDRead Only:trueThe unique identifier of the interface load job request that created the row. -
Manufacturer: string
Title:
ManufacturerMaximum Length:30Name of the manufacturer of an asset or item. This is a free text field. -
MatchOption: string
Title:
Match OptionMaximum Length:25Indicates whether the invoice for the shipment should be matched to the purchase order or the receipt. -
ModelNumber: string
Title:
ModelMaximum Length:40The model number of the invoice line item. -
OrgId: integer
(int64)
Title:
Business UnitThe unique identifier of the invoice business unit name. -
PaAdditionFlag: boolean
Maximum Length:
1Default Value:falseIndicates whether project related invoice distributions have been transferred to Oracle Projects. -
PaCcArInvoiceId: integer
(int64)
The unique identifier of the invoice for Projects intercompany invoice.
-
PaCcArInvoiceLineNumber: integer
(int64)
The invoice line number of the Projects intercompany invoice.
-
PaCcProcessedCode: string
Maximum Length:
1The processing status of an invoice line by Oracle Projects in the receiver business unit. -
PackingSlip: string
Maximum Length:
25The packing slip associated with the invoice line. -
PaQuantity: number
The project item quantity used to build accounting flexfield for project-related distribution line.
-
PJC_RESERVED_ATTRIBUTE1: string
Title:
Project Reserved Attribute 1Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE10: string
Title:
Project Reserved Attribute 10Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE2: string
Title:
Project Reserved Attribute 2Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE3: string
Title:
Project Reserved Attribute 3Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE4: string
Title:
Project Reserved Attribute 4Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE5: string
Title:
Project Reserved Attribute 5Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE6: string
Title:
Project Reserved Attribute 6Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE7: string
Title:
Project Reserved Attribute 7Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE8: string
Title:
Project Reserved Attribute 8Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_RESERVED_ATTRIBUTE9: string
Title:
Project Reserved Attribute 9Maximum Length:150Reserved for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE1: string
Title:
Project User-Defined Attribute 1Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE10: string
Title:
Project User-Defined Attribute 10Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE2: string
Title:
Project User-Defined Attribute 2Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE3: string
Title:
Project User-Defined Attribute 3Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE4: string
Title:
Project User-Defined Attribute 4Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE5: string
Title:
Project User-Defined Attribute 5Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE6: string
Title:
Project User-Defined Attribute 6Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE7: string
Title:
Project User-Defined Attribute 7Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE8: string
Title:
Project User-Defined Attribute 8Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PJC_USER_DEF_ATTRIBUTE9: string
Title:
Project User-Defined Attribute 9Maximum Length:150User defined segment for Projects standard cost collection flexfield. -
PjcBillableFlag: boolean
Title:
BillableMaximum Length:1Indicates whether the project related item is available for customer billing -
PjcCapitalizableFlag: boolean
Title:
CapitalizableMaximum Length:1Indicates whether the project related item is eligible for capitalization. -
PjcContextCategory: string
Title:
Project Context CategoryMaximum Length:40Default Value:AP_Invoice_LineIdentifies descriptive flexfield application context for project-related standardized code collection. -
PjcContractId: number
Title:
Project Contract IDThe identifier of the contract that's used while installing Oracle Project Billing or Oracle Project Billing or Oracle Grants Accounting. -
PjcContractLineId: number
Title:
Project Contract Line IDThe identifier of the contract line. -
PjcContractName: string
Title:
Contract NameMaximum Length:300The name of the contract used in Oracle Contract Billing or Oracle Grants Accounting. -
PjcContractNumber: string
Title:
Contract NumberMaximum Length:120The number of the Contract used in Oracle Contract Billing or Oracle Grants Accounting. -
PjcExpenditureItemDate: string
(date)
Title:
Project Expenditure Item DateDate on which project-related transaction occurred. -
PjcExpenditureTypeId: number
Title:
Project Expenditure Type IDIdentifies descriptive flexfield application context for project-related standardized code collection. -
PjcExpenditureTypeName: string
Title:
Expenditure TypeMaximum Length:240A classification of cost that's assigned to each expenditure item. -
PjcFundingAllocationId: number
Title:
Project Funding Allocation IDName of the project funding override. -
PjcFundingSourceName: string
Title:
Funding Source NameMaximum Length:360Name of the source funding the project. -
PjcFundingSourceNumber: string
Title:
Funding Source NumberMaximum Length:50Number of the source funding the project. -
PjcOrganizationId: number
Title:
Expenditure Organization IDThe identifier of the organization to build transaction descriptive flexfield for project-related transaction distributions. -
PjcOrganizationName: string
Title:
Expenditure OrganizationMaximum Length:240The name of the organization to which the project is assigned. -
PjcProjectId: number
Title:
Project IDIdentifies descriptive flexfield application context for project-related standardized code collection. -
PjcProjectName: string
Title:
Project NameMaximum Length:240The name of the project to which the invoice expense is charged. -
PjcProjectNumber: string
Title:
Project NumberMaximum Length:25The number of the project to which the invoice expense is charged. -
PjcTaskId: number
Title:
Task IDIdentifies descriptive flexfield application context for project-related standardized code collection. -
PjcTaskName: string
Title:
Task NameMaximum Length:255The name of the task used to build the transaction descriptive flexfield for project-related transaction distributions. -
PjcTaskNumber: string
Title:
Task NumberMaximum Length:100A subdivision of project work. Task Number uniquely identifies the element within a project or structure. -
PjcWorkType: string
Title:
Work TypeMaximum Length:240Classification of project-related work performed. -
PjcWorkTypeId: number
Title:
Project Work Type IDThe identifier of the project-related classification. -
PODistributionId: integer
Title:
Purchase Order Distribution IDThe unique identifier of the purchase order distribution line number that's matched to the invoice distribution. -
PODistributionNumber: integer
Title:
Purchase Order Distribution NumberThe purchase order distribution line number that's matched to the invoice distribution. -
POHeaderId: integer
Title:
Purchase Order Header IDThe unique identifier of the purchase order document number that's matched to the invoice. -
POLineId: integer
Title:
Purchase Order Line IDThe unique identifier of the purchase order line number that's matched to the invoice line. -
POLineLocationId: integer
Title:
Purchase Order Line Location IDThe unique identifier of the purchase order schedule line number that's matched to the invoice line. -
POLineNumber: number
Title:
Purchase Order Line NumberThe purchase order line number that's matched to the invoice line. -
PONumber: string
Title:
Purchase OrderMaximum Length:30The purchase order document number that's matched to the invoice. -
POReleaseId: integer
The unique identifier of the blanket purchase order release for purchase order matching.
-
POShipmentNumber: number
Title:
Purchase Order ScheduleThe purchase order schedule line number that's matched to the invoice line. -
PriceCorrectInvLineNumber: integer
Title:
Price Correction Invoice LineThe number of the invoice line that price correction invoice is updating. -
PriceCorrectInvNumber: string
Title:
Price Correction InvoiceMaximum Length:50The number of the invoice that price correction invoice is updating. -
PriceCorrectionFlag: boolean
Title:
Price Correction IndicatorMaximum Length:1Indicates if a line creates a price correction. -
PrimaryIntendedUse: string
Title:
Intended UseMaximum Length:30A tax driver used to determine and calculate the applicable taxes for the line. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup. -
ProductCategory: string
Title:
Product CategoryMaximum Length:240Identifies the taxable nature of a non-Inventory based item to determine tax or tax reporting purposes. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup. -
ProductFiscClassification: string
Title:
Product Fiscal ClassificationMaximum Length:240The user-entered product fiscal classification that helps to uniquely identify a product fiscal classification. -
ProductTable: string
Title:
Product TableMaximum Length:30The name of the product source table used to generate the invoice. -
ProductType: string
Title:
Product TypeMaximum Length:240The product type of the product item. Valid values are Goods and Services. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup. -
ProjectId: integer
(int64)
The unique identifier of the project referenced on the invoice line.
-
ProrateAcrossFlag: boolean
Title:
Prorate Across All Item LinesMaximum Length:1Indicates whether the Freight or Miscellaneous type line should be prorated across all existing Item type lines. The default value is false. If the value if true, then it indicates the charge line should be prorated across all item type lines. -
PurchasingCategory: string
Title:
Purchasing CategoryMaximum Length:2000The item category referenced on the invoice line. -
PurchasingCategoryId: integer
(int64)
Title:
Purchasing Category IDThe unique identifier for the item category. -
QuantityInvoiced: number
Title:
Invoiced QuantityThe quantity that was invoiced. -
Queues: string
Title:
Queue NameMaximum Length:255Queue name assigned to the invoice line rejection. -
RcvShipmentHeaderId: integer
The receipt shipment number used for receipt matching.
-
RcvTransactionId: integer
The receipt identifier used for receipt matching.
-
ReceiptLineNumber: string
Title:
Receipt LineMaximum Length:25The line number of the receipt associated with the invoice line. -
ReceiptNumber: string
Title:
ReceiptMaximum Length:30The receipt number of the material associated with the invoice line. -
Reference1: string
Maximum Length:
30Reference information from a non-Oracle application. This is a free text field. -
Reference2: string
Maximum Length:
30Reference information from a non-Oracle application. This is a free text field. -
ReferenceKey1: string
Title:
Reference Key 1Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey2: string
Title:
Reference Key 2Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey3: string
Title:
Reference Key 3Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey4: string
Title:
Reference Key 4Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReferenceKey5: string
Title:
Reference Key 5Maximum Length:150The primary key information that uniquely identifies the record in another product's view. -
ReleaseNumber: integer
The release number of the blanket purchase order for matching.
-
RequesterEmailAddress: string
Title:
Requester Email AddressMaximum Length:240The email address of the employee for the requested items. -
RequesterEmployeeNumber: string
Title:
Requester Employee NumberMaximum Length:30The employee's unique identifier who made the request for the products or services. -
RequesterFirstName: string
Title:
Requester First NameMaximum Length:150The first name of the person who made the request for the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers. -
RequesterId: integer
(int64)
Title:
Requester IDThe unique identifier of the requester. -
RequesterLastName: string
Title:
Requester Last NameMaximum Length:150The last name of the person who made the request for the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers. -
SerialNumber: string
Title:
Serial NumberMaximum Length:35The serial number for an item. -
ShipFromLocationCode: string
Title:
Ship-from LocationMaximum Length:60The code that identifies the ship-from location. -
ShipFromLocationId: integer
(int64)
Title:
Ship-from Location IDThe unique identifier of the ship-from location. -
ShipToLocationCode: string
Title:
Ship-to LocationMaximum Length:60The user-entered ship to location code that helps to uniquely identify a ship to location. -
ShipToLocationId: integer
(int64)
Title:
Ship-to Location IDThe unique identifier of the ship to location code that helps to uniquely identify a ship to location. -
SourceApplicationId: integer
The unique identifier of the source document application.
-
SourceEntityCode: string
Maximum Length:
30The entity code of the source document. -
SourceEventClassCode: string
Maximum Length:
30The event class code of the source document. -
SourceLineId: integer
The identifier of the lowest level for tax calculation.
-
SourceTrxId: integer
The identifier of the source document transaction.
-
SourceTrxLevelType: string
Maximum Length:
30The type of the source document transaction level. -
StatAmount: number
Title:
Statistical QuantityThe amount associated with a distribution line for measuring statistical quantities. -
TaskId: integer
(int64)
The unique identifier of the project task.
-
Tax: string
Title:
Tax NameMaximum Length:30The classification name of the charge imposed by a government through a fiscal or tax authority. -
TaxableFlag: boolean
Title:
Taxable IndicatorMaximum Length:1Indicates whether a line is taxable. -
TaxClassificationCode: string
Title:
Tax ClassificationMaximum Length:30The tax classification code used for tax calculation. The value can either be provided while creating an invoice line or populated by default from the Tax Classification Code from the Transaction Tax tab in the Supplier Profile or Address or as per the Tax setups. -
TaxCode: string
Maximum Length:
15The unique code of the tax charge imposed by a government through a fiscal or tax authority. -
TaxCodeId: integer
(int64)
The unique identifier of the tax charge imposed by a government through a fiscal or tax authority.
-
TaxJurisdictionCode: string
Title:
Tax Jurisdiction CodeMaximum Length:30The code of the tax jurisdiction associated with the tax rate on the invoice line. -
TaxRate: number
Title:
Tax RateThe rate specified for a tax rate. -
TaxRateCode: string
Title:
Tax Rate CodeMaximum Length:150The tax rate code associated with the tax rate identifier. -
TaxRateId: integer
(int64)
Title:
Tax Rate IDThe internal identifier of the tax rate that's effective on the invoice date. -
TaxRegimeCode: string
Title:
Tax Regime CodeMaximum Length:30The name of the set of tax rules that determines the treatment of one or more taxes administered by a tax authority. -
TaxStatusCode: string
Title:
Tax Status CodeMaximum Length:30The code that represent the tax status. -
TransientAccount: string
Title:
Distribution CombinationThe accounting flexfield used for automatic generation of a single distribution. The value can be provided while creating an invoice line. In case of Prepayment invoice or charge lines the value is populated by default from the Supplier Site Assignment or from Manage Common Options for Payables and Procurement options for the invoicing business unit. -
TransientAccrualAccount: string
Title:
Multiperiod Accounting Accrual AccountThe accrual account used in multiperiod accounting to accrue deferred expenses. -
TransientProjectDFF: string
Title:
Project InformationAdditional information for project standard cost collection flexfield. -
TrxBusinessCategory: string
Title:
Transaction Business CategoryMaximum Length:240The transaction category assigned to the invoice line. Used to identify and classify business transactions for the purpose of tax calculation. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup. -
Type1099: string
Title:
Income Tax TypeMaximum Length:10The payments of type 1099 made to a supplier. A 1099 supplier may receive payments of more than one type. The value can either be provided while creating an invoice line or populated by default from the Federal Income Tax Type from the Income Tax tab from Supplier Profile. -
UnitOfMeasLookupCode: string
Title:
UOMMaximum Length:25The unit of measure for the quantity invoiced. -
UnitPrice: number
Title:
Unit PriceThe price charged per unit of a good or service. -
UserDefinedFiscClass: string
Title:
User-Defined Fiscal ClassificationMaximum Length:240A classification for any tax requirement that you can't define using the existing fiscal classification types. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup. -
VendorItemNumber: string
Title:
Supplier Item NumberMaximum Length:300The number that identifies the supplier's item. -
WarrantyNumber: string
Maximum Length:
15The warranty number of the item on the invoice line.
Nested Schema : Interface Invoice Line Rejections
Type:
arrayTitle:
Interface Invoice Line RejectionsThe payables interface invoice line rejections resource is used to view the interface invoice line attributes rejections. Note that the service endpoints in this resource are specifically designed to only work with the visual builder add-in for Excel.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : payablesInterfaceInvoices-interfaceInvoiceLines-interfaceInvoiceLineRejections-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RejectionDescription: string
Read Only:
trueMaximum Length:255The reason for rejection of the interface invoice line.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : payablesInterfaceInvoices-interfaceInvoiceRejections-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RejectionDescription: string
Read Only:
trueMaximum Length:255The reason for rejection of the interface invoice.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Links
- interfaceInvoiceLines
-
Parameters:
- payablesInterfaceInvoicesUniqID:
$request.path.payablesInterfaceInvoicesUniqID
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. - payablesInterfaceInvoicesUniqID:
- interfaceInvoiceRejections
-
Parameters:
- payablesInterfaceInvoicesUniqID:
$request.path.payablesInterfaceInvoicesUniqID
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. - payablesInterfaceInvoicesUniqID:
- interfaceRejections
-
Parameters:
- payablesInterfaceInvoicesUniqID:
$request.path.payablesInterfaceInvoicesUniqID
Returns a list of all rejections for an interface invoice as a single attribute value. - payablesInterfaceInvoicesUniqID: