Attachment_2_-_DOD_EMALL_Catalog_Loader_Template_and_Instructions.xlsx
XLSX spreadsheet 158 KB Posted
- Attached to
- DOD EMALL Multiple Award Schedule Solicitation Federal contract opportunity
- Solicitation number
- SP4708-15-R-0001
- Issued by
- Defense Logistics Agency Troop Support
About this file
This document provides details for a Defense Logistics Agency solicitation seeking to establish Indefinite Delivery/Indefinite Quantity Multiple Award Schedule contracts for various commercially available off-the-shelf items to be ordered through the DOD EMALL system. The solicitation involves items matching a subset of Federal Supply Classes and seeks to make multiple awards for the entire spectrum of categories. Catalogs must be submitted using the provided Microsoft Excel template, with pricing inclusive of all shipping, handling, and transportation costs on an FOB Destination basis. The base period of performance is one year, with four one-year option periods. Award will be made to responsible offerors that can comply with supply and technical requirements at fair and reasonable prices. The final solicitation and attachments will be available via download from the DLA Internet Bid Board System.
Attachment 2 - DOD EMALL Catalog Loader Template and Instructions.xlsx
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| SP4708-15-R-0001_(15)_01-14_(DRAFT).pdf | ||
| Attachment_1_-_Supplier_Informational_Package_and_Business_Rules_and_Agreement_to_Sell_on_DOD_EMALL.pdf | ||
| Attachment_2_-_DOD_EMALL_Catalog_Loader_Template_and_Instructions.xlsx | XLSX spreadsheet | |
| Attachment_1_-_Supplier_Informational_Package_and_Business_Rules_and_Agreement_to_Sell_on_DOD_EMALL.pdf | ||
| SP4708-15-R-0001_(15)_01-14_(DRAFT).pdf |
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
Data Dictionary
| STANDARDIZED TEMPLATE COLUMN-NAME | FIELD (EMALL NAME) | FIELD TYPE | FIELD SIZE | COMMENT | DESCRIPTION |
| PART_NUMBER | Part Number (column A) | AN | 80 | REQUIRED | The Supplier's part number assigned by the Supplier to an item in the catalog. This number may be the same as or different than the manufacturer's part number. (Must not include the part name) (Do not use special characters ) |
| PART_NAME | Part Name (column B) | AN | 120 | REQUIRED | The name used for the item being marketed to the customer. (Must not include the part number)(Do not use special characters ) |
| PRICE | Price (column C) | N | 16,4 | REQUIRED | The amount of money required to purchase the item While the DOD EMALL system allows up to four decimals, the DOD EMALL Contracting Office has determined that all contract prices will be rounded to the nearest two decimal places to ensure greater accuracy in invoicing, billing, and payment transactions. Therefore, prices entered may only have up to two digits after the decimal point. (Shipping must be included) |
| UNIT_OF_ISSUE | Unit of Issue (column D) | AN | 2 | REQUIRED | Description of how a part is packaged. See the "Unit of Issue Codes" spreadsheet within this workbook for acceptable UOI codes. Note: "Boxes" or "Packages" should not be classified as "Each" should more than one item be contained within the Unit of Issue. |
| ITEMS_PER_UOI | Items Per Unit of Issue (column E) | N | 16,4 | REQUIRED | A number representing the quantity of items enclosed within the unit of issue. For "Each" (EA), this value is always "1", while for a "Box" (BX) or "Package" (PG), this number should always be greater than "1". |
| OEM_NAME | OEM Name (column F) | AN | 80 | REQUIRED | The name of the company that Manufactured the item, or Original Equipment Manufacturer (OEM) |
| OEM_PART_NO | OEM Part Number (column G) | AN | 80 | REQUIRED | The part number assigned by the OEM. This number may be the same as or different than the supplier's part number. |
| DESCRIPTION | Description (column H) | AN | 120 | REQUIRED | Summary description of the item.(Can not be a repeat of the Product Name) (Must not include the part number)(Do not use special characters ) |
| DAYS_ARO | Days ARO (column I) | N | 6 | REQUIRED | The number of business days "After Receipt of Order" (ARO) by the supplier that possession and ownership of the item will be transferred to the customer; expressed in "no-later-than" terms (i.e. the amount of time it will take for the customer to receive the items they ordered after the supplier receives the customer's order). |
| PSC_CODE | Product Service Code (column J) | AN | 4 | REQUIRED | Four digit alphanumerical code used to identify the Product Service Code (PSC) assigned to the item. PSC is a super-set of Federal Suply Class (FSC) codes. |
| LONG_DESCRIPTION | EXPANDED DESCRIPTION (column K) | AN | 2048 | Detailed description of a part being marketed to the customer. (Must not include the part number)(Do not use special characters ) | |
| NSN | NSN (column K) | AN | 13 | National Stock Number: An NSN is a 13-digit number used to identify an item of material in the supply distribution system of the United States . It consists of a four-digit Product Service Code and a nine-digit national item identification number | |
| UPC | UPC (column L) | AN | 20 | Universal Product Code | |
| IMAGE_NAME | IMAGE NAME (column N) | AN | 512 | Name of the DOD EMALL hosted item image associated to the part for display. (i.e. abc133.jpg) . URLs for external hosted images are not accepted. |
Max 80 characters, exclusive of extension (IAmEightyCharactersLongPlus.jpg).
Acceptable chars: alphas, numbers, hyphens "-", and underscores "_".
Images can be loaded via the Image Upload page in DOD EMALL CCHS.
Alternatively Images can be sent to : cchs-images@mantech.com. The email subject title must include Supplier Name and CCHS Supplier ID (Supplier ID is found in CCHS and is the series of numbers found in parenthesis following your company name). If email is titled wrong the images will not be accepted. Images may also be mailed to DOD EMALL CCHS Images c/o ManTech 301 Summers St., Suite 4 Hinton, WV 25951
| UNSPSC | UNSPSC (column P) | AN | 20 | United Nations Standard Products and Services Code (http://www.unspsc.org) | |
| HAZMAT | HAZARDOUS MATERIAL FLAG(column Q) | A | 10 | Y/N flag | Hazardous Material. Must be "Y" or "N": |
Y = TBD price Y = Hazardous Material N = non-Hazardous Material PRICE_TBD PRICE TBD FLAG (column R) A 1 Y/N flag Price To Be Determined. Must be "Y" or "N":
Y = TBD price N = non-TBD price This value must be set to Y and the price set to 0 if a parts price is pending response from the vendor. I.e.: ODM (On Demand Manufacturing) parts
| COG_CODE | COG CODE | AN | 2 | |
| OEM_CAGE_CODE | OEM CAGE CODE | AN | 2 | |
| ITEM_TYPE | ITEM TYPE | AN | 20 | |
| SALE_START | SALE START DATE | D | 8 | The date for which the discounted price for a part becomes effective. |
| SALE_END | SALE END DATE | D | 8 | The date for which the discounted price for a part terminates. |
| PB1_QTY | PB1 Quantity | N | 8 | The quantity that must be purchased in order for the PB1 break prices to be in effect. |
| PB1_Z1_PRICE | PB1 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB1 Quantity requirement is met. |
| PB1_Z1_SALE | PB1 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z2_PRICE | PB1 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB1 Quantity requirement is met. |
| PB1_Z2_SALE | PB1 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z3_PRICE | PB1 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB1 Quantity requirement is met. |
| PB1_Z3_SALE | PB1 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z4_PRICE | PB1 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB1 Quantity requirement is met. |
| PB1_Z4_SALE | PB1 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z5_PRICE | PB1 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB1 Quantity requirement is met. |
| PB1_Z5_SALE | PB1 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z6_PRICE | PB1 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB1 Quantity requirement is met. |
| PB1_Z6_SALE | PB1 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z7_PRICE | PB1 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB1 Quantity requirement is met. |
| PB1_Z7_SALE | PB1 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z8_PRICE | PB1 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB1 Quantity requirement is met. |
| PB1_Z8_SALE | PB1 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z9_PRICE | PB1 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB1 Quantity requirement is met. |
| PB1_Z9_SALE | PB1 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB1_Z10_PRICE | PB1 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB1 Quantity requirement is met. |
| PB1_Z10_SALE | PB1 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB1 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_QTY | PB2 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB2 break prices to be in effect. |
| PB2_Z1_PRICE | PB2 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB2 Quantity requirement is met. |
| PB2_Z1_SALE | PB2 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z2_PRICE | PB2 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB2 Quantity requirement is met. |
| PB2_Z2_SALE | PB2 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z3_PRICE | PB2 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB2 Quantity requirement is met. |
| PB2_Z3_SALE | PB2 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z4_PRICE | PB2 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB2 Quantity requirement is met. |
| PB2_Z4_SALE | PB2 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z5_PRICE | PB2 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB2 Quantity requirement is met. |
| PB2_Z5_SALE | PB2 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z6_PRICE | PB2 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB2 Quantity requirement is met. |
| PB2_Z6_SALE | PB2 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z7_PRICE | PB2 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB2 Quantity requirement is met. |
| PB2_Z7_SALE | PB2 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z8_PRICE | PB2 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB2 Quantity requirement is met. |
| PB2_Z8_SALE | PB2 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z9_PRICE | PB2 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB2 Quantity requirement is met. |
| PB2_Z9_SALE | PB2 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB2_Z10_PRICE | PB2 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB2 Quantity requirement is met. |
| PB2_Z10_SALE | PB2 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB2 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_QTY | PB3 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB3 break prices to be in effect. |
| PB3_Z1_PRICE | PB3 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB3 Quantity requirement is met. |
| PB3_Z1_SALE | PB3 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z2_PRICE | PB3 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB3 Quantity requirement is met. |
| PB3_Z2_SALE | PB3 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z3_PRICE | PB3 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB3 Quantity requirement is met. |
| PB3_Z3_SALE | PB3 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z4_PRICE | PB3 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB3 Quantity requirement is met. |
| PB3_Z4_SALE | PB3 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z5_PRICE | PB3 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB3 Quantity requirement is met. |
| PB3_Z5_SALE | PB3 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z6_PRICE | PB3 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB3 Quantity requirement is met. |
| PB3_Z6_SALE | PB3 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z7_PRICE | PB3 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB3 Quantity requirement is met. |
| PB3_Z7_SALE | PB3 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z8_PRICE | PB3 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB3 Quantity requirement is met. |
| PB3_Z8_SALE | PB3 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z9_PRICE | PB3 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB3 Quantity requirement is met. |
| PB3_Z9_SALE | PB3 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB3_Z10_PRICE | PB3 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB3 Quantity requirement is met. |
| PB3_Z10_SALE | PB3 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB3 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_QTY | PB4 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB4 break prices to be in effect. |
| PB4_Z1_PRICE | PB4 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB4 Quantity requirement is met. |
| PB4_Z1_SALE | PB4 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z2_PRICE | PB4 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB4 Quantity requirement is met. |
| PB4_Z2_SALE | PB4 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z3_PRICE | PB4 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB4 Quantity requirement is met. |
| PB4_Z3_SALE | PB4 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z4_PRICE | PB4 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB4 Quantity requirement is met. |
| PB4_Z4_SALE | PB4 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z5_PRICE | PB4 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB4 Quantity requirement is met. |
| PB4_Z5_SALE | PB4 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z6_PRICE | PB4 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB4 Quantity requirement is met. |
| PB4_Z6_SALE | PB4 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z7_PRICE | PB4 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB4 Quantity requirement is met. |
| PB4_Z7_SALE | PB4 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z8_PRICE | PB4 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB4 Quantity requirement is met. |
| PB4_Z8_SALE | PB4 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z9_PRICE | PB4 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB4 Quantity requirement is met. |
| PB4_Z9_SALE | PB4 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB4_Z10_PRICE | PB4 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB4 Quantity requirement is met. |
| PB4_Z10_SALE | PB4 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB4 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_QTY | PB5 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB5 break prices to be in effect. |
| PB5_Z1_PRICE | PB5 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB5 Quantity requirement is met. |
| PB5_Z1_SALE | PB5 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z2_PRICE | PB5 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB5 Quantity requirement is met. |
| PB5_Z2_SALE | PB5 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z3_PRICE | PB5 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB5 Quantity requirement is met. |
| PB5_Z3_SALE | PB5 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z4_PRICE | PB5 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB5 Quantity requirement is met. |
| PB5_Z4_SALE | PB5 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z5_PRICE | PB5 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB5 Quantity requirement is met. |
| PB5_Z5_SALE | PB5 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z6_PRICE | PB5 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB5 Quantity requirement is met. |
| PB5_Z6_SALE | PB5 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z7_PRICE | PB5 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB5 Quantity requirement is met. |
| PB5_Z7_SALE | PB5 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z8_PRICE | PB5 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB5 Quantity requirement is met. |
| PB5_Z8_SALE | PB5 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z9_PRICE | PB5 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB5 Quantity requirement is met. |
| PB5_Z9_SALE | PB5 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB5_Z10_PRICE | PB5 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB5 Quantity requirement is met. |
| PB5_Z10_SALE | PB5 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB5 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_QTY | PB6 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB6 break prices to be in effect. |
| PB6_Z1_PRICE | PB6 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB6 Quantity requirement is met. |
| PB6_Z1_SALE | PB6 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z2_PRICE | PB6 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB6 Quantity requirement is met. |
| PB6_Z2_SALE | PB6 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z3_PRICE | PB6 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB6 Quantity requirement is met. |
| PB6_Z3_SALE | PB6 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z4_PRICE | PB6 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB6 Quantity requirement is met. |
| PB6_Z4_SALE | PB6 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z5_PRICE | PB6 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB6 Quantity requirement is met. |
| PB6_Z5_SALE | PB6 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z6_PRICE | PB6 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB6 Quantity requirement is met. |
| PB6_Z6_SALE | PB6 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z7_PRICE | PB6 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB6 Quantity requirement is met. |
| PB6_Z7_SALE | PB6 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z8_PRICE | PB6 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB6 Quantity requirement is met. |
| PB6_Z8_SALE | PB6 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z9_PRICE | PB6 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB6 Quantity requirement is met. |
| PB6_Z9_SALE | PB6 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB6_Z10_PRICE | PB6 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB6 Quantity requirement is met. |
| PB6_Z10_SALE | PB6 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB6 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_QTY | PB7 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB7 break prices to be in effect. |
| PB7_Z1_PRICE | PB7 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB7 Quantity requirement is met. |
| PB7_Z1_SALE | PB7 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z2_PRICE | PB7 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB7 Quantity requirement is met. |
| PB7_Z2_SALE | PB7 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z3_PRICE | PB7 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB7 Quantity requirement is met. |
| PB7_Z3_SALE | PB7 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z4_PRICE | PB7 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB7 Quantity requirement is met. |
| PB7_Z4_SALE | PB7 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z5_PRICE | PB7 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB7 Quantity requirement is met. |
| PB7_Z5_SALE | PB7 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z6_PRICE | PB7 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB7 Quantity requirement is met. |
| PB7_Z6_SALE | PB7 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z7_PRICE | PB7 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB7 Quantity requirement is met. |
| PB7_Z7_SALE | PB7 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z8_PRICE | PB7 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB7 Quantity requirement is met. |
| PB7_Z8_SALE | PB7 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z9_PRICE | PB7 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB7 Quantity requirement is met. |
| PB7_Z9_SALE | PB7 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB7_Z10_PRICE | PB7 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB7 Quantity requirement is met. |
| PB7_Z10_SALE | PB7 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB7 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_QTY | PB8 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB8 break prices to be in effect. |
| PB8_Z1_PRICE | PB8 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB8 Quantity requirement is met. |
| PB8_Z1_SALE | PB8 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z2_PRICE | PB8 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB8 Quantity requirement is met. |
| PB8_Z2_SALE | PB8 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z3_PRICE | PB8 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB8 Quantity requirement is met. |
| PB8_Z3_SALE | PB8 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z4_PRICE | PB8 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB8 Quantity requirement is met. |
| PB8_Z4_SALE | PB8 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z5_PRICE | PB8 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB8 Quantity requirement is met. |
| PB8_Z5_SALE | PB8 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z6_PRICE | PB8 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB8 Quantity requirement is met. |
| PB8_Z6_SALE | PB8 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z7_PRICE | PB8 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB8 Quantity requirement is met. |
| PB8_Z7_SALE | PB8 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z8_PRICE | PB8 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB8 Quantity requirement is met. |
| PB8_Z8_SALE | PB8 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z9_PRICE | PB8 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB8 Quantity requirement is met. |
| PB8_Z9_SALE | PB8 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB8_Z10_PRICE | PB8 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB8 Quantity requirement is met. |
| PB8_Z10_SALE | PB8 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB8 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_QTY | PB9 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB9 break prices to be in effect. |
| PB9_Z1_PRICE | PB9 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB9 Quantity requirement is met. |
| PB9_Z1_SALE | PB9 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z2_PRICE | PB9 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB9 Quantity requirement is met. |
| PB9_Z2_SALE | PB9 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z3_PRICE | PB9 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB9 Quantity requirement is met. |
| PB9_Z3_SALE | PB9 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z4_PRICE | PB9 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB9 Quantity requirement is met. |
| PB9_Z4_SALE | PB9 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z5_PRICE | PB9 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB9 Quantity requirement is met. |
| PB9_Z5_SALE | PB9 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z6_PRICE | PB9 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB9 Quantity requirement is met. |
| PB9_Z6_SALE | PB9 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z7_PRICE | PB9 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB9 Quantity requirement is met. |
| PB9_Z7_SALE | PB9 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z8_PRICE | PB9 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB9 Quantity requirement is met. |
| PB9_Z8_SALE | PB9 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z9_PRICE | PB9 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB9 Quantity requirement is met. |
| PB9_Z9_SALE | PB9 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB9_Z10_PRICE | PB9 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB9 Quantity requirement is met. |
| PB9_Z10_SALE | PB9 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB9 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_QTY | PB10 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB10 break prices to be in effect. |
| PB10_Z1_PRICE | PB10 Zone 1 Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB10 Quantity requirement is met. |
| PB10_Z1_SALE | PB10 Zone 1 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 1 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z2_PRICE | PB10 Zone 2 Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB10 Quantity requirement is met. |
| PB10_Z2_SALE | PB10 Zone 2 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 2 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z3_PRICE | PB10 Zone 3 Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB10 Quantity requirement is met. |
| PB10_Z3_SALE | PB10 Zone 3 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 3 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z4_PRICE | PB10 Zone 4 Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB10 Quantity requirement is met. |
| PB10_Z4_SALE | PB10 Zone 4 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 4 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z5_PRICE | PB10 Zone 5 Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB10 Quantity requirement is met. |
| PB10_Z5_SALE | PB10 Zone 5 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 5 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z6_PRICE | PB10 Zone 6 Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB10 Quantity requirement is met. |
| PB10_Z6_SALE | PB10 Zone 6 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 6 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z7_PRICE | PB10 Zone 7 Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB10 Quantity requirement is met. |
| PB10_Z7_SALE | PB10 Zone 7 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 7 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z8_PRICE | PB10 Zone 8 Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB10 Quantity requirement is met. |
| PB10_Z8_SALE | PB10 Zone 8 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 8 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z9_PRICE | PB10 Zone 9 Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB10 Quantity requirement is met. |
| PB10_Z9_SALE | PB10 Zone 9 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 9 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
| PB10_Z10_PRICE | PB10 Zone 10 Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB10 Quantity requirement is met. |
| PB10_Z10_SALE | PB10 Zone 10 Sale Price | N | 16,4 | The amount of money required to purchase the product in zone 10 if the PB10 Quantity requirement is met and the purchase date is within the sale date range specified by SALE_START_DATE and SALE_END_DATE. |
SP4708-15-R-0001
Attachment 2 - &A
&P of &N
Requirements PART_NUMBER PART_NAME PRICE UNIT_OF_ISSUE ITEMS_PER_UOI OEM_NAME OEM_PART_NO DESCRIPTION DAYS_ARO PSC_CODE LONG_DESCRIPTION NSN UPC IMAGE_NAME UNSPSC HAZMAT PRICE_TBD COG_CODE OEM_CAGE_CODE ITEM_TYPE SALE_START SALE_END PB1_QTY PB1_Z1_PRICE PB1_Z1_SALE PB1_Z2_PRICE PB1_Z2_SALE PB1_Z3_PRICE PB1_Z3_SALE PB1_Z4_PRICE PB1_Z4_SALE PB1_Z5_PRICE PB1_Z5_SALE PB1_Z6_PRICE PB1_Z6_SALE PB1_Z7_PRICE PB1_Z7_SALE PB1_Z8_PRICE PB1_Z8_SALE PB1_Z9_PRICE PB1_Z9_SALE PB1_Z10_PRICE PB1_Z10_SALE PB2_QTY PB2_Z1_PRICE PB2_Z1_SALE PB2_Z2_PRICE PB2_Z2_SALE PB2_Z3_PRICE PB2_Z3_SALE PB2_Z4_PRICE PB2_Z4_SALE PB2_Z5_PRICE PB2_Z5_SALE PB2_Z6_PRICE PB2_Z6_SALE PB2_Z7_PRICE PB2_Z7_SALE PB2_Z8_PRICE PB2_Z8_SALE PB2_Z9_PRICE PB2_Z9_SALE PB2_Z10_PRICE PB2_Z10_SALE PB3_QTY PB3_Z1_PRICE PB3_Z1_SALE PB3_Z2_PRICE PB3_Z2_SALE PB3_Z3_PRICE PB3_Z3_SALE PB3_Z4_PRICE PB3_Z4_SALE PB3_Z5_PRICE PB3_Z5_SALE PB3_Z6_PRICE PB3_Z6_SALE PB3_Z7_PRICE PB3_Z7_SALE PB3_Z8_PRICE PB3_Z8_SALE PB3_Z9_PRICE PB3_Z9_SALE PB3_Z10_PRICE PB3_Z10_SALE PB4_QTY PB4_Z1_PRICE PB4_Z1_SALE PB4_Z2_PRICE PB4_Z2_SALE PB4_Z3_PRICE PB4_Z3_SALE PB4_Z4_PRICE PB4_Z4_SALE PB4_Z5_PRICE PB4_Z5_SALE PB4_Z6_PRICE PB4_Z6_SALE PB4_Z7_PRICE PB4_Z7_SALE PB4_Z8_PRICE PB4_Z8_SALE PB4_Z9_PRICE PB4_Z9_SALE PB4_Z10_PRICE PB4_Z10_SALE PB5_QTY PB5_Z1_PRICE PB5_Z1_SALE PB5_Z2_PRICE PB5_Z2_SALE PB5_Z3_PRICE PB5_Z3_SALE PB5_Z4_PRICE PB5_Z4_SALE PB5_Z5_PRICE PB5_Z5_SALE PB5_Z6_PRICE PB5_Z6_SALE PB5_Z7_PRICE PB5_Z7_SALE PB5_Z8_PRICE PB5_Z8_SALE PB5_Z9_PRICE PB5_Z9_SALE PB5_Z10_PRICE PB5_Z10_SALE PB6_QTY PB6_Z1_PRICE PB6_Z1_SALE PB6_Z2_PRICE PB6_Z2_SALE PB6_Z3_PRICE PB6_Z3_SALE PB6_Z4_PRICE PB6_Z4_SALE PB6_Z5_PRICE PB6_Z5_SALE PB6_Z6_PRICE PB6_Z6_SALE PB6_Z7_PRICE PB6_Z7_SALE PB6_Z8_PRICE PB6_Z8_SALE PB6_Z9_PRICE PB6_Z9_SALE PB6_Z10_PRICE PB6_Z10_SALE PB7_QTY PB7_Z1_PRICE PB7_Z1_SALE PB7_Z2_PRICE PB7_Z2_SALE PB7_Z3_PRICE PB7_Z3_SALE PB7_Z4_PRICE PB7_Z4_SALE PB7_Z5_PRICE PB7_Z5_SALE PB7_Z6_PRICE PB7_Z6_SALE PB7_Z7_PRICE PB7_Z7_SALE PB7_Z8_PRICE PB7_Z8_SALE PB7_Z9_PRICE PB7_Z9_SALE PB7_Z10_PRICE PB7_Z10_SALE PB8_QTY PB8_Z1_PRICE PB8_Z1_SALE PB8_Z2_PRICE PB8_Z2_SALE PB8_Z3_PRICE PB8_Z3_SALE PB8_Z4_PRICE PB8_Z4_SALE PB8_Z5_PRICE PB8_Z5_SALE PB8_Z6_PRICE PB8_Z6_SALE PB8_Z7_PRICE PB8_Z7_SALE PB8_Z8_PRICE PB8_Z8_SALE PB8_Z9_PRICE PB8_Z9_SALE PB8_Z10_PRICE PB8_Z10_SALE PB9_QTY PB9_Z1_PRICE PB9_Z1_SALE PB9_Z2_PRICE PB9_Z2_SALE PB9_Z3_PRICE PB9_Z3_SALE PB9_Z4_PRICE PB9_Z4_SALE PB9_Z5_PRICE PB9_Z5_SALE PB9_Z6_PRICE PB9_Z6_SALE PB9_Z7_PRICE PB9_Z7_SALE PB9_Z8_PRICE PB9_Z8_SALE PB9_Z9_PRICE PB9_Z9_SALE PB9_Z10_PRICE PB9_Z10_SALE PB10_QTY PB10_Z1_PRICE PB10_Z1_SALE PB10_Z2_PRICE PB10_Z2_SALE PB10_Z3_PRICE PB10_Z3_SALE PB10_Z4_PRICE PB10_Z4_SALE PB10_Z5_PRICE PB10_Z5_SALE PB10_Z6_PRICE PB10_Z6_SALE PB10_Z7_PRICE PB10_Z7_SALE PB10_Z8_PRICE PB10_Z8_SALE PB10_Z9_PRICE PB10_Z9_SALE PB10_Z10_PRICE PB10_Z10_SALE
&20SP4708-15-R-0001
Attachment 2 - &A
&20&P of &N
Unit of Issue Codes
| Unit of Issue Codes | |
| AC | Acre |
| AM | Ampoule |
| AT | Assortment |
| AY | Assembly |
| BA | Ball |
| BD | Bundle |
| BE | Bale |
| BF | Board Foot |
| BG | Bag |
| BK | Book |
| BL | Barrel |
| BO | Bolt |
| BQ | Briquet |
| BR | Bar |
| BT | Bottle |
| BX | Box |
| CA | Cartridge |
| CB | Carboy |
| CC | Cubic Centimeter |
| CD | Cubic Yard |
| CE | Cone |
| CF | Cubic Foot |
| CG | Centigram |
| CI | Cubic Inch |
| CK | Cake |
| CL | Coil |
| CM | Centimeter |
| CN | Can |
| CO | Container |
| CS | Case |
| CT | Carton |
| CU | Curie |
| CY | Cylinder |
| CZ | Cubic Meter |
| DA | Days |
| DC | Decagram |
| DE | Decimeter |
| DG | Decigram |
| DL | Deciliter |
| DM | Dram |
| DO | Dollars |
| DR | Drum |
| DW | Pennyweight |
| DZ | Dozen |
| EA | Each |
| EN | Each Collection |
| EX | Exposure |
| FD | Fold |
| FR | Frame |
| FT | Foot |
| FV | Five |
| FY | Fifty |
| GG | Great Gross |
| GI | Gill |
| GL | Gallon |
| GM | Gram |
| GN | Grain |
| GP | Group |
| GR | Gross |
| GS | Gross |
| HD | Hundred |
| HF | Hundred Feet |
| HK | Hank |
| HP | Hundred Pounds |
| HR | Hours |
| HS | Hundred Square Feet |
| HT | Half Hour |
| HU | Hundred |
| HW | Hundred Weight |
| HY | Yards |
| IN | Inch |
| JR | Jar |
| KG | Kilogram |
| KM | Kilometer |
| KR | Karat |
| KT | Kit |
| LB | Pound |
| LF | Linear Foot |
| LG | Length |
| LH | Labor Hour |
| LI | Liter |
| LM | Linear Meter |
| LT | Lot |
| LS | Lump Sum |
| LY | Linear Yard |
| MC | Thousand Cubic Feet |
| ME | Meal |
| MF | Thousand Feet |
| MG | Miligram |
| MI | Mile |
| ML | Milliliter |
| MM | Millimeter |
| MO | Months |
| MR | Meter |
| MX | Thousand |
| OT | Outfit |
| OZ | Ounce |
| PD | Pad |
| PG | Package |
| PH | Pack (PAK) |
| PI | Pillow |
| PK | Package |
| PL | Pallet/Unit Load |
| PM | Plate |
| PR | Pair |
| PT | Pint |
| PX | Pellet |
| PZ | Packet |
| QT | Quart |
| RA | Ration |
| RD | Round |
| RL | Reel |
| RM | Ream |
| RO | Roll |
| RX | Thousand Rounds |
| SB | Square Mile |
| SC | Square Centimeters |
| SD | Skid |
| SE | Set |
| SF | Square Foot |
| SH | Sheet |
| SI | Square Inch |
| SK | Skein |
| SL | Spool |
| SM | Square Meter |
| SO | Shot |
| SP | Strip |
| SQ | Square |
| ST | Set |
| SV | Skid |
| SX | Stick |
| SY | Square Yard |
| TB | Tube |
| TC | Truckload |
| TD | Twenty-four |
| TE | Ten |
| TF | Twenty-five |
| TG | Gross Ton |
| TN | Ton |
| TO | Troy Ounce |
| TS | Thirty-six |
| TT | Tablet |
| TU | Tube |
| UN | Unit |
| US | U.S.P. Unit |
| VI | Vial |
| WK | Week |
| YD | Yard |
| YR | Years |
SP4708-15-R-0001
Attachment 2 - &A
Common Reasons for Rejection
| List of common reasons as to why a catalog would be rejected: | |
| 1 | Column headers are removed, hidden, renamed. |
| 2 | These are the only special characters DOD EMALL system will except all others must be removed. :;<=>?@[\]^_`{\}~! "#$%&',()*+-./ |
| 3 | Missing one or more of the mandatory data elements |
| 4 | Days ARO column has a range i.e. 4-8 days. This must be a single number and no words i.e. 12 |
| 5 | Unit of Issue code must be one of the approved two digit codes listed under the Unit of Issue Codes Tab |
| 6 | N/A is inserted into a field. All fields must contain valid information |
| 7 | The Part Name and Description are the same. |
| 8 | Image shows an image that says no image available. |
| 9 | Price has more than four digits after the decimal point. |
SP4708-15-R-0001
Attachment 2 - &A
File details come from the government source that posted it. Updated .