Attach I - ECAT Loader.xlsx

XLSX spreadsheet 42 KB Posted Jul 14, 2023

Attached to: Laboratory Reagents Federal contract opportunity
Solicitation number: SPE2DS-23-R-0001
Issued by: Defense Logistics Agency Troop Support Subsistence

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains an item master template for a federal supply schedule contract solicitation. The template lists fields for suppliers to provide pricing and product details for laboratory reagents and consumables required by the Defense Logistics Agency Troop Support Subsistence. Mandatory fields include manufacturer name and part number to identify each product, unit of sale code, items per unit, hazardous handling information if applicable, pricing at various volume levels, and comparison data from other government contracts. Optional fields request additional product specifications, packaging details, and lead times. The template aims to collect comprehensive item and pricing data to support the Laboratory Reagents solicitation numbered SPE2DS-23-R-0001 seeking to establish contracts for these products.

View the file

Other files for this federal contract opportunity

Other files attached to Laboratory Reagents, newest first.
File	Type	Posted
Attach I - ECAT Loader 27 Jul 2023.xlsx	XLSX spreadsheet	Jul 27, 2023
Final QnA for SPE2DS-23-R-0001.pdf	PDF	Jul 27, 2023
SPE2DS-23-R-0001-0001.pdf	PDF	Jul 27, 2023
JA Reagent_Redacted.pdf	PDF	Jul 14, 2023
Attach IV_Supplier ECAT Order Management User Guide.pdf	PDF	Jul 14, 2023
Attach VII_ AIR20922 Commercial Customs Waiver.pdf	PDF	Jul 14, 2023
Attach II_ECAT Catalog Schema.pdf	PDF	Jul 14, 2023
SPE2DS23R0001.pdf	PDF	Jul 14, 2023
Attach III_ECAT RegistrationGuide.pdf	PDF	Jul 14, 2023
Attach VI_Acronym Definitions.pdf	PDF	Jul 14, 2023
Attach V_Exchange Rate Revision Schedule.xlsx	XLSX spreadsheet	Jul 14, 2023

Show all 11

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.

Vendor Item Data

	Lot #	Manufacturer Name	Manufacturer Part Number	Supplier Name	Supplier Part Number	Product Analyzer	Product Name	*Product Description	*Hazardous Indicator (Y/N)	Hazardous Special Handling Code	*Cold Chain Code (A/F/R)	*Controlled Code
(0/1/2/3/4/5)	*Country Of Origin Code	*Latex Free Indicator
(Y/N/U)	*Shelf-life Months (at time of manufacturing)	*Manufacturer Guaranteed minimum Shelf-Life months (at delivery)	Unit Of Sale Code	*Items Per Unit Of Sale Qty	Inner Pack Code	Inner Pack Qty	*Total Eaches	Lead Time Days	QTY Ordered the previous 12 Months	*List Unit Price (commercial catalog Unit of Sale price)	*Base Offered Unit Price (excluding delivery)	*FOB Destination Unit Price (inclusive of delivery to USAMMC-SWA)	*Pricing Support Unit Price	*Type Pricing Support Provided (Offeror Catalog, Offeror Invoice, OM Catalog, OM Invoice, or OM Terms of Sale)	Notes	Volume Discount Break Point 1	Volume Discount Amount 1	Volume Discount Percentage 1	Volume Discount Break Point 2	Volume Discount Amount 2	Volume Discount Percentage 2	Volume Discount Break Point 3
	1	ABAXIS	400-0024			Piccolo Xpress/Blood Chemistry
Analyzer	PANEL BASIC METAB 10S												PG					5	30
	1	ABAXIS	07P02-09			Piccolo Xpress/Blood Chemistry
Analyzer	Piccolo® Kidney Check Panel												PG					5	54
	1	ABAXIS	400-0030			Piccolo Xpress/Blood Chemistry
Analyzer	PANEL LIPID PLUS 10S												BX					5	100
	1	Abaxis	400-0003			Piccolo Xpress/Blood Chemistry
Analyzer	Liver Panel +												BX					5	100
	1	Abaxis	400-0027			Piccolo Xpress/Blood Chemistry
