GL_Journal 数据库表名:明细账DTO
| 字段名称 |
字段说明 |
字段长度 |
字段类型 |
是否唯一 |
| ID |
主键 |
-1 |
ID |
0 |
| Code |
编号 |
30 |
String |
0 |
| Name |
名称 |
200 |
String |
0 |
| DocID |
凭证ID |
-1 |
ID |
0 |
| EntryID |
分录ID |
-1 |
ID |
0 |
| AuxiliaryInfoID |
辅助信息ID |
-1 |
ID |
0 |
| DocNo |
凭证编号 |
50 |
String |
0 |
| DocBusinessType |
凭证业务类型 |
-1 |
Enum |
0 |
| RowNo |
分录行号 |
50 |
String |
0 |
| Summary |
摘要 |
200 |
String |
0 |
| Maker |
制单人名称 |
50 |
String |
0 |
| MadeDate |
制单日期 |
-1 |
DateTime |
0 |
| AuditorName |
审核人名称 |
50 |
String |
0 |
| AuditDate |
审核日期 |
-1 |
DateTime |
0 |
| SupervisorName |
主管名称 |
50 |
String |
0 |
| SupervisorAuditDate |
主管签字日期 |
-1 |
DateTime |
0 |
| CashierName |
出纳名称 |
50 |
String |
0 |
| CashierAuditDate |
出纳签字日期 |
-1 |
DateTime |
0 |
| BookKeeperName |
记账人名称 |
50 |
String |
0 |
| PostDate |
记账日期 |
-1 |
DateTime |
0 |
| IsTaxed |
是否计税 |
-1 |
Bool |
0 |
| SeqNo |
辅助信息编码 |
50 |
String |
0 |
| Direction |
借贷方向 |
-1 |
Enum |
0 |
| ExchangeRate |
汇率 |
-1 |
Decimal |
0 |
| Price |
单价 |
-1 |
Decimal |
0 |
| IsCarriedForwardOut |
是否转出 |
-1 |
Bool |
0 |
| IsCarriedForwardIn |
是否转入 |
-1 |
Bool |
0 |
| CreatedTime |
CreatedTime |
-1 |
DateTime |
0 |
| SequenceNumber |
顺序号 |
-1 |
Int |
0 |
| Ispost |
是否记账 |
-1 |
Bool |
0 |
| Year |
年 |
-1 |
Int |
0 |
| CurrentPeriod |
期间 |
-1 |
Int |
0 |
| Ts |
分布时间戳 |
-1 |
TimeStamp |
0 |
| Updated |
更新时间 |
32 |
DateTime |
0 |
| UpdatedBy |
更新者 |
32 |
String |
0 |
| idclerk |
idclerk |
0 |
ID |
0 |
| Clerk |
Clerk |
0 |
DTO |
0 |
| idauxAccPerson |
idauxAccPerson |
0 |
ID |
0 |
| AuxAccPerson |
AuxAccPerson |
0 |
DTO |
0 |
| idauxAccInventory |
idauxAccInventory |
0 |
ID |
0 |
| AuxAccInventory |
AuxAccInventory |
0 |
DTO |
0 |
| idcurrency |
idcurrency |
0 |
ID |
0 |
| Currency |
Currency |
0 |
DTO |
0 |
| idauxAccDepartment |
idauxAccDepartment |
0 |
ID |
0 |
| AuxAccDepartment |
AuxAccDepartment |
0 |
DTO |
0 |
| idauxAccProject |
idauxAccProject |
0 |
ID |
0 |
| AuxAccProject |
AuxAccProject |
0 |
DTO |
0 |
| idaccount |
idaccount |
0 |
ID |
0 |
| Account |
Account |
0 |
DTO |
0 |
| idauxAccCustomer |
idauxAccCustomer |
0 |
ID |
0 |
| AuxAccCustomer |
AuxAccCustomer |
0 |
DTO |
0 |
| idauxAccSupplier |
idauxAccSupplier |
0 |
ID |
0 |
| AuxAccSupplier |
AuxAccSupplier |
0 |
DTO |
0 |
| idexAuxAcc1 |
idexAuxAcc1 |
0 |
ID |
0 |
| ExAuxAcc1 |
ExAuxAcc1 |
0 |
DTO |
0 |
| idexAuxAcc2 |
idexAuxAcc2 |
0 |
ID |
0 |
| ExAuxAcc2 |
ExAuxAcc2 |
0 |
DTO |
0 |
| idexAuxAcc3 |
idexAuxAcc3 |
0 |
ID |
0 |
| ExAuxAcc3 |
ExAuxAcc3 |
0 |
DTO |
0 |
| idexAuxAcc4 |
idexAuxAcc4 |
0 |
ID |
0 |
| ExAuxAcc4 |
ExAuxAcc4 |
0 |
DTO |
0 |
| idexAuxAcc5 |
idexAuxAcc5 |
0 |
ID |
0 |
| ExAuxAcc5 |
ExAuxAcc5 |
0 |
DTO |
0 |
| idexAuxAcc6 |
idexAuxAcc6 |
0 |
ID |
0 |
| ExAuxAcc6 |
ExAuxAcc6 |
0 |
DTO |
0 |
| idexAuxAcc7 |
idexAuxAcc7 |
0 |
ID |
0 |
| ExAuxAcc7 |
ExAuxAcc7 |
0 |
DTO |
0 |
| idexAuxAcc8 |
idexAuxAcc8 |
0 |
ID |
0 |
| ExAuxAcc8 |
ExAuxAcc8 |
0 |
DTO |
0 |
| idexAuxAcc9 |
idexAuxAcc9 |
0 |
ID |
0 |
| ExAuxAcc9 |
ExAuxAcc9 |
0 |
DTO |
0 |
| idexAuxAcc10 |
idexAuxAcc10 |
0 |
ID |
0 |
| ExAuxAcc10 |
ExAuxAcc10 |
0 |
DTO |
0 |
| idsettleStyle |
idsettleStyle |
0 |
ID |
0 |
| QuantityDr |
借方数量 |
-1 |
Decimal |
0 |
| SettleStyle |
SettleStyle |
0 |
DTO |
0 |
| QuantityCr |
贷方数量 |
-1 |
Decimal |
0 |
| idaccountingPeriod |
idaccountingPeriod |
0 |
ID |
0 |
| AccountingPeriod |
AccountingPeriod |
0 |
DTO |
0 |
| AmountDr |
借方本币 |
-1 |
Decimal |
0 |
| AmountCr |
贷方本币 |
-1 |
Decimal |
0 |
| IdDocType |
凭证类别ID |
-1 |
ID |
0 |
| OrigAmountDr |
借方原币 |
-1 |
Decimal |
0 |
| OrigAmountCr |
贷方原币 |
-1 |
Decimal |
0 |
| DocType |
DocType |
0 |
DTO |
0 |
| OppositeAccountDTOs |
OppositeAccountDTOs |
0 |
DTOCollection |
0 |
| PeriodBeginOrigAmountDr |
期初原币借方金额 |
-1 |
Decimal |
0 |
| PeriodBeginOrigAmountCr |
期初原币贷方金额 |
-1 |
Decimal |
0 |
| PeriodBeginAmountDr |
期初本币借方金额 |
-1 |
Decimal |
0 |
| PeriodBeginAmountCr |
期初本币贷方金额 |
-1 |
Decimal |
0 |
| PeriodBeginQuantityDr |
期初借方数量 |
-1 |
Decimal |
0 |
| PeriodBeginQuantityCr |
期初贷方数量 |
-1 |
Decimal |
0 |
| isPeriodBegin |
是否期初 |
-1 |
Bool |
0 |
| BizNo |
业务单号 |
200 |
String |
0 |
| BizDate |
业务日期 |
-1 |
DateTime |
0 |
| billNo |
票据号 |
200 |
String |
0 |
| billDate |
票据日期 |
-1 |
DateTime |
0 |
| dueDate |
到期日 |
-1 |
DateTime |
0 |
| MakerId |
制单人ID |
-1 |
ID |
0 |
| DocDrCrType |
DocDrCrType |
-1 |
Int |
0 |