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 |