| Name | Description | Type | Additional information |
|---|---|---|---|
| TradeId |
灌溉交易ID TradeId bigint FK,PK |
integer |
None. |
| SerialId |
流量计ID SerialId Bigint 表联接 |
integer |
None. |
| YearCode |
账户年度 YearCode Char(4) PK |
string |
None. |
| TotalConsumeVolumn |
核算用水量 TotalConsumeVolumn Numeric(18,2) |
decimal number |
None. |
| CalSummary |
核算水费额 CalSummary Numeric(18,2) |
decimal number |
None. |
| ReceivedSummary |
已收款合计数 ReceivedSummary Numeric(18,2) 获取某个灌溉交易某个年度账单的已收款合计数 |
decimal number |
None. |
| BalanceSummery |
尚余差额 BalanceSummery Numeric(18,2) |
decimal number |
None. |
| PriceDesc |
价格阶梯 PriceDesc varchar(400) 获取某个结算年度记录的价格阶梯 |
string |
None. |
| LandGroupId |
组ID LandGroupId Bigint 表联接 |
integer |
None. |
| WateringTime |
交易时间 WateringTime Varchar(40) 从何时起至何时止的时间段 YYYY-MM-dd HH:mm至YYYY-MM-dd HH:mm |
string |
None. |
| DiscountSummary |
减免水费 DiscountSummary Numeric(18,2) |
decimal number |
None. |
| TotalSummary |
应收水费 TotalSummary Numeric(18,2) 优惠后的水费 |
decimal number |
None. |
| MeterInfo |
流量计信息 MeterInfo Varchar(200) 函数 |
string |
None. |
| HitPriceStepInfo |
阶梯信息 HitPriceStepInfo varchar 获取某一次灌溉交易在某一个年度的账单上命中的阶梯信息 |
string |
None. |
| GroupName |
依据组的ID，查询组的名称并返回 |
string |
None. |
| AgentId |
运营商ID AgentId Bigint NN,FK |
integer |
None. |