viw_elemachineperiod.md 896 Bytes

Edit Raw Blame History



viw_elemachineperiod (view)


Updatable: NO


Columns


#
Name
Type
Null


1
sPeriodId
varchar(100)
YES


2
iPeriodId
bigint
YES


3
sMachineId
varchar(50)
NO


4
sMachineNo
varchar(50)
NO


5
sMachineName
varchar(100)
NO


6
iPlcNo
int
NO


7
sBrandsId
varchar(100)
NO


8
sSubsidiaryId
varchar(100)
NO


9
iOrder
int
NO


Definition
select distinct `a`.`sPeriodId` AS `sPeriodId`,cast(`a`.`sPeriodId` as signed) AS `iPeriodId`,`b`.`sId` AS `sMachineId`,`b`.`sMachineNo` AS `sMachineNo`,`b`.`sMachineName` AS `sMachineName`,`b`.`iPlcNo` AS `iPlcNo`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,0 AS `iOrder` from (`sysaccountperiod` `a` join `elemachine` `b`)


Narrative

No human-written narrative yet.