GL_ReferenceAuxiliaryInfo 数据库表名:参考辅助信息DTO
| 字段名称 |
字段说明 |
字段长度 |
字段类型 |
是否唯一 |
| ID |
主键 |
-1 |
ID |
0 |
| Code |
编号 |
30 |
String |
0 |
| Name |
名称 |
200 |
String |
0 |
| DCdirection |
借贷方向 |
-1 |
Enum |
0 |
| BillNo |
票据号 |
50 |
String |
0 |
| BillDate |
票据日期 |
-1 |
DateTime |
0 |
| BizDate |
业务日期 |
-1 |
DateTime |
0 |
| BizNo |
业务单号 |
50 |
String |
0 |
| DueDate |
到期日 |
-1 |
DateTime |
0 |
| OrigAmount |
原币金额 |
-1 |
Decimal |
0 |
| Amount |
本币金额 |
-1 |
Decimal |
0 |
| Quantity |
数量 |
-1 |
Decimal |
0 |
| ExchangeRate |
汇率 |
-1 |
Decimal |
0 |
| Price |
单价 |
-1 |
Decimal |
0 |
| CreatedTime |
CreatedTime |
-1 |
DateTime |
0 |
| SequenceNumber |
顺序号 |
-1 |
Int |
0 |
| Ts |
分布时间戳 |
-1 |
TimeStamp |
0 |
| Updated |
更新时间 |
32 |
DateTime |
0 |
| UpdatedBy |
更新者 |
32 |
String |
0 |
| idaccount |
idaccount |
0 |
ID |
0 |
| Account |
Account |
0 |
DTO |
0 |
| idcurrency |
idcurrency |
0 |
ID |
0 |
| Currency |
Currency |
0 |
DTO |
0 |
| idsettlestyle |
idsettlestyle |
0 |
ID |
0 |
| Settlestyle |
Settlestyle |
0 |
DTO |
0 |
| idauxAccInventory |
idauxAccInventory |
0 |
ID |
0 |
| AuxAccInventory |
AuxAccInventory |
0 |
DTO |
0 |
| idauxAccPerson |
idauxAccPerson |
0 |
ID |
0 |
| AuxAccPerson |
AuxAccPerson |
0 |
DTO |
0 |
| idauxAccDepartment |
idauxAccDepartment |
0 |
ID |
0 |
| AuxAccDepartment |
AuxAccDepartment |
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 |
| idreferenceEntryDTO |
idreferenceEntryDTO |
0 |
ID |
0 |
| ReferenceEntry |
ReferenceEntry |
0 |
DTO |
0 |
| idclerk |
idclerk |
0 |
ID |
0 |
| Clerk |
Clerk |
0 |
DTO |
0 |
| unit |
计量单位 |
200 |
String |
0 |
| idauxAccProject |
idauxAccProject |
0 |
ID |
0 |
| AuxAccProject |
AuxAccProject |
0 |
DTO |
0 |
| idbankAccount |
账号ID |
-1 |
ID |
0 |
| BankAccount |
BankAccount |
0 |
DTO |
0 |
| ReferenceDocId |
参考凭证ID |
-1 |
ID |
0 |