# `cotordercostanalysis20251124145341` - **预估行数：** 0 - **数据大小：** 16.0 KB - **引擎：** InnoDB - **排序规则：** utf8mb3_general_ci - **创建时间：** 2026-04-27 18:52:04 - **更新时间：** ## 字段 | # | 名称 | 类型 | 可空 | 键 | 默认值 | 额外属性 | 备注 | |---|---|---|---|---|---|---|---| | 1 | `sBrandsId` | `varchar(100)` | YES | | | | | | 2 | `sSubsidiaryId` | `varchar(100)` | YES | | | | | | 3 | `sId` | `varchar(100)` | NO | | | | 工单ID或装配单ID | | 4 | `sWorkOrderNo` | `varchar(100)` | YES | | | | 工单号 | | 5 | `sWorkOrderSlaveId` | `varchar(100)` | YES | | | | 工单从表Id | | 6 | `sCostPeriod` | `varchar(100)` | YES | | | | 成本期间 | | 7 | `iOrder` | `int` | YES | | | | 排序号 | | 8 | `sCustomerId` | `varchar(100)` | NO | | | | 客户ID | | 9 | `sCustomerNo` | `varchar(100)` | YES | | | | 客户号 | | 10 | `sCustomerName` | `varchar(100)` | YES | | | | 客户名称 | | 11 | `sSalesOrderNo` | `varchar(100)` | YES | | | | 订单号 | | 12 | `sOrderSlaveId` | `varchar(100)` | YES | | | | 订单从表ID | | 13 | `sProductId` | `varchar(100)` | NO | | | | 产品ID | | 14 | `sProductNo` | `varchar(100)` | YES | | | | 产品号 | | 15 | `sProductName` | `varchar(100)` | YES | | | | 产品名称 / 部件名称 | | 16 | `sProductStyle` | `varchar(100)` | YES | | | | 产品规格 /工序 / 材料名称 | | 17 | `dProductQty` | `decimal(18,6)` | YES | | | | 产品数量 /计划数量 | | 18 | `sProductUnit` | `varchar(100)` | YES | | | | 产品单位 /上报单位 | | 19 | `dAreaQty` | `decimal(18,6)` | YES | | | | 印刷总面积 | | 20 | `dStdHour` | `decimal(18,6)` | YES | | | | 工序标准工时 | | 21 | `dProductCostPrice` | `decimal(18,6)` | YES | | | | 成本单价 | | 22 | `dCostProductMoney` | `decimal(18,6)` | YES | | | | 工单标准成本 | | 23 | `dFreight` | `decimal(18,6)` | YES | | | | 运费 | | 24 | `dProductTaxMoney` | `decimal(18,6)` | YES | | | | 产品税额 | | 25 | `dProductMoney` | `decimal(18,6)` | YES | | | | 销售金额 | | 26 | `dReceiptMoney` | `decimal(18,6)` | YES | | | | 收款金额 | | 27 | `sMakePerson` | `varchar(100)` | YES | | | | 制单人 | | 28 | `tCreateDate` | `datetime` | YES | | | | 制单日期 | | 29 | `tBillCompleteDate` | `datetime` | YES | | | | 完工日期 | | 30 | `tFactCountCost` | `datetime` | YES | | | | 计算成本日期 | | 31 | `dPeriodCostProductMoney` | `decimal(18,6)` | YES | | | | 本期成本 | | 32 | `dPeriodProductInQty` | `decimal(18,6)` | YES | | | | 本期入库数量 dPeriodProductInQty | | 33 | `dPeriodProductInPrice` | `decimal(18,6)` | YES | | | | 本期入库单价 dPeriodProductInPrice | | 34 | `dMaterialsCostMoney` | `decimal(18,6)` | YES | | | | 材料实际成本金额 | | 35 | `dMaterialsStdMoney` | `decimal(18,6)` | YES | | | | 材料成本金额 | | 36 | `dMaterialsDifMoney` | `decimal(18,6)` | YES | | | | 材料差异 | | 37 | `dOutSideCostMoney` | `decimal(18,6)` | YES | | | | 发外成本金额(对应发外入库) dOutSideCostMoney | | 38 | `dOutSideStdCostMoney` | `decimal(18,6)` | YES | | | | 发外成本金额(对应工序成本) | | 39 | `dOutSideDifMoney` | `decimal(18,6)` | YES | | | | 发外差异 | | 40 | `dShareMoney` | `decimal(18,6)` | YES | | | | 分摊金额 | | 41 | `sProcessId` | `varchar(100)` | YES | | | | 工序ID | | 42 | `sProcessName` | `varchar(100)` | YES | | | | 工序名称 | | 43 | `sWorkCenterName` | `varchar(100)` | YES | | | | 工作中心名称 | | 44 | `sWorkOrderProcessTbId` | `varchar(100)` | YES | | | | 工单工序表Guid | | 45 | `iType` | `int` | YES | | | | 类型 0 工单，1 材料， 2工序 | | 46 | `dSaleRate` | `decimal(18,6)` | YES | | | | 销售率 | | 47 | `dSaleProfit` | `decimal(18,6)` | YES | | | | 销售利润 | | 48 | `dStandardSalary` | `decimal(18,6)` | YES | | | | 标准薪资(工序成本) | | 49 | `dLaborMoney` | `decimal(18,6)` | YES | | | | 实际薪资 | | 50 | `dLaborDifMoney` | `decimal(18,6)` | YES | | | | 薪资差异 | | 51 | `dManufactureRate` | `decimal(18,6)` | YES | | | | 生产利润率 | | 52 | `dManufactureProfit` | `decimal(18,6)` | YES | | | | 生产利润 | | 53 | `dNetRate` | `decimal(18,6)` | YES | | | | 净利率 | | 54 | `dNetProfit` | `decimal(18,6)` | YES | | | | 净利润 | | 55 | `bOutSide` | `bit(1)` | YES | | | | 是否发外 发外的不用分摊 | | 56 | `bBillComplete` | `bit(1)` | YES | | | | 单据是否完工 | | 57 | `dInitMoney` | `decimal(18,6)` | YES | | | | 期初金额 | | 58 | `dSumMoney` | `decimal(18,6)` | YES | | | | 总金额 | | 59 | `dEndMoney` | `decimal(18,6)` | YES | | | | 累计成本金额 | | 60 | `dEarlyQty` | `decimal(18,6)` | YES | | | | 产成品-期初之前累计数量 | | 61 | `dEarlyMoney` | `decimal(18,6)` | YES | | | | 产成品-期初之前累计金额 | | 62 | `dDoingQty` | `decimal(18,6)` | YES | | | | 在制品-数量 | | 63 | `dDoingMoney` | `decimal(18,6)` | YES | | | | 在制品-金额 | | 64 | `dInProductCostMoney` | `decimal(18,6)` | YES | | | | 本期入库金额 | | 65 | `dProductCarryOverQty` | `decimal(18,6)` | YES | | | | 结转入库数量 | | 66 | `iPositiveColor` | `int` | YES | | 0 | | 印色 | | 67 | `sManualNo` | `varchar(100)` | YES | | | | 手工单号 | | 68 | `dCostCenter1Money` | `decimal(18,6)` | YES | | | | | | 69 | `dCostCenter2Money` | `decimal(18,6)` | YES | | | | | | 70 | `dCostCenter3Money` | `decimal(18,6)` | YES | | | | | | 71 | `dCostCenter4Money` | `decimal(18,6)` | YES | | | | | | 72 | `dCostCenter5Money` | `decimal(18,6)` | YES | | | | | | 73 | `dCostCenter6Money` | `decimal(18,6)` | YES | | | | | | 74 | `dCostCenter7Money` | `decimal(18,6)` | YES | | | | | | 75 | `dCostCenter8Money` | `decimal(18,6)` | YES | | | | | | 76 | `dCostCenter9Money` | `decimal(18,6)` | YES | | | | | | 77 | `dCostCenter10Money` | `decimal(18,6)` | YES | | | | | | 78 | `dCostCenter11Money` | `decimal(18,6)` | YES | | | | | | 79 | `dExpenseStandard1Money` | `decimal(18,6)` | YES | | | | | | 80 | `dExpense1Money` | `decimal(18,6)` | YES | | | | | | 81 | `dExpenseDif1Money` | `decimal(18,6)` | YES | | | | | | 82 | `dExpenseStandard2Money` | `decimal(18,6)` | YES | | | | | | 83 | `dExpense2Money` | `decimal(18,6)` | YES | | | | | | 84 | `dExpenseDif2Money` | `decimal(18,6)` | YES | | | | | | 85 | `dExpenseStandard3Money` | `decimal(18,6)` | YES | | | | | | 86 | `dExpense3Money` | `decimal(18,6)` | YES | | | | | | 87 | `dExpenseDif3Money` | `decimal(18,6)` | YES | | | | | | 88 | `dExpenseStandard4Money` | `decimal(18,6)` | YES | | | | | | 89 | `dExpense4Money` | `decimal(18,6)` | YES | | | | | | 90 | `dExpenseDif4Money` | `decimal(18,6)` | YES | | | | | | 91 | `dExpenseStandard5Money` | `decimal(18,6)` | YES | | | | | | 92 | `dExpense5Money` | `decimal(18,6)` | YES | | | | | | 93 | `dExpenseDif5Money` | `decimal(18,6)` | YES | | | | | | 94 | `dExpenseStandard6Money` | `decimal(18,6)` | YES | | | | | | 95 | `dExpense6Money` | `decimal(18,6)` | YES | | | | | | 96 | `dExpenseDif6Money` | `decimal(18,6)` | YES | | | | | | 97 | `dExpenseStandard7Money` | `decimal(18,6)` | YES | | | | | | 98 | `dExpense7Money` | `decimal(18,6)` | YES | | | | | | 99 | `dExpenseDif7Money` | `decimal(18,6)` | YES | | | | | | 100 | `dExpenseStandard8Money` | `decimal(18,6)` | YES | | | | | | 101 | `dExpense8Money` | `decimal(18,6)` | YES | | | | | | 102 | `dExpenseDif8Money` | `decimal(18,6)` | YES | | | | | | 103 | `dExpenseStandard9Money` | `decimal(18,6)` | YES | | | | | | 104 | `dExpense9Money` | `decimal(18,6)` | YES | | | | | | 105 | `dExpenseDif9Money` | `decimal(18,6)` | YES | | | | | | 106 | `dExpenseStandard10Money` | `decimal(18,6)` | YES | | | | | | 107 | `dExpense10Money` | `decimal(18,6)` | YES | | | | | | 108 | `dExpenseDif10Money` | `decimal(18,6)` | YES | | | | | | 109 | `dExpenseStandard11Money` | `decimal(18,6)` | YES | | | | | | 110 | `dExpense11Money` | `decimal(18,6)` | YES | | | | | | 111 | `dExpenseDif11Money` | `decimal(18,6)` | YES | | | | | | 112 | `dExpenseStandard12Money` | `decimal(18,6)` | YES | | | | | | 113 | `dExpense12Money` | `decimal(18,6)` | YES | | | | | | 114 | `dExpenseDif12Money` | `decimal(18,6)` | YES | | | | | | 115 | `dExpenseStandard13Money` | `decimal(18,6)` | YES | | | | | | 116 | `dExpense13Money` | `decimal(18,6)` | YES | | | | | | 117 | `dExpenseDif13Money` | `decimal(18,6)` | YES | | | | | | 118 | `dExpenseStandard14Money` | `decimal(18,6)` | YES | | | | | | 119 | `dExpense14Money` | `decimal(18,6)` | YES | | | | | | 120 | `dExpenseDif14Money` | `decimal(18,6)` | YES | | | | | | 121 | `dExpenseStandard15Money` | `decimal(18,6)` | YES | | | | | | 122 | `dExpense15Money` | `decimal(18,6)` | YES | | | | | | 123 | `dExpenseDif15Money` | `decimal(18,6)` | YES | | | | | | 124 | `dExpenseStandard16Money` | `decimal(18,6)` | YES | | | | | | 125 | `dExpense16Money` | `decimal(18,6)` | YES | | | | | | 126 | `dExpenseDif16Money` | `decimal(18,6)` | YES | | | | | | 127 | `dExpenseStandard17Money` | `decimal(18,6)` | YES | | | | | | 128 | `dExpense17Money` | `decimal(18,6)` | YES | | | | | | 129 | `dExpenseDif17Money` | `decimal(18,6)` | YES | | | | | | 130 | `dExpenseStandard18Money` | `decimal(18,6)` | YES | | | | | | 131 | `dExpense18Money` | `decimal(18,6)` | YES | | | | | | 132 | `dExpenseDif18Money` | `decimal(18,6)` | YES | | | | | | 133 | `dExpenseStandard19Money` | `decimal(18,6)` | YES | | | | | | 134 | `dExpense19Money` | `decimal(18,6)` | YES | | | | | | 135 | `dExpenseDif19Money` | `decimal(18,6)` | YES | | | | | | 136 | `dExpenseStandard20Money` | `decimal(18,6)` | YES | | | | | | 137 | `dExpense20Money` | `decimal(18,6)` | YES | | | | | | 138 | `dExpenseDif20Money` | `decimal(18,6)` | YES | | | | | | 139 | `dExpenseStandard21Money` | `decimal(18,6)` | YES | | | | | | 140 | `dExpense21Money` | `decimal(18,6)` | YES | | | | | | 141 | `dExpenseDif21Money` | `decimal(18,6)` | YES | | | | | | 142 | `dExpenseStandard22Money` | `decimal(18,6)` | YES | | | | | | 143 | `dExpense22Money` | `decimal(18,6)` | YES | | | | | | 144 | `dExpenseDif22Money` | `decimal(18,6)` | YES | | | | | | 145 | `dExpenseStandard23Money` | `decimal(18,6)` | YES | | | | | | 146 | `dExpense23Money` | `decimal(18,6)` | YES | | | | | | 147 | `dExpenseDif23Money` | `decimal(18,6)` | YES | | | | | | 148 | `dExpenseStandard24Money` | `decimal(18,6)` | YES | | | | | | 149 | `dExpense24Money` | `decimal(18,6)` | YES | | | | | | 150 | `dExpenseDif24Money` | `decimal(18,6)` | YES | | | | | | 151 | `dExpenseStandard25Money` | `decimal(18,6)` | YES | | | | | | 152 | `dExpense25Money` | `decimal(18,6)` | YES | | | | | | 153 | `dExpenseDif25Money` | `decimal(18,6)` | YES | | | | | | 154 | `dExpenseStandard26Money` | `decimal(18,6)` | YES | | | | | | 155 | `dExpense26Money` | `decimal(18,6)` | YES | | | | | | 156 | `dExpenseDif26Money` | `decimal(18,6)` | YES | | | | | | 157 | `dExpenseStandard27Money` | `decimal(18,6)` | YES | | | | | | 158 | `dExpense27Money` | `decimal(18,6)` | YES | | | | | | 159 | `dExpenseDif27Money` | `decimal(18,6)` | YES | | | | | ## 说明 _暂无人工说明；当某个[垂直切片](../../slices/index.md)使用这张表时，请从切片反向链接到本页。_