Analyzer	Renal Function Panel												BX					5	317
	1	Abaxis	400-0029			Piccolo Xpress/Blood Chemistry
Analyzer	General Chemistry 13												BX					5	500
	1	Abaxis	400-0037			Piccolo Xpress/Blood Chemistry
Analyzer	Metlac 12 Panel												BX					5	500
	1	Abaxis	11009131E			Piccolo Xpress/Blood Chemistry
Analyzer	Chemistry Control LvL 1												BX					5	500
	1	Abaxis	11009132E			Piccolo Xpress/Blood Chemistry
Analyzer	Chemistry Control LvL 2												BX					5	500
	2	ABBOTT LABS	02R2901			i-STAT Point of Care Analyzer	Total ß-hCG Control Lv 1												BX				5	3
	2	ABBOTT LABS	02R2902			i-STAT Point of Care Analyzer	Total ß-hCG Control Lv 2												EA				5	4
	2	ABBOTT LABS	02R2903			i-STAT Point of Care Analyzer	Total ß-hCG Control Lv 3												PG				5	4
	2	ABBOTT LABS	02R2901			i-STAT Point of Care Analyzer	cTnI Calibration Verification 1-3												PG				5	6
	2	ABBOTT LABS	03P8325			i-STAT Point of Care Analyzer	REAGENT ANALYZER GLUCOSE CARTRIDGE F/ I STAT												PG				5	8
	2	ABBOTT LABS	03P8550			i-STAT Point of Care Analyzer	CG4+												PG				5	11
	2	ABBOTT LABS	05P71-01			i-STAT Point of Care Analyzer	CONTROL BLOOD CHEMIST												PG				5	14
	2	ABBOTT LABS	06F14-01			i-STAT Point of Care Analyzer	CONTROL BLOOD CHEMIST												PG				5	18
	2	ABBOTT LABS	06P17-03			i-STAT Point of Care Analyzer	CTRL ISTAT LEV3 1ML 6S												BX				5	18
	2	ABBOTT LABS	06F15-01			i-STAT Point of Care Analyzer	REF STD KIT BLD CHEM												PG				5	22
	2	ABBOTT LABS	03P78-50			i-STAT Point of Care Analyzer	TEST PACK PH PARTIAL												PG				5	29
	2	ABBOTT LABS	03P84-25			i-STAT Point of Care Analyzer	TEST CARTRIDGE CREATI												BX				5	36
	2	ABBOTT LABS	03P83-25			i-STAT Point of Care Analyzer	TEST CARTRIDGE GLUCOS												PG				5	38
	2	ABBOTT LABS	03P80-25			i-STAT Point of Care Analyzer	CARTRIDGE I-STAT 25S												PG				5	39
	2	ABBOTT LABS	03P82-25			i-STAT Point of Care Analyzer	TEST PACK SODIUM HEMA												PG				5	40
	2	ABBOTT LABS	06P17-14			i-STAT Point of Care Analyzer	CONTROL LEVEL 2 PT 10S												PG				5	45
	2	ABBOTT LABS	06P17-13			i-STAT Point of Care Analyzer	CONTROL LVL 1 PT 10S												BX				5	50
	2	ABBOTT LABS	09P31-26			i-STAT Point of Care Analyzer	CARTRIDGE TEST BLOOD												BX				5	50
	2	ABBOTT LABS	03P79-25			i-STAT Point of Care Analyzer	CARTRIDGE BLD A TEST												BX				5	50
	2	ABBOTT LABS	03P76-25			i-STAT Point of Care Analyzer	TEST PACK SODIUM K IO												BX				5	50
	2	ABBOTT LABS	06F13-01			i-STAT Point of Care Analyzer	CONTROL BLOOD CHEMIST												PG				5	50
	2	ABBOTT LABS	03P89-24			i-STAT Point of Care Analyzer	CARTRIDGE COAGULATION												EA				5	54
	2	ABBOTT LABS	06P17-10			i-STAT Point of Care Analyzer	CONTROL LVL 2 1ML 6S												PG				5	60
	2	ABBOTT LABS	06P17-11			i-STAT Point of Care Analyzer	CONTROL LVL 3 1ML 6S												PG				5	64
	2	ABBOTT LABS	06P17-09			i-STAT Point of Care Analyzer	CONTROL LVL 1 1ML 6S												EA				5	71
	2	ABBOTT LABS	05P70-01			i-STAT Point of Care Analyzer	SET CALIB LEVEL 1-5 1S												BX				5	72
	2	ABBOTT LABS	05P71-01			i-STAT Point of Care Analyzer	TRICONTROL LEVEL 1 1S												EA				5	77
	2	ABBOTT LABS	05P5825			i-STAT Point of Care Analyzer	ISTAT HCG CART 25S												PG				5	139
	2	ABBOTT LABS	05P72-01			i-STAT Point of Care Analyzer	TRICONTROL LEVEL 2 1S												PG				5	140
	2	ABBOTT LABS	03P9025			i-STAT Point of Care Analyzer	CARTRIDGE CARDIAC TES												BX				5	242
	2	ABBOTT LABS	06F12-01			i-STAT Point of Care Analyzer	CONTROL BLOOD CHEMIST												BX				5	250
	2	ABBOTT LABS	03P8825			i-STAT Point of Care Analyzer	CARTRIDGE TEST CG8 25S												BX				5	250
	2	ABBOTT LABS	9P31-25			i-STAT Point of Care Analyzer	CARTRIDGE CHEM 8+ 25S												BX				5	373
	3	Accriva Diagnostics	000J201			Hemochron Signature Elite	PT CUVETTES												BX				5	NA
	3	Accriva Diagnostics	DCJCPT-N			Hemochron Signature Elite	DIRECTCHECK PT/APTT Normal												BX				5	NA
	3	Accriva Diagnostics	DCJAPTT-A			Hemochron Signature Elite	DIRECTCHECK APTT ABNORMAL												BX				5	NA
	3	Accriva Diagnostics	DCJPT-A			Hemochron Signature Elite	DIRECTCHECK PT ABNORMAL												BX				5	NA
	3	Werfen	DCJPT-A			Hemochron Signature Elite	CONTROL COAGULATION												PG				5	NA
	4	BECKMAN COULTER	8448350			Beckman Coulter DxH500	ACT RINSE DIL 500ML 1S												PG				5	1
	4	BECKMAN COULTER	B36880			Beckman Coulter DxH500	CALIBRATOR DXH SER 1S												PG				5	6
	4	BECKMAN COULTER	B36845			Beckman Coulter DxH500	DILUENT FOR DXH 500 1S												EA				5	28
	4	BECKMAN COULTER	B36872			Beckman Coulter DxH500	CONTROLS DXH 500 1S												KT				5	1
	4	BECKMAN COULTER	B36846			Beckman Coulter DxH500	LYSE FOR DXH 500 1S												PG				5	2
	4	BECKMAN COULTER	B36868			Beckman Coulter DxH500	CLEANER DHX SERIES 1S												BX				5	2
	5	BIOFIRE DIAGNOSTICS	423742			BioFire Filmarray system	Respratory Panel 2.1 (RP2.1) Panel												BX				5	7
	5	BIOFIRE DIAGNOSTICS	NGDS-ASY-0017			BioFire Filmarray system	PANEL,SENTINEL												PG				5	10
	5	BIOFIRE DIAGNOSTICS	423740			BioFire Filmarray system	KIT RESPIR PAN 2.1 30S												BX				5	50
	5	BIOFIRE DIAGNOSTICS	RFIT-ASY-0116			BioFire Filmarray system	KIT BIOFIRE GI PAN 30S												PG				5	50
	5	BIOFIRE DIAGNOSTICS	ZTXNATRPC21BIO			BioFire Filmarray system	Respratory Panel 2.1 (PR2.1) QC CONTROLS 0.3ML X 12 1S												BX				5	25
	5	BIOFIRE DIAGNOSTICS	M315			BioFire Filmarray system	PANEL CNTRL 12 TUBE 1S												PG				5	21
	5	BIOFIRE DIAGNOSTICS	M441			BioFire Filmarray system	PANEL CTRL FILMARR 12S												EA				5	21
	5	BIOFIRE DIAGNOSTICS	MQCM210V11			BioFire Filmarray system	Respratory Panel 2 (PR2), QC												BX				5	25
	5	BIOFIRE DIAGNOSTICS	MQCM238			BioFire Filmarray system	GastrointestinaI (GI), QC												BX				5	25
	5	BIOSITE	21V88754			Triage Meter Pro	CONTROL 5TOTAL LVL2 5S												PG				5	51
	6	ORTHO CLINICAL DIAGNOSTICS	719810			Ortho Confidence System	CONTROL COOMBS TEST												BX				5	53
	6	ORTHO CLINICAL DIAGNOSTICS	716980			Ortho Hematology microplate Bioclone	COOMBS TEST REAGENT												SE				5	1
	6	ORTHO CLINICAL DIAGNOSTICS	719610			Ortho Selectogen	REAGENT SET ANTIBODY												KT				5	4
	6	ORTHO CLINICAL DIAGNOSTICS	719100			Ortho Surgiscreen	ANTI-BODY DETECTION												PG				5	13
	6	ORTHO CLINICAL DIAGNOSTICS	719210			Ortho Vision or Ortho Vision Max	TEST KIT REVERSE BLD												PG				5	18
	6	ORTHO CLINICAL DIAGNOSTICS	6902096			Ortho-Clinical Confidence system	CONTROL KIT BLOOD GRP												EA				5	35
	7	Quidel	98000XREU			Triage Meter Pro	TRIAGE BNP XR TEST 25S												EA				5	73
	7	Quidel	97300EU			Triage Meter Pro	PANEL SOB TRI PROF 25S												PG				5	90
	7	Quidel	98100EU			Triage Meter Pro	Triage Multi-Analyte Control Level 1												PG				5	NA
	7	Quidel	97000HS			Triage Meter Pro	Cardiac Panel Cartridge												KT				5	NA
	7	Quidel	94614			Triage Meter Pro	Tox Drug Screen Controls Lv 2												BX				5	20
	7	Quidel	94613			Triage Meter Pro	Tox Drug Screen Controls Lv 1												EA				5	28
	7	Quidel	94600			Triage Meter Pro	Drug Screen Panel Cartridge												BX				5	NA
	7	ALERE	88753			Triage Meter Pro	CONTROL BLOOD CHEMIST												KT				5	8
	8	Quidel	00343			QuickVue Rapid test	Strep A Rapid Test (Comes with QC)												BX				5	383
	8	Quidel	0W009			QuickVue Rapid test	QUICKVUE TEST KIT 10S												PG				5	1
	8	SYSMEX	SYS-024-0971-4			XP-300, pocH-100i, pocH100iV Diff	REAGENT POCH DILUENT 2L 100I HEMATOLOGY												KT				5	1
	8	SYSMEX	PPL-200A			XP-300, pocH-100i, pocH100iV Diff	POCH-PACK L												CS				5	2
	8	SYSMEX	217685			XP-300, pocH-100i, pocH100iV Diff	Poch Calibrator SCS - 1000 1S												KT				5	3
	8	SYSMEX	99900517			XP-300, pocH-100i, pocH100iV Diff	EIGHTCHECK-3WP 4.6 1S												CS				5	22
	8	SYSMEX	SYE83401621			XP-300, pocH-100i, pocH100iV Diff	Cell Clean												PG				5	70
	8	SYSMEX	140-3004-0			XP-300, pocH-100i, pocH100iV Diff	CONTROL EIGHTCHECK 12S												EA				5	135
	9	Zeptometrix	NATNG-6MC			Cepheid Gene Xpert	NATTROL NG Positive Control												EA				5	3
	9	Zeptometrix	NATCT(434)-6MC			Cepheid Gene Xpert	NATTROL CT Positive Control												CS				5	19
	9	Zeptometrix	NATCT/NGNEG-6MC			Cepheid Gene Xpert	CT/NG Negative Control (6 X 1 mL)												CS				5	33
	9	Zeptometrix	NATCT/NGP-C			Cepheid Gene Xpert	NATTROL CT/NG PNL 17S												BX				5	105
	9	Cepheid	CEPRSARSCOV2DOD			Cepheid Gene Xpert	RT-PCR TEST CEPHD 10S												CS				5	9
	9	Cepheid	GXCT/NG-10			Cepheid Gene Xpert	RT-PCR TEST CT/NG												EA				5	10
	9	Cepheid	XP3COV2/FLU/RSV-10			Cepheid Gene Xpert	Xpert® Xpress CoV-2/Flu/RSV plus												PG				5	18
	9	Cepheid	NATFRC-ERC			Cepheid Gene Xpert	NATtrol Flu/RSV/SARS-CoV-2 External Run Control (6 x 0.5mL Vials)												KT				5	19
	10	ZOETIS	10023274			Vetscan VS2 analyzer	CARTRIDGE VET CG8+ 10S												PG				5	2
	10	ZOETIS	400-0035			Vetscan VS2 analyzer	BIOCHEM PANEL PLUS 10S												BX				5	3
	10	ZOETIS	10023314			Vetscan VS2 analyzer	VETSCAN HM5 NORMAL 1S												CS				5	6
	10	ZOETIS	10023219			Vetscan VS2 analyzer	VETSCAN RGNT DISC 12S												EA				5	6
	10	ZOETIS	400-0034			Vetscan VS2 analyzer	METLYTE 8+CRP 10S												PG				5	7
	11	Siemens	3536597			CLINITEK Advantus	Multistix 10 SG (urine dip stick)												KT				5	36
	11	Werfen	87177			CLINITEK Advantus	Kova Liqua-Trol w/micro, Abnormal, Control urine Lv1												BX				5	NA
	12						MALARIA rapid test												EA				5	15
	12						INDICATOR BIO VEL 60S												BX				5	1
	12						TEST STRIPS CIDEX 120S												BX				5	2
	12						CASSETTE STERR 100 5S												PG				5	2
	12						SWAB CULTURE CARY 50S												BX				5	7
	12						TUBE BLOOD COLL 100S												PG				5	32
	12						TUBE BD PST LIHEP 50S												BX				5	156
	12						TUBE VACUUM BLOOD 100S												EA				5	4
	12						SWAB CULTURE COLL 100S												EA				5	6
	12						CULTURE SWAB GEL 50S												EA				5	21
	12						CULTURE SWAB 50S												EA				5	24
	12						TUBE BLOOD COLL 100S												EA				5	26
	12						SWAB TEST SANITATION												BX				5	50
	12						PATHOGEL VET SET												BX				5	50
	12						ATP POSITIVE CONTROL												SE				5	52
	12						Rapid HBsAg Kit												SE				5	166
	12						WATER SAMPLE PADDL 25S												BX				5	NA
	12						KIT DIFFERENTIATION												CS				5	3
	12						TUBE BLOOD 1.8ML 50S												PG				5	8
	12						Hemoccult rapid test												PG				5	10
	12						TEST SNAP GIARDIA 15S												BX				5	13
	12						TEST SNAP FELINE 15S												KT				5	22
	12						TEST SNAP 4DX PLUS 30S												PG				5	24
	12						TEST WATER REAG 200S												PG				5	26
	12						KIT CORQC TEST 11.5 1S												KT				5	29
	12						REAGENT BLOOD A1 B 2S												PG				5	30
	12						CANISTER INTERNAL												BX				5	39
	12						HIV-1/2 Rapid Test												PG				5	19
	12						ABO Blood Grouping Anti-B												BX				5	31
	12						Immunohematology Anti-D (Anti-RH1) (Human Monoclonal-Polyclonal Blend) For Rapid Tube, Slide and Microplate Tests 10 mL												PG				5	96
	12						Influenza A+B Rapid Test												CS				5	2
	12						Mono Rapid Test (Comes with QC)												PG				5	2
	12						hCG Combo Rapid Test												EA				5	2
	12						SET CULTURE SPORVIEW 20S												PG				5	3
	12						CONTROL ST HEMOGLOBIN												BX				5	4
	12						CONTROL SPIN FLUID 4S												PG				5	4
	12						CELL CHEX L2 2.0ML 3S												EA				5	5
	12						REAGENT SALINE 20L 1S												PG				5	11
	12						CONTROL RAPID HIV-1/2												EA				5	13

