ARAP_Detail 数据库表名:应收应付明细账DTO
| 字段名称 |
字段说明 |
字段长度 |
字段类型 |
是否唯一 |
| ID |
主键 |
-1 |
ID |
0 |
| Code |
编号 |
30 |
String |
0 |
| Name |
名称 |
200 |
String |
0 |
| Year |
会计年度 |
-1 |
Int |
0 |
| Period |
会计期间 |
-1 |
Int |
0 |
| VoucherID |
单据ID |
-1 |
ID |
0 |
| voucherSettleState |
结款状态 |
-1 |
Int |
0 |
| VoucherCode |
单据编号 |
30 |
String |
0 |
| VoucherDate |
单据日期 |
-1 |
DateTime |
0 |
| VoucherDetailID |
单据明细ID |
-1 |
ID |
0 |
| DetailID |
明细ID |
-1 |
ID |
0 |
| DetailCode |
明细编码 |
50 |
String |
0 |
| DetailName |
明细名称 |
50 |
String |
0 |
| BusinessID |
业务类型对应单据ID |
-1 |
ID |
0 |
| BusinessCode |
业务类型处理编码 |
50 |
String |
0 |
| RegisterDate |
记帐日期 |
-1 |
DateTime |
0 |
| ExchangeRate |
汇率 |
-1 |
Decimal |
0 |
| OrigCashAmount |
现结金额 |
-1 |
Decimal |
0 |
| CashAmount |
现结金额(本币) |
-1 |
Decimal |
0 |
| OrigAmount |
应收应付金额 |
-1 |
Decimal |
0 |
| OrigSettleAmount |
已收已付金额 |
-1 |
Decimal |
0 |
| Amount |
应收应付金额(本币) |
-1 |
Decimal |
0 |
| SettleAmount |
已收已付金额(本币) |
-1 |
Decimal |
0 |
| OrigInAllowances |
其中折让 |
-1 |
Decimal |
0 |
| InAllowances |
其中折让(本币) |
-1 |
Decimal |
0 |
| AuditFlag |
是否审核 |
-1 |
Bool |
0 |
| AuditBussinessFlag |
业务是否审核 |
-1 |
Bool |
0 |
| PrepayFlag |
是否预收预付 |
-1 |
Bool |
0 |
| IsArFlag |
是否应收标志 |
-1 |
Bool |
0 |
| BussinessFlag |
业务标志 |
50 |
String |
0 |
| Flag |
是否业务系统产生标志 |
-1 |
Int |
0 |
| ArrivalDate |
到期日 |
-1 |
DateTime |
0 |
| Memo |
备注 |
200 |
String |
0 |
| ExtendFlag |
扩展标志 |
-1 |
Int |
0 |
| AccountingYear |
凭证会计年度 |
-1 |
Int |
0 |
| AccountingPeriod |
凭证会计期间 |
-1 |
Int |
0 |
| DocId |
凭证ID |
36 |
String |
0 |
| DocClass |
凭证类别 |
36 |
String |
0 |
| DocNo |
凭证编号 |
36 |
String |
0 |
| IsCarriedForwardOut |
是否已结转 |
-1 |
Bool |
0 |
| IsCarriedForwardIn |
是否结转来的单据 |
-1 |
Bool |
0 |
| SaleOrderCode |
销售订单号 |
50 |
String |
0 |
| SaleOrderID |
销售订单ID |
-1 |
ID |
0 |
| SourceOrderCode |
源头订单号 |
50 |
String |
0 |
| SourceOrderID |
源头订单ID |
-1 |
ID |
0 |
| idpartner |
idpartner |
0 |
ID |
0 |
| CancelAssociationCodes |
核销关联单据号 |
100 |
String |
0 |
| DetailType |
明细类型 |
50 |
String |
0 |
| iddepartment |
iddepartment |
0 |
ID |
0 |
| VoucherTimeStamp |
时间戳 |
50 |
String |
0 |
| YearPeriod |
年期间 |
50 |
String |
0 |
| idperson |
idperson |
0 |
ID |
0 |
| HeadPriuserdefnvc1 |
头自定义项私有1 |
60 |
String |
0 |
| idcurrency |
idcurrency |
0 |
ID |
0 |
| HeadPriuserdefdecm1 |
头自定义项数字私有1 |
-1 |
Decimal |
0 |
| HeadPriuserdefnvc2 |
头自定义项私有2 |
60 |
String |
0 |
| HeadPriuserdefdecm2 |
头自定义项数字私有2 |
-1 |
Decimal |
0 |
| idbusiType |
idbusiType |
0 |
ID |
0 |
| HeadPriuserdefnvc3 |
头自定义项私有3 |
60 |
String |
0 |
| idvoucherType |
idvoucherType |
0 |
ID |
0 |
| HeadPriuserdefdecm3 |
头自定义项数字私有3 |
-1 |
Decimal |
0 |
| HeadPriuserdefnvc4 |
头自定义项私有4 |
60 |
String |
0 |
| idarapVoucherType |
idarapVoucherType |
0 |
ID |
0 |
| HeadPriuserdefdecm4 |
头自定义项数字私有4 |
-1 |
Decimal |
0 |
| HeadPriuserdefnvc5 |
头自定义项私有5 |
60 |
String |
0 |
| HeadPriuserdefdecm5 |
头自定义项数字私有5 |
-1 |
Decimal |
0 |
| HeadPriuserdefnvc6 |
头自定义项私有6 |
60 |
String |
0 |
| HeadPriuserdefdecm6 |
头自定义项数字私有6 |
-1 |
Decimal |
0 |
| HeadPubuserdefnvc1 |
头自定义项公有1 |
60 |
String |
0 |
| HeadPubuserdefdecm1 |
头自定义项数字公有1 |
-1 |
Decimal |
0 |
| HeadPubuserdefdecm2 |
头自定义项数字公有2 |
-1 |
Decimal |
0 |
| idnoSettlePartner |
idnoSettlePartner |
0 |
ID |
0 |
| HeadPubuserdefnvc2 |
头自定义项公有2 |
60 |
String |
0 |
| HeadPubuserdefdecm3 |
头自定义项数字公有3 |
-1 |
Decimal |
0 |
| idsourceOrderType |
idsourceOrderType |
0 |
ID |
0 |
| HeadPubuserdefnvc3 |
头自定义项公有3 |
60 |
String |
0 |
| HeadPubuserdefdecm4 |
头自定义项数字公有4 |
-1 |
Decimal |
0 |
| HeadPubuserdefnvc4 |
头自定义项公有4 |
60 |
String |
0 |
| HeadPubuserdefdecm5 |
头自定义项数字公有5 |
-1 |
Decimal |
0 |
| HeadPubuserdefnvc5 |
头自定义项公有5 |
60 |
String |
0 |
| HeadPubuserdefdecm6 |
头自定义项数字公有6 |
-1 |
Decimal |
0 |
| HeadPubuserdefnvc6 |
头自定义项公有6 |
60 |
String |
0 |
| DetailPriuserdefnvc1 |
体自定义项私有1 |
60 |
String |
0 |
| DetailPriuserdefdecm1 |
体自定义项数字私有1 |
-1 |
Decimal |
0 |
| DetailPriuserdefnvc2 |
体自定义项私有2 |
60 |
String |
0 |
| DetailPriuserdefdecm2 |
体自定义项数字私有2 |
-1 |
Decimal |
0 |
| DetailPriuserdefnvc3 |
体自定义项私有3 |
60 |
String |
0 |
| idproject |
idproject |
0 |
ID |
0 |
| DetailPriuserdefdecm3 |
体自定义项数字私有3 |
-1 |
Decimal |
0 |
| DetailPriuserdefnvc4 |
体自定义项私有4 |
60 |
String |
0 |
| DetailPriuserdefdecm4 |
体自定义项数字私有4 |
-1 |
Decimal |
0 |
| DetailPubuserdefnvc1 |
体自定义项共有1 |
60 |
String |
0 |
| DetailPubuserdefdecm1 |
体自定义项数字共有1 |
-1 |
Decimal |
0 |
| DetailPubuserdefnvc2 |
体自定义项共有2 |
60 |
String |
0 |
| DetailPubuserdefdecm2 |
体自定义项数字共有2 |
-1 |
Decimal |
0 |
| DetailPubuserdefnvc3 |
体自定义项共有3 |
60 |
String |
0 |
| DetailPubuserdefdecm3 |
体自定义项数字共有3 |
-1 |
Decimal |
0 |
| DetailPubuserdefnvc4 |
体自定义项共有4 |
60 |
String |
0 |
| DetailPubuserdefdecm4 |
体自定义项数字共有4 |
-1 |
Decimal |
0 |
| CreatedTime |
CreatedTime |
-1 |
DateTime |
0 |
| SequenceNumber |
顺序号 |
-1 |
Int |
0 |
| IdMarketingOrgan |
营销机构ID |
-1 |
ID |
0 |
| Ts |
分布时间戳 |
-1 |
TimeStamp |
0 |
| Updated |
更新时间 |
32 |
DateTime |
0 |
| UpdatedBy |
更新者 |
32 |
String |
0 |
| Partner |
Partner |
0 |
DTO |
0 |
| Department |
Department |
0 |
DTO |
0 |
| Person |
Person |
0 |
DTO |
0 |
| Currency |
Currency |
0 |
DTO |
0 |
| BusiType |
BusiType |
0 |
DTO |
0 |
| VoucherType |
VoucherType |
0 |
DTO |
0 |
| ArapVoucherType |
ArapVoucherType |
0 |
DTO |
0 |
| NoSettlePartner |
NoSettlePartner |
0 |
DTO |
0 |
| SourceOrderType |
SourceOrderType |
0 |
DTO |
0 |
| Project |
Project |
0 |
DTO |
0 |
| IdDetailProject |
IdDetailProject |
-1 |
ID |
0 |
| DetailProject |
DetailProject |
0 |
DTO |
0 |
| isRollInFlag |
应收冲应、应收冲应付转入标志 |
-1 |
Bool |
0 |
| sourceVoucherCode |
来源单号 |
200 |
String |
0 |
| sourceVoucherID |
来源单ID |
-1 |
ID |
0 |
| PurchaseOrderCode |
采购订单号 |
50 |
String |
0 |
| PurchaseOrderID |
采购订单ID |
-1 |
ID |
0 |
| MarketingOrgan |
营销机构 |
0 |
DTO |
0 |