FedMall_QSG_Catalog_Template v2.0_2023-12-14.xlsx

XLSX spreadsheet 45 KB Posted Dec 14, 2023

Attached to: New FEDMALL Synopsis Federal contract opportunity
Solicitation number: SP47W1-24-R-0002
Issued by: Defense Logistics Agency

About this file

Written by GovTribe AI · Dec 21, 2023

This document provides a template and instructions for suppliers to submit and maintain catalog items in FEDMALL. It includes a template spreadsheet with required data fields describing items, pricing, and additional attributes. Suppliers must populate the template with item details and upload the Excel or CSV file to FEDMALL via the supplier portal. The template outlines over 30 required and optional fields for items covering identification data, pricing, shipping costs, environmental certifications, and other attributes. Master data codes are used for some fields. Images must be uploaded separately. The document provides field descriptions and formatting instructions for suppliers to accurately populate the template for ingestion into the FEDMALL system.

View the file

Other files for this federal contract opportunity

Other files attached to New FEDMALL Synopsis, newest first.
File	Type	Posted
ATTACH_2_FedMall Question Template FedMall Questions and Answers.xlsx	XLSX spreadsheet	Apr 3, 2024
FEDMALL Items to be Solicited.xlsx	XLSX spreadsheet	Jan 18, 2024
DCSO-C3-FEDMALL Synopsis-13DEC23.pdf	PDF	Dec 14, 2023

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

About

System FedMall

Document Supplier Catalog Template

Created By IBM

Purpose To assist suppliers with the generation of a valid Excel spreadsheet to create or maintain their catalog items in FedMall

Last Updated On Monday, December 06, 2021

Version History	v0.1.0	Initial Release
	v0.1.1	Minor update to incorporate DLA feedback
	v0.1.2	Minor revision. Described how to specify a contract ID for MarketPlace catalogs. Listed reference location for MRC code lookup.
	v0.1.3	Minor revision. Provided additional clarification about how to manage the date formats when using Microsoft Excel to edit the template.
	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.
	v0.1.5	Minor revision. Marked Quantity Per Unit Pack and Days ARO as mandatory fields.
	v0.1.6	Minor revision. Set all Catalog Template cells to be formatted as "Text."
	v0.1.7	Removed DLIS URL pointing to MRC code list, which is no longer valid.

Instructions

Instructions	1	Complete the "Catalog Template" sheet with your catalog details. Do not modify the number or the order of the columns.
	2	Reference the "Field Descriptions" sheet and the "Additional Information" sheet for help on completing the data entry. You may leave optional fields blank.
	3	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).
	4	When complete, upload the file to FedMall via the Supplier Portal.

Catalog File Details	File Type	The file should be a plain text file with a .csv extension.
	Row Header	Use the headings on the "Catalog Template" sheet. The uploaded .csv file must include the headings as its first row.
	Field Delimiter	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.
	Rows	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.
	File Size	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.

Managing Images Specification 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.

Using MRCs to Specify Additional Characteristics Specification 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.

Exporting a Text File from Excel	Summary	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.
	1	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.
	2	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).
	3	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").

Maintaining Delimiters with Optional Fields Specification 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:

…^PN12345^^Company Name^… This 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:

…^This item meets environmental regulations^^^^^

Catalog Template 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

Header Example 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

Field Descriptions

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

Additional Information 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
(for reference only)	NAME/DEFINITION	X12 CODE

(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.)

http://www.dlmso.dla.mil/eApplications/LogDataAdmin/dlmsansiconverguides.asp

File details come from the government source that posted it. Updated Dec 14, 2023.