project QadFinancials > class BMfgCreditTermsDetail > business logic query CreditTermsDetailByDomainCode

Description

Get CreditTermsDetail by domain, payment condition code, staged payment condition code


Parameters


icDomaincharacter
icPaymentConditionCodecharacter
icStagedPaymentConditionCodecharacter


query condition


  each ctd_det where
ctd_det.ctd_domain = icDomain AND
ctd_det.ctd_code = icPaymentConditionCode AND
ctd_det.ctd_date_cd = icStagedPaymentConditionCode


query resultset tqCreditTermsDetailByDomainCode


field namedata typedb fielddescription
tcctd_codecharacterctd_det.ctd_codeTerms Code
tcctd_date_cdcharacterctd_det.ctd_date_cdDating Code
tcctd_domaincharacterctd_det.ctd_domainDomain
tdctd_pct_duedecimalctd_det.ctd_pct_due% Due
tictd_seqintegerctd_det.ctd_seqSequence
tdoid_ctd_detdecimalctd_det.oid_ctd_det
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(ctd_det)


Internal usage


QadFinancials
method BMfgCreditTerms.ValidateComponent
method BMfgCreditTermsDetail.LoadMfgData
method BMfgCreditTermsDetail.MaintainData