委外供应商存货价格DTO
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| idvendor (T+13.0) | 委外供应商 | int | 4 | True | |
| EffectiveEndDate (T+13.0) | 生效结束日期 | datetime | 8 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| name (T+12.1) | 名称 | nvarchar | 200 | True | |
| PriceKey (T+13.0) | 价格键 | nvarchar | 48 | True | |
| InvBarCode (T+13.0) | 存货条形码 | nvarchar | 128 | True | |
| transactionPrice (T+13.0) | 成交价 | nvarchar | 1000 | True | |
| updated (T+12.1) | 更新时间 | datetime | 8 | True | |
| EffectiveStartDate (T+13.0) | 生效开始日期 | datetime | 8 | True | |
| createdtime (T+12.1) | CreatedTime | datetime | 8 | True | |
| IdInventoryprice (T+13.0) | 存货价格本ID | int | 4 | True | |
| IdProcess (T+16.0) | 工序id | int | 4 | True | |
| isUseProcessSubUnit (T+16.0) | 是否工序辅计量 | int | 4 | True | |
| updatedBy (T+12.1) | 更新者 | nvarchar | 32 | True | |
| sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
| AgreementPrice (T+12.1) | 协议价 | decimal | 13 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| HighestOutsourcedPrice (T+12.1) | 最高委外价 | decimal | 13 | True | |
| idProcessSubUnit (T+16.0) | 工序辅计量单位 | int | 4 | True | |
| idinventory (T+12.1) | idInventory | int | 4 | True | |
| idunit (T+12.1) | idunit | int | 4 | True | |
| agreementDiscount (T+13.0) | 协议价折扣 | decimal | 13 | True | |
| idinventorypricetrace (T+13.0) | 存货价格跟踪表ID | int | 4 | True | |
| idpricetrace (T+12.1) | idpriceTrace | int | 4 | True | |
| idOutsourcedVendorPriceStrategyDTO (T+12.1) | idoutsourcedVendorPriceStrategyDTO | int | 4 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| LatestOutresourcedPrice (T+12.1) | 最新委外价 | decimal | 13 | True |
Copyright 2016 Chanjet Inc.