数据清除备份表，已废弃
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| PaymentStatus (T+16.0) | int | 4 | True | ||
| id (T+16.0) | int | 4 | False | ||
| issaleout (T+16.0) | int | 4 | True | ||
| cardTicketDiscountAmount (T+16.0) | decimal | 13 | True | ||
| storagesettleamount (T+16.0) | decimal | 13 | True | ||
| expirydate (T+16.0) | datetime | 8 | True | ||
| idbaseUnit (T+16.0) | int | 4 | True | ||
| pubuserdefnvc3 (T+16.0) | nvarchar | 200 | True | ||
| promotiontypestr (T+16.0) | nvarchar | 400 | True | ||
| freeItem2 (T+16.0) | nvarchar | 600 | True | ||
| freeItem7 (T+16.0) | nvarchar | 600 | True | ||
| RedPaymentStatus (T+16.0) | int | 4 | True | ||
| TaxFlag (T+16.0) | tinyint | 1 | True | ||
| promotionidstr (T+16.0) | nvarchar | 400 | True | ||
| ts (T+16.0) | timestamp | 8 | False | ||
| PaymentCode (T+16.0) | varchar | 50 | True | ||
| freeItem9 (T+16.0) | nvarchar | 600 | True | ||
| sequencenumber (T+16.0) | int | 4 | True | ||
| taxamount (T+16.0) | decimal | 13 | True | ||
| freeItem6 (T+16.0) | nvarchar | 600 | True | ||
| code (T+16.0) | nvarchar | 60 | True | ||
| freeItem0 (T+16.0) | nvarchar | 600 | True | ||
| pubuserdefnvc2 (T+16.0) | nvarchar | 200 | True | ||
| freeItem1 (T+16.0) | nvarchar | 600 | True | ||
| discountrate (T+16.0) | decimal | 13 | True | ||
| discountAuthorize (T+16.0) | nvarchar | 100 | True | ||
| priuserdefnvc2 (T+16.0) | nvarchar | 1000 | True | ||
| sourceVoucherCode (T+16.0) | nvarchar | 100 | True | ||
| memberprice (T+16.0) | decimal | 13 | True | ||
| priuserdefnvc1 (T+16.0) | nvarchar | 1000 | True | ||
| priuserdefdecm1 (T+16.0) | decimal | 13 | True | ||
| refundStatus (T+16.0) | int | 4 | True | ||
| amount (T+16.0) | decimal | 13 | True | ||
| basequantity (T+16.0) | decimal | 13 | True | ||
| RetailID (T+16.0) | bigint | 8 | True | ||
| totalSaleoutQty (T+16.0) | decimal | 13 | True | ||
| memberdiscountrate (T+16.0) | decimal | 13 | True | ||
| isFromPriceStrategy (T+16.0) | int | 4 | True | ||
| memo (T+16.0) | nvarchar | 400 | True | ||
| price (T+16.0) | decimal | 13 | True | ||
| isusestorage (T+16.0) | tinyint | 1 | True | ||
| subquantity (T+16.0) | decimal | 13 | True | ||
| idRdRecord (T+16.0) | int | 4 | True | ||
| batch (T+16.0) | nvarchar | 100 | True | ||
| idinventory (T+16.0) | int | 4 | True | ||
| priuserdefnvc4 (T+16.0) | nvarchar | 1000 | True | ||
| pubuserdefdecm3 (T+16.0) | decimal | 13 | True | ||
| totalReturnQty (T+16.0) | decimal | 13 | True | ||
| detailDiscountAmount (T+16.0) | decimal | 13 | True | ||
| pubuserdefnvc4 (T+16.0) | nvarchar | 200 | True | ||
| tax (T+16.0) | decimal | 13 | True | ||
| totalDiscountRate (T+16.0) | decimal | 13 | True | ||
| ismemberstorageprojet (T+16.0) | tinyint | 1 | True | ||
| wipechange (T+16.0) | decimal | 13 | True | ||
| priuserdefdecm3 (T+16.0) | decimal | 13 | True | ||
| quantity2 (T+16.0) | decimal | 13 | True | ||
| isdel (T+16.0) | tinyint | 1 | True | ||
| freeItem8 (T+16.0) | nvarchar | 600 | True | ||
| idsubUnit (T+16.0) | int | 4 | True | ||
| promotionid (T+16.0) | int | 4 | True | ||
| isuseintegralandcash (T+16.0) | tinyint | 1 | True | ||
| idunit (T+16.0) | int | 4 | True | ||
| idperson (T+16.0) | int | 4 | True | ||
| forpickupQty (T+16.0) | decimal | 13 | True | ||
| pubuserdefnvc1 (T+16.0) | nvarchar | 200 | True | ||
| discountAuthorizeId (T+16.0) | int | 4 | True | ||
| quantity (T+16.0) | decimal | 13 | True | ||
| RdRecordCode (T+16.0) | nvarchar | 100 | True | ||
| CashSettleAmount (T+16.0) | decimal | 13 | True | ||
| inventorybarcode (T+16.0) | nvarchar | 400 | True | ||
| pubuserdefdecm2 (T+16.0) | decimal | 13 | True | ||
| retailprice (T+16.0) | decimal | 13 | True | ||
| priuserdefnvc3 (T+16.0) | nvarchar | 1000 | True | ||
| pubuserdefdecm1 (T+16.0) | decimal | 13 | True | ||
| ProductionDate (T+16.0) | datetime | 8 | True | ||
| priuserdefdecm4 (T+16.0) | decimal | 13 | True | ||
| temporaryQty (T+16.0) | decimal | 13 | True | ||
| priuserdefdecm2 (T+16.0) | decimal | 13 | True | ||
| freeItem3 (T+16.0) | nvarchar | 600 | True | ||
| LastModifiedField (T+16.0) | varchar | 200 | True | ||
| UmallSkuId (T+16.0) | varchar | 50 | True | ||
| taxrate (T+16.0) | decimal | 13 | True | ||
| limitedsalesubid (T+16.0) | int | 4 | True | ||
| createdtime (T+16.0) | datetime | 8 | True | ||
| idproject (T+16.0) | int | 4 | True | ||
| VirtualSettleAmount (T+16.0) | decimal | 13 | True | ||
| totalpickupQty (T+16.0) | decimal | 13 | True | ||
| taxprice (T+16.0) | decimal | 13 | True | ||
| bookingQuantity (T+16.0) | decimal | 13 | True | ||
| IsManualChangePrice (T+16.0) | tinyint | 1 | True | ||
| pubuserdefdecm4 (T+16.0) | decimal | 13 | True | ||
| idunit2 (T+16.0) | int | 4 | True | ||
| promotioncode (T+16.0) | nvarchar | 400 | True | ||
| ispresent (T+16.0) | tinyint | 1 | True | ||
| promotiontype (T+16.0) | int | 4 | True | ||
| limitedsaleid (T+16.0) | int | 4 | True | ||
| freeItem4 (T+16.0) | nvarchar | 600 | True | ||
| storageDiscountAmount (T+16.0) | decimal | 13 | True | ||
| barCodeParseResultDic (T+16.0) | nvarchar | 1000 | True | ||
| unitexchangerate (T+16.0) | decimal | 13 | True | ||
| name (T+16.0) | nvarchar | 400 | True | ||
| detailCoponAmount (T+16.0) | decimal | 13 | True | ||
| freeItem5 (T+16.0) | nvarchar | 600 | True | ||
| idRetailDTO (T+16.0) | int | 4 | True | ||
| RedPaymentCode (T+16.0) | varchar | 50 | True | ||
| bookingAmount (T+16.0) | decimal | 13 | True | ||
| retailamount (T+16.0) | decimal | 13 | True | ||
| accountAmount (T+16.0) | decimal | 13 | True |
Copyright 2016 Chanjet Inc.