{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Ark1","Ark2","Ark3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Ark1","index":0,"n_rows":64,"n_cols":2,"rows_kept":64,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["R005","Item no (box 32) is always used even if \"Items\" (box 5) = \"1\", \"Item no\" (box 32) is also \"1\"."]
["R021","A zero '0' is to be considered as a valid number in this field."]
["R028","If the negative IE303 is generated for a declaration request IE302 including an MRN, the same MRN shall be included in IE303. In any other case the data element shall not be present."]
["R030","The date has to be given in the format YYYYMMDD where: \nYYYY    = Year\nMM         = Month\nDD          = Day"]
["R031","In case of air- sea and inland waterway transportation the IMPORT OPERATION.MRN  may be replaced by following other data elements identifying the \r\n    diverted/arriving means of transport. \r\n    - the 'Identification of the means of transport' and\r\n    - the 'Transport mode at border (box 25)' and \r\n    - the 'Expected date of arrival'. \r\n\r\nThe 'Identification of the means of transport' shall - depending on the declared 'Transport  Mode at border (box 25) – correspond to following values :\r\n - 1 and 8 (sea  and inland waterway transport): \r\n - the International Maritime Organisation (IMO) ship identification number or \r\n - the European Vessel Identification Number (ENI), (both corresponding to IE315.IMPORT OPERATION.Identity crossing border (box 21)\r\n - 4 (air transport): \r\n - The (IATA) flight number. In code-share situations the flight number of the code-share partners shall be used. (corresponding to IE315.IMPORT \r\n   OPERATION.Conveyance reference number)"]
["R033","The ‘Declaration request number’ shall be allocated by the Customs generating the \r\n   declaration request. It shall be unique per Member State and shall be composed of:\r\n   - 1-2 digit: country code of the Member State;\r\n   - 3-22 digit: unique number per Member State."]
["R034","The ‘Diversion LRN’ of the diversion request (IE323) shall be indicated (if the declaration  request is generated based on a diversion request)."]
["R038","The 'Identification of the means of transport’of the diversion request (IE323) shall be \r\n            indicated if the declaration response (IE303) is generated based on a diversion request.\r\nThe 'Identification of the means of transport’of the declaration request (IE302) shall be \r\n            indicated if the declaration response (IE303) is generated based on a declaration request."]
["R039","The 'Arrival date’ of the diversion request (IE323) shall be indicated if the declaration \r\n         response (IE303) is generated based on a diversion request.\r\nThe 'Arrival date’ of the declaration request (IE302) shall be indicated if the declaration \r\n               response (IE303) is generated based on a declaration request."]
["R040","The data group can be present if the declaration response (IE303) is generated based on a declaration request (IE302). If the declaration response (IE303) is generated based on a  diversion request (IE323), the data group can not be used."]
["R080","Only the SPECIAL MENTIONS that are marked as 'Common' in the reference data shall be included in common domain messages."]
["R105","The total number of packages is equal to the sum of all ‘Number of packages’ + all ‘Number of pieces’ + a value of ‘1’ for each declared ‘bulk’."]
["R132","The data group 'RISK ANALYSIS' contains the consolidated risk analysis results from the Office of first Entry. Risk analysis results from the Office of Lodgement (if any) are transmitted, if it is part of the consolidation."]
["R133","Following data shall be forwarded:\r\n         • Case 1 (not applicable for ICS Phase 1): The full C_ENS_SND data including the relevant common safety and security risk analysis results. As relevant are to be regarded all occurrences of the data group 'RISK ANALYSIS' which include a 'Risk analysis result code' for which the last digit is 'A', 'B', 'C' or 'Z'  (only these occurrences of the data group 'RISK ANALYSIS' are to be forwarded).In case 1 the attribute 'IMPORT OPERATION.Information type' is set to '2'.\r\n         •Case 2: As long as ICS is restricted to the use of information type '1', case 2 shall be used in any case and shall consist:\r\n                  A. Either of the full C_ENS_SND data if relevant common risk analysis results are present on the ENS header level (regardless of the availability of risk analysis results that are linked to ENS goods items). This is the case where one or more occurrences of the data group 'RISK ANALYSIS' are available for which the attribute 'Item Number (Box 32) involved' is not present and for which the last digit of the attribute 'RISK ANALYSIS.Risk analysis result code' is 'A', 'B', 'C' or 'Z'. Only the occurrences of the data group 'RISK ANALYSIS' which have a Risk analysis result code of type 'A', 'B', 'C' or 'Z' shall be  sent.\r\n                 B. Or, in any other case, of the full C_ENS_SND data but including only the goods items (possibly all of them) for which relevant common risk analysis results are present on ENS goods item level. This is the case where one or more occurrences of the data group 'RISK ANALYSIS' are available for which the attribute 'RISK.ANALYSIS.Item Number (Box 32) involved' is present.  In this case only these occurrences of the ENS goods items and those occurrences of the 'RISK ANALYSIS' data group for which the last digit of the 'Risk analysis result code' is 'A', 'B', 'C' or 'Z' shall be sent. In case 2 the attribute 'IMPORT OPERATION.Information type' is set to '1'.\r\nOnce information type '2' becomes applicable, cases 1 and 2B shall be used only (case 2A shall become case 1)."]
["R134","The data group/attribute shall not be used if the message is sent to the 'Person lodging  the ENS'. If the message is sent to the 'Trader at Entry (Carrier)' and if the same  data group/attribute is present in the ENS, then it shall be present."]
["R148","The data in the IE corresponds always to the current (latest) version of the data. This means that it contains the amended declaration data (if any) and/or the revised declaration data after a control (if any)."]
["R221","Even if the IE is sent for one or more goods items of an ENS (but not for all of them), the following attributes shall contain the totals for the complete ENS (for all items declared in the ENS):\r\n         • Total number of items (box 5)\r\n         • Total number of packages (box 6)\r\n         • Total gross mass (box 35)"]
["R230","This attribute is used as a flag, its value can be either \"0\" (\"no\") or \"1\" (\"yes\")."]
["R660","The time has to be given in the format YYYYMMDDHHMM where:\r\nYYYY = Year\r\nMM = Month\r\nDD = Day\r\nHH = Hour\r\nMM = Minute"]
["R660","The time has to be given in the format YYYYMMDDHHMM where:\r\nYYYY = Year\r\nMM = Month\r\nDD = Day\r\nHH = Hour\r\nMM = Minute"]
["R661","The 'Declaration registration date and time' is the date and time when the ENS is registered and the MRN is allocated. It corresponds to the 'Declaration registration date and time' communicated in IE328."]
["R661","The 'Declaration registration date and time' is the date and time when the ENS is registered and the MRN is allocated. It corresponds to the 'Declaration registration date and time' communicated in IE328."]
["R662","The 'Amendment acceptance date and time' is the date when the acceptance of an amendment request to an ENS is registered. It corresponds to the 'Amendment acceptance date and time' communicated in IE304."]
["R662","The 'Amendment acceptance date and time' is the date when the acceptance of an amendment request to an ENS is registered. It corresponds to the 'Amendment acceptance date and time' communicated in IE304."]
["R666","The scheduled date/date and time of arrival of the means of transport at the declared\r\n           first Office of Entry shall be provided. It shall be the local date and time of the first place of arrival."]
["R666","The scheduled date/date and time of arrival of the means of transport at the declared\r\n           first Office of Entry shall be provided. It shall be the local date and time of the first place of arrival."]
["R670","The first two digits of the 'Place of loading' and 'Place of unloading' shall consist of the country code."]
["R670","The first two digits of the 'Place of loading' and 'Place of unloading' shall consist of the country code."]
["R805","The data group is to be used when different from the data group 'PERSON Lodging the summary declaration'."]
["R806","The data group is required if different from the data group 'PERSON Lodging the summary declaration'.The data group is required if different from the data group 'PERSON Lodging the summary declaration'."]
["R806","The data group is required if different from the data group 'PERSON Lodging the summary declaration'.The data group is required if different from the data group 'PERSON Lodging the summary declaration'."]
["R808","If some of the goods are destined to be transported to subsequent Offices of Entry, then this data group is required."]
["R808","If some of the goods are destined to be transported to subsequent Offices of Entry, then this data group is required."]
["R809","If the intervention/control notification is for one or some of the declared containers/identities crossing border (box 21)/transport documents, only those container numbers/ identities crossing border (box 21)/transport documents,  shall be included in the message."]
["R814","The Office to which the amendment request had been submitted shall be used. It is the Office to which this message will be sent."]
["R818","The data group/attribute shall be included in the message, if it had been provided by the Trader in the corresponding received declaration."]
["R820","If risk analysis has been performed for the requested MRN/MRN item number, only those occurrences of the data group 'RISK ANALYSIS' shall be included in the message for which the last digit of the attribute 'Risk Analysis result code' has one of the following values: 'A', 'B' or 'C'. \r\nIf no risk analysis has been performed for the requested MRN / MRN item number, then the declaration response (IE303) shall include one occurrence of the data group 'RISK ANALYSIS'. The 'Risk Analysis result code' shall be 'Z'."]
["R823","The United Nations Dangerous Goods Identifier (UNDG) is the unique serial number (n4) assigned within the United Nations to dangerous substances and articles. This element shall be provided where it is relevant."]
["R824","The 'Item Number (box 32) involved' shall be indicated if the risk analysis result relates to an item of an Entry summary declaration (ICS), Exit summary declaration or Export declaration (ECS) or Transit declaration (NCTS). In any other case the attribute 'Item Number (box 32) involved' shall not be used."]
["R826","For air cargo transported with other modes of transported than air, the other mode \r\n              of  transport shall be declared (e.g. for air cargo transported on road, the mode of transport '3' (road) shall be declared)."]
["R827","The 'Customs Office of Lodgement' shall be present if it is different from the 'Customs Office of first Entry' and not be present if it is the same as the 'Office of first Entry'."]
["R834","This following check shall be performed if the AEO-Database in which the AEO  certificate numbers are registered is available when performing the check:\r\n        •  The 'Specific circumstance indicator' with value 'E' (AEO) can be used only if the 'Person Lodging the ENS' and all 'Consignees' declared in the ENS have a valid AEO certificate of type 'AEOF' or 'AEOS'. \r\n        •  If an amendment request (IE313) is concerned and if the amendment request is sent by a Representative, then the Representative shall have a valid AEO certificate of type 'AEOF' or 'AEOS' as well."]
["R835","If the Trader has a valid EORI Trader Identification number (TIN), then the TIN shall be declared. Other than EORI-TIN shall not be used."]
["R835","If the Trader has a valid EORI Trader Identification number (TIN), then the TIN shall be declared. Other than EORI-TIN shall not be used."]
["R837","The EORI Trader Identification number (TIN) shall be declared."]
["R837","The EORI Trader Identification number (TIN) shall be declared."]
["R843","The 'Conveyance Reference Number' is the identification of the journey of the means of transport (e.g. flight number, train number, voyage number, trip number)."]
["R866","If the ENS is lodged by another party than the Carrier, then the transport document of the Carrier should be declared, if available."]
["R875","The attribute 'Item Number' refers to corresponding 'Item number' of the \tE_EXS_DAT \t(IE 615)/E_ENS_DAT (IE315) /E_EXP_DAT (IE515)/ E_DEC_DAT (IE15)."]
["R879","Exit: The country of final destination must be entered in any case. If the specific circumstance indicator is not equal to 'A', then at least the country of original departure must be entered additionally.\r\nEntry: The country of original departure must be entered in any case. If the specific circumstance indicator is not equal to 'A', then at least the country of final destination must be entered additionally."]
["R881","If the attribute is used, its minimum length is 4 digits."]
["R888","The item number as presented in the accepted (Entry) summary declaration with the same MRN has to be entered."]
["R891","The Local Reference Number (LRN)/Diversion LRN/Pre-Arrival LRN/Arrival LRN shall be a number/identifier allocated by the sending TRADER for a specific transaction (ENS, Pre-Arrival Notification, Arrival notification). It shall be unique per Trader sending the transaction."]
["R895","Only the Trader to whom the Office concerned is sending the advanced intervention notification (IE351) shall be used in the message."]
["R896","The data group 'TRADER Representative' can be used by the 'PERSON Lodging the entry summary declaration' to authorise a Representative to amend an Entry summary declaration on his behalf at the Office of first Entry concerned.\r\nIf preventive/prohibitive measures are to be taken (IE351) or if controls at Entry are to be communicated to the trader prior to the arrival at Entry (IE351), the trader identified here, will be receiving the 'Advanced intervention notification' – IE351."]
["R897","The attribute shall refer to the item number of the requested Entry summary declaration."]
["R899","The country code is required to enable ICS to request the ENS data and the safety and security risk analysis results at the declared Office of first Entry (e.g. in case of international diversion or where the forwarding has failed for any reasons). \r\nThe country code shall be declared if it is different to the third and fourth characters of the MRN. \r\nIt shall correspond to the first and second digit of the 'Customs Office of first Entry' declared in the Entry summary declaration. It is only required if the Diversion request/the Arrival notification is sent to a Member State which is different from that country."]
["TR0022","In case the value of a MESSAGE.GOODS ITEM.PACKAGES.Number of Packages is ‘0’ then there should exist at least one GOODS ITEM with the same 'Marks and Numbers of Packages', and 'Number of Packages' with value greater than ‘0’."]
["TR0099","This data item must be entered if the message is encoded in EDIFACT and the corresponding free text field is not in the UNOC character set. It is otherwise optional.\r\nIf the data item is filled in, it must contain the language code of the language used in the corresponding free text field."]
["TR0099","This data item must be entered if the message is encoded in EDIFACT and the corresponding free text field is not in the UNOC character set. It is otherwise optional.\r\nIf the data item is filled in, it must contain the language code of the language used in the corresponding free text field."]
["TR9175","The last digit, which is used to identify the type of risk, shall be validated against codelist “Risk analysis result code”."]
["TR9181","The field is Required for response and rejection messages. It does not apply for requests and one way messages."]
["TR9181","The field is Required for response and rejection messages. It does not apply for requests and one way messages."]
["TR9205","The “ENTRY KEY” data group shall be used only when the rejected messages are the IE302 and the IE303, and the Entry Key is present in these messages. Otherwise, the “Document/reference number” shall be used at the “HEADER” data group. For IE302 and IE303, the first MRN will be used (if the “ENTRY KEY” is not used). The “Document/reference number” data item and the “ENTRY KEY” data group cannot be used at the same time."]

{"sheet":"Ark2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Ark3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}