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