Attachment_10_DOD_EMALL_-_Supplier_Informational_Package.pdf

INSTRUCTIONS

FIELD COLUMN DESCRIPTION

Part Number A Supplier's part number (MUST NOT Include the Part Name - NO Special Characters)

Part Name B The name of the part (MUST NOT Include the Part Name - NO Special Characters)

Price C Buyers cost (shipping must be included)

UOI D This would be Each, Box, Package etc..., Refer To the Unit of Issue Codes

Items per UOI E Amount of items in a box or package

OEM Name F The name of the company that Manufactured the item

OEM PN G The Manufactures part number

Description H Description of the item (MUST BE DIFFERENT than Part Name - MUST NOT Include Part Number - NO Special Characters)

Days ARO I Time frame from receipt of order to shipment to the customer

LONG_DESCRIPTION J Detailed description of item (MUST NOT Include Part Number - DO NOT USE Special Characters)

NSN's K National Stock Number assigned by the Government

UPC L Universal Product Code

Image Description M File name of images (i.e http://www.actiongear.com/agcatalog/pics/acb133_Dry.jpg or abc133.jpg)

Image Ref N You may enter the URL attached to the image

ENAC O Environmental Code to display recycled symbol

UNSPSC P United Nations Standard Products and Services Code

RED Text indicates MANDATORY

BLACK Text indicates OPTIONAL

DOD EMALL Required Data Elements

ITEM FIELD (EMALL NAME) FIELD

TYPE

FIELD

SIZE COMMENT DESCRIPTION

1 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 )

2 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 )

3 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)

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

5 Items Per Unit of Issue ( Column E ) N 16,4 REQUIRED The number of parts which comprise the part's unit of issue.

6 OEM Name ( Column F ) AN 80 REQUIRED The name assigned to a part being marketed to the customer by the original equipment manufacturer.

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

8 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 )

9 Days ARO ( Column I ) N 30 REQUIRED The number of days after receipt of order the part is expected to ship.

10 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 )

11 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

12 UPC ( Column L ) AN 20 Universal Product Code

13 IMAGE DESCRIPTION ( Column M ) AN 256 Description of the image being used to represent a part.

IMAGE URL IF SELF HOSTED

OR ( Column N )

IMAGE NAME MANTECH HOSTED

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

15 ENAC CODE ( Column O ) AN 2 Environmental Attribute Code

