| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
id |
integer |
None. |
| id_User |
User id |
integer |
None. |
| UniqueID |
Quote/Order/Invoice ID |
string |
None. |
| id_Order |
Order Serial No |
integer |
None. |
| id_Branch |
Branch Id |
integer |
None. |
| id_OrderType |
1: Parcel 2: Order 3: Container |
integer |
None. |
| id_InfoType |
Info Type |
integer |
None. |
| id_Staff | integer |
None. |
|
| StartDate |
Query Start Date in "yyyy-MM-dd" |
date |
None. |
| EndDate |
Query End Date in "yyyy-MM-dd" |
date |
None. |
| DateType |
Date type. 0: Default create date, 31: Invoice payment date. |
integer |
None. |
| id_Status |
Status ID. 0: Default all status; -1: All Active Status; 1,2,3,...: for specific info status; |
integer |
None. |
| StatusType |
StatusType. 0: Default all status; 1 - 1,4,5, 2 - 6, 70, 75, 78, 80, 82, 84, 3 - 85, 4 - 87 5 - 88 6 - 96 7 - Other |
integer |
None. |
| id_Status_exclude |
Status ID exclude. |
integer |
None. |
| id_SubStatus |
Sub Status ID |
integer |
None. |
| id_PickupLocation | integer |
None. |
|
| keyword |
搜索关键字 |
string |
None. |
| pageNum |
页码 |
integer |
None. |
| pageSize |
每页条目数 |
integer |
None. |
| sortBy |
排序依据 |
string |
None. |
| order |
排序方向 asc/desc |
string |
None. |
| lang |
语言 EN/CN |
string |
None. |
| AllInvoiceType |
true: 所有账单类型 false: 不包括 50 出口运费 Export Freight |
boolean |
None. |