Name | Description | Type | Additional information |
---|---|---|---|
MPLXID1 |
单选的门票类型ID |
string |
Max length: 36 |
ISALL |
@ISALL CHAR(1),/*是否查询全部数据(1-查询所有 0-仅查询旅行社数据(即不查询其他的数据)) |
string |
Max length: 1 |
Top20 |
@Top20 char(1) /*是否只显示前20名*/ |
string |
Max length: 1 |
XZQHDMp |
@VAR_XZQHDM varchar(6),/*行政区划代码*/ |
string |
Max length: 6 |
GPXZ |
@VAR_GPXZ char(1),/*购票人性质 '0' 只含旅行社部门导游组团组团部门 '1' 只含散客 其他值全包括*/ |
string |
Max length: 1 |
SCQHDM |
@VAR_SCQHDM char(2),/*一级市场区划代码*/ |
string |
Max length: 8 |
TJFW |
@TJFW char(1)统计范围1营业类,2返款类,A营业类+返款类 |
string |
Max length: 1 |
FLAG |
@VAR_FLAG char(1),/*是否启用价格区间查询 1表示启用*/ |
string |
Max length: 1 |
JG1 |
@VAR_JG1 decimal(18,2),/*价格区间1*/ |
decimal number |
None. |
JG2 |
@VAR_JG2 decimal(18,2)/*价格区间2*/ |
decimal number |
None. |
MPLXID |
门票类型id GUID类型 |
globally unique identifier |
None. |
JMDM |
@VAR_JMDM bigint, 剧目代码 |
integer |
None. |
YQID |
@VAR_YQID UNIQUEIDENTIFIER,园区ID |
globally unique identifier |
None. |
PCMC |
@VAR_PCMC nvarchar(64) 场次名称 |
string |
Max length: 64 |
PCID |
@VAR_PCID uniqueidentifier,场次ID |
globally unique identifier |
None. |
ISJQ |
@VAR_ISJQ char(1),是否是景区统计 1表示景区,其他值表示演艺系统 |
string |
Max length: 1 |
TJNR |
@VAR_TJNR char(1)1仅统计数量,2仅统计金额,其他值,全部统计 |
string |
Max length: 1 |
SPZD |
@VAR_SPZD char(2),售票站点 |
string |
Max length: 2 |
SYSID |
@VAR_SYSID char(1)/*1-仅检索团队购票 2-仅检索散客购票 0或空,检索上序两种购票*/ |
string |
Max length: 1 |
DayType | string |
Max length: 1 |
|
StartDate | string |
Required Max length: 8 |
|
EndDate | string |
Required Max length: 8 |
|
DJSFZID | globally unique identifier |
None. |
|
DJSID | globally unique identifier |
None. |
|
DJSBMID | globally unique identifier |
None. |
|
ZTSID | globally unique identifier |
None. |
|
ZTSBMID | globally unique identifier |
None. |
|
XYDWID | globally unique identifier |
None. |
|
SPDH | string |
Max length: 20 |
|
LBSBH | string |
Max length: 32 |
|
YHDLM | string |
Max length: 20 |
|
DYZH | string |
Max length: 20 |
|
JYLY | string |
Max length: 1 |
|
XFFAID | string |
Max length: 6 |
|
FKFSID | string |
Max length: 2 |
|
MPLXList | string |
Max length: 2000 |
|
SPZDList | string |
Max length: 2000 |