JDBC Driver for SAP Concur

Build 23.0.8839

Invoice

Gets all relevant information (Payment Request Header, Payment Request Line Item and Payment Request Allocation) of a Payment Request.

Table Specific Information

Select

The ID Column is required in the WHERE clause in order to access this view. For example:

SELECT * FROM Invoice WHERE Id = 'sampleInvoiceId'

Columns

Name Type References Description
AmountWithoutVat String The net amount of the invoice, excluding VAT.
ApprovalStatus String A code which indicates the approval status of the payment request.
ApprovedByDelegate String Was the Payment Request approved by a delegate. Format: true/false.
AssignedByUsername String Username of the assigning employee.
AssignedDate String The date the payment request was assigned to the current owner.
BuyerCostCenter String The company defined center responsible for the payment request.
CalculatedAmount String The sum of all line item amounts plus shipping amount and tax amount for the payment request.
CheckNumber String Check number of the payment made to the vendor.
CompanyBillToAddress String The company billing address.
CompanyShipToAddress String The company shipping address.
CountryCode String The country code.
CreatedByUsername String Username of the payment request creator.
CurrencyCode String The 3-letter ISO 4217 currency code for the expense report currency. Examples: USD - US dollars; BRL - Brazilian real;, etc.
Custom1 String The details from the Custom fields. These may not have data, depending on configuration.
Custom10 String The details from the Custom fields. These may not have data, depending on configuration.
Custom11 String The details from the Custom fields. These may not have data, depending on configuration.
Custom12 String The details from the Custom fields. These may not have data, depending on configuration.
Custom13 String The details from the Custom fields. These may not have data, depending on configuration.
Custom14 String The details from the Custom fields. These may not have data, depending on configuration.
Custom15 String The details from the Custom fields. These may not have data, depending on configuration.
Custom16 String The details from the Custom fields. These may not have data, depending on configuration.
Custom17 String The details from the Custom fields. These may not have data, depending on configuration.
Custom18 String The details from the Custom fields. These may not have data, depending on configuration.
Custom19 String The details from the Custom fields. These may not have data, depending on configuration.
Custom2 String The details from the Custom fields. These may not have data, depending on configuration.
Custom20 String The details from the Custom fields. These may not have data, depending on configuration.
Custom21 String The details from the Custom fields. These may not have data, depending on configuration.
Custom22 String The details from the Custom fields. These may not have data, depending on configuration.
Custom23 String The details from the Custom fields. These may not have data, depending on configuration.
Custom24 String The details from the Custom fields. These may not have data, depending on configuration.
Custom3 String The details from the Custom fields. These may not have data, depending on configuration.
Custom4 String The details from the Custom fields. These may not have data, depending on configuration.
Custom5 String The details from the Custom fields. These may not have data, depending on configuration.
Custom6 String The details from the Custom fields. These may not have data, depending on configuration.
Custom7 String The details from the Custom fields. These may not have data, depending on configuration.
Custom8 String The details from the Custom fields. These may not have data, depending on configuration.
Custom9 String The details from the Custom fields. These may not have data, depending on configuration.
DataSource String A code which indicates the method used to created the Payment Request. Use
DeletedDate String The date the user deleted the payment request.
DeliverySlipNumber String The delivery slip number associated with receiving receipt.
Description String User entered description of the Payment Request.
DiscountPercentage String The discount from the supplier if the discount terms are met.
DiscountTerms String The NET discount terms with a supplier when discounts apply.
EmployeeName String The owner of the Payment Request.
ExternalPolicyId String The external policy ID.
ExtractDate String The date the payment request was extracted, in order to import it into an accounts payable system and generate a payment.
FirstApprovalDate String The date the payment request received its first approval in its approval workflow.
FirstSubmitDate String The date the payment request was first submitted.
ID String The unique identifier of the resource.
InvoiceAmount String User-entered value representing the total invoice amount, used to calculate amount remaining on the line item page.
InvoiceDate String The date the vendor issued the invoice.
InvoiceNumber String The invoice Number from the vendor for the payment request.
InvoiceReceivedDate String The date on which the invoice was received.
IsAssigned String Whether the payment request is assigned. Format: true/false.
IsInvoiceConfirmed String Indicates if the payment request invoice is confirmed or in a different status. Format: true/false.
IsPaymentRequestDeleted String Whether the payment request is deleted. Format: true/false.
IsPaymentRequestDuplicate String Whether the payment request identified as a duplicate of another existing request. Format:true/false.
IsTestTransaction String Is the payment request a test transaction (true/false).
LastSubmitDate String The date the payment request was last submitted.
LedgerCode String A code which indicates which company journal the payment request is assigned to. Use
LineItemsAggr String Aggregate information of line items

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839