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 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. -
Owner: string
Title:
Owner
Read Only:true
Maximum Length:255
The user name of the owner associated with the interface invoice. -
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
- 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: