viw_revsupply.md 8.1 KB

Edit Raw Blame History



viw_revsupply（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
iIncrement
int
NO


2
sId
varchar(100)
NO


3
sBrandsId
varchar(100)
NO


4
sSubsidiaryId
varchar(100)
NO


5
tCreateDate
datetime
NO


6
sMakePerson
varchar(255)
NO


7
iOrder
int
NO


8
sFormId
varchar(100)
NO


9
sBillNo
varchar(255)
NO


10
sSupplyId
varchar(100)
YES


11
sMemo
text
YES


12
bCheck
bit(1)
NO


13
tCheckDate
datetime
YES


14
sCheckPerson
varchar(255)
YES


15
bPrint
bit(1)
NO


16
bCopyLimit
bit(1)
NO


17
sStatus
varchar(255)
YES


18
bInvalid
bit(1)
NO


19
sMReserve1
varchar(255)
YES


20
sMReserve2
varchar(255)
YES


21
sMReserve3
varchar(255)
YES


22
sMReserve4
varchar(255)
YES


23
sMReserve5
varchar(255)
YES


24
sMReserve6
varchar(255)
YES


25
dMReserve1
decimal(18,6)
YES


26
dMReserve2
decimal(18,6)
YES


27
dMReserve3
decimal(18,6)
YES


28
iMReserve1
int
YES


29
iMReserve2
int
YES


30
iMReserve3
int
YES


31
tMReserve1
datetime
YES


32
tMReserve2
datetime
YES


33
sTestStandardId
varchar(100)
YES


34
iReviewType
int
YES


35
sSlaveId
varchar(100)
NO


36
sParentId
varchar(100)
NO


37
sSReserve1
varchar(255)
YES


38
sSReserve2
varchar(255)
YES


39
sSReserve3
varchar(255)
YES


40
sSReserve4
varchar(255)
YES


41
sSReserve5
varchar(255)
YES


42
sSReserve6
varchar(255)
YES


43
dSReserve1
decimal(18,6)
YES


44
dSReserve2
decimal(18,6)
YES


45
dSReserve3
decimal(18,6)
YES


46
iSReserve1
int
YES


47
iSReserve2
int
YES


48
iSReserve3
int
YES


49
tSReserve1
datetime
YES


50
tSReserve2
datetime
YES


51
sSMemo
text
YES


52
iScoreOne
int
YES


53
iScoreTwo
int
YES


54
iScoreThree
int
YES


55
iScoreFour
int
YES


56
bSubCheck
bit(1)
YES


57
tSubCheckDate
datetime
YES


58
sSubCheckPerson
varchar(255)
YES


59
iScoreTotal
bigint
YES


60
bSupplyInvalid
bit(1)
YES


61
iHappendCount
int
YES


62
dInStoreMoney
decimal(18,2)
YES


63
dAccidentRate
decimal(18,2)
YES


64
dDeliverRate
decimal(18,2)
YES


65
dAccidentMoney
decimal(18,2)
YES


66
dOutMoney
decimal(18,2)
YES


67
iQualityScore
int
YES


68
iSystemScore
int
YES


69
iDeliverScore
int
YES


70
iPriceScore
int
YES


71
iServiceScore
int
YES


