Attachment II_ECAT Catalog Schema.docx

DOCX document 71 KB Posted

Attached to
Laboratory Reagents Federal contract opportunity
Solicitation number
SPE2DS22Q0083
Issued by
Defense Logistics Agency Troop Support Subsistence

About this file

This is a solicitation for laboratory reagents to support the United States Army Medical Center Europe. The Defense Logistics Agency Troop Support Europe and Africa is seeking to award one or more Indefinite Delivery/Indefinite Quantity contracts for various brand-name laboratory reagents for delivery to USAMMCE locations in Kaiserslautern, Germany. The contracts would have a term of five years. The minimum value of each contract is $1,000 and the maximum is $2.5 million. Quotes are due by August 22, 2022. A pre-proposal conference will be held on August 4, 2022. The solicitation is unrestricted and conducted under FAR Part 13 for simplified acquisitions. The applicable NAICS code is 325413 with a small business size standard of 1,200 employees.

View the file

Other files for this federal contract opportunity

Other files attached to Laboratory Reagents, newest first.
File Type Posted
SPE2DS-22-Q-0083 0003.pdf PDF
Attachment 1_ECAT Catalog Loader_v14_25 Aug 22.xlsx XLSX spreadsheet
SPE2DS22Q0083-0002.pdf PDF
Attachment 1_ECAT Catalog Loader_v13_10 Aug 22.xlsx XLSX spreadsheet
SPE2DS22Q0083-0001.pdf PDF
Attachment 1_ECAT Catalog Loader_v12_5 Aug 22.xlsx XLSX spreadsheet
Attach VI_Acronym Definitions.pdf PDF
Reagent JA_signed_Redacted.pdf PDF
Attach IV_Supplier ECAT Order Management User Guide.pdf PDF
Attach V_Exchange Rate Revision Schedule.xlsx XLSX spreadsheet
SF1449_SPE2DS22Q0083.PDF PDF
Attach III_ECAT RegistrationGuide.pdf PDF
Attachment II_ECAT Catalog Schema.pdf PDF
Attachment 1_ECAT Catalog Loader_v11_22Jun22.xlsx XLSX spreadsheet
Show all 14

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

Text version

Attachment II: ECAT Catalog Schema Tab 1- Item Master Template Fields

Field Name
Length
Type
Definition
Comments
*MANUFACTURER NAME
40
AN
The name of the manufacturer that produces the product.
The combination of the Manufacturer Name and Manufacturer Part Number denotes the unique Product Identifier.
*MANUFACTURER PART NUMBER
30
AN
The Original Equipment Manufacturer's (OEM) item number to identify the product.
The combination of the Manufacturer Name and Manufacturer Part Number denotes the unique Product Identifier. If this field is blank, the NDC field MUST be completed.
*NATIONAL DRUG CODE
11
N
The National Drug Code corresponding to the Manufacturer Part Number.
Note: This field applies to Pharmaceutical products only.

The National Drug Code is an 11-digit number identifying human drugs.

If this field is blank, the Manufacturer Part Number field MUST be completed.

SUPPLIER NAME
120
AN
The name of the supplier that provides the product for distribution.
If this column is blank, the assumption is that the contract owner is the supplier. The system will align the supplier part number with the contract owner.
*SUPPLIER PART NUMBER
30
AN
The item number used by the supplier to identify the product.
LINE ITEM NUMBER
12
N
Used as a reference when providing errors for the current request that is being worked. Not a field that is tied to a specific data item.

*LINE ITEM ACTION

(A/U/D)

1
A
The action to be taken on this line.
A = Add this line to the contract

U = Update this line with the data provided in this spreadsheet D = Delete this existing line from the contract. Deleting the product will cause the product to be removed from every price group associated to this contract

*PRODUCT NAME
80
AN
The formal name of the product.
A set of 1 to 3 words that constitutes the distinctive name of the product. Preferred Format is: Noun (space) Descriptor1 (space) Descriptor2. The Noun must be singular. Descriptors must express quality, kind, or condition of the Noun. Abbreviations must NOT be used.
*PRODUCT DESCRIPTION
800
AN
Specifications and details that are not contained in the Product Name but are needed to accurately describe the product.
The description must be a maximum of 800 characters. Abbreviations must NOT be used.
PRODUCT CATEGORY
80
AN
Used by suppliers to group items into specific categories, enabling them to provide discounts based on items in specific categories, when applicable.

PRODUCT TYPE CODE

(G/C/O)

1
A
Identifies the Product Type.
G = General Product

C = Components O = Products with Options Value will default to G, if not provided.

BASE UNIT OF PACK CODE
2
AN
The smallest packaging configuration within the Unit of Sale. The first tie, wrap, or container applied to a single item, or a quantity thereof, or to a group of items of a single part number, preserved or unpreserved, which constitutes a complete or identifiable package.
QTY OF BASE UNIT OF MEASURE
8,3
N
The count of Item UOM Content units contained in the Base Unit of Pack (BUOP).
BASE UNIT OF MEASURE CODE
2
AN
The smallest practical Unit of Measure for the product contained in the Item UOM.

*HAZARDOUS INDICATOR

(Y/N)

1
A
Indicates whether the product is classified as hazardous.
Y = Yes

N = No

*COLD CHAIN CODE

(A/F/R)

1
A
Indicates whether the item must be kept frozen or refrigerated.
A = Ambient (Not a cold chain item)

F = Frozen (Item requires frozen storage) R = Refrigeration (Item requires refrigeration storage)

*CONTROLLED CODE

(0/1/2/3/4/5)

1
A
Indicates whether the product must be stored in a secure area.
0 = NO CONTROL

1 = LSD, HEROIN, MARIJUANA - RESEARCH ONLY

