viw_elematerialscoach.md 4.84 KB

Edit Raw Blame History



viw_elematerialscoach（视图）


是否可更新： 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
sBillNo
varchar(50)
YES


9
sMemo
text
YES


10
bInvalid
bit(1)
NO


11
sMReserve1
varchar(255)
YES


12
sMReserve2
varchar(255)
YES


13
sMReserve3
varchar(255)
YES


14
sMReserve4
varchar(255)
YES


15
sMReserve5
varchar(255)
YES


16
sMReserve6
varchar(255)
YES


17
dMReserve1
decimal(18,6)
YES


18
dMReserve2
decimal(18,6)
YES


19
dMReserve3
decimal(18,6)
YES


20
iMReserve1
int
YES


21
iMReserve2
int
YES


22
iMReserve3
int
YES


23
tMReserve1
datetime
YES


24
tMReserve2
datetime
YES


25
bStartMark
bit(1)
NO


26
sFormId
varchar(255)
YES


27
tCheckDate
datetime
YES


28
sCheckPerson
varchar(255)
YES


29
sStatus
varchar(255)
YES


30
bCheck
bit(1)
YES


31
sEmployeeId
varchar(255)
YES


32
sSlaveId
varchar(100)
NO


33
sParentId
varchar(100)
NO


34
sSlaveMemo
varchar(2000)
YES


35
sMaterialsId
varchar(255)
YES


36
dNewPrice
decimal(24,13)
NO


37
dOldPrice
decimal(24,13)
NO


38
iCigPack
int
YES


39
sCigPack
varchar(1)
NO


定义
select `xlyweberp_saas_ai`.`elematerialscoachmaster`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`bStartMark` AS `bStartMark`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sEmployeeId` AS `sEmployeeId`,`xlyweberp_saas_ai`.`elematerialscoachslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`elematerialscoachslave`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`elematerialscoachslave`.`sSlaveMemo` AS `sSlaveMemo`,`xlyweberp_saas_ai`.`elematerialscoachslave`.`sMaterialsId` AS `sMaterialsId`,`xlyweberp_saas_ai`.`elematerialscoachslave`.`dNewPrice` AS `dNewPrice`,`xlyweberp_saas_ai`.`elematerialscoachslave`.`dOldPrice` AS `dOldPrice`,`xlyweberp_saas_ai`.`elematerialscoachmaster`.`iCigPack` AS `iCigPack`,(case `xlyweberp_saas_ai`.`elematerialscoachmaster`.`iCigPack` when 1 then '是' else '否' end) AS `sCigPack` from (`xlyweberp_saas_ai`.`elematerialscoachmaster` join `xlyweberp_saas_ai`.`elematerialscoachslave` on((`xlyweberp_saas_ai`.`elematerialscoachmaster`.`sId` = `xlyweberp_saas_ai`.`elematerialscoachslave`.`sParentId`)))


说明

暂无人工说明。