POST api/Report/RPT_YYHZ_FKFS_1/V/Query
调用存储过程,产生营业类分付款方式汇总表
Request Information
URI Parameters
None.
Body Parameters
Rpt_TicketCommonParm2| Name | 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 |
| VAR_HasInsurance |
统计结果中是否包含保险数据。 |
string |
Max length: 1 |
| VAR_AddOnSolutionId |
加购方案ID |
string |
None. |
| VAR_RefSellBillNum |
引用售票单号 |
string |
None. |
| VAR_RefOrderNum |
引用预订单号 |
string |
None. |
Request Formats
application/json, text/json
{
"VAR_RQ1": "sample string 1",
"VAR_RQ2": "sample string 2",
"VAR_DATA": "sample string 3",
"VAR_DJSID": "3672597a-0dec-4ff9-bc7a-7637cbd397b4",
"VAR_DJSBMID": "54c64212-c89a-4c4c-a6c3-8be0a5c48a28",
"VAR_ZTSID": "703ea262-8f2d-4c4e-9378-edb62296cc11",
"VAR_ZTSBMID": "e1c3d3be-f92e-4fdd-80b0-73ec52a76e92",
"VAR_XYDWID": "0f8baa5d-8821-4111-bb27-a8c31edffe89",
"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",
"VAR_HasInsurance": "sample string 20",
"VAR_AddOnSolutionId": "sample string 21",
"VAR_RefSellBillNum": "sample string 22",
"VAR_RefOrderNum": "sample string 23"
}
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_AddOnSolutionId>sample string 21</VAR_AddOnSolutionId> <VAR_DATA>sample string 3</VAR_DATA> <VAR_DJSBMID>54c64212-c89a-4c4c-a6c3-8be0a5c48a28</VAR_DJSBMID> <VAR_DJSID>3672597a-0dec-4ff9-bc7a-7637cbd397b4</VAR_DJSID> <VAR_DYZH>sample string 9</VAR_DYZH> <VAR_FAID>sample string 15</VAR_FAID> <VAR_FKFSID>sample string 16</VAR_FKFSID> <VAR_HasInsurance>sample string 20</VAR_HasInsurance> <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_RefOrderNum>sample string 23</VAR_RefOrderNum> <VAR_RefSellBillNum>sample string 22</VAR_RefSellBillNum> <VAR_SCQH>sample string 14</VAR_SCQH> <VAR_SPZDDM>sample string 19</VAR_SPZDDM> <VAR_TDLX>sample string 13</VAR_TDLX> <VAR_XYDWID>0f8baa5d-8821-4111-bb27-a8c31edffe89</VAR_XYDWID> <VAR_YHDLM>sample string 18</VAR_YHDLM> <VAR_YWYDM>sample string 17</VAR_YWYDM> <VAR_ZTSBMID>e1c3d3be-f92e-4fdd-80b0-73ec52a76e92</VAR_ZTSBMID> <VAR_ZTSID>703ea262-8f2d-4c4e-9378-edb62296cc11</VAR_ZTSID> </Rpt_TicketCommonParm2>
application/x-www-form-urlencoded
application/bson
Binary JSON content. See http://bsonspec.org for details.
Response Information
Resource Description
调用存储过程,产生营业类分付款方式汇总表
ComplexParm| Name | 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.