Name | Description | Type | Additional information |
---|---|---|---|
VAR_RQ1 |
VAR_RQ1 char(8)/*起始日期*/, |
string |
None. |
VAR_RQ2 |
VAR_RQ2 char(8)/*截止日期*/, |
string |
None. |
VAR_DATA |
/*统计范围:'1'仅售票数据,2仅退票数据,其他值售票和退票数据*/ |
string |
None. |
VAR_DJSID |
VAR_DJSID uniqueidentifier,/*地接社ID*/ |
globally unique identifier |
None. |
VAR_DJSBMID |
VAR_DJSBMID uniqueidentifier ,/*地接社部门ID*/ |
globally unique identifier |
None. |
VAR_ZTSID |
VAR_ZTSID uniqueidentifier,/*组团社ID*/ |
globally unique identifier |
None. |
VAR_ZTSBMID |
VAR_ZTSBMID uniqueidentifier,/*组团社ID*/ |
globally unique identifier |
None. |
VAR_XYDWID |
VAR_XYDWID uniqueidentifier,/*协议单位ID*/ |
globally unique identifier |
None. |
VAR_DYZH |
VAR_DYZH varchar(20),/*导游证号*/ |
string |
None. |
VAR_JYLY |
VAR_JYLY char(1),/*交易来源,1前台,2互联网*/ |
string |
None. |
VAR_MemberId |
VAR_MemberId bigint,/*会员ID,0表示不限*/ |
integer |
None. |
VAR_MemberLevel |
VAR_MemberLevel tinyint ,/*会员等级,FF表示不限*/ |
byte |
None. |
VAR_TDLX |
VAR_TDLX char(2),/*游客类型或团队类型*/ |
string |
None. |
VAR_SCQH |
VAR_SCQH varchar(8),/*市场区划*/ |
string |
None. |
VAR_FAID |
VAR_FAID char(4) ,/*现返方案ID*/ |
string |
None. |
VAR_YWYDM |
VAR_YWYDM varchar(4),/*业务员代码*/ |
string |
None. |
VAR_FKFS |
售票单或退票单具有某种付款方式 |
string |
None. |
VAR_YHDLM |
VAR_YHDLM AS CT_STR50_UNIQUE_ARR READONLY/*售票员*/, |
string |
None. |
VAR_SPZDDM |
VAR_SPZDDM as CT_STR50_UNIQUE_ARR READONLY/*售票站点代码*/ |
string |
None. |