viw_mitcheckprofitloss.md 4.04 KB

Edit Raw Blame History



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