UFTData

ARAP_Cancel_FirstDetail Table  (ARAP 往来现金)  [T+12.1]

Summary

收付款核销明细DTO

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  detailName (T+12.1) 明细名称 nvarchar50 True 
  detailID (T+12.1) 明细ID intTrue 
  idvouchertype (T+12.1) 单据类型ID intTrue 
  saleordercode (T+12.1) 销售订单号 nvarchar50 True 
  iddepartment (T+12.1) 部门ID intTrue 
  origCurrentAmount (T+12.1) 冲销金额 decimal13 True 
  idproject (T+12.1) 项目ID intTrue 
  vouchertimestamp (T+12.1) 时间戳 nvarchar32 True 
  ID (T+12.1) 主键 intFalse 
  IdDetailProject (T+12.1) 明细项目ID intTrue 
  detailCode (T+12.1) 明细编码 nvarchar50 True 
  origAmount (T+12.1) 原币金额 decimal13 True 
  CancelAmount (T+12.1) 累计核销金额(本币) decimal13 True 
  sourceorderid (T+12.1) 源头订单ID intTrue 
  ts (T+12.1) 分布时间戳 timestampFalse 
  currentAmount (T+12.1) 冲销金额(本币) decimal13 True 
  createdtime (T+12.1) 创建时间 datetimeTrue 
  Allowances (T+12.1) 折让(本币) decimal13 True 
  Amount (T+12.1) 金额 decimal13 True 
  idArapCancelDTO (T+12.1) 核销类型ID intTrue 
  exchangeRate (T+12.1) 汇率 decimal13 True 
  IdMember (T+12.1) 会员ID intTrue 
  sourceordercode (T+12.1) 源头订单号 nvarchar50 True 
  IdBusiType (T+12.1) 业务类型ID intTrue 
  idnosettlepartner (T+12.1) 客户ID intTrue 
  idcurrency (T+12.1) 币种ID intTrue 
  idsourceordertype (T+12.1) 来源单据类型ID intTrue 
  code (T+12.1) 编号 nvarchar30 True 
  voucherID (T+12.1) 单据ID intTrue 
  origVoucherNoSettleAmount (T+12.1) 单据未结算金额 decimal13 True 
  idSettlePartner (T+12.1) 结算客户ID intTrue 
  orignosettleamount (T+12.1) 未结算金额 decimal13 True 
  origVoucherAmount (T+12.1) 单据金额 decimal13 True 
  SourceVoucherMemo (T+12.1) 来源单据备注 nvarchar200 True 
  saleorderid (T+12.1) 销售订单ID intTrue 
  OrigAllowances (T+12.1) 折让 decimal13 True 
  arrivalDate (T+12.1) 到期日 datetimeTrue 
  idperson (T+12.1) 业务员ID intTrue 
  voucherDate (T+12.1) 单据日期 datetimeTrue 
  voucherDetailID (T+12.1) 单据明细ID intTrue 
  voucherCode (T+12.1) 单据编号 nvarchar30 True 
  nosettleamount (T+12.1) 未结算金额(本币) decimal13 True 
  OrigCancelAmount (T+12.1) 核销金额 decimal13 True 
  IsSelected (T+12.1) 是否被选中 tinyintTrue 

Send feedback

Copyright 2016 Chanjet Inc.