project BLF > class BSystem > business logic query System
Description
System properties; returns information about he overall system
Parameters
iiLanguageID | integer | LanguageID of the system |
query condition
each Syst where
Syst.Lng_ID = iiLanguageID
first Domains (inner-join) where
Domains.Domain_ID = Syst.Domain_ID AND
first Lng (outer-join) where
Lng.Lng_ID = Syst.Lng_ID AND
first Usr (outer-join) where
Usr.Usr_ID = Syst.Usr_ID AND
query resultset tqSystem
field name | data type | db field | description |
tcDomainCode | character | Domains.DomainCode | Domain |
tcSystAdminUserPwd | character | Syst.SystAdminUserPwd | System Admin Password |
tcSystApplicationId | character | Syst.SystApplicationId | Application ID |
tcUsrLogin | character | Usr.UsrLogin | Login |
tcLngCode | character | Lng.LngCode | Language Code |
tlLngIsSystemLanguage | logical | Lng.LngIsSystemLanguage | System Language |
tiSyst_ID | integer | Syst.Syst_ID | Record ID |
tiLng_ID | integer | Syst.Lng_ID | Language |
Internal usage
BLF
QadFinancials