Back to dataset
Payments to suppliers from Monmouthshire County Council
You're previewing the first 4 rows of this file.
Download this filesetparameter SELECT description AS PeriodName FROM acrperiod WHERE client = 'M1' AND period_id = 'GL' and period = <Period> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
*Enquiry for Revenue Codes without TT FP and SupID 990001-990008 (and not Sundry supplier - 990009-10) | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set |
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 | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set |
sql FROM agltransact b | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set |
sql INNER JOIN acrperiod p on b.client=p.client and p.period_id='GL' and p.period=b.period | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set |