SM_FC_TransactionEntry 数据库表名:交易分录DTO
字段名称 |
字段说明 |
字段长度 |
字段类型 |
是否唯一 |
ID |
主键 |
-1 |
ID |
0 |
Code |
编号 |
30 |
String |
0 |
Name |
名称 |
200 |
String |
0 |
Summary |
摘要 |
200 |
String |
0 |
ExchangeRate |
汇率 |
-1 |
Decimal |
0 |
OrigAmountDr |
借方原币 |
-1 |
Decimal |
0 |
OrigAmountCr |
贷方原币 |
-1 |
Decimal |
0 |
AmountDr |
借方本币 |
-1 |
Decimal |
0 |
AmountCr |
贷方本币 |
-1 |
Decimal |
0 |
QuantityDr |
借方数量 |
-1 |
Decimal |
0 |
QuantityCr |
贷方数量 |
-1 |
Decimal |
0 |
Price |
单价 |
-1 |
Decimal |
0 |
MergeCode |
合并号 |
50 |
String |
0 |
OrigAmount |
原币金额 |
-1 |
Decimal |
0 |
BillNo |
票据号 |
50 |
String |
0 |
BillDate |
票据日期 |
-1 |
DateTime |
0 |
Memoto |
备注 |
200 |
String |
0 |
DCdirection |
借贷方向 |
-1 |
Enum |
0 |
GenerateDate |
创建时间 |
-1 |
DateTime |
0 |
AccountType |
科目类型 |
50 |
String |
0 |
Extend1 |
扩展字段1 |
50 |
String |
0 |
Extend2 |
扩展字段2 |
50 |
String |
0 |
Extend3 |
扩展字段3 |
50 |
String |
0 |
CreatedTime |
CreatedTime |
-1 |
DateTime |
0 |
SequenceNumber |
顺序号 |
-1 |
Int |
0 |
Ts |
分布时间戳 |
-1 |
TimeStamp |
0 |
Updated |
更新时间 |
32 |
DateTime |
0 |
UpdatedBy |
更新者 |
32 |
String |
0 |
idcurrency |
idcurrency |
0 |
ID |
0 |
Currency |
Currency |
0 |
DTO |
0 |
idtransactionDocDTO |
idtransactionDocDTO |
0 |
ID |
0 |
TransactionDoc |
TransactionDoc |
0 |
DTO |
0 |
SourceVoucherDetails |
SourceVoucherDetails |
0 |
DTOCollection |
0 |
idauxiliaryInfo |
idauxiliaryInfo |
0 |
ID |
0 |
AuxiliaryInfo |
AuxiliaryInfo |
0 |
DTO |
0 |
idaccount |
idaccount |
0 |
ID |
0 |
Account |
Account |
0 |
DTO |
0 |
AuxiliaryInfos |
AuxiliaryInfos |
0 |
DTOCollection |
0 |