Attachment 0007 - SA_LWSP Transaction Card Tool.xlsx
XLSX spreadsheet 26 KB Posted
- Attached to
- Solicitation_Barrel and Front Sight Assembly Federal contract opportunity
- Solicitation number
- W912CH-24-R-0123
- Issued by
- Department of the Army
About this file
This is a transaction card tool spreadsheet template that provides instructions and formatting requirements for exporting transaction data to LOGSA (Logistics Support Activity) in a fixed-length file format. The template specifies field lengths and data requirements for various elements including Document Identifier Code (DIC), Routing Identifier Code (RIC), transaction codes for shipments and receipts, NSN/MCN numbers, document numbers, DODAAC information, weapon serial numbers, and calendar dates.
The associated solicitation is for a five-year Firm-Fixed Price Requirements Contract for Barrel and Front Sight Assembly (NSN: 1005-01-233-8529, Part No.: 9390007) issued by the Army Contracting Command - Detroit Arsenal. The solicitation (W912CH-24-R-0123) is a 100% Small Business Set-Aside requiring Military Packaging Level B and Special Packaging Instructions. The technical data package is Export Controlled (Distribution F) and requires Joint Certification Program (JCP) certification for access. Questions should be directed to Contract Specialist Ryan Nawrocki.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| W912CH24R0123- QA.xlsx | XLSX spreadsheet | |
| W912CH24R0123- QA.xlsx | XLSX spreadsheet | |
| W912CH24R0123- QA.xlsx | XLSX spreadsheet | |
| W912CH24R0123- QA.xlsx | XLSX spreadsheet | |
| W912CH24R0123- QA.xlsx | XLSX spreadsheet | |
| W912CH24R0123- QA.xlsx | XLSX spreadsheet | |
| W912CH24R0123-0004.pdf | ||
| W912CH24R0123- QA.xlsx | XLSX spreadsheet | |
| W912CH24R0123- QA.xlsx | XLSX spreadsheet | |
| W912CH24R0123-0003.pdf | ||
| W912CH24R0123-0001.pdf | ||
| W912CH24R0123-0002.pdf | ||
| W912CH24R0123.pdf | ||
| Attachment 0006 - SA_LWSP Instructions to Contractors.doc | DOC document | |
| Attachment 0005 - FAT Waiver Worksheet.pdf | ||
| Attachment 0002 - Certificate of Technical Data Destruction.pdf | ||
| Attachment 0004 - Non Disclosure Agreement.pdf | ||
| Attachment 0003 - Government Furnished Ammunition.pdf | ||
| W912CH24R0123_Barrel and Front Sight Assembly.pdf | ||
| Attachment 0001 - Government Furnished Property.xlsx | XLSX spreadsheet |
Show all 20
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Export as Fixed Length File Ajay Singh:
The first row indicates the length of the field (in chars). This will be used as the field width when exporting the .xls to .txt to the fixed-width format that LOGSA requires. Make sure the Excel file is saved to the desired folder and have Macros enabled.
To export data, select the range that you want to export (do not include the first or second row) and press the Export Data button below.
A text file entitled SASP_TRANSACTION_CARD.txt will be saved and created in the same folder in which this workbook resides. This file can be renamed accordingly but the title must not include spaces.
| The text file will open in Excel when created. Do not save the text file in Excel because it will alter the formatting. Open the file in Notepad to verify the information and formatting is correct before sending to LOGSA. | 3 | 1 | 22 | 15 | 6 | 6 | 12 | 7 | 5 |
| DIC | RIC | Transaction Code. P,F, N shipments or R receipts (1 digit) | NSN or MCN if no NSN is available (13 digits) | Document number specified in contract section B (14 Digits) | Ship to/ | ||||
| Receipt from DODAAC (6 Digits) | Reporter | ||||||||
| DODAAC (6 Digits) | Weapon Serial |
number (Max
| 11 Digits) | Owning |
| DODAAC (6 Digits) | Last 2 digits of |
the calender year and the julian day of the year (5 Digits) Example 11021
DSM AGT X XXXXXXXXXXXXX XXXXXXXXXXXXXX XXXXXX XXXXXX XXXXXXXXXXX XXXXXX XXXXX
image1.emf
File details come from the government source that posted it. Updated .