project QadFinancials > class BMfgDaybookDefault > business logic query DaybookDftByTransDocTypeCode


Parameters


icDomaincharacter
icTransactionTypecharacter
icDocumentTypecharacter
icDaybookEntitycharacter
icDaybookCodecharacter


query condition


  each dyd_mstr where
dyd_mstr.dyd_domain = icDomain AND
dyd_mstr.dyd_tr_type = icTransactionType AND
dyd_mstr.dyd_doc_type = icDocumentType AND
(dyd_mstr.dyd_entity_fr <= icDaybookEntity OR
dyd_mstr.dyd_entity_fr = '' ) AND
(dyd_mstr.dyd_entity_to >= icDaybookEntity OR
dyd_mstr.dyd_entity_to = '' ) AND
dyd_mstr.dyd_dy_code = icDaybookCode


query resultset tqDaybookDftByTransDocTypeCode


field namedata typedb fielddescription
tcdyd_doc_typecharacterdyd_mstr.dyd_doc_typeDoc Type
tcdyd_domaincharacterdyd_mstr.dyd_domainDomain
tcdyd_dy_codecharacterdyd_mstr.dyd_dy_codeDaybook
tcdyd_entity_frcharacterdyd_mstr.dyd_entity_frFrom Entity
tcdyd_entity_tocharacterdyd_mstr.dyd_entity_toTo Entity
tcdyd_tr_typecharacterdyd_mstr.dyd_tr_typeTrans Type
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(dyd_mstr)


Internal usage


QadFinancials
method BJournal.ValidateComponent