project QadFinancials > class BMfgCreditTermsDetail > business logic query DetailSeqByDomainCode

Description

Get sequence(max) by domain and payment condition code.


Parameters


icDomaincharacter
icPaymentConditionCodecharacter


query condition


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


query sort order


ctd_det.ctd_seq (descending)


query resultset tqDetailSeqByDomainCode


field namedata typedb fielddescription
tcctd_codecharacterctd_det.ctd_codeTerms Code
tcctd_domaincharacterctd_det.ctd_domainDomain
tictd_seqintegerctd_det.ctd_seqSequence
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(ctd_det)


Internal usage


QadFinancials
method BMfgCreditTermsDetail.UpdateMfgData