{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Import Certificate","申請書","VBAHelper"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Instructions","index":0,"n_rows":97,"n_cols":5,"rows_kept":97,"cut":false,"hidden":false,"merged":[[0,1,0,4],[87,0,91,0],[92,0,96,0],[4,0,16,0],[22,0,86,0]]}
[null,"Organic INTEGRITY Database Import Certificate Data Dictionary: please use the instructions below to format your data on NOP Import Certificates for the NOP INTEGRITY database.\nThe NOP Import Certificate and Instructions can be found at https://www.ams.usda.gov/resources/nop-2110-1\nData Visibility: Only staff of the Certifier that issued the certificate, their accrediting trade partner government staff, and USDA-NOP staff can view specific NOP Import Certificates.\nFields with green text can be edited."]
[null,"Data Element","Data Element Name","Required/Optional/Autofilled","Instructions"]
[null,"ic_certNum","Import Certificate Number (Box 4)","Optional","Leave blank for new certificates, enter existing certificate number to edit. Columns S, CJ, CK, CL, CN can be edited."]
[null,null,"Import Certificate Status","Autofilled - Do Not Edit","Valid/Invalid. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_certifier","Certifying Body (CB) Issuing Certificate (Box 8)","Autofilled from User Profile - Do Not Edit","Certifier Name (ISO 3 Letter Country Code for Program). Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,null,"Issuing CB Website","Autofilled from User Profile - Do Not Edit","From Certifier Profile.  Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_isuCbHasAltContact","Issuing CB Alternate Contact Information (Box 8)","Yes as applicable","Yes/No. Leave columns F-O blank if no Issuing Certifier Satellite Office/Alternate Contact Information is needed."]
[null,"ic_isuCbContAddLine1","Issuing CB Contact Address Line 1 (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","From Certifier Profile or Satellite Office Alternate Information. City, State/Province, Country, and ZIP/Postal Code information must be entered separately in the relevant columns. "]
[null,"ic_isuCbContAddLine2","Issuing CB Contact Address Line 2 (Box 8)","Autofilled or Optional for Issuing Certifier Satellite Office/ Alternate Contact","From Certifier Profile or Satellite Office Alternate Information. Additional address information. "]
[null,"ic_isuCbContCity","Issuing CB Contact City (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","From Certifier Profile or Satellite Office Alternate Information. Use Title Case. If no city exists, then leave blank.  Required for U.S. operations. "]
[null,"ic_isuCbContState","Issuing CB Contact State/ Province (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","From Certifier Profile or Satellite Office Alternate Information. Required for U.S. operations. "]
[null,"ic_isuCbContCountry","Issuing CB Contact Country (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","From Certifier Profile or Satellite Office Alternate Information. Select from Country List."]
[null,"ic_isuCbContZip","Issuing CB Contact ZIP/Postal Code (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","From Certifier Profile or Satellite Office Alternate Information. City, State/Province, Country, and ZIP/Postal Code information must be entered separately in the relevant columns."]
[null,"ic_isuCbContFName","Issuing CB Contact First Name (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","From Certifier Profile or Satellite Office/User Alternate Information. Enter only one first name. Use Title Case."]
[null,"ic_isuCbContLName","Issuing CB Contact Last Name (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","From Certifier Profile or Satellite Office/User Alternate Information. Enter only one last name. Use Title Case."]
[null,"ic_isuCbContPhone","Issuing CB Contact Phone Number (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","From Certifier Profile or Satellite Office/User Alternate Information. For U.S. numbers, use (XXX)XXX-XXXX format. Enter extensions as \"Ext. XXXX.\" For international numbers, begin with the country code. Do not include \"011.\" If the exporter does not have a telephone number, leave blank. "]
[null,"ic_isuCbContEmail"," Issuing CB Contact Email (Box 8)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","From Certifier Profile or Satellite Office/User Alternate Information. Do not enter website addresses. Incomplete addresses will be deleted. "]
[null,"ic_program","Organic Standard Product Certified To (Box 1)","Required","Select from Organic Standards List - Dropdown Menu"]
[null,"ic_SingleShipment","Single Shipment","Yes as applicable","Yes/No"]
[null,"ic_startDate","Certificate Start Date (Box 3)","Required","Date the selected Import Certificate became effective. MM/DD/YYYY"]
[null,"ic_endDate","Certificate End Date (Box 3)","Required - Published ICs can be edited to up to 18 months from Start Date.","Date the selected Import Certificate  effective date ended. For single shipment, enter same date as Start Date. MM/DD/YYYY"]
[null,"ic_expCountry","Product Exported From (Box 6)","Required","Select from Country List - Dropdown Menu"]
["Entity Information ","ic_expNOPId","Certified Exporter NOP ID (Box 5)","Required for Certified Exporters. If Certified, do not complete columns AA-AL.","NOP's 10-digit unique ID for operation. If entered, columns AA-AL  will be ignored."]
[null,"ic_altExpContact","Alternate Certified Exporter Contact Information","Yes as applicable","Yes/No. Leave columns W-Z blank if no Alternate Exporter Contact Information is needed."]
[null,"ic_altExpFirstName","Alternate Certified Exporter Contact First Name (Box 5)","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Enter only one first name. Use Title Case."]
[null,"ic_altExpLastName","Alternate Certified Exporter Contact Last Name (Box 5)","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Enter only one last name. Use Title Case."]
[null,"ic_altExpPhNum","Alternate Certified Exporter Contact Phone Number (Box 5)","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","For U.S. numbers, use (XXX)XXX-XXXX format. Enter extensions as \"Ext. XXXX.\" For international numbers, begin with the country code. Do not include \"011.\" If the exporter does not have a telephone number, leave blank. "]
[null,"ic_altExpEmail","Alternate Certified Exporter Contact Email (Box 5)","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Do not enter website addresses. Incomplete addresses will be deleted. "]
[null,"ic_unCertExp","Uncertified Exporter","Yes as applicable","Yes/No. Leave columns AB-AL blank if Certified Exporter NOP Operation ID is entered in Column U. "]
[null,"ic_unCertExpOpName","Exporter Operation Name (Box 5)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified- database does not process this column for Certified Exporters. Operation's business name. Enter text in Title Case. "]
[null,"ic_unCertExpAddLine1","Exporter Address Line 1 (Box 5)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Exporters. City, State/Province, Country, and ZIP/Postal Code information must be entered separately in the relevant columns."]
[null,"ic_unCertExpAddLine2","Exporter Address Line 2 (Box 5)","Optional; Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Exporters. Additional address information. "]
[null,"ic_unCertExpCity","Exporter City (Box 5)","Required if Uncertified (US). Autofilled if Certified.","Do not edit if Certified - database does not process this column for Certified Exporters. Use Title Case. If no city exists, then leave blank.  Required for U.S. operations. "]
[null,"ic_unCertExpState","Exporter State/ Province (Box 5)","Required if Uncertified (US). Autofilled if Certified.","Do not edit if Certified - database does not process this column for Certified Exporters. Required for U.S. operations."]
[null,"ic_unCertExpCountry","Exporter Country (Box 5)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Exporters. Select from Country List.  "]
[null,"ic_unCertExpZipPostal","Exporter ZIP/Postal Code (Box 5)","Required if Uncertified (US). Autofilled if Certified.","Do not edit if Certified - database does not process this column for Certified Exporters. Use 5-digit zip code for U.S. states. Use appropriate mailing code for international addresses."]
[null,"ic_ucExpFirstName","Exporter Contact First Name (Box 5)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Exporters. Enter only one first name. Use Title Case."]
[null,"ic_ucExpLastName","Exporter Contact Last Name (Box 5)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Exporters. Enter only one last name. Use Title Case."]
[null,"ic_ucExpPhNum","Exporter Contact Phone Number (Box 5)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Exporters. For U.S. numbers, use (XXX)XXX-XXXX format. Enter extensions as \"Ext. XXXX.\" For international numbers, begin with the country code. Do not include \"011.\" If the operation does not have a telephone number, leave blank. "]
[null,"ic_ucExpEmail","Exporter Contact Email (Box 5)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Exporters. Do not enter website addresses. Incomplete addresses will be deleted. "]
[null,"ic_fhSameExp","Final Handler is the same as Exporter","Yes as applicable","Yes/No. If Yes, do not complete columns AN-BD, and Column U must be completed with NOP 10-digit unique ID for Certified Exporter"]
[null,"ic_fhNopId","Certified Final Handler NOP ID (Box 14)","Required if Final Handler is not same as Certified Exporter (column AM = No and column U is completed with NOP 10-digit unique ID for Certified Exporter).","NOP's 10-digit unique ID for operation. Final Handler must be certified."]
[null,"ic_fhAltContact","Alternate Final Handler Contact Information","Yes as applicable","Yes/No. Leave columns AP-AS blank if no Alternate Certified Final Handler Contact Information is needed."]
[null,"ic_fhAltFirstName","Alternate Final Handler Contact First Name (Box 14)","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Enter only one first name. Use Title Case."]
[null,"ic_fhAltLastName","Alternate Final Handler Contact Last Name (Box 14)","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Enter only one last name. Use Title Case."]
[null,"ic_fhAltPhNum","Alternate Final Handler Contact Phone Number (Box 14)","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","For U.S. numbers, use (XXX)XXX-XXXX format. Enter extensions as \"Ext. XXXX.\" For international numbers, begin with the country code. Do not include \"011.\" If the exporter does not have a telephone number, leave blank. "]
[null,"ic_fhAltEmail","Alternate Final Handler Contact Email (Box 14)","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Do not enter website addresses. Incomplete addresses will be deleted. "]
[null,"ic_fhOpName","Final Handler Operation Name (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhAddLine1","Final Handler Address Line 1 (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhAddLine2","Final Handler Address Line 2 (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhCity","Final Handler City (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhState","Final Handler State/ Province (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhCountry","Final Handler Country (Box14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhZip","Final Handler ZIP/Postal Code (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhContactFName","Final Handler Contact First Name (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhContactLName","Final Handler Contact Last Name (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhContactPhone","Final Handler Contact Phone Number (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhContactEmail","Final Handler Contact Email (Box 14)","Autofilled","From Final Handler Operation Record. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column."]
[null,"ic_fhCertBody","Certifying Body (CB) of Final Handler (Box 15)","Autofilled from Final Handler Operation Profile","Certifier Name (ISO 3 Letter Country Code for Program). Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBAddLine1","Final Handler CB Address Line 1 (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBAddLine2","Final Handler CB Address Line 2 (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBCity","Final Handler CB City (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBState","Final Handler CB State/Province (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBCountry","Final Handler CB Country (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBZip","Final Handler CB ZIP/Postal Code (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBFName","Final Handler CB Contact First Name (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBLName","Final Handler CB Contact Last Name (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBPhone","Final Handler CB Contact Phone Number (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_fhCBEmail","Final Handler CB Contact Email (Box 15)","Autofilled","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_recNopId","NOP ID for Certified Recipient in the U.S. (Box 7)","Required for Certified Recipients. If Certified, do not complete columns BV-CG.","NOP's 10-digit unique ID for operation. "]
[null,"ic_altRecContact","Alternate Certified Recipient Contact Information","Yes as applicable","Yes/No. Leave columns BR-BU blank if no Alternate Certified Recipient Contact Information is needed. "]
[null,"ic_altRecFirstName","Alternate Certified Recipient Contact First Name (Box 7)","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Enter only one first name. Use Title Case."]
[null,"ic_altRecLastName","Alternate Certified Recipient Contact Last Name (Box 7)","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Enter only one last name. Use Title Case."]
[null,"ic_altRecPhNum","Alternate Certified Recipient Contact Phone Number (Box 7)","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","For U.S. numbers, use (XXX)XXX-XXXX format. Enter extensions as \"Ext. XXXX.\" For international numbers, begin with the country code. Do not include \"011.\" If the exporter does not have a telephone number, leave blank. "]
[null,"ic_altRecEmail","Alternate Certified Recipient Contact Email (Box 7)","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Do not enter website addresses. Incomplete addresses will be deleted. "]
[null,"ic_unCertRec","Uncertified Recipient (Box 7)","Yes as applicable","Yes/No. Leave columns BW-CG blank if Certified Recipient NOP Operation ID is entered in Column BP."]
[null,"ic_unCertRecOpName","Recipient Operation Name (Box 7)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Operation's business name. Enter text in Title Case. "]
[null,"ic_unCertRecAddLine1","Recipient Address Line 1 (Box 7)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. City, State/Province, Country, and ZIP/Postal Code information must be entered separately in the relevant columns."]
[null,"ic_unCertRecAddLine2","Recipient Address Line 2 (Box 7)","Optional, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Additional address information. "]
[null,"ic_unCertRecCity","Recipient City (Box 7)","Required if Uncertified (US). Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Use Title Case. If no city exists, then leave blank.  Required for U.S. operations. "]
[null,"ic_unCertRecState","Recipient State (box 7)","Required if Uncertified (US). Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Required for U.S. operations. "]
[null,"ic_unCertRecCountry","Recipient Country (Box 7)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Select from Country List.  "]
[null,"ic_unCertRecZipPostal","Recipient ZIP/Postal Code (Box 7)","Required if Uncertified (US). Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Use 5-digit zip code for U.S. states. Use appropriate mailing code for international addresses. "]
[null,"ic_ucRecFirstName","Recipient Contact First Name (Box 7)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Enter only one first name. Use Title Case. Enter only one first name. Use Title Case. "]
[null,"ic_ucRecLastName","Recipient Contact Last Name (Box 7)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Enter only one last name. Use Title Case."]
[null,"ic_ucRecPhNum","Recipient Phone Number (Box 7)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. For U.S. numbers, use (XXX)XXX-XXXX format. Enter extensions as \"Ext. XXXX.\" For international numbers, begin with the country code. Do not include \"011.\" If the operation does not have a telephone number, leave blank. "]
[null,"ic_ucRecEmail","Recipient Email (Box 7)","Required if Uncertified, Autofilled if Certified","Do not edit if Certified - database does not process this column for Certified Recipients. Do not enter website addresses. Incomplete addresses will be deleted. "]
["Product Information","ic_product","Product As Labeled (Box 11)","Required","For raw products, enter the common name of the products(s). For packaged products, enter the name shown on the principal display panel (front of the package)."]
[null,"ic_htsCode","HTS Code (Box 12)","Required","10-digit HTS Code from https://hts.usitc.gov (do not include any punctuation)"]
[null,"ic_totalWeight","Total Net Weight (Box 9)","Required - Published ICs can be edited.","Kilograms (KG) for all shipments."]
[null,"ic_totalContainers","Total Containers (Box 10) ","Optional - Published ICs can be edited.","Integer whole number"]
[null,"ic_lotNum","Shipping Identification - Flight #, Vessel #, Container #, Lot #, etc.  (Box 13) ","Optional - Published ICs can be edited.","Max 4,000 Characters"]
["Additional Information","ic_productCityState","City and State of Product Destination (Box 2)","Autofilled from Recipient in U.S. - Do Not Edit","Recipient City and State. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_remarks","Remarks (Box 16)","Optional - Published ICs can be edited.","Max 256 Characters."]
[null,"ic_attestations","Attestations (Box 16)","Required","Select from Attestation List - Dropdown Menu"]
[null,"ic_certIssuerFullName","Certificate Issuer Full Name (Box 17)","Autofilled from User Profile - Do Not Edit.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,"ic_dateSigned","Date Signed  (Box 18)","Autofilled from Publication Date - Do Not Edit.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]

{"sheet":"Import Certificate","index":1,"n_rows":5,"n_cols":95,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["ic_certNum","ic_certStatus","ic_certifier","ic_isuCbWebSite","ic_isuCbHasAltContact","ic_isuCbContAddLine1","ic_isuCbContAddLine2","ic_isuCbContCity","ic_isuCbContState","ic_isuCbContCountry","ic_isuCbContZip","ic_isuCbContFName","ic_isuCbContLName","ic_isuCbContPhone","ic_isuCbContEmail","ic_program","ic_SingleShipment","ic_startDate","ic_endDate","ic_expCountry","ic_expNOPId","ic_altExpContact","ic_altExpFirstName","ic_altExpLastName","ic_altExpPhNum","ic_altExpEmail","ic_unCertExp","ic_unCertExpOpName","ic_unCertExpAddLine1","ic_unCertExpAddLine2","ic_unCertExpCity","ic_unCertExpState","ic_unCertExpCountry","ic_unCertExpZipPostal","ic_ucExpFirstName","ic_ucExpLastName","ic_ucExpPhNum","ic_ucExpEmail","ic_fhSameExp","ic_fhNopId","ic_fhAltContact","ic_fhAltFirstName","ic_fhAltLastName","ic_fhAltPhNum","ic_fhAltEmail","ic_fhOpName","ic_fhAddLine1","ic_fhAddLine2","ic_fhCity","ic_fhState","ic_fhCountry","ic_fhZip","ic_fhContactFName","ic_fhContactLName","ic_fhContactPhone","ic_fhContactEmail","ic_fhCertBody","ic_fhCBAddLine1","ic_fhCBAddLine2","ic_fhCBCity","ic_fhCBState","ic_fhCBCountry","ic_fhCBZip","ic_fhCBFName","ic_fhCBLName","ic_fhCBPhone","ic_fhCBEmail","ic_recNopId","ic_altRecContact","ic_altRecFirstName","ic_altRecLastName","ic_altRecPhNum","ic_altRecEmail","ic_unCertRec","ic_unCertRecOpName","ic_unCertRecAddLine1","ic_unCertRecAddLine2","ic_unCertRecCity","ic_unCertRecState","ic_unCertRecCountry","ic_unCertRecZipPostal","ic_ucRecFirstName","ic_ucRecLastName","ic_ucRecPhNum","ic_ucRecEmail","ic_product","ic_htsCode","ic_totalWeight","ic_totalContainers","ic_lotNum","ic_productCityState","ic_remarks","ic_attestations","ic_certIssuerFullName","ic_dateSigned"]
["Import Certificate Number (Box 4)\n\n輸入証明書番号","Import Certificate Status","Certifying Body (CB) Issuing Certificate (Box 8)","Issuing CB Website","Issuing CB Alternate Contact Information (Box 8)","Issuing CB Contact Address Line 1 (Box 8)","Issuing CB Contact Address Line 2 (Box 8)","Issuing CB Contact City (Box 8)","Issuing CB Contact State/ Province (Box 8)","Issuing CB Contact Country (Box 8)","Issuing CB Contact ZIP/Postal Code (Box 8)","Issuing CB Contact First Name (Box 8)","Issuing CB Contact Last Name (Box 8)","Issuing CB Contact Phone Number (Box 8)"," Issuing CB Contact Email (Box 8)","Organic Standard Product Certified To (Box 1)\n\n認証有機基準","Single Shipment","Certificate Start Date (Box 3)\n\n認証書開始日\n","Certificate End Date (Box 3)\n\n認証書終了日","Product Exported From (Box 6)\n\n輸出国","Certified Exporter NOP ID (Box 5)\n\n認証済Exporter情報\n","Alternate Certified Exporter Contact Information\n(OID登録内容に代わる認証済Exporter情報W-Z列）\n","Alternate Certified Exporter Contact First Name (Box 5)","Alternate Certified Exporter Contact Last Name (Box 5)","Alternate Certified Exporter Contact Phone Number (Box 5)","Alternate Certified Exporter Contact Email (Box 5)","Uncertified Exporter\n\n認証されていないExporter情報\n","Exporter Operation Name (Box 5)","Exporter Address Line 1 (Box 5)","Exporter Address Line 2 (Box 5)","Exporter City (Box 5)","Exporter State/ Province (Box 5)","Exporter Country (Box 5)","Exporter ZIP/Postal Code (Box 5)","Exporter Contact First Name (Box 5)","Exporter Contact Last Name (Box 5)","Exporter Contact Phone Number (Box 5)","Exporter Contact Email (Box 5)","Final Handler is the same as Exporter","Certified Final Handler NOP ID (Box 14)\n最終取扱者（JAS生産行程管理者・小分け業者）＝申請者の情報","Alternate Final Handler Contact Information\n(OID登録内容に代わる最終取扱者情報AP-AS列）","Alternate Final Handler Contact First Name (Box 14)","Alternate Final Handler Contact Last Name (Box 14)","Alternate Final Handler Contact Phone Number (Box 14)","Alternate Final Handler Contact Email (Box 14)","Final Handler Operation Name (Box 14)","Final Handler Address Line 1 (Box 14)","Final Handler Address Line 2 (Box 14)","Final Handler City (Box 14)","Final Handler State/ Province (Box 14)","Final Handler Country (Box14)","Final Handler ZIP/Postal Code (Box 14)","Final Handler Contact First Name (Box 14)","Final Handler Contact Last Name (Box 14)","Final Handler Contact Phone Number (Box 14)","Final Handler Contact Email (Box 14)","Certifying Body (CB) of Final Handler (Box 15)","Final Handler CB Address Line 1 (Box 15)","Final Handler CB Address Line 2 (Box 15)","Final Handler CB City (Box 15)","Final Handler CB State/Province (Box 15)","Final Handler CB Country (Box 15)","Final Handler CB ZIP/Postal Code (Box 15)","Final Handler CB Contact First Name (Box 15)","Final Handler CB Contact Last Name (Box 15)","Final Handler CB Contact Phone Number (Box 15)","Final Handler CB Contact Email (Box 15)","NOP ID for Certified Recipient in the U.S. (Box 7)\n\n認証済Recipient（輸入業者・受取人）情報","Alternate Certified Recipient Contact Information\n\n(OID登録内容に代わる認証済Recipient情報BR-BU列）","Alternate Certified Recipient Contact First Name (Box 7)","Alternate Certified Recipient Contact Last Name (Box 7)","Alternate Certified Recipient Contact Phone Number (Box 7)","Alternate Certified Recipient Contact Email (Box 7)","Uncertified Recipient (Box 7)\n\n認証されていないRecipient情報","Recipient Operation Name (Box 7)","Recipient Address Line 1 (Box 7)","Recipient Address Line 2 (Box 7)","Recipient City (Box 7)","Recipient State (box 7)","Recipient Country (Box 7)","Recipient ZIP/Postal Code (Box 7)","Recipient Contact First Name (Box 7)","Recipient Contact Last Name (Box 7)","Recipient Phone Number (Box 7)","Recipient Email (Box 7)","Product As Labeled (Box 11)","HTS Code (Box 12)","Total Net Weight (Box 9)","Total Containers (Box 10) ","Shipping Identification - Flight #, Vessel #, Container #, Lot #, etc.  (Box 13) ","City and State of Product Destination (Box 2)","Remarks (Box 16)","Attestations (Box 16)","Certificate Issuer Full Name (Box 17)","Date Signed  (Box 18)"]
["Optional","Autofilled - Do Not Edit","Autofilled from User Profile - Do Not Edit","Autofilled from User Profile - Do Not Edit","Yes as applicable","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Optional for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Required","Yes as applicable","Required","Required - Published ICs can be edited to up to 18 months from Start Date.","Required","Required for Certified Exporters. If Certified, do not complete columns AA-AL.","Yes as applicable","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Yes as applicable","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Optional; Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified.","Required if Uncertified (US). Autofilled if Certified.","Required if Uncertified, Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified.","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Yes as applicable","Required if Final Handler is not same as Certified Exporter (Column AM = No)","Yes as applicable","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled from Final Handler Operation Profile","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Required for Certified Recipients. If Certified, do not complete columns BV-CG.","Yes as applicable","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Yes as applicable","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Optional, Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required","Required","Required - Published ICs can be edited.","Optional - Published ICs can be edited.","Optional - Published ICs can be edited.","Autofilled from Recipient in U.S. - Do Not Edit","Optional - Published ICs can be edited.","Required","Autofilled from User Profile - Do Not Edit.","Autofilled from Publication Date - Do Not Edit."]
["Leave blank for new certificates, enter existing certificate number to edit. Columns S, CJ, CK, CL, CN can be edited.\n\n発行申請の場合は、何も入力しないでください。空白のままにしておいてください。\n\n・発行後の訂正申請の場合は、該当する証明書の番号を入力し、訂正する項目（S, CJ, CK, CL, CN）を訂正してください。","Valid/Invalid. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Certifier Name (ISO 3 Letter Country Code for Program). Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile.  Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Yes/No. Leave columns F-O blank if no Issuing Certifier Satellite Office/Alternate Contact Information is needed.","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office Alternate Information.","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office/User Alternate Information","From Certifier Profile or Satellite Office/User Alternate Information","From Certifier Profile or Satellite Office/User Alternate Information","From Certifier Profile or Satellite Office/User Alternate Information","Select from Organic Standards List\n\nセルをクリックしたら表示される右側に表示される下向き▼をクリックして、ブルダウンメニューを表示させ、Japanese Agricultural Standards (JAS)を選択してください。","Yes/No\n\n\nSingle Shipmentの場合はYesを、Multiple Shipmentsの場合はNoと入力してください。","Date the selected Import Certificate became effective. MM/DD/YYYY\n\nETD(出発予定日）を入力してください。\nMM（月）/DD（日)/YYYYY（年）\n","Date the selected Import Certificate  effective date ended. For single shipment, enter same date as Start Date. MM/DD/YYYY\n\nETA(到着予定日）を入力してください。MM（月）/DD（日)/YYYYY（年）\n","Select from Country List\n\nセルをクリックしたら表示される右側に表示される下向き▼をクリックして、ブルダウンメニューを表示させ、JAPANを選択する。","NOP's 10-digit unique ID for operation. If entered, columns AA-AL  will be ignored.\n\n\n他社が輸出する場合は、何も入力しないでください。V列からZ列まで何も入力しないで、AA列からAL列まで入力してください。","Yes/No. Leave columns W-Z blank if no Alternate Exporter Contact Information is needed.\n\n\n入力しない(空欄のままにしておく）。\n","入力しない(空欄のままにしておく）。","入力しない(空欄のままにしておく）。","入力しない(空欄のままにしておく）。","入力しない(空欄のままにしておく）。","Yes/No. Leave columns AB-AL blank if Certified Exporter NOP Operation ID is entered in Column U.\n\n他社が輸出する場合「Yes」と入力してください。 \nExporterの情報としてAB列からAL列まで必ず入力してください。","Operation's business name. Do not edit if Certified- database does not process this column for Certified Exporters.\n\nExporter会社名\n\n","Do not edit if Certified - database does not process this column for Certified Exporters.\n\nExporter住所1行目（番地など）","Do not edit if Certified - database does not process this column for Certified Exporters.\n\nExporter住所２行目（町名など）","Do not edit if Certified - database does not process this column for Certified Exporters.\n\nExporter住所：市、郡","Do not edit if Certified - database does not process this column for Certified Exporters.\n\nExporter住所：都道府県","Select from Country List.  Do not edit if Certified - database does not process this column for Certified Exporters.\n\n\n\nExporter住所：国名\n「JAPAN」と入力してください。","Do not edit if Certified - database does not process this column for Certified Exporters.\n\n\n\n\nExporter住所：郵便番号","Do not edit if Certified - database does not process this column for Certified Exporters.\n\n\n\n\nExporter連絡先：担当者の名\n（最初の文字は大文字で入力）","Do not edit if Certified - database does not process this column for Certified Exporters.\n\n\n\n\nExporter連絡先：担当者の姓\n（最初の文字は大文字で入力）","Do not edit if Certified - database does not process this column for Certified Exporters.\n\nExporter連絡先：電話番号","Do not edit if Certified - database does not process this column for Certified Exporters.\n\n\n\nExporter連絡先：Eメール","Yes/No. If Yes, do not complete columns AN-BD, and column U must be completed with NOP 10-digit unique ID for Certified Exporter\n\n\n他社が輸出する場合、「No」と入力してください。（輸出者と最終取扱者（生産行程管理者・小分け業者）が異なるので）\n","NOP's 10-digit unique ID for operation. Final Handler must be certified.\n\n\n\n\n自社のNOP ID(10ケタ）を入力してください。\n※NOP IDはGlobal OIDのOperation Profileでご確認ください。","Yes/No. Leave columns AP-AS blank if no Alternate Certified Final Handler Contact Information is needed.\n\n\n「No」と入力してください。AP列からAS列までは何も入力しないでください。\nただし、ICについての連絡先がGlobal OIDに登録された連絡先とは異なる場合は「Yes」と入力し、AP列からAS列まで入力してください。","入力しない（空欄のままにしておく）。","入力しない（空欄のままにしておく）。","入力しない（空欄のままにしておく）。","入力しない（空欄のままにしておく）。","Operation's business name. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Certifier Name (ISO 3 Letter Country Code for Program). Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","NOP's 10-digit unique ID for operation. \n\n受取人Recipient（輸入業者・受取人）がNOP認証されている場合\n輸入業者のNOP ID(10ケタ）を入力してください。\n※必ず輸入業者に確認してください。\n\n\n受取人がNOP認証申請中の場合は、このBP列からBU列まで何も入力しないで（空欄のまま）、BV列に進んでください。","Yes/No. Leave columns BR-BU blank if no Alternate Certified Recipient Contact Information is needed. \n\n受取人RecipientがNOP認証されている場合「No」と入力してください。BR列からBU列までは何も入力しないでください。\nただし、輸入業者がICについての連絡先をOIDに登録された連絡先と変更する場合は「Yes」と入力し、BR列からBU列まで入力してください。","入力しない（空欄のままにしておく）。","入力しない（空欄のままにしておく）。","入力しない（空欄のままにしておく）。","入力しない（空欄のままにしておく）。","Yes/No. Leave columns BW-CG blank if Certified Recipient NOP Operation ID is entered in Column BP.\n\n受取人RecipientがNOP認証されている場合は「No」と入力してください。次のBW列からCG列まで何も入力しないで、CH列に進んでください。\n\n受取人RecipientがNOP認証申請中事業者の場合、「Yes」と入力してください。 Recipientの情報としてBW列からCG列まで必ず入力してください。","Operation's business name. Do not edit if Certified - database does not process this column for Certified Recipients.\n\nRecipient会社名","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient住所1行目（番地など）","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient住所２行目（Streetなど）","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient住所：市、郡","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient住所：州名","Select from Country List.  Do not edit if Certified - database does not process this column for Certified Recipients.\n\nRecipient住所：国名\nセルをクリックしたら表示される右側に表示される下向き▼をクリックして、ブルダウンメニュー（Country List）を表示させ、UNITED STATES OF AMERICA (THE)を選択。","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient住所：郵便番号","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient連絡先：担当者の名（最初の文字は大文字で入力）","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient連絡先：担当者の姓（最初の文字は大文字で入力）","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient連絡先：電話番号（米国の(XXX)XXX-XXXXで入力）","Do not edit if Certified - database does not process this column for Certified Recipients.\n\n\nRecipient連絡先：Eメール","For raw products, enter the common name of the products(s). For packaged products, enter the name shown on the principal display panel (front of the package).\n\n商品名\nHTSコードで同じ分類となる製品の一般的名称を記載してください。（例：Organic Green Tea）。\nコードの製品全体を示す一般的な名称であれば、製品名と同じでも問題ありません。","10-digit HTS Code from https://hts.usitc.gov (do not include punctuation)\n\n\nHTSコード\n（ピリオドを使用せず10ケタの数字で入力してくだい。）","Kilograms (KG) for all shipments.\n\n\n\n合計正味重量(kg)\n＊発行後の編集可能","Integer whole number\n\n\n\n最終包装形態の合計数量\n＊発行後の編集可能","Max 4,000 Characters\n\n輸出船積識別情報\n＊発行後の編集可能\n申請時必須入力項目：\nインボイス番号、インボイスの発行日、製品のロット番号、コンテナ番号等を記入してください。\n\n航空便：フライトNo., AWB No.\n船便：本船名、航海、コンテナ番号、BL No.","Recipient City and State. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Max 256 Characters.\n\n備考欄\n＊発行後の編集可能\n\n※インボイス番号やBL等の輸送手段の情報はここには入力せず、左の「輸出船積識別情報」」に入力すること。\n\nInvoiceの商品名を記載する必要がある場合は、CN列「Remarks」欄に記載することが可能です。","Select from Attestation List\n\n証明内容\nセルをクリックしたら表示される右側に表示される下向き▼をクリックして、ブルダウンメニュー（Attestations List）を表示させ、Certified in compliance with the terms of the U.S.-Japan Organic Equivalence Arrangementを選択。\n","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Japanese Agricultural Standards (JAS)","Yes",null,null,"JAPAN",null,null,null,null,null,null,"Yes",null,null,null,null,null,"JAPAN",null,null,null,null,null,"No",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Certified in compliance with the terms of the U.S.-Japan Organic Equivalence Arrangement"]

{"sheet":"申請書","index":2,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,1],[5,0,5,1],[5,2,5,5],[5,7,5,8],[6,0,6,1],[6,4,6,5],[7,0,7,8],[8,0,8,1],[6,7,6,8],[8,6,8,8],[8,3,8,5],[19,1,19,3],[9,0,9,1],[9,2,9,8],[10,0,11,2],[13,0,13,8],[11,4,11,8],[10,4,10,8],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[20,1,20,3],[24,0,29,3],[24,5,24,6],[24,7,24,8],[25,5,25,6],[25,7,29,8],[27,5,27,6],[29,5,29,6]]}
["Japan Organic and Natural Foods Association"]
["輸入証明書 (Import Certificate)　申請書"]
["Application for Import Certificate based on the U.S. - Japan / the U.S - Canada Organic Equivalence Arrangement"]
["１．申請日と申請者について　（注：製品の最終格付者が申請者になります。自社で格付した製品以外は申請できません。）"]
["申請日(年月日)"]
["申請者(認証事業者)名",null,null,null,null,null,"認証番号"]
["申請担当者名",null,null,"TEL",null,null,"Email"]
["２．輸出方法について"]
["輸出予定日(年月日)",null,null,"同等性の範囲　JASかCORか"]
["輸出手段"]
["受取人についての確認で該当するものにチェックをつけてください。事業者チェック用",null,null,null,"受取人が米国の制度で求められる認証を取得していることを確認した。"]
[null,null,null,"　　","受取人が認証申請中であることを確認した。\n  9月19日までには認証を受けている必要がございます。\n  (免除の対象は米国内の流通等を行う事業者に対してのものであり、輸入業者については必ず認証が必要です。)"]
["３．輸出品の表示の確認"]
["輸出品の表示審査は済んでいますか？（該当するものにチェックを付けてください）"]
[null,"商品名（証明書に記載する名称）",null,null,"a. 済み","b. 申請中","a:確認日/b:申請日\n(年月日)","aおよびbの場合：\n外国格付表示の有無","c. 輸入業者が現地の表示を確認済み"]
[1]
[2]
[3]
[4]
[5]
[6]
["※足りない場合は行を増やして入力してください。"]
[]
["４．必須添付書類"]
["取引が確認できる書類（インボイス、パッキングリスト、B/L等輸送手段が特定できる書類など）\n（添付するものにチェックをつけてください。その他の書類は具体的に書類名を記載してください。）",null,null,null,"添付","書類",null,"備考欄"]
[null,null,null,null,null,"インボイス"]
[null,null,null,null,null,"パッキングリスト"]
[null,null,null,null,null,"B/L、AWB"]
[null,null,null,null,null,"国際宅配便発送伝票"]
[null,null,null,null,null,"その他"]
[]
["注意：製品は出荷されたのちも、有機性を保つように取扱われるよう注意してください。"]
["★左のImport Certificateのシートに輸出品に関する詳細を入力してください。"]
[]
["JONA事務局　様式22-2　米国電子証明書申請書_他社輸出用　2024.2.22発効 2024.3.29改訂,2024.7.26改訂"]

{"sheet":"VBAHelper","index":3,"n_rows":250,"n_cols":6,"rows_kept":250,"cut":false,"hidden":true,"merged":[]}
["Countries","US States",null,"Program Name on Certifier and Operation Profile --> Organic Standard",null,"Attestation Statement for Import Certificate"]
["UNITED STATES OF AMERICA (THE)","Alabama",null,"USDA-NOP (U.S.A.)",null,"N/A"]
["ÅLAND ISLANDS","Alaska",null,"Canada Organic Regime (COR)",null,"Certified in compliance with the terms of the U.S.-Canada Organic Equivalency Arrangement"]
["AFGHANISTAN","American Samoa",null,"European Organic Regulations",null,"Certified in compliance with the terms of the U.S.-European Union Organic Equivalence Arrangement"]
["ALBANIA","Arizona",null,"Japanese Agricultural Standards (JAS)",null,"Certified in compliance with the terms of the U.S.-Japan Organic Equivalence Arrangement"]
["ALGERIA","Arkansas",null,"Korean Food Act",null,"Certified in compliance with the terms of the U.S.-Korea Organic Equivalency Arrangement"]
["AMERICAN SAMOA","California",null,"Swiss Organic Ordinance",null,"Certified in compliance with the terms of the U.S.-Switzerland Organic Equivalence Arrangement"]
["ANDORRA","Colorado",null,"Taiwan Organic Regulations",null,"Certified in compliance with the terms of the AIT/TECRO-NOP/AFA Organic Equivalence Arrangement"]
["ANGOLA","Connecticut",null,"UK Organic Standards",null,"Certified in compliance with the terms of the U.S.-U.K. Organic Equivalence Arrangement"]
["ANGUILLA","Delaware",null,"USDA-NOP (Israel Recognition)"]
["ANTARCTICA","District of Columbia",null,"USDA-NOP (New Zealand Recognition)"]
["ANTIGUA AND BARBUDA","Federated States of Micronesia"]
["ARGENTINA","Florida"]
["ARMENIA","Georgia"]
["ARUBA","Guam"]
["AUSTRALIA","Hawaii"]
["AUSTRIA","Idaho"]
["AZERBAIJAN","Illinois"]
["BAHAMAS (THE)","Indiana"]
["BAHRAIN","Iowa"]
["BANGLADESH","Kansas"]
["BARBADOS","Kentucky"]
["BELARUS","Louisiana"]
["BELGIUM","Maine"]
["BELIZE","Maryland"]
["BENIN","Massachusetts"]
["BERMUDA","Michigan"]
["BHUTAN","Midway Islands"]
["BOLIVIA (PLURINATIONAL STATE OF)","Minnesota"]
["BONAIRE, SINT EUSTATIUS AND SABA","Mississippi"]
["BOSNIA AND HERZEGOVINA","Missouri"]
["BOTSWANA","Montana"]
["BOUVET ISLAND","Nebraska"]
["BRAZIL","Nevada"]
["BRITISH INDIAN OCEAN TERRITORY (THE)","New Hampshire"]
["BRUNEI DARUSSALAM","New Jersey"]
["BULGARIA","New Mexico"]
["BURKINA FASO","New York"]
["BURUNDI","North Carolina"]
["CABO VERDE","North Dakota"]
["CAMBODIA","Northern Mariana Islands"]
["CAMEROON","Ohio"]
["CANADA","Oklahoma"]
["CAYMAN ISLANDS (THE)","Oregon"]
["CENTRAL AFRICAN REPUBLIC (THE)","Pennsylvania"]
["CHAD","Puerto Rico"]
["CHILE","Rhode Island"]
["CHINA","South Carolina"]
["CHRISTMAS ISLAND","South Dakota"]
["COCOS (KEELING) ISLANDS (THE)","Tennessee"]
["COLOMBIA","Texas"]
["COMOROS (THE)","Utah"]
["CONGO (THE DEMOCRATIC REPUBLIC OF THE)","Vermont"]
["CONGO (THE)","Virgin Islands"]
["COOK ISLANDS (THE)","Virginia"]
["COSTA RICA","Washington"]
["CÔTE D'IVOIRE","West Virginia"]
["CROATIA","Wisconsin"]
["CUBA","Wyoming"]
["CURAÇAO"]
["CYPRUS"]
["CZECH REPUBLIC (THE)"]
["DENMARK"]
["DJIBOUTI"]
["DOMINICA"]
["DOMINICAN REPUBLIC (THE)"]
["ECUADOR"]
["EGYPT"]
["EL SALVADOR"]
["EQUATORIAL GUINEA"]
["ERITREA"]
["ESTONIA"]
["ETHIOPIA"]
["FALKLAND ISLANDS (THE) [MALVINAS]"]
["FAROE ISLANDS (THE)"]
["FIJI"]
["FINLAND"]
["FRANCE"]
["FRENCH GUIANA"]
["FRENCH POLYNESIA"]
["FRENCH SOUTHERN TERRITORIES (THE)"]
["GABON"]
["GAMBIA (THE)"]
["GEORGIA"]
["GERMANY"]
["GHANA"]
["GIBRALTAR"]
["GREECE"]
["GREENLAND"]
["GRENADA"]
["GUADELOUPE"]
["GUAM"]
["GUATEMALA"]
["GUERNSEY"]
["GUINEA"]
["GUINEA-BISSAU"]
["GUYANA"]
["HAITI"]
["HEARD ISLAND AND MCDONALD ISLANDS"]
["HOLY SEE (THE)"]
["HONDURAS"]
["HONG KONG"]
["HUNGARY"]
["ICELAND"]
["INDIA"]
["INDONESIA"]
["IRAN (ISLAMIC REPUBLIC OF)"]
["IRAQ"]
["IRELAND"]
["ISLE OF MAN"]
["ISRAEL"]
["ITALY"]
["JAMAICA"]
["JAPAN"]
["JERSEY"]
["JORDAN"]
["KAZAKHSTAN"]
["KENYA"]
["KIRIBATI"]
["KOREA (THE DEMOCRATIC PEOPLE'S REPUBLIC OF)"]
["KOREA (THE REPUBLIC OF)"]
["KUWAIT"]
["KYRGYZSTAN"]
["LAO PEOPLE'S DEMOCRATIC REPUBLIC (THE)"]
["LATVIA"]
["LEBANON"]
["LESOTHO"]
["LIBERIA"]
["LIBYA"]
["LIECHTENSTEIN"]
["LITHUANIA"]
["LUXEMBOURG"]
["MACAO"]
["MADAGASCAR"]
["MALAWI"]
["MALAYSIA"]
["MALDIVES"]
["MALI"]
["MALTA"]
["MARSHALL ISLANDS (THE)"]
["MARTINIQUE"]
["MAURITANIA"]
["MAURITIUS"]
["MAYOTTE"]
["MEXICO"]
["MICRONESIA (FEDERATED STATES OF)"]
["MOLDOVA (THE REPUBLIC OF)"]
["MONACO"]
["MONGOLIA"]
["MONTENEGRO"]
["MONTSERRAT"]
["MOROCCO"]
["MOZAMBIQUE"]
["MYANMAR"]
["NAMIBIA"]
["NAURU"]
["NEPAL"]
["NETHERLANDS (THE)"]
["NEW CALEDONIA"]
["NEW ZEALAND"]
["NICARAGUA"]
["NIGER (THE)"]
["NIGERIA"]
["NIUE"]
["NORFOLK ISLAND"]
["NORTH MACEDONIA"]
["NORTHERN MARIANA ISLANDS (THE)"]
["NORWAY"]
["OMAN"]
["PAKISTAN"]
["PALAU"]
["PALESTINE, STATE OF"]
["PANAMA"]
["PAPUA NEW GUINEA"]
["PARAGUAY"]
["PERU"]
["PHILIPPINES (THE)"]
["PITCAIRN"]
["POLAND"]
["PORTUGAL"]
["PUERTO RICO"]
["QATAR"]
["RÉUNION"]
["ROMANIA"]
["RUSSIAN FEDERATION (THE)"]
["RWANDA"]
["SAINT BARTHÉLEMY"]
["SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA"]
["SAINT KITTS AND NEVIS"]
["SAINT LUCIA"]
["SAINT MARTIN (FRENCH PART)"]
["SAINT PIERRE AND MIQUELON"]
["SAINT VINCENT AND THE GRENADINES"]
["SAMOA"]
["SAN MARINO"]
["SAO TOME AND PRINCIPE"]
["SAUDI ARABIA"]
["SENEGAL"]
["SERBIA"]
["SEYCHELLES"]
["SIERRA LEONE"]
["SINGAPORE"]
["SINT MAARTEN (DUTCH PART)"]
["SLOVAKIA"]
["SLOVENIA"]
["SOLOMON ISLANDS"]
["SOMALIA"]
["SOUTH AFRICA"]
["SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS"]
["SOUTH SUDAN"]
["SPAIN"]
["SRI LANKA"]
["SUDAN (THE)"]
["SURINAME"]
["SVALBARD AND JAN MAYEN"]
["SWAZILAND"]
["SWEDEN"]
["SWITZERLAND"]
["SYRIAN ARAB REPUBLIC"]
["TAIWAN"]
["TAJIKISTAN"]
["TANZANIA, UNITED REPUBLIC OF"]
["THAILAND"]
["TIMOR-LESTE"]
["TOGO"]
["TOKELAU"]
["TONGA"]
["TRINIDAD AND TOBAGO"]
["TUNISIA"]
["TURKEY"]
["TURKMENISTAN"]
["TURKS AND CAICOS ISLANDS (THE)"]
["TUVALU"]
["UGANDA"]
["UKRAINE"]
["UNITED ARAB EMIRATES (THE)"]
["UNITED KINGDOM OF GREAT BRITAIN AND NORTHERN IRELAND (THE)"]
["UNITED STATES MINOR OUTLYING ISLANDS (THE)"]
["URUGUAY"]
["UZBEKISTAN"]
["VANUATU"]
["VENEZUELA (BOLIVARIAN REPUBLIC OF)"]
["VIET NAM"]
["VIRGIN ISLANDS (BRITISH)"]
["VIRGIN ISLANDS (U.S.)"]
["WALLIS AND FUTUNA"]
["WESTERN SAHARA*"]
["YEMEN"]
["ZAMBIA"]
["ZIMBABWE"]