临时表:临时凭证来源单据信息
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
vOrigAmount (T+12.2) | 单据原币金额 | decimal | 13 | True | |
Memo (T+12.2) | 备注 | nvarchar | 200 | True | |
idsupplier (T+12.2) | 供应商ID | int | 4 | True | |
iddepartment (T+12.2) | 部门ID | int | 4 | True | |
srcVoucherTimeStamp (T+12.1) | 来源单据时间戳 | nvarchar | 200 | True | |
idcurrency (T+12.2) | 币种ID | int | 4 | True | |
IsNoSaledDispatchVoucher (T+12.3) | 销售出库单是否处理为发出商品 | int | 4 | True | |
code (T+12.1) | 编号 | nvarchar | 30 | True | |
idinrdstyle (T+12.2) | 入库类别ID | int | 4 | True | |
ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
idSrcBusiType (T+12.1) | 来源单据业务类型ID | int | 4 | True | |
SrcAuditedDate (T+12.3) | 审核日期 | datetime | 8 | True | |
idTransactionDocDTO (T+12.1) | 交易凭证头ID | int | 4 | True | |
vAmount (T+12.2) | 单据本币金额 | decimal | 13 | True | |
carryforwardtype (T+12.1) | 结转类型 | int | 4 | True | |
srcVoucherNo (T+12.1) | 来源单据编号 | nvarchar | 200 | True | |
idcustomer (T+12.2) | 客户ID | int | 4 | True | |
idoutrdstyle (T+12.2) | 出库类别ID | int | 4 | True | |
idclerck (T+12.2) | 业务员ID | int | 4 | True | |
idTempDocDTO (T+12.1) | 临时凭证id | int | 4 | True | |
id (T+12.1) | 主键 | int | 4 | False | |
srcvoucherid (T+12.1) | 来源单据ID | int | 4 | True | |
idSrcVoucherType (T+12.1) | 来源单据类型ID | int | 4 | True | |
srcVoucherDate (T+12.1) | 来源单据日期 | datetime | 8 | True | |
InvoiceCode (T+12.2) | 发票编号 | nvarchar | 200 | True |
Copyright 2016 Chanjet Inc.