{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ASN Data","Sample ASN template","Country of Origin codes","Freight Carrier Codes","UOM"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"ASN Data","index":0,"n_rows":4,"n_cols":67,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Document Type","ASN"]
["HEADER_SECTION","Shipment Number*","Shipment Date*","Expected Receipt Date*","Bill of Lading","Packing Slip*","Freight Carrier Code","Number of Containers","Waybill Number","Gross weight UOM","Gross weight","Net weight UOM","Net weight","Tar weight UOM","Tar weight","Packing Code","Carrier Method","Special Handling Code","Hazard Code","Hazard Class","Freight Terms","Comments","Attribute Category","Ship From Location","Attribute1","Attribute2","Attribute3","Attribute4","Attribute5","Attribute6","Attribute7","Attribute8","Attribute9","Attribute10","Attribute11","Attribute12","Attribute13","Attribute14","Attribute15"]
[]
["LINE_SECTION","Organization*","PO Number*","Revision Number*","Release Number","Line Number*","PO Shipment Number*","Quantity*","UOM*","Bill of Lading","Packing Slip*","Number of Containers","Waybill Number","Barcode Label","Country of Origin*","Container Number","Truck Number","Vendor Lot","Comments","Attribute Category","Attribute1","Attribute2","Attribute3","Attribute4","Attribute5","Attribute6","Attribute7","Attribute8","Attribute9","Attribute10","Attribute11","Attribute12","Attribute13","Attribute14","Attribute15","Shipment Header Attribute Category","Shipment Header Attribute1","Shipment Header Attribute2","Shipment Header Attribute3","Shipment Header Attribute4","Shipment Header Attribute5","Shipment Header Attribute6","Shipment Header Attribute7","Shipment Header Attribute8","Shipment Header Attribute9","Shipment Header Attribute10","Shipment Header Attribute11","Shipment Header Attribute12","Shipment Header Attribute13","Shipment Header Attribute14","Shipment Header Attribute15","Shipment Line Attribute Category","Shipment Line Attribute1","Shipment Line Attribute2","Shipment Line Attribute3","Shipment Line Attribute4","Shipment Line Attribute5","Shipment Line Attribute6","Shipment Line Attribute7","Shipment Line Attribute8","Shipment Line Attribute9","Shipment Line Attribute10","Shipment Line Attribute11","Shipment Line Attribute12","Shipment Line Attribute13","Shipment Line Attribute14","Shipment Line Attribute15"]

