Attachment 13 OS3 Monthly Usage Report TemplateFinal 31Jan2014.xlsx
XLSX spreadsheet 136 KB Posted
- Attached to
- FSSI Office Supplies Strategic Sourcing Solution Third Generation (OS3) Purchasing Federal contract opportunity
- Solicitation number
- GSQ02-14-R-SA0001
- Issued by
- GSA Federal Acquisition Service
About this file
Monthly Usage Report Template
View the file
Other files for this federal contract opportunity
Show all 46
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
Report Template Ord_date Ord_num Prod_Descr Mfr_Name Mfr_Part_No UOI Qty UPC-A code FSC UNSPSC SubCategory OS3 Price MAS_Price Comm_list_price Reman_Toner Dlvry_Method Frgt_charge Ship_wt Disc_amt Suppl_fee Tot_pur_amt Dbt_Crdt_ind Cust_Agency Sub_Agency1 Sub_Agency2 Sub_Agency3 MAJCOM DODAAC Pay_Method Pay_date Sale_Ch To_zip_code From_zip_code Chrg_proc_date Tran_Num Contr_Name Contr_No
Data Descriptions
| Report Field | Field Full Name | Field Description | Data type | Data Length | Allow Null Value | Comments | Sample Data | |
| Ord_date | Order Date | mmddyyyy | date - mmddyyyy | 8 | No | MMDDYYYY - 07022010 for July 2nd 2010 | 08122010 | |
| Ord_num | Order Number | Free list | letters, numericals and special characters | 30 characters | No | contractor order number OR order number assigned by governement portal (i.e. GSA Advantage, DOD Emall) | N889798 | |
| Prod_Descr | Product Description | Free text | letters, numericals and special characters | 255 characters | No | Standardized descriptions used by wholesalers | GSA Y FLAG,TAPE,IN DISP,2PK,RE | |
| Mfr_Name | Manufacturer's name | Free text | letters, numericals and special characters | 50 characters | No | HP, DELL, etc | ||
| Mfr_Part_No | Manufacturer's part number | Free text | letters, numericals and special characters | 50 characters | No | 45328ZE | ||
| UOI | Unit of Issue | Free List | strings | 30 characters | No | Restricted List: https://www.gsaadvantage.gov/advgsa/advantage/information/page.do?BV_UseBVCookie=Yes&keyName=UNIT_DEFINITIONS&uom=#KT | EA | |
| Qty | Number of units purchased | Free list | integers | Unrestricted | No | 100 | ||
| UPC-A code | UPC is the barcode mainly used for scanning of trade items at the point of sale | 12 characters | yes | Include if applicable | ||||
| FSC Code | Federal Supply Classification (FSC) codes are used to group products into logical families for management purposes. The four-digit fieldsare used to group standardization documents and their products into logical families | Free list | integers | 10 characters | No | Most items should fall within: 7510, 7520, 7530, 7540 | 7510 (for Office Supplies) | |
| UNSPSC | United Nations Standard Products and Service Codes. UNSPSC for a given item is composed of five two-digit identifiers, which together categorize the item into a five-level hierarchy. The five levels of the classification are "Segment", "Family", "Class", "Commodity", and "Business Function". | Free list | integers | 10 characters | Yes | This field is not mandatory | 56101700 | |
| SubCategory | Item subcategory | Restricted list | strings | Upto 30 chars | No | Restricted List: General Office supplies, Paper, Toner, Ink | Can be either office supplies, paper or toner | |
| OS3 Price | OS3 Price | Free list/Catalog | Floating numbers | Unrestricted | No | 2045.35 | ||
| MAS_Price If any | MAS price | Free list/Catalog | Floating numbers | Unrestricted | yes | Only if contractor has a MAS contract | 1456.99 | |
| Comm_list_price | Fixed Commercial List Price | catalog | Floating numbers | Unrestricted | No | Distributors wholesale list price | 395.99 | |
| Reman_Toner | Indicator of Reman toner (not OEM) | Yes/No | No | Should be listed as "Yes" if toner/ink item is a compatible or remanufactured item; "No" if it is an OEM item | yes | |||
| Dlvry_Method | Delivery Method | Restricted list | strings | Upto 30 chars | No | Restricted List: Standard, Next Business Day, Desktop, Secure Desktop, Next Day Desktop, Next Day Secure Desktop, International | Standard | |
| Frgt_charge | Shipping/Freight charges | Catalog | Floating numbers | No | only if other than standard shipping used | 8.95 | ||
| Ship_wt | Shipping weight | Free list | Floating numbers | Unrestricted | Yes | *Optional | 12 pounds | |
| Disc_amt | Discount Amount | Free list/Catalog | Floating numbers | Unrestricted | Yes | The difference between the OS3 price and the vendor's Commercial price | 245.35 | |
| Suppl_fee | Supplemental fees charged (e.g., processing orders below the minimum, etc.) | Free list | Floats | Yes | Fees should only be charged if order is below the order minimum or special instructions are required | 25.00 | ||
| Tot_pur_amt | Total Purchase Amount | Free list/Catalog | Floating numbers | Unrestricted | No | Total amount of line item (NOT total order amount) | 2045.35 | |
| Dbt_Crdt_ind | Debit Credit Indicator | Restricted list | 1 character | one character (D or C) | No | D for Debit - sales drafts | ||
| C for Credit - credit voucher and sales reversals | D | |||||||
| Cust_Agency | Customer Agency Name | Restricted list | strings | No | Restricted List: Customer agency name as provided in guidance | Department of the Navy | ||
| Sub_Agency1 | Bureau/Sub-Agency Level 1 | Open text | strings | No | Restricted List: Customer agency name as provided in guidance | Marine Corps | ||
| Sub_Agency2 | Bureau/Sub-Agency Level 2 | Open text | strings | Yes | If available | |||
| Sub_Agency3 | Bureau/Sub-Agency Level 3 | Open text | strings | Yes | If available | |||
| MAJCOM | Major Command | Restricted list | strings | Yes | If available | |||
| DODAAC | Department of Defense Activity Address Code is a six position code that uniquely identifies a Department of Defense unit, activity, or organization that has the authority to requisition and/or receive material. These codes are particularly important for Defense Department financial, contracting, and auditing records. The codes are used across the entire Federal Government when ordering supplies using MILSTRIP, FEDSTRIP, or DLMS (Defense Logistic Management Standards Office) | Open text | strings | Yes | If available | |||
| Pay_Method | Payment method | Restricted list | strings | No | Restricted List: Government SmartPay Card; Employee Credit Card; AAC/DODAAC; ETF; Check; NET 30; Other | |||
| Pay_date | Payment Date | mmddyyyy | date - mmddyyyy | 8 | No | MMDDYYYY - 07022010 for July 2nd 2010 - Date on which the payment was completed | 08122010 | |
| Sale_Ch | Sales channel | Restricted list | strings | No | Restricted List: Phone, fax, e-mail, GSA Advantage, e-Buy, DoD EMALL, Vendor Portal, Walk-in Store and Other | |||
| To_zip_code | Ship to Zip Code | char | Numericals | 5 digits | No | Shipping Destination Zip code, should be five digits | 01282 | |
| From_zip_code | Ship From Zip Code | char | Numericals | 5 digits | Yes | Shipping Origination Zip code (If available*) | 20101 | |
| Chrg_proc_date | Date contractor processed charge/credit | mmddyyyy | date - mmddyyyy | 8 | No | Date on which the charge or credit was processed by the contractor- MMDDYYYY - 07022010 for July 2nd 2010 | 08122010 | |
| Tran_Num | Contractor processing transaction reference number for charge/credit | Free list | letters, numericals and special characters | 30 characters | No | Contractor processing transaction reference number for charge/credit | ZHJ9809809 | |
| Contr_Name | Name of the OS3 contractor | Restricted list | strings | No | Company Name | |||
| Contr_No | OS3 contract number | Restricted list | integers, special chars and letters | No | GS-XXF-XXXXXXXXXXX |
File Naming
| Report File Name Should follow the naming convention below: |
| Contrat_Number-usg-mmyyyy.xls |
| Eg: GS-23F-FS001-usg-062010.xls |
File details come from the government source that posted it. Updated .