Field Definitions

* - DENOTES MANDATORY FIELD				FOR OFFICIAL USE ONLY		* - DENOTES MANDATORY FIELD				FOR OFFICIAL USE ONLY
Item Master Template Fields						Price Offer Template Fields
Field Name	Length	Type	Definition	Comments		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 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 and Manufacturer Part Number denotes the unique Product Identifier. If this field is blank, the NDC field MUST be completed.
	*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. *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 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.		*SUPPLIER PART NUMBER	30	AN	The item number used by you 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.		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.
	*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		*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.
	*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.		*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.
	*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.		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.
	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.			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.
	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.		*TOTAL EACHES	8	N	The smallest Base Unit of Pack units contained in the Unit of Sale.
	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.		*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.
	QTY OF BASE UNIT OF MEASURE	8,3	N	The count of Item UOM Content units contained in the Base Unit of Pack (BUOP).		*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.
	BASE UNIT OF MEASURE CODE	2	AN	The smallest practical Unit of Measure for the product contained in the Item UOM.		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.
	*HAZARDOUS INDICATOR
(Y/N)	1	A	Indicates whether the product is classified as hazardous.	Y = Yes

N = No

Value will default to Y if a valid Special Handling Code is selected		*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 HAZARDOUS SPECIAL HANDLING CODE 4 AN Indicates the Speical Handling Code for a hazardous Product C11 = EXPLOSIVES WITH A MASS EXPLOSION HAZARD. (NITROGLYCERIN/DYNAMITE)

