business logic query GeneralizedCodeForSecurity

Description

GeneralizedCodeForSecurity: query that allows conditions on code_domain, code_fldname and code_value.
The code_cmmt in the resul-set will either contain a * (meaning all companies are accessible), either a comma-separated list of company-codes that are accessible

Parameters

icDomainCode	character	DomainCode: the code of the domain
icCodeFldName	character	CodeFldName: this is normaly the area wherefor the security is setup. Possible value "GLUSERID":U
icCodeValue	character	CodeValue: in caase of the security, this paramater can contain a user-login

query condition

each code_mstr where

code_mstr.code_domain = icDomainCode AND
code_mstr.code_fldname = icCodeFldName AND
code_mstr.code_value = icCodeValue

query sort order

code_mstr.code_domain (ascending)
code_mstr.code_fldname (ascending)
code_mstr.code_value (ascending)

query resultset tqGeneralizedCodeForSecurity

field name	data type	db field	description
tccode_domain	character	code_mstr.code_domain	Domain
tccode_fldname	character	code_mstr.code_fldname	Field Name
tccode_value	character	code_mstr.code_value	Value
tccode_cmmt	character	code_mstr.code_cmmt	Comments
tccode_desc	character	code_mstr.code_desc	Description
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(code_mstr)

Internal usage

QadFinancials

method BAPMatching.CreateAPMatchingLNTaxFromGTM
method BAPMatching.GetPendingVouchersLogChargesTaxWHT
method BAPMatching.GetPendingVouchersNoLogChargesTaxFiscalWHT
method BAPMatching.GetPendingVouchersNoLogChargesTaxWHT
method BAPMatching.GetPendingVouchersPOShipperTaxWHT
method BCInvoice.DefaultValuesTax
method BCInvoice.DefaultValuesWHTCode
method BCInvoice.GetWHTDescriptionAndCCExch
method TMfgEntitySecurity.Main