# `cotordercostanalysis`


- **Engine:** InnoDB
- **Collation:** utf8mb3_general_ci

## Columns

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

## Indexes

| Name | Unique | Type | Columns |
|---|---|---|---|
| `CotOrderCostAnalysis_1` |  | BTREE | `sId`, `iType` |
| `CotOrderCostAnalysis_2` |  | BTREE | `sCostPeriod`, `sWorkOrderNo` |
| `CotOrderCostAnalysis_3` |  | BTREE | `sCostPeriod`, `iType` |
| `CotOrderCostAnalysis_4` |  | BTREE | `sProductId`, `sWorkOrderSlaveId` |
| `CotOrderCostAnalysis_sCustomerId` |  | BTREE | `sCustomerId` |
| `CotOrderCostAnalysis_sId` |  | BTREE | `sId` |
| `CotOrderCostAnalysis_sProductId` |  | BTREE | `sProductId` |

## 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._