Name |
|
Comment |
This report is available to participants as an audit trail of the entries in the CTP Receipt and Delivery Point Preferences markets portal application. |
Name |
BUY_SELL_POSITION |
PARTICIPANT_CODE |
PRODUCT_NAME |
STEP_NUMBER |
VERSION_DATETIME |
Name |
Data Type |
Mandatory |
Comment |
PARTICIPANT_CODE |
VARCHAR2(20) |
X |
The participant code used in the ETS. |
PRODUCT_NAME |
VARCHAR2(80) |
X |
The capacity product name. |
BUY_SELL_POSITION |
VARCHAR2(4) |
X |
Specifies the position that the contract reference must be used for, for example Buy, Sell or Both. |
STEP_NUMBER |
NUMBER(6) |
X |
The step number for the corresponding capacity quantity. |
VERSION_DATETIME |
DATE |
X |
The date and time the preference was updated. |
FROM_GAS_DATE |
DATE |
|
The first gas date that the contract reference takes effect from. Disregard the time component as this is not applicable. |
TO_GAS_DATE |
DATE |
|
The last gas date that the contract reference takes effect until. Disregard the time component as this is not applicable. |
OVERRIDE_FLAG |
VARCHAR2(3) |
|
A flag to indicate whether the receipt and delivery points specified in the original order should override this preference, for example Yes or No. |
PRODUCT_RECEIPT_POINT |
VARCHAR2(40) |
|
The default Receipt Point for Spread Product |
RECEIPT_POINT_ID |
NUMBER(8,0) |
|
The unique identifier of the Receipt Point as defined in the Transportation Service Point Register. This is the point where gas is injected into the pipeline |
RECEIPT_POINT_NAME |
VARCHAR2(255) |
|
The descriptive name of the Receipt Point as defined in the Transportation Service Point Register. |
PRODUCT_DELIVERY_POINT |
VARCHAR2(40) |
|
The default Delivery Point for Spread Product |
DELIVERY_POINT_ID |
NUMBER(8,0) |
|
The unique identifier of the Delivery Point as defined in the Transportation Service Point Register. This is the point where gas is withdrawn from the pipeline. Mandatory for service points registered under Part 24 of the rules. |
DELIVERY_POINT_NAME |
VARCHAR2(255) |
|
The descriptive name of the Delivery Point as defined in the Transportation Service Point Register. |
STEP_QUANTITY |
NUMBER(10,0) |
|
The step quantity to applied to the contract reference (GJ/day). |
LAST_UPDATED |
DATE |
|
The date and time the preference was updated. |
LAST_UPDATED_BY |
VARCHAR2(20) |
|
The user name who updated the preference. |
LASTCHANGED |
DATE |
|
The date and time the report was generated. |
|
|
|