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. |