Attachment 3 - List of Integrations (Revised) .xlsx
XLSX spreadsheet 15 KB Posted
- Solicitation number
- 47HAA021R0001
- Issued by
-
GSA Office of Administrative Services
About this file
This document provides details for a federal contract solicitation seeking an advanced metering, utility, and waste data tracking solution. The General Services Administration's Office of the Chief Information Officer - Office of Public Buildings Information Technology Services, in support of the PBS Office of Facilities Management and Office of Financial Management, is seeking a cloud-based, commercial-off-the-shelf enterprise solution to replace existing applications and services for energy usage analysis, advanced metering, solid waste tracking, and utility invoice processing. Offerors must submit proposals by 10AM ET on August 20, 2021. The solution will provide a single integrated environment to be managed by a single contractor and include hosting, licensing, configuration, data architecture, integration, and support services. Questions regarding this requirement are due by July 27, 2021 to the identified contracting staff.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 6 - Required Price Template 08_18_2021 rev.xlsx | XLSX spreadsheet | |
| Amendment 47HAA021R0001_0002.pdf | ||
| Amendment no. 2 - Government Responses (EUAS) - Round 2.pdf | ||
| Amendment No. 1 - Government Responses (EUAS).pdf | ||
| Amendment 47HAA021R0001_0001.pdf | ||
| Appendix E - Sample Load Profile Template .xlsx | XLSX spreadsheet | |
| Attachment 12 - Tier 3 Help Desk.xlsx | XLSX spreadsheet | |
| Appendix G - Recent File Accruals.xlsx | XLSX spreadsheet | |
| Attachment 11 - Utility Vendors.xlsx | XLSX spreadsheet | |
| Attachment 10 - Advanced Metering Types.xlsx | XLSX spreadsheet | |
| Attachment 4_Demo Instructions (rev 7.28.2021).docx | DOCX document | |
| Appendix F - Sample Power Quality Template.xlsx | XLSX spreadsheet | |
| Appendices A-D.zip | ZIP file | |
| Solicitation No. 47HAA021R0001 - Advanced Metering.pdf | ||
| Attachments 1-9.zip | ZIP file |
Show all 15
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
Systems Integration List
| Column Name | Field Type | Max Length | Required | Validation Rules | Purpose | Header or Line | FSD Mapping |
| Invoice Number | AN | 20 | Required by System | If missing, the invoice line |
record will not be processed. Must not contain any of the following characters:
· Space
| · | | Unique identifier of the invoice. | Header | Invoice Number (Bill ID) | |||||
| Invoice Line Number | N | 5 | Required by System | If missing, the invoice line record | ||||
| will not be processed. | Unique identifier of the invoice line number. Note: Invoice line numbers should be provided in sequential order starting with 1 | Line | 1,2,3,4,….etc. | |||||
| Vendor Code | AN | 10 | Required by System | If missing, the invoice line | ||||
| record will not be processed. | Part of the unique identifier of the vendor or account associated with the invoice in VSS, when paired with Vendor Address Code. | Header | Populate with “510374236”. | |||||
| Vendor Address Code | AN | 13 | Required by System | If missing, the invoice line record will not be processed. | Part of the unique identifier of the vendor or account associated with the invoice in VSS, when paired with Vendor Code. | Header | Populate with “00022”. | |
| Vendor Registration Number (VRN) | AN | 30 | Optional | If VRN is not populated the system will infer the vendor information using the vendor code/vendor address code. | Unique Identifier of the vendor or account associated with the invoice in VSS. | Header | ||
| Contract Number Reference | AN | 30 | Required by USDA | Each invoice line must reference a contract number or blanket purchase agreement (BPA) number or an obligation number. All invoice lines within the same invoice must reference the same contract number, if supplied. | Identifies the contract number for which the invoice is being submitted. | Header and Line | Populate with the GSA Contract Number. |
(Contract Number on Masterfile)
| Contract Line Number Reference | N | 5 | Optional | Required if contract number reference is supplied. | Identifies the Contract Line Number for which the invoice is being submitted. | Line | |
| Sub-Contract Line Number Reference | AN | 2 | Required by USDA | Identifies the Sub -Contract Line Number for which the invoice is being submitted. | Line | Populate with the GSA MDL Number. |
(Sub Contract Line Number on Masterfile)
| BPA Number Reference | AN | 30 | Optional | Each invoice line must reference a contract number or BPA number or an obligation number. | Identifies the BPA number for which the invoice is being submitted. | Header and Line | |
| BPA Line Number Reference | N | 5 | Optional | Required if BPA number referenced is supplied. | Identifies the BPA Line Number for which the invoice is being submitted | Line | |
| Sub BPA Line Number Referenced | N | 2 | Optional | Identifies the Sub BPA Line Number for which the invoice is being submitted | Line | ||
| Obligation Number Reference | AN | 30 | Optional, only required if unreference d invoice = F | If unreferenced invoice = F and missing, the invoice line record will not be processed. All invoice lines within the same invoice must reference the same obligation. | Identifies the Award or Order for which the invoice is being submitted. | Header and Line | |
| Obligation Line Number Reference | N | 5 | Optional, only required if unreference d invoice = F | If unreferenced invoice = F and missing, the invoice line record will not be processed. | Identifies the Award or Order line number for which the invoice is being submitted. | Line | |
| Commodity Name | AN | 60 | Optional | Required if Quantity, Unit Price, and Unit of Issue are supplied. This must match the Commodity Name used on the Award or Order being referenced on the invoice. | Identifies the product or service for which the invoice is being submitted. | Line | |
| Quantity | N | 21,6 | Optional | Required if Commodity Name, Unit Price, and Unit of Issue are supplied. | Identifies the quantity for which the invoice is being submitted, as related to the supplied Commodity Name. | Line | |
| Unit Price | N | 21,6 | Optional | Required if Commodity Name, Unit Price, and Unit of Issue are supplied. | Identifies the unit price associated with each product or service for which the invoice is being submitted, as related to the supplied Commodity Name. If Unit Price and Quantity are supplied, the invoice amount will be calculated as Unit Price * Quantity. | Line | |
| Unit of Issue | AN | 30 | Optional | Identifies the unit associated with the product or service for which the invoice is being submitted. If supplied, the Unit of Issue for the invoice should match the Unit of Issue used on the Award or Order being referenced by the invoice. | Line | ||
| Invoice Amount | N | 21,6 | Required by USDA | Required if Unit Price and Quantity are not supplied. | Indicates the amount for which the invoice is being submitted. If Quantity and Unit Price are supplied, this field will be ignored and the invoice amount will be calculated using Unit Price * Quantity. | Line | Dollar amount for the invoice accounting line. |
| Credit Amount | N | 21,6 | Optional | Indicates the amount of any credits being included on the invoice. | Header | ||
| Discount Day 1 | N | 3 | Optional | The number of days entered for Discount Day 1 must be less than the number of days entered for Discount Day 2, Discount Day 3, and Discount Day 4 if provided. | Header | ||
| Discount Day 2 | N | 3 | Optional | The number of days entered for Discount Day 2 must be more than the number of days entered for Discount Day 1 and less than the number of days entered for Discount Day 3 and Discount Day 4 if provided. | Used in conjunction with Discount Amount 2 or Discount Percent 2 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 2, the amount of the discount taken will be determined using Discount Amount 2 or Discount Percent 2. | Header | |
| Discount Day 3 | N | 3 | Optional | The number of days entered for Discount Day 3 must be more than the number of days entered for Discount Day 1 and Discount Day 2 and less than the number of days entered for Discount Day 4 if provided. | Used in conjunction with Discount Amount 3 or Discount Percent 3 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 3, the amount of the discount taken will be determined using Discount Amount 3 or Discount Percent 3. | Header | |
| Discount Day 4 | N | 3 | Optional | The number of days entered for Discount Day 4 must be more than the number of days entered for Discount Day 1, Discount Day 2, and Discount Day 3 if provided. | Used in conjunction with Discount Amount 4 or Discount Percent 4 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 4, the amount of the discount taken will be determined using Discount Amount 4 or Discount Percent 4. | Header | |
| Discount Amount 1 | N | 3,2 | Optional | If Discount Day 1 is supplied, either Discount Amount 1 or Discount Percent 1 must also be supplied, but not both. | Used in conjunction with Discount Day 1 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 1, the amount of the discount taken will be determined using Discount Amount 1 if supplied. | Header | |
| Discount Amount 2 | N | 3,2 | Optional | If Discount Day 2 is supplied, either Discount Amount 2 or Discount Percent 2 must also be supplied, but not both. | Used in conjunction with Discount Day 2 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 2, the amount of the discount taken will be determined | Header | |
| Discount Amount 3 | N | 3,2 | Optional | If Discount Day 3 is supplied, either Discount Amount 3 or Discount Percent 3 must also be supplied, but not both. | Used in conjunction with Discount Day 3 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 3, the amount of the discount taken will be determined using Discount Amount 3 if supplied. | Header | |
| Discount Amount 4 | N | 3,2 | Optional | If Discount Day 4 is supplied, either Discount Amount 4 or Discount Percent 4 must also be supplied, but not both. | Used in conjunction with Discount Day 4 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 4, the amount of the discount taken will be determined using Discount Amount 4 if supplied. | Header | |
| Discount Percent 1 | N | 3,3 | Optional | If Discount Day 1 is supplied, either Discount Amount 1 or Discount Percent 1 must also be supplied, but not both. The supplied value must be less than or equal to 100. | Used in conjunction with Discount Day 1 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 1, the amount of the discount taken will be determined using Discount Percent 1 if supplied. | Header | |
| Discount Percent 2 | N | 3,3 | Optional | If Discount Day 2 is supplied, either Discount Amount 2 or Discount Percent 2 must also be supplied, but not both. The supplied value must be less than or equal to 100. | Used in conjunction with Discount Day 2 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 2, the amount of the discount taken will be determined using Discount Percent 2 if supplied. | Header | |
| Discount Percent 3 | N | 3,3 | Optional | If Discount Day 3 is supplied, either Discount Amount 3 or Discount Percent 3 must also be supplied, but not both. The supplied value must be less than or equal to 100. | Used in conjunction with Discount Day 3 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 3, the amount of the discount taken will be determined using Discount Percent 3 if supplied. | Header | |
| Discount Percent 4 | N | 3,3 | Optional | If Discount Day 4 is supplied, either Discount Amount 4 or Discount Percent 1 must also be supplied, but not both. The supplied value must be less than or equal to 100. | Used in conjunction with Discount Day 4 to specify discount terms on the invoice. If the invoice is paid within the number of days provided in Discount Day 4, the amount of the discount taken will be determined using Discount Amount 4 if supplied. | Header | |
| Period of Performance Start Date | Date | 10 | Required by USDA | Period of Performance Start Date must occur before Period of Performance End Date. | Indicates the start date for the period of performance associated with the activity for which an invoice is being submitted. | Line | Populate with Service Period Beginning |
| Period of Performance End Date | Date | 10 | Required by USDA | Period of Performance Start Date must occur before Period of Performance End Date. | Indicates the end date for the period of performance associated with the activity for which an invoice is being submitted. | Line | Populate with Service Period End |
| PSC | AN | 4 | Optional | Indicates the Product Service Code (PSC) associated with the product or service for which the invoice is being submitted. | Line | ||
| NAICS | AN | 6 | Optional | Indicates the North American Industrial Classification System (NAICS) Code associated with the product or service for which the invoice is being submitted. | Line | ||
| SIC | AN | 4 | Optional | Indicates the Standard Industrial Classification (SIC) Code associated with the product or service for which the invoice is being submitted. | Line | ||
| NSN | AN | 30 | Optional | Indicates the National Stock Number (NSN) associated with the product for which the invoice is being submitted. | Line | ||
| Delivery Date | Date | 10 | Optional | Indicates the date of delivery for the product or service for which the invoice is being submitted. | Header and Line | ||
| FOB | AN | 40 | Optional | If supplied, the FOB must be one of the accepted values as listed in section 1.3 – Freight On Board Values. | Indicates the Freight on Board (FOB) location determining who pays the shipping charges. | Header and Line | |
| Additional Markings | AN | 30 | Optional | Indicates additional information that can be used to further identify the shipping location or delivery method. | Header and Line | ||
| Description | AN | 225 | Required by USDA | Provides the ability to enter any additional information on the invoice that may be helpful or useful. | Line | Populate with Service Period Start Date + Service Period End Date + Utility Company Name |
Example: 04/18/2018-05/16/2018 UGI UTILITIES INC.
Invoice Title AN 50 Required by USDA Provides the ability to input a title for referencing the invoice. Header Populate with the GSA Purchase Order Number.
(PDN Number on Masterfile)
| Invoice Office Code | AN | 10 | Optional | Required if Invoice Office Address Code is supplied. | Part of the unique identifier of the Invoicing Office that will receive the invoice, when paired with Invoice Office Address Code. | Header | Populate with “GSAINVOICE” |
| Invoice Office Address Code | AN | 5 | Optional | Required if Invoice Office Code is Supplied. | Part of the unique identifier of the vendor or account associated with the invoice in VSS, when paired with Invoice Office Code. | Header | Populate with “VSS” |
| Unreferenced Invoice | Boolean | 1 | Required by System | Valid values are: T=True F=False | Is used as an indicator for the Invoice Upload batch process will need to verify user’s permissions to create unreferenced Invoices. | Header | “T” |
| Accounting Template | AN | 10 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Accounting Template Code for which the invoice is being submitted. | Line | |
| Partition | AN | 10 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Partition Code for which the invoice is being submitted. | Line | |
| BBFY | AN | 4 | Required by System | This field will only be processed if Unreferenced Invoice value = T. | Identifies the BBFY for which the invoice is being submitted. | Line | Current Fiscal Year (YYYY) |
| EBFY | AN | 4 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the EBFY for which the invoice is being submitted. | Line | Populated with the ending budget fiscal year (YYYY), if applicable. |
| Fund | AN | 20 | Required by system | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Fund Code for which the invoice is being submitted. | Line | Populate with the Fund (appropriation Code). |
(Fund on Masterfile) Division AN 20 Required by System This field will only be processed if Unreferenced Invoice value = T. Identifies the Division Code for which the invoice is being submitted. Line Populate with the Division (Region) code.
(Region on Masterfile) Organization AN 20 Required by System This field will only be processed if Unreferenced Invoice value = T. Identifies the Organization Code for which the invoice is being submitted. Line Populate with the Organization code.
(Org Code on Masterfile)
| Sub Organization | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Sub Organization Code for which the invoice is being submitted. | Line | |
| Program | AN | 20 | Required by USDA | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Program Code for which the invoice is being submitted. | Line | Populate with the Program (budget activity) code. |
(Program on Masterfile) Project AN 20 Optional This field will only be processed if Unreferenced Invoice value = T. Identifies the Project Code for which the invoice is being submitted. Line Populate with the Project number.
(Project Number on Masterfile)
| Sub Project | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Sub Project Code for which the invoice is being submitted. | Line | |
| Activity | AN | 20 | Required by USDA | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Activity Code for which the invoice is being submitted. | Line | Populate with the Activity (Function) Code. |
(Activity on Masterfile) Object AN 20 Required by USDA This field will only be processed if Unreferenced Invoice value = T. Identifies the Object Code for which the invoice is being submitted. Line Populate with the Sub Object Class (cost element) code.
(Sub Object Class on Masterfile)
| Sub Object | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Sub Object Code for which the invoice is being submitted. | Line | |
| Revenue Source Code | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Revenue Source Code for which the invoice is being submitted. | Line | |
| Sub Revenue Source Code | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the Sub Revenue Source Code for which the invoice is being submitted. | Line | |
| User Dimension 1 | AN | 20 | Required by USDA | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 1 for which the invoice is being submitted. | Line | Populate with the building number. |
(Building Number on Masterfile)
| User Dimension 2 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 2 for which the invoice is being submitted. | Line | |
| User Dimension 3 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 3 for which the invoice is being submitted. | Line | |
| User Dimension 4 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 4 for which the invoice is being submitted. | Line | |
| User Dimension 5 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 5 for which the invoice is being submitted. | Line | Populate with the Lease Number. |
(Lease Number on Masterfile).
| User Dimension 6 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 6 for which the invoice is being submitted. | Line | |
| User Dimension 7 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 7 for which the invoice is being submitted. | Line | |
| User Dimension 8 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 8 for which the invoice is being submitted. | Line | |
| User Dimension 9 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 9 for which the invoice is being submitted. | Line | |
| User Dimension 10 | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Dimension 10 for which the invoice is being submitted. | Line | |
| Cancelled BBFY | AN | 4 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Cancelled BBFY for which the invoice is being submitted. | Line | |
| Cancelled EBFY | AN | 4 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Cancelled EBFY for which the invoice is being submitted. | Line | |
| Cancelled Fund | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Cancelled Fund for which the invoice is being submitted. | Line | |
| Cost Organization | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Cost Organization Code for which the invoice is being submitted. | Line | |
| Sub Cost Organization | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Sub Cost Organization for which the invoice is being submitted. | Line | |
| YBA | AN | 4 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User YBA Code for which the invoice is being submitted. | Line | |
| BETC | AN | 10 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User BETC Code for which the invoice is being submitted. | Line | |
| Cohort Year | AN | 4 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User Cohort Year for which the invoice is being submitted. | Line | |
| PRC | AN | 20 | Optional | This field will only be processed if Unreferenced Invoice value = T. | Identifies the User PRC Code for which the invoice is being submitted. | Line | |
| Agreement Number | AN | 20 | Optional | If populated the value must be valid in VSS database. | Identifies the Agreement Number for which the invoice is being submitted. | Line | Populate with the work authorization/RWA agreement number. |
(Agreement Number on Masterfile)
| Agreement Line Number | AN | 4 | Optional | This field is required if the agreement number is populated. | Identifies the Agreement Line Number for which the invoice is being submitted. | Line | When agreement number populated then populate with “1”. |
| External System Document Number | AN | 30 | Optional | Header | Populate with the GSA Purchase Order Number. |
(PDN Number on Masterfile) Source Number AN 30 Required by USDA Line Populate with the customer account number.
(Account Number on Masterfile)
File details come from the government source that posted it. Updated .