SA_QuotationTool_BOMCfg 数据库表名:报价工具BOM配置DTO
| 字段名称 |
字段说明 |
字段长度 |
字段类型 |
是否唯一 |
| ID |
主键 |
-1 |
ID |
0 |
| Code |
编号 |
30 |
String |
0 |
| Name |
名称 |
200 |
String |
0 |
| Version |
版本号 |
50 |
String |
0 |
| ProduceQuantity |
生产数量 |
-1 |
Decimal |
0 |
| ProduceType |
生产类型 |
-1 |
Enum |
0 |
| IsDefaultBom |
是否默认BOM |
-1 |
Bool |
0 |
| BomDepth |
BOM级次 |
-1 |
Int |
0 |
| RationWage |
定额工资 |
-1 |
Decimal |
0 |
| RationCharge |
定额费用 |
-1 |
Decimal |
0 |
| RationManHour |
定额工时 |
-1 |
Decimal |
0 |
| RateOfExchange |
换算率 |
-1 |
Decimal |
0 |
| ProduceQuantity2 |
生产数量2 |
-1 |
Decimal |
0 |
| YieldRate |
成品率% |
-1 |
Decimal |
0 |
| RationCost |
定额成本 |
-1 |
Decimal |
0 |
| RationMaterial |
定额材料 |
-1 |
Decimal |
0 |
| Cost |
成本 |
-1 |
Decimal |
0 |
| GetBomChildUnitMethod |
子件单价取值方式 |
-1 |
Enum |
0 |
| IsCostBOM |
成本BOM |
-1 |
Bool |
0 |
| Disabled |
是否停用 |
-1 |
Bool |
0 |
| IsChildModify |
材料修改 |
-1 |
Bool |
0 |
| IsRoutingModify |
工序修改 |
-1 |
Bool |
0 |
| VoucherDate |
VoucherDate |
-1 |
DateTime |
0 |
| MadeDate |
MadeDate |
-1 |
DateTime |
0 |
| Maker |
Maker |
50 |
String |
0 |
| Auditor |
Auditor |
50 |
String |
0 |
| AuditedDate |
AuditedDate |
-1 |
DateTime |
0 |
| MakerId |
MakerId |
-1 |
ID |
0 |
| AuditorId |
AuditorId |
-1 |
ID |
0 |
| Reviser |
Reviser |
50 |
String |
0 |
| VoucherState |
VoucherState |
-1 |
Enum |
0 |
| CreatedTime |
CreatedTime |
-1 |
DateTime |
0 |
| SequenceNumber |
顺序号 |
-1 |
Int |
0 |
| Ts |
分布时间戳 |
-1 |
TimeStamp |
0 |
| Updated |
更新时间 |
32 |
DateTime |
0 |
| UpdatedBy |
更新者 |
32 |
String |
0 |
| idmechiner |
idmechiner |
0 |
ID |
0 |
| Mechiner |
Mechiner |
0 |
DTO |
0 |
| idinventory |
idinventory |
0 |
ID |
0 |
| Inventory |
Inventory |
0 |
DTO |
0 |
| idmanufacturePlant |
idmanufacturePlant |
0 |
ID |
0 |
| ManufacturePlant |
ManufacturePlant |
0 |
DTO |
0 |
| idwarehouse |
idwarehouse |
0 |
ID |
0 |
| Warehouse |
Warehouse |
0 |
DTO |
0 |
| idunit |
idunit |
0 |
ID |
0 |
| Unit |
Unit |
0 |
DTO |
0 |
| idunit2 |
idunit2 |
0 |
ID |
0 |
| Unit2 |
Unit2 |
0 |
DTO |
0 |
| idrouting |
idrouting |
0 |
ID |
0 |
| Routing |
Routing |
0 |
DTO |
0 |
| RoutingDetails |
RoutingDetails |
0 |
DTOCollection |
0 |
| BomCfgChildren |
BomCfgChildren |
0 |
DTOCollection |
0 |
| idsuitBom |
idsuitBom |
0 |
ID |
0 |
| SuitBom |
SuitBom |
0 |
DTO |
0 |