project QadFinancials > class BMfgSystemAccountControl > business logic query SystemAccountControlForAll


Parameters


icDomainCodecharacterDomainCode


query condition


  each gl_ctrl where
gl_ctrl.gl_domain = icDomainCode


query resultset tqSystemAccountControlForAll


field namedata typedb fielddescription
tcgl__qadc09charactergl_ctrl.gl__qadc09Bank Acct Validation
tcgl_ap_acctcharactergl_ctrl.gl_ap_acctPayables
tcgl_ap_cccharactergl_ctrl.gl_ap_ccAP Cost Ctr
tcgl_ap_subcharactergl_ctrl.gl_ap_subPayables Sub-Acct
tcgl_apds_acctcharactergl_ctrl.gl_apds_acctAP Discount
tcgl_apds_cccharactergl_ctrl.gl_apds_ccAP Disc Cost Ctr
tcgl_apds_subcharactergl_ctrl.gl_apds_subAP Discount Sub
tcgl_apvr_acctcharactergl_ctrl.gl_apvr_acctAP Rate Variance
tcgl_apvr_cccharactergl_ctrl.gl_apvr_ccAP Rate Var Cost Ctr
tcgl_apvr_subcharactergl_ctrl.gl_apvr_subAP Rate Variance Sub
tcgl_apvrx_acctcharactergl_ctrl.gl_apvrx_acctExpensed Item Rate Var
tcgl_apvrx_cccharactergl_ctrl.gl_apvrx_ccExpensed Items Rate Var CC
tcgl_apvrx_subcharactergl_ctrl.gl_apvrx_subExp Item Rate Var Sub
tcgl_apvu_acctcharactergl_ctrl.gl_apvu_acctAP Usage Variance
tcgl_apvu_cccharactergl_ctrl.gl_apvu_ccAP Usage Var Cost Ctr
tcgl_apvu_subcharactergl_ctrl.gl_apvu_subAP Usage Variance Sub
tcgl_apvux_acctcharactergl_ctrl.gl_apvux_acctExpensed Item Usage Var
tcgl_apvux_cccharactergl_ctrl.gl_apvux_ccExpense Items Use Var CC
tcgl_apvux_subcharactergl_ctrl.gl_apvux_subExp Item Usage Sub
tcgl_ar_acctcharactergl_ctrl.gl_ar_acctReceivables
tcgl_ar_cccharactergl_ctrl.gl_ar_ccAR Cost Ctr
tcgl_ar_subcharactergl_ctrl.gl_ar_subReceivables Sub-Acct
tcgl_base_currcharactergl_ctrl.gl_base_currBase Currency
tcgl_bdn_acctcharactergl_ctrl.gl_bdn_acctBurden
tcgl_bdn_cccharactergl_ctrl.gl_bdn_ccBurden Cost Ctr
tcgl_bdn_subcharactergl_ctrl.gl_bdn_subBurden Sub-Acct
tcgl_bvar_acctcharactergl_ctrl.gl_bvar_acctBurden Usage Var
tcgl_bvar_cccharactergl_ctrl.gl_bvar_ccBurden Usage Variance CC
tcgl_bvar_subcharactergl_ctrl.gl_bvar_subBurden Usage Var Sub
tcgl_bvrr_acctcharactergl_ctrl.gl_bvrr_acctBurden Rate Var
tcgl_bvrr_cccharactergl_ctrl.gl_bvrr_ccBurden Rate Variance CC
tcgl_bvrr_subcharactergl_ctrl.gl_bvrr_subBurden Rate Var Sub
tlgl_canlogicalgl_ctrl.gl_canCanadian Tax
tcgl_cbdn_acctcharactergl_ctrl.gl_cbdn_acctCOGS Burden Acct
tcgl_cbdn_cccharactergl_ctrl.gl_cbdn_ccCOGS Burden CC
tcgl_cbdn_subcharactergl_ctrl.gl_cbdn_subCOGS Burden Sub-Acct
tcgl_cchg_acctcharactergl_ctrl.gl_cchg_acctCost Revalue Acct
tcgl_cchg_cccharactergl_ctrl.gl_cchg_ccCost Revalue Cost Ctr
tcgl_cchg_subcharactergl_ctrl.gl_cchg_subCost Revalue Sub-Acct
tcgl_clbr_acctcharactergl_ctrl.gl_clbr_acctCOGS Labor Acct
tcgl_clbr_cccharactergl_ctrl.gl_clbr_ccCOGS Labor CC
tcgl_clbr_subcharactergl_ctrl.gl_clbr_subCOGS Labor Sub-Acct
tcgl_cmtl_acctcharactergl_ctrl.gl_cmtl_acctCOGS Material Acct
tcgl_cmtl_cccharactergl_ctrl.gl_cmtl_ccCOGS Material CC
tcgl_cmtl_subcharactergl_ctrl.gl_cmtl_subCOGS Material Sub-Acct
tcgl_cog_acctcharactergl_ctrl.gl_cog_acctCost of Goods
tcgl_cog_cccharactergl_ctrl.gl_cog_ccCost of Goods Cost Ctr
tcgl_cog_subcharactergl_ctrl.gl_cog_subCost of Goods Sub_Acct
tcgl_cop_acctcharactergl_ctrl.gl_cop_acctCost Of Production
tcgl_cop_cccharactergl_ctrl.gl_cop_ccCost of Production Cost Ctr
tcgl_cop_subcharactergl_ctrl.gl_cop_subCost Of Production Sub
tcgl_covh_acctcharactergl_ctrl.gl_covh_acctCOGS Overhead Acct
tcgl_covh_cccharactergl_ctrl.gl_covh_ccCOGS Overhead CC
tcgl_covh_subcharactergl_ctrl.gl_covh_subCOGS Overhead Sub-Acct
tcgl_crterms_acctcharactergl_ctrl.gl_crterms_acctCredit Terms Interest Account
tcgl_crterms_cccharactergl_ctrl.gl_crterms_ccCredit Terms Interest CC
tcgl_crterms_subcharactergl_ctrl.gl_crterms_subCredit Terms Int Sub
tcgl_cs_acctcharactergl_ctrl.gl_cs_acctSales Cash
tcgl_cs_cccharactergl_ctrl.gl_cs_ccCash Cost Ctr
tcgl_cs_subcharactergl_ctrl.gl_cs_subSales Cash Sub-Acct
tcgl_csub_acctcharactergl_ctrl.gl_csub_acctCOGS Subcontract Acct
tcgl_csub_cccharactergl_ctrl.gl_csub_ccCOGS Subcontract CC
tcgl_csub_subcharactergl_ctrl.gl_csub_subCOGS Subcontract Sub-Acct
tcgl_disc_acctcharactergl_ctrl.gl_disc_acctSales Discount
tcgl_disc_cccharactergl_ctrl.gl_disc_ccDisc Cost Ctr
tcgl_disc_subcharactergl_ctrl.gl_disc_subSales Disc Sub-Acct
tcgl_domaincharactergl_ctrl.gl_domainDomain
tcgl_dscr_acctcharactergl_ctrl.gl_dscr_acctInv Discrep Acct
tcgl_dscr_cccharactergl_ctrl.gl_dscr_ccInv Discrep Cost Ctr
tcgl_dscr_subcharactergl_ctrl.gl_dscr_subInv Discrep Sub-Acct
tcgl_entitycharactergl_ctrl.gl_entityEntity
tcgl_esls_acctcharactergl_ctrl.gl_esls_acctExempt Sales Acct
tcgl_esls_cccharactergl_ctrl.gl_esls_ccExempt Sales Cost Ctr
tcgl_ex_ratetypecharactergl_ctrl.gl_ex_ratetypeExchange Rate Type
tcgl_ex_rnd_acctcharactergl_ctrl.gl_ex_rnd_acctExchange Rounding Acct
tcgl_ex_rnd_cccharactergl_ctrl.gl_ex_rnd_ccExchange Rounding CC
tcgl_ex_rnd_subcharactergl_ctrl.gl_ex_rnd_subExchange Rounding Sub
tigl_ex_roundintegergl_ctrl.gl_ex_roundRound Factor
tcgl_fin_acctcharactergl_ctrl.gl_fin_acctSales Finance
tcgl_fin_cccharactergl_ctrl.gl_fin_ccFinance Cost Ctr
tcgl_fin_subcharactergl_ctrl.gl_fin_subSales Finance Sub
tcgl_flr_acctcharactergl_ctrl.gl_flr_acctFloor Stock Account
tcgl_flr_cccharactergl_ctrl.gl_flr_ccFloor Stock CC
tcgl_flr_subcharactergl_ctrl.gl_flr_subFloor Stock Sub-Acct
tcgl_frtacc_acctcharactergl_ctrl.gl_frtacc_acctSales Freight Accrued Account
tcgl_frtacc_cccharactergl_ctrl.gl_frtacc_ccCost Center
tcgl_frtacc_subcharactergl_ctrl.gl_frtacc_subSales Frt Accrued Sub
tcgl_frtapp_acctcharactergl_ctrl.gl_frtapp_acctSales Freight Applied Account
tcgl_frtapp_cccharactergl_ctrl.gl_frtapp_ccCost Center
tcgl_frtapp_subcharactergl_ctrl.gl_frtapp_subSales Frt Applied Sub
tcgl_fsaccr_acctcharactergl_ctrl.gl_fsaccr_acctAccrued Revenue
tcgl_fsaccr_cccharactergl_ctrl.gl_fsaccr_ccAccrued Revenue CC
tcgl_fsaccr_subcharactergl_ctrl.gl_fsaccr_subAccrued Revenue Sub-Acct
tcgl_fsbdn_acctcharactergl_ctrl.gl_fsbdn_acctService Burden
tcgl_fsbdn_cccharactergl_ctrl.gl_fsbdn_ccService Burden CC
tcgl_fsbdn_subcharactergl_ctrl.gl_fsbdn_subService Burden Sub
tcgl_fscm_inv_acctcharactergl_ctrl.gl_fscm_inv_acctCustomer Inventory
tcgl_fscm_inv_cccharactergl_ctrl.gl_fscm_inv_ccCustomer Inventory CC
tcgl_fscm_inv_subcharactergl_ctrl.gl_fscm_inv_subCustomer Inv Sub
tcgl_fsdef_acctcharactergl_ctrl.gl_fsdef_acctDeferred Revenue
tcgl_fsdef_cccharactergl_ctrl.gl_fsdef_ccDeferred Revenue CC
tcgl_fsdef_subcharactergl_ctrl.gl_fsdef_subDeferred Revenue Sub-Acct
tcgl_fsexd_acctcharactergl_ctrl.gl_fsexd_acctExpense Due Employee
tcgl_fsexd_cccharactergl_ctrl.gl_fsexd_ccExpense Due CC
tcgl_fsexd_subcharactergl_ctrl.gl_fsexd_subExpense Due Emp Sub
tcgl_fsexp_acctcharactergl_ctrl.gl_fsexp_acctService Expense
tcgl_fsexp_cccharactergl_ctrl.gl_fsexp_ccService Expense CC
tcgl_fsexp_subcharactergl_ctrl.gl_fsexp_subService Expense Sub
tcgl_fslbr_acctcharactergl_ctrl.gl_fslbr_acctService Labor
tcgl_fslbr_cccharactergl_ctrl.gl_fslbr_ccService Labor CC
tcgl_fslbr_subcharactergl_ctrl.gl_fslbr_subService Labor Sub
tcgl_fsrc_inv_acctcharactergl_ctrl.gl_fsrc_inv_acctRepair Center Inventory
tcgl_fsrc_inv_cccharactergl_ctrl.gl_fsrc_inv_ccRepair Center Inv CC
tcgl_fsrc_inv_subcharactergl_ctrl.gl_fsrc_inv_subRepair Center Inv Sub
tigl_index1integergl_ctrl.gl_index1Index
tcgl_inv_acctcharactergl_ctrl.gl_inv_acctInventory Acct
tcgl_inv_cccharactergl_ctrl.gl_inv_ccInventory Cost Ctr
tcgl_inv_subcharactergl_ctrl.gl_inv_subInventory Sub-Acct
tcgl_langcharactergl_ctrl.gl_langDefault System Language
tcgl_late_acctcharactergl_ctrl.gl_late_acctCredit Terms Late Interest Acct
tcgl_late_cccharactergl_ctrl.gl_late_ccCredit Terms Late Interest CC
tcgl_late_subcharactergl_ctrl.gl_late_subCr Terms Late Inte Sub
tcgl_lbr_acctcharactergl_ctrl.gl_lbr_acctLabor
tcgl_lbr_cccharactergl_ctrl.gl_lbr_ccLabor Cost Ctr
tcgl_lbr_subcharactergl_ctrl.gl_lbr_subLabor Sub-Acct
tcgl_lvar_acctcharactergl_ctrl.gl_lvar_acctLabor Usage Var
tcgl_lvar_cccharactergl_ctrl.gl_lvar_ccLabor Usage Variance CC
tcgl_lvar_subcharactergl_ctrl.gl_lvar_subLabor Usage Var Sub
tcgl_lvrr_acctcharactergl_ctrl.gl_lvrr_acctLabor Rate Var
tcgl_lvrr_cccharactergl_ctrl.gl_lvrr_ccLabor Rate Variance CC
tcgl_lvrr_subcharactergl_ctrl.gl_lvrr_subLabor Rate Var Sub
tcgl_mvar_acctcharactergl_ctrl.gl_mvar_acctMaterial Usage Var
tcgl_mvar_cccharactergl_ctrl.gl_mvar_ccMaterial Usage Variance CC
tcgl_mvar_subcharactergl_ctrl.gl_mvar_subMaterial Usage Var Sub
tcgl_mvrr_acctcharactergl_ctrl.gl_mvrr_acctMaterial Rate Var
tcgl_mvrr_cccharactergl_ctrl.gl_mvrr_ccMaterial Rate Variance CC
tcgl_mvrr_subcharactergl_ctrl.gl_mvrr_subMaterial Rate Var Sub
tcgl_ot_acctcharactergl_ctrl.gl_ot_acctOvertime
tcgl_ot_cccharactergl_ctrl.gl_ot_ccOvertime Cost Ctr
tcgl_ot_subcharactergl_ctrl.gl_ot_subOvertime Sub-Acct
tcgl_ovh_acctcharactergl_ctrl.gl_ovh_acctOverhead Appl Acct
tcgl_ovh_cccharactergl_ctrl.gl_ovh_ccOverhead Appl CC
tcgl_ovh_subcharactergl_ctrl.gl_ovh_subOverhead Appl Sub-Acct
tcgl_ppv_acctcharactergl_ctrl.gl_ppv_acctPO Price Variance
tcgl_ppv_cccharactergl_ctrl.gl_ppv_ccPO Price Var Cost Ctr
tcgl_ppv_subcharactergl_ctrl.gl_ppv_subPO Price Variance Sub
tcgl_pur_acctcharactergl_ctrl.gl_pur_acctPurchases
tcgl_pur_cccharactergl_ctrl.gl_pur_ccPurchases Cost Ctr
tcgl_pur_subcharactergl_ctrl.gl_pur_subPurchases Sub
tcgl_rcpt_acctcharactergl_ctrl.gl_rcpt_acctPO Receipts Acct
tcgl_rcpt_cccharactergl_ctrl.gl_rcpt_ccPO Receipts Cost Ctr
tcgl_rcpt_subcharactergl_ctrl.gl_rcpt_subPO Receipts Sub-Acct
tcgl_rcptx_acctcharactergl_ctrl.gl_rcptx_acctExpensed Item Receipts
tcgl_rcptx_cccharactergl_ctrl.gl_rcptx_ccExpensed Receipts Cost Ctr
tcgl_rcptx_subcharactergl_ctrl.gl_rcptx_subExp Item Receipts Sub
tcgl_rgain_acctcharactergl_ctrl.gl_rgain_acctRealized Exchange Gain Acct
tcgl_rgain_cccharactergl_ctrl.gl_rgain_ccRealized Exchange Gain CC
tcgl_rgain_subcharactergl_ctrl.gl_rgain_subRealized Exch Gain Sub
tcgl_rloss_acctcharactergl_ctrl.gl_rloss_acctRealized Exchange Loss Acct
tcgl_rloss_cccharactergl_ctrl.gl_rloss_ccRealized Exchange Loss CC
tcgl_rloss_subcharactergl_ctrl.gl_rloss_subRealized Exch Loss Sub
tcgl_rmar_acctcharactergl_ctrl.gl_rmar_acctService Returns
tcgl_rmar_cccharactergl_ctrl.gl_rmar_ccService Returns CC
tcgl_rmar_subcharactergl_ctrl.gl_rmar_subService Returns Sub
tcgl_rnd_mthdcharactergl_ctrl.gl_rnd_mthdRounding Method
tcgl_rtns_acctcharactergl_ctrl.gl_rtns_acctSales Returns
tcgl_rtns_cccharactergl_ctrl.gl_rtns_ccReturns Cost Ctr
tcgl_rtns_subcharactergl_ctrl.gl_rtns_subSales Returns Sub
tcgl_scrp_acctcharactergl_ctrl.gl_scrp_acctScrap
tcgl_scrp_cccharactergl_ctrl.gl_scrp_ccScrap Cost Ctr
tcgl_scrp_subcharactergl_ctrl.gl_scrp_subScrap Sub-Acct
tcgl_sls_acctcharactergl_ctrl.gl_sls_acctSales
tcgl_sls_cccharactergl_ctrl.gl_sls_ccSales Cost Ctr
tcgl_sls_subcharactergl_ctrl.gl_sls_subSales Sub-Account
tigl_sub_lenintegergl_ctrl.gl_sub_lenSub-Module Sub-Account Length
tcgl_svar_acctcharactergl_ctrl.gl_svar_acctSubcontract Usage Var
tcgl_svar_cccharactergl_ctrl.gl_svar_ccSubcontract Usage Variance CC
tcgl_svar_subcharactergl_ctrl.gl_svar_subSub Usage Var Sub
tcgl_svrr_acctcharactergl_ctrl.gl_svrr_acctSubcontract Rate Var
tcgl_svrr_cccharactergl_ctrl.gl_svrr_ccSubcontract Rate Variance CC
tcgl_svrr_subcharactergl_ctrl.gl_svrr_subSub Rate Var Sub
tcgl_symbolcharactergl_ctrl.gl_symbolSymbol
tcgl_tax_typecharactergl_ctrl.gl_tax_typeTax Type
tcgl_tax1_acctcharactergl_ctrl.gl_tax1_acctSales Tax 1
tcgl_tax1_cccharactergl_ctrl.gl_tax1_ccTax Cost Ctr
tcgl_tax2_acctcharactergl_ctrl.gl_tax2_acctSales Tax 2
tcgl_tax2_cccharactergl_ctrl.gl_tax2_ccTax Cost Ctr
tcgl_tax3_acctcharactergl_ctrl.gl_tax3_acctSales Tax 3
tcgl_tax3_cccharactergl_ctrl.gl_tax3_ccTax Cost Ctr
tcgl_term_acctcharactergl_ctrl.gl_term_acctSales Terms
tcgl_term_cccharactergl_ctrl.gl_term_ccTerms Cost Ctr
tcgl_term_subcharactergl_ctrl.gl_term_subSales Terms Sub
tcgl_timezonecharactergl_ctrl.gl_timezoneServer Time Zone
tcgl_txap_acctcharactergl_ctrl.gl_txap_acctAP Tax Account
tcgl_txap_cccharactergl_ctrl.gl_txap_ccAP Tax Cost Center
tcgl_txap_cn_acctcharactergl_ctrl.gl_txap_cn_acctAP Tax CN Account
tcgl_txap_cn_subcharactergl_ctrl.gl_txap_cn_subAP Tax CN Sub-Account
tcgl_txap_subcharactergl_ctrl.gl_txap_subAP Tax Sub-Account
tcgl_txapr_acctcharactergl_ctrl.gl_txapr_acctAP Retained Tax Acct
tcgl_txapr_cccharactergl_ctrl.gl_txapr_ccAP Retained Tax CC
tcgl_txapr_subcharactergl_ctrl.gl_txapr_subAP Retained Tax Sub-Account
tcgl_txar_acctcharactergl_ctrl.gl_txar_acctAR Sales Tax Account
tcgl_txar_cccharactergl_ctrl.gl_txar_ccAR Sales Tax CC
tcgl_txar_cn_acctcharactergl_ctrl.gl_txar_cn_acctSales Tax CN Acct
tcgl_txar_cn_subcharactergl_ctrl.gl_txar_cn_subSales Tax CN Sub-Account
tcgl_txar_subcharactergl_ctrl.gl_txar_subAR Sales Tax Sub-Account
tcgl_txara_acctcharactergl_ctrl.gl_txara_acctAR Absorbed Tax Acct
tcgl_txara_cccharactergl_ctrl.gl_txara_ccAR Absorbed Tax CC
tcgl_txara_subcharactergl_ctrl.gl_txara_subAR Absorbed Tax Sub-Account
tcgl_ugain_acctcharactergl_ctrl.gl_ugain_acctUnrealized Exchange Gain Acct
tcgl_ugain_cccharactergl_ctrl.gl_ugain_ccUnrealized Exchange Gain CC
tcgl_ugain_subcharactergl_ctrl.gl_ugain_subUnrealized Exchange Gain Sub
tcgl_uloss_acctcharactergl_ctrl.gl_uloss_acctUnrealized Exchange Loss Acct
tcgl_uloss_cccharactergl_ctrl.gl_uloss_ccUnrealized Exchange Loss CC
tcgl_uloss_subcharactergl_ctrl.gl_uloss_subUnrealized Exchange Loss Sub
tcgl_user_acctcharactergl_ctrl.gl_user_acctExempt Sales Acct
tcgl_user_cccharactergl_ctrl.gl_user_ccExempt Sales Cost Ctr
tcgl_user_subcharactergl_ctrl.gl_user_subExempt Sales Sub-Acct
tcgl_user1charactergl_ctrl.gl_user1Ufld1
tcgl_user2charactergl_ctrl.gl_user2Ufld2
tlgl_vatlogicalgl_ctrl.gl_vatValue Added Tax
tlgl_verifylogicalgl_ctrl.gl_verifyVerify GL Accounts
tcgl_wip_acctcharactergl_ctrl.gl_wip_acctWork in Process
tcgl_wip_cccharactergl_ctrl.gl_wip_ccWork in Process Cost Ctr
tcgl_wip_subcharactergl_ctrl.gl_wip_subWork in Process Sub
tcgl_wvar_acctcharactergl_ctrl.gl_wvar_acctMethod Variance
tcgl_wvar_cccharactergl_ctrl.gl_wvar_ccMethod Variance CC
tcgl_wvar_subcharactergl_ctrl.gl_wvar_subMethod Variance Sub
tcgl_xfer_acctcharactergl_ctrl.gl_xfer_acctTransfer Variance
tcgl_xfer_cccharactergl_ctrl.gl_xfer_ccTransfer Variance Cost Ctr
tcgl_xfer_subcharactergl_ctrl.gl_xfer_subTransfer Variance Sub
tcgl_xvar_acctcharactergl_ctrl.gl_xvar_acctMix Var
tcgl_xvar_cccharactergl_ctrl.gl_xvar_ccMix Var CC
tcgl_xvar_subcharactergl_ctrl.gl_xvar_subMix Var Sub-Acct
tdoid_gl_ctrldecimalgl_ctrl.oid_gl_ctrl


Internal usage


QadFinancials
method BAPMatching.AdditionalUpdatesAllLinesPLVarUsage
method BAPMatching.AdditionalUpdatesAllQueriesStart
method BAPMatching.AdditionalUpdatesAllQueriesStop
method BAPMatching.AdditionalUpdatesAllTaxGetPPV
method BMfgPOReceipt.GetAccountInformationOnPOReceiptNoLC
method BMfgSystemAccountControl.UpdateRndMthd
method BAPMatching.AdditionalUpdatesAllTaxGetInvAcc
method BAPMatching.GetGLPLVarRateDiscrepancy
method BAPMatching.GetGLPLVarRateNormal