Attachment_0009_-_SA_LWSP_SASP_Transaction_Card_Tool.xls

XLS spreadsheet 74 KB Posted

Attached to
M110 Semi-automatic Sniper System (SASS)
Solicitation number
W56HZV17R0026
Issued by

About this file

Attachment 0009 - SA LWSP SASP Transaction Card Tool

View the file

Other files

Show all 17

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

Export as Fixed Length File

3312215661275
DICRICTransaction 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

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.

File details come from the government source that posted it.