POST api/Report/RPT_YYHZ_FKFS_2_KHDWD/V/Query
调用存储过程,产生营业类分付款方式汇总表2(分客户单位)
Request Information
URI Parameters
None.
Body Parameters
Rpt_TicketCommonParm2Name | Description | Type | Additional information |
---|---|---|---|
VAR_RQ1 |
VAR_RQ1 char(8)/*起始日期*/, |
string |
Max length: 8 |
VAR_RQ2 |
VAR_RQ2 char(8)/*截止日期*/, |
string |
Max length: 8 |
VAR_DATA |
char(1),/*统计范围:'1'仅售票数据,2仅退票数据,其他值售票和退票数据*/ |
string |
Max length: 1 |
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 |
Max length: 20 |
VAR_JYLY |
VAR_JYLY char(1),/*交易来源,1前台,2互联网*/ |
string |
Max length: 1 |
VAR_MemberId |
VAR_MemberId bigint,/*会员ID,0表示不限*/ |
integer |
None. |
VAR_MemberLevel |
VAR_MemberLevel tinyint ,/*会员等级,FF表示不限*/ |
byte |
None. |
VAR_TDLX |
VAR_TDLX char(2),/*游客类型或团队类型*/ |
string |
Max length: 2 |
VAR_SCQH |
VAR_SCQH varchar(8),/*市场区划*/ |
string |
None. |
VAR_FAID |
VAR_FAID char(4) ,/*现返方案ID*/ |
string |
Max length: 8 |
VAR_FKFSID |
FKFSID ,付款方式ID。 |
string |
Max length: 2 |
VAR_YWYDM |
VAR_YWYDM varchar(4),/*业务员代码*/ |
string |
Max length: 4 |
VAR_YHDLM |
VAR_YHDLM AS CT_STR50_UNIQUE_ARR READONLY/*售票员*/, |
string |
Max length: 8000 |
VAR_SPZDDM |
VAR_SPZDDM as CT_STR50_UNIQUE_ARR READONLY/*售票站点代码*/ |
string |
Max length: 8000 |
Request Formats
application/json, text/json
{ "VAR_RQ1": "sample string 1", "VAR_RQ2": "sample string 2", "VAR_DATA": "sample string 3", "VAR_DJSID": "e3e0f7de-94b4-4204-8196-ab6a7951f3a9", "VAR_DJSBMID": "9925e5fd-8399-44bb-a025-3819d8fddc32", "VAR_ZTSID": "5ae50570-f23a-4391-b3cd-b6e6fec8115e", "VAR_ZTSBMID": "04e0d676-e8b4-4ab9-afa0-85b59606b52f", "VAR_XYDWID": "261382ac-8b6a-465c-a107-cdfbaf82a39b", "VAR_DYZH": "sample string 9", "VAR_JYLY": "sample string 10", "VAR_MemberId": 11, "VAR_MemberLevel": 64, "VAR_TDLX": "sample string 13", "VAR_SCQH": "sample string 14", "VAR_FAID": "sample string 15", "VAR_FKFSID": "sample string 16", "VAR_YWYDM": "sample string 17", "VAR_YHDLM": "sample string 18", "VAR_SPZDDM": "sample string 19" }
application/xml, text/xml
<Rpt_TicketCommonParm2 xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer.Tour.V5.Parm.Report"> <VAR_DATA>sample string 3</VAR_DATA> <VAR_DJSBMID>9925e5fd-8399-44bb-a025-3819d8fddc32</VAR_DJSBMID> <VAR_DJSID>e3e0f7de-94b4-4204-8196-ab6a7951f3a9</VAR_DJSID> <VAR_DYZH>sample string 9</VAR_DYZH> <VAR_FAID>sample string 15</VAR_FAID> <VAR_FKFSID>sample string 16</VAR_FKFSID> <VAR_JYLY>sample string 10</VAR_JYLY> <VAR_MemberId>11</VAR_MemberId> <VAR_MemberLevel>64</VAR_MemberLevel> <VAR_RQ1>sample string 1</VAR_RQ1> <VAR_RQ2>sample string 2</VAR_RQ2> <VAR_SCQH>sample string 14</VAR_SCQH> <VAR_SPZDDM>sample string 19</VAR_SPZDDM> <VAR_TDLX>sample string 13</VAR_TDLX> <VAR_XYDWID>261382ac-8b6a-465c-a107-cdfbaf82a39b</VAR_XYDWID> <VAR_YHDLM>sample string 18</VAR_YHDLM> <VAR_YWYDM>sample string 17</VAR_YWYDM> <VAR_ZTSBMID>04e0d676-e8b4-4ab9-afa0-85b59606b52f</VAR_ZTSBMID> <VAR_ZTSID>5ae50570-f23a-4391-b3cd-b6e6fec8115e</VAR_ZTSID> </Rpt_TicketCommonParm2>
application/x-www-form-urlencoded
Sample not available.
application/bson
Binary JSON content. See http://bsonspec.org for details.
Response Information
Resource Description
调用存储过程,产生营业类分付款方式汇总表2(分客户单位)
ComplexParmName | Description | Type | Additional information |
---|---|---|---|
Zipped |
读取或设置一个值,指示当前缓冲区是否经过了压缩 |
boolean |
None. |
Buffer |
读取或设置一个值,指明当前缓冲区的内容 |
Collection of byte |
None. |
Response Formats
application/json, text/json
{ "Zipped": true, "Buffer": "QEA=" }
application/xml, text/xml
<ComplexParm xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer"> <Buffer>QEA=</Buffer> <Zipped>true</Zipped> </ComplexParm>
application/bson
Binary JSON content. See http://bsonspec.org for details.