Hello everyone,
Is there a way of working out how much income was generated through orders which have been assigned a specific source code. I can’t even seem to be able to find a list of orders relating to a specific source code as the source_code for all records in our lvs_tkt_hist table is NULL.
Many thanks for your help
Grae
Normal 0 false false false EN-GB X-NONE X-NONE MicrosoftInternetExplorer4
Take two...
You could do a simple select on T_ORDERS, something like...
select sum(tot_paid_amt) from t_order
where source_no = 123
The above will give you the total order amount (including fees etc).
Or you could just look at ticket purchases using SUM(tot_ticket_paid_amt) as below.
select sum(tot_ticket_paid_amt) from t_order