支票DTO
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
voucherdate (T+12.1) | 单据日期 | datetime | 8 | True | |
invalidatememo (T+12.1) | 作废备注 | nvarchar | 50 | True | |
reimbursememo (T+12.1) | 报销备注 | nvarchar | 50 | True | |
voucherstatebeforeclose (T+12.1) | 作废前的单据状态 | int | 4 | True | |
iscarriedforwardin (T+12.1) | 是否结转来的单据 | tinyint | 1 | True | |
documentsusage (T+12.1) | 用途 | nvarchar | 50 | True | |
origbillamout (T+12.1) | 开票金额 | decimal | 13 | True | |
origreimburseamount (T+12.1) | 报销金额 | decimal | 13 | True | |
maker (T+12.1) | 制单人 | nvarchar | 50 | True | |
reimbursedate (T+12.1) | 报销日期 | datetime | 8 | True | |
origLimitAmount (T+12.1) | 领用限额 | decimal | 13 | True | |
notepwd (T+12.1) | 支票密码 | nvarchar | 50 | True | |
sourcevouchercode (T+12.1) | 来源单据编号 | nvarchar | 50 | True | |
paymenter (T+12.1) | 付款人 | nvarchar | 50 | True | |
receiver (T+12.1) | 收款人 | nvarchar | 50 | True | |
settledetailid (T+12.1) | 结算明细ID | nvarchar | 1024 | True | |
idreimbursedepartment (T+12.1) | 报销部门ID | int | 4 | True | |
iduser (T+12.1) | 用户Id | int | 4 | True | |
receivebank (T+12.1) | 收款银行 | nvarchar | 50 | True | |
idsourcevouchertype (T+12.1) | 来源单据类型ID | int | 4 | True | |
idreceivebankaccount (T+12.1) | 收款账号ID | int | 4 | True | |
id (T+12.1) | 主键 | int | 4 | False | |
makerid (T+12.1) | 制单人ID | int | 4 | True | |
invalidatedate (T+12.1) | 作废日期 | datetime | 8 | True | |
memo (T+12.1) | 备注 | nvarchar | 50 | True | |
voucherstate (T+12.1) | 单据状态 | int | 4 | True | |
ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
billDate (T+12.1) | 票据日期 | datetime | 8 | True | |
idwriteoffer (T+12.1) | idwriteOffer | int | 4 | True | |
billcode (T+12.1) | 票号 | nvarchar | 50 | True | |
idusedepartment (T+12.1) | 领用部门ID | int | 4 | True | |
createdtime (T+12.1) | 创建时间 | datetime | 8 | True | |
isautoreimburse (T+12.1) | 自动报销 | tinyint | 1 | True | |
idpaymentbankaccount (T+12.1) | 付款账号ID | int | 4 | True | |
receiveaccount (T+12.1) | 收款账号 | nvarchar | 50 | True | |
idorigreimburseperson (T+12.1) | 报销人ID | int | 4 | True | |
iduserperson (T+12.1) | 领用人ID | int | 4 | True | |
idChequeBookDTO (T+12.1) | 支票本ID | int | 4 | True | |
sourceVoucherID (T+12.1) | 来源单据ID | int | 4 | True | |
iscarriedforwardout (T+12.1) | 是否已结转 | tinyint | 1 | True | |
idcancler (T+12.1) | idcancler | int | 4 | True |
Copyright 2016 Chanjet Inc.