project QadFinancials > class BMfgDomain > business logic query DomainForInventoryControlFile

Description

DomainForInventoryControlFile: this query returns information on the icc_ctrl (ForInventoryControlFile) but could not be written on an appropriate class because that table contains field that have a '%' in their name.


Parameters


icDomainCodecharacter


query condition


  each dom_mstr where
dom_mstr.dom_domain = icDomainCode

      each icc_ctrl (inner-join) where
icc_ctrl.icc_domain = dom_mstr.dom_domain AND


query resultset tqDomainForInventoryControlFile


field namedata typedb fielddescription
tcdom_domaincharacterdom_mstr.dom_domainDomain
tldom_activelogicaldom_mstr.dom_activeActive
tdicc_tol_o_pctdecimalicc_ctrl.icc_tol_o_pctAll Others
tcicc_user1charactericc_ctrl.icc_user1Ufld1
tcicc_user2charactericc_ctrl.icc_user2Ufld2
tcicc_xclr_acctcharactericc_ctrl.icc_xclr_acctTransfer Clearing Acct
tcicc_xclr_cccharactericc_ctrl.icc_xclr_ccIntercompany Cost Center
tcicc_xclr_subcharactericc_ctrl.icc_xclr_subTsfr Clearing Sub-Acct
tdoid_icc_ctrldecimalicc_ctrl.oid_icc_ctrl
tiicc__qad01integericc_ctrl.icc__qad01
tiicc__qad02integericc_ctrl.icc__qad02
tiicc__qad03integericc_ctrl.icc__qad03
tcicc__qadc01charactericc_ctrl.icc__qadc01
tcicc__qadc02charactericc_ctrl.icc__qadc02
tcicc__qadc03charactericc_ctrl.icc__qadc03
tiicc__qadi02integericc_ctrl.icc__qadi02
tiicc__qadi04integericc_ctrl.icc__qadi04
tlicc_ascendlogicalicc_ctrl.icc_ascendAscending or Descending
tlicc_cogslogicalicc_ctrl.icc_cogsSum LL Costs Into Matl Cost
tlicc_cur_aplogicalicc_ctrl.icc_cur_apCurrent Cost from AP
tcicc_cur_costcharactericc_ctrl.icc_cur_costCurrent Cost (AVG/LAST/NONE)
tcicc_cur_setcharactericc_ctrl.icc_cur_setDefault Current Cost Set
tcicc_domaincharactericc_ctrl.icc_domainDomain
tcicc_gl_setcharactericc_ctrl.icc_gl_setDefault GL Cost Set
tlicc_gl_sumlogicalicc_ctrl.icc_gl_sumSummarized Journal
tlicc_gl_tranlogicalicc_ctrl.icc_gl_tranCreate GL Transactions
tiicc_iss_daysintegericc_ctrl.icc_iss_daysIssue Days
tlicc_mirrorlogicalicc_ctrl.icc_mirrorMirror Accounting
tiicc_pk_ordintegericc_ctrl.icc_pk_ordPicking Order
tcicc_sitecharactericc_ctrl.icc_siteDefault Site
tdicc_tol_adecimalicc_ctrl.icc_tol_aClass A
tdicc_tol_a_pctdecimalicc_ctrl.icc_tol_a_pctClass A
tdicc_tol_bdecimalicc_ctrl.icc_tol_bClass B
tdicc_tol_b_pctdecimalicc_ctrl.icc_tol_b_pctClass B
tdicc_tol_cdecimalicc_ctrl.icc_tol_cClass C
tdicc_tol_c_pctdecimalicc_ctrl.icc_tol_c_pctClass C
tlicc_tol_flaglogicalicc_ctrl.icc_tol_flagTolerance Method
tdicc_tol_odecimalicc_ctrl.icc_tol_oAll Others
tiicc_jrnlintegericc_ctrl.icc_jrnlNext Journal
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(dom_mstr),rowid(icc_ctrl)


Internal usage


QadFinancials
method BAPMatching.AdditionalUpdatesAllLinesPLExpenseAcruals
method BAPMatching.AdditionalUpdatesAllLinesPLReceiptPvod
method BAPMatching.AdditionalUpdatesAllLinesPLVarUsage
method BAPMatching.AdditionalUpdatesAllQueriesStart
method BAPMatching.AdditionalUpdatesAllQueriesStop
method BMfgPOReceipt.GetAccountInformationOnPOReceiptNoLC
method BAPMatching.GetGLPLVarRateNormal