viw_etpmachineplan.md 2.94 KB

Edit Raw Blame History



viw_etpmachineplan（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
tCreateDate
datetime
NO


5
sMakePerson
varchar(255)
NO


6
iOrder
int
NO


7
sFormId
varchar(100)
NO


8
sBillNo
varchar(255)
NO


9
sMemo
text
YES


10
bCheck
bit(1)
NO


11
tCheckDate
datetime
YES


12
sCheckPerson
varchar(255)
YES


13
bPrint
bit(1)
NO


14
bCopyLimit
bit(1)
NO


15
sStatus
varchar(255)
YES


16
bInvalid
bit(1)
NO


17
sMachineId
varchar(100)
NO


18
sMReserve1
varchar(255)
YES


19
sMReserve2
varchar(255)
YES


20
sMReserve3
varchar(255)
YES


21
sMReserve4
varchar(255)
YES


22
sMReserve5
varchar(255)
YES


23
sMReserve6
varchar(255)
YES


24
dMReserve1
decimal(18,6)
YES


25
dMReserve2
decimal(18,6)
YES


26
dMReserve3
decimal(18,6)
YES


27
iMReserve1
int
YES


28
iMReserve2
int
YES


29
iMReserve3
int
YES


30
tMReserve1
datetime
YES


31
tMReserve2
datetime
YES


32
sSlaveId
varchar(100)
NO


33
iSlaveOrder
int
NO


34
sParentId
varchar(100)
NO


35
sSrcId
varchar(100)
NO


36
sSrcSlaveId
varchar(100)
NO


37
sSrcNo
varchar(100)
NO


定义
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`iOrder` AS `iOrder`,`m`.`sFormId` AS `sFormId`,`m`.`sBillNo` AS `sBillNo`,`m`.`sMemo` AS `sMemo`,`m`.`bCheck` AS `bCheck`,`m`.`tCheckDate` AS `tCheckDate`,`m`.`sCheckPerson` AS `sCheckPerson`,`m`.`bPrint` AS `bPrint`,`m`.`bCopyLimit` AS `bCopyLimit`,`m`.`sStatus` AS `sStatus`,`m`.`bInvalid` AS `bInvalid`,`m`.`sMachineId` AS `sMachineId`,`m`.`sMReserve1` AS `sMReserve1`,`m`.`sMReserve2` AS `sMReserve2`,`m`.`sMReserve3` AS `sMReserve3`,`m`.`sMReserve4` AS `sMReserve4`,`m`.`sMReserve5` AS `sMReserve5`,`m`.`sMReserve6` AS `sMReserve6`,`m`.`dMReserve1` AS `dMReserve1`,`m`.`dMReserve2` AS `dMReserve2`,`m`.`dMReserve3` AS `dMReserve3`,`m`.`iMReserve1` AS `iMReserve1`,`m`.`iMReserve2` AS `iMReserve2`,`m`.`iMReserve3` AS `iMReserve3`,`m`.`tMReserve1` AS `tMReserve1`,`m`.`tMReserve2` AS `tMReserve2`,`s`.`sId` AS `sSlaveId`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sSrcId` AS `sSrcId`,`s`.`sSrcSlaveId` AS `sSrcSlaveId`,`s`.`sSrcNo` AS `sSrcNo` from (`xlyweberp_saas_ai`.`etpmachineplanmaster` `m` join `xlyweberp_saas_ai`.`etpmachineplanslave` `s` on((`m`.`sId` = `s`.`sParentId`)))


说明

暂无人工说明。