库存销量上报明细临时表
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| idproject (T+13.0) | int | 4 | True | ||
| freeItem4 (T+13.0) | nvarchar | 300 | True | ||
| freeItem2 (T+13.0) | nvarchar | 300 | True | ||
| RequirementDate (T+13.0) | datetime | 8 | True | ||
| idunit2 (T+13.0) | int | 4 | True | ||
| totaltransquantity (T+13.0) | decimal | 13 | True | ||
| invbarcode (T+13.0) | nvarchar | 50 | True | ||
| freeItem8 (T+13.0) | nvarchar | 300 | True | ||
| priuserdefnvc4 (T+13.0) | nvarchar | 500 | True | ||
| totalexecutedquantity2 (T+13.0) | decimal | 13 | True | ||
| pubuserdefnvc2 (T+13.0) | nvarchar | 500 | True | ||
| Quantity2ForPhone (T+13.0) | decimal | 13 | True | ||
| totaldistributionquantity2 (T+13.0) | decimal | 13 | True | ||
| pubuserdefnvc1 (T+13.0) | nvarchar | 500 | True | ||
| freeItem6 (T+13.0) | nvarchar | 300 | True | ||
| freeItem5 (T+13.0) | nvarchar | 300 | True | ||
| QuantityForPhone (T+13.0) | decimal | 13 | True | ||
| totaldistributionquantity (T+13.0) | decimal | 13 | True | ||
| priuserdefnvc1 (T+13.0) | nvarchar | 500 | True | ||
| compositionquantity (T+13.0) | nvarchar | 50 | True | ||
| completestatus (T+13.0) | int | 4 | True | ||
| pubuserdefdecm1 (T+13.0) | decimal | 13 | True | ||
| idinventory (T+13.0) | int | 4 | True | ||
| idStockRequestDTO (T+13.0) | int | 4 | True | ||
| code (T+13.0) | nvarchar | 30 | True | ||
| pubuserdefdecm3 (T+13.0) | decimal | 13 | True | ||
| priuserdefdecm3 (T+13.0) | decimal | 13 | True | ||
| changerate (T+13.0) | decimal | 13 | True | ||
| ts (T+13.0) | timestamp | 8 | False | ||
| pubuserdefdecm4 (T+13.0) | decimal | 13 | True | ||
| totalstockinquantity (T+13.0) | decimal | 13 | True | ||
| sequencenumber (T+13.0) | int | 4 | True | ||
| onwayquantity2 (T+13.0) | decimal | 13 | True | ||
| idunit (T+13.0) | int | 4 | True | ||
| idbaseunit (T+13.0) | int | 4 | True | ||
| totalpracount (T+13.0) | int | 4 | True | ||
| IdunitForPhone (T+13.0) | int | 4 | True | ||
| differencequantity2 (T+13.0) | decimal | 13 | True | ||
| totalstockinquantity2 (T+13.0) | decimal | 13 | True | ||
| id (T+13.0) | int | 4 | False | ||
| pubuserdefdecm2 (T+13.0) | decimal | 13 | True | ||
| IdOutWarehouse (T+13.0) | int | 4 | True | ||
| priuserdefnvc3 (T+13.0) | nvarchar | 500 | True | ||
| createdtime (T+13.0) | datetime | 8 | True | ||
| quantity2 (T+13.0) | decimal | 13 | True | ||
| quantity (T+13.0) | decimal | 13 | True | ||
| differencequantity (T+13.0) | decimal | 13 | True | ||
| basequantity (T+13.0) | decimal | 13 | True | ||
| idsubunit (T+13.0) | int | 4 | True | ||
| subquantity (T+13.0) | decimal | 13 | True | ||
| pubuserdefnvc3 (T+13.0) | nvarchar | 500 | True | ||
| freeItem9 (T+13.0) | nvarchar | 300 | True | ||
| haspra (T+13.0) | tinyint | 1 | True | ||
| freeItem7 (T+13.0) | nvarchar | 300 | True | ||
| freeItem1 (T+13.0) | nvarchar | 300 | True | ||
| priuserdefdecm4 (T+13.0) | decimal | 13 | True | ||
| priuserdefdecm2 (T+13.0) | decimal | 13 | True | ||
| totalpurchasequantity2 (T+13.0) | decimal | 13 | True | ||
| updated (T+13.0) | datetime | 8 | True | ||
| onwayquantity (T+13.0) | decimal | 13 | True | ||
| pubuserdefnvc4 (T+13.0) | nvarchar | 500 | True | ||
| name (T+13.0) | nvarchar | 200 | True | ||
| retailprice (T+13.0) | decimal | 13 | True | ||
| priuserdefnvc2 (T+13.0) | nvarchar | 500 | True | ||
| totalstockoutquantity (T+13.0) | decimal | 13 | True | ||
| freeItem3 (T+13.0) | nvarchar | 300 | True | ||
| totalpurchasequantity (T+13.0) | decimal | 13 | True | ||
| retailamount (T+13.0) | decimal | 13 | True | ||
| Idunit2ForPhone (T+13.0) | int | 4 | True | ||
| totalexecutedquantity (T+13.0) | decimal | 13 | True | ||
| totaltransquantity2 (T+13.0) | decimal | 13 | True | ||
| totalstockoutquantity2 (T+13.0) | decimal | 13 | True | ||
| freeItem0 (T+13.0) | nvarchar | 300 | True | ||
| priuserdefdecm1 (T+13.0) | decimal | 13 | True | ||
| DistributionState (T+13.0) | int | 4 | True |
Copyright 2019 Chanjet Inc.