viw_knifemould.md 4.13 KB

Edit Raw Blame History Permalink



viw_knifemould（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
iIncrement
int
NO


2
sId
varchar(100)
NO


3
sBrandsId
varchar(100)
NO


4
tCreateDate
datetime
NO


5
tRecipientPerson
datetime
YES


6
tRecipientReturnPerson
datetime
YES


7
sSubsidiaryId
varchar(100)
NO


8
iOrder
int
NO


9
sMakePerson
varchar(255)
NO


10
sRecipientPerson
varchar(100)
YES


11
sRecipientReturnPerson
varchar(100)
YES


12
sKnifeMouldNo
varchar(255)
NO


13
sKnifeMouldName
varchar(255)
NO


14
sKnifeMouldStyle
varchar(255)
YES


15
sStoreShelveId
varchar(100)
YES


16
dDurable
decimal(18,6)
NO


17
sState
varchar(255)
NO


18
sMemo
text
YES


19
sFormId
varchar(100)
NO


20
bActivate
bit(1)
NO


21
bInvalid
bit(1)
NO


22
sMReserve1
varchar(255)
YES


23
sMReserve2
varchar(255)
YES


24
sMReserve3
varchar(255)
YES


25
sMReserve4
varchar(255)
YES


26
sPlateType
varchar(100)
NO


27
sProductId
varchar(100)
NO


28
sParentId
varchar(100)
NO


29
sSlaveId
varchar(100)
NO


30
iSlaveOrder
int
NO


31
sProcessId
varchar(100)
YES


32
dProcessQty
decimal(18,6)
YES


33
dProductionReportQty
decimal(18,6)
YES


34
sOldKnifeMouldNo
varchar(255)
YES


定义
select `xlyweberp_saas_ai`.`eleknifemould`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`eleknifemould`.`sId` AS `sId`,`xlyweberp_saas_ai`.`eleknifemould`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`eleknifemould`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`eleknifemould`.`tRecipientPerson` AS `tRecipientPerson`,`xlyweberp_saas_ai`.`eleknifemould`.`tRecipientReturnPerson` AS `tRecipientReturnPerson`,`xlyweberp_saas_ai`.`eleknifemould`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`eleknifemould`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`eleknifemould`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`eleknifemould`.`sRecipientPerson` AS `sRecipientPerson`,`xlyweberp_saas_ai`.`eleknifemould`.`sRecipientReturnPerson` AS `sRecipientReturnPerson`,`xlyweberp_saas_ai`.`eleknifemould`.`sKnifeMouldNo` AS `sKnifeMouldNo`,`xlyweberp_saas_ai`.`eleknifemould`.`sKnifeMouldName` AS `sKnifeMouldName`,`xlyweberp_saas_ai`.`eleknifemould`.`sKnifeMouldStyle` AS `sKnifeMouldStyle`,`xlyweberp_saas_ai`.`eleknifemould`.`sStoreShelveId` AS `sStoreShelveId`,`xlyweberp_saas_ai`.`eleknifemould`.`dDurable` AS `dDurable`,`xlyweberp_saas_ai`.`eleknifemould`.`sState` AS `sState`,`xlyweberp_saas_ai`.`eleknifemould`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`eleknifemould`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`eleknifemould`.`bActivate` AS `bActivate`,`xlyweberp_saas_ai`.`eleknifemould`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`eleknifemould`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`eleknifemould`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`eleknifemould`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`eleknifemould`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`eleknifemould`.`sPlateType` AS `sPlateType`,`xlyweberp_saas_ai`.`eleknifemouldproduct`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`eleknifemouldproduct`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`eleknifemouldproduct`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`eleknifemouldproduct`.`iOrder` AS `iSlaveOrder`,`xlyweberp_saas_ai`.`eleknifemould`.`sProcessId` AS `sProcessId`,`xlyweberp_saas_ai`.`eleknifemould`.`dProcessQty` AS `dProcessQty`,`xlyweberp_saas_ai`.`eleknifemould`.`dProductionReportQty` AS `dProductionReportQty`,`xlyweberp_saas_ai`.`eleknifemould`.`sOldKnifeMouldNo` AS `sOldKnifeMouldNo` from (`xlyweberp_saas_ai`.`eleknifemould` join `xlyweberp_saas_ai`.`eleknifemouldproduct` on((`xlyweberp_saas_ai`.`eleknifemould`.`sId` = `xlyweberp_saas_ai`.`eleknifemouldproduct`.`sParentId`)))


说明

暂无人工说明。