{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Instructions","CountryCodes","Issues"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Data","index":0,"n_rows":1,"n_cols":82,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Account Number","Employee Type","User ID","Generate Login Information","Hierarchy ID","Status","Reason","Prefix","First Name on Card","Middle Initial","Last Name on Card","Suffix","Second Row of Embossing","Date of Birth","SSN/SIN/Tax ID","Mother's Maiden Name","Cardholder Address Line 1","Address Line 2","City","State/Province","ZIP/Postal Code","Country","Statement Address Line 1","Address Line 2","City","State/Province","ZIP/Postal Code","Country","E-Mail Address","Business Phone","Mobile Phone","Custom Field 1|Custom Field 2|Custom Field 3","Notes","Employee ID","Cost Center","VIP","International","Credit Limit","Cash Advance Limit","Monthly Transaction Limit","Monthly Amount Limit","Cycle Transaction Limit","Cycle Amount Limit","Daily Amount Limit","Daily Transaction Limit","Single Amount Limit","Other Transaction Limit","Other Amount Limit","Other Number of Days","Other Refresh Date","MCC Group 1","MCC Group Action 1","MCC Group 2","MCC Group Action 2","MCC Group 3","MCC Group Action 3","MCC Group 4","MCC Group Action 4","MCC Group 5","MCC Group Action 5","MCC Group 6","MCC Group Action 6","MCC Group 7","MCC Group Action 7","MCC Group 8","MCC Group Action 8","MCC Group 9","MCC Group Action 9","Rush Card Delivery","Card Delivery","Full First Name","Full Last Name","Country of Citizenship","Primary Home Address 1","Primary Home Address 2","Primary Home Address City","Primary Home Address State/Province","Primary Home Address Zip/Postal Code","Primary Home Address Country","Type of Account"," Add/Update","Blank Override"]

{"sheet":"Instructions","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["This file is a template file for the Account Import feature. This file should be used to import accounts with custom fields. The File Layout Requirements can be located in the PaymentNet Help."]
[]
["Instructions:"]
["1. Fill out the required fields and click the Validate button."]
["2. A pop-up box will appear to indicate whether errors were found or validation passed with no errors."]
["3. If errors were identified, a new tab will appear showing all the errors."]
["4. Correct all errors and click the Validate button again."]
["5. Once validation passes with no errors, the file is ready to be uploaded to PaymentNet. The format will need to follow the requirements indicated in the PaymentNet Help."]
[]
["*Note: Please refer to the help topics Configuring an Import File and General Import File Tips for information about how to format and save the data to be imported."]

{"sheet":"CountryCodes","index":2,"n_rows":250,"n_cols":2,"rows_kept":250,"cut":false,"hidden":true,"merged":[]}
["Alpha-3 code","Country"]
["AFG","Afghanistan"]
["ALB","Albania"]
["DZA","Algeria"]
["ASM","American Samoa"]
["AND","Andorra"]
["AGO","Angola"]
["AIA","Anguilla"]
["ATA","Antarctica"]
["ATG","Antigua and Barbuda"]
["ARG","Argentina"]
["ARM","Armenia"]
["ABW","Aruba"]
["AUS","Australia"]
["AUT","Austria"]
["AZE","Azerbaijan"]
["BHS","Bahamas (the)"]
["BHR","Bahrain"]
["BGD","Bangladesh"]
["BRB","Barbados"]
["BLR","Belarus"]
["BEL","Belgium"]
["BLZ","Belize"]
["BEN","Benin"]
["BMU","Bermuda"]
["BTN","Bhutan"]
["BOL","Bolivia (Plurinational State of)"]
["BES","Bonaire, Sint Eustatius and Saba"]
["BIH","Bosnia and Herzegovina"]
["BWA","Botswana"]
["BVT","Bouvet Island"]
["BRA","Brazil"]
["IOT","British Indian Ocean Territory (the)"]
["BRN","Brunei Darussalam"]
["BGR","Bulgaria"]
["BFA","Burkina Faso"]
["BDI","Burundi"]
["CPV","Cabo Verde"]
["KHM","Cambodia"]
["CMR","Cameroon"]
["CAN","Canada"]
["CYM","Cayman Islands (the)"]
["CAF","Central African Republic (the)"]
["TCD","Chad"]
["CHL","Chile"]
["CHN","China"]
["CXR","Christmas Island"]
["CCK","Cocos (Keeling) Islands (the)"]
["COL","Colombia"]
["COM","Comoros (the)"]
["COD","Congo (the Democratic Republic of the)"]
["COG","Congo (the)"]
["COK","Cook Islands (the)"]
["CRI","Costa Rica"]
["HRV","Croatia"]
["CUB","Cuba"]
["CUW","Curaçao"]
["CYP","Cyprus"]
["CZE","Czechia"]
["CIV","Côte d'Ivoire"]
["DNK","Denmark"]
["DJI","Djibouti"]
["DMA","Dominica"]
["DOM","Dominican Republic (the)"]
["ECU","Ecuador"]
["EGY","Egypt"]
["SLV","El Salvador"]
["GNQ","Equatorial Guinea"]
["ERI","Eritrea"]
["EST","Estonia"]
["SWZ","Eswatini"]
["ETH","Ethiopia"]
["FLK","Falkland Islands (the) [Malvinas]"]
["FRO","Faroe Islands (the)"]
["FJI","Fiji"]
["FIN","Finland"]
["FRA","France"]
["GUF","French Guiana"]
["PYF","French Polynesia"]
["ATF","French Southern Territories (the)"]
["GAB","Gabon"]
["GMB","Gambia (the)"]
["GEO","Georgia"]
["DEU","Germany"]
["GHA","Ghana"]
["GIB","Gibraltar"]
["GRC","Greece"]
["GRL","Greenland"]
["GRD","Grenada"]
["GLP","Guadeloupe"]
["GUM","Guam"]
["GTM","Guatemala"]
["GGY","Guernsey"]
["GIN","Guinea"]
["GNB","Guinea-Bissau"]
["GUY","Guyana"]
["HTI","Haiti"]
["HMD","Heard Island and McDonald Islands"]
["VAT","Holy See (the)"]
["HND","Honduras"]
["HKG","Hong Kong"]
["HUN","Hungary"]
["ISL","Iceland"]
["IND","India"]
["IDN","Indonesia"]
["IRN","Iran (Islamic Republic of)"]
["IRQ","Iraq"]
["IRL","Ireland"]
["IMN","Isle of Man"]
["ISR","Israel"]
["ITA","Italy"]
["JAM","Jamaica"]
["JPN","Japan"]
["JEY","Jersey"]
["JOR","Jordan"]
["KAZ","Kazakhstan"]
["KEN","Kenya"]
["KIR","Kiribati"]
["PRK","Korea (the Democratic People's Republic of)"]
["KOR","Korea (the Republic of)"]
["KWT","Kuwait"]
["KGZ","Kyrgyzstan"]
["LAO","Lao People's Democratic Republic (the)"]
["LVA","Latvia"]
["LBN","Lebanon"]
["LSO","Lesotho"]
["LBR","Liberia"]
["LBY","Libya"]
["LIE","Liechtenstein"]
["LTU","Lithuania"]
["LUX","Luxembourg"]
["MAC","Macao"]
["MDG","Madagascar"]
["MWI","Malawi"]
["MYS","Malaysia"]
["MDV","Maldives"]
["MLI","Mali"]
["MLT","Malta"]
["MHL","Marshall Islands (the)"]
["MTQ","Martinique"]
["MRT","Mauritania"]
["MUS","Mauritius"]
["MYT","Mayotte"]
["MEX","Mexico"]
["FSM","Micronesia (Federated States of)"]
["MDA","Moldova (the Republic of)"]
["MCO","Monaco"]
["MNG","Mongolia"]
["MNE","Montenegro"]
["MSR","Montserrat"]
["MAR","Morocco"]
["MOZ","Mozambique"]
["MMR","Myanmar"]
["NAM","Namibia"]
["NRU","Nauru"]
["NPL","Nepal"]
["NLD","Netherlands (the)"]
["NCL","New Caledonia"]
["NZL","New Zealand"]
["NIC","Nicaragua"]
["NER","Niger (the)"]
["NGA","Nigeria"]
["NIU","Niue"]
["NFK","Norfolk Island"]
["MNP","Northern Mariana Islands (the)"]
["NOR","Norway"]
["OMN","Oman"]
["PAK","Pakistan"]
["PLW","Palau"]
["PSE","Palestine, State of"]
["PAN","Panama"]
["PNG","Papua New Guinea"]
["PRY","Paraguay"]
["PER","Peru"]
["PHL","Philippines (the)"]
["PCN","Pitcairn"]
["POL","Poland"]
["PRT","Portugal"]
["PRI","Puerto Rico"]
["QAT","Qatar"]
["MKD","Republic of North Macedonia"]
["ROU","Romania"]
["RUS","Russian Federation (the)"]
["RWA","Rwanda"]
["REU","Réunion"]
["BLM","Saint Barthélemy"]
["SHN","Saint Helena, Ascension and Tristan da Cunha"]
["KNA","Saint Kitts and Nevis"]
["LCA","Saint Lucia"]
["MAF","Saint Martin (French part)"]
["SPM","Saint Pierre and Miquelon"]
["VCT","Saint Vincent and the Grenadines"]
["WSM","Samoa"]
["SMR","San Marino"]
["STP","Sao Tome and Principe"]
["SAU","Saudi Arabia"]
["SEN","Senegal"]
["SRB","Serbia"]
["SYC","Seychelles"]
["SLE","Sierra Leone"]
["SGP","Singapore"]
["SXM","Sint Maarten (Dutch part)"]
["SVK","Slovakia"]
["SVN","Slovenia"]
["SLB","Solomon Islands"]
["SOM","Somalia"]
["ZAF","South Africa"]
["SGS","South Georgia and the South Sandwich Islands"]
["SSD","South Sudan"]
["ESP","Spain"]
["LKA","Sri Lanka"]
["SDN","Sudan (the)"]
["SUR","Suriname"]
["SJM","Svalbard and Jan Mayen"]
["SWE","Sweden"]
["CHE","Switzerland"]
["SYR","Syrian Arab Republic"]
["TWN","Taiwan (Province of China)"]
["TJK","Tajikistan"]
["TZA","Tanzania, United Republic of"]
["THA","Thailand"]
["TLS","Timor-Leste"]
["TGO","Togo"]
["TKL","Tokelau"]
["TON","Tonga"]
["TTO","Trinidad and Tobago"]
["TUN","Tunisia"]
["TUR","Turkey"]
["TKM","Turkmenistan"]
["TCA","Turks and Caicos Islands (the)"]
["TUV","Tuvalu"]
["UGA","Uganda"]
["UKR","Ukraine"]
["ARE","United Arab Emirates (the)"]
["GBR","United Kingdom of Great Britain and Northern Ireland (the)"]
["UMI","United States Minor Outlying Islands (the)"]
["USA","United States of America (the)"]
["URY","Uruguay"]
["UZB","Uzbekistan"]
["VUT","Vanuatu"]
["VEN","Venezuela (Bolivarian Republic of)"]
["VNM","Viet Nam"]
["VGB","Virgin Islands (British)"]
["VIR","Virgin Islands (U.S.)"]
["WLF","Wallis and Futuna"]
["ESH","Western Sahara"]
["YEM","Yemen"]
["ZMB","Zambia"]
["ZWE","Zimbabwe"]
["ALA","Åland Islands"]

{"sheet":"Issues","index":3,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Issues found on the 'Validate Data' tab that must be corrected to complete submission\r\n\r\nYou may delete these rows as you complete them.  This tab will be rebuilt with each Validation check if issues are found."]
["Column","Row","Issue"]
["First Name on Card (Col I)",2,"Illegal characters entered in [First Name on Card].  Can't use these characters (shown between the '~'s)(a space is for a space character being illegal) ~1234567890~"]
["Last Name on Card (Col K)",2,"Illegal characters entered in [Last Name on Card].  Can't use these characters (shown between the '~'s)(a space is for a space character being illegal) ~34567890~"]