ATT_2Required_Data_Elements.xlsx
XLSX spreadsheet 172 KB Posted
- Attached to
- FSG 66 INSTRUMENTS & LAB EQUIPMENT
- Solicitation number
- SPMLW1-13-R-6601
About this file
ATTACHMENT 2
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ATTACHMENT_3.PDF | ||
| ATTACHMENT_1.pdf | ||
| ATTACHMENT_4.pdf | ||
| ATTACHMENT_6.PDF | ||
| FSG_66_INSTRUMENTS_ _LAB_SOLICITATION.pdf | ||
| ATTACHMENT_5.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| ** Part Number (column A) | Supplier's part number (Must not include the part name)(Do not use special characters ) |
| **Part Name (column B) | The name of the part (Must not include the part number)(Do not use special characters ) |
| ** Price (column C) | Buyers cost (shipping must be included) |
| ** UOI (column D) | This would be each, box, package etc., there is a list of acceptable unit of issue codes on the Product UOI Codes tab or Services UOI Codes tab |
| ** Items per UOI (column E) | Amount of items in a box or package |
| ** OEM Name (column F) | The name of the company that Manufactured the item |
| ** OEM PN (column G) | The Manufactures part number |
| **Description (column H) | Description of the item (Must be different than the "Part Name") (Must not include the part number)(Do not use special characters ) |
| ** Days ARO (After Receipt of Order) (column I) | Time frame from receipt of order to shipment to the customer |
| LONG_DESCRIPTION (column J) | Detailed description of item (Must not include the part number)(Do not use special characters ) |
| NSN's (column K) | National Stock Number assigned by the Government |
| UPC (column L) | Universal Product Code |
| Image Description (column M) | File name of images (abc133.jpg) |
| Image Ref (column N) | Enter image file name abc133.jpg |
| ENAC (column O) | Environmental Code to display recycled symbol |
| UNSPSC (column P) | United Nations Standard Products and Services Code |
| ** Indicates Mandatory Data Elements |
| Items In Black are not Mandatory |
Requirements PART_NUMBER PART_NAME PRICE UNIT_OF_ISSUE ITEMS_PER_UOI OEM_NAME OEM_PART_NO DESCRIPTION DAYS_ARO LONG_DESCRIPTION NSN UPC IMAGE_DESCRIPTION IMAGE_REF ENAC_CODE UNSPSC HAZMAT PRICE_TBD CLASS_CODE SHIP_WEIGHT SHIP_WEIGHT_UOM SHIP_LENGTH SHIP_WIDTH SHIP_HEIGHT SHIP_DIM_UOM PROD_WEIGHT PROD_WEIGHT_UOM PROD_LENGTH PROD_WIDTH PROD_HEIGHT PROD_DIM_UOM FSC_CODE PKG_UOS PKG_IPUOS PKG_PRICE NSN_CERT_CODE 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
Product Unit of Issue Codes
| Acceptable Unit of Issue Codes for each product listed (To be used for all DLA contracts) | |||||||
| AM | Ampoule | CN | Can | LI | Liter | RO | Roll |
| AT | Assortment | CO | Container | LT | Lot | SD | Skid |
| AY | Assembly | CY | Cylinder | MC | Thousand Cubic Feet | SE | Set |
| BA | Ball | CZ | Cubic Meter | ME | Meal | SF | Square Foot |
| BD | Bundle | DR | Drum | ML | Milliliter | SH | Sheet |
| BE | Bale | DZ | Dozen | MM | Millimeter | SK | Skein |
| BF | Board Foot | EA | Each | MR | Meter | SL | Spool |
| BG | Bag | FD | Fold | MX | Thousand | SO | Shot |
| BK | Book | FT | Foot | OT | Outfit | SP | Strip |
| BL | Barrel | FV | Five | OZ | Ounce | SV | Service |
| BO | Bolt | FY | Fifty | PD | Pad | SX | Stick |
| BR | Bar | GL | Gallon | PG | Package | SY | Square Yard |
| BT | Bottle | GP | Group | PM | Plate | TD | Twenty-four |
| BX | Box | GR | Gross | PR | Pair | TE | Ten |
| CA | Cartridge | HD | Hundred | PT | Pint | TF | Twenty-five |
| CB | Carboy | HK | Hank | PZ | Packet | TN | Ton (2,000 lb) |
| CD | Cubic Yard | IN | Inch | QT | Quart | TO | Troy Ounce |
| CE | Cone | JR | Jar | RA | Ration | TS | Thirty-six |
| CF | Cubic Foot | KG | Kilogram | RL | Reel | TU | Tube |
| CK | Cake | KT | Kit | RD | Round | VI | Vial |
| CL | Coil | LB | Pound | RL | Reel | YD | Yard |
| CM | Centimeter | LG | Length | RM | Ream |
Data Dictionary
| FIELD (EMALL NAME) | FIELD TYPE | FIELD SIZE | COMMENT | DESCRIPTION |
| Part Number (column A) | AN | 80 | REQUIRED | The number assigned by the vendor to a part 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 (column B) | AN | 120 | REQUIRED | The name used for a part being marketed to the customer. (Must not include the part number)(Do not use special characters ) |
| Price (column C) | N | 16,4 | REQUIRED | The amount of money required to purchase the part. Price entered may only have four digit after the decimal point. (Shipping must be included) |
| Unit of Issue (column D) | AN | 2 | REQUIRED | Description of how a part is packaged. There are Product UOI and Services UOI tabs on this spreadsheet. |
| Items Per Unit of Issue (column E) | N | 16,4 | REQUIRED | The number of parts which comprise the part's unit of issue. |
| OEM Name (column F) | AN | 80 | REQUIRED | The name assigned to a part being marketed to the customer by the original equipment manufacturer. |
| OEM Part Number (column G) | AN | 80 | REQUIRED | The number assigned by the original equipment manufacturer to a part in the catalog. This number may be the same as or different than the vendor's part number. |
| Description (column H) | AN | 512 | REQUIRED | Summary describing a part being marketed to the customer.(Can not be a repeat of the Product Name) (Must not include the part number)(Do not use special characters ) |
| Days ARO (column I) | N | 30 | REQUIRED | The number of days after receipt of order the part is expected to ship. |
| EXPANDED DESCRIPTION (column J) | AN | 2048 | Detailed description of a part being marketed to the customer. (Must not include the part number)(Do not use special characters ) | |
| 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 federal supply class (FSC) and a nine-digit national item identification number | |
| UPC (column L) | AN | 20 | Universal Product Code | |
| IMAGE DESCRIPTION (column M) | AN | 256 | Description of the image being used to represent a part. | |
| IMAGE NAME MANTECH HOSTED (column N) | AN | 512 | The file name associated to the part for display. (i.e. abc133.jpg) Images should 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 excepted. Images may also be mailed to DOD EMALL CCHS Images c/o ManTech 301 Summers St., Suite 4 Hinton, WV 25951 | |
| ENAC CODE (column O) | AN | 2 | Environmental Attribute Code | |
| UNSPSC (column P) | AN | 20 | United Nations Standard Products and Services Code (http://www.unspsc.org) | |
| HAZARDOUS MATERIAL (column Q) | AN | 10 | ||
| PRICE TBD (column R) | N | 1 | Value is 1 if price is "To Be Determined" | Price To Be Determined. This value must be set to 1 and the price set to 0 if a parts price is pending response from the vendor. I.e.: ODM (On Demand Manufacturing) parts |
| CLASSIFICATION CODE (column S) | AN | 50 | The short code used to represent the classification of the part. | |
| SHIPPING WEIGHT (column T) | N | 7,1 | Shipping weight represents the gross weight for a part during shipment. It includes the weight of the contents, wrappings, crates, boxes and containers. | |
| SHIPPING WEIGHT UNIT OF MEASURE | AN | 10 | A standard of basic quantity or increment by which a part is shipped. | |
| SHIPPING LENGTH | N | 8,1 | The gross length of the part being shipped including the wrappings, crates, boxes and containers. | |
| SHIPPING WIDTH | N | 8,1 | The gross width of the part being shipped including the wrappings, crates, boxes and containers. | |
| SHIPPING HEIGHT | N | 8,1 | The gross height of the part being shipped including the wrappings, crates, boxes and containers. | |
| SHIPPING UNIT OF MEASURE | AN | 10 | A standard of basic quantity or increment by which a part is shipped. | |
| PRODUCT WEIGHT | N | 8,1 | Product weight represents the weight for a part without shipping compliments. This weight does not include the weight of the wrappings, crates, boxes and containers. | |
| PRODUCT WEIGHT UNIT OF MEASURE | AN | 10 | A standard of basic quantity or increment used to describe how the part's weight is measured. | |
| PRODUCT LENGTH | N | 8,1 | The length of only the part without shipping compliments. | |
| PRODUCT WIDTH | N | 8,1 | The width of the part without shipping compliments. | |
| PRODUCT HEIGHT | N | 8,1 | The height of the part without shipping compliments. | |
| PRODUCT UNIT OF MEASURE | AN | 10 | A standard of basic quantity or increment used to describe how the part is measured. | |
| FEDERAL SUPPLY CLASS | N | 4 | Four digit code used to describe the Federal Supply Class assigned to the part. | |
| PACKAGE UNIT OF ISSUE | AN | 30 | ||
| PACKAGE ITEMS PER UNIT OF ISSUE | N | 10 | ||
| PACKAGE PRICE | N | 16,4 | ||
| SALE PRICE | N | 16,4 | The discounted amount of money required to purchase the part. | |
| SALE START DATE | D | 8 | The date for which the discounted price for a part becomes effective. | |
| SALE END DATE | D | 8 | The date for which the discounted price for a part terminates. | |
| COUNTRY OF ORIGIN | AN | 10 | Country where part was manufactured. | |
| COG CODE | AN | 2 | ||
| Best Guess Quantity | N | 10 | ||
| Best Guess Amount | N | 16,4 | ||
| Estimated Max Quantity | N | 10 | ||
| Estimated Max Amount | N | 16,4 | ||
| PB1 Quantity | N | 8 | The quantity that must be purchased in order for the PB1 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB2 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB3 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB4 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB5 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB6 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB7 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB8 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB9 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Quantity | N | 16,4 | The quantity that must be purchased in order for the PB10 break prices to be in effect. | |
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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. |
Reasons for Catalog Rejection
| List of common reasons 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. |
Services Unit of Issue Codes
| Unit of Issue Codes for Services | |||||
| AC | Acre | FV | Five | PI | Pillow |
| AM | Ampoule | FY | Fifty | PK | Package |
| AT | Assortment | GG | Great Gross | PL | Pallet/Unit Load |
| AY | Assembly | GI | Gill | PM | Plate |
| BA | Ball | GL | Gallon | PR | Pair |
| BD | Bundle | GM | Gram | PT | Pint |
| BE | Bale | GN | Grain | PX | Pellet |
| BF | Board Foot | GP | Group | PZ | Packet |
| BG | Bag | GR | Gross | QT | Quart |
| BK | Book | GS | Gross | RA | Ration |
| BL | Barrel | HD | Hundred | RD | Round |
| BO | Bolt | HF | Hundred Feet | RL | Reel |
| BQ | Briquet | HK | Hank | RM | Ream |
| BR | Bar | HP | Hundred Pounds | RO | Roll |
| BT | Bottle | HR | Hours | RX | Thousand Rounds |
| BX | Box | HS | Hundred Square Feet | SB | Square Mile |
| CA | Cartridge | HT | Half Hour | SC | Square Centimeters |
| CB | Carboy | HU | Hundred | SD | Skid |
| CC | Cubic Centimeter | HW | Hundred Weight | SE | Set |
| CD | Cubic Yard | HY | Yards | SF | Square Foot |
| CE | Cone | IN | Inch | SH | Sheet |
| CF | Cubic Foot | JR | Jar | SI | Square Inch |
| CG | Centigram | KG | Kilogram | SK | Skein |
| CI | Cubic Inch | KM | Kilometer | SL | Spool |
| CK | Cake | KR | Karat | SM | Square Meter |
| CL | Coil | KT | Kit | SO | Shot |
| CM | Centimeter | LB | Pound | SP | Strip |
| CN | Can | LF | Linear Foot | SQ | Square |
| CO | Container | LG | Length | ST | Set |
| CS | Case | LH | Labor Hour | SV | Skid |
| CT | Carton | LI | Liter | SX | Stick |
| CU | Curie | LM | Linear Meter | SY | Square Yard |
| CY | Cylinder | LO | Lot | TB | Tube |
| CZ | Cubic Meter | LS | Lump Sum | TC | Truckload |
| DA | Days | LY | Linear Yard | TD | Twenty-four |
| DC | Decagram | MC | Thousand Cubic Feet | TE | Ten |
| DE | Decimeter | ME | Meal | TF | Twenty-five |
| DG | Decigram | MF | Thousand Feet | TG | Gross Ton |
| DL | Deciliter | MG | Miligram | TN | Ton |
| DM | Dram | MI | Mile | TO | Troy Ounce |
| DO | Dollars | ML | Milliliter | TS | Thirty-six |
| DR | Drum | MM | Millimeter | TT | Tablet |
| DW | Pennyweight | MO | Months | TU | Tube |
| DZ | Dozen | MR | Meter | UN | Unit |
| EA | Each | MX | Thousand | US | U.S.P. Unit |
| EN | Each Collection | OT | Outfit | VI | Vial |
| EX | Exposure | OZ | Ounce | WK | Week |
| FD | Fold | PD | Pad | YD | Yard |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .