Please sign in to use the application.
Drag & drop .xlsx file here
Values extracted from the Excel template. Modify as needed and click the button below to update XML outputs and the Facility Summary. Note: This does not regenerate Validation results.
Compares MVendors from the Excel sheet (D9) against the BigQuery MVendor table and validates the PVendor number (from D7) for each found MVendor. Also displays Total Record Count from the MVendor table.
(Validation results will appear here after generation)
Checks the BigQuery Facility table for existing facilities with the same PVendor (D7) and State (D19). Determines the next available sequence number for the Facility ID.
(Existing facility check results will appear here after generation)
(Standard XML will appear here after generation)(Flatbed XML will appear here after generation if applicable)Contains INSERT statements for MVNDR_SHPG_FAC_LOC (Query 1), MVNDR_SHPG_FAC (Query 2), and MVNDR_SFAC_STAT (Query 3). Query 1 is skipped for MVendors if their `TOTAL_RECORD_COUNT` in the MVendor table exceeds the configured limit. All queries use the generated Facility ID (ending in 'FB' if D6 is 'Yes'/'True') and department from BigQuery for valid MVendors.
(All INSERT statements will appear here, delineated by query type)Calculated based on vendor postal code if facility is not marked 'IFC Ineligible'. Requires external service.
(MVendor numbers will appear here after generation)Summary of the created facility's details, formatted for easy copy-pasting into an email notification.
(Facility summary will appear here after generation)Shows the last time key BigQuery tables were updated (Eastern Time).
(Fetching table metadata...)
Your account is not authorized to use this application.