project QadFinancials > class BMfgGeneralizedCode > 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


icDomainCodecharacterDomainCode: the code of the domain
icCodeFldNamecharacterCodeFldName: this is normaly the area wherefor the security is setup. Possible value "GLUSERID":U
icCodeValuecharacterCodeValue: 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 namedata typedb fielddescription
tccode_domaincharactercode_mstr.code_domainDomain
tccode_fldnamecharactercode_mstr.code_fldnameField Name
tccode_valuecharactercode_mstr.code_valueValue
tccode_cmmtcharactercode_mstr.code_cmmtComments
tccode_desccharactercode_mstr.code_descDescription
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = 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