数据清除备份表，已废弃
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| code (T+16.0) | nvarchar | 100 | True | ||
| totalretailamount (T+16.0) | decimal | 13 | True | ||
| iscleared (T+16.0) | int | 4 | True | ||
| issaleout (T+16.0) | int | 4 | True | ||
| receivingmaturity (T+16.0) | datetime | 8 | True | ||
| pubuserdefnvc3 (T+16.0) | nvarchar | 200 | True | ||
| ismodifiedcode (T+16.0) | tinyint | 1 | True | ||
| shiftcode (T+16.0) | nvarchar | 100 | True | ||
| pubuserdefdecm5 (T+16.0) | decimal | 13 | True | ||
| idstore (T+16.0) | int | 4 | True | ||
| idshiftvoucher (T+16.0) | bigint | 8 | True | ||
| wipechange (T+16.0) | decimal | 13 | True | ||
| priuserdefnvc1 (T+16.0) | nvarchar | 1000 | True | ||
| priuserdefdecm4 (T+16.0) | decimal | 13 | True | ||
| idbusitype (T+16.0) | int | 4 | True | ||
| idperson (T+16.0) | int | 4 | True | ||
| DistributionMode (T+16.0) | int | 4 | True | ||
| LadingCode (T+16.0) | varchar | 50 | True | ||
| ReFoundForStorage (T+16.0) | decimal | 13 | True | ||
| priuserdefdecm2 (T+16.0) | decimal | 13 | True | ||
| priuserdefnvc4 (T+16.0) | nvarchar | 1000 | True | ||
| priuserdefdecm1 (T+16.0) | decimal | 13 | True | ||
| DataClient (T+16.0) | int | 4 | True | ||
| username (T+16.0) | nvarchar | 100 | True | ||
| CourierNo (T+16.0) | varchar | 50 | True | ||
| ts (T+16.0) | timestamp | 8 | False | ||
| SteadCashIntegral (T+16.0) | decimal | 13 | True | ||
| priuserdefnvc6 (T+16.0) | nvarchar | 1000 | True | ||
| DataSource (T+16.0) | int | 4 | True | ||
| customeraddress (T+16.0) | nvarchar | 1000 | True | ||
| CourierFirm (T+16.0) | varchar | 255 | True | ||
| isdealed (T+16.0) | int | 4 | False | ||
| ReceiveStatus (T+16.0) | int | 4 | True | ||
| iddailyvoucher (T+16.0) | bigint | 8 | True | ||
| givechangeforstorageamount (T+16.0) | decimal | 13 | True | ||
| storagesettleamount (T+16.0) | decimal | 13 | True | ||
| auditor (T+16.0) | nvarchar | 100 | True | ||
| docclass (T+16.0) | nvarchar | 72 | True | ||
| PreReceiveAmount (T+16.0) | decimal | 13 | True | ||
| OnlinePaymentAmount (T+16.0) | decimal | 13 | True | ||
| pubuserdefnvc5 (T+16.0) | nvarchar | 200 | True | ||
| customerrequest (T+16.0) | nvarchar | 510 | True | ||
| priuserdefdecm6 (T+16.0) | decimal | 13 | True | ||
| pubuserdefnvc6 (T+16.0) | nvarchar | 200 | True | ||
| docid (T+16.0) | nvarchar | 72 | True | ||
| usercode (T+16.0) | nvarchar | 100 | True | ||
| auditeddate (T+16.0) | datetime | 8 | True | ||
| PrintSettleStyle (T+16.0) | nvarchar | 1024 | True | ||
| poscode (T+16.0) | nvarchar | 100 | True | ||
| idproject (T+16.0) | int | 4 | True | ||
| accountingperiod (T+16.0) | int | 4 | True | ||
| voucherdate (T+16.0) | datetime | 8 | True | ||
| deliveryDate (T+16.0) | datetime | 8 | True | ||
| pubuserdefdecm6 (T+16.0) | decimal | 13 | True | ||
| payordercode (T+16.0) | nvarchar | 200 | True | ||
| IDVoucherType (T+16.0) | int | 4 | True | ||
| userid (T+16.0) | int | 4 | True | ||
| RetailSettleCode (T+16.0) | nvarchar | 100 | True | ||
| customerphone (T+16.0) | nvarchar | 100 | True | ||
| TotalCount (T+16.0) | decimal | 9 | True | ||
| idmember (T+16.0) | int | 4 | True | ||
| docno (T+16.0) | nvarchar | 72 | True | ||
| pubuserdefdecm3 (T+16.0) | decimal | 13 | True | ||
| idmarketingorgan (T+16.0) | int | 4 | True | ||
| iscarriedforwardin (T+16.0) | tinyint | 1 | True | ||
| priuserdefnvc5 (T+16.0) | nvarchar | 1000 | True | ||
| pubuserdefnvc1 (T+16.0) | nvarchar | 200 | True | ||
| discountsandallowances (T+16.0) | decimal | 13 | True | ||
| maker (T+16.0) | nvarchar | 100 | True | ||
| name (T+16.0) | nvarchar | 400 | True | ||
| pubuserdefdecm1 (T+16.0) | decimal | 13 | True | ||
| SourceVoucherCode (T+16.0) | nvarchar | 100 | True | ||
| madedate (T+16.0) | datetime | 8 | True | ||
| shift (T+16.0) | int | 4 | True | ||
| PrintCount (T+16.0) | int | 4 | True | ||
| customerlinkman (T+16.0) | nvarchar | 100 | True | ||
| totaltaxamount (T+16.0) | decimal | 13 | True | ||
| priuserdefnvc2 (T+16.0) | nvarchar | 1000 | True | ||
| balanceintegral (T+16.0) | decimal | 13 | True | ||
| iscancel (T+16.0) | int | 4 | True | ||
| accountingyear (T+16.0) | int | 4 | True | ||
| idRetailSettle (T+16.0) | int | 4 | True | ||
| integral (T+16.0) | decimal | 13 | True | ||
| pubuserdefdecm4 (T+16.0) | decimal | 13 | True | ||
| idMembertype (T+16.0) | int | 4 | True | ||
| priuserdefnvc3 (T+16.0) | nvarchar | 1000 | True | ||
| createdtime (T+16.0) | datetime | 8 | True | ||
| pubuserdefnvc2 (T+16.0) | nvarchar | 200 | True | ||
| integralsteadcashamount (T+16.0) | decimal | 13 | True | ||
| ExternalCode (T+16.0) | varchar | 50 | True | ||
| deliveryStatus (T+16.0) | int | 4 | True | ||
| auditorid (T+16.0) | int | 4 | True | ||
| dailycode (T+16.0) | nvarchar | 100 | True | ||
| auditedtime (T+16.0) | char | 8 | True | ||
| iscarriedforwardout (T+16.0) | tinyint | 1 | True | ||
| makerid (T+16.0) | int | 4 | True | ||
| priuserdefdecm5 (T+16.0) | decimal | 13 | True | ||
| customername (T+16.0) | nvarchar | 100 | True | ||
| id (T+16.0) | int | 4 | False | ||
| posname (T+16.0) | nvarchar | 100 | True | ||
| sequencenumber (T+16.0) | int | 4 | True | ||
| voucherstate (T+16.0) | int | 4 | True | ||
| totaldiscountamount (T+16.0) | decimal | 13 | True | ||
| IsPresent (T+16.0) | tinyint | 1 | True | ||
| pubuserdefdecm2 (T+16.0) | decimal | 13 | True | ||
| priuserdefdecm3 (T+16.0) | decimal | 13 | True | ||
| idDepartment_Store (T+16.0) | int | 4 | True | ||
| pubuserdefnvc4 (T+16.0) | nvarchar | 200 | True | ||
| memo (T+16.0) | nvarchar | 400 | True | ||
| RetailID (T+16.0) | bigint | 8 | True | ||
| reviser (T+16.0) | nvarchar | 100 | True | ||
| balancestorage (T+16.0) | decimal | 13 | True | ||
| idDistrict_Member (T+16.0) | int | 4 | True |
Copyright 2016 Chanjet Inc.