{"sheet":"Sample ASN template","index":1,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Document Type","ASN"]
["HEADER_SECTION","Shipment Number*","Shipment Date*","Expected Receipt Date*","Bill of Lading","Packing Slip*","Freight Carrier Code","Number of Containers","Waybill Number","Gross weight UOM","Gross weight","Net weight UOM","Net weight","Tar weight UOM","Tar weight"]
[null,"NewTemplate123","2017-10-11","2017-10-15",null,"NewTemplate123","BWA",null,"AWB555"]
["LINE_SECTION","Organization*","PO Number*","Revision Number*","Release Number","Line Number*","PO Shipment Number*","Quantity*","UOM*","Bill of Lading","Packing Slip*","Number of Containers","Waybill Number","Barcode Label","Country of Origin*"]
[null,"US_100000","AF95056927",1,null,1,2,5,"EACH",null,"NewTemplate123",null,null,null,"MY"]
[]
[]
["You can create Multiple ASN Shipment Numbers - Copy the rows above down as many times as needed"]
["**This is a Sample Template, no Macro is build into this Tab to auto default values."]
["Document Type","ASN"]
["HEADER_SECTION","Shipment Number*","Shipment Date*","Expected Receipt Date*","Bill of Lading","Packing Slip*","Freight Carrier Code","Number of Containers","Waybill Number","Gross weight UOM","Gross weight","Net weight UOM","Net weight","Tar weight UOM","Tar weight"]
[null,"NewTemplate123","2017-10-11","2017-10-15",null,"NewTemplate123","BWA",null,"AWB555"]
["LINE_SECTION","Organization*","PO Number*","Revision Number*","Release Number","Line Number*","PO Shipment Number*","Quantity*","UOM*","Bill of Lading","Packing Slip*","Number of Containers","Waybill Number","Barcode Label","Country of Origin*"]
[null,"US_100000","AF95056927",1,null,1,2,5,"EACH",null,"NewTemplate123",null,null,null,"MY"]
["HEADER_SECTION","Shipment Number*","Shipment Date*","Expected Receipt Date*","Bill of Lading","Packing Slip*","Freight Carrier Code","Number of Containers","Waybill Number","Gross weight UOM","Gross weight","Net weight UOM","Net weight","Tar weight UOM","Tar weight"]
[null,"NewTemplate456","2017-10-11","2017-10-15",null,"NewTemplate456","BWA",null,"AWB555"]
["LINE_SECTION","Organization*","PO Number*","Revision Number*","Release Number","Line Number*","PO Shipment Number*","Quantity*","UOM*","Bill of Lading","Packing Slip*","Number of Containers","Waybill Number","Barcode Label","Country of Origin*"]
[null,"US_100000","AF95056928",1,null,1,1,10,"EACH",null,"NewTemplate456",null,null,null,"MY"]

{"sheet":"Country of Origin codes","index":2,"n_rows":258,"n_cols":5,"rows_kept":258,"cut":false,"hidden":false,"merged":[]}
["COO_Code","Country"]
["AF","Afghanistan"]
["AX","Aland Islands",null,null,"** Use COO Code (Column A) for Template Update"]
["AL","Albania"]
["DZ","Algeria"]
["AS","American Samoa"]
["AD","Andorra"]
["AO","Angola"]
["AI","Anguilla"]
["AQ","Antarctica"]
["AG","Antigua and Barbuda"]
["AR","Argentina"]
["AM","Armenia"]
["AW","Aruba"]
["AU","Australia"]
["AT","Austria"]
["AZ","Azerbaijan"]
["BS","Bahamas"]
["BH","Bahrain"]
["BD","Bangladesh"]
["BB","Barbados"]
["BY","Belarus"]
["BE","Belgium"]
["BZ","Belize"]
["BJ","Benin"]
["BM","Bermuda"]
["BT","Bhutan"]
["BO","Bolivia, Plurinational State of"]
["BQ","Bonaire, Sint Eustatius and Saba"]
["BA","Bosnia and Herzegovina"]
["BW","Botswana"]
["BV","Bouvet Island"]
["BR","Brazil"]
["IO","British Indian Ocean Territory"]
["BN","Brunei Darussalam"]
["BG","Bulgaria"]
["BF","Burkina Faso"]
["BI","Burundi"]
["CV","Cabo Verde"]
["KH","Cambodia"]
["CM","Cameroon"]
["CA","Canada"]
["KY","Cayman Islands"]
["CF","Central African Republic"]
["TD","Chad"]
["CL","Chile"]
["CN","China"]
["CX","Christmas Island"]
["CC","Cocos (Keeling) Islands"]
["CO","Colombia"]
["KM","Comoros"]
["CG","Congo"]
["CD","Congo, The Democratic Republic of the"]
["CK","Cook Islands"]
["CR","Costa Rica"]
["CI","Cote d'Ivoire"]
["HR","Croatia"]
["CU","Cuba"]
["CW","Curacao"]
["CY","Cyprus"]
["CZ","Czech Republic"]
["DK","Denmark"]
["DJ","Djibouti"]
["DM","Dominica"]
["DO","Dominican Republic"]
["EC","Ecuador"]
["EG","Egypt"]
["SV","El Salvador"]
["GQ","Equatorial Guinea"]
["ER","Eritrea"]
["EE","Estonia"]
["ET","Ethiopia"]
["FK","Falkland Islands (Malvinas)"]
["FO","Faroe Islands"]
["FJ","Fiji"]
["FI","Finland"]
["FR","France"]
["GF","French Guiana"]
["PF","French Polynesia"]
["TF","French Southern Territories"]
["GA","Gabon"]
["GM","Gambia"]
["GE","Georgia"]
["DE","Germany"]
["GH","Ghana"]
["GI","Gibraltar"]
["GR","Greece"]
["GL","Greenland"]
["GD","Grenada"]
["GP","Guadeloupe"]
["GU","Guam"]
["GT","Guatemala"]
["GG","Guernsey"]
["GN","Guinea"]
["GW","Guinea-Bissau"]
["GY","Guyana"]
["HT","Haiti"]
["HM","Heard Island and McDonald Islands"]
["VA","Holy See (Vatican City State)"]
["HN","Honduras"]
["HK","Hong Kong"]
["HU","Hungary"]
["IS","Iceland"]
["IN","India"]
["ID","Indonesia"]
["IR","Iran, Islamic Republic of"]
["IQ","Iraq"]
["IE","Ireland"]
["IM","Isle of Man"]
["IL","Israel"]
["IT","Italy"]
["JM","Jamaica"]
["JP","Japan"]
["JE","Jersey"]
["JO","Jordan"]
["KZ","Kazakhstan"]
["KE","Kenya"]
["KI","Kiribati"]
["KP","Korea, Democratic People's Republic of"]
["KR","Korea, Republic of"]
["XK","Kosovo"]
["KW","Kuwait"]
["KG","Kyrgyzstan"]
["LA","Lao People's Democratic Republic"]
["LV","Latvia"]
["LB","Lebanon"]
["LS","Lesotho"]
["LR","Liberia"]
["LY","Libya"]
["LI","Liechtenstein"]
["LT","Lithuania"]
["LU","Luxembourg"]
["MO","Macao"]
["MK","Macedonia, The Former Yugoslav Republic of"]
["MG","Madagascar"]
["MW","Malawi"]
["MY","Malaysia"]
["MV","Maldives"]
["ML","Mali"]
["MT","Malta"]
["MH","Marshall Islands"]
["MQ","Martinique"]
["MR","Mauritania"]
["MU","Mauritius"]
["YT","Mayotte"]
["MX","Mexico"]
["FM","Micronesia, Federated States of"]
["MD","Moldova, Republic of"]
["MC","Monaco"]
["MN","Mongolia"]
["ME","Montenegro"]
["MS","Montserrat"]
["MA","Morocco"]
["MZ","Mozambique"]
["MM","Myanmar"]
["NA","Namibia"]
["NR","Nauru"]
["NP","Nepal"]
["NL","Netherlands"]
["NC","New Caledonia"]
["NZ","New Zealand"]
["NI","Nicaragua"]
["NE","Niger"]
["NG","Nigeria"]
["NU","Niue"]
["NF","Norfolk Island"]
["MP","Northern Mariana Islands"]
["NO","Norway"]
["ZR","Obsolete see CD territory"]
["YU","Obsolete see CS territory"]
["FX","Obsolete see FR territory"]
["LX","Obsolete see LT territory"]
["AN","Obsolete see NL territory"]
["CS","Obsolete see RS or ME territory"]
["TP","Obsolete see TL territory"]
["OM","Oman"]
["PK","Pakistan"]
["PW","Palau"]
["PS","Palestine, State of"]
["PA","Panama"]
["PG","Papua New Guinea"]
["PY","Paraguay"]
["PE","Peru"]
["PH","Philippines"]
["PN","Pitcairn"]
["PL","Poland"]
["PT","Portugal"]
["PR","Puerto Rico"]
["QA","Qatar"]
["RE","Reunion"]
["RO","Romania"]
["RU","Russian Federation"]
["RW","Rwanda"]
["BL","Saint Barthelemy"]
["SH","Saint Helena, Ascension and Tristan da Cunha"]
["KN","Saint Kitts and Nevis"]
["LC","Saint Lucia"]
["MF","Saint Martin (French part)"]
["PM","Saint Pierre and Miquelon"]
["VC","Saint Vincent and the Grenadines"]
["WS","Samoa"]
["SM","San Marino"]
["ST","Sao Tome and Principe"]
["SA","Saudi Arabia"]
["SN","Senegal"]
["RS","Serbia"]
["SC","Seychelles"]
["SL","Sierra Leone"]
["SG","Singapore"]
["SX","Sint Maarten (Dutch part)"]
["SK","Slovakia"]
["SI","Slovenia"]
["SB","Solomon Islands"]
["SO","Somalia"]
["ZA","South Africa"]
["GS","South Georgia and the South Sandwich Islands"]
["SS","South Sudan"]
["ES","Spain"]
["LK","Sri Lanka"]
["SD","Sudan"]
["SR","Suriname"]
["SJ","Svalbard and Jan Mayen"]
["SZ","Swaziland"]
["SE","Sweden"]
["CH","Switzerland"]
["SY","Syrian Arab Republic"]
["TW","Taiwan"]
["TJ","Tajikistan"]
["TZ","Tanzania, United Republic of"]
["TH","Thailand"]
["TL","Timor-Leste"]
["TG","Togo"]
["TK","Tokelau"]
["TO","Tonga"]
["TT","Trinidad and Tobago"]
["TN","Tunisia"]
["TR","Turkey"]
["TM","Turkmenistan"]
["TC","Turks and Caicos Islands"]
["TV","Tuvalu"]
["UG","Uganda"]
["UA","Ukraine"]
["AE","United Arab Emirates"]
["GB","United Kingdom"]
["US","United States"]
["UM","United States Minor Outlying Islands"]
["UY","Uruguay"]
["UZ","Uzbekistan"]
["VU","Vanuatu"]
["VE","Venezuela, Bolivarian Republic of"]
["VN","Viet Nam"]
["VG","Virgin Islands, British"]
["VI","Virgin Islands, U.S."]
["WF","Wallis and Futuna"]
["EH","Western Sahara"]
["YE","Yemen"]
["ZM","Zambia"]
["ZW","Zimbabwe"]

{"sheet":"Freight Carrier Codes","index":3,"n_rows":76,"n_cols":5,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["FREIGHT_CODE","CARRIER_NAME"]
["ABF","ABF"]
["AERO","Aero",null,null,"** Use Freight Code (Column A) for Template Update"]
["Ceva","CEVA"]
["SCH","SCH Consolidation"]
["CSCR","Customer Specified Carrier"]
["CUSCOL","Cuscol"]
["DB Schenker","DB Schenker"]
["DGF","DHL Global Forwarding"]
["DHL","DHL"]
["FEDEX","Fedex"]
["Immediate Air","Immediate Air"]
["Internal","Internal"]
["Geolog","Geolog"]
["MAC","MAC"]
["MFreight","MFreight"]
["NNR","NNR"]
["ONTOUR","ONTOUR"]
["Other","Other"]
["Rollkontor","Rollkontor"]
["Stets Logistics","Stets Logistics"]
["Schenker","Schenker"]
["TNT","TNT Courier"]
["UTI","DSV"]
["YRC","YRC"]
["USPS","USPS"]
["CPU","Customer Pick Up"]
["CSC","Customer Specified"]
["Follow Routing Guide","Follow Routing Guide"]
["UPS","UPS"]
["Roadway","Roadway Express"]
["USF","USF Holland"]
["BWA","Best Way Air"]
["MON","Monroe Transportation"]
["PUR","Purolator"]
["BWS","Best Way Surface"]
["YEL","Yellow Freight System"]
["Coburns","Coburns"]
["Mainfreight","Mainfreight Domestic"]
["ODF","Old Dominion Freight"]
["HCA","Hand Carry"]
["CNWY","Conway"]
["CRST","CRST International"]
["JAF","JA Frate"]
["JBH","JB Hunt"]
["SNDR","Schneider National"]
["CHL","Challenger"]
["SIC","SIC - System Integration Center Berlin"]
["TOLL","TOLL"]
["QUEBEC","QUEBEC"]
["HAND DLVR","HAND DLVR"]
["AIRB","AIRB"]
["CANPAC","CANPAC"]
["CANPAX","CANPAX"]
["CANPO","CANPO"]
["DOCX","DOCX"]
["LOOMIC","LOOMIC"]
["LOOMIX","LOOMIX"]
["PRLAIR","PRLAIR"]
["PRLGRD","PRLGRD"]
["PRLTRC","PRLTRC"]
["PRLTRX","PRLTRX"]
["SAMEDX","SAMEDX"]
["USMAIL","USMAIL"]
["DBSCHENKER","DBSCHENKER"]
["LTL","LTL"]
["EXP","EXPEDITORS"]
["TNTEX","TNT EX"]
["Challenger","Challenger---DO NOT USE"]
["Monroe","Monroe Transportation--DO NOT USE"]
["Purolator","Purolator-----DO NOT USE"]
["BAX","DO NOT USE 0202"]
["TNSM","TESTING NEW SHIP METHOD"]
["IACT","IACT"]
["WAT","WAT"]
["BAW","Best Way - DO NOT USE"]

{"sheet":"UOM","index":4,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["EACH","UOM",null,"** Use EACH (Column A) for Template Update"]