Action |
Type |
insert |
site |
Site Code |
Site Name |
delete |
site |
Site Code |
update |
site |
Current Site Code |
New Site Code |
Site Name |
insert |
supply |
Site Code |
Source Code |
Generator Type |
Supply Name |
GSP Group (geographic location) |
Start date (yyyy-MM-dd hh:mm) |
Finish Date |
MOP Contract |
MOP Account |
DC Contract |
DC Account |
Meter Serial Number |
Profile Class |
Meter Timeswitch Class |
CoP |
Standard Settlement Configuration (blank for HH supplies)
|
Import MPAN Core |
Import LLFC |
Import Supply Capacity |
Import Supplier Contract |
Import Supplier Account |
Export MPAN Core |
Export LLFC |
Export Supply Capacity |
Export Supplier Contract |
Export Supplier Account |
update |
supply |
MPAN Core |
Source Code |
Generator Type |
Supply Name |
GSP Group |
delete |
supply |
MPAN Core |
insert |
g_supply |
Site Code |
MPRN |
Supply Name |
Exit Zone |
Start date (yyyy-MM-dd hh:mm) |
Finish Date (YYYY-MM-dd hh:mm or blank for ongoing) |
Meter Serial Number |
Is Corrected? |
Unit |
Contract |
Account |
update |
g_supply |
Existing MPRN |
MPRN |
Supply Name |
Exit Zone |
delete |
g_supply |
MPRN |
insert |
era |
MPAN Core |
Start date (yyyy-MM-dd) |
Site Code |
MOP Contract |
MOP Account |
DC Contract |
DC Account |
Meter Serial Number |
Profile Class |
MTC |
CoP |
SSC |
Import MPAN Core |
Import LLFC |
Import Supply Capacity |
Import Supplier Contract |
Import Supplier Account |
Import ACTIVE? |
Import REACTIVE_IMP? |
Import REACTIVE_EXP? |
Export MPAN Core |
Export LLFC |
Export Supply Capacity |
Export Supplier Contract |
Export Supplier Account |
Export ACTIVE? |
Export REACTIVE_IMP? |
Export REACTIVE_EXP? |
update |
era |
MPAN Core |
Date |
Start date |
Finish date |
MOP Contract |
MOP Account |
DC Contract |
DC Account |
Meter Serial Number |
Profile Class |
MTC |
CoP |
SSC |
Import MPAN Core |
Import LLFC |
Import Supply Capacity |
Import Supplier Contract |
Import Supplier Account |
Export MPAN Core |
Export LLFC |
Export Supply Capacity |
Export Supplier Contract |
Export Supplier Account |
delete |
era |
MPAN Core |
Date |
insert |
channel |
MPAN Core |
Date (yyyy-MM-dd hh:mm) |
Import Related? |
Channel Type (active, reactive import, reactive export) |
delete |
channel |
MPAN Core |
Date |
Import Related? |
Channel Type (active, reactive import, reactive export) |
insert |
site_era |
Site Code |
Core MPAN |
Era Start Date |
Is Physical? |
insert |
hh_datum |
MPAN Core |
Date |
Channel Type |
Value |
Status |
insert |
user |
Email Address |
Password |
Password Digest |
User Role |
Participant Code |
Role Code |
update |
user |
Current Email Address |
Email Address |
Password |
Password Digest |
User Role |
Participant Code |
Role Code |
insert |
channel_snag_ignore |
MPAN Core |
Import Related? |
Channel Type |
Description |
From |
To |
insert |
channel_snag_unignore |
MPAN Core |
Import Related? |
Channel Type |
Description |
From |
To |
insert |
site_snag_ignore |
Site Code |
Description |
From |
To |
insert |
batch |
Role Name (dc, supplier or mop) |
Contract Name |
Reference |
Description |
update |
batch |
Role Name (dc, supplier or mop) |
Contract Name |
Old Reference |
New Reference |
Description |
insert |
bill |
Role Name (dc, supplier or mop) |
Contract Name |
Batch Reference |
Mpan Core |
Issue Date |
Start Date |
Finish Date |
Net |
Vat |
Gross |
Account Reference |
Reference |
Type |
Breakdown |
Kwh |
(Meter Serial Number |
Mpan |
Coefficient |
Units |
TPR |
Previous Date |
Previous Value |
Previous Type |
Present Date |
Present Value |
Present Type)* |
update |
bill |
Chellow Id |
Account |
Reference |
Issue Date |
Start Date |
Finish Date |
kwh |
Net |
Vat |
Type |
Paid? |
Breakdown |
update |
register_read |
Chellow Id |
TPR |
Coefficient |
Units |
Meter Serial Number |
MPAN |
Previous Date |
Previous Value |
Previous Type |
Present Date |
Present Value |
Present Type |
insert |
llfc |
DNO Code |
LLFC Code |
LLFC Description |
Voltage Level Code |
Is Substation? |
Is Import? |
Valid From |
Valid To |
update |
llfc |
DNO Code |
LLFC Code |
Valid From |
LLFC Description |
Voltage Level Code |
Is Substation? |
Is Import? |
Valid To |
delete |
llfc |
DNO Code |
LLFC Code |
Date |
insert |
market_role |
Market Role Code |
Market Role Description |
insert |
party |
Market Role Code |
Participant Code |
Name |
Valid From (YYYY-MM-dd hh:mm) |
Valid To (YYYY-MM-dd hh:mm) |
DNO Code |