2 = MORPHINE, MEPERIDINE, AMPHETAMINES, ETC., MOST POTENTIAL FOR ABUSE

3 = ASPIRIN/CODEINE, ETC., LESS ABUSED

4 = DIAZEPAM, ETC., POTENTIAL ABUSE

5 = CONTROLLED SALE BY PHARMACY ONLY

Value will default to 0 if not provided.

MINIMUM ORDER QTY
4
N
The minimum number of the Unit of Sale that must be ordered.
Minimum Order Quantity should be equal to or less than the Multiple Order Quantity.

If no minimum order value is required, enter a value of 1.

MULTIPLE ORDER QTY
4
N
The multiplier for ordering greater than the Minimum Ordering Quantity.
The denomination in which the product must be ordered. It is used in conjunction with Minimum Order Quantity. If no multiple order quantity is required, enter a value of 1.
*COUNTRY OF ORIGIN CODE
3
AN
The three position Country Code of the country of origin for the product.
The Country of Origin Code MUST be three (3) characters.

DROP SHIP INDICATOR

(Y/N)

1
A
Indicates whether the product may be drop shipped.
Note: This field is NOT APPLICABLE to ECAT Contracts.

Y = Yes N = No Value will default to N, if not provided.

DROP SHIP FEE INDICATOR

(Y/N)

1
A
Indicates whether there is a fee to drop ship the product.
Note: This field is NOT APPLICABLE to ECAT Contracts.

This field is ONLY used when the Drop Ship Indicator is Y.

Y = Yes N = No Value will default to N, if not provided.

GREEN PRODUCT INDICATOR

(Y/N/U)

1
A
Indicates whether the product is environmentally friendly.
Y = Yes

N = No U = Unknown Value will default to U, if not provided.

*LATEX FREE INDICATOR

(Y/N/U)

1
A
Indicates whether the product is latex free.
Y = Yes

N = No U = Unknown Value will default to U, if not provided.

*SHELF LIFE MONTHS
3
N
Represents the general shelf life (in months) of the item at the time of manufacturing.

Tab 2 - Price Offer Template Fields

Field Name
Length
Type
Definition
Comments
*MANUFACTURER NAME
40
AN
The name of the manufacturer that produces the product.
The combination of the Manufacturer Name, Manufacturer Part Number, Unit of Sale Code and Items Per Unit of Sale Quantity denotes the unique Product Identifier.
*MANUFACTURER PART NUMBER
30
AN
The Original Equipment Manufacturer's (OEM) item number to identify the product.
The combination of the Manufacturer Name, Manufacturer Part Number, Unit of Sale Code and Items Per Unit of Sale Quantity denotes the unique Product Identifier.

If this field is blank, the NDC field MUST be completed.

*NATIONAL DRUG CODE
11
N
The National Drug Code corresponding to the Manufacturer Part Number.
Note: This field applies to Pharmaceutical products only.

The National Drug Code is an 11-digit number identifying human drugs.

If this field is blank, the Manufacturer Part Number field MUST be completed.

SUPPLIER NAME
120
AN
The name of the supplier that provides the product for distribution.
If this column is blank, the assumption is that the contract owner is the supplier. The system will align the supplier part number with the contract owner.
*SUPPLIER PART NUMBER
30
AN
The item number used by you to identify the product.
NATIONAL STOCK NUMBER
13
N
The National Stock Number corresponding to the Part Number.
A National Stock Number is the official label applied to an item of supply that is repeatedly procured, stocked, stored, issued, and used throughout the Federal Supply System.
*UNIT OF SALE CODE
2
AN
The saleable packaging configuration.
The combination of the Manufacturer Name, Manufacturer Part Number, Unit of Sale Code and Items Per Unit of Sale Quantity denotes the unique Product Identifier.
*ITEMS PER UNIT OF SALE QTY
8
N
The count of Base Unit of Pack units within the Unit of Sale.
The combination of the Manufacturer Name, Manufacturer Part Number, Unit of Sale Code and Items Per Unit of Sale Quantity denotes the unique Product Identifier.
INNER PACK CODE
2
AN
The packaging configuration of the Item units contained within the Unit of Sale.
A value is not required; however, if it is completed, then Inner Pack Qty must also be completed.
INNER PACK QTY
8,3
N
The count of Base Unit of Pack units contained in the Inner Packaging.
A value is not required; however, if it is completed, then Inner Pack Code must also be completed.
*TOTAL EACHES
8
N
The smallest Base Unit of Pack units contained in the Unit of Sale.
*PRICE GROUP ID
6
N
The price group ID generated within the application that corresponds to the proposed grouping of products and pricing for a given region, contract/pricing agreement type (i.e., BIG 4, National Contract), or specific DoDAAC(s).
This number MUST correspond to a Price Group that has been saved within the application and associated to this request, prior to importing any spreadsheet data.
*LEAD TIME DAYS
3
N
The maximum number of business days to ship the product from Order Acceptance to arrival of shipment to the customer.
The timeframe begins at Order Acceptance and ends at delivery to the customer.
LINE ITEM NUMBER
12
N
Used as a reference when providing errors for the current request that is being worked. Not a field that is tied to a specific data item.

*LINE ITEM ACTION

(A/U/D)

1
A
The action to be taken on this line.
A = Add this line to the contract

U = Update this existing line on the contract with the data provided in this spreadsheet D = Delete this existing line from the contract

