# `viw_mitcheckprofitloss`（视图）


- **是否可更新：** YES
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sId` | `varchar(100)` | NO |
| 2 | `sSlaveId` | `varchar(100)` | NO |
| 3 | `sBrandsId` | `varchar(100)` | NO |
| 4 | `sSubsidiaryId` | `varchar(100)` | NO |
| 5 | `tCreateDate` | `datetime` | NO |
| 6 | `sMakePerson` | `varchar(100)` | NO |
| 7 | `iOrder` | `int` | NO |
| 8 | `sEmployeeId` | `varchar(100)` | NO |
| 9 | `sMaterialsId` | `varchar(100)` | NO |
| 10 | `sMaterialsStyle` | `varchar(255)` | NO |
| 11 | `dAuxiliaryQty` | `decimal(18,6)` | NO |
| 12 | `sAuxiliaryUnit` | `varchar(255)` | NO |
| 13 | `dMaterialsQty` | `decimal(18,6)` | NO |
| 14 | `dConversionQty` | `decimal(18,6)` | NO |
| 15 | `dMaterialsPrice` | `decimal(18,6)` | NO |
| 16 | `dMaterialsMoney` | `decimal(18,6)` | NO |
| 17 | `sMemo` | `text` | YES |
| 18 | `sDefineNo` | `varchar(100)` | NO |
| 19 | `sDefineNo2` | `varchar(100)` | NO |
| 20 | `dOriginalAuxiliaryQty` | `decimal(18,6)` | NO |
| 21 | `dOriginalQty` | `decimal(18,6)` | NO |
| 22 | `dOriginalMoney` | `decimal(18,6)` | NO |
| 23 | `dProfitLossAuxiliaryQty` | `decimal(18,6)` | NO |
| 24 | `dProfitLossQty` | `decimal(18,6)` | NO |
| 25 | `dProfitLossPrice` | `decimal(18,6)` | NO |
| 26 | `dProfitLossMoney` | `decimal(18,6)` | NO |
| 27 | `sSrcSlaveId` | `varchar(100)` | NO |
| 28 | `sSrcId` | `varchar(100)` | NO |
| 29 | `sSrcNo` | `varchar(255)` | NO |
| 30 | `sWareHouseId` | `varchar(100)` | NO |
| 31 | `sLocationId` | `varchar(100)` | NO |
| 32 | `sWareHouseLocationId` | `varchar(100)` | NO |
| 33 | `sCurrency` | `varchar(3)` | NO |
| 34 | `dCurrencyRate` | `int` | NO |
| 35 | `dProductMoney` | `decimal(18,6)` | NO |
| 36 | `dProductTaxMoney` | `int` | NO |
| 37 | `dProductNoTaxMoney` | `int` | NO |
| 38 | `dProductTaxForeignMoney` | `int` | NO |
| 39 | `dProductForeignMoney` | `decimal(18,6)` | NO |
| 40 | `dCostMoney` | `int` | NO |
| 41 | `sBillNo` | `char(0)` | NO |
| 42 | `sFormId` | `char(0)` | NO |

## 定义

```sql
select `xlyweberp_saas_ai`.`mitcheckprofitloss`.`sId` AS `sId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sEmployeeId` AS `sEmployeeId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sMaterialsId` AS `sMaterialsId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sMaterialsStyle` AS `sMaterialsStyle`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dMaterialsQty` AS `dMaterialsQty`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dConversionQty` AS `dConversionQty`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dMaterialsPrice` AS `dMaterialsPrice`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dMaterialsMoney` AS `dMaterialsMoney`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sDefineNo` AS `sDefineNo`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sDefineNo2` AS `sDefineNo2`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dOriginalAuxiliaryQty` AS `dOriginalAuxiliaryQty`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dOriginalQty` AS `dOriginalQty`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dOriginalMoney` AS `dOriginalMoney`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dProfitLossAuxiliaryQty` AS `dProfitLossAuxiliaryQty`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dProfitLossQty` AS `dProfitLossQty`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dProfitLossPrice` AS `dProfitLossPrice`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dProfitLossMoney` AS `dProfitLossMoney`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sSrcSlaveId` AS `sSrcSlaveId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sSrcId` AS `sSrcId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sSrcNo` AS `sSrcNo`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sWareHouseId` AS `sWareHouseId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sLocationId` AS `sLocationId`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`sWareHouseLocationId` AS `sWareHouseLocationId`,'人名币' AS `sCurrency`,1 AS `dCurrencyRate`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dProfitLossMoney` AS `dProductMoney`,0 AS `dProductTaxMoney`,0 AS `dProductNoTaxMoney`,0 AS `dProductTaxForeignMoney`,`xlyweberp_saas_ai`.`mitcheckprofitloss`.`dProfitLossMoney` AS `dProductForeignMoney`,0 AS `dCostMoney`,'' AS `sBillNo`,'' AS `sFormId` from `xlyweberp_saas_ai`.`mitcheckprofitloss`
```

## 说明

_暂无人工说明。_
