# `accordercostanalysis` - **Rows (estimated):** 319634 - **Data size:** 1.6 GB - **Engine:** InnoDB - **Collation:** utf8mb3_general_ci - **Created:** 2026-04-27 18:47:12 - **Updated:** 2026-04-27 18:50:50 ## Columns | # | Name | Type | Null | Key | Default | Extra | Comment | |---|---|---|---|---|---|---|---| | 1 | `sBrandsId` | `varchar(100)` | NO | | | | | | 2 | `sSubsidiaryId` | `varchar(100)` | NO | | | | | | 3 | `sId` | `varchar(100)` | NO | | | | 工单ID或装配单ID | | 4 | `sFormId` | `varchar(100)` | NO | | | | 界面Id | | 5 | `sBillNo` | `varchar(255)` | NO | | | | 单据号 | | 6 | `sWorkOrderId` | `varchar(100)` | NO | | | | 工单Id | | 7 | `sWorkOrderNo` | `varchar(100)` | NO | | | | 工单号 | | 8 | `sWorkOrderSlaveId` | `varchar(100)` | NO | | | | 工单从表Id | | 9 | `iOrder` | `int` | NO | | 0 | | 排序号 | | 10 | `sCustomerId` | `varchar(100)` | NO | | | | 客户ID | | 11 | `sCustomerNo` | `varchar(100)` | NO | | | | 客户号 | | 12 | `sCustomerName` | `varchar(100)` | NO | | | | 客户名称 | | 13 | `sSalesOrderNo` | `varchar(100)` | NO | | | | 订单号 | | 14 | `sProductId` | `varchar(100)` | NO | | | | 产品ID | | 15 | `sProductNo` | `varchar(100)` | NO | | | | 产品号 | | 16 | `sProductName` | `varchar(100)` | NO | | | | 产品名称 | | 17 | `sProductStyle` | `varchar(100)` | NO | | | | 产品规格 | | 18 | `dProductQty` | `decimal(18,6)` | NO | | 0.000000 | | 产品数量 | | 19 | `sProductUnit` | `varchar(100)` | NO | | | | 产品单位 | | 20 | `dAreaQty` | `decimal(18,6)` | NO | | 0.000000 | | 印刷总面积 | | 21 | `dStdHour` | `decimal(18,6)` | NO | | 0.000000 | | 工序标准工时 | | 22 | `dProductCostPrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 23 | `dCostProductMoney` | `decimal(18,6)` | NO | | 0.000000 | | 工单标准成本 | | 24 | `dFreight` | `decimal(18,6)` | NO | | 0.000000 | | 运费 | | 25 | `dProductTaxMoney` | `decimal(18,6)` | NO | | 0.000000 | | 产品税额 | | 26 | `dProductMoney` | `decimal(18,6)` | NO | | 0.000000 | | 销售金额 | | 27 | `dReceiptMoney` | `decimal(18,6)` | NO | | 0.000000 | | 收款金额 | | 28 | `sMakePerson` | `varchar(100)` | NO | | | | 制单人 | | 29 | `tCreateDate` | `datetime` | YES | | | | 制单日期 | | 30 | `dPeriodCostProductMoney` | `decimal(18,6)` | NO | | 0.000000 | | 本期成本 | | 31 | `dPeriodProductInQty` | `decimal(18,6)` | NO | | 0.000000 | | 本期入库数量 | | 32 | `dPeriodProductInPrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 33 | `dMaterialsCostMoney` | `decimal(18,6)` | NO | | 0.000000 | | 材料实际成本金额 | | 34 | `dMaterialsStdMoney` | `decimal(18,6)` | NO | | 0.000000 | | 材料成本金额 | | 35 | `dMaterialsDifMoney` | `decimal(18,6)` | NO | | 0.000000 | | 材料差异 | | 36 | `dOutSideCostMoney` | `decimal(18,6)` | NO | | 0.000000 | | 发外成本金额(对应发外入库) | | 37 | `dOutSideStdCostMoney` | `decimal(18,6)` | NO | | 0.000000 | | 发外成本金额(对应工序成本) | | 38 | `dOutSideDifMoney` | `decimal(18,6)` | NO | | 0.000000 | | 发外差异 | | 39 | `dShareMoney` | `decimal(18,6)` | NO | | 0.000000 | | 分摊金额 | | 40 | `sProcessId` | `varchar(100)` | NO | | | | 工序ID | | 41 | `sProcessName` | `varchar(100)` | NO | | | | 工序名称 | | 42 | `sWorkCenterName` | `varchar(100)` | NO | | | | 工作中心名称 | | 43 | `sWorkOrderProcessTbId` | `varchar(100)` | NO | | | | 工单工序表Guid | | 44 | `iType` | `int` | NO | | 0 | | 类型 0 工单，1 材料， 2工序 | | 45 | `dSaleRate` | `decimal(18,6)` | NO | | 0.000000 | | 销售率 | | 46 | `dSaleProfit` | `decimal(18,6)` | NO | | 0.000000 | | 销售利润 | | 47 | `dStandardSalary` | `decimal(18,6)` | NO | | 0.000000 | | 标准薪资(工序成本) | | 48 | `dLaborMoney` | `decimal(18,6)` | NO | | 0.000000 | | 实际薪资 | | 49 | `dLaborDifMoney` | `decimal(18,6)` | NO | | 0.000000 | | 薪资差异 | | 50 | `dManufactureRate` | `decimal(18,6)` | NO | | 0.000000 | | 生产利润率 | | 51 | `dManufactureProfit` | `decimal(18,6)` | NO | | 0.000000 | | 生产利润 | | 52 | `dNetRate` | `decimal(18,6)` | NO | | 0.000000 | | 净利率 | | 53 | `dNetProfit` | `decimal(18,6)` | NO | | 0.000000 | | 净利润 | | 54 | `bOutSide` | `bit(1)` | NO | | b'0' | | 是否发外 发外的不用分摊 | | 55 | `bBillComplete` | `bit(1)` | NO | | b'0' | | 单据是否完工 | | 56 | `dInitMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期初金额 | | 57 | `dSumMoney` | `decimal(18,6)` | NO | | 0.000000 | | 总金额 | | 58 | `dEndMoney` | `decimal(18,6)` | NO | | 0.000000 | | 累计成本金额 | | 59 | `dEarlyQty` | `decimal(18,6)` | NO | | 0.000000 | | 产成品-期初之前累计数量 | | 60 | `dEarlyMoney` | `decimal(18,6)` | NO | | 0.000000 | | 产成品-期初之前累计金额 | | 61 | `dDoingQty` | `decimal(18,6)` | NO | | 0.000000 | | 在制品-数量 | | 62 | `dDoingMoney` | `decimal(18,6)` | NO | | 0.000000 | | 在制品-金额 | | 63 | `dInProductCostMoney` | `decimal(18,6)` | NO | | 0.000000 | | 本期入库金额 | | 64 | `dProductCarryOverQty` | `decimal(18,6)` | NO | | 0.000000 | | 结转入库数量 | | 65 | `dProcessQty` | `decimal(18,6)` | NO | | 0.000000 | | 上报数量 | | 66 | `iProcessColorQty` | `int` | NO | | 0 | | 色令 | | 67 | `sManualNo` | `varchar(100)` | NO | | | | 手工单号 | | 68 | `sCostPeriod` | `varchar(100)` | NO | | | | 月份 | | 69 | `bConfirm` | `bit(1)` | NO | | b'0' | | 是否确认 | | 70 | `sConfirmMonth` | `varchar(100)` | NO | | | | 确认月份 | | 71 | `dCostCenter1Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 72 | `dCostCenter2Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 73 | `dCostCenter3Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 74 | `dCostCenter4Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 75 | `dCostCenter5Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 76 | `dCostCenter6Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 77 | `dExpenseStandard1Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 78 | `dExpense1Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 79 | `dExpenseDif1Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 80 | `dExpenseStandard2Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 81 | `dExpense2Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 82 | `dExpenseDif2Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 83 | `dExpenseStandard3Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 84 | `dExpense3Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 85 | `dExpenseDif3Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 86 | `dExpenseStandard4Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 87 | `dExpense4Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 88 | `dExpenseDif4Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 89 | `dExpenseStandard5Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 90 | `dExpense5Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 91 | `dExpenseDif5Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 92 | `dExpenseStandard6Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 93 | `dExpense6Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 94 | `dExpenseDif6Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 95 | `dExpenseStandard7Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 96 | `dExpense7Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 97 | `dExpenseDif7Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 98 | `dExpenseStandard8Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 99 | `dExpense8Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 100 | `dExpenseDif8Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 101 | `dExpenseStandard9Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 102 | `dExpense9Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 103 | `dExpenseDif9Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 104 | `dExpenseStandard10Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 105 | `dExpense10Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 106 | `dExpenseDif10Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 107 | `dAllMoney` | `decimal(18,6)` | NO | | 0.000000 | | 总金额 | | 108 | `dHour` | `decimal(18,6)` | NO | | 0.000000 | | 工时 | | 109 | `dInitExpense1Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用1 | | 110 | `dInitExpense2Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用2 | | 111 | `dInitExpense3Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用3 | | 112 | `dInitExpense4Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用4 | | 113 | `dInitExpense5Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用5 | | 114 | `dInitExpense6Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用6 | | 115 | `dInitExpense7Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用7 | | 116 | `dInitExpense8Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用8 | | 117 | `dInitExpense9Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用9 | | 118 | `dInitExpense10Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用10 | | 119 | `dInitMaterialsMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期初材料金额 | | 120 | `dInitOutsideMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期初发外金额 | | 121 | `dInitLaborMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期初人工金额 | | 122 | `dInitAllMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期初总金额 | | 123 | `dEndExpense1Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用1 | | 124 | `dEndExpense2Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用2 | | 125 | `dEndExpense3Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用3 | | 126 | `dEndExpense4Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用4 | | 127 | `dEndExpense5Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用5 | | 128 | `dEndExpense6Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用6 | | 129 | `dEndExpense7Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用7 | | 130 | `dEndExpense8Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用8 | | 131 | `dEndExpense9Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用9 | | 132 | `dEndExpense10Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用10 | | 133 | `dEndMaterialsMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期末材料金额 | | 134 | `dEndOutsideMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期末发外金额 | | 135 | `dEndLaborMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期末人工金额 | | 136 | `dEndAllMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期末总金额 | | 137 | `dInitExpense11Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用11 | | 138 | `dInitExpense12Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用12 | | 139 | `dInitExpense13Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用13 | | 140 | `dInitExpense14Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用14 | | 141 | `dInitExpense15Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用15 | | 142 | `dInitExpense16Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用16 | | 143 | `dInitExpense17Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用17 | | 144 | `dEndExpense11Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用11 | | 145 | `dEndExpense12Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用12 | | 146 | `dEndExpense13Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用13 | | 147 | `dEndExpense14Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用14 | | 148 | `dEndExpense15Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用15 | | 149 | `dEndExpense16Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用16 | | 150 | `dEndExpense17Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用17 | | 151 | `dExpenseStandard11Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 152 | `dExpense11Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 153 | `dExpenseDif11Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 154 | `dExpenseStandard12Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 155 | `dExpense12Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 156 | `dExpenseDif12Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 157 | `dExpenseStandard13Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 158 | `dExpense13Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 159 | `dExpenseDif13Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 160 | `dExpenseStandard14Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 161 | `dExpense14Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 162 | `dExpenseDif14Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 163 | `dExpenseStandard15Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 164 | `dExpense15Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 165 | `dExpenseDif15Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 166 | `dExpenseStandard16Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 167 | `dExpense16Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 168 | `dExpenseDif16Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 169 | `dExpenseStandard17Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 170 | `dExpense17Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 171 | `dExpenseDif17Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 172 | `dDoingExpense1Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用1 | | 173 | `dDoingExpense2Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用2 | | 174 | `dDoingExpense3Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用3 | | 175 | `dDoingExpense4Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用4 | | 176 | `dDoingExpense5Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用5 | | 177 | `dDoingExpense6Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用6 | | 178 | `dDoingExpense7Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用7 | | 179 | `dDoingExpense8Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用8 | | 180 | `dDoingExpense9Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用9 | | 181 | `dDoingExpense10Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用10 | | 182 | `dDoingExpense11Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用11 | | 183 | `dDoingExpense12Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用12 | | 184 | `dDoingExpense13Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用13 | | 185 | `dDoingExpense14Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用14 | | 186 | `dDoingExpense15Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用15 | | 187 | `dDoingExpense16Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用16 | | 188 | `dDoingExpense17Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用17 | | 189 | `dDoingMaterialsMoney` | `decimal(18,6)` | NO | | 0.000000 | | 在制品材料金额 | | 190 | `dDoingOutsideMoney` | `decimal(18,6)` | NO | | 0.000000 | | 在制品发外金额 | | 191 | `dDoingLaborMoney` | `decimal(18,6)` | NO | | 0.000000 | | 在制品人工金额 | | 192 | `dDoingAllMoney` | `decimal(18,6)` | NO | | 0.000000 | | 在制品总金额 | | 193 | `dProductInStoreQty` | `decimal(18,6)` | NO | | 0.000000 | | 产品入库数 | | 194 | `sMachineId` | `varchar(100)` | NO | | | | 设备ID | | 195 | `sMachineName` | `varchar(100)` | NO | | | | 设备名称 | | 196 | `dStdProcessQty` | `decimal(18,6)` | NO | | 0.000000 | | 计划数量 | | 197 | `sPartsName` | `varchar(100)` | NO | | | | 部件名称 | | 198 | `dAdjustHour` | `decimal(18,6)` | NO | | 0.000000 | | 调整工时 | | 199 | `sMaterialsId` | `varchar(100)` | NO | | | | 材料ID | | 200 | `sMaterialsNo` | `varchar(100)` | NO | | | | 材料号 | | 201 | `sMaterialsName` | `varchar(100)` | NO | | | | 材料名称 | | 202 | `sMaterialsStyle` | `varchar(100)` | NO | | | | 材料规格 | | 203 | `dAuxiliaryQty` | `decimal(18,6)` | NO | | 0.000000 | | 材料数量 | | 204 | `dMaterialsQty` | `decimal(18,6)` | NO | | 0.000000 | | 材料换算数量 | | 205 | `sMaterialsUnit` | `varchar(100)` | NO | | | | 材料换算单位 | | 206 | `sAuxiliaryUnit` | `varchar(100)` | NO | | | | 材料单位 | | 207 | `sOrderFormId` | `varchar(100)` | NO | | | | 订单formId | | 208 | `sOrderId` | `varchar(100)` | NO | | | | 订单id | | 209 | `sOrderSlaveId` | `varchar(100)` | NO | | | | 订单从表id | | 210 | `sBillId` | `varchar(100)` | NO | | | | 单据id | | 211 | `sAccId` | `varchar(100)` | NO | | | | 唯一id | | 212 | `dMaterialsCostPrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 213 | `dOutSideCostPrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 214 | `iBillType` | `int` | NO | | 0 | | 核算类型(1:本期作业，2:成品入库,3:直接材料, 4:外发开票,5:本期暂估,6:上期暂估,7:计件工资) | | 215 | `dInitExpense18Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用18 | | 216 | `dEndExpense18Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用18 | | 217 | `dDoingExpense18Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用18 | | 218 | `dExpense18Money` | `decimal(18,6)` | NO | | 0.000000 | | 本期分摊费用18 | | 219 | `dInitExpense19Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用19 | | 220 | `dEndExpense19Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用19 | | 221 | `dDoingExpense19Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用19 | | 222 | `dExpense19Money` | `decimal(18,6)` | NO | | 0.000000 | | 本期分摊费用19 | | 223 | `dInitExpense20Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用20 | | 224 | `dEndExpense20Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用20 | | 225 | `dDoingExpense20Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用20 | | 226 | `dExpense20Money` | `decimal(18,6)` | NO | | 0.000000 | | 本期分摊费用20 | | 227 | `sWorkCenterId` | `varchar(100)` | NO | | | | 工作中心id | | 228 | `dSumPlateQty` | `decimal(18,6)` | NO | | 0.000000 | | 印版张数 | | 229 | `dInitExpense21Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用21 | | 230 | `dInitExpense22Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用22 | | 231 | `dInitExpense23Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用23 | | 232 | `dInitExpense24Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用24 | | 233 | `dInitExpense25Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用25 | | 234 | `dInitExpense26Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用26 | | 235 | `dInitExpense27Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用27 | | 236 | `dInitExpense28Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用28 | | 237 | `dInitExpense29Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用29 | | 238 | `dInitExpense30Money` | `decimal(18,6)` | NO | | 0.000000 | | 期初分摊费用30 | | 239 | `dEndExpense21Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用21 | | 240 | `dEndExpense22Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用22 | | 241 | `dEndExpense23Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用23 | | 242 | `dEndExpense24Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用24 | | 243 | `dEndExpense25Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用25 | | 244 | `dEndExpense26Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用26 | | 245 | `dEndExpense27Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用27 | | 246 | `dEndExpense28Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用28 | | 247 | `dEndExpense29Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用29 | | 248 | `dEndExpense30Money` | `decimal(18,6)` | NO | | 0.000000 | | 期末分摊费用30 | | 249 | `dDoingExpense21Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用21 | | 250 | `dDoingExpense22Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用22 | | 251 | `dDoingExpense23Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用23 | | 252 | `dDoingExpense24Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用24 | | 253 | `dDoingExpense25Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用25 | | 254 | `dDoingExpense26Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用26 | | 255 | `dDoingExpense27Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用27 | | 256 | `dDoingExpense28Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用28 | | 257 | `dDoingExpense29Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用29 | | 258 | `dDoingExpense30Money` | `decimal(18,6)` | NO | | 0.000000 | | 在制品分摊费用30 | | 259 | `dExpenseStandard21Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 260 | `dExpense21Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 261 | `dExpenseDif21Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 262 | `dExpenseStandard22Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 263 | `dExpense22Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 264 | `dExpenseDif22Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 265 | `dExpenseStandard23Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 266 | `dExpense23Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 267 | `dExpenseDif23Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 268 | `dExpenseStandard24Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 269 | `dExpense24Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 270 | `dExpenseDif24Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 271 | `dExpenseStandard25Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 272 | `dExpense25Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 273 | `dExpenseDif25Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 274 | `dExpenseStandard26Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 275 | `dExpense26Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 276 | `dExpenseDif26Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 277 | `dExpenseStandard27Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 278 | `dExpense27Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 279 | `dExpenseDif27Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 280 | `dExpenseStandard28Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 281 | `dExpense28Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 282 | `dExpenseDif28Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 283 | `dExpenseStandard29Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 284 | `dExpense29Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 285 | `dExpenseDif29Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 286 | `dExpenseStandard30Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 287 | `dExpense30Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 288 | `dExpenseDif30Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 289 | `sOrderType` | `varchar(100)` | NO | | | | 订单类型 | | 290 | `dAdjustProcessQty` | `decimal(18,6)` | NO | | 0.000000 | | 上报数量 | | 291 | `dExpenseStandard18Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 292 | `dExpenseStandard19Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 293 | `dExpenseStandard20Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 294 | `dExpenseDif18Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 295 | `dExpenseDif19Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 296 | `dExpenseDif20Money` | `decimal(18,6)` | NO | | 0.000000 | | | | 297 | `dBillOutSideCostMoney` | `decimal(18,6)` | NO | | 0.000000 | | 发外成本金额(整单) | | 298 | `dPreviousOutAuxiliaryQty` | `decimal(18,6)` | NO | | 0.000000 | | 上期暂估数量（发外） | | 299 | `dPreviousOutMaterialsQty` | `decimal(18,6)` | NO | | 0.000000 | | 上期暂估换算数量（发外） | | 300 | `dThisInStoreOutAuxiliaryQty` | `decimal(18,6)` | NO | | 0.000000 | | 本期入库数量（发外） | | 301 | `dThisInStoreOutMaterialsQty` | `decimal(18,6)` | NO | | 0.000000 | | 本期入库换算数量（发外） | | 302 | `dThisInvoiceOutAuxiliaryQty` | `decimal(18,6)` | NO | | 0.000000 | | 本期发票数量（发外） | | 303 | `dThisInvoiceOutMaterialsQty` | `decimal(18,6)` | NO | | 0.000000 | | 本期发票换算数量（发外） | | 304 | `sProductPlanSlaveId` | `varchar(100)` | NO | | | | 生产任务ID | | 305 | `sState` | `varchar(11)` | NO | | 0 | | 状态（未排成 0 已排程 1 已下达 2 暂停 3 取消（冻结）4 完工 5） | | 306 | `sDecompose` | `varchar(255)` | NO | | | | 印面自定义 | | 307 | `tReportCompleteDate` | `datetime` | YES | | | | 强制完工日期 | | 308 | `dProductionReportQty` | `decimal(18,6)` | NO | | 0.000000 | | 产量上报数量 | | 309 | `sOutsideType` | `varchar(255)` | NO | | | | 发外类型（工序外发、成品外购） | | 310 | `sWorkOrderControlId` | `varchar(100)` | NO | | | | 工单控制表Id | | 311 | `tBillCompleteDate` | `datetime` | YES | | | | 工单强制完工日期 | | 312 | `dInitQty` | `decimal(18,6)` | NO | | 0.000000 | | 期初数量 | | 313 | `dInitBillOutSideMoney` | `decimal(18,6)` | NO | | 0.000000 | | 期初发外成本金额(整单) | | 314 | `dEndQty` | `decimal(18,6)` | NO | | 0.000000 | | 产出数量 | | 315 | `dEndBillOutSideMoney` | `decimal(18,6)` | NO | | 0.000000 | | 产出发外成本金额(整单) | | 316 | `dDoingBillOutSideMoney` | `decimal(18,6)` | NO | | 0.000000 | | 在制品发外成本金额(整单) | | 317 | `dMaterialsCostBoxMoney` | `decimal(18,6)` | NO | | 0.000000 | | 材料实际成本金额纸箱 | | 318 | `dEndRate` | `decimal(18,6)` | NO | | 0.000000 | | 转出比例 | | 319 | `dProductNoTaxMoney` | `decimal(18,6)` | NO | | 0.000000 | | 销售金额(不含税) | | 320 | `dPeriodProductInBeforeQty` | `decimal(18,6)` | NO | | 0.000000 | | 本期入库前数量 | | 321 | `bOrderComplete` | `bit(1)` | NO | | b'0' | | 订单是否完工 | | 322 | `tOrderCompleteDate` | `datetime` | YES | | | | 订单完工时间 | | 323 | `sOrderCompletePerson` | `varchar(255)` | NO | | | | 完工人 | | 324 | `sOrderCompleteType` | `varchar(255)` | NO | | | | 完工类型 | | 325 | `sOrderCompleteMemo` | `varchar(2000)` | NO | | | | 完工说明 | | 326 | `dVariableCost` | `decimal(18,6)` | NO | | 0.000000 | | 变动成本 | | 327 | `dErrorMoney` | `decimal(18,6)` | NO | | | | 差异金额 | | 328 | `dProductNoTaxPrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 329 | `dProductPrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 330 | `dEndMaterialsPrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 331 | `dEndOtherPrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 332 | `dEndPeoplePrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 333 | `dEndOutsidePrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 334 | `dEndMakePrice` | `decimal(24,13)` | NO | | 0.0000000000000 | | | | 335 | `dOriginalProcessQty` | `decimal(18,6)` | NO | | 0.000000 | | 源数量 | | 336 | `dOriginalHour` | `decimal(18,6)` | NO | | 0.000000 | | 源工时 | | 337 | `sParentProductId` | `varchar(255)` | YES | | | | 主产品子产品 | | 338 | `sFatherSlaveId` | `varchar(255)` | YES | | | | 父级id | | 339 | `dCombineCoefficient` | `decimal(18,6)` | NO | | 0.000000 | | 合版系数 | | 340 | `dConvertQty` | `decimal(18,6)` | NO | | 0.000000 | | 转换入库数 | | 341 | `sWorkOrderMaterialsTbId` | `varchar(100)` | NO | | | | | | 342 | `dInitFatherMoney` | `decimal(18,6)` | NO | | 0.000000 | | | | 343 | `dFatherMoney` | `decimal(18,6)` | NO | | 0.000000 | | | | 344 | `dEndFatherMoney` | `decimal(18,6)` | NO | | 0.000000 | | | | 345 | `dDoingFatherMoney` | `decimal(18,6)` | NO | | 0.000000 | | | | 346 | `sFatherId` | `varchar(100)` | NO | | | | 客户ID | | 347 | `bIsFather` | `bit(1)` | NO | | b'0' | | 是否发外 发外的不用分摊 | | 348 | `bMain` | `bit(1)` | NO | | b'0' | | 是否主工单 | | 349 | `bChild` | `bit(1)` | NO | | b'0' | | 是否子产品 | | 350 | `dMaterialsFatherMoney` | `decimal(18,6)` | NO | | 0.000000 | | 子产品材料金额 | | 351 | `dExpenseFatherMoney` | `decimal(18,6)` | NO | | 0.000000 | | 子产品费用金额 | | 352 | `dPreviousOutPrice` | `decimal(18,6)` | NO | | 0.000000 | | 上期暂估单价 | | 353 | `dPreviousOutMoney` | `decimal(18,6)` | NO | | 0.000000 | | 上期暂估金额 | | 354 | `dThisInStoreOutPrice` | `decimal(18,6)` | NO | | 0.000000 | | 本期入库单价 | | 355 | `dThisInStoreOutMoney` | `decimal(18,6)` | NO | | 0.000000 | | 本期入库金额 | | 356 | `dThisInvoiceOutPrice` | `decimal(18,6)` | NO | | 0.000000 | | 本期发票单价 | | 357 | `dThisInvoiceOutMoney` | `decimal(18,6)` | NO | | 0.000000 | | 本期发票金额 | | 358 | `dThisOutSideMoney` | `decimal(18,6)` | NO | | 0.000000 | | 本期入库金额 | ## Narrative _No human-written narrative yet — when this table is exercised by a [vertical slice](../../slices/index.md), link from there back to this page._