| Name | Description | Type | Additional information |
|---|---|---|---|
| STARTDATE |
@STARTDATE char(8),/*起始的交易日期*/ |
string |
Max length: 8 |
| ENDDATE |
@ENDDATE char(8),/*截止的交易日期*/ |
string |
Max length: 8 |
| BillNum |
@BillNum varchar(20),/*单据单号,左匹配，输入时需要加"%"*/ |
string |
Max length: 20 |
| CompleteBillOnly |
@CompleteBillOnly char(1),/*是否仅返回已结单据，1表示是，其他值表示否,当此值为‘1’时，@SellBillPayState，@RefundBillState参数没有意义*/ |
string |
Max length: 1 |
| SellBillPayState |
@SellBillPayState char(1),/*售票单收款状态*/ |
string |
Max length: 1 |
| RefundBillState |
RefundBillState char(1),/*退款单状态*/ |
string |
Max length: 1 |
| BusiFrom |
@BusiFrom char(1),/*交易来源，1是前台2是互联网或手机*/ |
string |
Max length: 1 |
| IsBindingGuider |
@IsBindingGuider char(1),/*是否绑定导游，1表示是，0表示否*/ |
string |
Max length: 1 |
| GuiderNum |
@GuiderNum varchar(20),/*导游证号*/ |
string |
Max length: 20 |
| FKFSID |
@FKFSID char(2),/*付款方式（含）*/ |
string |
Max length: 2 |
| STAAREA |
@STAAREA char(1),/*统计范围 A全部，1仅售货， 2仅退货 */ |
string |
Max length: 1 |
| MemberId |
@MemberId Bigint ,/*会员代码*/ |
integer |
None. |
| MemberLevelId |
@MemberLevelId tinyint ,/*会员等级*/ |
byte |
None. |
| ShopList |
@ShopList as CT_STR50_UNIQUE_ARR READONLY,/*门票列表*/ |
Collection of string |
None. |
| UserList |
@UserList as CT_STR50_UNIQUE_ARR READONLY ,/*售货员列表*/ |
Collection of string |
None. |
| ProductList |
@ProductList as CT_INT_UNIQUE_ARR READONLY,/*商品清单（含）*/ |
Collection of string |
None. |
| ProductClassList |
@ProductClassList as CT_STR50_UNIQUE_ARR READONLY,/*商品列别清单（含）*/ |
Collection of string |
None. |