VendorCustomerInvoices
This view is part of Vendor Direct Fulfillment Shipping API. Returns a list of customer invoices created during a time frame that you specify. The date range to search must be no more than 7 days.
Select
The following fields are filtered server-side:- PurchaseOrderNumber supports the '=' comparison
- CreatedDate supports all the >, >=, =, <=, < comparisons
Some example queries:
SELECT * FROM VendorCustomerInvoices
SELECT * FROM VendorCustomerInvoices WHERE PurchaseOrderNumber = '12345'
SELECT * FROM VendorCustomerInvoices WHERE CreatedDate > '2022-09-10T12:00:00' AND CreatedDate < '2022-09-15T12:00:00'
Columns
| Name | Type | References | Description |
| PurchaseOrderNumber [KEY] | String | This field will contain the Purchase Order Number for this order. | |
| Content | String | The Base64encoded customer invoice. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| CreatedDate | String | Filters for created date. If left empty the default specified range is from 6 days earlier to today. |