*LIST PRICE
9,2
N
The commercial catalog Unit of Sale price.
*BASE OFFERED UNIT PRICE
9,2
N
Supplier offered price to the DLA for the quantity unit of sale provided. This is considered price level 1 when there are multiple price level options.
All line items must have an offered unit price. For products with multiple prices, the offered unit price is considered price level 1. All subsequent pricing levels must have a preceding pricing level value. DO NOT include the dollar sign ($); also, the value MUST contain two decimal places for cents even on a whole number (i.e., CORRECT = 23.45; INCORRECT = $23.45 or $23 or 23].
VOLUNTARY PRICE REDUCTION (VPR)
9,2
N
This price serves a price override of the offered unit price for the timeframe specified for the regions specified.
This price will exist for a finite timeframe that must start on or after the contract effective date, and end on or before the contract end date. A value is not required; however, if it is completed, then VPR Effective Date & VPR Expiration Date must also be completed.
VPR EFFECTIVE DATE
8
N
The date the VPR will be effective for ordering.
This date must be completed if Voluntary Price Reduction (VPR) is completed.

The date must be formatted as MM/DD/YYYY.

VPR EXPIRATION DATE
8
N
The date the VPR will expire for ordering.
This date must be completed if Voluntary Price Reduction (VPR) is completed.

The date must be formatted as MM/DD/YYYY.

VOLUME DISCOUNT BREAK POINT 1
5
N
The Upper Limit of 1st Break Point.
Enter the value for the quantity where the first discount begins. For example, if a 10% discount is given for ordering 100 or more, enter 100. A value is not required; however, if it is completed, then either Volume Discount Amount 1 or Volume Discount Percentage 1 must also be completed.
VOLUME DISCOUNT AMOUNT 1
9,2
N
The 1st Break Point Discount Amount.
Enter the discounted Unit Price of the first break point. For example, if the base price is 10.00 and a 10% discount is offered if 100 or more are ordered, then enter 9.00 as the Discount Amount. DO NOT include the dollar sign ($). Also, the value MUST contain two decimal places for cents even on a whole number. This field MUST NOT be completed if using Volume Discount Percentage 1.
VOLUME DISCOUNT PERCENTAGE 1
5
N
The 1st Break Point Discount Percentage.
Enter the Percentage Discount of the first break point. For example, if the base price is 10.00 and a 10% discount is offered if 100 or more are ordered, then enter 10 as the Discount Percentage. DO NOT include the percentage sign (%). This field MUST NOT be completed if using Volume Discount Amount 1.
VOLUME DISCOUNT BREAK POINT 2
5
N
The Upper Limit of 2nd Break Point.
Enter the value for the quantity where the second discount begins. For example, if a 12% discount is given for ordering 200 or more, enter 200. A value is not required; however, if it is completed, then either Volume Discount Amount 2 or Volume Discount Percentage 2 must also be completed.
VOLUME DISCOUNT AMOUNT 2
9,2
N
The 2nd Break Point Discount Amount.
Enter the discounted Unit Price of the second break point. For example, if the base price is 10.00 and a 12% discount is offered if 200 or more are ordered, then enter 8.80 as the Discount Amount. DO NOT include the dollar sign ($). Also, the value MUST contain two decimal places for cents even on a whole number. This field MUST NOT be completed if using Volume Discount Percentage 2.
VOLUME DISCOUNT PERCENTAGE 2
5
N
The 2nd Break Point Discount Percentage.
Enter the Percentage Discount of the second break point. For example, if the base price is 10.00 and a 12% discount is offered if 200 or more are ordered, then enter 12 as the Discount Percentage. DO NOT include the percentage sign (%). This field MUST NOT be completed if using Volume Discount Amount 2.
VOLUME DISCOUNT BREAK POINT 3
5
N
The Upper Limit of 3rd Break Point.
Enter the value for the quantity where the third discount begins. For example, if a 15% discount is given for ordering 300 or more, enter 300. A value is not required; however, if it is completed, then either Volume Discount Amount 3 or Volume Discount Percentage 3 must also be completed.
VOLUME DISCOUNT AMOUNT 3
9,2
N
The 3rd Break Point Discount Amount.
Enter the discounted Unit Price of the third break point. For example, if the base price is 10.00 and a 15% discount is offered if 300 or more are ordered, then enter 8.50 as the Discount Amount. DO NOT include the dollar sign ($). Also, the value MUST contain two decimal places for cents even on a whole number. This field MUST NOT be completed if using Volume Discount Percentage 3.
VOLUME DISCOUNT PERCENTAGE 3
5
N
The 3rd Break Point Discount Percentage.
Enter the discounted Percentage of the third break point. For example, if the base price is 10.00 and a 15% discount is offered if 300 or more are ordered, then enter 15 as the Discount Percentage. DO NOT include the percentage sign (%). This field MUST NOT be completed if using Volume Discount Amount 3.
VOLUME DISCOUNT BREAK POINT 4
5
N
The Upper Limit of 4th Break Point.
Enter the value for the quantity where the fourth discount begins. For example, if a 20% discount is given for ordering 400 or more, enter 400. A value is not required; however, if it is completed, then either Volume Discount Amount 4 or Volume Discount Percentage 4 must also be completed.
VOLUME DISCOUNT AMOUNT 4
9,2
N
The 4th Break Point Discount Amount.
Enter the discounted Unit Price of the fourth break point. For example, if the base price is 10.00 and a 20% discount is offered if 400 or more are ordered, then enter 8.00 as the Discount Amount. DO NOT include the dollar sign ($). Also, the value MUST contain two decimal places for cents even on a whole number. This field MUST NOT be completed if using Volume Discount Percentage 4.
VOLUME DISCOUNT PERCENTAGE 4
5
N
The 4th Break Point Discount Percentage.
Enter the discounted Percentage of the fourth break point. For example, if the base price is 10.00 and a 20% discount is offered if 400 or more are ordered, then enter 20 as the Discount Percentage. DO NOT include the percentage sign (%). This field MUST NOT be completed if using Volume Discount Amount 4.
COMPARISON PRICE 1
9,2
N
The first comparison price for this product.
A value is not required; however, if it is completed, then both Comparison Price 1 Name and Comparison Price 1 Type must also be completed.
COMPARISON PRICE 1 NAME
30
AN
The description for Comparison Price 1.
A value is only required when Comparison Price 1 is completed.
COMPARISON PRICE 1 TYPE
6
AN
The type of comparison price for Comparison Price 1.
A value is only required when Comparison Price 1 is completed.

