UFTData

ST_RDRecord_b_RetailAmountTmep Table  (ST 库存核算)  [T+16.0]

Summary

零售数据升级临时表(零售金额取记账金额改为取零售金额) 备份数据临时表

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  saleAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionVoucherCodes (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  OrigCumulativeExpenseAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  TaxManuPrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  pubuserdefdecm2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  docid (T+16.0) 同ST_RDRecord_b字段 nvarchar76 True 
  estimatedAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  freeItem6 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  cumulativePurchaseArrivalQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  IsModifiedPrice (T+16.0) 同ST_RDRecord_b字段 tinyintTrue 
  TaxPrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  idbusiTypeByMergedFlow (T+16.0) 同ST_RDRecord_b字段 intTrue 
  SentBaseQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ID (T+16.0) 同ST_RDRecord_b字段 intFalse 
  defectiveQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionSingleGroupID (T+16.0) 同ST_RDRecord_b字段 nvarchar300 True 
  idIndirectSourceVoucherType (T+16.0) 同ST_RDRecord_b字段 intTrue 
  distributedQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  MaterialFee (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  receiveVoucherDetailId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  CurrentSettleManuAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  price2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  idbaseunit (T+16.0) 同ST_RDRecord_b字段 intTrue 
  OrigTS (T+16.0) 同ST_RDRecord_b字段 timestampTrue 
  backFlushSourceVoucherDetailId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  idBackFlushSourceVoucherType (T+16.0) 同ST_RDRecord_b字段 intTrue 
  createdtime (T+16.0) 同ST_RDRecord_b字段 datetimeTrue 
  CumPurchaseShrinkageQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  RetailNoTaxPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  taxFlag (T+16.0) 同ST_RDRecord_b字段 tinyintTrue 
  cumulativeSettlementSubQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  OrigShrinkageQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PriceStrategySchemeIds (T+16.0) 同ST_RDRecord_b字段 nvarchar800 True 
  IdMarketingOrgan (T+16.0) 同ST_RDRecord_b字段 intTrue 
  PriceStrategySchemeNames (T+16.0) 同ST_RDRecord_b字段 nvarchar2000 True 
  NotSettleQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  CostAccountStatus (T+16.0) 同ST_RDRecord_b字段 intTrue 
  sourceVoucherDetailId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  IsPromotionPresent (T+16.0) 同ST_RDRecord_b字段 tinyintTrue 
  dispatchAdjust (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  idwarehouse (T+16.0) 同ST_RDRecord_b字段 intTrue 
  origTax (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  origTaxPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  cumulativeSettlementAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  priuserdefnvc3 (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  ManuPrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionPriceBatchType (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  VendorInventoryPrice (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  Discount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  distributedQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  pubuserdefnvc1 (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  batch (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  cumulativeEstimateAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ManufactureOrderDetailId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  SerialNumbers (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  pubuserdefdecm3 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  freeItem1 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  productFreeItem0 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  productFreeItem7 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  compositionQuantity (T+16.0) 同ST_RDRecord_b字段 nvarchar200 True 
  updatedBy (T+16.0) 同ST_RDRecord_b字段 nvarchar64 True 
  saleOrderCode (T+16.0) 同ST_RDRecord_b字段 nvarchar60 True 
  SentBaseAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ManuPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  expiryDate (T+16.0) 同ST_RDRecord_b字段 datetimeTrue 
  ShrinkageBaseQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  idsubunit (T+16.0) 同ST_RDRecord_b字段 intTrue 
  freeItem4 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  productFreeItem4 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  DataSource (T+16.0) 同ST_RDRecord_b字段 intTrue 
  PromotionBatchMemo (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  cumulativeSaleDispatchQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  CurrentEstimateManuAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  differencequantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ShrinkageSubQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  origTaxSalePrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  cumulativeSettlementQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  totalAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  DiscountRate (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  SuperSourceVoucherTypeCode (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  taxSalePrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  TaxManuPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  backFlushSourceVoucherid (T+16.0) 同ST_RDRecord_b字段 intTrue 
  productFreeItem1 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  UnAccountedCarriedforwardFlag (T+16.0) 同ST_RDRecord_b字段 bitTrue 
  CumulativeExpenseSubQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  productFreeItem2 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  CurrentEstimateManuQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  backFlushSourceVoucherCode (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  CumReturnQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  CumPurchaseShrinkageQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  Retailprice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionVoucherIds (T+16.0) 同ST_RDRecord_b字段 nvarchar800 True 
  memo (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  cumulativeSaleDispatchQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  priuserdefdecm1 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PriceStrategyTypeName (T+16.0) 同ST_RDRecord_b字段 nvarchar800 True 
  CumReturnQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  VendorInventoryName (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  ManufactureOrderMaterialDetailId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  taxSaleAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  InvBarCode (T+16.0) 同ST_RDRecord_b字段 nvarchar256 True 
  baseQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  estimatedPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionPresentGroupID (T+16.0) 同ST_RDRecord_b字段 nvarchar300 True 
  idproject (T+16.0) 同ST_RDRecord_b字段 intTrue 
  BoxNumber (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  OrigTaxManuPrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  baseEstimatedPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  productFreeItem9 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  idProductInventory (T+16.0) 同ST_RDRecord_b字段 intTrue 
  priuserdefnvc2 (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  priuserdefdecm3 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  SourceVoucherIdByMergedFlow (T+16.0) 同ST_RDRecord_b字段 intTrue 
  SourceVoucherDetailIdByMergedFlow (T+16.0) 同ST_RDRecord_b字段 intTrue 
  pubuserdefnvc2 (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  productFreeItem5 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  taxSalePrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  materialAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  TaxManuAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ManufactureOrderCode (T+16.0) 同ST_RDRecord_b字段 nvarchar60 True 
  price (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  DetailMemo (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  OrigDiscount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  differencequantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  MonthAdjustMenuAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  cumulativeSettlementBaseQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  salePrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  OrigManuPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  OrigDiscountPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PurchaseOrderCode (T+16.0) 同ST_RDRecord_b字段 nvarchar200 True 
  PromotionPresentBatchInfo (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  RetailAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  receiveAdjust (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  idsourceVoucherTypeByMergedFlow (T+16.0) 同ST_RDRecord_b字段 intTrue 
  CardTicketDiscountAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionSingleTypeID (T+16.0) 同ST_RDRecord_b字段 intTrue 
  pubuserdefdecm1 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  LastModifiedField (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  priuserdefnvc4 (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  code (T+16.0) 同ST_RDRecord_b字段 nvarchar60 True 
  ManufactureOrderId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  idunit (T+16.0) 同ST_RDRecord_b字段 intTrue 
  sourceVoucherId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  idinventory (T+16.0) 同ST_RDRecord_b字段 intTrue 
  updated (T+16.0) 同ST_RDRecord_b字段 datetimeTrue 
  idsourcevouchertype (T+16.0) 同ST_RDRecord_b字段 intTrue 
  SourceVoucherCodeByMergedFlow (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  origSaleAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  isNoModify (T+16.0) 同ST_RDRecord_b字段 nvarchar2000 True 
  productFreeItem6 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  pubuserdefnvc3 (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  priuserdefdecm4 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  quantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  RetailNoTaxAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  origTaxPrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  origTaxSalePrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  EstimateManuAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  origTaxSaleAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  quantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  changeRate (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  receiveDate (T+16.0) 同ST_RDRecord_b字段 datetimeTrue 
  isNewMaterialFeed (T+16.0) 同ST_RDRecord_b字段 tinyintTrue 
  receiveVoucherCode (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  ts (T+16.0) 同ST_RDRecord_b字段 varbinary100 True 
  CumulativeExpenseQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  idExaminer (T+16.0) 同ST_RDRecord_b字段 intTrue 
  origTaxAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  taxAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  productFreeItem3 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  basePrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  subQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ExaminerDate (T+16.0) 同ST_RDRecord_b字段 datetimeTrue 
  receiveVoucherId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  indirectSourceVoucherDetailId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  PartnerInventoryName (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  CumulativeExpenseAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  inventoryLocation (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  PurchaseOrderId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  origPrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionSingleVoucherCode (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  pubuserdefdecm4 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  freeItem7 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  feeAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PriceStrategyTypeId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  PromotionPresentTypeID (T+16.0) 同ST_RDRecord_b字段 intTrue 
  idRDRecordDTO (T+16.0) 同ST_RDRecord_b字段 intTrue 
  taxPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  CumulativeExpenseBaseQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  sourceVoucherCode (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  AccountTime (T+16.0) 同ST_RDRecord_b字段 datetimeTrue 
  SNCount (T+16.0) 同ST_RDRecord_b字段 intTrue 
  arrivalQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  freeItem3 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  kitQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  isManualCost (T+16.0) 同ST_RDRecord_b字段 tinyintTrue 
  EstimateManuPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  OrigShrinkageQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  CashbackWay (T+16.0) 同ST_RDRecord_b字段 intTrue 
  OrigManuAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  freeItem9 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  OrigManuPrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ProductionDate (T+16.0) 同ST_RDRecord_b字段 datetimeTrue 
  freeItem8 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  taxRate (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  idunit2 (T+16.0) 同ST_RDRecord_b字段 intTrue 
  NotSettleQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  OrigTaxManuPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  freeItem2 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  CustomerInventoryPrice (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  PromotionSingleVoucherID (T+16.0) 同ST_RDRecord_b字段 intTrue 
  feeAdjust (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  tax (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  isCostAccounted (T+16.0) 同ST_RDRecord_b字段 tinyintTrue 
  freeItem0 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  amount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  defectiveQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  priuserdefdecm2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  cumulativeSettlementQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  priuserdefnvc1 (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  saleOrderId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  isAdjustQuantityFeed (T+16.0) 同ST_RDRecord_b字段 tinyintTrue 
  CumulativeExpenseQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  freeItem5 (T+16.0) 同ST_RDRecord_b字段 nvarchar600 True 
  manHour (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  pubuserdefnvc4 (T+16.0) 同ST_RDRecord_b字段 nvarchar1000 True 
  SourceOrderDetailId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  arrivalQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionPresentBatchType (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  origSalePrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  productFreeItem8 (T+16.0) 同ST_RDRecord_b字段 nvarchar120 True 
  salePrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  baseManuPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  kitQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionPresentVoucherCode (T+16.0) 同ST_RDRecord_b字段 nvarchar100 True 
  origAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  IsPresent (T+16.0) 同ST_RDRecord_b字段 tinyintTrue 
  ShrinkageQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ManuFeeDiff (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ManuAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  ShrinkageQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  cumulativePurchaseArrivalQuantity2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  origSalePrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  RDDivideFee (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  origPrice (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionPriceBatchInfo (T+16.0) 同ST_RDRecord_b字段 nvarchar400 True 
  CurrentSettleManuQuantity (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  saleOrderDetailId (T+16.0) 同ST_RDRecord_b字段 intTrue 
  OrigTaxManuAmount (T+16.0) 同ST_RDRecord_b字段 decimal13 True 
  PromotionPresentVoucherID (T+16.0) 同ST_RDRecord_b字段 intTrue 
  estimatedPrice2 (T+16.0) 同ST_RDRecord_b字段 decimal13 True 

Send feedback

Copyright 2016 Chanjet Inc.