quoquotationmaterials.md
9.68 KB
quoquotationmaterials
工单材料表
- Engine: InnoDB
- Collation: utf8mb3_general_ci
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | iIncrement |
int |
NO | PRI | auto_increment | 自增列 | |
| 2 | sId |
varchar(50) |
NO | MUL | 唯一ID | ||
| 3 | sBrandsId |
varchar(50) |
NO | 加工商ID | |||
| 4 | sSubsidiaryId |
varchar(50) |
NO | 子公司ID | |||
| 5 | iOrder |
int |
NO | 0 | 排序号 | ||
| 6 | sParentId |
varchar(50) |
NO | 父级ID | |||
| 7 | sSlaveId |
varchar(50) |
NO | 从表Id | |||
| 8 | sControlId |
varchar(50) |
NO | 控制表ID | |||
| 9 | sType |
varchar(50) |
YES | 类型（0-部件材料、1-部件辅料、2-成品材料） | |||
| 10 | sMaterialsId |
varchar(50) |
NO | 材料ID | |||
| 11 | sMaterialsStyle |
varchar(50) |
NO | 材料规格 | |||
| 12 | dAuxiliaryQty |
decimal(18,6) |
NO | 0.000000 | 数量 | ||
| 13 | sAuxiliaryUnit |
varchar(50) |
YES | 材料单位 | |||
| 14 | dMaterialsQty |
decimal(18,6) |
NO | 0.000000 | 换算数量 | ||
| 15 | iReelPaper |
int |
NO | 0 | 卷筒按张算 | ||
| 16 | dConversionQty |
decimal(18,6) |
NO | 0.000000 | 预留数量 | ||
| 17 | dCostMaterialsPrice |
decimal(18,6) |
NO | 0.000000 | 成本价格 | ||
| 18 | dCostMaterialsMoney |
decimal(18,6) |
NO | 0.000000 | 成本金额 | ||
| 19 | dMaterialsPrice |
decimal(18,6) |
NO | 0.000000 | 材料单价 | ||
| 20 | dMaterialsMoney |
decimal(18,6) |
NO | 0.000000 | 材料金额 | ||
| 21 | dMaterialsKQty |
decimal(18,6) |
NO | 1.000000 | 材料开数 | ||
| 22 | bComMaterials |
bit(1) |
NO | b'0' | 是否来料 | ||
| 23 | bOutsideBandMaterials |
bit(1) |
NO | b'0' | 是否发外带料 | ||
| 24 | sProcessId |
varchar(50) |
NO | 工序ID | |||
| 25 | sProcessTbId |
varchar(50) |
NO | 源单的工序表Id | |||
| 26 | sSelectProcess |
varchar(50) |
NO | 手动选择工序后赋值此字段 | |||
| 27 | sSrcId |
varchar(50) |
NO | 材料表复制部件时源单Id | |||
| 28 | sMaterialsMemo |
text |
YES | 材料信息 | |||
| 29 | sAReserve1 |
varchar(50) |
YES | 预留字符1 | |||
| 30 | sAReserve2 |
varchar(50) |
YES | 预留字符2 | |||
| 31 | sAReserve3 |
varchar(50) |
YES | 预留字符3 | |||
| 32 | sAReserve4 |
varchar(50) |
YES | 预留字符4 | |||
| 33 | sAReserve5 |
varchar(50) |
YES | 预留字符5 | |||
| 34 | sAReserve6 |
varchar(50) |
YES | 预留字符6 | |||
| 35 | dAReserve1 |
decimal(18,6) |
YES | 预留数字1 | |||
| 36 | dAReserve2 |
decimal(18,6) |
YES | 预留数字2 | |||
| 37 | dAReserve3 |
decimal(18,6) |
YES | 预留数字3 | |||
| 38 | iAReserve1 |
int |
YES | 预留整型1 | |||
| 39 | iAReserve2 |
int |
YES | 预留整型2 | |||
| 40 | iAReserve3 |
int |
YES | 预留整型3 | |||
| 41 | tAReserve1 |
datetime |
YES | 预留日期1 | |||
| 42 | tAReserve2 |
datetime |
YES | 预留日期2 | |||
| 43 | bComComplete |
bit(1) |
NO | b'0' | 来料强制完工 | ||
| 44 | dComAuxiliaryQty |
decimal(18,6) |
NO | 0.000000 | 来料反写数量 | ||
| 45 | dComQty |
decimal(18,6) |
NO | 0.000000 | 来料换算数量 | ||
| 46 | bCutComplete |
bit(1) |
NO | b'0' | 分切强制完工 | ||
| 47 | dCutAuxiliaryQty |
decimal(18,6) |
NO | 0.000000 | 分切数量 | ||
| 48 | dCutQty |
decimal(18,6) |
NO | 0.000000 | 分切换算数量 | ||
| 49 | bMarginalComplete |
bit(1) |
NO | b'0' | 边角料强制完工 | ||
| 50 | dMarginalAuxiliaryQty |
decimal(18,6) |
NO | 0.000000 | 边角料数量 | ||
| 51 | dMarginalQty |
decimal(18,6) |
NO | 0.000000 | 边角料换算数量 | ||
| 52 | bNotAuto |
bit(1) |
NO | b'0' | 是否自动计算 | ||
| 53 | sMakePerson |
varchar(50) |
NO | 制单人 | |||
| 54 | tCreateDate |
datetime |
NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 记账日期 | |
| 55 | sSrcControlId |
varchar(50) |
NO | 源单控制表Id | |||
| 56 | sSrcMaterialsTbId |
varchar(50) |
NO | 源单材料表Id | |||
| 57 | dSumAuxiliaryQty |
decimal(18,6) |
YES | 总数量 | |||
| 58 | dBomCoefficient |
decimal(18,6) |
YES | BOM系数 | |||
| 59 | sSlaveProductId |
varchar(50) |
YES | 从表产品ID | |||
| 60 | sCombinePartsName |
longtext |
YES | 产品名称 | |||
| 61 | bManyType |
bit(1) |
NO | b'1' | 是否多类型 | ||
| 62 | dVatMaterialsPrice |
decimal(18,6) |
NO | 0.000000 | 含税材料单价 | ||
| 63 | tMakeDate |
datetime |
NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 制单日期 | |
| 64 | sParentMaterialsId |
varchar(50) |
YES | 父级材料表id | |||
| 65 | sMaterialsType |
longtext |
YES | 材料分类 | |||
| 66 | dQzAuxiliaryQty |
decimal(18,6) |
YES | 0.000000 | 千张用量 | ||
| 67 | dQgqzAuxiliaryQty |
decimal(18,6) |
YES | 评估千张用量 | |||
| 68 | sBclassifyName |
longtext |
YES | 物料大类 | |||
| 69 | sBclassifyId |
varchar(50) |
YES | 大类id | |||
| 70 | sTaxId |
varchar(50) |
YES | 税率ID | |||
| 71 | dTzQzAuxiliaryQty |
decimal(18,6) |
YES | 单位用量 | |||
| 72 | dTzCostMaterialsdwQty |
decimal(18,6) |
YES | 调整单位用量kg/张 | |||
| 73 | sInkBOMId |
varchar(50) |
NO | 油墨bom主表id | |||
| 74 | sInkBOMsSlaveId |
varchar(50) |
NO | 油墨bom从表id | |||
| 75 | sInkBOMsMaterialsId |
varchar(50) |
NO | 油墨bom专色墨id | |||
| 76 | bSfRate |
bit(1) |
YES | 是否含税 | |||
| 77 | sWorkOrderUsed |
varchar(50) |
YES | ||||
| 78 | dLastVatMaterialsPrice |
decimal(18,6) |
NO | 0.000000 | 最终含税材料单价 | ||
| 79 | dLastMaterialsPrice |
decimal(18,6) |
NO | 0.000000 | 最终材料单价 | ||
| 80 | diMachineCoefficient |
decimal(18,6) |
NO | 0.000000 | 机器系数 | ||
| 81 | diJumpCoefficient |
decimal(18,6) |
NO | 0.000000 | 跳步系数 | ||
| 82 | dMassiveConsumption |
decimal(18,6) |
NO | 0.000000 | 大块耗用量 | ||
| 83 | dHolographicAttritionRate |
decimal(18,6) |
NO | 0.000000 | 全息损耗率 | ||
| 84 | sBullionName |
varchar(100) |
YES | 金块名称 | |||
| 85 | sMachineModel |
varchar(50) |
NO | 机型 | |||
| 86 | sHotFixPictureType |
varchar(50) |
YES | 烫图类别 | |||
| 87 | dGildingChunkLenth |
decimal(18,6) |
NO | 0.000000 | 烫金块长 | ||
| 88 | dGildingChunkWidth |
decimal(18,6) |
NO | 0.000000 | 烫金块宽 | ||
| 89 | sTrend |
varchar(50) |
YES | 走向 | |||
| 90 | dMinSeparable |
decimal(18,6) |
NO | 0.000000 | 最小间距 | ||
| 91 | iGildingChunk |
int |
NO | 0 | 烫金块数 | ||
| 92 | dMonoblockConsumption |
decimal(18,6) |
NO | 0.000000 | 单个块耗用量 | ||
| 93 | dAuxiThousheetQty |
decimal(18,6) |
NO | 0.000000 | 千张用量 | ||
| 94 | iNumberOfTime |
int |
NO | 0 | 烫金工次 | ||
| 95 | sName |
varchar(100) |
YES | 名称 | |||
| 96 | iGildingNumber |
int |
NO | 0 | 烫金条数 | ||
| 97 | sPressingName |
varchar(100) |
YES | 烫位名称 | |||
| 98 | sAlumite |
varchar(50) |
YES | 电化铝 | |||
| 99 | sProcessDifficulty |
varchar(50) |
YES | 工艺难度 | |||
| 100 | iCoefficientOfDifficulty |
int |
NO | 0 | 难度系数 | ||
| 101 | sGildingCraft |
varchar(50) |
YES | 烫金工艺 | |||
| 102 | sGildingType |
varchar(50) |
YES | 烫金类别 | |||
| 103 | sHolographicPattern |
varchar(50) |
YES | 全息图案 | |||
| 104 | iJumpCoefficient |
int |
NO | 0 | 跳步系数 | ||
| 105 | sPaperTexture |
varchar(50) |
YES | 纸纹方向 | |||
| 106 | dPackageQty |
decimal(18,6) |
YES | 0.000000 | 预留数量 | ||
| 107 | sAluminumVersionNum |
varchar(50) |
NO | 电化铝版本 | |||
| 108 | sAluminumBomId |
varchar(50) |
NO | 电化铝烫金主表id | |||
| 109 | sAluminumBomSlaveId |
varchar(50) |
NO | 电化铝烫金从表id | |||
| 110 | sVersionNum |
varchar(20) |
YES | 油墨版本号 | |||
| 111 | sMaterialsProcessName |
varchar(100) |
YES | 工序名称 | |||
| 112 | dTzCostMaterialCbsdwQty |
decimal(18,6) |
YES | 最终成本(个/元) | |||
| 113 | sMaterialsNo |
varchar(50) |
YES | 材料编号 | |||
| 114 | sMaterialsName1 |
varchar(50) |
YES | 比较材料名称 | |||
| 115 | sMaterialsName |
varchar(100) |
YES | 材料名称 | |||
| 116 | dQzMaterialsQty |
decimal(18,6) |
NO | 0.000000 | 千张用量 | ||
| 117 | dGramWeight |
decimal(18,6) |
YES | 0.000000 | 纸张克重 | ||
| 118 | dCostMaterialsNoTaxPrice |
decimal(18,6) |
NO | 0.000000 | 成本价格不含税 | ||
| 119 | dTzCostMaterialsNoTaxPrice |
decimal(18,6) |
NO | 0.000000 | 成本价格不含税(调整) | ||
| 120 | dCostMaterialsNoTaxMoney |
decimal(18,6) |
NO | 0.000000 | 成本金额不含税 | ||
| 121 | dTzCostMaterialsNoTaxMoney |
decimal(18,6) |
NO | 0.000000 | 成本金额不含税(调整) |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
IndexN_quoquotationmaterials |
BTREE |
sId, sBrandsId, sSubsidiaryId, sParentId
|
|
IndexU_quoquotationmaterials |
✓ | BTREE |
sId, sBrandsId, sSubsidiaryId
|
PRIMARY |
✓ | BTREE | iIncrement |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.