定义
select `xlyweberp_saas_ai`.`revsupplymaster`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`revsupplymaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`revsupplymaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`revsupplymaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`revsupplymaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`revsupplymaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`revsupplymaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`revsupplymaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`revsupplymaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`revsupplyslave`.`sSupplyId` AS `sSupplyId`,`xlyweberp_saas_ai`.`revsupplymaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`revsupplymaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`revsupplymaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`revsupplymaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`revsupplymaster`.`bPrint` AS `bPrint`,`xlyweberp_saas_ai`.`revsupplymaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`revsupplymaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`revsupplymaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`revsupplymaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`revsupplymaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`revsupplymaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`revsupplymaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`revsupplymaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`revsupplymaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`revsupplymaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`revsupplymaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`revsupplymaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`revsupplymaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`revsupplymaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`revsupplymaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`revsupplymaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`revsupplymaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`revsupplymaster`.`sTestStandardId` AS `sTestStandardId`,`xlyweberp_saas_ai`.`revsupplymaster`.`iReviewType` AS `iReviewType`,`xlyweberp_saas_ai`.`revsupplyslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`revsupplyslave`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`revsupplyslave`.`sSReserve1` AS `sSReserve1`,`xlyweberp_saas_ai`.`revsupplyslave`.`sSReserve2` AS `sSReserve2`,`xlyweberp_saas_ai`.`revsupplyslave`.`sSReserve3` AS `sSReserve3`,`xlyweberp_saas_ai`.`revsupplyslave`.`sSReserve4` AS `sSReserve4`,`xlyweberp_saas_ai`.`revsupplyslave`.`sSReserve5` AS `sSReserve5`,`xlyweberp_saas_ai`.`revsupplyslave`.`sSReserve6` AS `sSReserve6`,`xlyweberp_saas_ai`.`revsupplyslave`.`dSReserve1` AS `dSReserve1`,`xlyweberp_saas_ai`.`revsupplyslave`.`dSReserve2` AS `dSReserve2`,`xlyweberp_saas_ai`.`revsupplyslave`.`dSReserve3` AS `dSReserve3`,`xlyweberp_saas_ai`.`revsupplyslave`.`iSReserve1` AS `iSReserve1`,`xlyweberp_saas_ai`.`revsupplyslave`.`iSReserve2` AS `iSReserve2`,`xlyweberp_saas_ai`.`revsupplyslave`.`iSReserve3` AS `iSReserve3`,`xlyweberp_saas_ai`.`revsupplyslave`.`tSReserve1` AS `tSReserve1`,`xlyweberp_saas_ai`.`revsupplyslave`.`tSReserve2` AS `tSReserve2`,`xlyweberp_saas_ai`.`revsupplyslave`.`sSMemo` AS `sSMemo`,`xlyweberp_saas_ai`.`revsupplyslave`.`iScoreOne` AS `iScoreOne`,`xlyweberp_saas_ai`.`revsupplyslave`.`iScoreTwo` AS `iScoreTwo`,`xlyweberp_saas_ai`.`revsupplyslave`.`iScoreThree` AS `iScoreThree`,`xlyweberp_saas_ai`.`revsupplyslave`.`iScoreFour` AS `iScoreFour`,`xlyweberp_saas_ai`.`revsupplymaster`.`bSubCheck` AS `bSubCheck`,`xlyweberp_saas_ai`.`revsupplymaster`.`tSubCheckDate` AS `tSubCheckDate`,`xlyweberp_saas_ai`.`revsupplymaster`.`sSubCheckPerson` AS `sSubCheckPerson`,((((`xlyweberp_saas_ai`.`revsupplyslave`.`iQualityScore` + `xlyweberp_saas_ai`.`revsupplyslave`.`iSystemScore`) + `xlyweberp_saas_ai`.`revsupplyslave`.`iDeliverScore`) + `xlyweberp_saas_ai`.`revsupplyslave`.`iPriceScore`) + `xlyweberp_saas_ai`.`revsupplyslave`.`iServiceScore`) AS `iScoreTotal`,`xlyweberp_saas_ai`.`revsupplymaster`.`bSupplyInvalid` AS `bSupplyInvalid`,`xlyweberp_saas_ai`.`revsupplyslave`.`iHappendCount` AS `iHappendCount`,`xlyweberp_saas_ai`.`revsupplyslave`.`dInStoreMoney` AS `dInStoreMoney`,`xlyweberp_saas_ai`.`revsupplyslave`.`dAccidentRate` AS `dAccidentRate`,`xlyweberp_saas_ai`.`revsupplyslave`.`dDeliverRate` AS `dDeliverRate`,`xlyweberp_saas_ai`.`revsupplyslave`.`dAccidentMoney` AS `dAccidentMoney`,`xlyweberp_saas_ai`.`revsupplyslave`.`dOutMoney` AS `dOutMoney`,`xlyweberp_saas_ai`.`revsupplyslave`.`iQualityScore` AS `iQualityScore`,`xlyweberp_saas_ai`.`revsupplyslave`.`iSystemScore` AS `iSystemScore`,`xlyweberp_saas_ai`.`revsupplyslave`.`iDeliverScore` AS `iDeliverScore`,`xlyweberp_saas_ai`.`revsupplyslave`.`iPriceScore` AS `iPriceScore`,`xlyweberp_saas_ai`.`revsupplyslave`.`iServiceScore` AS `iServiceScore` from (`xlyweberp_saas_ai`.`revsupplymaster` join `xlyweberp_saas_ai`.`revsupplyslave` on((`xlyweberp_saas_ai`.`revsupplymaster`.`sId` = `xlyweberp_saas_ai`.`revsupplyslave`.`sParentId`)))


说明

暂无人工说明。