project QadFinancials > class BMfgUnpostedTransactionDetail > business logic query TransactionByDateType

Description

Query returns glt_det records by the specified date and type


Parameters


icDomaincharacterDomain code
icEntitycharacterEntity code
icTypecharacterTransaction Type
itStartDatedateStart Date
itEndDatedateEnd Date


query condition


  each glt_det where
glt_det.glt_domain = icDomain AND
glt_det.glt_entity = icEntity AND
glt_det.glt_tr_type = icType AND
glt_det.glt_effdate >= itStartDate AND
glt_det.glt_effdate <= itEndDate AND
glt_det.glt_exp = false


query resultset tqTransactionByDateType


field namedata typedb fielddescription
tcglt_domaincharacterglt_det.glt_domainDomain
ttglt_effdatedateglt_det.glt_effdateEffective
tcglt_entitycharacterglt_det.glt_entityEntity
tcglt_tr_typecharacterglt_det.glt_tr_typeTransaction Type


Internal usage


QadFinancials
method BCompany.ValidateComponent
method BCompanyProperty.ValidateComponent
method BCreditorReport.CheckForUnpostedTransByPerYr
method BGLCalendar.ValidateComponent
method BGLReport.CheckUnpostedTransactions
method BGLReport.CheckUnpostedTransactionsForMulti
method BPeriod.ValidateComponentPre
method BVATReport.CheckUnpostedTransactions
method BVATReport.VATQuarterDet
method BVATReport.VATQuarterSum
method BVATReport.VATQuarterTran