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