MFC = Most Favored Customer price MSC = Most Similar Customer price OGP = Other Government Pricing from any other government source EQFSS = VA FSS Price, according to the supplier SCM = DAPA Holder Sells the Item Commercially; price offered is best price available given similar terms NSCM = Item is a Commercial Item, but is Not Sold Commercially by the DAPA Holder; price offered is best price available given similar terms SCPK = DAPA Holder Sells PrePak or Similar PrePaks Commercially; price offered is best price available given similar terms NSCPK = Component Items are Commercial, but PrePak is Not Sold Commercially by DAPA Holder; price offered is best price available given similar terms

COMPARISON PRICE 2
9,2
N
The second comparison price for this product.
A value is not required; however, if it is completed, then both Comparison Price 2 Name and Comparison Price 2 Type must also be completed.
COMPARISON PRICE 2 NAME
30
AN
The description for Comparison Price 2.
A value is only required when Comparison Price 2 is completed.
COMPARISON PRICE 2 TYPE
6
AN
The type of comparison price for Comparison Price 2.
A value is only required when Comparison Price 2 is completed.

Refer to Comparison Price 1 Type for allowable values and descriptions.

COMPARISON PRICE 3
9,2
N
The third comparison price for this product.
A value is not required; however, if it is completed, then both Comparison Price 3 Name and Comparison Price 3 Type must also be completed.
COMPARISON PRICE 3 NAME
30
AN
The description for Comparison Price 3.
A value is only required when Comparison Price 3 is completed.
COMPARISON PRICE 3 TYPE
6
AN
The type of comparison price for Comparison Price 3.
A value is only required when Comparison Price 3 is completed.

Refer to Comparison Price 1 Type for allowable values and descriptions.

