Attachment C.xlsm

This file is a data template and key field description document for vendor transaction reporting under a NASPO ValuePoint state and local contract opportunity for STC FLAGS in South Carolina. The document establishes the standardized format and field definitions required for contractors to report sales data, including vendor information, customer billing and shipping details, purchase order numbers and dates, shipment dates, invoice information, product details with UNSPSC commodity codes, pricing structures, quantities, and administrative fees. The template accommodates various customer segments including state government, K-12 education, higher education, local government, and medical entities, with provisions for tracking different order types such as sales orders, credits/returns, and upgrades/downgrades. All transaction data must be reported using the specified field structure with pricing in US currency format and quantities supporting extended price calculations.

The document specifies that vendors must report list prices, NASPO ValuePoint contract prices, and applicable administrative fees for each transaction, with the administrative fee calculated as a percentage of the total price. The template includes optional fields for tracking value-added resellers, distributors, and Energy Star compliance status. The data collection framework is designed to provide comprehensive visibility into contract utilization across all participating jurisdictions and customer segments, enabling performance monitoring and compliance verification throughout the contract term. All monetary amounts are to be reported in US currency with appropriate decimal precision, and zip codes must be formatted in standard five or nine-digit configurations.