Data Reference Wiki

Master data, lookup tables, and system reference across the BrandSafway Quoting Ecosystem

24 Tables SafQuote ERP Salesforce CRM Salesforce CPQ Cross-System
SafQuote ERP (9)
Disciplines 77 Subtasks 483 Hardcost Codes 136 Account Codes 760 Freight Types 8 Floor Types 80 LP Items 38 LP Item Rates 10,257 Rate Profiles 13,500
Salesforce (7)
SFDC Products 163,421 SFDC Branches 653 SFDC Pricebooks 118 Record Types varies SFDC Proposals 10,540 Pricebook Entries 2.1M Quote Sections 2,593
Salesforce CPQ (3)
CPQ Price Rules 75 CPQ Price Conditions 168 CPQ Internals ~140K
Cross-System (5)
Competitors 2,997 Currency Types 24 FX Rates 976 SFDC Users 5,535 Projects 148,827
SafQuote ERP 9 tables
Disciplines
VW_MD_DISCIPLINES
Service disciplines (Scaffolding, Insulation, Coating, etc.) with active/inactive status and sort order.
77 rows SafQuote ERP
Subtasks
VW_MD_SUBTASKS
Labor subtask definitions per discipline (Erect, Dismantle, Modify, TM, etc.).
483 rows SafQuote ERP
Hardcost Codes
VW_MD_HARDCOST
Hardcost item catalog by group (RNT=Rentals, CON=Consumables, ENB=Engineering).
136 rows SafQuote ERP
Account Codes
VW_MD_ACCOUNT_CODES
GL account mapping per discipline — links cost/revenue modules to accounting codes.
760 rows SafQuote ERP
Freight Types
VW_MD_FREIGHT_TYPES
Vehicle types for freight (Pickup, Semi, Flatbed, etc.) with branch/common categories.
8 rows SafQuote ERP
Floor Types
VW_MD_FLOOR_TYPES
Pricing floor categories (Commercial, Industrial) by contract type and deal size range.
80 rows SafQuote ERP
LP Items
VW_SQ_LP_ITEMS
Labor pricing item catalog (Non-Complex, Complex, Premium Support, etc.).
38 rows SafQuote ERP
LP Item Rates
VW_SQ_LP_ITEMS_RATES
Standard bill/cost rates per LP item, branch, and discipline. Rate types: P (Production), D (Differential).
10,257 rows SafQuote ERP
Rate Profiles
VW_MD_RATE_PROFILES
Named rate profiles per branch and discipline (e.g., '1A.NY Carp Std'). Links to labor detail PROFILE_ID.
13,500 rows SafQuote ERP
Salesforce 7 tables
SFDC Products
VW_PRODUCT2
Salesforce product catalog — equipment, parts, services. 154K active. Links to Quote Line Items.
163,421 rows Salesforce
SFDC Branches
VW_BRANCH__C
BrandSafway branch master in Salesforce. BRANCH_NUMBER__C maps to SafQuote BRANCH_NO.
653 rows Salesforce
SFDC Pricebooks
VW_PRICEBOOK2
Price books (Vestas, Spider regional, Power Climber). 39% of quotes use Vestas price book.
118 rows Salesforce
Record Types
VW_RECORDTYPE
Salesforce record type definitions — controls layouts and picklist values per object.
varies rows Salesforce
SFDC Proposals
VW_PROPOSAL__C
Proposal records linked to opportunities — proposal generation tracking.
10,540 rows Salesforce
Pricebook Entries
VW_PRICEBOOKENTRY
Product-price combinations across all 118 price books. Defines unit pricing per product per book.
2.1M rows Salesforce
Quote Sections
VW_QUOTE_SECTION_RECORDS__C
Custom quote section records — organizing quotes into presentation sections.
2,593 rows Salesforce
Salesforce CPQ 3 tables
CPQ Price Rules
VW_SBQQ__PRICERULE__C
Salesforce CPQ pricing rules — conditional logic for automatic price adjustments.
75 rows Salesforce CPQ
CPQ Price Conditions
VW_SBQQ__PRICECONDITION__C
Conditions that trigger CPQ price rules (field, operator, value combinations).
168 rows Salesforce CPQ
CPQ Internals
Multiple
Internal CPQ processing tables: favorite products, approval snapshots, process inputs, record jobs.
~140K rows Salesforce CPQ
Cross-System 5 tables
Competitors
VW_COMPETITOR__C
Competitor master list — used for win/loss analysis and competitive intelligence.
2,997 rows Cross-System
Currency Types
VW_CURRENCYTYPE
Active currencies with corporate conversion rates. USD is corporate currency.
24 rows Cross-System
FX Rates
VW_DATEDCONVERSIONRATE
Historical monthly FX conversion rates for multi-currency deal analysis.
976 rows Cross-System
SFDC Users
VW_USER
Salesforce users — resolves Owner IDs to names, titles, departments, divisions.
5,535 rows Cross-System
Projects
VW_PROJECT__C
BrandSafway project tracking — job sites, durations, project numbers across all regions.
148,827 rows Cross-System
DEV_SILVER.ERPSERV_SAFQTPMST + DEV_SILVER.SALESFORCE | 24 reference tables