accordercostanalysis.md
29.6 KB
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, link from there back to this page.