Validation messages

If there are multiple records in the csv file, every record must pass validation. If any record in the file fails validation, the entire csv file is rejected.

Delivered quantity data is subject to the following validations:

Error code	Validation	Error message	Reference & comments
001	The filename format is invalid.	The filename provided does not comply with the naming convention.	Filename format.
002	The file ID cannot be duplicated.	A duplicate file ID detected.	File IDs must be unique, see Filename format.
003	The filename cannot be duplicated.	A duplicate filename detected.	File IDs must be unique, see Filename format.
004	The market identifier must be GSH.	An invalid market identifier. The market identifier must be GSH.	CSV file format.
005	The transaction descriptor in the filename must be DQ.	An invalid transaction descriptor.	Filename format.
006	The participant code provided must be a registered GSH participant.	An invalid participant code. The participant code provided is not registered with the GSH.	Contact your Participant ID's participant administrator.
007	The file must be in CSV format.	The supplied file is not in CSV format.	CSV file format.
008	The END OF REPORT number specified in the file must match the number of data rows in the file.	Then row number specified in the file does not match the number of data rows in the file.	CSV file format.
009	Mandatory fields are missing.	Missing mandatory fields (...). Where (...) represents a list of missing mandatory fields.	For the list of mandatory fields, see CSV file format.
101	The specified gas date must be less than today’s date.	The Gas Date [GASDATE] is outside the submission window.	Participants can only submit a delivered quantity for gas dates prior to the current gas date.
102	The specified gas date is already included in a Revision settlement run.	The Gas Date [GASDATE] has already been processed in a Revision settlement.	The submitted gas date is already processed in a Revision settlement.
103	The specified Transaction ID must exist for the specified gas date.	No matching Transaction ID [TRANSACTION_ID] found for Gas Date [GAS_DATE].	No matching Transaction ID found.
105	If the Action is ‘CONFIRM’, the delivered quantity data for the specified Transaction ID on the specified Gas Date must have been submitted.	Cannot confirm Transaction ID [TRANSACTION_ID] for gas date [GAS_DATE]. No delivered quantity data has been submitted for Transaction ID [TRANSACTION_ID] on gas date [GAS_DATE].	No delivered quantity data has been submitted for the Transaction ID.
106	A delivered quantity record cannot be resubmitted if one or more of the fields have not been modified (e.g. action is SUBMIT and the current status of the delivered quantity data is Submitted). The only action permitted in this scenario is CONFIRM.	Cannot resubmit Transaction ID [TRANSACTION_ID] for gas date [GAS_DATE]. No delivered quantity data has been changed.	Delivered quantity data must be changed to resubmit.
107	The specified buyer must match the buyer for the specified Transaction ID on the specified gas date. This is applicable to SUBMIT and CONFIRM actions.	Invalid Buyer [BUYER_PARTICIPANT_CODE] for Transaction ID [TRANSACTION_ID] on gas date [GAS_DATE].	The specified buyer must match the buyer for the specified Transaction ID on the specified gas date.
108	The specified seller must match the seller for the specified Transaction ID on the specified gas date. This is applicable to SUBMIT and CONFIRM actions.	Invalid Seller [SELLER_PARTICIPANT_CODE] for Transaction ID [TRANSACTION_ID] on gas date [GAS_DATE].	The specified seller must match the seller for the specified Transaction ID on the specified gas date.
109	The specified transaction quantity must match the quantity for the specified Transaction ID on the specified gas date. This is applicable to SUBMIT and CONFIRM actions.	Transaction Quantity [TRANSACTION_QUANTITY] does not match the quantity for Transaction ID [TRANSACTION_ID] on gas date [GAS_DATE].	The specified transaction quantity must match the quantity for the specified Transaction ID on the specified gas date.
110	The specified product location must match the production location for the specified Transaction ID on the specified gas date. This is applicable to SUBMIT and CONFIRM actions.	Product Location [PRODUCT_LOCATION] does not match the product location for Transaction ID [TRANSACTION_ID] on gas date [GAS_DATE].	The specified product location must match the production location for the specified Transaction ID on the specified gas date.
112	The specified delivered quantity must be a whole number.	The Delivered Quantity must be a whole number.	CSV file format.
113	The specified delivered quantity must be greater than or equal to 0.	The delivered quantity must be a positive number.	CSV file format.
114	The value for reason for variation must be D, R or NF.	An invalid value for ‘Reason for Variation’. It must be D, R or NF.	CSV file format.
115	If the Settlements Off-market is No, the delivered quantity cannot be NULL.	‘Delivered Quantity’ is a mandatory field when ‘Settlements Off-market’ is No.	CSV file format.
116	If the Settlements Off-market is No, the Reason For Variation cannot be NULL.	‘Reason for Variation’ is a mandatory field when ‘Settlements Off-market’ is No.	CSV file format.
117	If the action is Confirm, the value for the Settlements Off-market must be the same as the submitted value.	Cannot confirm Transaction ID [TRANSACTION_ID] for gas date [GAS_DATE]. The value for ‘Settlements Off-market’ is different from the submitted value.	CSV file format.
118	If the action is Confirm, the value for Delivered Quantity must be the same as the submitted value.	Cannot confirm Transaction ID [TRANSACTION_ID] for gas date [GAS_DATE]. The value for ‘Delivered Quantity’ is different from the submitted value.	CSV file format.
119	If the action is Confirm, the value for Reason for Variation must be the same as the submitted value.	Cannot confirm Transaction ID [TRANSACTION_ID] for gas date [GAS_DATE]. The value for ‘Reason for Variation’ is different from the submitted value.	CSV file format.
120	The value for Action must be S or C.	Invalid value for ‘Action’. It must be S or C.	CSV file format.