business logic query CompanyForDomainProperties

Description

Get domain properties for a specific company

iiCompanyId	integer	Company id
icCompanyCode	character

each Company where

Company.Company_Id = iiCompanyId AND
Company.CompanyCode = icCompanyCode

first Domains (inner-join) where

Domains.Domain_ID = Company.Domain_ID AND

each DomainProperty (inner-join) where

DomainProperty.Domain_ID = Domains.Domain_ID AND

field name	data type	db field	description
tiCompany_ID	integer	Company.Company_ID	Record ID
tcCompanyCode	character	Company.CompanyCode	Entity Code
tcDomainCode	character	Domains.DomainCode	Domain
tlDomainPropertyIsChronolNr	logical	DomainProperty.DomainPropertyIsChronolNr	Chronological Invoice Numbering
tlDomainPropertyIsConsecutNr	logical	DomainProperty.DomainPropertyIsConsecutNr	Consecutive Invoice Numbering
tlDomainPropertyIsInvCertific	logical	DomainProperty.DomainPropertyIsInvCertific	Invoice Certification: activated or not
tlDomainPropertyIsPopupInvNr	logical	DomainProperty.DomainPropertyIsPopupInvNr	Show Supplier Invoice Number in Pop-up After Save
tcDomainPropertyNonChronErr	character	DomainProperty.DomainPropertyNonChronErr	Action on Non-Chronological Number
tcDomainPropertyWHTDueMoment	character	DomainProperty.DomainPropertyWHTDueMoment	WHT Due at

QadFinancials