project QadFinancials > class BAPMatchingReport > business logic query InvTrHistForGLCrossRef
Parameters
| icFromPurchaseOrder | character | |
| icToPurchaseOrder | character | |
query condition
each tr_hist where
tr_hist.tr_nbr >= icFromPurchaseOrder AND
tr_hist.tr_nbr <= icToPurchaseOrder AND
tr_hist.tr_nbr <> '' AND
tr_hist.tr_lot <> ''
each trgl_det (inner-join) where
trgl_det.trgl_domain = tr_hist.tr_domain AND
trgl_det.trgl_trnbr = tr_hist.tr_trnbr AND
trgl_det.trgl_dy_code <> '' AND
trgl_det.trgl_dy_num <> ''
query resultset tqInvTrHisForGLCrossRef
| field name | data type | db field | description |
|---|
| tctr_domain | character | tr_hist.tr_domain | Domain |
| titr_line | integer | tr_hist.tr_line | Line |
| tctr_lot | character | tr_hist.tr_lot | ID |
| tctr_nbr | character | tr_hist.tr_nbr | Order |
| tctrgl_dy_code | character | trgl_det.trgl_dy_code | Daybook |
| tctrgl_dy_num | character | trgl_det.trgl_dy_num | Entry Number |
Internal usage
QadFinancials