UFTData

AA_DR_Store Table  (AA 基础设置)  [T+12.1]

Summary

POS机DTO

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  buyerAddressUpdate (T+12.1) buyerAddressUpdate tinyintTrue 
  id (T+12.1) 主键 intFalse 
  pickedUnLock (T+12.1) pickedUnLock tinyintTrue 
  shopFullName (T+12.1) shopFullName nvarchar50 True 
  shorthand (T+12.1) 助记码 nvarchar50 True 
  name (T+12.1) 名称 nvarchar200 True 
  haveSellerRemark (T+12.1) haveShellerRemark tinyintTrue 
  idmembertype (T+12.1) 会员类型id intTrue 
  priuserdefnvc3 (T+12.1) 字符专用自定义项3 nvarchar500 True 
  paidOrderAutoCheck (T+12.1) paidOrderAutoCheck tinyintTrue 
  cashOnDeliveryOrder (T+12.1) cashOnDeliveryOrder tinyintTrue 
  virtualInvertory (T+12.1) virtualInvertory decimal13 True 
  shipmentsAutoUpType (T+12.1) shipmentsAutoUptype tinyintTrue 
  priuserdefdecm5 (T+12.1) 数值自定义项5 decimal13 True 
  idperson (T+12.1) 员工id intTrue 
  correspondwarehouse (T+12.1) crrespondwarehouse nvarchar200 True 
  priuserdefdecm4 (T+12.1) 数值自定义项4 decimal13 True 
  telephone (T+12.1) 联系电话 nvarchar50 True 
  paidNumber (T+12.1) paidNumber tinyintTrue 
  ts (T+12.1) 分布时间戳 timestampFalse 
  address (T+12.1) 发货地址 nvarchar50 True 
  wholesaleType (T+12.1) wholesaletype tinyintTrue 
  upInventoryNumberPerce (T+12.1) upinvertoryNumber decimalTrue 
  idbankaccount (T+12.1) 账户id intTrue 
  priuserdefnvc4 (T+12.1) 字符专用自定义项4 nvarchar500 True 
  sequencenumber (T+12.1) 顺序号 intTrue 
  idsettlementcustomer (T+12.1) 结算客户id intTrue 
  shopWebset (T+12.1) shopwebset nvarchar100 True 
  nonPayNumber (T+12.1) nonPayNumber tinyintTrue 
  isdeductionforepost (T+12.1) 扣点前记账  tinyintTrue 
  shopType (T+12.1) shopType intTrue 
  autoDownInventory (T+12.1) aautoDownInvertory tinyintTrue 
  checkaddress (T+12.1) 坐标地址 nvarchar200 True 
  priuserdefdecm3 (T+12.1) 数值自定义项3 decimal13 True 
  idmarketingorgan (T+12.1) 所属营销机构ID intTrue 
  idReceiveSettleStyle (T+12.1) 收款结算方式id intTrue 
  idinventoryclass (T+12.1) 存货分类id intTrue 
  LastRefundTime (T+12.1) Lastrefundtime datetimeTrue 
  LastUpdateTime (T+12.1) lastUpdateTime datetimeTrue 
  updatedBy (T+12.1) 更新者 nvarchar32 True 
  idwarehouse (T+12.1) 仓库id intTrue 
  iddepartment (T+12.1) 部门id intTrue 
  iddefalutshipments (T+12.1) iddeffalutshipment intTrue 
  autoLogistic (T+12.1) autoLogistic nvarchar10 True 
  updated (T+12.1) 更新时间 datetimeTrue 
  branchdistributionway (T+12.1) 补货配送方式 intTrue 
  createdtime (T+12.1) CreatedTime datetimeTrue 
  sellerNo (T+12.1) sellerNo nvarchar50 True 
  autoUnLock (T+12.1) autoUnlock tinyintTrue 
  abbreviation (T+12.1) 门店简称 nvarchar50 True 
  priuserdefnvc5 (T+12.1) 字符专用自定义项5 nvarchar500 True 
  code (T+12.1) 编号 nvarchar30 True 
  autoDownAddInvertory (T+12.1) autoDownAddInvertory tinyintTrue 
  disabled (T+12.1) 停用 tinyintTrue 
  priuserdefnvc1 (T+12.1) 字符专用自定义项1 nvarchar500 True 
  idunit (T+12.1) 单位id intTrue 
  cashshieldnum (T+12.1) 加密POS数量 intTrue 
  idcustomer (T+12.1) 客户id intTrue 
  applyRefund (T+12.1) applyReffund tinyintTrue 
  iddistrict (T+12.1) 地区id intTrue 
  priuserdefnvc2 (T+12.1) 字符专用自定义项2 nvarchar500 True 
  priuserdefdecm1 (T+12.1) 数值专用自定义项1 decimal13 True 
  haveBuyerMessage (T+12.1) haveBuyerMessage tinyintTrue 
  priuserdefdecm2 (T+12.1) 数值专用自定义项2 decimal13 True 
  storetype (T+12.1) 门店类型 intTrue 
  idpartnerclass (T+12.1) 往来单位id intTrue 
  memo (T+12.1) 备注 nvarchar50 True 
  priceMode (T+12.1) PriceMode intTrue 

Send feedback

Copyright 2019 Chanjet Inc.