viw_mftprocesschange.md 5.16 KB

Edit Raw Blame History



viw_mftprocesschange（视图）


是否可更新： NO

定义者： 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
sFormId
varchar(100)
NO


7
iOrder
int
NO


8
sBillNo
varchar(255)
NO


9
sManualNo
varchar(255)
NO


10
sType
varchar(255)
NO


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
tStartDate
datetime
YES


34
tEndDate
datetime
YES


35
sWorkOrderId
varchar(100)
NO


36
sWorkOrderNo
varchar(255)
NO


37
sCustomerId
varchar(100)
NO


38
sCustomerName
varchar(100)
NO


39
sProductId
varchar(255)
YES


40
sSlaveId
varchar(100)
YES


41
iSlaveOrder
int
YES


42
sParentId
varchar(100)
YES


43
sProcessId
varchar(100)
YES


44
sSReserve1
varchar(255)
YES


45
sSReserve2
varchar(255)
YES


46
sSReserve3
varchar(255)
YES


47
sSReserve4
varchar(255)
YES


48
sSReserve5
varchar(255)
YES


49
sSReserve6
varchar(255)
YES


50
dSReserve1
decimal(18,6)
YES


51
dSReserve2
decimal(18,6)
YES


52
dSReserve3
decimal(18,6)
YES


53
iSReserve1
int
YES


54
iSReserve2
int
YES


55
iSReserve3
int
YES


56
tSReserve1
datetime
YES


57
tSReserve2
datetime
YES


58
sSrcSlaveId
varchar(100)
YES


59
sSrcId
varchar(100)
YES


60
sOriginalProcessId
varchar(100)
YES


61
sSlaveType
varchar(255)
YES


62
sBeforeMemo
text
YES


63
sAfterMemo
text
YES


64
iChangeType
int
YES


65
iFileType
int
YES


66
iProposeType
int
YES


定义
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`sFormId` AS `sFormId`,`m`.`iOrder` AS `iOrder`,`m`.`sBillNo` AS `sBillNo`,`m`.`sManualNo` AS `sManualNo`,`m`.`sType` AS `sType`,`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`.`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`,`m`.`tStartDate` AS `tStartDate`,`m`.`tEndDate` AS `tEndDate`,`m`.`sWorkOrderId` AS `sWorkOrderId`,`m`.`sWorkOrderNo` AS `sWorkOrderNo`,`m`.`sCustomerId` AS `sCustomerId`,`m`.`sCustomerName` AS `sCustomerName`,`m`.`sProductId` AS `sProductId`,if((ifnull(`s`.`sId`,'') = ''),`m`.`sId`,`s`.`sId`) AS `sSlaveId`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sProcessId` AS `sProcessId`,`s`.`sSReserve1` AS `sSReserve1`,`s`.`sSReserve2` AS `sSReserve2`,`s`.`sSReserve3` AS `sSReserve3`,`s`.`sSReserve4` AS `sSReserve4`,`s`.`sSReserve5` AS `sSReserve5`,`s`.`sSReserve6` AS `sSReserve6`,`s`.`dSReserve1` AS `dSReserve1`,`s`.`dSReserve2` AS `dSReserve2`,`s`.`dSReserve3` AS `dSReserve3`,`s`.`iSReserve1` AS `iSReserve1`,`s`.`iSReserve2` AS `iSReserve2`,`s`.`iSReserve3` AS `iSReserve3`,`s`.`tSReserve1` AS `tSReserve1`,`s`.`tSReserve2` AS `tSReserve2`,`s`.`sSrcSlaveId` AS `sSrcSlaveId`,`s`.`sSrcId` AS `sSrcId`,`s`.`sOriginalProcessId` AS `sOriginalProcessId`,`s`.`sType` AS `sSlaveType`,`m`.`sBeforeMemo` AS `sBeforeMemo`,`m`.`sAfterMemo` AS `sAfterMemo`,`m`.`iChangeType` AS `iChangeType`,`m`.`iFileType` AS `iFileType`,`m`.`iProposeType` AS `iProposeType` from (`xlyweberp_saas_ai`.`mftprocesschangemaster` `m` left join `xlyweberp_saas_ai`.`mftprocesschangeslave` `s` on((`m`.`sId` = `s`.`sParentId`)))


说明

暂无人工说明。