对账收款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 2016 Chanjet Inc.