对账收款DTO
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| imprestamount (T+12.1) | 增减备用金金额 | decimal | 13 | True | |
| RetailBankAccountName (T+12.3) | 账号名称 | nvarchar | 50 | True | |
| receivetime (T+12.1) | 交款时间 | char | 8 | True | |
| RetailAmount (T+12.3) | 零售金额 | decimal | 13 | True | |
| factsettleamount (T+12.1) | 实际上交本币金额 | decimal | 13 | True | |
| idsettlestyle (T+12.1) | 结算方式ID | int | 4 | True | |
| poscode (T+12.1) | POS编码 | nvarchar | 50 | True | |
| autoid (T+12.2) | 自增ID | int | 4 | False | |
| imprestbalanceamount (T+12.1) | 备用金余额 | decimal | 13 | True | |
| RetailOrigAmount (T+12.3) | 结算金额 | decimal | 13 | True | |
| iscarriedforwardout (T+12.1) | 是否已结转 | tinyint | 1 | True | |
| dailyDetailCode (T+12.1) | 日结单号 | nvarchar | 50 | True | |
| createdtime (T+12.1) | 创建时间 | datetime | 8 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| shiftdate (T+12.1) | 交班日期 | datetime | 8 | True | |
| iscarriedforwardin (T+12.1) | 是否结转来的单据 | tinyint | 1 | True | |
| exchangerate (T+12.1) | 汇率 | decimal | 13 | True | |
| workingdate (T+12.1) | 上班日期 | datetime | 8 | True | |
| idbankaccount (T+12.1) | 账号ID | int | 4 | True | |
| dailyTime (T+12.1) | 日结时间 | char | 8 | True | |
| workingtime (T+12.1) | 上班时间 | nvarchar | 8 | True | |
| origfactsettleamount (T+12.1) | 实际收款金额 | decimal | 13 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| idcurrency (T+12.1) | 币种ID | int | 4 | True | |
| shiftvoucherdate (T+12.1) | 交班单日期 | datetime | 8 | True | |
| amount (T+12.1) | 金额 | decimal | 13 | True | |
| extendflag (T+12.1) | 扩展标志 | int | 4 | True | |
| usercode (T+12.1) | 收银员编码 | nvarchar | 50 | True | |
| shifttime (T+12.1) | 交班时间 | char | 8 | True | |
| origsettleamount (T+12.1) | 原币结算金额 | decimal | 13 | True | |
| shiftvouchercode (T+12.1) | 交班单号 | nvarchar | 50 | True | |
| dailyDetailID (T+12.1) | 日结单ID | bigint | 8 | True | |
| userid (T+12.1) | 用户ID | int | 4 | True | |
| receivedate (T+12.1) | 交款日期 | datetime | 8 | True | |
| receivername (T+12.1) | 收款人名称 | nvarchar | 50 | True | |
| posname (T+12.1) | POS名称 | nvarchar | 50 | True | |
| sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
| receiverid (T+12.1) | 收款人Id | int | 4 | True | |
| receivercode (T+12.1) | 收款人编码 | nvarchar | 50 | True | |
| MemberStorageAmount (T+12.3) | 会员储值金额 | decimal | 13 | True | |
| settleamount (T+12.1) | 已收已付金额(本币) | decimal | 13 | True | |
| origamount (T+12.1) | 原币金额 | decimal | 13 | True | |
| shiftvoucherid (T+12.1) | 交班单ID | bigint | 8 | True | |
| idstore (T+12.1) | 门店ID | int | 4 | True | |
| ID (T+12.1) | 主键 | bigint | 8 | False | |
| idreceivebankaccount (T+12.1) | 收款账号ID | int | 4 | True | |
| initialamount (T+12.1) | 钱箱初始余额 | decimal | 13 | True | |
| dailyDetailDate (T+12.1) | 日结单日期 | datetime | 8 | True | |
| name (T+12.1) | 名称 | nvarchar | 200 | True | |
| username (T+12.1) | 用户姓名 | nvarchar | 50 | True |
Copyright 2019 Chanjet Inc.