Attachment_04_-_Electronic_Pack_Data_File_Report_Format.pdf

ATTACHMENT 04: Electronic Pack Data File Report Format

USAMMA Sets, Kits, Outfits (SKO) Supply Requirement

1. Contractor shall provide an Electronic Pack Data File Report using Microsoft Excel Application and sent via electronic mail to COR and CTA for every SKOs Supply Requirement DO issued under this CONTRACT. All electronic files must be compatible with the most current version of Microsoft Office Application. All data must be provided in upper case lettering. Electronic Pack Data Files format will be provided using the following template:

Format Template for Excel Pack Data File Report Format Worksheets:

FIELD TITLE LENGTH REMARKS

BDN 4 Alpha/Numeric

.ACN 8 Numeric

Assemblage ID Number 2 Default to ‘01’

NSN 13 Numeric

Nomenclature 45 Leave blank

Quantity Packed 7 Numeric Whole Numbers

Unit of Issue 2 Alpha – blank

Manufacturer Name 20 Alpha; All Caps

Manufacturer Date 4 Alpha YYMM

Expiration Date 4 Alpha YYMM

Serial/Lot/Contract Indicator

Serial number takes precedent over lot and contract number.

1 ‘S’ = Serial Number

‘L’ = Lot Number

‘C’ = Contract Number

Serial/Lot/Contract Number 20

Filler 1

Container/Pallet Number Low 4 Sub Location

Container/Pallet Number High 4 Primary Location

2. This template must be utilized for each item in each USAMMA SKOs Supply Requirement DO to include all equipment items as well as set builds.

3. If an NSN has multiple serial numbers, lot numbers or manufacturer information than a separate NSN record must be created with the appropriate packed quantity. The “Field” column need only be completed for each item of the Sets, Kits and Outfits. The “Type” and “Notes” items are for descriptive purposes only.

4. The Contractor shall provide this report via electronic mail (e-mail) message to the following e-mail addresses:

To be completed at time of award

5. The Government will notify the Contractor if there is any change to the above USAMMA CTAs’ e-mail addresses.