{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["About","Instructions","Catalog Template","Header Example","Field Descriptions","Additional Information"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"About","index":0,"n_rows":20,"n_cols":5,"rows_kept":20,"merged":[[2,3,2,4],[4,3,4,4],[6,3,6,4],[8,3,8,4],[10,3,10,4]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"System","FedMall"]
[]
[null,null,"Document","Supplier Catalog Template"]
[]
[null,null,"Created By","IBM"]
[]
[null,null,"Purpose","To assist suppliers with the generation of a valid Excel spreadsheet to create or maintain their catalog items in FedMall"]
[]
[null,null,"Last Updated On","2017-06-13"]
[]
[null,null,"Version History","v0.1.0","Initial Release"]
[{"$nulls":3},"v0.1.1","Minor update to incorporate DLA feedback"]
[{"$nulls":3},"v0.1.2","Minor revision. Described how to specify a contract ID for MarketPlace catalogs. Listed reference location for MRC code lookup."]
[{"$nulls":3},"v0.1.3","Minor revision. Provided additional clarification about how to manage the date formats when using Microsoft Excel to edit the template."]
[{"$nulls":3},"v0.1.4","Minor revision. Added details for handling delimiters with optional fields in the \"Instructions\" tab. Updated URL and clarified Note on \"Additional Information\" tab. Clarified that the \"Justifying Comment\" fields are conditionally required."]
[{"$nulls":3},"v0.1.5","Minor revision. Marked Quantity Per Unit Pack and Days ARO as mandatory fields."]
[{"$nulls":3},"v0.1.6","Minor revision. Set all Catalog Template cells to be formatted as \"Text.\""]
[{"$nulls":3},"v0.1.7","Removed DLIS URL pointing to MRC code list, which is no longer valid."]

{"sheet":"Instructions","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Instructions",1,null,"Complete the \"Catalog Template\" sheet with your catalog details. Do not modify the number or the order of the columns."]
[{"$nulls":3},2,null,"Reference the \"Field Descriptions\" sheet and the \"Additional Information\" sheet for help on completing the data entry. You may leave optional fields blank."]
[{"$nulls":3},3,null,"If the item already exists in FedMall, it will be overwritten. If it does not already exist in FedMall, it will be added. To delete an item, enter a \"Y\" in the first column (Archive); otherwise, leave the first column blank (or specify \"N\" in the first column)."]
[{"$nulls":3},4,null,"When complete, upload the file to FedMall via the Supplier Portal."]
[]
[null,null,"Catalog File Details","File Type",null,"The file should be a plain text file with a .csv extension."]
[{"$nulls":3},"Row Header",null,"Use the headings on the \"Catalog Template\" sheet. The uploaded .csv file must include the headings as its first row."]
[{"$nulls":3},"Field Delimiter",null,"Each field should be separated from adjacent fields with a delimiter, which is the caret ( ^ ) character. If you want to use Microsoft Excel to create your data file and then export it to delimited text, instructions are provided below."]
[{"$nulls":3},"Rows",null,"At present, you may insert a maximum of 10,000 rows of data (plus the one header row). This limitation is subject to change following performance testing."]
[{"$nulls":3},"File Size",null,"The size of the file will vary not only with the number of rows of data, but also with the content of each row. The file should not exceed a maximum size of 20 Megabytes to support effective performance. This limitation is subject to change following system performance testing."]
[]
[null,null,"Managing Images","Specification",null,"All images are uploaded in an archive (.zip) file separate from the main catalog spreadsheet. Please see the \"Image Upload Specification\" spreadsheet for complete details about how to structure that image file archive."]
[]
[null,null,"Using MRCs to Specify Additional Characteristics","Specification",null,"The final field in the template, \"Characteristic Information,\" represents a series of code-value pairs, where the code is a Master Requirements Code (MRC) as listed in the Master Requirements Directory (MRD), which in turn is managed by the Defense Logistics Agency (DLA) Logistics Information Services (DLIS). You may search for individual codes in the Supplier Portal by accessing Product Information Management and adding/editing an item."]
[]
[null,null,"Exporting a Text File from Excel","Summary",null,"You may create your catalog file in any text editor. You may also find it convenient to use Excel to maintain your data and then export the data from Excel to the delimited text file for import into FedMall. "]
[{"$nulls":3},1,null,"First, change your delimiter (\"list separator\"). Open Control Panel and then the \"Region and Language\" applet (or, click Start -> Run and type \"intl.cpl\"). On the Formats tab, click \"Additional settings…\". Change the \"List separator\" value from its default (usually a comma) to the caret (Shift + 6 on most US keyboards). Click OK to save the change."]
[{"$nulls":3},2,null,"In Excel, create your catalog. Ensure that the first row contains the column headers as listed in the \"Catalog Template\" sheet. Click File -> Save As. In Save As Type, select \"CSV (Comma delimited) (*.csv)\". Provide a file name and click Save. Excel will warn you that \"some features in your workbook might be lost\"; click Yes to keep using this format (Excel is warning you that some features, like formatting, won't be saved in a text file; this is to be expected)."]
[{"$nulls":3},3,null,"Confirm a successful export by opening the file in a plain text editor (such as Notepad). You should see the header row on the first line followed by your data, with a caret ( ^ ) character separating each data field (\"column\")."]
[]
[null,null,"Maintaining Delimiters with Optional Fields","Specification",null,"There must be a caret separating each field, even if an optional field is left blank. For example, if leaving OEM CAGE Code blank (between OEM Part Number and OEM Name), the fields might look like this: \n…^PN12345^^Company Name^…  \nThis same principle holds true at the end of the row. For example, if you leave the last five fields blank in a given row, that row would end with five carets (^^^^^), like this: \n…^This item meets environmental regulations^^^^^ "]

{"sheet":"Catalog Template","index":2,"n_rows":1,"n_cols":30,"rows_kept":1,"flags":["formulas_cached_only"]}
["Item Master Primary Spec/Item Status Information/Archive","Item Master Primary Spec/Common Information/Commercial and Government Entity Code","Item Master Primary Spec/Common Information/Contract Number","Item Master Primary Spec/Common Information/Part Number","Item Master Primary Spec/Common Information/Part Name","Item Master Primary Spec/Common Information/Federal Supply Class","Item Master Primary Spec/Pricing/Original Unit Price","Item Master Primary Spec/Pricing/Original Unit of Issue","Item Master Primary Spec/Pricing/Quantity Per Unit Pack","Item Master Primary Spec/Common Information/Original Equipment Manufacturer Part Number","Item Master Primary Spec/Common Information/Original Equipment Manufacturer CAGE Code","Item Master Primary Spec/Common Information/Original Equipment Manufacturer Name","Item Master Primary Spec/Short Description","Item Master Primary Spec/Common Information/Days After Receipt of Order","Item Master Primary Spec/Long Description","Item Master Primary Spec/Common Information/Universal Product Code","Item Master Primary Spec/Commercial Information/Environmental Information/Hazardous Material Flag","Item Master Primary Spec/Sale Pricing/Sale Start Date","Item Master Primary Spec/Sale Pricing/Sale End Date","Item Master Primary Spec/Sale Pricing/Sale Price","Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Standard Shipment Price","Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Expedited Shipment Price","Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Next Day Shipment Price","Item Master Primary Spec/Special Properties/Environmentally Preferred/Environmentally Preferred Indicator","Item Master Primary Spec/Special Properties/Environmentally Preferred/Justifying Comment","Item Master Primary Spec/Special Properties/Energy Star/Energy Star Indicator","Item Master Primary Spec/Special Properties/Energy Star/Justifying Comment","Item Master Primary Spec/Special Properties/Made in the USA/Made in the USA Indicator","Item Master Primary Spec/Special Properties/Made in the USA/Justifying Comment","Item Master Primary Spec/Characteristic Information"]

{"sheet":"Header Example","index":3,"n_rows":5,"n_cols":1,"rows_kept":5,"flags":["formulas_cached_only"]}
["Header Example"]
[]
["The first row of your .csv text file is a header row, and it should look like this:"]
[]
["Item Master Primary Spec/Item Status Information/Archive^Item Master Primary Spec/Common Information/Commercial and Government Entity Code^Item Master Primary Spec/Common Information/Contract Number^Item Master Primary Spec/Common Information/Part Number^Item Master Primary Spec/Common Information/Part Name^Item Master Primary Spec/Common Information/Federal Supply Class^Item Master Primary Spec/Pricing/Original Unit Price^Item Master Primary Spec/Pricing/Original Unit of Issue^Item Master Primary Spec/Pricing/Quantity Per Unit Pack^Item Master Primary Spec/Common Information/Original Equipment Manufacturer Part Number^Item Master Primary Spec/Common Information/Original Equipment Manufacturer CAGE Code^Item Master Primary Spec/Common Information/Original Equipment Manufacturer Name^Item Master Primary Spec/Short Description^Item Master Primary Spec/Common Information/Days After Receipt of Order^Item Master Primary Spec/Long Description^Item Master Primary Spec/Common Information/Universal Product Code^Item Master Primary Spec/Commercial Information/Environmental Information/Hazardous Material Flag^Item Master Primary Spec/Sale Pricing/Sale Start Date^Item Master Primary Spec/Sale Pricing/Sale End Date^Item Master Primary Spec/Sale Pricing/Sale Price^Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Standard Shipment Price^Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Expedited Shipment Price^Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Next Day Shipment Price^Item Master Primary Spec/Special Properties/Environmentally Preferred/Environmentally Preferred Indicator^Item Master Primary Spec/Special Properties/Environmentally Preferred/Justifying Comment^Item Master Primary Spec/Special Properties/Energy Star/Energy Star Indicator^Item Master Primary Spec/Special Properties/Energy Star/Justifying Comment^Item Master Primary Spec/Special Properties/Made in the USA/Made in the USA Indicator^Item Master Primary Spec/Special Properties/Made in the USA/Justifying Comment^Item Master Primary Spec/Characteristic Information"]

{"sheet":"Field Descriptions","index":4,"n_rows":33,"n_cols":9,"rows_kept":33,"merged":[[0,1,0,2]],"flags":["formulas_cached_only"]}
["Field Descriptions","Descriptions of columns in Supplier Catalog Template sheet"]
[]
["Field Name","Position","Field Description","Field Group","Attribute Type","Attribute Length","Mandatory","Multi-valued?","Attribute Header (matches the column headers in the \"Catalog Template\" sheet)"]
["Archive",1,"This field indicates whether the item should be marked for deletion (archive). Valid values are \"Y\" (yes, archive; mark as deleted in the database) or \"N\" (no, default).","Item Status Information","STRING",1,"N","Single value","Item Master Primary Spec/Item Status Information/Archive"]
["Commercial and Government Entity Code",2,"The CAGE code of the supplier; a 5-character alphanumeric code issued by the US Government","Common Information","STRING",5,"Y","Single value","Item Master Primary Spec/Common Information/Commercial and Government Entity Code"]
["Contract Number",3,"The full contract number associated with this item's catalog. For MarketPlace catalogs without a contract, use the identifier MARKETPLACE_<CAGE>. That is, a single underscore character ( _ ) separates the all-capital word “MARKETPLACE” from the supplier’s CAGE code (5 alphanumeric characters). Example: MARKETPLACE_012AB.","Common Information","STRING",20,"Y","Single value","Item Master Primary Spec/Common Information/Contract Number"]
["Part Number ",4,"Your part number; the part number as captured by the vendor/supplier.","Common Information","STRING",80,"Y","Single value","Item Master Primary Spec/Common Information/Part Number"]
["Part Name",5,"Product name; the name of the item","Common Information","STRING",80,"Y","Single value","Item Master Primary Spec/Common Information/Part Name"]
["Product Service Code",6,"The PSC (product service code) includes all of the Federal Service Code (FSC) numbers and includes additional codes; PSCs are 4 alphanumeric characters long.","Common Information","STRING",4,"Y","Single value","Item Master Primary Spec/Common Information/Federal Supply Class"]
["Price",7,"This is the customer cost; note: for FOB Destination, this price must include the shipment costs. Enter the price as a number with up to two decimal digits; do not include the dollar sign.","Pricing","NUMBER",20,"Y","Single value","Item Master Primary Spec/Pricing/Original Unit Price"]
["Unit of Issue",8,"This is a word such as \"each,\" \"box,\" or \"carton,\" to describe the unit associated with the quantity. Use a valid code from the list provided in the next sheet.","Pricing","STRING",2,"Y","Single value","Item Master Primary Spec/Pricing/Original Unit of Issue"]
["Quantity per Unit Pack",9,"Also known as the quantity per unit of issue; this is the number of items in each box, carton, etc.","Pricing","NUMBER",20,"Y","Single value","Item Master Primary Spec/Pricing/Quantity Per Unit Pack"]
["OEM Part Number",10,"The original equipment manufacturer (OEM) part number; do not modify with a prefix or suffix","Common Information","STRING",80,"Y","Single value","Item Master Primary Spec/Common Information/Original Equipment Manufacturer Part Number"]
["OEM CAGE Code",11,"The original equipment manufacturer (OEM)'s 5-character Commercial and Government Entity (CAGE) code","Common Information","STRING",5,"N","Single value","Item Master Primary Spec/Common Information/Original Equipment Manufacturer CAGE Code"]
["OEM Name",12,"The original equipment manufacturer (OEM) name; the name of the company that manufactured the item","Common Information","STRING",80,"Y","Single value","Item Master Primary Spec/Common Information/Original Equipment Manufacturer Name"]
["Description",13,"Detailed description of the item (spell out key words)","(General)","STRING",254,"Y","Single value","Item Master Primary Spec/Short Description"]
["Days ARO",14,"Time frame from receipt of order (ARO = After Receipt of Order) to shipping; this is not the same as the time frame for the delivery of an order.","Common Information","NUMBER",20,"Y","Single value","Item Master Primary Spec/Common Information/Days After Receipt of Order"]
["Expanded Description",15,"Long description of the item.","(General)","STRING",3000,"Y","Single value","Item Master Primary Spec/Long Description"]
["UPC",16,"The universal product code (\"bar code\") number. Use only digits 0 through 9; do not include the hyphen (-) character.","Common Information","STRING",12,"N","Single value","Item Master Primary Spec/Common Information/Universal Product Code"]
["Hazardous Material Flag",17,"Indicates hazardous material (HAZMAT) classification. Valid values are \"Y\" (yes, HAZMAT) or \"N\" (no).","Commercial Information","STRING",1,"N","Single value","Item Master Primary Spec/Commercial Information/Environmental Information/Hazardous Material Flag"]
["Sale Start Date",18,"The date (date only, no time) at which point the sale price will be effective. Use format YYYY-MM-DD, e.g. 2015-12-17. Note: If using Microsoft Excel to edit the file, change the format to “Text” (instead of “Date” or “General”) to prevent Excel from converting the numbers into its own data format.","Sale Pricing","DATE",10,"N","Single value","Item Master Primary Spec/Sale Pricing/Sale Start Date"]
["Sale End Date",19,"The date (date only, no time) at which point the sale price will no longer be effective. Use format YYYY-MM-DD, e.g. 2015-12-17. Note: If using Microsoft Excel to edit the file, change the format to “Text” (instead of “Date” or “General”) to prevent Excel from converting the numbers into its own data format.","Sale Pricing","DATE",10,"N","Single value","Item Master Primary Spec/Sale Pricing/Sale End Date"]
["Sale Price",20,"Enter the price as a number with up to two decimal digits; do not include the dollar sign.","Sale Pricing","NUMBER",20,"N","Single value","Item Master Primary Spec/Sale Pricing/Sale Price"]
["Standard Shipment Price",21,"Enter the price as a number with up to two digits after the decimal; do not include the dollar sign.","Commercial Information","NUMBER",10,"N","Single value","Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Standard Shipment Price"]
["Expedited Shipment Price",22,"Enter the price as a number with up to two digits after the decimal; do not include the dollar sign.","Commercial Information","NUMBER",10,"N","Single value","Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Expedited Shipment Price"]
["Next Day Shipment Price",23,"Enter the price as a number with up to two digits after the decimal; do not include the dollar sign.","Commercial Information","NUMBER",10,"N","Single value","Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Next Day Shipment Price"]
["Environmentally Preferred Indicator",24,"Indicates whether this item is environmentally preferred. Valid values are \"Y\" (yes) or \"N\" (no).","Special Properties","STRING",1,"N","Single value","Item Master Primary Spec/Special Properties/Environmentally Preferred/Environmentally Preferred Indicator"]
["Environmentally Preferred Justifying Comment",25,"Free text comments to justify the indicator. Required only if the associated indicator is “Y”.","Special Properties","STRING",3000,"Conditional","Single value","Item Master Primary Spec/Special Properties/Environmentally Preferred/Justifying Comment"]
["Energy Star Indicator",26,"Indicates whether this item is Energy Star certified. Valid values are \"Y\" (yes) or \"N\" (no).","Special Properties","STRING",1,"N","Single value","Item Master Primary Spec/Special Properties/Energy Star/Energy Star Indicator"]
["Energy Star Justifying Comment",27,"Free text comments to justify the indicator. Required only if the associated indicator is “Y”.","Special Properties","STRING",3000,"Conditional","Single value","Item Master Primary Spec/Special Properties/Energy Star/Justifying Comment"]
["Made in the USA Indicator",28,"Indicates whether this item is made in the USA. Valid values are \"Y\" (yes) or \"N\" (no).","Special Properties","STRING",1,"N","Single value","Item Master Primary Spec/Special Properties/Made in the USA/Made in the USA Indicator"]
["Made in the USA Justifying Comment",29,"Free text comments to justify the indicator. Required only if the associated indicator is “Y”.","Special Properties","STRING",3000,"Conditional","Single value","Item Master Primary Spec/Special Properties/Made in the USA/Justifying Comment"]
["Characteristic Information",30,"List of Master Requirement Codes (MRC). Format string as one or more code-value pairs. Separate the code from its value with the pipe (|) character. Separate each code-value pair with five (5) tilde characters (~~~~~). Format is: code1|value1~~~~~code2|value2~~~~~code3|value3~~~~~code4|value4. Do not use the delimiters (i.e. the pipe character or five consecutive tildes) in either the codes or the values provided. A maximum of 100 code-value pairs may be included per item.","Characteristic Information","STRING",13595,"N","Multiple values allowed per field","Item Master Primary Spec/Characteristic Information"]

{"sheet":"Additional Information","index":5,"n_rows":497,"n_cols":3,"rows_kept":497,"merged":[[0,0,0,1],[2,1,2,2],[4,0,4,2],[7,1,7,2],[8,1,8,2]],"flags":["formulas_cached_only"]}
["Additional Information"]
[]
["Important note","FedMall uses X12 codes on all outbound requisitions and purchase orders. For those vendors who are using the DoD codes, please use the conversions available in the table below. All codes in vendor catalog uploads should be X12 codes as listed below."]
[]
["Unit of Issue (UI) Codes"]
[]
["Number of codes:",485]
["Also see:","http://www.dlmso.dla.mil/eApplications/LogDataAdmin/dlmsansiconverguides.asp "]
["Note:","The following note is provided verbatim from the source document on the DLA.mil site: ALL X12 CODE VALUES WITHOUT TRAILING ASTERISKS(*) HAVE BEEN APPROVED BY THE ASC X12 COMMITTEE FOR USE IN ALL VERSION RELEASES OF ANSI X12. A SINGLE ASTERISK (*) INDICATES THAT X12 CODE VALUES ARE AUTHORIZED FOR USE IN VERSION RELEASES 005020 AND AN ALL SUBSEQUENT VERSIONS. THE X12 CODE VALUES FOLLOWED BY A DOUBLE ASTERISK (**) HAVE BEEN APPROVED FOR VERSION RELEASE 005030 AND ALL SUBSEQUENT VERSIONS."]
[]
["DOD CODE \n(for reference only)","NAME/DEFINITION","X12 CODE \n(to be used in FedMall)"]
["SC","SECOND",3]
[5,"LIFT",5]
[7,"STRAND",7]
[9,"TIRE",9]
["GP","GROUP",10]
["OT","OUTFIT",11]
["PZ","PACKET",12]
["RA","RATION",13]
["SO","SHOT",14]
["SX","STICK",15]
[17,"100 POUND DRUM",17]
[18,"55 GALLON DRUM",18]
[19,"TANK TRUCK",19]
["1N","COUNT","1N"]
["1O","SEASON","1O"]
["1P","TANK CAR","1P"]
["FR","FRAME","1Q"]
["1R","TRANSACTION","1R"]
["1X","QUARTER MILE","1X"]
[20,"20 FOOT CONTAINER",20]
[21,"40 FOOT CONTAINER",21]
["2D","SHIP SET","2D"]
["MB","BRITISH THERMAL UNITS/HOUR","2I"]
["DB","DECIBEL","2N"]
["KC","KILOCURIE ","2R"]
["2U","MEGAGRAM","2U"]
["2W","BIN","2W"]
[43,"SUPER BULK BAG (SAME SIZE AS PALLET)",43]
[44,"500 KILOGRAM BULK BAG",44]
[45,"300 KILOGRAM BULK BAG",45]
[46,"25 KILOGRAM BULK BAG",46]
[47,"50 POUND BAG",47]
[48,"BULK CAR LOAD",48]
["4A","BOBBIN","4A"]
["4B","CAP","4B"]
["4E","20-PACK","4E"]
["4F","100-PACK","4F"]
["4G","MICROLITER","4G"]
[51,"ACTUAL TONNES",51]
[57,"MESH",57]
[58,"NET KILOGRAMS",58]
["5B","BATCH","5B"]
["5D","PROOF GALLONS","5D"]
["5G","PUMP","5G"]
["5H","STAGE","5H"]
["5I","STANDARD CUBE FOOT","5I"]
["VT","VOLT",70]
["7A","LANDINGS","7A"]
["7C","FLIGHT HOURS","7C"]
["8C","CORD","8C"]
["8D","DUTY","8D"]
["8P","PROJECT","8P"]
["8R","PROGRAM","8R"]
["8S","SESSION","8S"]
["K2","SQUARE KILOMETER","8U"]
[91,"STOKE",91]
[94,"CURL UNIT",94]
[95,"20,000 GALLON TANKCAR",95]
[96,"10,000 GALLON TANKCAR",96]
[97,"10 KILOGRAM DRUM",97]
[98,"15 KILOGRAM DRUM",98]
["WT","WATT ",99]
["AP","APOTHECARY POUND","9A (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["BQ","BRIQUET","9B (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["FD","FOLD","9F (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["AO","APOTHECARY OUNCE","9O (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["PI","PILLOW","9P (X12 VERSION RELEASE 005030 MIGRATION CODE. REFER TO ADC 1008.) "]
["ST","SEAT","9S (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["9Y","FAMILY UNIT","9Y"]
["US","USP UNIT","9Z (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["BA","BALL","AA"]
["AB","BULK PACK","AB"]
["AC","ACRE","AC"]
["YT","BYTE ","AD"]
["CG","CENTIGRAM","AF"]
["AJ","COP (CYLINDRICAL OR CONICAL MASS)","AJ"]
["FA","FATHOM ","AK"]
["AL","ACCESS LINES","AL"]
["AM","AMPOULE","AM"]
["AR","SUPPOSITORY ","AR"]
["AT","ASSORTMENT","AS"]
["AV","CAPSULE","AV"]
["AW","POWDER-FILLED VIAL","AW"]
["AX","TWENTY","AX"]
["AY","ASSEMBLY","AY"]
["B0","BRITISH THERMAL UNITS PER CUBIC FOOT","B0"]
["BY","BUNK","B2"]
["B3","BATTING POUND","B3"]
["B4","BARREL IMPERIAL","B4"]
["B5","BILLET","B5"]
["B6","BUN","B6"]
["B7","CYCLE","B7"]
["B8","BOARD","B8"]
["B9","BATT","B9"]
["BE","BALE","BA"]
["BB","BASS BOX","BB"]
["BC","BUCKET","BC"]
["BD","BUNDLE","BD"]
["BM","BEAM ","BE"]
["BF","BOARD FOOT","BF"]
["BG","BAG","BG"]
["BH","BRUSH","BH"]
["BR","BAR","BI"]
["BJ","BAND","BJ"]
["BK","BOOK","BK"]
["BZ","BLOCK","BL"]
["BO","BOLT","BM"]
["BN","BULK","BN"]
["BT","BOTTLE","BO"]
["BP","100 BOARD FEET","BP"]
["BL","BARREL","BR"]
["BS","BASKET","BS"]
["BI","BELT ","BT"]
["BU","BUSHEL (32 DRY QUARTS)","BU"]
["BV","BUSHEL DRY IMPERIAL","BV"]
["BW","BASE WEIGHT","BW"]
["BX","BOX","BX"]
["ZF","MILLION BTUS/DEKATHERM","BZ"]
["C0","CALLS","C0"]
["C1","COMPOSITE PRODUCT POUNDS (TOTAL WEIGHT)","C1"]
["C7","CARSET","C2"]
["C4","CARLOAD","C4"]
["C5","COST","C5"]
["C6","CELL","C6"]
["C8","CUBIC DECIMETER","C8"]
["C9","COIL GROUP","C9"]
["CS","CASE","CA"]
["CB","CARBOY","CB"]
["CC","CUBIC CENTIMETER","CC"]
["KR","KARAT (CARAT)","CD"]
["CF","CUBIC FOOT","CF"]
["CQ","CARD","CG"]
["CO","CONTAINER","CH"]
["CI","CUBIC INCH","CI"]
["CE","CONE","CJ"]
["CR","CONNECTOR","CK"]
["CY","CYLINDER","CL"]
["CM","CENTIMETER","CM"]
["CN","CAN","CN"]
["CP","CRATE","CP"]
["CA","CARTRIDGE","CQ"]
["CZ","CUBIC METER","CR"]
["CX","CASSETTE","CS"]
["CT","CARTON","CT"]
["CU","CUP","CU"]
["CV","COVER","CV"]
["HP","HUNDRED POUNDS ","CW"]
["CL","COIL","CX"]
["CD","CUBIC YARD","CY"]
["C3","COMBO","CZ"]
["DA","DAY","DA"]
["DM","DRAM","DF"]
["DG","DECIGRAM","DG"]
["MI","MILE","DH"]
["DI","DISPENSER","DI"]
["DC","DECAGRAM","DJ"]
["KM","KILOMETER","DK"]
["DL","DECILITER","DL"]
["DE","DECIMETER","DM"]
["DO","DOLLARS U.S.","DO"]
["DP","DOZEN PAIR","DP"]
["DQ","DATA RECORD","DQ"]
["DR","DRUM","DR"]
["DS","DISPLAY","DS"]
["DT","DRY TON","DT"]
["DU","DYNE","DU"]
["DK","DEGREES, KELVIN","DV"]
["DX","CALENDAR DAYS (NUMBER OF)","DW"]
["DY","DIRECTORY BOOKS","DY"]
["DZ","DOZEN","DZ"]
["E1","HECTOMETER","E1"]
["EA","EACH","EA"]
["EB","ELECTRONIC MAIL BOXES","EB"]
["EE","EMPLOYEES","EE"]
["EH","KNOTS","EH"]
["EJ","LOCATIONS","EJ"]
["EP","ELEVEN PACK","EP"]
["EQ","EQUIVALENT GALLONS","EQ"]
["EV","ENVELOPES","EV"]
["IU","INTERNATIONAL UNIT","F2"]
["F4","MINIM ","F4"]
["F6","PRICE PER SHARE","F6"]
["DF","FAHRENHEIT ","FA"]
["FB","FIELDS","FB"]
["FC","1000 CUBIC FEET","FC"]
["FE","TRACK FOOT","FE"]
["FF","HUNDRED CUBIC METERS","FF"]
["FG","TRANSDERMAL PATCH","FG"]
["FJ","SIZING FACTOR","FJ"]
["FK","FIBER","FK"]
["FL","FLAKE TON","FL"]
["FM","MILLION CUBIC FEET","FM"]
["FO","FLUID OUNCE","FO"]
["FT","FOOT","FT"]
["FU","FURLONG","FU"]
["GB","GALLONS PER MINUTE ","G2"]
["GI","GILL (IMPERIAL)","G5"]
["GL","GALLON","GA"]
["GG","GREAT GROSS","GG"]
["IG","IMPERIAL GALLON","GI"]
["GM","GRAM","GR"]
["GR","GROSS","GS"]
["GN","GRAIN","GX"]
["H2","HALF LITER","H2"]
["H4","HECTOLITER","H4"]
["HK","HANK","HA"]
["HX","HUNDRED BOXES","HB"]
["HC","HUNDRED COUNT","HC"]
["HZ","HALF DOZEN","HD"]
["HF","HUNDRED FEET","HF"]
["HG","HECTOGRAM","HG"]
["HA","HUNDRED CUBIC FEET","HH"]
["HI","HUNDRED SHEETS","HI"]
["KH","HUNDREDS OF KILOGRAMS","HK"]
["HL","HUNDRED FEET (LINEAR)","HL"]
["HO","HUNDRED TROY OUNCES","HO"]
["HQ","HECTARE","HQ"]
["HR","HOUR","HR"]
["HS","HUNDRED SQUARE FEET","HS"]
["HT","HALF HOUR","HT"]
["HD","HUNDRED","HU"]
["HW","HUNDRED WEIGHT – SHORT (HUNDRED WEIGHT) ","HV"]
["CW","HUNDRED WEIGHT (LONG)","HW"]
["HB","HOSPITAL BEDS","HX (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["HY","HUNDRED YARDS","HY"]
["I1","PERSONS, CAPACITY"]
["PX","PELLET","I2 (X12 VERSION RELEASE 005030 MIGRATION CODE. REFER TO ADC 1008.)"]
["PN","PERSON ","IE"]
["IH","INHALER","IH"]
["IM","IMPRESSION","IM"]
["IN","INCH","IN"]
["IP","INSURANCE POLICY","IP"]
["IS","STOP","IS"]
["JB","JOB","JA"]
["JU","JUMBO ","JB"]
["JO","JOINT","JO"]
["JR","JAR","JR"]
["JG","JUG ","JU"]
["K6","KILOLITER","K6"]
["K7","KILOWATT","K7"]
["KV","KILOVOLT ","K8 (X12 VERSION RELEASE 006050 MIGRATION CODE. REFER TO ADC 1008.)"]
["CK","CAKE ","KA"]
["KE","KEG","KE"]
["KF","KILOPACKET","KF"]
["KG","KILOGRAM","KG"]
["KZ","KILOWATT-HOUR ","KH "]
["KK","100 KILOGRAMS","KK"]
["KT","KIT","KT"]
["KU","TASK","KU"]
["DK","KELVIN ","KV"]
["L5","LITERS AT 15 DEGREES CELSIUS","L5 (LOCAL CODE SUBMITTED FOR INCLUSION IN X12. REFER TO ADC 1108.) "]
["LB","POUND (AVOIRDUPOIS)","LB"]
["LE","LITE","LE"]
["LF","LINEAR FOOT","LF"]
["LO","LONG TON","LG"]
["LN","LINEAR INCH","LI"]
["LJ","LARGE SPRAY","LJ"]
["LK","LINK","LK"]
["LM","LINEAR METER","LM"]
["LG","LENGTH","LN"]
["LT","LOT","LO"]
["LR","LAYER","LR"]
["LS","LUMP SUM","LS"]
["LI","LITER","LT"]
["LY","LINEAR YARD","LY"]
["M0","MAGNETIC TAPE","M0"]
["M3","MAT","M3"]
["M5","MICROGRAM","MC"]
["MD","AIR DRY METRIC TON","MD"]
["MG","MILLIGRAM","ME"]
["MJ","METRIC GROSS TON","MG"]
["MH","METRIC ","MI"]
["MT","MINUTE","MJ"]
["ML","MILLILITER","ML"]
["MM","MILLIMETER","MM"]
["MA","METRIC NET TON","MN"]
["MO","MONTH","MO"]
["M6","METRIC TON","MP"]
["MQ","1000 METERS","MQ"]
["MR","METER","MR"]
["MS","SQUARE MILLIMETER","MS"]
["MK","METRIC LONG TON","MT"]
["MZ","MIXED","MX"]
["N2","NUMBER OF LINES","N2"]
["N7","PART","N7"]
["N9","CARTRIDGE NEEDLE","N9"]
["NB","BARGE","NB"]
["NC","CAR","NC"]
["ND","NET BARRELS","ND"]
["NE","NET LITERS","NE"]
["NF","MESSAGES","NF"]
["NG","NET GALLONS","NG"]
["NI","NET IMPERIAL GALLONS","NI"]
["NJ","NUMBER OF SCREENS","NJ"]
["NK","NIGHTS","NK"]
["NL","LOAD","NL"]
["NM","NAUTICAL MILE","NM"]
["NN","TRAIN","NN"]
["NS","SHORT TON","NS"]
["NT","TRAILER","NT"]
["NV","VEHICLE","NV"]
["NX","PARTS PER THOUSAND","NX"]
["GT","THOUSAND GALLONS PER DAY","NZ (X12 VERSION RELEASE 005030 MIGRATION CODE. REFER TO ADC 1008.)"]
["OA","PANEL","OA"]
["OL","OUTLET","OB (X12 VERSION RELEASE 005030 MIGRATION CODE. REFER TO ADC 1008.)"]
["OC","BILLBOARD","OC"]
["GX","APOTHECARY GRAIN","OG (X12 VERSION RELEASE 005030 MIGRATION CODE. REFER TO ADC 1008.) "]
["OP","TWO PACK","OP"]
["OU","OPERATING UNIT","OU (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["OZ","OUNCE - AV ","OZ"]
["P0","PAGE - ELECTRONIC","P0"]
["P1","PERCENT","P1"]
["P2","POUNDS PER FOOT","P2"]
["P3","THREE PACK","P3"]
["P4","FOUR PACK","P4"]
["P5","FIVE PACK","P5"]
["P6","SIX PACK","P6"]
["P7","SEVEN PACK","P7"]
["P8","EIGHT PACK","P8"]
["P9","NINE PACK","P9"]
["PL","PAIL","PA"]
["PB","PAIR INCHES","PB"]
["PC","PIECE","PC"]
["PD","PAD","PD"]
["PE","POUNDS EQUIVALENT","PE"]
["PF","PALLET (LIFT)","PF"]
["PO","POUNDS GROSS","PG"]
["PH","PACK (PAK)","PH"]
["PY","PITCH ","PI"]
["PG","PACKAGE","PK"]
["PJ","PALLET/UNIT LOAD","PL"]
["PS","POUNDS NET","PN"]
["PM","PLATE","PP"]
["PR","PAIR","PR"]
["PT","PINT","PT"]
["PU","MASS POUNDS","PU"]
["PV","HALF PINT","PV"]
["PP","PINT IMPERIAL","PX"]
["PK","PECK DRY US","PY"]
["PQ","PECK DRY IMPERIAL ","PZ"]
["ME","MEAL","Q3"]
["FY","FIFTY","Q4"]
["TF","TWENTY-FIVE","Q5"]
["TS","THIRTY-SIX","Q6"]
["TD","TWENTY-FOUR","Q7"]
["FV","FIVE","Q9 (X12 VERSION RELEASE 005030 MIGRATION CODE. REFER TO ADC 1008.)"]
["QC","CHANNEL","QC"]
["QU","QUARTER DOZEN","QD"]
["QE","PHOTOGRAPHS","QE"]
["QF","QUARTER ","QF ** "]
["QK","QUARTER KILOGRAM","QK"]
["QR","QUIRE","QR"]
["QS","QUART DRY U.S.","QS"]
["QT","QUART","QT"]
["QI","QUART IMPERIAL","QU"]
["R4","CALORIE","R4"]
["R5","THOUSANDS OF DOLLARS ","R5"]
["R9","THOUSAND CUBIC METERS","R9"]
["RR","RACK ","RA"]
["RB","RADIAN","RB"]
["RC","ROD (AREA) - 16.25 SQUARE YARDS","RC"]
["RD","ROD (LENGTH) - 5.5 YARDS","RD"]
["RL","REEL","RE"]
["RG","RING","RG"]
["RH","RUNNING OR OPERATING HOURS","RH"]
["RK","ROLL-METRIC MEASURE","RK"]
["RO","ROLL","RL"]
["RM","REAM","RM"]
["RN","REAM-METRIC MEASURE","RN"]
["RE","ROUND ","RO"]
["RP","POUNDS PER REAM","RP"]
["RS","RESETS","RS"]
["RT","REVENUE TON MILES","RT"]
["RU","RUN","RU"]
["RX","THOUSAND ROUNDS","RX"]
["S5","SIXTY-FOURTHS OF AN INCH","S5"]
["S6","SESSIONS","S6"]
["S7","STORAGE UNITS","S7"]
["SW","STANDARD ADVERTISING UNIT ","S8"]
["S9","SLIP SHEET","S9"]
["SA","SANDWICH","SA"]
["M2","SQUARE MILE","SB"]
["C2","SQUARE CENTIMETER","SC"]
["SN","SECTION (640 ACRES OR ONE SQUARE MILE) ","SE"]
["SF","SQUARE FOOT","SF"]
["SG","SEGMENT","SG"]
["SH","SHEET","SH"]
["SI","SQUARE INCH","SI"]
["SJ","SACK","SJ"]
["SR","SPLIT TANKTRUCK","SK"]
["SV","SLEEVE","SL"]
["SM","SQUARE METER","SM"]
["SU","SQUARE ROD","SN"]
["SL","SPOOL","SO"]
["S8","SHELF PACKAGE","SP"]
["SQ","SQUARE","SQ"]
["SP","STRIP","SR"]
["SS","SHEET-METRIC MEASURE","SS"]
["SE","SET","ST"]
["SD","SKID","SV"]
["SK","SKEIN","SW"]
["SB","SHIPMENT ","SX"]
["SY","SQUARE YARD","SY"]
["SZ","SYRINGE","SZ"]
["T1","THOUSAND POUNDS GROSS","T1"]
["T3","THOUSAND PIECES","T3"]
["T4","THOUSAND BAGS","T4"]
["T5","THOUSAND CASINGS","T5"]
["T6","THOUSAND GALLONS","T6"]
["T7","THOUSAND IMPRESSIONS","T7"]
["T8","THOUSAND LINEAR INCHES","T8"]
["T9","THOUSAND KILOWATT HOURS/MEGAWATT-HOUR ","T9"]
["TA","TENTH CUBIC FOOT","TA"]
["TU","TUBE","TB"]
["TC","TRUCK LOAD","TC"]
["TG","GROSS TON","TG"]
["MX","THOUSAND","TH"]
["TI","THOUSAND SQUARE INCHES","TI"]
["TJ","THOUSAND SQUARE CENTIMETERS","TJ"]
["TK","TANK","TK"]
["MF","THOUSAND FEET","TL"]
["TM","THOUSAND FEET (BOARD)","TM"]
["TN","NET TON (2,000 POUNDS)","TN"]
["TO","TROY OUNCE","TO"]
["TV","TEN-PACK","TP"]
["TQ","THOUSAND FEET","TQ"]
["TR","TEN SQUARE FEET","TR"]
["TZ","THOUSAND SQUARE FEET","TS"]
["TL","THOUSAND LINEAR METERS","TT"]
["TX","THOUSAND LINEAR YARDS","TU"]
["TH","THOUSAND KILOGRAMS","TV"]
["TW","THOUSAND SHEETS","TW"]
["TP","TROY POUND","TX"]
["TY","TRAY","TY"]
["MC","THOUSAND CUBIC FEET","TZ"]
["U1","TREATMENT","U1"]
["TT","TABLET","U2"]
["TE","TEN","U3"]
["U5","TWO HUNDRED FIFTY","U5"]
["U6","UNITED STATES GALLONS @ 60 DEGREES FAHRENHEIT","U6 (MIGRATION CODE APPROVED FOR VERSION TO BE PUBLISHED JAN 2014. REFER TO ADC 1008.) "]
["UH","TEN THOUSAND YARDS","UH"]
["UL","UNITLESS","UL"]
["UM","MILLION UNITS","UM"]
["UN","UNIT","UN"]
["UP","TROCHE","UP"]
["UQ","WAFER","UQ"]
["AD","APOTHECARY DRAM","UX"]
["V1","FLAT","V1"]
["V2","POUCH","V2"]
["VC","FIVE HUNDRED","VC"]
["VI","VIAL","VI"]
["VS","VISIT","VS"]
["W2","WET KILO","W2"]
["WB","WET POUND","WB"]
["WD","WORK DAY","WD"]
["WE","WET TON","WE"]
["WG","WINE GALLON","WG"]
["WH","WHEEL","WH"]
["WK","WEEK","WK"]
["DW","PENNYWEIGHT","WP"]
["WR","WRAP","WR"]
["CH","CHAIN","X1"]
["X2","BUNCH","X2"]
["X3","CLOVE","X3"]
["X4","DROP","X4"]
["X5","HEAD","X5"]
["X6","HEART","X6"]
["X7","LEAF","X7"]
["X8","LOAF","X8"]
["X9","PORTION","X9"]
["Y1","SLICE","Y1"]
["TB","TABLESPOON","Y2"]
["T2","TEASPOON","Y3"]
["Y4","TUB","Y4"]
["YD","YARD","YD"]
["YL","100 LINEAL YARDS","YL"]
["YR","YEAR","YR"]
["Z1","LIFT VAN","Z1"]
["Z2","CHEST","Z2"]
["Z3","CASK","Z3"]
["HH","HOGSHEAD","Z4"]
["Z5","LUG","Z5"]
["PA","PAGE","ZP"]
["B2","BARREL, DRY ","ZW (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["B1","BARREL, LIQUID ","ZX (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]
["AS","APOTHECARY SCRUPLE ","ZY (X12 VERSION RELEASE 005020 MIGRATION CODE. REFER TO ADC 1008.)"]