{"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":2,"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":276,"n_cols":7,"rows_kept":276,"cut":false,"hidden":false,"merged":[[0,1,0,4]],"flags":["formulas_cached_only"]}
["Condition","Logic operator",null,null,null,"Desciption"]
["C10","IF",null,null,null," first digit of ‘Transport mode at the border (box 25) ’ = ‘2’, ‘5’ or ‘7’"]
[null,null,"THEN",null,null,"‘NationalityCrossing border’ (box 21) = ‘O’"]
[null,null,"ELSE",null,null,"‘NationalityCrossing border’ (box 21) = ‘R’"]
[]
["C17","IF",null,null,null," 'IMPORT OPERATION.NationalityCrossing border (box 21)' is present"]
[null,null,"THEN",null,null,"the attribute = 'R'"]
[null,null,"ELSE",null,null,"the attribute = 'O'"]
[]
["C19","IF ",null,null,null,"IMPORT OPERATION.IdentityCrossing Border (box 21)' is present"]
[null,"OR","  ",null,null,"IMPORT OPERATION.SpecificCircumstance indicator' is = 'A' or 'B' "]
[null,null,"THEN",null,null,"the data groupCan not be used"]
[null,null,"ELSE ",null,null,"the data group = 'R'"]
[]
["C20","IF",null,null,null," first digit of 'Transport moder at border (box25)' = ‘2’, ‘5’ or ‘7’"]
[null,null,"THEN",null,null,"‘NationalityCrossing Border (ex. box 21) = ‘O’"]
[null,null,"ELSE",null,null,"‘NationalityCrossing Border (ex. box 21) = ‘R’"]
[]
["C62","IF ",null,null,null,"‘Kind of packages’ (Box 31) indicates ‘BULK’ (UNECE rec 21 : ‘VQ’, ‘VG’, ‘VL’, ‘VY’,’VR’ or ‘VO’)"]
[null,null,"THEN",null,null,"‘Number of packages’ (box 31)Can not be used"]
[{"$nulls":5},"‘Number of Pieces’ (box 31)Can not be used"]
[{"$nulls":5},"'Marks & numbers of Packages (Box 31)' = 'O'"]
[null,null,"ELSE"]
[null,null,"IF ",null,null,"‘Kind of packages’ (Box 31) indicates ‘UNPACKED’ (UNECE rec 21 : = ‘NE’, 'NF' or 'NG')"]
[null,null,null,"THEN",null,"‘Number of packages’Can not be used"]
[{"$nulls":5},"‘Number of Pieces’ (box 31) = ‘R’"]
[{"$nulls":5},"'Marks & numbers of Packages (Box 31)' = 'O'"]
[null,null,null,"ELSE",null,"‘Number of packages’ (box 31) = ‘R’"]
[{"$nulls":5},"‘Number of Pieces’ (box 31)Can not be used"]
[null,null,null,"IF",null," the attribute 'SpecificCircumstance indicator' is not used"]
[{"$nulls":4},"THEN"," the attribute 'Marks & numbers of Packages (Box 31)' = 'R'"]
[{"$nulls":4},"ELSE"," the attribute 'Marks & numbers of Packages (Box 31)' = 'O'"]
[]
["C305","IF ",null,null,null,"AAR-/AER-/Summary Declaration rejection reasonCode' = '4' (other)"]
[null,null,"THEN",null,null,"'AAR/AER/Summary Declaration rejection reason' = 'R'"]
[null,null,"ELSE",null,null,"'AAR/AER/Summary Declaration rejection reason' = 'O'"]
[]
["C310","IF ",null,null,null,"‘Amendment rejection motivationCode’ = ‘?’ (other) *"]
[null,null,"THEN",null,null,"'Amendment rejection motivation text' = 'R'"]
[null,null,"ELSE",null,null,"'Amendment rejection motivation text' = ‘O’"]
[]
[]
["C312","IF ",null,null,null,"Diversion RejectionCode'/'Entry Rejection MotivationCode' = '4' (Other)"]
[null,null,"THEN",null,null,"the attribute = 'R'"]
[null,null,"ELSE",null,null,"the attribute = 'O'"]
[]
["C501","IF ",null,null,null,"the attribute 'TIN' is present in the data group (and thus known by EORI)"]
[null,null,"THEN",null,null," this attribute = 'O'"]
[]
[null,null,"ELSE ",null,null," this attribute = 'R'"]
[]
["C502","IF",null,null,null," 'Transport mode at border' = '1', '4' or '8'"]
[null," ","THEN",null,null," the attribute = 'R'"]
[null,null,"ELSE ",null,null," the attribute = 'O'"]
[]
["C511","IF ",null,null,null,"only one 'TraderConsignor' is declared for all goods items"]
[null,null,"THEN",null,null," the data group 'TraderConsignor (box 2)' on IMPORT OPERATION level is used"]
[null,null,"ELSE",null,null," the data group 'TraderConsignor (ex box 2)' on GOODS ITEM level is used"]
[]
["C513","IF ",null,null,null,"first digit of ‘SpecificCircumstance indicator = 'A'"]
[null,null,"THEN",null,null," the attribute 'Transport mode at the border’ (box 25)' '7' and '9'Can not be used"]
[null,"IF ",null,null,null,"first digit of ‘SpecificCircumstance indicator = 'B'"]
[null,null,"THEN",null,null," the attribute 'Transport mode at the border’ (box 25)' '7' and '9'Can not be used"]
[null,"IF",null,null,null," first digit of ‘SpecificCircumstance indicator = 'C'"]
[null,null,"THEN",null,null," the attribute 'Transport mode at the border’ (box 25)' '1', '2', '4', '7', '8' and '9'Can not be used"]
[null,"IF ",null,null,null,"first digit of ‘SpecificCircumstance indicator = 'D'"]
[null,null,"THEN ",null,null,"the attribute 'Transport mode at the border’ (box 25)' '1', '3', '4', '7', '8' and '9'Can not be used"]
[null," ","ELSE",null,null," the attribute 'Transport mode at the border’ (box 25)' = 'O' (noCheck)"]
[]
["C514","IF ",null,null,null,"the attribute is present"]
[null,null,"THEN"]
[null,null,"IF",null,null," 'Transport mode at border' = '1' or '8'"]
[null," ",null,"THEN",null," the attributeConsists either of the International Maritime Organisation (IMO) ship identification number (format n7 - leading '0' allowed) or of the European Vessel Identification Number (ENI) (format n8 - leading '0' allowed) "]
[null,null,"IF",null,null," 'Transport mode at border' = '2' "]
[null," ",null,"THEN",null," the attributeConsists of the wagon number and has no format restrictions"]
[null,null,"IF",null,null," 'Transport mode at border' = '3' "]
[null," ",null,"THEN ",null,"the attributeConsists of the registration plate number and has no format restrictions"]
[null,null,null,"ELSE",null," no format restrictions"]
[]
["C515","IF ",null,null,null,"'Transport mode at border' = '1', '4' or '8'"]
[null," ","THEN ",null,null,"the attribute = 'O'"]
[null,null,"ELSE",null,null," the attributeCan not be used"]
[]
["C516","IF ",null,null,null,"the attribute is present"]
[null,null,"THEN"]
[null,null,"IF",null,null," 'Transport mode at border' = '1' or '8'"]
[null," ",null,"THEN",null," the attributeConsists either of the International Maritime Organisation (IMO) ship identification number (format n7 - leading '0' allowed) or of the European Vessel Identification Number (ENI) (format n8 - leading '0' allowed)"]
[]
[]
[null,null," IF ",null,null,"'Transport mode at border' = '4' "]
[null," ",null,"THEN",null,"the attributeConsists of the (IATA) flight number and has format an..8"]
[{"$nulls":5},"  - an..3: mandatory prefix identifying the airline/operator"]
[{"$nulls":5},"  - n..4: mandatory number of the flight "]
[{"$nulls":5},"  - a1: optional suffix "]
[]
["C517","IF",null,null,null," 'Transport mode at border' = '1', '4' or '8'"]
[null," ","THEN",null,null," the attribute = 'O'"]
[null,null,"ELSE",null,null," the attribute = 'R'"]
[]
["C518","IF",null,null,null," 'Transport mode at border' = '4' "]
[null," ","THEN",null,null," the attribute is 'R' andConsists of the (IATA) flight number and has format an..8:"]
[{"$nulls":5},"  - an..3: mandatory prefix identifying the airline/operator"]
[{"$nulls":5},"  - n..4: mandatory number of the flight "]
[{"$nulls":5},"  - a1: optional suffix "]
[null,"   ","ELSE",null,null," the attribute is 'O' and the format of the attribute has no restrictions"]
[]
["C519","IF ",null,null,null,"'Information type' is '1'"]
[null,null,"THEN ",null,null,"the data group 'Risk Analysis' is = 'R'"]
[null,null,"ELSE",null,null," the data group 'Risk Analysis' is = 'O'"]
[]
["C520","IF",null,null,null," the attribute ‘DIVERSION REQUEST.Identification of the means of transport' (IE323) or ‘DECLARATION REQUEST.Identification of the means of transport' (IE302) is used"]
[null,null,"THEN",null,null,"the data groupCan not be used"]
[null,null,"ELSE",null,null,"the data group is = 'R'"]
[]
["C521","IF ",null,null,null,"the data group 'IMPORT OPERATION’ is used"]
[null,null,"THEN",null,null,"the data group is ‘O’"]
[null,null,"ELSE",null,null,"the data groupCan not be used"]
[]
["C522","IF",null,null,null," the data group 'CUSTOMS OFFICE of first Entry' is used"]
[null,null,"THEN",null,null,"the attribute ‘CountryCode of Office of first Entry declared’Can not be used"]
[null,null,"ELSE",null,null,"the attribute ‘CountryCode of Office of first Entry declared’ is = 'R'"]
[]
["C523","IF",null,null,null,"the attribute ‘DIVERSION REQUEST.Identification of the means of  transport' (IE323) or ‘DECLARATION REQUEST.Identification of the means  of transport' (IE302) is used"]
[null,null,"THEN",null,null,"the attribute is = 'R'"]
[null,null,"ELSE",null,null,"the attribute is 'O'"]
[]
["C525","IF ",null,null,null,"the attribute 'DECLARATION RESPONSE.Information type is '1' and the attribute  'DECLARATION RESPONSE.Risk' is '0'"]
[null,null,"THEN",null,null,"the data groupCan not be used"]
[null,null,"ELSE",null,null,"the data group is = 'R'"]
[]
["C526","IF",null,null,null," the data group 'IMPORT OPERATION' is present"]
["     ",null,"THEN ",null,null,"the datagroup/attribute = 'O'"]
[null,null,"ELSE ",null,null,"the datagroup/attributeCan not be used"]
[]
["C527","IF ",null,null,null,"the attribute 'IMPORT OPERATION.ENS Risk' is = '0'"]
[null,null,"THEN",null,null,"the attributeCan not be used"]
[null,null,"ELSE",null,null,"the data group is = 'O'"]
[]
["C537","IF",null,null,null," the data group 'IMPORT OPERATION' is present"]
["     ",null,"THEN",null,null," the datagroup/attribute = 'R'"]
[null,null,"ELSE ",null,null,"the datagroup/attributeCan not be used"]
[]
["C540","IF",null,null,null," 'IMPORT OPERATION.ENS Risk' = '0'"]
["     ",null,"THEN ",null,null,"the datagroup/attributeCan not be used "]
[null,null,"ELSE",null,null," the datagroup/attribute = 'R'"]
[]
["C541","IF ",null,null,null," 'IMPORT OPERATION.Information type' is '0' or if 'IMPORT OPERATION.ENS Risk' = '0'"]
[null,null,"THEN",null,null,"this data group/attributeCan not be used "]
[null,null,"ELSE",null,null,"this data group/attribute is = 'O'"]
[]
["C542","IF",null,null,null,"  'IMPORT OPERATION.ENS Risk' = '0'"]
[null,null,"THEN",null,null,"this data group/attributeCan not be used "]
[null,null,"ELSE ",null,null,"the datagroup/attribute = 'C' (the otherConditions apply)"]
[]
["C546","IF ",null,null,null,"the data group 'CUSTOMS DATA REFERENCE (IE344 and IE347) /  IMPORT OPERATION.MRN' (IE340) is used"]
[null,null,"THEN",null,null,"this data group/attribute is = 'O'"]
[null,null,"ELSE",null,null,"this data group/attributeCan not be used"]
[]
["C550","IF",null,null,null," 'IMPORT OPERATION.ENS Risk' = '0'"]
["     ",null,"THEN",null,null," the datagroup/attributeCan not be used "]
[null,null,"ELSE ",null,null,"the datagroup/attribute = 'C' (the otherConditions apply)"]
[]
["C552","IF",null,null,null," 'PERSON Lodging the summary declaration' is used (because he is the sender of the  amendment request)."]
[]
[null,null,"THEN",null,null,"data group 'Trader Representative'Can not be used"]
[null,null,"ELSE",null,null,"data group 'Trader Representative' = 'R' (because he is the sender of the amendment request)"]
[]
[]
["C562","IF ",null,null,null,"SpecificCircumstance indicator is 'E' "]
["     "]
[null,null,"THEN ",null,null,"the attribute = 'R' "]
[null,null,"ELSE",null,null," the attribute = 'O'"]
["C564",{"$nulls":4},": FollowingCondition is toCheck the AEOCertificate and applies only as long as EORI is not in place:"]
[null,"IF",null,null,null," the attribute 'SpecificCircumstance indicator = 'E'"]
[null,null,"THEN",null,null,"the data group = R (for the first goods item)"]
[]
["C565",{"$nulls":4},": FollowingCondition is toCheck the AEOCertificate and applies only as long as EORI is not  In place:"]
[null,"IF",null,null,null," the attribute 'SpecificCircumstance indicator = 'E'"]
[null,null,"THEN",null,null,"the attribute 'Document Type (Box 44) withCode value 'Y022' and 'Y024' must be present (for the first goods item)"]
[]
["C566",{"$nulls":4},": FollowingCondition is toCheck the AEOCertificate and applies only as long as EORI is not in place:"]
[]
[null,"IF ",null,null,null,"the attribute 'Document Type (Box 44)' = 'Y022' or 'Y024'"]
[null,null,"THEN",null,null,"the attribute 'Document reference' must be the following:"]
[{"$nulls":5},"- 1-2 digits:CountryCode"]
[{"$nulls":5},"- 3-6 digits: AEO typeCode (AEOC, AEOF, AEOS)"]
[{"$nulls":5},"- following digits: no restrictions"]
[]
["C567","IF ",null,null,null,"the attribute 'SpecificCircumstance indicator = 'A'"]
[null,null,"THEN",null,null,"the attribute 'Commercial Reference Number (box 7)', 'Commercial Reference Number (ex box 7)' and the datagroup 'PRODUCED DOCUMENTS/CERTIFICATES' = 'O'"]
[null,null,"ELSE"]
[null,null,"IF ",null,null,"the attribute 'Commercial Reference Number (box 7)' and 'Commercial Reference Number (ex box 7)' is not used,"]
[null,null,null,"THEN ",null,"at least one attribute 'PRODUCED DOCUMENTS/CERTIFICATES.Document type' pointing to a transport document must be present"]
[null,null,null,"ELSE  ",null,"the data group 'PRODUCED DOCUMENTS/CERTIFICATES' = 'O'"]
[]
[]
["C570","IF ",null,null,null,"the attribute 'SpecificCircumstance indicator' = 'B'"]
[null,null,"THEN",null,null,"the data group is = 'O'"]
[null,null,"ELSE "]
[null,null,"IF ",null,null,"the attribute 'SpecificCircumstance incicator' = 'A'"]
[null,null,null,"THEN",null,"   the attribute must occur at least once (min. 1 value)"]
[null,null,null,"ELSE   ",null,"this attribute must occur at least twice (min. 2 values) "]
[]
["C571","IF ",null,null,null,"the attribute 'Item NumberConcerned' for at least one of the occurrences of the data group   CUSTOMS INTERVENTION' is present"]
["   ",null,"THEN ",null,null," the data group is = 'O'"]
[null,null,"ELSE  ",null,null," the data groupCan not be used"]
[]
[]
["C574","IF ",null,null,null,"the attribute 'SpecificCircumstance indicator' = 'A'"]
[null,null,"THEN",null,null,"the attribute 'IMPORT OPERATION.Loading place' is = 'O' the attribute 'GOODS ITEM.Loading place'Can not be used"]
[null,null,"ELSE"]
[null,null,"IF ",null,null,"the attribute 'IMPORT OPERATION.Loading place' is used"]
[null,null,null,"THEN   ",null,"the attribute 'GOODS ITEM.Loading place'Can not be used"]
[null,null,null,"ELSE   ",null,"the attribute 'GOODS ITEM.Loading place' = R"]
[]
["C576","IF ",null,null,null,"the attribute EXPORT OPERATION / IMPORT OPERATION / TRANSIT OPERATION.TransportCharges – Method of payment' is used"]
[null,null,"THEN",null,null,"this attributeCan not be used"]
[null,null,"ELSE",null,null,"this attribute = 'O'"]
[]
["C577","IF ",null,null,null,"the attribute 'SpecificCircumstance indicator' = 'A' or 'B'"]
[null,null,"THEN",null,null,"this data group = 'O'"]
[null,null,"ELSE",null,null,"this data group = 'R'"]
[]
["C579","IF",null,null,null,"the attribute 'SpecificCircumstance indicator' = 'B' or 'E'"]
[null,null,"THEN"]
[null,null,"IF ",null,null,"the attribute 'IMPORT OPERATION.Unloading place' is used"]
[null,null,null,"THEN  ",null," the attribute 'GOODS ITEM.Unloading place'Can not be used,"]
[null,null,null,"ELSE   ",null,"the attribute 'GOODS ITEM.Unloading place' = 'O'"]
[null,null,"ELSE"]
[null,null,"IF ",null,null,"the attribute 'IMPORT OPERATION.Unloading place' is used"]
[null,null,null,"THEN   ",null,"the attribute 'GOODS ITEM.Unloading place'Can not be used,"]
[null,null,null,"ELSE   ",null,"the attribute 'GOODS ITEM.Unloading place' = R"]
[]
["C582","IF ",null,null,null,"the data group 'PACKAGES' is used"]
[null,null,"THEN",null,null,"this attribute is = 'R'"]
[null,null,"ELSE",null,null,"this attributeCan not be used"]
[]
["C583","IF ",null,null,null,"the attribute 'SPECIAL MENTION.Additional information_id' = '10600' is used for at least one GOODS ITEM"]
[null,null,"THEN",null,null,"the data group 'TRADERConsignee' and the data group 'GOODS ITEM.TRADERConsignee'Can not be used"]
["                     ",null," IF ",null,null,"the data group 'TRADER Notify party' is used"]
[null,null,null,"THEN ",null,"the data group 'GOODS ITEM.TRADER.Notify party'Can not be used  "]
[null,null,null,"ELSE",null,"the data group 'GOODS ITEM.TRADER.Notify party'= 'R' Notify party'Can not be used "]
[null,null,null,"IF ",null,"the data group 'TRADERConsignee' is used"]
[{"$nulls":4},"THEN "," the data group 'GOODS ITEM.TRADERConsignee'Can not be used"]
[{"$nulls":4},"ELSE ","the data group 'GOODS ITEM.TRADERConsignee' = 'O'"]
[{"$nulls":6}," "]
["C585","IF ",null,null,null,"the attribute 'GOODS ITEM.Textual description' is used"]
[null,null,"THEN",null,null,"this data group is = 'O'"]
[null,null,"ELSE",null,null,"this data group is = 'R'"]
[]
["C586","IF ",null,null,null,"the attribute 'Arrival registration date and time' or 'Arrival rejection reason' is present"]
[null,null,"THEN  ",null,null,"the data group ' FUNCTIONAL ERROR'Can not be used"]
[null,"     ","ELSE",null,null,"  the data group ' FUNCTIONAL ERROR' = 'R'"]
[]
["C590","IF ",null,null,null,"the data group 'CUSTOMS DATA REFERENCE' is present"]
[null,null,"THEN",null,null,"this data group/ attributeCan not be used"]
[null,null,"ELSE",null,null,"this data group/ attribute is = 'O'"]
[]
["C591","IF ",null,null,null,"the data group 'CUSTOMS DATA REFERENCE' is present"]
[null,null,"THEN",null,null,"this data group/ attributeCan not be used"]
[null,null,"ELSE",null,null,"this data group/ attribute is = 'R'"]
[]
["C592","IF ",null,null,null,"the attribute 'SpecificCircumstance indicator' = 'E' "]
[null,"AND/OR",null,null,null,"'IMPORT OPERATION.Total gross mass is used"]
[null,null,"THEN",null,null,"this attribute is = 'O'"]
[null,null,"ELSE",null,null,"this attribute is = 'R'"]
[]
["C594","IF ",null,null,null,"the attribute 'Arrival registration date and time' is used"]
[null,null,"THEN  ",null,null,"the attribute 'Arrival rejection reason'Can not be used and the attribute 'Arrival rejection reason date and time'Can not be used"]
[null,null,"ELSE",null,null,"  the attribute 'Arrival rejection reason' = 'O' and the attribute 'Declaration rejection date and time'Can not be used"]
[null,"            "]
[]
["C597","IF ",null,null,null,"the attribute 'Arrival registration date and time' is used"]
[null,null,"THEN  ",null,null,"the data groupCan not be used"]
[null,null,"ELSE",null,null,"   the data group = 'R'"]
[{"$nulls":5}," * (To be defined at national level)."]

{"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"]}