project QadFinancials > class BMfgAccountDefaultMaster > business logic query AccountDefaultMasterByPrimKey

Description

AccountDefaultMasterByPrimKey; query that allows you to filter on fields of the primary-key


Parameters


icDomainCodecharacterDomainCode
icModulecharacter
icTypecharacter
icKey1character
icKey2character
icKey3character
icKey4character
icKey5character
icKey6character


query condition


  each acdf_mstr where
acdf_mstr.acdf_domain = icDomainCode AND
acdf_mstr.acdf_module = icModule AND
acdf_mstr.acdf_type = icType AND
acdf_mstr.acdf_key1 = icKey1 AND
acdf_mstr.acdf_key2 = icKey2 AND
acdf_mstr.acdf_key3 = icKey3 AND
acdf_mstr.acdf_key4 = icKey4 AND
acdf_mstr.acdf_key5 = icKey5 AND
acdf_mstr.acdf_key6 = icKey6


query resultset tqAccountDefaultMasterByPrimKey


field namedata typedb fielddescription
tcacdf_acctcharacteracdf_mstr.acdf_acctAccount Number
tcacdf_cccharacteracdf_mstr.acdf_ccCost Center
tcacdf_domaincharacteracdf_mstr.acdf_domainDomain
tcacdf_key1characteracdf_mstr.acdf_key1
tcacdf_key2characteracdf_mstr.acdf_key2
tcacdf_key3characteracdf_mstr.acdf_key3
tcacdf_key4characteracdf_mstr.acdf_key4
tcacdf_key5characteracdf_mstr.acdf_key5
tcacdf_key6characteracdf_mstr.acdf_key6
tcacdf_modulecharacteracdf_mstr.acdf_moduleModule
tcacdf_subcharacteracdf_mstr.acdf_subSub Account
tcacdf_typecharacteracdf_mstr.acdf_typeAccount Type
tdoid_acdf_mstrdecimalacdf_mstr.oid_acdf_mstr
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(acdf_mstr)


Internal usage


QadFinancials
method BAPMatching.AdditionalUpdatesAllLinesPLVarExchRateAccount
method BAPMatching.AdditionalUpdatesAllLinesPLVarUsage
method BAPMatching.AdditionalUpdatesAllQueriesStart
method BAPMatching.AdditionalUpdatesAllQueriesStop
method BAPMatching.AdditionalUpdatesAllTaxGetPPV
method BCompanyProperty.CreateInterCoAccounts
method BMfgPOReceipt.GetAccountInformationOnPOReceiptNoLC
method BAPMatching.AdditionalUpdatesAllTaxGetLogChargePPV
method BAPMatching.GetGLPLVarRateLogCharge
method BAPMatching.GetGLPLVarRateNormal