POST api/Report/RPT_YYRHZ_FKFS_1/V/Query

调用存储过程SP_RPT_YYRHZ_FKFS_1,产生营业类分付款方式日汇总表一

Request Information

URI Parameters

None.

Body Parameters

Rpt_TicketCommonParm2
NameDescriptionTypeAdditional 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

Sample:
{
  "VAR_RQ1": "sample string 1",
  "VAR_RQ2": "sample string 2",
  "VAR_DATA": "sample string 3",
  "VAR_DJSID": "825eca71-0d18-4c8d-ae02-efef272d615d",
  "VAR_DJSBMID": "b2d16150-26b3-4e82-b07d-d89d099d1166",
  "VAR_ZTSID": "b918e9a5-9c39-4d83-b7de-fce42cc3e27c",
  "VAR_ZTSBMID": "fb60468d-1726-44c5-bcd3-11d5166f9c8e",
  "VAR_XYDWID": "f5a36cdc-44fe-4480-8d09-798f0c69c7f4",
  "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

Sample:
<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>b2d16150-26b3-4e82-b07d-d89d099d1166</VAR_DJSBMID>
  <VAR_DJSID>825eca71-0d18-4c8d-ae02-efef272d615d</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>f5a36cdc-44fe-4480-8d09-798f0c69c7f4</VAR_XYDWID>
  <VAR_YHDLM>sample string 18</VAR_YHDLM>
  <VAR_YWYDM>sample string 17</VAR_YWYDM>
  <VAR_ZTSBMID>fb60468d-1726-44c5-bcd3-11d5166f9c8e</VAR_ZTSBMID>
  <VAR_ZTSID>b918e9a5-9c39-4d83-b7de-fce42cc3e27c</VAR_ZTSID>
</Rpt_TicketCommonParm2>

application/x-www-form-urlencoded

Sample:

Sample not available.

application/bson

Sample:
Binary JSON content. See http://bsonspec.org for details.

Response Information

Resource Description

调用存储过程SP_RPT_YYRHZ_FKFS_1,产生营业类分付款方式日汇总表一

ComplexParm
NameDescriptionTypeAdditional information
Zipped

读取或设置一个值,指示当前缓冲区是否经过了压缩

boolean

None.

Buffer

读取或设置一个值,指明当前缓冲区的内容

Collection of byte

None.

Response Formats

application/json, text/json

Sample:
{
  "Zipped": true,
  "Buffer": "QEA="
}

application/xml, text/xml

Sample:
<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

Sample:
Binary JSON content. See http://bsonspec.org for details.