viw_mitcheckprofitloss.md 4.76 KB

Edit Raw Blame History



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


定义
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`


说明

暂无人工说明。