viw_eleteamperiod.md 815 Bytes

Edit Raw Blame History



viw_eleteamperiod (view)


Updatable: NO


Columns


#
Name
Type
Null


1
sPeriodId
varchar(100)
YES


2
iPeriodId
bigint
YES


3
sTeamId
varchar(100)
NO


4
sTeamNo
varchar(255)
YES


5
sTeamName
varchar(255)
YES


6
sBrandsId
varchar(100)
NO


7
sSubsidiaryId
varchar(100)
NO


8
iOrder
int
NO


Definition
select distinct `a`.`sPeriodId` AS `sPeriodId`,cast(`a`.`sPeriodId` as signed) AS `iPeriodId`,`b`.`sId` AS `sTeamId`,`b`.`sTeamNo` AS `sTeamNo`,`b`.`sTeamName` AS `sTeamName`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,0 AS `iOrder` from (`sysaccountperiod` `a` join `eleteam` `b`)


Narrative

No human-written narrative yet.