project QadFinancials > class BMfgAccountPayableCtrl > business logic query AccountsPayableCtrlByDomain

Description

Query that returns information from the Accounts-payable control files


Parameters


icDomainCodecharacter


query condition


  each apc_ctrl where
apc_ctrl.apc_domain = icDomainCode


query resultset tqAccountsPayableCtrlByDomain


field namedata typedb fielddescription
tcapc_ers_cn_dybkcharacterapc_ctrl.apc_ers_cn_dybkERS Credit Note Daybook
tcapc_ers_inv_dybkcharacterapc_ctrl.apc_ers_inv_dybkERS Invoice Daybook
tlapc_recalc_taxlogicalapc_ctrl.apc_recalc_taxRecalculate Tax Rates
tcapc_domaincharacterapc_ctrl.apc_domainDomain
tlapc_approvlogicalapc_ctrl.apc_approvUse Assigned-To Field
tcapc_bankcharacterapc_ctrl.apc_bankDefault Bank
tiapc_batchintegerapc_ctrl.apc_batchNext Batch
tcapc_ckfrmcharacterapc_ctrl.apc_ckfrmCheck Form
tlapc_confirmlogicalapc_ctrl.apc_confirmEnter Vouchers Confirmed
tlapc_ers_ps_errlogicalapc_ctrl.apc_ers_ps_errERS Packing Slip Error
tiapc_ers_vo_tpintegerapc_ctrl.apc_ers_vo_tpERS Voucher Date Option
tcapc_ex_ratetypecharacterapc_ctrl.apc_ex_ratetypeRate Type
tdapc_ex_toldecimalapc_ctrl.apc_ex_tolExchange Tolerance
tlapc_expvarlogicalapc_ctrl.apc_expvarUse Expensed Item Var Accts
tlapc_ext_reflogicalapc_ctrl.apc_ext_refExternal Voucher References Allowed
tlapc_gl_avg_cstlogicalapc_ctrl.apc_gl_avg_cstUpdate GL Average Cost
tlapc_gl_sumlogicalapc_ctrl.apc_gl_sumSummarized Journal
tiapc_jrnlintegerapc_ctrl.apc_jrnlNext Journal
tlapc_multi_entity_paylogicalapc_ctrl.apc_multi_entity_payMulti-Entity Payments
tlapc_piplogicalapc_ctrl.apc_pipUse Payment In Process Acct
tlapc_rv_conflogicalapc_ctrl.apc_rv_confRelease Recur VOs Confirmed
tcapc_shipcharacterapc_ctrl.apc_shipShip-To
tiapc_sum_lvlintegerapc_ctrl.apc_sum_lvlAP Summarization Level
tlapc_use_drftlogicalapc_ctrl.apc_use_drftUse Draft Management
tcapc_user1characterapc_ctrl.apc_user1Ufld1
tcapc_user2characterapc_ctrl.apc_user2Ufld2
tlapc_vchr_alllogicalapc_ctrl.apc_vchr_allVoucher All
tcapc_vo_precharacterapc_ctrl.apc_vo_preVoucher Prefix
tiapc_voucherintegerapc_ctrl.apc_voucherNext Voucher
tdoid_apc_ctrldecimalapc_ctrl.oid_apc_ctrl
tlapc_holdinvoiceamtlogicalapc_ctrl.apc_holdinvoiceamtPut variance amount on hold
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(apc_ctrl)


Internal usage


QadFinancials
method BAPMatching.AdditionalUpdatesAll
method BAPMatching.AdditionalUpdatesAllLinesPLVarUsage
method BAPMatching.InitInstance
method BCInvoice.AllocateCInvoices
method BERSProcessor.ERSProcess
method BAPMatching.GetGLPLVarRateNormal