# `accordercostanmainalysis`


- **Rows (estimated):** 349
- **Data size:** 336.0 KB
- **Engine:** InnoDB
- **Collation:** utf8mb3_general_ci
- **Created:** 2026-04-27 18:51:12
- **Updated:** 2026-04-27 18:51:12

## 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 | `dProductMoney` | `decimal(18,6)` | NO |  | 0.000000 |  | 销售金额 |
| 21 | `sMakePerson` | `varchar(100)` | NO |  |  |  | 制单人 |
| 22 | `tCreateDate` | `datetime` | YES |  |  |  | 制单日期 |
| 23 | `iType` | `int` | NO |  | 0 |  | 类型 0 工单，1 材料， 2工序 |
| 24 | `sOrderId` | `varchar(100)` | NO |  |  |  | 订单id |
| 25 | `sOrderSlaveId` | `varchar(100)` | NO |  |  |  | 订单从表id |
| 26 | `dExpense1Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额1 |
| 27 | `dExpense2Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额2 |
| 28 | `dExpense3Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额3 |
| 29 | `dExpense4Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额4 |
| 30 | `dExpense5Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额5 |
| 31 | `dExpense6Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额6 |
| 32 | `dExpense7Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额7 |
| 33 | `dExpense8Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额8 |
| 34 | `dExpense9Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额9 |
| 35 | `dExpense10Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额10 |
| 36 | `dExpense11Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额11 |
| 37 | `dExpense12Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额12 |
| 38 | `dExpense13Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额13 |
| 39 | `dExpense14Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额14 |
| 40 | `dExpense15Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额15 |
| 41 | `dExpense16Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额16 |
| 42 | `dExpense17Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额17 |
| 43 | `dExpense18Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额18 |
| 44 | `dExpense19Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额19 |
| 45 | `dExpense20Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额20 |
| 46 | `dExpense21Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额21 |
| 47 | `dExpense22Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额22 |
| 48 | `dExpense23Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额23 |
| 49 | `dExpense24Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额24 |
| 50 | `dExpense25Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额25 |
| 51 | `dExpense26Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额26 |
| 52 | `dExpense27Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额27 |
| 53 | `dExpense28Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额28 |
| 54 | `dExpense29Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额29 |
| 55 | `dExpense30Money` | `decimal(18,6)` | NO |  | 0.000000 |  | 本期投入金额30 |
| 56 | `sCostPeriod` | `varchar(100)` | NO |  |  |  | 月份 |

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