UFTData

RE_ShiftVoucher Table  (RE 零售管理)  [T+12.1]

Summary

对账收款DTO

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  ismodifiedcode (T+12.1) 是否手工修改单据编码 tinyintTrue 
  docno (T+12.1) 凭证编号 nvarchar36 True 
  idmarketingorgan (T+12.1) 所属营销机构ID intTrue 
  posname (T+12.1) POS名称 nvarchar50 True 
  docclass (T+12.1) 凭证类别 nvarchar36 True 
  workingdate (T+12.1) 上班日期 datetimeTrue 
  totalsettleamount (T+12.1) 结算总金额 decimal13 True 
  imprestamount (T+12.1) 增减备用金金额 decimal13 True 
  shifttime (T+12.1) 交班时间 charTrue 
  ID (T+12.1) 主键 bigintFalse 
  iscarriedforwardout (T+12.1) 是否已结转 tinyintTrue 
  voucherdiscountamount (T+12.1) 整单折扣金额 decimal13 True 
  voucherdate (T+12.1) 单据日期 datetimeTrue 
  iscarriedforwardin (T+12.1) 是否结转来的单据 tinyintTrue 
  poscode (T+12.1) POS编码 nvarchar50 True 
  code (T+12.1) 编号 nvarchar50 True 
  idstore (T+12.1) 门店ID intTrue 
  auditor (T+12.1) 审核人 nvarchar50 True 
  autoid (T+12.2) 自增ID intFalse 
  ReceiveDate (T+12.2) 收款日期 datetimeTrue 
  voucherstate (T+12.1) 单据状态 intTrue 
  retailamount (T+12.1) 销售金额 decimal13 True 
  sequencenumber (T+12.1) 顺序号 intTrue 
  shift (T+12.1) 班次 intTrue 
  accountingyear (T+12.1) 会计年度 intTrue 
  maker (T+12.1) 制单人 nvarchar50 True 
  initialamount (T+12.1) 钱箱初始余额 decimal13 True 
  usercode (T+12.1) 收银员编码 nvarchar50 True 
  GiveChangeForStorage (T+12.2) 找零转储值金额 decimal13 True 
  name (T+12.1) 名称 nvarchar200 True 
  totalcount (T+12.1) 水单总数 intTrue 
  removeamount (T+12.1) 删除金额 decimal13 True 
  price (T+12.1) 单价 decimal13 True 
  docid (T+12.1) 凭证ID nvarchar36 True 
  accountingperiod (T+12.1) 会计期间 intTrue 
  retailreturncount (T+12.1) 退货商品数 decimal13 True 
  memo (T+12.1) 备注 nvarchar200 True 
  auditorid (T+12.1) 审核人ID intTrue 
  reviser (T+12.1) 修改人 nvarchar50 True 
  WipeChange (T+12.2) 抹零 decimal13 True 
  workingtime (T+12.1) 上班时间 charTrue 
  userid (T+12.1) 用户ID intTrue 
  retailcount (T+12.1) 销售商品数 decimal13 True 
  username (T+12.1) 收银员姓名 nvarchar50 True 
  ts (T+12.1) 分布时间戳 timestampFalse 
  removecount (T+12.1) 删除商品数 decimal13 True 
  makerid (T+12.1) 制单人ID intTrue 
  iscancel (T+12.1) 结算状态 intTrue 
  createdtime (T+12.1) 创建时间 datetimeTrue 
  madedate (T+12.1) 制单日期 datetimeTrue 
  returnamount (T+12.1) 退货金额 decimal13 True 
  auditeddate (T+12.1) 审核日期 datetimeTrue 
  shiftdate (T+12.1) 交班日期 datetimeTrue 

Send feedback

Copyright 2019 Chanjet Inc.