Description
Query returns glt_det records by the specified date and type
Parameters
icDomain | character | Domain code |
icEntity | character | Entity code |
icType | character | Transaction Type |
itStartDate | date | Start Date |
itEndDate | date | End 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 name | data type | db field | description |
tcglt_domain | character | glt_det.glt_domain | Domain |
ttglt_effdate | date | glt_det.glt_effdate | Effective |
tcglt_entity | character | glt_det.glt_entity | Entity |
tcglt_tr_type | character | glt_det.glt_tr_type | Transaction Type |
Internal usage
QadFinancials