| Name | Description | Type | Additional information |
|---|---|---|---|
| RQ |
日期 |
string |
None. |
| RepertoireId |
剧目ID RepertoireId Bigint NN |
integer |
None. |
| RepertoireName |
剧目名称 RepertoireName Nvarchar(30) NN |
string |
None. |
| SessionId |
场次ID SessionId Uniqueidentifier PK |
globally unique identifier |
None. |
| SessionName |
场次名称 SessionName Nvarchar(64) NN |
string |
None. |
| ToursimAreaId |
园区ID ToursimAreaId Uniqueidentifier NN |
globally unique identifier |
None. |
| ToursimAreaName |
园区名称 ToursimAreaName Nvarchar(64) NN |
string |
None. |
| PerformTime |
演出时间 PerformTime Varchar(20) NN 21:00-23:00 |
string |
None. |
| Income |
收入 Income Numeric(18,2) NN 依据交易日期的当日收入。如果没有分成且单一园区的，收入归入该园区；如果有多个园区且没有分成的，收入归入主园区（在配置中设置），没有命中的园区金额为零。 |
decimal number |
None. |
| TicketIncome |
售票收款 TicketIncome Numeric(18,2) NN |
decimal number |
None. |
| RefundTicketMoney |
退票退款 RefundTicketMoney Numeric(18,2) NN |
decimal number |
None. |
| Other |
其他 Other Numeric(18,2) NN 含交易手续费。 |
decimal number |
None. |
| SellPeopleTimes |
售票人次数 SellPeopleTimes Int NN |
integer |
None. |
| RefundPeopleTimes |
退票人次数 RefundPeopleTimes Int NN |
integer |
None. |
| NetPeopleTimes |
净人次数 NetPeopleTimes Int NN |
integer |
None. |
| AlterTicketOut |
签出人次数 AlterTicketOut Int NN |
integer |
None. |
| AlterTicketIn |
签入人次数 AlterTicketIn Int NN |
integer |
None. |
| PreoccupySeats |
预占座位数 PreoccupySeats Int NN 这个含预订未付，预留，维修 |
integer |
None. |
| SeatCounts |
座位数 SeatCounts Int NN 座位数-预订未付座位数-净人次数=空闲座位数（票数） |
integer |
None. |
| Attendance |
上座率 Attendance Numeric(4,1) |
decimal number |
None. |
| CheckedTicketCounts |
已检票数量 CheckedTicketCounts Int NN |
integer |
None. |
| WaitCheckCounts |
待检票数 WaitCheckCounts int |
integer |
None. |
| BookedTicketCounts |
已订票数量 BookedTicketCounts Int NN |
integer |
None. |
| WaitSellCounts |
待售票数量 WaitSellCounts int NN |
integer |
None. |
| RemainderSeats |
余座数 RemainderSeats int NN |
integer |
None. |