CS_CashAccount 数据库表名:现金银行帐DTO

字段名称 字段说明 字段长度 字段类型 是否唯一
ID 主键 -1 ID 0
Code 编号 30 String 0
Name 名称 200 String 0
SourceVoucherDate 来源单据日期 -1 DateTime 0
SourceVoucherID 来源单据ID -1 ID 0
OrigTotalDrAmount 借(收入)累计金额 -1 Decimal 0
TotalDrAmount 借(收入)累计本币 -1 Decimal 0
OrigTotalCrAmount 贷(支出)累计金额 -1 Decimal 0
TotalCrAmount 贷(支出)累计本币 -1 Decimal 0
SourceVoucherCode 来源单据编号 30 String 0
SourceVoucherMaker 来源单据制单人 50 String 0
SourceVoucherAuditor 来源单据审核人 50 String 0
SourceVoucherMemo 备注 200 String 0
SourceMultiSettleID 来源多结算ID -1 ID 0
OrigInAmount 收入金额 -1 Decimal 0
OrigOutAmount 支出金额 -1 Decimal 0
OrigAmount 余额 -1 Decimal 0
IsPeriodBeginning 是否期初 -1 Bool 0
SourceVoucherCreatedTime 来源单据创建日期 -1 DateTime 0
SourceVoucherDocumentCode 来源单据票据号 30 String 0
AccountingYear 会计年度 -1 Int 0
AccountingPeriod 会计期间 -1 Int 0
DocNo 凭证号 36 String 0
DocId 凭证Id 36 String 0
DocClass 凭证类别 36 String 0
Year 业务年期间 -1 Int 0
Period 业务月期间 -1 Int 0
IsCarriedForwardIn isCarriedForwardIn -1 Bool 0
IsCarriedForwardOut isCarriedForwardOut -1 Bool 0
InAmount 收入金额(本币) -1 Decimal 0
OutAmount 支出金额(本币) -1 Decimal 0
Amount 余额(本币) -1 Decimal 0
IsPullin 是否引入到手工日记账 -1 Bool 0
InExchangeRate 收入汇率 -1 Decimal 0
OutExchangeRate 支出汇率 -1 Decimal 0
ExchangeRate 余额汇率 -1 Decimal 0
CreatedTime CreatedTime -1 DateTime 0
SequenceNumber 顺序号 -1 Int 0
Ts 分布时间戳 -1 TimeStamp 0
Updated 更新时间 32 DateTime 0
UpdatedBy 更新者 32 String 0
idbankAccount idbankAccount 0 ID 0
BankAccount BankAccount 0 DTO 0
idsourceVoucherBusinessType idsourceVoucherBusinessType 0 ID 0
SourceVoucherBusinessType SourceVoucherBusinessType 0 DTO 0
idsourceVoucherType idsourceVoucherType 0 ID 0
SourceVoucherType SourceVoucherType 0 DTO 0
idpartner idpartner 0 ID 0
Partner Partner 0 DTO 0
iddepartment iddepartment 0 ID 0
Department Department 0 DTO 0
idperson idperson 0 ID 0
Person Person 0 DTO 0
idsettleStyle idsettleStyle 0 ID 0
SettleStyle SettleStyle 0 DTO 0
SourceVoucherMakerId 制单人ID -1 ID 0
idproject idproject -1 ID 0
Project Project 0 DTO 0
IdMarketingOrgan IdMarketingOrgan -1 ID 0
MarketingOrgan MarketingOrgan 0 DTO 0