VendorPackingSlips
This view is part of Vendor Direct Fulfillment Shipping API. Returns a list of packing slips for the purchase orders that match the criteria specified. Date range to search must not be 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 VendorPackingSlips WHERE PurchaseOrderNumber = '12345'
SELECT * FROM VendorPackingSlips 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 | A Base64encoded string of the packing slip PDF. | |
| ContentType | String | The format of the file such as PDF, JPEG etc |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| CreatedDate | String | Filters for created date. If left empty the default specified range is from 6 days earlier to today |