Bill Export - Meter Accounts - pnpscada\
\
Bill Export Select the Billing Period, and the Meter Accounts, for which to export the Formal (Monthly) Bills.\
When the Export! button is pressed, the bills will be exported.\
\
There are many formats of which the native PNPSCADA ones are the following two: One Row/Record per Bill (Summary) CSV (comma separated values) download and One Row/Record per Line Item CSV download (Detailed).\
\
The formats of the CSV exports are as follows:\
Summary format:\
\
[TABLE=\"class: grid, width: 500\"]\\Bill ID\numeric\
\\Bill Date\YYYY-MM-DD HH:MM:SS.S\
\\Meter Account ID\numeric\
\\Meter Account Name\alphanumeric\
\\Total Excl. VAT\floating point\
\\Total Incl. VAT\floating point\
\\Meter/s\meter/s serial number/s - alphanumeric no embedded spaces\
\\Start Reading\numeric with unit\
\\End Reading\numeric with unit\
\\Max Demand\numeric with unit, if applicable\
\\Account Number\if applicable (optional field in edit->Meter Account screen)\
\\Lot Number\
\if applicable, you can also change the name of the field in the edit->Meter Account screen.\
\\Region\if applicable, you can also change the name of the field in the edit->Meter Account screen.\
\\Stand Number\if applicable, you can also change the name of the field in the edit->Meter Account screen.\
\
\
\
For Example:\
[CODE]\"Bill ID\",\"Bill Date\",\"Meter Account ID\",\"Meter Account Name\",\"Total Excl. VAT\",\"Total Incl. VAT\",\"Meter/s\",\"Start Reading\",\"End \
\
Reading\",\"Max.Demand\",\"Account Number\"[CR][NL]\"1253\",\"2009-05-19 00:00:00.0\",\"234\",\"Q-Studio 1\",\"12533.47\",\"14288.16\",\"93936859\",\"1.000kWh\",\"1204.000kWh\",\"148kVA\",\"q001\"[CR][NL][/CODE]\
\
Detailed format:\
[TABLE=\"class: grid, width: 500\"]\\Bill Run ID\numeric\
\\Account ID\numeric, auto assigned by system\
\\Account Name\alphanumeric\
\\Start\YYYY-MM-DD HH:MM:SS.S\
\\End\YYYY-MM-DD HH:MM:SS.S\
\\Item ID\numeric\
\\Tariff Name\alphanumeric\
\\Tariff ID\numeric\
\\Qty\floating point\
\\Units\alphanumeric\
\\Rate\floating point\
\\Amount\floating point\
\\Description1\alphanumeric\
\\Description2\alphanumeric\
\\Comparison ID\numeric\
\\TOU register start reading\if this is a TOU consumption tariff line item, numeric in the db units, e.g. kWh or kl\
\\TOU register end reading\if this is a TOU consumption tariff line item, numeric in the db units, e.g. kWh or kl\
\\Account Number\if applicable (optional field in edit->Meter Account screen)\
\\Lot Number\if applicable, you can also change the name of the field in the edit->Meter Account screen.\
\\Region\if applicable, you can also change the name of the field in the edit->Meter Account screen.\
\\Stand Number\if applicable, you can also change the name of the field in the edit->Meter Account screen.\
\\.\\
\\and the meter readings\\
\\.\\
\\Bill Run ID\numeric\
\\Account ID\numeric\
\\Account Name\alphanumeric\
\\Reading Date\YYYY-MM-DD HH:MM:SS.S\
\\Meter Serial Number\alphanumeric (no spaces)\
\\Total Type\Start/End\
\\Active energy\floating point\
\\Reactive energy (Q1)\floating point\
\\Active energy(Reversed)\floating point\
\\Reactive energy(Reverse Lagging)\floating point\
\\Reactive Energy(Reverse Leading)\floating point\
\\Reactive Energy(Forward Leading)\floating point\
\
\
\
For Example:\
\
[CODE]

\\\
\\\
\\\
\\\
\\\
\\\
\\\
\\\
\\\
\\\
\\\
\\\
\

Bill Run ID,Account ID,Account Name,Start,End,Item ID,Tariff Name,Tariff ID,Qty,Units,Rate,Amount,Description1,Description2,Comparison ID,[CR][NL]

\"2853\",\"184\",\"DBN TOYOTA TOTAL\",\"2009-12-01 00:00:00.0\",\"2010-01-01 00:00:00.0\",\"25995\",\"Network Demand Charge (LS)\",\"1000000196\",\"25244.80144505\",\"kVA\",\"41.8\",\"1055232.70040309\",\"\",\"0.994pf 2009-12-08 08:30\",\"824\",[CR][NL]

\"2853\",\"184\",\"DBN TOYOTA TOTAL\",\"2009-12-01 00:00:00.0\",\"2010-01-01 00:00:00.0\",\"25996\",\"Off-peak (LS)\",\"1000000192\",\"2683500\",\"kWh\",\"0.1755\",\"470954.25\",\"Diversified\",\"Total 1011339543.4kWh\",\"813\",[CR][NL]

,[CR][NL]

[CR][NL]

[CR][NL]

[CR][NL]

Bill Run ID,Account ID,Account Name,Reading Date,Meter Serial Number,Total Type,Active energy,Reactive energy,Active energy(Reversed),Reactive energy(Reverse Lagging),Reactive Energy(Reverse Leading) ,Reactive Energy(Forward Leading),[CR][NL]

\"2853\",\"184\",\"DBN TOYOTA TOTAL\",\"2009-12-01 00:00:00.0\",\"95367341\",\"Start\",\"716916.400kWh\",\"3300.000kvarh\",\" \",\" \",\" \",\" \",

\"2853\",\"184\",\"DBN TOYOTA TOTAL\",\"2010-01-01 00:00:00.0\",\"95367341\",\"End\",\"4174316.400kWh\",\"25500.000kvarh\",\" \",\" \",\" \",\" \",

\"2853\",\"184\",\"DBN TOYOTA TOTAL\",\"2009-12-01 00:00:00.0\",\"95367342\",\"Start\",\"696450.000kWh\",\"4400.000kvarh\",\" \",\" \",\" \",\" \",

\"2853\",\"184\",\"DBN TOYOTA TOTAL\",\"2010-01-01 00:00:00.0\",\"95367342\",\"End\",\"4172550.000kWh\",\"52900.000kvarh\",\" \",\" \",\" \",\" \",

\
[/CODE]\
\
\
\
\
Bill Export is mentioned on: [URL=\"http://85.10.211.170:700/vqwiki/jsp/Wiki?List of Screens in PnPScada&highlight=List+of+Screens+in+PnPScada\"]List of Screens in PnPScada