Power BI Connector for SAP Concur

Build 24.0.9060

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 ReadOnly Description
AmountWithoutVat String False

The net amount of the invoice, excluding VAT.

Name String False

The Invoice name.

ApprovalStatus String False

A code which indicates the approval status of the payment request.

ApprovedByDelegate String False

Was the Payment Request approved by a delegate. Format: true/false.

AssignedByUsername String False

Username of the assigning employee.

AssignedDate String False

The date the payment request was assigned to the current owner.

BuyerCostCenter String False

The company defined center responsible for the payment request.

CalculatedAmount String False

The sum of all line item amounts plus shipping amount and tax amount for the payment request.

CheckNumber String False

Check number of the payment made to the vendor.

CompanyBillToAddress String False

CompanyShipToAddress String False

CountryCode String False

The country code.

CreatedByUsername String False

Username of the payment request creator.

CurrencyCode String False

The 3-letter ISO 4217 currency code for the expense report currency. Examples: USD - US dollars; BRL - Brazilian real;, etc.

Custom1 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom10 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom11 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom12 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom13 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom14 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom15 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom16 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom17 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom18 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom19 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom2 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom20 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom21 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom22 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom23 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom24 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom3 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom4 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom5 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom6 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom7 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom8 String False

The details from the Custom fields. These may not have data, depending on configuration.

Custom9 String False

The details from the Custom fields. These may not have data, depending on configuration.

DataSource String False

A code which indicates the method used to created the Payment Request. Use

DeletedDate String False

The date the user deleted the payment request.

DeliverySlipNumber String False

The delivery slip number associated with receiving receipt.

Description String False

User entered description of the Payment Request.

DiscountPercentage String False

The discount from the supplier if the discount terms are met.

DiscountTerms String False

The NET discount terms with a supplier when discounts apply.

EmployeeName String False

The owner of the Payment Request.

ExternalPolicyId String False

The external policy ID.

ExtractDate String False

The date the payment request was extracted, in order to import it into an accounts payable system and generate a payment.

FirstApprovalDate String False

The date the payment request received its first approval in its approval workflow.

FirstSubmitDate String False

The date the payment request was first submitted.

ID [KEY] String False

The unique identifier of the resource.

InvoiceAmount String False

User-entered value representing the total invoice amount, used to calculate amount remaining on the line item page.

InvoiceDate String False

The date the vendor issued the invoice.

InvoiceNumber String False

The invoice Number from the vendor for the payment request.

InvoiceReceivedDate String False

The date on which the invoice was received.

IsAssigned String False

Whether the payment request is assigned. Format: true/false.

IsInvoiceConfirmed String False

Indicates if the payment request invoice is confirmed or in a different status. Format: true/false.

IsPaymentRequestDeleted String False

Whether the payment request is deleted. Format: true/false.

IsPaymentRequestDuplicate String False

Whether the payment request identified as a duplicate of another existing request. Format:true/false.

IsTestTransaction String False

Is the payment request a test transaction (true/false).

LastSubmitDate String False

The date the payment request was last submitted.

LedgerCode String False

A code which indicates which company journal the payment request is assigned to. Use

EmployeeId String False

The company ID of the employee to whom the invoice should be assigned. Has precedence over EmployeeEmail; not evaluated if EmployeeLoginId matches an employee. This value is required if none of the following are provided: LedgerCode; EmployeeLoginId; EmployeeEmail; PurchaseOrderNumber; ExternalPolicyId.

EmployeeLoginId String False

The login ID of the employee to whom the invoice should be assigned. Has precedence over EmployeeId and EmployeeEmail. This value is required if none of the following are provided: LedgerCode; EmployeeId; EmployeeEmail; PurchaseOrderNumber; ExternalPolicyId.

LineItemsAggr String False

Aggregate information of line items

VendorRemitToIdentifierAgg String False

Used to identify the vendor location for payment remittance. At a minimum, the VendorCode or the combination of (VendorName, Address1, and PostalCode) are required. Use of as many fields as possible is encouraged to ensure a single vendor can be identified. If more than one vendor matches the information provided, the Invoice creation attempt will fail.

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