project QadFinancials > class BMfgDaybookDefault > business logic query DaybookDftByTransDocTypeCode
Parameters
icDomain | character | |
icTransactionType | character | |
icDocumentType | character | |
icDaybookEntity | character | |
icDaybookCode | character | |
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 name | data type | db field | description |
tcdyd_doc_type | character | dyd_mstr.dyd_doc_type | Doc Type |
tcdyd_domain | character | dyd_mstr.dyd_domain | Domain |
tcdyd_dy_code | character | dyd_mstr.dyd_dy_code | Daybook |
tcdyd_entity_fr | character | dyd_mstr.dyd_entity_fr | From Entity |
tcdyd_entity_to | character | dyd_mstr.dyd_entity_to | To Entity |
tcdyd_tr_type | character | dyd_mstr.dyd_tr_type | Trans Type |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(dyd_mstr) |
Internal usage
QadFinancials