GTIN
14
N
The Global Trade Item Number corresponding to the Part Number.
Note: This field applies to Medical/Surgical products only.
LENGTH UOM CODE
2
AN
The Length Unit of Measure Code of the Unit of Sale.
Length UOM Code, Width UOM Code, and Height UOM Code must ALL have the SAME value.
LENGTH
5,3
N
The Length dimension of the Unit of Sale.
WIDTH UOM CODE
2
AN
The Width Unit of Measure Code of the Unit of Sale.
Length UOM Code, Width UOM Code, and Height UOM Code must ALL have the SAME value.
WIDTH
5,3
N
The Width dimension of the Unit of Sale.
HEIGHT UOM CODE
2
AN
The Height Unit of Measure Code of the Unit of Sale.
Length UOM Code, Width UOM Code, and Height UOM Code must ALL have the SAME value.
HEIGHT
5,3
N
The Height dimension of the Unit of Sale.
GROSS WEIGHT UOM CODE
2
AN
The Gross Weight Unit of Measure Code of the Unit of Sale.
GROSS WEIGHT
5,3
N
The Gross Weight of the Unit of Sale.
Unit of Sale Code
Description
01
Actual Pounds
02
Statute Mile
03
Seconds
04
Small Spray
05
Lifts
08
Heat Lots
10
Group
11
Outfit
12
Packet
13
Ration
14
Shot
15
Stick
16
115 Kilogram Drum
17
100 Pound Drum
18
55 Gallon Drum
19
Tank Truck
1A
Car Mile
1B
Car Count
1C
Locomotive Count
1D
Caboose Count
1E
Empty Car
1F
Train Mile
1G
Fuel Usage (Gallons)
1H
Caboose Mile
1I
Fixed Rate
1J
Ton Miles
1K
Locomotive Mile
1L
Total Car Count
1M
Total Car Mile
1X
Quarter Mile
20
20 Foot Container
21
40 Foot Container
22
Deciliter per Gram
23
Grams per Cubic Centimeter
24
Theoretical Pounds
25
Grams per Square Centimeter
26
Actual Tons
27
Theoretical Tons
28
Kilograms per Square Meter
29
Pounds per 1000 Square Feet
2A
Radians Per Second
2B
Radians Per Second Squared
2C
Roentgen
2F
Volts Per Meter
2G
Volts (Alternating Current)
2H
Volts (Direct Current)
2I
British Thermal Units (BTUs) Per Hour
2J
Cubic Centimeters Per Second
Unit of Sale Code
Description
2K
Cubic Feet Per Hour
2L
Cubic Feet Per Minute
2M
Centimeters Per Second
2N
Decibels
2P
Kilobyte
2Q
Kilobecquerel
2R
Kilocurie
2U
Megagram
2V
Megagrams Per Hour
2W
Bin
2X
Meters Per Minute
2Y
Milliroentgen
2Z
Millivolts
30
Horsepower Days per Air Dry Metric Tons
31
Catchweight
32
Kilograms per Air Dry Metric Tons
33
Kilopascal Square Meters per Gram
34
Kilopascals per Millimeter
35
Milliliters per Square Centimeter Second
36
Cubic Feet per Minute per Square Foot
37
Ounces per Square Foot
38
Ounces per Square Foot per 0.01 Inch
39
Poise
3A
Netwon
3B
Megajoule
3C
Manmonth
40
Milliliter per Second
41
Milliliter per Minute
43
Super Bulk Bag
44
500 Kilogram Bulk Bag
45
300 Kilogram Bulk Bag
46
25 Kilogram Bulk Bag
47
50 Pound Bag
48
Bulk Car Load
4A
Bobbin
4B
Cap
4C
Centistokes
4D
Curie
4E
20-Pack
4F
100-Pack
4G
Microliter
4H
Micrometer
4I
Meters Per Second
4J
Meters Per Second Per Second
4K
Milliamperes
4L
Megabyte
Unit of Sale Code
Description
4M
Milligrams Per Hour
4N
Megabecquerel
4O
Microfarad
4P
Newtons Per Meter
4Q
Ounce Inch
4R
Ounce Foot
4S
Pascal
4T
Picofarad
4U
Pounds Per Hour
50
Actual Kilograms
51
Actual Tonnes
53
Theoretical Kilograms
54
Theoretical Tonnes
56
Sitas
58
Net Kilograms
59
Parts Per Million
60
Percent Weight
61
Parts Per Billion
62
Percent Per 1000 Hours
63
Failure Rate in Time
64
Pounds Per Square Inch Gauge
65
Coulomb
66
Oersteds
67
Siemens
68
Ampere
69
Test Specific Scale
70
Volt
71
Volt-Ampere Per Pound
72
Watts Per Pound
73
Ampere Turn Per Centimeter
74
Milli Pascals
75
Cycles
76
Gauss
77
Mil
78
Kilogauss
79
Electron Volt
80
Pounds Per Square Inch Absolute
81
Henry
82
Ohm
83
Farad
84
Kilo Pounds Per Square Inch (KSI)
85
Foot Pounds
86
Joules
87
Pounds per Cubic Foot
89
Poise
90
Saybold Universal Second
91
Stokes
92
Calories per Cubic Centimeter
Unit of Sale Code
Description
93
Calories per Gram
94
Curl Units
95
20,000 Gallon Tankcar
96
10,000 Gallon Tankcar
97
10 Kilogram Drum
98
15 Kilogram Drum
A8
Dollars per Hours
A9
Rate
AA
Ball
AB
Bulk Pack
AC
Acre
AD
Bytes
AE
Amperes per Meter
AF
Centigram
AH
Additonal Minutes
AI
Average Minutes Per Call
AJ
Cop
AK
Fathom
AL
Access Lines
AM
Ampoule
AN
Minutes or Messages
AP
Aluminum Pounds Only
AQ
Anit-hemophilic Factor (AHF) Units
AR
Suppository
AS
Assortment
AT
Atmosphere
AU
Ocular Insert System
AV
Capsule
AW
Powder-Filled Vials
AX
Twenty
AY
Assembly
AZ
British Thermal Units (BTUs) per Pound
B0
British Thermal Units (BTUs) per Cubic Foot
B1
Barrels per Day
B2
Bunks
B3
Batting Pound
B4
Barrel, Imperial
B5
Billet
B6
Bun
B7
Cycles
B8
Board
B9
Batt
BA
Bale
BB
Base Box
BC
Bucket
BD
Bundle
BE
Beam
Unit of Sale Code
Description
BF
Board Feet
BG
Bag
BH
Brush
BI
Bar
BJ
Band
BK
Book
BL
Block
BM
Bolt
BN
Bulk
BO
Bottle
BP
100 Board Feet
BQ
Brake horse power
BR
Barrel
BS
Basket
BT
Belt
BU
Bushel
BV
Bushel, Dry Imperial
BW
Base Weight
BX
Box
BY
British Thermal Unit (BTU)
BZ
Million BTU's
C0
Calls
C1
Composite Product Pounds (Total Weight)
C2
Carset
C3
Centiliter
C4
Carload
C5
Cost
C6
Cell
C7
Centipoise (CPS)
C8
Cubic Decimeter
C9
Coil Group
CA
Case
CB
Carboy
CC
Cubic Centimeter
CD
Carat
CE
Centigrade, Celsius
CF
Cubic Feet
CG
Card
CH
Container
CI
Cubic Inches
CJ
Cone
CK
Connector
CL
Cylinder
CM
Centimeter
CN
Can
CO
Cubic Meters (Net)
CP
Crate
Unit of Sale Code
Description
CQ
Cartridge
CR
Cubic Meter
CS
Cassette
CT
Carton
CU
Cup
CV
Cover
CW
Hundred Pounds (CWT)
CX
Coil
CY
Cubic Yard
CZ
Combo
D3
Square Decimeter
D8
Draize Score
D9
Dyne per Square Centimeter
DA
Days
DB
Dry Pounds
DC
Disk (Disc)
DD
Degree
DE
Deal
DF
Dram
DG
Decigram
DH
Miles
DI
Dispenser
DJ
Decagram
DK
Kilometers
DL
Deciliter
DM
Decimeter
DO
Dollars, U.S.
DP
Dozen Pair
DQ
Data Records
DR
Drum
DS
Display
DT
Dry Ton
DU
Dyne
DY
Directory Books
DZ
Dozen
E1
Hectometer
E3
Inches, Fraction--Average
E4
Inches, Fraction--Minimum
E5
Inches, Fraction--Actual
E7
Inches, Decimal--Average
E8
Inches, Decimal--Actual
E9
English, (Feet, Inches)
EA
Each
EB
Electronic Mail Boxes
EC
Each per Month
ED
Inches, Decimal--Nominal
EF
Inches, Fraction-Nominal
EM
Inches, Decimal-Minimum
Unit of Sale Code
Description
EP
Eleven pack
EQ
Equivalent Gallons
EV
Envelope
EX
Feet, Inches and Fraction
EY
Feet, Inches and Decimal
EZ
Feet and Decimal
F1
Thousand Cubic Feet Per Day
F9
Fibers per Cubic Centimeter of Air
FA
Fahrenheit
FB
Fields
FC
1000 Cubic Feet
FD
Million Particles per Cubic Foot
FE
Track Foot
FF
Hundred Cubic Meters
FG
Transdermal Patch
FH
Micromolar
FL
Flake Ton
FM
Million Cubic Feet
FO
Fluid Ounce
FP
Pounds per Sq. Ft.
FR
Feet Per Minute
FS
Feet Per Second
FT
Foot
FZ
Fluid Ounce (Imperial)
G2
U.S. Gallons Per Minute
G3
Imperial Gallons Per Minute
G4
Gigabecquerel
G5
Gill (Imperial)
G7
Microfiche Sheet
GA
Gallon
GB
Gallons/Day
GC
Grams per 100 Grams
GD
Gross Barrels
GE
Pounds per Gallon
GF
Grams per 100 Centimeters
GG
Great Gross (Dozen Gross)
GH
Half Gallon
GI
Imperial Gallons
GJ
Grams per Milliliter
GK
Grams per Kilogram
GL
Grams per Liter
GM
Grams per Sq. Meter
GN
Gross Gallons
GO
Milligrams per Square Meter
GP
Milligrams per Cubic Meter
GQ
Micrograms per Cubic Meter
GR
Gram
Unit of Sale Code
Description
GS
Gross
GT
Gross Kilogram
GV
Gigajoules
GW
Gallons Per Thousand Cubic Feet
GX
Grain
GY
Gross Yard
GZ
Gage Systems
H1
Half Pages - Electronic
H2
Half Liter
H4
Hectoliter
HA
Hank
HB
Hundred Boxes
HC
Hundred Count
HD
Half Dozen
HE
Hundredth of a Carat
HF
Hundred Feet
HG
Hectogram
HH
Hundred Cubic Feet
HI
Hundred Sheets
HJ
Horsepower
HK
Hundred Kilograms
HL
Hundred Feet - Linear
HM
Miles Per Hour
HN
Millimeters of Mercury
HO
Hundred Troy Ounces
HR
Hours
HS
Hundred Square Feet
HT
Half Hour
HU
Hundred
HV
Hundred Weight (Short)
HW
Hundred Weight (Long)
HY
Hundred Yards
HZ
Hertz
IA
Inch Pound
IB
Inches Per Second (Vibraion Velocity)
IC
Counts per Inch
IE
Person
IF
Inches of Water
II
Column-Inches
IL
Inches per Minute
IM
Impressions
IN
Inch
IP
Insurance Policy
IT
Counts per Centimeter
IU
Inches Per Second (Linear Speed)
IV
Inches Per Second Per Second (Acceleration)
Unit of Sale Code
Description
IW
Inches Per Second Per Second (Vibration Acceleration)
J2
Joule Per Kilogram
JB
Jumbo
JE
Joule Per Kelvin
JG
Joule Per Gram
JK
Mega Joule per Kilogram
JM
Megajoule/Cubic Meter
JO
Joint
JR
Jar
JU
Jug
K1
Kilowatt Demand
K2
Kilovolt Amperes Reactive Demand
K3
Kilovolt Amperes Reactive Hour
K4
Kilovolt Amperes
K5
Kilovolt Amperes Reactive
K6
Kiloliter
K7
Kilowatt
KA
Cake
KB
Kilocharacters
KC
Kilograms per Cubic Meter
KD
Kilograms Decimal
KE
Keg
KF
Kilopackets
KG
Kilogram
KH
Kilowatt Hour
KI
Kilograms/Millimeter Width
KJ
Kilosegments
KK
100 Kilograms
KL
Kilograms/Meter
KM
Kilograms per Square Meter, Kilograms,Decimal
KN
Kilometer
KO
Millequivalence Caustic Potash per Gram of Product
KP
Kilometers Per Hour
KQ
Kilopascal
KR
Kiloroentgen
KT
Kit
KV
Kelvin
KW
Kilograms per Millimeter
KX
Milliliters per Kilogram
L2
Liters Per Minute
LA
Pounds Per Cubic Inch
LB
Pound
LC
Linear Centimeter
LD
Liters Per Day
LE
Lite
Unit of Sale Code
Description
LF
Linear Foot
LG
Long Ton
LH
Labor Hours
LI
Linear Inch
LJ
Large Spray
LK
Link
LM
Linear Meter
LN
Length
LO
Lot
LP
Liquid Pounds
LQ
Liters Per Day
LR
Layer(s)
LS
Lump Sum
LT
Liter
LX
Linear Yards Per Pound
LY
Linear Yard
M0
Magnetic Tapes
M1
Milligrams per Liter
M2
Millimeter - Actual
M3
Mat
M4
Monetary Value
M5
Microcurie
M6
Millibar
M7
Micro Inch
M8
Mega Pascals
M9
Million British Thermal Units per One Thousand Cubic Feet
MA
Machine/Unit
MB
Millimeter - Nominal
MC
Microgram
MD
Air Dry Metric Ton
ME
Milligram
MF
Milligram per Sq. Ft. per Side
MG
Metric Gross Ton
MH
Microns
MI
Metric
MJ
Minutes
MK
Milligrams Per Square Inch
ML
Milliliter
MM
Millimeter
MN
Metric Net Ton
MO
Months
MP
Metric Ton
MQ
1000 Meters
MR
Meter
MS
Square Millimeter
MT
Metric Long Ton
MU
Millicurie
Unit of Sale Code
Description
MV
Number of Mults
MW
Metric Ton Kilograms
MX
Mixed
MY
Millimeter - Average
MZ
Millimeter - minimum
N1
Pen Calories
N2
Number of Lines
N3
Print Point
N4
Pen Grams (Protein)
NA
Milligrams per Kilogram
NB
Barge
NC
Car
ND
Net Barrels
NE
Net Liters
NF
Messages
NG
Net Gallons
NH
Message Hours
NI
Net Imperial Gallons
NJ
Number of Screens
NL
Load
NM
Nautical Mile
NN
Train
NQ
Mho
NR
Micro Mho
NS
Short Ton
NT
Trailer
NV
Vehicle
NW
Newton
NX
Parts Per Thousand
NY
Pounds Per Air-Dry Metric Ton
OA
Panel
ON
Ounces per Square Yard
OP
Two pack
OT
Overtime Hours
OZ
Ounce - Av
P0
Pages - Electronic
P1
Percent
P2
Pounds per Foot
P3
Three pack
P4
Four-pack
P5
Five-pack
P6
Six pack
P7
Seven pack
P8
Eight-pack
P9
Nine pack
PA
Pail
PB
Pair Inches
Unit of Sale Code
Description
PC
Piece
PD
Pad
PE
Pounds Equivalent
PF
Pallet (Lift)
PG
Pounds Gross
PH
Pack (PAK)
PI
Pitch
PJ
Pounds, Decimal - Pounds per Square Foot - Pound Gage
PK
Package
PL
Pallet/Unit Load
PM
Pounds - Percentage
PN
Pounds Net
PO
Pounds per Inch of Length
PP
Plate
PQ
Pages per Inch
PR
Pair
PS
Pounds per Sq. Inch
PT
Pint
PU
Mass Pounds
PV
Half Pint
PW
Pounds per Inch of Width
PX
Pint, Imperial
PY
Peck, Dry U.S.
PZ
Peck, Dry Imperial
Q1
Quarter (Time)
Q2
Pint U.S. Dry
Q3
Meal
Q4
Fifty
Q5
Twenty-Five
Q6
Thrity-Six
Q7
Twenty-Four
QA
Pages - Facsimile
QB
Pages - Hardcopy
QD
Quarter Dozen
QH
Quarter Hours
QK
Quarter Kilogram
QR
Quire
QS
Quart, Dry U.S.
QT
Quart
QU
Quart, Imperial
R1
Pica
R2
Becquerel
R3
Revolutions Per Minute
R4
Calorie
R5
Thousands of Dollars
R6
Millions of Dollars
R7
Billions of Dollars
Unit of Sale Code
Description
R9
Thousand Cubic Meters
RA
Rack
RD
Rod
RE
Reel
RG
Ring
RK
Roll-Metric Measure
RL
Roll
RM
Ream
RN
Ream- Metric Measure
RO
Round
RP
Pounds per Ream
RS
Resets
RT
Revenue Ton Miles
RU
Run
S2
Seconds (time)
S3
Square Feet per Second
S4
Square Meters per Second
S6
Sessions
S7
Storage Units
S8
Standard Advertising Units (SAUs)
S9
Slip Sheet
SA
Sandwich
SB
Square Mile
SC
Square Centimeter
SD
Solid Pounds
SE
Section
SF
Square Foot
SG
Segment
SH
Sheet
SI
Square Inch
SJ
Sack
SK
Split Tanktruck
SL
Sleeve
SM
Square Meter
SN
Square Rod
SO
Spool
SP
Shelf Package
SQ
Square
SR
Strip
SS
Sheet-Metric Measure
ST
Set
SU
Short Ton
SV
Skid
SW
Skein
SX
Shipment
SY
Square Yard
T0
Telecommunications Lines in Service
Unit of Sale Code
Description
T1
Thousand pounds gross
T2
Thousandths of an Inch
T3
Thousand Pieces
T4
Thousand Bags
T5
Thousand Casings
T6
Thousand Gallons
T7
Thousand Impressions
T8
Thousand Linear Inches
T9
Thousand Kilowatt Hours
TA
Tenth Cubic Foot
TB
Tube
TC
Truckload
TD
Thems
TE
Tote
TF
Ten Square Yards
TG
Gross Ton
TH
Thousand
TI
Thousand Square Inches
TJ
Thousand Sq. Centimeters
TK
Tank
TL
Thousand Feet (Linear)
TM
Thousand Feet (Board)
TN
Net Ton (2,000 LB)
TO
Troy Ounce
TP
Ten-pack
TQ
Thousand Feet
TR
Ten Square Feet
TS
Thousand Square Feet
TT
Thousand Linear Meters
TU
Thousand Linear Yards
TV
Thousand Kilograms
TW
Thousand Sheets
TX
Troy Pound
TY
Tray
TZ
Thousand Cubic Feet
U2
Tablet
U3
Ten
U5
Two Hundred Fifty
UA
Ton
UB
Telecommunications Lines in Service - Average
UC
Telecommunications Ports
UD
Tenth Minutes
UE
Tenth Hours
UF
Usage per Telecommunications Line - Average
UH
Ten Thousand Yards
UM
Million Units
Unit of Sale Code
Description
UN
Unit
VA
Voltampere per Kilogram
VC
Five Hundred
VI
Vial
VS
Visit
VT
Voltage
W2
Wet Kilo
WA
Watts per Kilogram
WB
Wet Pound
WE
Wet Ton
WG
Wine Gallon
WH
Wheel
WI
Weight per Square Inch
WK
Week
WM
Working Months
WP
Pennyweight
WR
Wrap
WT
Wattage
WU
Wattage Hours
WW
Milliliters of Water
X1
Chains (Land Survey)
YD
Yard
YL
100 Lineal Yards
YR
Years
YT
Ten Yards
ZZ
Mutually Defined
CODE
COUNTRY
AFG
AFGHANISTAN
ALA
ALAND ISLANDS
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
BHR
BAHRAIN
BGD
BANGLADESH
BRB
BARBADOS
BLR
BELARUS
BEL
BELGIUM
BLZ
BELIZE
BEN
BENIN
BMU
BERMUDA
BTN
BHUTAN
BOL
BOLIVIA
BIH
BOSNIA AND HERZEGOVINA
BWA
BOTSWANA
BVT
BOUVET ISLAND
BRA
BRAZIL
IOT
BRITISH INDIAN OCEAN TERRITORY
BRN
BRUNEI DARUSSALAM
BGR
BULGARIA
BFA
BURKINA FASO
BDI
BURUNDI
KHM
CAMBODIA
CMR
CAMEROON
CAN
CANADA
CPV
CAPE VERDE
CYM
CAYMAN ISLANDS
CAF
CENTRAL AFRICAN REPUBLIC
TCD
CHAD
CHL
CHILE
CHN
CHINA
CXR
CHRISTMAS ISLAND
CCK
COCOS (KEELING) ISLANDS
COL
COLOMBIA
COM
COMOROS
COG
CONGO, REPUBLIC OF
COD
CONGO, THE DEMOCRATIC REPUBLIC OF THE
COK
COOK ISLANDS
CRI
COSTA RICA
CIV
COTE D'IVOIRE
HRV
CROATIA
CUB
CUBA
CYP
CYPRUS
CZE
CZECH REPUBLIC
DNK
DENMARK
DJI
DJIBOUTI
DMA
DOMINICA
DOM
DOMINICAN REPUBLIC
ECU
ECUADOR
EGY
EGYPT
SLV
EL SALVADOR
GNQ
EQUATORIAL GUINEA
ERI
ERITREA
EST
ESTONIA
ETH
ETHIOPIA
FRO
FAEROE ISLANDS
FLK
FALKLAND ISLANDS
FJI
FIJI
FIN
FINLAND
FRA
FRANCE
GUF
FRENCH GUIANA
PYF
FRENCH POLYNESIA
ATF
FRENCH SOUTHERN TERRITORIES
GAB
GABON
GMB
GAMBIA
GEO
GEORGIA
DEU
GERMANY
GHA
GHANA
GIB
GIBRALTAR
GBR
GREAT BRITAIN
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
HND
HONDURAS
HKG
HONG KONG
HUN
HUNGARY
ISL
ICELAND
IND
INDIA
IDN
INDONESIA
IRN
IRAN
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
XKX
KOSOVO
KWT
KUWAIT
KGZ
KYRGYZSTAN
LAO
LAO PEOPLE'S DEMOCRATIC REPUBLIC
LVA
LATVIA
LBN
LEBANON
LSO
LESOTHO
LBR
LIBERIA
LBY
LIBYA
LIE
LIECHTENSTEIN
LTU
LITHUANIA
LUX
LUXEMBOURG
MAC
MACAO
MKD
MACEDONIA
MDG
MADAGASCAR
MWI
MALAWI
MYS
MALAYSIA
MDV
MALDIVES
MLI
MALI
MLT
MALTA
MHL
MARSHALL ISLANDS
MTQ
MARTINIQUE
MRT
MAURITANIA
MUS
MAURITIUS
MYT
MAYOTTE
MEX
MEXICO
FSM
MICRONESIA
MDA
MOLDOVA
MCO
MONACO
MNG
MONGOLIA
MNE
MONTENEGRO
MSR
MONTSERRAT
MAR
MOROCCO
MOZ
MOZAMBIQUE
MMR
MYANMAR
NAM
NAMIBIA
NRU
NAURU
NPL
NEPAL
NLD
NETHERLANDS
ANT
NETHERLANDS ANTILLES
NCL
NEW CALEDONIA
NZL
NEW ZEALAND
NIC
NICARAGUA
NER
NIGER
NGA
NIGERIA
NIU
NIUE
NFK
NORFOLK ISLAND
PRK
NORTH KOREA
MNP
NORTHERN MARIANA ISLANDS
NOR
NORWAY
OMN
OMAN
PAK
PAKISTAN
PLW
PALAU
PSE
PALESTINIAN TERRITORIES
PAN
PANAMA
PNG
PAPUA NEW GUINEA
PRY
PARAGUAY
PER
PERU
PHL
PHILIPPINES
PCN
PITCAIRN
POL
POLAND
PRT
PORTUGAL
PRI
PUERTO RICO
QAT
QATAR
REU
REUNION
ROU
ROMANIA
RUS
RUSSIAN FEDERATION
RWA
RWANDA
BLM
SAINT BARTHELEMY
SHN
SAINT HELENA
KNA
SAINT KITTS AND NEVIS
LCA
SAINT LUCIA
MAF
SAINT MARTIN
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
SVK
SLOVAKIA
SVN
SLOVENIA
SLB
SOLOMON ISLANDS
SOM
SOMALIA
ZAF
SOUTH AFRICA
SGS
SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS
KOR
SOUTH KOREA
ESP
SPAIN
LKA
SRI LANKA
SDN
SUDAN
SUR
SURINAME
SJM
SVALBARD AND JAN MAYEN
SWZ
SWAZILAND
SWE
SWEDEN
CHE
SWITZERLAND
SYR
SYRIAN ARAB REPUBLIC
TWN
TAIWAN
TJK
TAJIKISTAN
TZA
TANZANIA
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
TUV
TUVALU
UGA
UGANDA
UKR
UKRAINE
ARE
UNITED ARAB EMIRATES
USA
UNITED STATES
UMI
UNITED STATES MINOR OUTLYING ISLANDS
URY
URUGUAY
UZB
UZBEKISTAN
VUT
VANUATU
VAT
VATICAN CITY
VEN
VENEZUELA
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

File details come from the government source that posted it. Updated .