| *Enquiry for Revenue Codes without TT FP and SupID 990001-990008 (and not Sundry supplier - 990009-10) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| sql dbSELECT DISTINCT b.sequence_no,b.voucher_no,b.amount,b.account, b.dim_1, s.dim_e as respoff, c.payment_date, f.apar_name, m.description as DivinDesc, l.description as DeptDesc, k.description as directdesc, i.description as An4Desc, j.description as an5desc, 'R' as revCap, a.description as Adesc, v.description as CCdesc, w.description as SGdesc, f.apar_gr_id, x.description as respoffdesc, p.date_from, p.date_to, b.dim_2, h.description as dim2desc, b.dim_3, b.dim_4, b.dim_5, b.dim_6, b.dim_7, b.order_id |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| sql FROM agltransact b |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| sql INNER JOIN acrperiod p on b.client=p.client and p.period_id='GL' and p.period=b.period |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