16 UNSPSC ( Column P ) AN 20 United Nations Standard Products and Services Code (http://www.unspsc.org)

17 HAZARDOUS MATERIAL ( Column Q ) AN 10

18 PRICE TBD ( Column R ) N 1 Value = 1 if price is "TBD"

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

19 CLASSIFICATION CODE ( Column S ) AN 50 The short code used to represent the classification of the part.

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

21 SHIPPING WEIGHT UNIT OF MEASURE AN 10 A standard of basic quantity or increment by which a part is shipped.

22 SHIPPING LENGTH N 8,1 The gross length of the part being shipped including the wrappings, crates, boxes and containers.

23 SHIPPING WIDTH N 8,1 The gross width of the part being shipped including the wrappings, crates, boxes and containers.

24 SHIPPING HEIGHT N 8,1 The gross height of the part being shipped including the wrappings, crates, boxes and containers.

25 SHIPPING UNIT OF MEASURE AN 10 A standard of basic quantity or increment by which a part is shipped.

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

27 PRODUCT WEIGHT UNIT OF MEASURE AN 10 A standard of basic quantity or increment used to describe how the part's weight is measured.

28 PRODUCT LENGTH N 8,1 The length of only the part without shipping compliments.

29 PRODUCT WIDTH N 8,1 The width of the part without shipping compliments.

30 PRODUCT HEIGHT N 8,1 The height of the part without shipping compliments.

31 PRODUCT UNIT OF MEASURE AN 10 A standard of basic quantity or increment used to describe how the part is measured.

32 FEDERAL SUPPLY CLASS N 4 Four digit code used to describe the Federal Supply Class assigned to the part.

33 PACKAGE UNIT OF ISSUE AN 30

34 PACKAGE ITEMS PER UNIT OF ISSUE N 10

35 PACKAGE PRICE N 16,4

36 SALE PRICE N 16,4 The discounted amount of money required to purchase the part.

37 SALE START DATE D 8 The date for which the discounted price for a part becomes effective.

TYPE

FIELD

SIZE COMMENT DESCRIPTION

38 SALE END DATE D 8 The date for which the discounted price for a part terminates.

39 COUNTRY OF ORIGIN AN 10 Country where part was manufactured.

40 COG CODE AN 2

41 Best Guess Quantity N 10 42 Best Guess Amount N 16,4 43 Estimated Max Quantity N 10 44 Estimated Max Amount N 16,4

45 PB1 Quantity N 8 The quantity that must be purchased in order for the PB1 break prices to be in effect.

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

66 PB2 Quantity N 16,4 The quantity that must be purchased in order for the PB2 break prices to be in effect.

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

87 PB3 Quantity N 16,4 The quantity that must be purchased in order for the PB3 break prices to be in effect.

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

108 PB4 Quantity N 16,4 The quantity that must be purchased in order for the PB4 break prices to be in effect.

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

129 PB5 Quantity N 16,4 The quantity that must be purchased in order for the PB5 break prices to be in effect.

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

150 PB6 Quantity N 16,4 The quantity that must be purchased in order for the PB6 break prices to be in effect.

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

171 PB7 Quantity N 16,4 The quantity that must be purchased in order for the PB7 break prices to be in effect.

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

192 PB8 Quantity N 16,4 The quantity that must be purchased in order for the PB8 break prices to be in effect.

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

213 PB9 Quantity N 16,4 The quantity that must be purchased in order for the PB9 break prices to be in effect.

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

234 PB10 Quantity N 16,4 The quantity that must be purchased in order for the PB10 break prices to be in effect.

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

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

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

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

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

TYPE

FIELD

SIZE COMMENT DESCRIPTION

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

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

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

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

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

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

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

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

COMMON REASONS FOR CATALOG REJECTION

1 Column Headers are Removed, Hidden or Renamed

2 These are the ONLY Special Characters ALLOWED by the DOD EMALL System

3 Missing One (or more) MANDATORY Data Elements

4 Days ARO field MUST BE a POSITIVE INTEGER - NO TEXT or Special Characters Allowed

5 Unit of Issue MUST BE an APPROVED Two-Digit Code taken from the Unit of Issue Codes

6 N/A is used in any field - ALL USED FIELDS must contain Valid Data

7 The Part Name and Description are the same.

8 Image Placeholder Shows "No Image Available"

9 Part Price EXCEEDS Four (4) Digits AFTER the Decimal Point

AM Ampoule EX Exposure OT Outfit AT Assortment FD Fold OZ Ounce AY Assembly FR Frame PD Pad BA Ball FT Foot PG Package BD Bundle FV Five PI Pillow BE Bale FY Fifty PM Plate BF Board Foot GG Great Gross PR Pair BG Bag GI Gill PT Pint BK Book GL Gallon PX Pellet BL Barrel GM Gram PZ Packet BO Bolt GN Grain QT Quart BQ Briquet GP Group RA Ration BR Bar GR Gross RD Round BT Bottle HD Hundred RL Reel BX Box HF Hundred Feet RM Ream CA Cartridge HK Hank RO Roll CB Carboy HP Hundred Pounds RX Thousand Rounds CC Cubic Centimeter HS Hundred Square SD Skid CD Cubic Yard HW Hundred Weight SE Set CE Cone HY Hundred Yards SF Square Foot CF Cubic Foot IN Inch SH Sheet CG Centigram JR Jar SI Square Inch CI Cubic Inch KG Kilogram SK Skein CK Cake KM Kilometer SL Spool CL Coil KR Carat SM Square Meter CM Centimeter KT Kit SO Shot CN Can LB Pound SP Strip CO Container LF Linear Foot SQ Square CU Curie LG Length SX Stick CY Cylinder LI Liter SY Square Yard CZ Cubic Meter LI Liter TD Twenty-four DC Decagram MC Thousand Cubic TE Ten DE Decimeter MC Thousand TF Twenty-five DG Decigram ME Meal TN Ton (2,000 lb) DL Deciliter MF Thousand Feet TO Troy Ounce DM Dram MG Milligram TS Thirty-six DR Drum MI Mile TT Tablet DW Pennyweight ML Milliliter TU Tube DZ Dozen MM Millimeter US U.S.P. Unit EA Each MR Meter VI Vial

PRODUCT - Unit of Issue Codes

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 FR Frame PG Package YR Years FT Foot PH Pack / PAK

Unit of Issue Codes for Services