UFTData

SA_CreditOccupancyHistory Table  (SA 销售管理)  [T+12.2]

Summary

更新信用历史记录

Remark

用于保存每次更新信用的历史记录表

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  voucherCode (T+12.2) 单据编码 varchar200 True 
  outunsettleamount (T+12.2) 保存时点已出货未立账 decimal13 True 
  idcustomer (T+12.2) 客户id intTrue 
  id (T+12.2) 主键id intFalse 
  orderunoutamount (T+12.2) 保存时已订未出货点金额 decimal13 True 
  orderunoutamountForAudit (T+12.2) 审核时点已订未出货金额 decimal13 True 
  receiveuncancelamount (T+12.2) 保存时点已出货未结款金额 decimal13 True 
  outunsettleamountForAudit (T+12.2) 审核时点已出货未立账 decimal13 True 
  expenseSettleAmount (T+12.2) 保存时点费用单金额 decimal13 True 
  salesettleamount (T+12.2) 保存时点销售应收款金额 decimal13 True 
  operationType (T+12.2) 操作类型 varchar20 True 
  updated (T+12.2) 更新时间 datetimeTrue 
  idclerk (T+12.2) 业务员id intTrue 
  ts (T+12.2) 时间戳 timestampFalse 
  incomeunsettleamountForAudit (T+12.2) 审核时点收入未结款金额 decimal13 True 
  expenseSettleAmountForAudit (T+12.2) 审核时点费用单未结款金额 decimal13 True 
  incomeunsettleamount (T+12.2) 保存时点收入未结款金额 decimal13 True 
  salesettleamountForAudit (T+12.2) 审核时点销售应收款金额 decimal13 True 
  receiveuncancelamountForAudit (T+12.2) 审核时点已出货未立账金额 decimal13 True 

Send feedback

Copyright 2019 Chanjet Inc.