C12 = EXPLOSIVES WITH A BLAST/PROJECTION HAZARD.

C13 = EXPLOSIVES WITH A MINOR BLAST HAZARD. (ROCKET PROPELLANT, DISPLAY FIREWORKS)

C14 = XPLOSIVES WITH A MAJOR FIRE HAZARD. (CONSUMER FIREWORKS, AMMUNITION)

C15 = BLASTING AGENTS

C16 = EXTREMELY INSENSITIVE EXPLOSIVES

C21 = FLAMMABLE GAS

C22 = NONFLAMMABLE GAS

C22A = OXYGEN

C23 = POISONOUS GAS

C23A = INHALATION HAZARD

C30 = FLAMMABLE LIQUIDS

C41 = FLAMMABLE SOLIDS

C42 = SPONTANEOUSLY COMBUSTIBLE SOLIDS

C43 = DANGEROUS WHEN WET

C51 = OXIDIZING AGENT

C52 = ORGANIC PEROXIDE OXIDIZING AGENT

C61 = POISON

C62 = BIOHAZARD

C70 = RADIOACTIVE

C80 = CORROSIVE

C90 = MISCELLANEOUS

This field is mandatory if HAZARDOUS INDICATOR is set to Y		*LIST PRICE	9,2	N	The commercial catalog Unit of Sale price.
	*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)		*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].
	*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.		*PRICING SUPPORT UNIT PRICE	9,2		Unit Price found in the Other than Certified Cost and Pricing Data submitted in Volume IIIb: b. Pricing Support for Price Reasonableness Determinations	Shall indicate if the terms and conditions of the catalogs, price lists, invoices, or terms of sale are inclusive or exclusive of shipping. If prices are inclusive of shipping, the shipping address country of destination.
	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 greater 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.	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.
*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.	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.

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

	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.		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.
	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.		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.
	*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.		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.
	*SHELF LIFE MONTHS	3	N	Represents the general shelf life (in months) of the item at the time of manufacturing.			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 SCMPK = DAPA Holder Sells PrePak or Similar PrePaks Commercially; price offered is best price available given similar terms NSCMPK = 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.
	GROSS WEIGHT	5,3	N	The Gross Weight of the Unit of Sale.
FOR OFFICIAL USE ONLY

Country Codes

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
	FOR OFFICIAL USE ONLY

SysGuid

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