# `viw_mitcheckprofitloss` (view)


- **Updatable:** YES

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 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 |

## Definition

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

## Narrative

_No human-written narrative yet._
