BACKOFFICE WEBSITE V5.0 FOR APX POWER NL User manual
Contents
1. 21 4 5 3 2 PResulS aana a dee Pe 21 4 5 4 Historical Contract book 23 RS a Oe TEE 23 AS AO Ree Gleiser Dee deeg Geer Aele tee 24 4 5 5 Historical Order Tee 2 s 22 cccs2sce Ba dignceededesvicods tsi ATAA RAE AT EA Aa 26 ADAAN eee A E 26 45 5 2 Beeler eerk ie eebe eege E hace ore tetas d tale heeds 27 4 5 5 3 Order status column 28 4 5 5 4 Order detallSs ssiccsds iseces eaaa a ee wae 29 4 5 6 Historical Matching Results ccs ci eege diastase 30 Ee KE GE 30 ADGA Bee leese tal dos tat Ee See ee 31 4 5 7 General Matching Results c 404 nnd arti seinen eee ie 33 4 57731 FES esse eit tae Rea ected eed die ened Helena 33 A572 IROSUINS E E AE IETA EEE A A AT E vivedeyanes 33 4 5 8 Settlement Gummar REENEN 35 ADS GE 35 458 27 ox 1 10 C ee ea ee ee 36 4 6 rolleng ee Wie kinder Ae 38 4 6 1 DO MING EE 38 4 6 2 Change password Sete eos ete ett Sa eee See Rese Bal ae he att 39 4 7 BOG LE 40 Page 2 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 1 Introduction The Back Office website supports the main EuroLight trading system To improve performance data in the EuroLight application itself is limited to three days In the Back Office website you can view your invoices and query the APX trading database for your historical order contract invoice and settlement information The Back Office website is intended for analysts back office employees2. BACKOFFICE WEBSITE V5 0 FOR APX POWER NL Current user test Tidcerdata Chargelines Report Historical Contiact Book Historical Order Book Invoice Printing Historical Matching Results General Matching Results Settlement Summary Microsoft Internet Ex Edt View Favorites SE Websi Search Favontes eles User manual APX Sales amp Trading Eis ZS Current user test Invoicegroup AS ER AT H Final invoices 22 Jan 05 to 28 Jan 08 Purchases Sales 15 Jan 08 to 21 Jan 08 S Purchases Sales 10008 to Jane Purchases Prs y Invoices AB Feb 06 to 10 F 09 Sales TEEN ER DEEN salar rogistered Office Strawinskyt ege Invoice Ho 14 APX Seles amp Tradir P BC APX BV NL Power E Nee Final Settlement Invoice 22 Jan 08 to 20 300 068 Ve 3 Date Issued 25 tanuary 2008 Total amount Pavabte ee 0098085 08 Total amount exc VAT vm Charge Summary co Fees VAT Aate VAT 11011 eneray purchese DS D RE DR A Fee corrected Energy purcrases sel sens mp sema a7 Total amount Payable eres ees DR DEEN Se TA Ae dit 626 APX Sales amp Tra EE SH DEE zogen a lt 7434400 84 lt 4340187 vuaenz 50000509 00 tee 2606 1 121EC 1 Market apply coun Application of articles 38 and 3 The Rules and Regulations APX Power number mein This invoice amount will be deducted
3. Organization E Open in Excel Query Organization APX Applying date Instrument MCP Buy Sell Net 2008 02 12 NL 1H080212 H01 17 50 60004 0 0 MAh 0 0 MAh 0 0 MAh 2008 02 12 NL 1H080212 H02 16 00 b nk 0 0 MAh 0 0 MAh 0 0 MAh 2008 02 12 NL 1H080212 H03 13 40 EMAN 0 0 MWh 0 0 MAN 0 0 MWh 2008 02 12 NL 1H080212 H04 11 19 EMAN 0 0 MWh 0 0 MAN 0 0 MAN 2008 02 12 NL 1H080212 H05 11 00 Mwh 0 0 MWh 0 0 MAN 0 0 MWh 2008 02 12 NL 1H080212 H06 11 20 Mwh 0 0 MWh 0 0 MAh 0 0 MWh 2008 02 12 NL 1H080212 H07 8 50 amp MAh 0 0 MAh 0 0 Map 0 0 MAM 2008 02 12 NL 1H080212 H08 14 00 MVWh 0 0 MAh 0 0 MWh 0 0 Mh 2008 02 12 NL 1H080212 H09 9 00 amp MAh 0 0 MAh 0 0 Map 0 0 MAh 2008 02 12 NL 1H080212 H10 15 50 EMAh 0 0 MAh 0 0 MWh 0 0 MAh 2008 02 12 NL 1H080212 H11 19 70 amp MAh 0 0 MWh 0 0 Map 0 0 MAh 2008 02 12 NL 1H080212 H12 23 08 Mvvh 0 0 MWh 0 0 MAh 0 0 MWh 2008 02 12 NL 1H080212 H13 2410 60041 0 0 MWh 0 0 MAh 0 0 MAh 2008 02 12 NL 1H080212 H14 19 42 EMAh 0 0 MWh 0 0 MWh 0 0 MAh 2008 02 12 NL 1H080212 H15 15 50 amp MAh 0 0 MAN 0 0 MAh 0 0 MAh 2008 02 12 NL 1H080212 H16 15 30 EMAR 0 0 MAR 0 0 MAh 0 0 MAh 2008 02 12 NL 1H080212 H17 22 00 MwWh 0 0 MAh 0 0 MAh 0 0 MAN 2008 02 12 NL 1H080212 H18 79 22 b nk 0 0 MWh 0 0 MAh 0 0 MAh 2008 02 12 NL 1H080212 H19 8012 b nk 0 0 MAR 0 0 MA
4. The Collateral section of the BackOffice website gives you an insight in the intermediate results of this calculation Current user test Collateral requirement DAM APX Sales amp Trading_EUR_APXNL1 APX Sales amp Trading_EUR_ 19 01 2008 to 25 01 2008 Required Collateral 1 229 109 70 Calculation date 22 01 2008 22 12 2007 197 110 41 186 248 13 10 862 28 0 00 23 12 2007 0 00 0 00 0 00 0 00 24 12 2007 0 00 0 00 0 00 0 00 25 12 2007 1 802 853 51 1 779 646 05 23 207 46 0 00 26 12 2007 0 00 0 00 0 00 0 00 27 12 2007 0 00 0 00 0 00 0 00 28 12 2007 2 293 669 26 2 254 441 72 39 227 54 0 00 29 12 2007 166 794 55 150 681 03 16 113 52 0 00 30 12 2007 0 00 0 00 0 00 0 00 31 12 2007 0 00 0 00 0 00 0 00 01 01 2008 0 00 0 00 0 00 0 00 02 01 2008 0 00 0 00 0 00 0 00 03 01 2008 4 970 013 52 4 526 885 59 443 127 93 0 00 04 01 2008 2 299 576 88 2 273 858 73 25 718 15 0 00 05 01 2008 1 682 336 56 1 651 935 79 30 400 77 0 00 06 01 2008 0 00 0 00 0 00 0 00 07 01 2008 0 00 0 00 0 00 0 00 08 01 2008 2 508 374 38 2 479 437 48 28 936 90 0 00 09 01 2008 2 490 723 58 2 461 485 13 29 238 45 0 00 10 01 2008 2 297 744 24 2 268 595 85 29 148 39 0 00 11 01 2008 2 028 801 14 1 955 569 82 73 231
5. chargelines in a CSV formatted output More about this can be found in chapter Excel export CSV 4 2 2 4 Monthly invoice list The monthly invoice list can be accessed by using the invoice history menu in the side bar see Figure 5 This list shows all final invoices for the selected month For each invoice the following is displayed e invoice period the invoice number the subtotals of all charge lines grouped by charge type the total amount of the invoice whether the invoice has been paid or not Via the monthly invoice list you can access any invoice by first selecting the appropriate year and month in the invoice history menu On the left of all invoices in the list a magnifying glass is shown By clicking on this button you can zoom in on this particular invoice Page 13 BackOffice Website v5 0 for APX Power NL User Manual Document version 1 0 Current user test Invoicegroup APX_EUR_APXNL1 Final Invoices 22 Jan 08 to 28 Jan 08 Purchases Sales 18 Jan 08 to 21 Jan 08 Purchases Sales 8 Jan 08 to 14 Jan 08 Purchases Preliminary Invoices 12 Feb 08 to 18 Feb 08 Purchases Sales Feb 08 to 11 Feb 08 Purchases Sales 11 DeoO7 to 17 Dec 07 Purchases Sales Invoice History 2008 gt Jan 2008 2007 Invoice Quick Finder Go e Final Invoices January 2008 gd Description Energy Fees VAT Total Paid a 1 Jan 08 to 7
6. 32 0 00 12 01 2008 1 284 940 16 1 267 964 00 16 976 16 0 00 13 01 2008 0 00 0 00 0 00 0 00 14 01 2008 0 00 0 00 0 00 0 00 15 01 2008 2 537 068 83 2 507 464 09 29 604 74 0 00 16 01 2008 3 114 859 82 3 082 705 85 32 153 97 0 00 17 01 2008 2 522 421 74 2 509 339 35 13 082 39 0 00 18 01 2008 1 211 985 98 1 193 016 06 18 969 92 0 00 Avg 30 714 28 0 00 Std dev 82 691 51 0 00 initial 10 000 00 individual 609 554 85 mutual 609 554 85 Figure 12 Collateral section Per underlying day the following information is shown o Purchase value o Sale value o Net value o Net purchase or net sale Below this the average amp standard deviation of the net purchase amp net sale are shown Finally the initial individual amp mutual collateral are shown which are summed up to the required collateral Page 16 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Only the results of the last collateral calculation are visible It is not possible to browse to the results of previous weeks The results will be available on the website almost immediately after they have been calculated Page 17 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 5 Reports In the reports section of the Back Office website several reports can be queried Individual user permissions gov
7. H01 10 150 000 150 000 17 00 2550 00 11717364 2962207 11011 Energy purchases NL 1H080122 H01 10 150 000 150 000 17 00 2550 00 11717368 2962208 11011 Energy purchases NL 1H080122 H01 10 50 000 50 000 17 00 850 00 Figure 9 Charge line details Page 12 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 2 2 3 1 The header The header contains information about the invoice these details belong to On the left e Invoice number You can click on the invoice number to go back to the invoice Since preliminary invoices do not yet have an invoice number a back to the invoice link is shown here e Organization information name amp address e VAT registration number In the middle e Type of the invoice Final or preliminary these charge lines belong to e Date of the invoice these charge lines belong to On the right e Print button 4 2 2 3 2 The sub header The sub header shows the settlement account and the group of charge lines you selected 4 2 2 3 3 The charge lines All charge lines for this invoice that are related to the selected settlement account and charge type are displayed here in a table Depending on the charge type you selected the exact columns that are displayed will vary For example the VAT column is only shown when you select the VAT charge type 4 2 2 3 4 Footer The footer contains an Export to CSV option which allows you to display the
8. apx nl index php JB Links gt ant ees BACKOFFICE WEBSITE Profile Logout Welcome to the APX DAM Production BackOffice website For questions regarding this website please contact the customer service desk at 31 20 305 4042 Main area Side bar lowe 1 greng Figure 3 Back Office website interface 3 1 Header In the header information is displayed regarding the environment you are accessing Production member test By using the items in the menu bar at the bottom of the header you can select the various sections of the Back Office website 3 2 Side bar The content of the Side bar is different for each section On the top of the Side bar the current user is displayed Underneath an additional menu dependent on which section will be shown giving you access to the content of the sections More details can be found in Chapter 4 on page 7 3 3 Main area This is where data like invoices and reports will be shown dependent on which section you are in Page 6 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 Sections The various sections of the Back Office website can be accessed via the menu items in the header See chapter 3 on page 6 for more details The screenshots in this chapter will only include the side bar and main area as these are the only parts that differ between the sections 4 1 Home When logging into the Back Office website
9. trom your sleering secouri f xoy iao Regier No 34153887 Kee Customer Service Desk APK Group T 31 20 305 4042 L 4002 i LEE pas ynan 729 1077x Amsterdam The Helle an 720 07770 000 O O O E Document version 1 0 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Table of Contents Ms TWAMtFOCUCTION E EEEN E E dene lest cscacessnatceccacet svete tana ta tena lotacadedaces saseteas eenctaes 3 2 Accessing the Back Office website mccscacsiiicdts catsvediheagerideiedeaeecnninetes eee 4 3 Interac description EE 6 3 1 PIC ACS es nose Set eee tate Sekt fel has eid eats Aad io a Si ld is ANd oe iced cl 6 3 2 ee EE 6 3 3 MAINA E E ois chec dase Ses oct cates chet E dat acces vs aS vau s EE 6 As e EE 7 4 1 Home Ee ee Ee E EE 7 4 2 INVOICES EE 7 4 2 1 DIGG EE 7 4 2 2 MAIN Ae beer EE Ste Be e 8 e E NET E ELE 8 4 2 2 2 Invoice and Self bill oo 1 10 4 22 39 G arge EE 12 4 2 2 4 Monthly invoice list q cc2h0 s Eegen engin ae 13 4 3 re Ee EE 15 4 4 el EE EE 16 4 5 DEE lee tes fate eke ao hth acta ccs Pent ke A Ee 18 4 5 1 Excel export GS EE 18 4 5 2 Le Dt EC NEE 19 4 52231 RINGS isso neat et it ad ben die hd e 19 AS52220 HROSUINS PEE EE E ved S NEE E A S E E A sde ege 19 4 5 3 Chargeline report TEEN 21 4 9 3 1 PIES 20290 a e eer a et A A EE eS
10. 0 Current user test gt Tickerdata Chargelines Report Historical Contract Book Historical Order Book Historical Matching Results General Matching Results Settlement Summary Tickerdata Market segment E Instruments p Filter on applying date Trade time From 2008 02 12 0 00 00 00 CET To 2008 0212 23 59 59 ceT m open in Excel Query Please wait while we process your request Figure 15 Please wait while we process your request After execution of the query the results will be displayed Current user test gt Tickerdata Chargelines Report Historical Contract Book Historical Order Book Historical Matching Results General Matching Results Settlement Summary Tickerdata 2983050 NL 1HO80212 H11 Market segment E Instruments NM Filter on 19 applying date Trade time From 2008 02 12 00 00 00 cer To 2008 02 12 1 23 59 59 ceT Open in Excel Query 150 MW 19 70 2008 02 11 14 36 46 CET 2983051 NL 1HO80212 H11 2983052 NL 1HO80212 H11 150 MW 150 Mu 19 70 2008 02 11 14 36 46 CET 9 70 2008 02 11 14 36 46 CET 2983053 NL 1H080212 H11 2983054 NL 1H080212 H11 2983055 NL 1HO80212 H11 2983056 NL 1HO80212 H11 2983057 NL 1HO80212 H11 7082NE2 hl AHARNN I H11 B W N _ i 50 Ma 50 Mad booo mooo o AEN MA so mw 50 MW som 19 7
11. 0 2008 02 11 14 36 46 CET 19 70 2008 02 11 14 36 46 CET 19 70 2008 02 11 14 36 46 CET 19 70 2008 02 11 14 36 46 CET 19 70 2008 02 11 14 36 46 CET E1070 9008 07 14 44 2eAR CET Figure 16 Tickerdata results This table will have the following columns e Contract ID e Instrument e Side e Volume e Price e Trade time in a table See Figure 16 You can sort this table by clicking on the table headers A triangle next to the header title signifies on which column the table is currently sorted see Figure 17 By default the results are sorted by trade time 19 70 DM 19 70 EI Open in Excel Query 2008 02 12 00 00 00 cer 2008 02 12 E 23 59 59 cet 2008 02 11 14 36 46 CET 2008 02 11 14 36 46 CET 61970 puw 61970 2008 02 11 14 36 46 CET 2008 02 11 14 36 48 CET Triangle indicating active sorted column Figure 17 Sort rows by column applying date Page 20 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 5 3 Chargeline report The chargeline report allows you to filter data based on the chargeline s you wish to analyse To retrieve information set the filters to define your criteria and then click on the Query button In order to prevent timeouts and other problems the number of lines you can query in one request is limited to 1 000 If your request would return more then this a wa
12. 080213 H06 10 20 3 519 1 MAh 2008 02 13 NL 1H080213 H07 8 50 3 824 5 MAh 2008 02 13 NL 1H080213 H08 12 00 3 600 0 MAh 2008 02 13 NL 1H080213 H09 17 25 3 907 3 Mh 2008 02 13 NL 1H080213 H10 24 00 3 907 6 Mh 2008 02 13 NL 1H080213 H11 24 51 3 937 0 MAh 2008 02 13 NL 1H080213 H12 28 00 3 894 0 MAh 2008 02 13 NL 1H080213 H13 28 01 3 883 6 MAh 2008 02 13 NL 1H080213 H14 24 46 3 938 1 MAh 2008 02 13 NL 1H080213 H15 20 01 3 928 4 Mh 2008 02 13 NL 1H080213 H16 19 03 3 918 1 Mh 2008 02 13 NL 1H080213 H17 23 02 4 000 0 Mh 2008 02 13 NL 1H080213 H18 76 00 3 607 2 MAh 2008 02 13 NL 1H080213 H19 55 00 3 600 1 MAh 2008 02 13 NL 1H080213 H20 40 00 3 740 5 MAh 2008 02 13 NL 1H080213 H21 24 00 3 801 7 MAh 2008 02 13 NL 1H080213 H22 20 99 3 550 0 MAh 2008 02 13 NL 1H080213 H23 21 00 3 551 9 MVVh 2008 02 13 NL 1H080213 H24 16 00 3 848 0 MAh Export to CSV Figure 27 General Matching Results report 4 5 7 1 Filters The General Matching Results report offers two filtering option Before requesting the report you have to specify a market and an applying date The report will return general matching results for all instruments within the market that have the specified applying date 4 5 7 2 Results For each particular matching process a separate table will be shown with the applicable matching results The date and time of that specific matching process is displayed above the columns The tab
13. 1H080212 H01 150 000 MW 150 000 MWh 17 50 ep 190 498 750 Creat 11801967 38997 W 2008 02 12 2983199 APX 000001 APX_EUR_APXNLI 11034 NL 1H080212 H01 150 000 MW 150 000 MWh 10 1400 MNh 19 0 63 9900 Charge 11801968 36997 W 2008 02 12 2983180 APX 000001 APX_EUR_APXNLI 11010 NL 1H080212 H01 150 000 MW 150 000 MAh 17 50 eut 2625 0000 Credit Figure 18 Chargeline report results This table will have the following columns e Charge ID Statement ID Type Invoice number Period Contract ID Position account Invoice group Charge code Instrument Volume Total volume Price Fee VAT Amount Side Depending on the charge code in the request some of these columns might be blank You can sort this table by clicking on the table headers A triangle next to the header title signifies on which column the table is currently sorted see Figure 17 By default the results are sorted by charge ID Page 22 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 5 4 Historical Contract book Via the Historical Contract book it is possible to retrieve information on all your contracts Please note in EuroLight only the past 3 days of data can be queried To retrieve your contracts set the filters to define your criteria and then click on the Query button In order to prevent timeouts and other possible problems the number of lines you can query is in one request cur
14. 49130 1 M D Mu 1600 00 Export to CSV Figure 24 Order details 1 If you are using a popup blocker make sure you allow popups for the Back Office website in order to be able to access the order details Page 29 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 5 6 Historical Matching Results Via the Historical Matching Results section it is possible to retrieve information about your matching results To retrieve your matching results you can set the filters to define your criteria followed by clicking on the Query button In order to prevent timeouts and other possible problems the number of lines you can query in one request is currently set to 1 000 If your request would return more then this a warning message is shown Current user test Historical Matching Results Tickerdata Kee s Market Select a market Applying date istorical Contract Bool Historical Order Book izati From 2008 01 01 00 00 00 cet Organization X gt Historical Matching Results General Matching Results Position account Es To 2008 02 12 ri 23 59 59 CET Settlement Summary Group by Position account organization T open in Excel Query Figure 25 Historical Matching Results 4 5 6 1 Filters The Historical Matching Results book offers several filters with which you can set the criteria on which results should be selected and displayed Market Here you can select t
15. 7 1420800 27 8898683 08 Invoice Quick Finder Your Input Tax 1420800 27 Invoice Quick Your Output Tax 0 00 Finder Application of articles 38 and 39 Council Directive 2006 112 EC Invoice history The Rules and Regulations APX Power Market apply This invoice amount will be deducted from your clearing account with number NL 8096 84 639 8 01 Preliminary invoices Charge line details APX BY Trade Register No 34153887 VAT No NL 8096 84 639 B 01 Recent Final invoices Customer Service Desk APX Group T 31 20 305 4042 F 31 20 305 4002 Invoice group E csdeski apxqroup com www apxqroup com Registered Office Strawinskylaan 729 1077XX Amsterdam The Netherlands Figure 5 Invoices section 4 2 2 Main area The main area for the Invoices sections can display several items depending on the chosen selection These are e Final or preliminary summary statements invoices or self bills e Charge line details for selected invoice or self bill e Monthly invoice list When you select the Invoices section from the Header the latest final invoice is automatically displayed 4 2 2 1 Summary Statement A Summary statement offers an easy overview of the invoice and self bill for the selected period and the net amount that results from that The summary statement can be selected from the side bar by selecting the slightly out dented date lines from the Final Invoices or Preliminary Invoices list Page 8 Bac
16. Jan 08 Invoice No 12 7488164 94 8951926 96 Y 34461 61 1429300 41 A 1 Jan 08to 7 Jan 08 Invoice No APXS 4 7137397 26 8452680 11 Y 34305 53 1349588 38 a 8 Jan 08 to 14 Jan 08 Invoice No 11 7786814 91 9325643 34 Y 49857 91 1488970 52 8 dan 08 to 14 Jan 08 Invoice No APXS 3 7751328 48 9165088 28 Y 49575 43 1463335 23 a 15 Jan 08 to 21 Jan 08 Invoice No 10 2119551 40 405078 43 2537068 83 Y 12439 00 18 Jan 08 to 21 Jan 08 Invoice No APXS 2 2119551 40 2507464 09 Y 12439 00 400351 69 a 22 Jan 08 to 28 Jan 08 Invoice No 14 7434440 54 8898683 08 43441 97 1420800 27 A 22 Jan 08 to 28 Jan 08 Invoice No APXS 6 7583048 81 89709 12 83 W 44468 29 1432332 31 Figure 10 List of invoices for the selected month Page 14 BackOffice Website v5 0 for APX Power NL User Manual 4 3 Charge codes Document version 1 0 The Charge codes section displays an overview of all charge codes used in EuroLight Using this screen you can see which charge codes exist in the system and what they mean Charge codes Power NL Chargecode Charge Name 11010 Energy Sales Energy Ke 11011 Energy purchases Energy v 11020 Fee contracted Energy sales Fees Y 11021 Fee contracted Energy purchases Fees
17. Password field Enter your new password in the New password field Dots will be displayed for every character you type Then confirm the new password by repeating it in the Confirm password field To confirm the change enter your current password which you used to login to the Back Office website and click on the Save changes button Current user test Your password has been updated sucessfully Your settings have been updated sucessfully Settings Timezone CET X Decimal separator comma be Thousand separator none v CSV separator semicolon v T Change password New password Confirm password Confirm changes Current password Save changes Figure 31 Profile updated successfully If the password is changed successfully the Profile form should return a message confirming the successful change see Figure 31 Profile updated successfully If the change was unsuccessful the profile form will also inform you of this via a message see Figure 32 Current user test Your profile has NOT been updated The following error occurred The current password you entered is incorrect Settings Timezone CET e Decimal separator comma Se Thousand separator none bd CV separator semicolon IS Change password New password Contirm password Confirm changes Current password Save changes Figure 32 Error while saving changes to the profile Page 39 BackOffice Website v5 0 for AP
18. X Power NL Document version 1 0 User Manual 4 7 Logout We recommend that you logout correctly at the end of each Back Office website session Simply click Logout on the menu bar For security reasons the Back Office website will automatically log out after a period of inactivity of 10 minutes When you next need to access the Back Office website you will automatically be returned to the Login screen see Figure 1 Page 40
19. Y 11030 19 VAT on Energy sales Vat Iw 490 11032 19 VAT on Energy purchases Vat Ke 19 0 11034 19 VAT on Fees Energy sales Vat vi 19 0 11035 19 VAT on Fees Energy purchases Vat 19 10 11036 0 VAT on Fees Energy sales Vat Y 0 0 11037 0 YAT on Fees Energy purchases Vat v 0 0 11038 0 VAT on Energy sales Vat Y 00 11040 0 VAT on Energy purchases Vat IT v 0 0 11110 Energy sales OTC _ Energy W 8 11111 Energy purchases OTC Energy Ce 11120 Fee contracted Energy sales OTC Fees Ve 11121 Fee contracted Energy purchases OTC Fees 11130 19 VAT on Energy sales OTC Vat w 19 0 11132 19 YAT on Energy purchases OTC Vat Ke 19 0 11134 19 VAT on Fees Energy sales OTC Vat 19 0 11135 19 VAT on Fees Energy purchases OTC Vat v 19 0 11136 0 VAT on Fees Energy sales OTC Vat 00 11137 0 VAT on Fees Energy purchases OTC Vat Ke 0 0 11138 0 VAT on Energy sales OTC Vat Iw 0 0 11140 0 YAT on Energy purchases OTC Vat L 0 0 Figure 11 Charge code section Page 15 BackOffice Website v5 0 for APX Power NL User Manual 4 4 Collateral Document version 1 0 The collateral requirement for the Dutch Day Ahead Market is calculated weekly based on the trading done in the last 28 days See Rules and Regulations APX Power Market appendix H Guide to bank payments collaterals and margining for details on the exact calculation done
20. accounts you have access to Page 23 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Instruments The instruments filter is a powerful field in which you can filter orders based on part or all of the instrument code For example NL 1H will return all rows with instruments that begin with NL 1H Please note this is case sensitive i e nl 1h will not return any rows From To The report can be filtered by applying date or trade time Using these two fields a from and to date and time can be specified If applying date is selected all contracts which deliver between the selected dates and times will be displayed If trade time is selected all contracts traded between the selected dates and times will be displayed 4 5 4 2 Results After clicking on the Query button a popup will appear see Figure 15 informing you to wait for the results while the query is executed Depending on the size of the query and the amount of data that needs to be returned this could take up to 30 seconds After execution of the query the results will be displayed in a table see Figure 20 Historical Contract Book This table will contain the following columns Contract Id Organization code Organization name Position account Instrument Side Order number Order header number Order header type Order price Contract price Volume Contract value User Rectification status Reverse con
21. and financial officers This document is designed as an operational guide to the Back Office website You will find that in some of the chapters processes are repeated The repetition of information in some places ensures that all chapters are complete giving you the opportunity to extract the information you deem necessary Page 3 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 2 Accessing the Back Office website You can access the Back Office website via your Internet browser The web address will vary depending on which environment you want to access Production Member test To access the production environment go to https backoffice apx nl When opening the above web address a login screen will be displayed In the top right hand corner of the header a message will display which environment you are accessing This can be seen in Figure 1 where it shows Power NL Production 5 0 in grey text BackOffice Website Microsoft Internet Explorer provided by APX Group laj x File Edit View Favorites Tools Help a Q O A Apm trom OG GLA Address http backoffice apx nlfindex php AEB in xX BACKOFFICE WEBSITE Username Passwor o RH iE Done St Internet Figure 1 Back Office website login screen To log in to the Back Office website you first need a user account Back Office website user accounts are independent of EuroLight accounts therefore persons not having a
22. be returned this could take up to 30 seconds After execution of the query the results will be displayed in a table See Figure 18 Page 21 BackOffice Website v5 0 for APX Power NL User Manual Document version 1 0 Chargeline Report Charge codes 11010 gt Type C osiy C Weekly C Monthiy 19 a mon 11020 Status C Final C Pretminary 19 a moz e ai eines C Totais on wu z 7 ee From 2008 0242 cf no charge codes To 2008 02 12 ES I open in Excel Query 11801960 36997 W 2008 02 12 2983198 APX 000001 APX_EUR_APXNLI 11010 NL 1H080212 H01 150 000 MW 150 000 MWh 17 50 ep 2525 0000 Cred 11801361 38997 W 2008 02 12 2983198 APX 000001 APX_EUR_APXNLI 11020 NL 1H080212 H01 150 000 MW 150 000 Mh 01400 emh 21 000 Charge 11801962 36997 W 2008 02 12 2983198 APX 000001 APX_EUR_APXNLI 11030 NL 1H080212 H01 150 000 MW 150 000 Mh 17 50 eut 190 498 7500 Credt 11301963 36997 W 2008 02 12 2983198 APX 000001 APX_EUR_APXNLI 11034 NL 1H080212 H01 150 000 MW 150 000 MWh 10 1400 MWh 190 3 9900 Charge 11801964 36997 W 2008 02 12 2983199 APX 000001 APX_EUR_APXNLI 11010 NL 1H080212 HO 150 000 MW 150 000 MWh 17 50 MWh lt 2625 0000 Creat 11801965 36997 W 2008 02 12 2983199 APX 000001 APX_EUR_APXNLA 11020 NL 1H080212 H01 150 000 MW 150 000 mh 041400 emh 21 0000 Charge 11801965 36997 W 2006 02 12 2983199 APX 000001 APX_EUR_APXNLI 11030 NL
23. by invoice group or by organization Please note that if you are grouping the results by organization the Invoice group filter menu will be disabled Interval Using this option you can select whether the information should be grouped by Instrument Invoice or Settlement period 4 5 8 2 Results After clicking on the Query button a popup will be appear see Figure 15 informing you to wait for the results while the query is executed Depending on the size of the query and the amount of data that needs to be returned this could take up to 30 seconds After execution of the query the results will be displayed in a table See Figure 29 Settlement Summary Organization Dee Invoice status C e ereiminary Invoicegroup bs S Group by Organization 19 invoicearoup Market F H Interval settement period C invoice instrument APX_EUR_APXNL1 2008 02 12 NL 1H080212H01 17 50 28500 MW 2650 0 MW 4637500 742 00 74200 140 99 EES ap A 2006 02 12 m ve 1600 2455 0 MW za zem za eme 51800 2455 0 MW 667 40 eea7ao 130 80 281800 2505 0 MW 701 40 man em zen 2006 02 12 27500 00 2500 0 MW 27600 00 700 00 emm 139 100 09300 2008 02 12 D E 24550 MW 27496 00 2455 0 MW zeen 867 40 ees7a0 eme 81800 1 APX_EUR_APXNL1 2008 02 12 NL 1H080212H07 D 25050 MW EECH 25050 MW 82123250 emma ema 133 28 283486 13 40 24550 MW 1409 2505 MW 1100 Figure 29 Settlement Summary results This tab
24. ccess to EuroLight can be given separate access to the Back Office website To obtain a user account please contact APX Power NL Operations 31 0 20 305 4042 To login Enter your username and password in the respective text boxes and click on the Login button If you entered correct user details you are logged in and the main interface will be shown If incorrect user details are entered you will be returned to the login page Page 4 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual In the case that the Back Office website is not available you will be notified via a message under the login box See Figure 2 for an example SLE a a _ File Edit view Favorites Tools Help ag Qa O x A seach qe ravortes A 0 2 e JE 15 Address http fbackoffice apx nlfindex php 8 E gt Ba Links BACKOFFICE WEBSITE Atth the Backoffice Website is loc epee ot login al minutes If this messa SECH please contact H n Done TT fag internet Figure 2 Back Office website unavailable Page 5 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 3 Interface description The interface of the Back Office website is divided into three parts the Header the Side bar and the Main area See Figure 3 18 x a File Edit View Favorites Tools Help Om O A Ol lao eee O E JA Address http backoffice
25. ce VAT Reg NL 8096 84 639 5 01 22 Jan 08 to 28 Jan 08 Print Netherlands d A N B Ve Date Issued 25 January 2008 Total amount Payable 8898683 08 Total amount excl VAT 7477882 81 Charge Summary Energy Fees VAT Rate VAT Total 11011 Energy purchases 7434440 84 000 19 00 8846936 91 1412546 07 11021 Fee contracted Energy purchases 0 00 43441 97 19 00 8254 20 51696 17 Total Amount Payable 7434440 84 43441 97 8898683 08 1420800 27 Account Summary Energy Fees VAT Total 626 APX Sales amp Trading_EUR_APXNL1 7434440 84 43441 97 1420800 27 8898683 08 Total Amount Payable 7434440 84 43441 97 1420800 27 8893683 08 VAT Summary Total Your Input Tax 1420800 27 Your Output Tax 0 00 Application of articles 38 and 39 Council Directive 2006 112 EC The Rules and Regulations APX Power Market apply This invoice amount will be deducted from your clearing account with number NL 8096 84 639 8 01 APK BY Trade Register No 34153887 VAT No NL 8096 84 639 8 01 Customer Service Desk APX Group T 31 20 305 4042 F 31 20 305 4002 E csdesk apxqroup com www apxqroup com Registered Office Strawinskylaan 729 1077XX Amsterdam The Netherlands Figure 8 The invoice and self bill parts 4 2 2 2 1 The header The header contains the following information On the left e Invoice self bill number only on final invoi
26. ces self bills e Organization information name amp address e VAT registration number In the middle e Type of the invoice Final or preliminary an invoice or self bill e Date of the invoice self bill On the right e Print button e Paid indicator A stamp like image is shown when the invoice self bill has been paid e Date the invoice self bill was issued only on final invoices 4 2 2 2 2 The totals The totals part shows the total amount due or owed including and excluding VAT Page 11 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 2 2 2 3 Charge Summary The Charge Summary shows the amount of the charge lines grouped and totalled by charge code and charge type Energy Fee VAT giving you an easy view on the amounts that form the total amount of the invoice 4 2 2 2 4 Account Summary The Account Summary shows the amounts of the charge lines grouped and totalled by settlement account and charge type Energy Fee VAT giving you an alternate view on the amounts that form the total amount of the invoice The amounts in this summary function as links to the Charge line details drill down screens Figure 9 and chapter 4 2 2 3 4 2 2 2 5 VAT Summary The VAT Summary shows the amount of VAT on this invoice grouped by input and output tax Input tax is the VAT calculated over amounts you have to pay i e energy purchases fees Output tax is the VAT calculated over amounts you receiv
27. e i e energy sales 4 2 2 2 6 The footer On preliminary invoices and self bills the footer is empty On final invoices the footer states the bank account number and other general APX information 4 2 2 3 Charge line details Upon selecting an amount in the Account Summary of an invoice the charge line details screen for the selected account charge type is displayed The Charge line details screen is built up of three parts the header the sub header and the charge lines Invoice Ho 14 yy APX Sales amp Trading P K Strawinskylaan 729 Final Settlement Print 1077 X Amsterdam Invoice ie Charge amp Fee Detail VAT Reg 22 Jan 08 to 28 Jan 08 APX Sales amp Trading_EUR_APXHL1 Energy 11717332 2962199 11011 Energy purchases NL 1H080122 H01 10 50 000 50 000 17 00 850 00 11717338 2962200 11011 Energy purchases NL 1H080122 H01 10 50 000 50 000 17 00 850 00 11717340 2962201 11011 Energy purchases NL 1H080122 H01 10 50 000 50 000 17 00 850 00 141717344 2962202 11011 Energy purchases NL 1H080122 H01 10 150 000 150 000 17 00 2550 00 141717348 2962203 11011 Energy purchases NL 1H080122 H01 10 150 000 150 000 17 00 2550 00 11717352 2962204 11011 Energy purchases NL 1H080122 H01 10 15 000 15 000 17 00 255 00 41717356 2962205 11011 Energy purchases NL 1H080122 H01 10 150 000 150 000 17 00 2550 00 11717360 2962206 11011 Energy purchases NL 1H080122
28. ern your access to reports The Side bar of the Reports section shows a list of all reports available to you while the main area shows the currently selected report For most reports you have to select one or more dates These dates can either be typed in directly or selected by using a popup calendar In case of manual entry the date has to be in the following format YYYY MM DD To open the popup calendar click on the Open popup Calendar button located on the right side of the date field see Figure 13 Some reports allow you to enter a from and to time allowing data to be returned that relates to specific times of the day This should be entered in the following format HH MM SS Behind the time field you ll see the timezone in which the time is interpreted This can be changed in your Settings From 2007 04 20 00 00 00 cut pma To 2007 04 20 23 59 59 GMT 1 April sl 2007 foes MTWTFSS f 26 27 28 29 311 25 45 97 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 4 Today Figure 13 Popup calendar 4 5 1 Excel export CSV All reports have an export to CSV functionality triggered via the button Export to CSV located directly below the displayed results When using this button the results are displayed in a CSV formatted output which can then be imported into another application for example Excel Additionally all reports can be opened directly in Excel I
29. f you select this option a file download dialogue box will ask if you wish to open or save the file Opening will open the file directly in Excel and save will allow you to choose a location on your network to save the file N B the file opens saves as a CSV To convert this to a standard Excel file with the file open in Excel you may need to select Data gt Text to columns and follow the wizard If this is not done automatically you need to change the profile settings more about this can be found in the chapter Settings If you re using Internet Explorer and you can t save the file to disk make sure the following option is disabled Tools gt Internet options gt Advanced Tab gt Security gt Do not save encrypted pages to disk Page 18 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 5 2 Tickerdata The Tickerdata report allows you to monitor public trade information To retrieve information set the filters to define your criteria and then click on the Query button In order to prevent timeouts and other problems the number of lines you can query in one request is limited to 1 000 If your request would return more then this a warning message is shown Current user test Tickerdata gt Tickerdata Chargelines Report Market segment TI Filter on C it Hi anise Book 9 ba Applying date Trade time Instruments From 2008 02 12 17 00 00 00 cer Hi rder Historical Matching Resu
30. formation for all organizations which you have access to grouped by organization Organization Specific Disabled Information for the selected organization organization grouped by organization Invoice S j Information for all invoice groups which group you have access to grouped by invoice group Invoice S Specific group Information for the selected invoice group group grouped by invoice group Invoice Specific Information for all invoice groups group organization related to the selected organization which you have access to grouped by invoice group Invoice Specific Specific group Information for the selected invoice group organization group grouped by invoice group You can only select organizations and invoice groups for which you have user rights Market Via this field you can select the Market for which you require the settlement information Page 35 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Settlement period Using these two fields a from and to date can be specified Settlement information of all invoices that have been settled between these two dates will be included Invoice status Via this option you select whether to retrieve information regarding preliminary or final invoices It is not possible to retrieve information regarding preliminary and final invoices in one request Group by Via this option you can select whether the information should be grouped summed
31. h 0 0 MAR 2008 02 12 NL 1H080212 H20 40 72 EMAh 0 0 MAh 0 0 MAM 0 0 MAh 2008 02 12 NL 1H080212 H21 25 00 b nk 0 0 MWh 0 0 MAh 0 0 Map 2008 02 12 NL 1H080212 H22 28 91 en 0 0 MAN 0 0 MWh 0 0 MAN 2008 0242 NL1H080212 H23 27 50 MWh 0 0 MWh 0 0 MWh 0 0 MAh 2008 02 12 NL 1HO80212 H24 18 10 MWh 0 0 MAh 0 0 MAh 0 0 MAh Export to CSV Figure 26 Historical matching results output Page 32 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 5 7 General Matching Results Via the General Matching Results report you can retrieve the MCP and MCV for each instrument for a specific applying date Upon selecting an applying date followed by clicking the Query button a table with the general matching results will be displayed Current user test General Matching Results Tickerdata Chargelines Report Market APX DAM Hour i Historical Contract Book ouy Z Openin Excel WW Historical Order Book Applying date 2008 02 13 Historical Matching Results gt General Matching Results Settlement Summary Matching 2008 02 12 14 40 49 CET 2008 02 13 NL 1H080213 HO1 17 00 3 741 0 MAh 2008 02 13 NL 1H080213 H02 14 00 3 550 0 Mh 2008 02 13 NL 1H080213 H03 12 40 3 550 0 MVVh 2008 02 13 NL 1H080213 H04 10 19 3 657 5 MAh 2008 02 13 NL 1H080213 H05 10 00 3 650 0 MAh 2008 02 13 NL 1H
32. he market you wish to see the results of Organization amp Position account With these two menus you can filter the organization and position account These menus work using a one or all principle all signified with an asterisk resulting in the following possible combinations Page 30 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Group by Organization Position Result account Organization Disabled Matching results for all organizations which you have access to grouped by organization Organization Specific Disabled Matching results for the selected organization organization grouped by organization Position a KR Matching results for all position account accounts which you have access to grouped by position account Position R Specific Matching results for the selected account account position account grouped by position account Position Specific e Matching results for all position account organization accounts related to the selected organization which you have access to grouped by position account Position Specific Specific Matching results for the selected account organization account position account grouped by position account You can only select organization and position accounts for which you have user rights Group by With this option you can select whether the matching results are grouped summed by position account or by
33. kOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Current user test Invoicegroup APX_EUR_APXNL1 e Fi Oi gt 22 Jan 08 to 28 Jan 08 Sales 15 Jan 08 to 21 Jan 08 Purchases Sales 8 Jan 08 to 14 Jan 08 Purchases Preliminary Invoices 12 Feb 08 to 18 Feb 08 Purchases Sales 5 Feb 08 to 11 Feb 08 Purchases Sales Figure 6 The side bar The dates relate to the invoice or self bill dates After selection the summary statement is displayed in the main area A summary statement is built up of several parts See Figure 7 e The header e The invoice total e The invoice number only on final summary statements e The self bill total e The self bill number only on final summary statements e The net amount payable receivable e The footer only on final invoice summaries Se Summary statement a 1077XX Amsterdam Final eege 22 Jan 08 to 28 Jan 08 Date Issued 25 January 2008 Purchases 14 8899693 03 Sales APXS 6 8970912 83 NET Amount Payable Receivable 72229 75 Figure 7 The summary statement parts 4 2 2 1 1 The header The header contains the following information On the left e Organization information name amp address e VAT registration number In the middle e Type of the invoice Summary Statement Final or preliminary e Settlement period the summary statement refers to On the right e Print button e Date the summary statement was iss
34. le has the following fields e Applying date Page 33 BackOffice Website v5 0 for APX Power NL User Manual e Instrument e MCP MCV Document version 1 0 Page 34 BackOffice Website v5 0 for APX Power NL User Manual 4 5 8 Settlement Summary Via the Settlement Summary section it is possible to retrieve information regarding the settlement of your contracts The data displayed in the Settlement Summary report is based on the charge lines of the individual invoices Document version 1 0 Settlement Summary Organization Invoicegroup Market Fal See ee Group by Interval Invoice status Final C Preliminary Settlement period Organization C invoice group From 2008 02 12 PF To 1 02 12 E Settlement period C Invoice 2008 02 12 I open in Excel Query Figure 28 Settlement Summary 4 5 8 1 Filters The Settlement Summary screen offers several filters with which you can set the criteria by which results should be selected and displayed Organization amp Invoice group Using these two menus you can filter on organization and invoice group Depending on the Group By settings the Invoice group field might not be available These menus work using a one or all principle all signified with an asterisk resulting in the following possible combinations Group by Organization Invoice group Result Organization Disabled In
35. le will have the following columns Organization Invoice group Settlement period Invoice nr Instrument MCP Sale volume Sale value Purchase volume Purchase value Fee value Netto excl VAT VAT Total value Page 36 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Depending on the Group by and Interval setting in the request some of these columns might be blank You can sort this table by clicking on the table headers A triangle next to the header title signifies on which column the table is currently sorted see Figure 17 By default the results are sorted by Organization and Settlement period Page 37 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 6 Profile In the profile section you can make a number of settings regarding how the information you wish to see throughout the Back Office website is displayed and you can also change the password for your Back Office website account Current user test Settings Timezone CET Decimal separator comma Thousand separator none CSV separator semicolon Change password 4 4 4 4 New password Confirm password Confirm changes Current password Save changes Figure 30 Profile 4 6 1 Settings The Back Office website is designed to service multiple platforms across multiple geographies You can set your preferred timezone and formatting settings here so the informatio
36. lts General Matching Results To AAA EE Settlement Summary La Open in Excel Query Figure 14 Tickerdata 4 5 2 1 Filters The Tickerdata screen offers several filters with which you can set the criteria by which results should be selected and displayed Market segment Using this menu you can filter on market segment Selecting a market segment will result in displaying information for the selected market segment only Instruments The instruments filter is a powerful field in which you can filter orders based on part or all of the instrument code For example NL 1H will return all rows with instruments that begin with NL 1H Please note this is case sensitive i e nl 1h will not return any rows From To The report can be filtered by applying date or trade time Using these two fields a from and to date and time can be specified If applying date is selected all orders which deliver between the selected dates and times will be displayed If trade time is selected all orders traded between the selected dates and times will be displayed 4 5 2 2 Results After clicking on the Query button a popup will be appear see Figure 15 informing you to wait for the results while the query is executed Depending on the size of the query and the amount of data that needs to be returned this could take up to 30 seconds Page 19 BackOffice Website v5 0 for APX Power NL User Manual Document version 1
37. n have different statuses represented by the following key M Filled Fulled contracted AM Open Accepted by Market Operator PM Open Partially matched O Open Pending RF Rejected Instrument Frozen RIP Rejected Invalid entry in Phase RNP Rejected No permission RM Rejected Rejected by Market Operator RW Rejected Sent to watchlist not complying to collateral R Rejected Trading closed WW Watched Order withdrawn to Watchlist RS Watched Sent to watchlist max side exceeded WX Withdrawn Order expiration date is expired WBM Withdrawn Withdrawn by Block Modify W Withdrawn Withdrawn by Participant WM Withdrawn Withdrawn by Market Operator Page 28 BackOffice Website v5 0 for APX Power NL User Manual 4 5 5 4 Order details Document version 1 0 The historical orderbook allows you to zoom in on the details of a specific order by clicking on the magnifying glass icon in the first column of the results see Figure 23 Q 7449130 Q 7449131 Figure 23 Magnifying glass icon to zoom in on order details When the icon is clicked a popup window will appear showing the order details of the selected order see Figure 24 The order details show the complete history of the selected order Orderdetails Order Nr 7449130 Header Nr 7449129 Header Type SpotLimit Instrument NL 1H080212 H01 7449130 Do 150 Mu 1600 00 74
38. n is shown in accordingly Timezone Use this option to select the timezone the Back Office website uses to interpret the input time fields Options e GMT Greenwich Mean Time e GB Greenwich Mean Time with daylight saving time e CET Central European Time with daylight saving time Decimal separator Use this option to select between a space a comma or a full stop Thousand separator Use this option to select between no separation a space a comma or a full stop CSV separator Use this option to select between a tab a semicolon or a comma Please note that whichever option you select here will be the option that you must use when importing any Back Office website files you have exported to CSV files into Excel using the Text to columns wizard If the List separator set in Windows is the same as specified here Excel will automatically perform the Text to columns conversion Please note that a separator cannot have the same value as on of the other separators Any settings that are changed will require you to input your password to confirm the changes Page 38 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual A typical profile for Back Office website users in the Netherlands would be Timezone CET Decimal separator Comma Thousand separator None CSV separator Semicolon 4 6 2 Change password To change your password first tick the Change Password box This activates the New
39. organization Please note that if you are grouping the results by organization the Position Account filter menu will be disabled Applying date With these two fields a from and to date and time can be specified The matching results for all instruments which start delivery between these two date and time will be displayed 4 5 6 2 Results After clicking on the Query button a popup will be appear see Figure 15 informing you to wait for the results while the query is executed Depending on the size of the query and the amount of data that needs to be returned this could take up to 30 seconds Page 31 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual After execution of the query the results will be displayed in a table see Figure 26 The first 3 columns of this table will by default display the applying date instrument and MCP Depending on your filter settings three additional columns for each organization position account are displayed showing the volumes bought sold and the net volume Current user test Historical Matching Results Tickerdata EE Market APXDAMHourly zl Applying date Historical Contract Book x Historical Order Book Organization From 2008 02 12 0 00 00 00 cer gt Historical Matching Results d General Matching Results Position account F zj To 2008 02 12 ed 23 59 59 CET Settlement Summary 0 SC Group by position account
40. ppears only months with invoices are displayed If you select a month a list containing all final invoices for selected month appears e Invoice Quick Finder Allows you to quickly jump to a specific invoice by entering the invoice number Page 7 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Current user test Invoice Ho 14 APX Sales amp Trading Invoicegroup Strawinskylaan 728 APX BV NL Power APX_EUR_APXNLI z 1077XX Amsterdam Final Settlement Invoice Netherlands Final Invoices i 22 Jan 08 to 28 Jan 08 VAT Reg NL 8096 84 639 5 01 P aid gt Purchases 22 Jan 08 to 28 Jan 08 indicator Sales 15 Jan 08 to 21 Jan 08 Purchases Date Issued 25 January 2008 Sales SE Total amount Payable 8898683 08 Purchases d Total amount excl VAT 7477882 81 Preliminary Invoices E Charge Summary Energy Fees VAT Rate VAT Total Sales 11011 Energy purchases 7434440 84 0 00 19 00 8846986 91 5 Feb 08 to 14 Feb 08 1412546 07 E Late 11021 Fee contracted Energy purchases 0 00 43441 97 19 00 8254 20 51696 17 11 06007 to 17 06007 Total Amount Payable 7434440 84 43441 97 8898683 08 Purchases 1420800 27 Invoice History Energy Fees VAT 2008 626 APX Sales amp Trading EUR_APXNL1 7434440 84 43441 97 1420800 27 8898683 08 Eau Total Amount Payable 7434440 43441 9
41. rently set to 1 000 If your request would return more then this a warning message is shown Current user test Historical Contract Book Organization e Filter on Applying date C Trade time Position account e From 2008 02 12 00 00 00 ceT Market segment f X To 2008 02 12 23 59 59 Cer Instruments id I open in Excel Query Figure 19 Historical contract book 4 5 4 1 Filters The historical order book offers several filters with which you can set the criteria on which orders should be selected Organization Position account Platform amp Market segment Via these four menus organizations position accounts and market segments can be filtered These menus function according to the one or all principle signified with an asterisk resulting in the following possible examples Organization Position Market Result account segment S S Contracts for all position accounts which you have access to are displayed Specific Contracts for the selected position account account are displayed Specific S Contracts for all position accounts organization related to the selected organization which you have access to are displayed Specific Specific j Contracts for the selected position organization account account are displayed KR Specific Contracts for the selected market market segment are displayed segment You can only select organizations and position
42. rical order book offers several filters with which you can set the criteria on which orders should be selected Organization Position account amp Market segment Via these four menus organizations position accounts and market segments can be filtered These menus function according to the one or all principle signified with an asterisk resulting in the following possible examples Page 26 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Organization Position Market segment Result account S Orders for all position accounts which you have access to are displayed R Specific Orders for the selected position account account are displayed Specific id i Orders for all position accounts organization related to the selected organization which you have access to are displayed Specific Specific KR Orders for the selected position organization account account are displayed S i Specific market Orders for the selected market segment segment are displayed Only organization and position accounts you have user permissions for can be queried The filters can be used in combination with one another to allow you to generate precise reports Instruments The instruments filter is a powerful field in which you can filter orders based on part or all of the instrument code For example NL 1H will return all rows with instruments that begin with NL 1H Please no
43. rning message is shown Current user test Chargeline Report Charge codes 11010 a Type paily C ween C monthly C Ai 11011 11020 Status 5 Final C Preliminary C an 11021 Show All chargelines Totals ont Deselect all 11030 S 2 uf pa From 2008 02 12 i if no charge codes are selected all chargecodes will be retumed To 2008 02 12 E m Open in Excel Query Figure 25 Chargeline report 4 5 3 1 Filters The chargeline screen offers several filters with which you can set the criteria by which results should be selected and displayed Charge codes Here you can select the charge codes that you would like to report on Type You can further refine your search to include daily weekly monthly or all settlement period types Status Via this option you select whether to retrieve information regarding preliminary or final invoices or both Show Via this option you can select whether the information displayed should include individual charge lines or only the total of all applicable charge lines From To Using these two fields a from and to date can be specified Information from all settlement periods that start within the selected date range will be included 4 5 3 2 Results After clicking on the Query button a popup will be appear see Figure 15 informing you to wait for the results while the query is executed Depending on the size of the query and the amount of data that needs to
44. te this is case sensitive i e nl 1h will not return any rows Applying date Using these two fields a from and to date can be specified All orders applying for dates which lie between these two dates will be displayed 4 5 5 2 Results After clicking on the query button a popup message will appear see Figure 15 informing you to wait for the results while the query is executed Depending on the size of the query and the amount of data that needs to be returned this could take up to 30 seconds After execution of the query the results will be displayed in a table See Figure 22 This table will have the following columns Zoom to order details Order number Header number Organization code Organization name Position account Type Status Page 27 BackOffice Website v5 0 for APX Power NL User Manual Applying date Instrument Side Price Unmatched volume Contracted volume Total volume Cash value User Lead time Location Meter no Reason code Submit time Last modified Document version 1 0 Historical Order Book 8 2 5a ajsa seal a E 2 3 2 EF 3 8 3 8 Figure 22 Historical Order book results This table can be sorted by clicking on the table headers A triangle next to the header title signifies on which column the table is currently sorted see Figure 17 By default the results are sorted by applying date 4 5 5 3 Order status column Orders ca
45. tract ID Lead time Location Page 24 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual e Meter no e Reason code e Trade time This table can be sorted by clicking on the table headers A triangle next to the header title signifies on which column the table is currently sorted see Figure 17 By default the results are sorted by Trade time Page 25 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 5 5 Historical Order book Via the Historical Order book section it is possible to retrieve information on all your orders stored in the EuroLight database including orders in the market that have not yet been matched Please note in EuroLight only the past 3 days of data can be queried To retrieve your orders you can set the filters to define your criteria and when you click on the Query button the information is displayed In order to prevent timeouts and other possible problems the number of lines you can query in one request is currently set to 1 000 If your request would return more then this a warning message is shown Ciarentuserins Historical Order Book Organization H X Applying date ar 006 Position account lt From 2008 02 12 00 00 00 cer istorica ng M Market segment ei To 2008 02 12 P 23 59 59 ceT Settlement Summary Instruments T open in Excel Query Figure 21 Historical order book 4 5 5 1 Filters The histo
46. ued only on final summary statements Page 9 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual 4 2 2 1 2 The totals The totals part shows the total amount of the invoice and the total amount of the self bill and a net amount payable receivable The hyperlinks will take you to either the self bill or invoice depending on your selection Invoice self bill numbers are displayed only on final summary statements 4 2 2 1 3 The footer On preliminary invoices the footer is empty On final invoices the footer states some general APX contact information 4 2 2 2 Invoice and Self bill Invoices and self bills can be selected using several options e Directly from the Side bar from the Final Invoices or Preliminary Invoices list e Indirectly via the hyperlink in the Summary Statement e Indirectly via the monthly invoice list in the Invoice History e Directly via the quick finder After selection the invoice or self bill depending on your selection is displayed in the main area Invoices and self bills are built up of several parts See Figure 8 e The header The totals The Charge Summary The Account Summary The VAT Summary only on final invoices The footer only on final invoices Page 10 BackOffice Website v5 0 for APX Power NL Document version 1 0 User Manual Invoice Ho 14 we APX Sales amp Trading APX BV NL Power Strawinskylaan 729 r 1077XX Amsterdam Final Settlement Invoi
47. you start in the Home section This section shows a box in which a message can be displayed set by APX In Figure 4 for example a welcome message is displayed Current user test Welcome to the APX DAM Production BackOffice website For questions regarding this website please contact the customer service desk at 31 20 305 4042 Figure 4 Home section 4 2 Invoices In the Invoices section you are able to view all your preliminary and final summary statements invoices and self bills To access this section you need user rights to at least one invoice group APX Power NL Operations can setup this access 4 2 1 Side bar The Side bar in the Invoices section contains five groups of data These are from top to bottom e Invoice group The invoice group selection menu If you have user rights to more than one invoice group you can select the desired invoice group by using a pull down menu e Final Invoices Displays a list of the latest final invoices for the selected invoice group Upon selection of an individual invoice it will be displayed in the main screen e Preliminary Invoices Displays a list of all preliminary invoices for the selected invoice group Upon selection of an individual invoice it will be displayed in the main screen e Invoice History Allows you access to all historic invoices The invoice history shows a list of years for which it has invoices If you select a year a sub menu with individual months a
Download Pdf Manuals
Related Search