emerald - Technical Architecture
Data Model
Tables (117)
Appendices LkUp
Primary Key: Appendix
Fields: - Appendix ID: Long - Appendix: Text (PK)
BBBEE Pillar Sales LkUp
Primary Key: BBBEE
Fields: - BBBEE Pillar ID: Long - BBBEE Pillar Description: Text - BBBEE Pillar: Text
Candidates Sourced From LkUp
Primary Key: Candidates
Fields: - Candidates Sourced From ID: Long - Candidates Sourced From: Text
Channel Partner LkUp
Primary Key: Channel
Fields: - Channel Partner ID: Long - Channel Partner: Text
Client Tender Brief Meeting LkUp
Primary Key: Client
Fields: - Client Tender Brief Meeting ID: Long - Client Tender Brief Meeting: Text
Client Tiers
Primary Key: Client
Fields: - Client Tier ID: Long - Client Tier: Text - Client Tier Range: Text
Contact Type LkUp
Primary Key: Contact
Fields: - Contact Type ID: Long - Contact Type: Text
Contract Duration LkUp
Primary Key: Contract
Fields: - Contract Duration ID: Long - Contract Duration: Text
Contract Type LkUp
Primary Key: Contract
Fields: - Contract Type ID: Long - Contract Type: Text
ContractCurrencyLookup
Primary Key: Contract
Fields: - Contract Currency ID: Long - Contract Currency: Text
CountryLookup
Primary Key: Country
Fields: - Country ID: Long - Country: Text (PK) - Country Code: Text - Active: Boolean - SSMA_TimeStamp: Binary
DatabaseUsers Module Permissions
Primary Key: Module
Fields: - Module Permission ID: Long - Username: Text - Module Permission: Text - LEVEL: Text - Role: Text
DatabaseUsers
Primary Key: Username
Fields: - User ID: Long - Username: Text (PK) - User Password: Text - LEVEL: Text - ForceChange: Boolean - Delivery Location ID: Long - Department: Text - Email Address: Text - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary - First Name: Text - Surname: Text - Cell Phone Number: Text
Delivery Locations Sales
Primary Key: Delivery
Fields: - Delivery Location ID: Long - Delivery Location: Text - Distribution Model ID: Long
DepartmentLookup
Primary Key: ID
Fields: - ID: Long (PK) - Department: Text
Distribution Model Types
Primary Key: Distribution
Fields: - Distribution Model Type ID: Long - Distribution Model Type: Text - Floor Size: Text - Capacity: Text
Distribution Models Proposal
Primary Key: Distribution
Fields: - Distribution Model ID: Long - Distribution Model: Text - Distribution Model Code: Text - Active: Boolean - SSMA_TimeStamp: Binary
Divisions Proposal
Primary Key: Division
Fields: - Division ID: Long - Division: Text (PK) - Active: Boolean - SSMA_TimeStamp: Binary
Email Recipient List
Primary Key: Email
Fields: - Email Recipient ID: Long - Email Function Name: Text - Email Recipient: Text
EmailFunctionLookup
Primary Key: Email
Fields: - Email Function ID: Long - Email Function Name: Text
Entity Contracted LkUp
Primary Key: Entity
Fields: - Entity Contracted ID: Long - Entity Contracted: Text
ExpectedPaymentFrequencyLookup
Primary Key: Expected
Fields: - Expected Payment Frequency ID: Long - Expected Payment Frequency: Text
External Service Providers LkUp
Primary Key: External
Fields: - External Service Providers ID: Long - External Service Providers: Text
Extra Sponsor Element Lookup
Primary Key: Extra
Fields: - Extra Sponsor Element ID: Long - Extra Sponsor Element: Text - Admin Fee: Double
Feasibility Study Length LkUp
Primary Key: Feasibility
Fields: - Feasibility Study Length ID: Long - Feasibility Study Length: Text
Funding Amount Administered By LkUp
Primary Key: Funding
Fields: - Funding Amount Administered By ID: Long - Funding Amount Administered By: Text
Funding Solution LkUp
Primary Key: Funding
Fields: - Funding Solution ID: Long - Funding Solution: Text
General Sales
Primary Key: Front
Fields: - Front End Version Number: Text - PDFFilePath: Text
Growth Stage LkUp
Primary Key: Growth
Fields: - Growth Stage ID: Long - Growth Stage: Text
Impact Statistic Type LkUp
Primary Key: Impact
Fields: - Impact Statistic Type ID: Long - Impact Statistic Type: Text
Industry Charter LkUp
Primary Key: Industry
Fields: - Industry Charter ID: Long - Industry Charter: Text
IndustryLookupSales
Primary Key: Industry
Fields: - Industry ID: Long - Industry: Text (PK) - Active: Boolean - SSMA_TimeStamp: Binary
Info Session Type LkUp
Primary Key: Info
Fields: - Info Session Type ID: Long - Info Session Type: Text
Invoice Day LkUp
Primary Key: Invoice
Fields: - Invoice Day ID: Long - Invoice Day: Text
Language LkUp
Primary Key: Language
Fields: - Language ID: Long - Language: Text (PK)
Lead Generated Method LkUp
Primary Key: Lead
Fields: - Lead Generated Method ID: Long - Lead Generated Method: Text
Lead Report Frequency LkUp
Primary Key: Lead
Fields: - Lead Report Frequency ID: Long - Lead Report Frequency: Text
Month LkUp
Primary Key: Month
Fields: - Month Number: Long - Month Name: Text - Last Day: Integer
Other Frameworks LkUp
Primary Key: Other
Fields: - Other Framework ID: Long - Other Framework: Text
Other Solutions for Appendix LkUp
Primary Key: Other
Fields: - Other Solutions for Appendix ID: Long - Other Solutions for Appendix: Text
Paid For Database LkUp
Primary Key: Paid
Fields: - Paid For Database ID: Long - Paid For Database: Text
Payment Terms LkUp
Primary Key: Payment
Fields: - Payment Terms ID: Long - Payment Terms: Text
Pillar Proposal LkUp
Primary Key: Pillar
Fields: - Pillar ID: Long - Division ID: Long - Pillar Description: Text - Pillar: Text (PK)
PR Type LkUp
Primary Key: PR
Fields: - PR Type ID: Long - PR Type: Text
Principals Sales Contacts
Primary Key: Principal
Fields: - Principal Contact ID: Long - Principal ID: Long - Contact Type ID: Long - Contact First Name: Text - Contact Surname: Text - Contact Position: Text - Contact Email: Text - Contact Phone: Text - Contact Cell Phone: Text - VA Pack Addressee: Boolean - SSMA_TimeStamp: Binary
Principals Sales Countries
Primary Key: Principal
Fields: - Principal Country ID: Long - Principal ID: Long - Country ID: Long
Principals Sales Languages
Primary Key: Principal
Fields: - Principal Language ID: Long - Principal ID: Long - Language: Text
Principals Sales
Primary Key: Principal
Fields: - Principal ID: Long - Principal: Text (PK) - Physical Address 1: Text - Physical Address 2: Text - Physical Address 3: Text - Physical Address 4: Text - Company Website: Text - Industry ID: Long - Industry Charter: Text - Financial Year End: Text - Client Tier ID: Long - Sales Force Principal ID: Text
Product Distribution Models Proposal
Primary Key: Product
Fields: - Product Distribution Model ID: Long - Product ID: Long - Distribution Model ID: Long
Product Divisions Proposal
Primary Key: Product
Fields: - Product Division ID: Long - Product ID: Long - Division ID: Long
Products Proposal
Primary Key: Product
Fields: - Product ID: Long - Product: Text (PK) - Active: Boolean - SSMA_TimeStamp: Binary
Products Sales
Primary Key: Product
Fields: - Product ID: Long - Product: Text (PK) - BBBEE Pillar: Text - Active: Boolean - SSMA_TimeStamp: Binary
Proposal Appendices
Primary Key: Proposal
Fields: - Proposal Appendices ID: Long - Proposal ID: Long - Appendix ID: Text
Proposal Client Needs
Primary Key: Proposal
Fields: - Proposal Client Need ID: Long - Proposal ID: Long - Proposal Client Need: Text
Proposal Commodities
Primary Key: Proposal
Fields: - Proposal Commodity ID: Long - Proposal ID: Long - Proposal Commodity: Text
Proposal Delivery Regions
Primary Key: Delivery
Fields: - Delivery Region ID: Long - Proposal ID: Long - Division ID: Long - Distribution Model ID: Long - Existing or New: Long - Delivery Location ID: Long - New Delivery Location: Text - Geographic Area: Text
Proposal External Service Providers
Primary Key: Proposal
Fields: - Proposal External Service Provider ID: Long - Proposal ID: Long - Proposal External Service Provider: Text
Proposal Feasibility Study
Primary Key: Proposal
Fields: - Proposal Feasibility Study ID: Long - Proposal ID: Long - Proposal Feasibility Study: Text
Proposal Funding Solution
Primary Key: Proposal
Fields: - Proposal Funding Solution ID: Long - Proposal ID: Long - Proposal Funding Solution: Text
Proposal Growth Stages
Primary Key: Proposal
Fields: - Proposal Growth Stage ID: Long - Proposal ID: Long - Proposal Growth Stage: Text
Proposal Impact Statistics Types
Primary Key: Proposal
Fields: - Proposal Impact Statistic Type ID: Long - Proposal ID: Long - Proposal Impact Statistic Type: Text
Proposal Lost Reason LkUp
Primary Key: Proposal
Fields: - Proposal Lost Reason ID: Long - Proposal Lost Reason: Text
Proposal Non SA Regions
Primary Key: Proposal
Fields: - Proposal Non SA Regions ID: Long - Proposal ID: Long - Proposal Non SA Regions: Text
Proposal Other Solutions for Appendix
Primary Key: Proposal
Fields: - Proposal Other Solution for Appendix ID: Long - Proposal ID: Long - Proposal Other Solution for Appendix: Text
Proposal Pillars
Primary Key: Proposal
Fields: - Proposal Pillar ID: Long - Proposal ID: Long - Pillar ID: Long
Proposal Products
Primary Key: Proposal
Fields: - Proposal Products ID: Long - Proposal ID: Long - Product ID: Long
Proposal Sourcing and Selection
Primary Key: Proposal
Fields: - Proposal Sourcing and Selection ID: Long - Proposal ID: Long - Proposal Sourcing and Selection: Text
Proposal Stakeholders Other
Primary Key: Proposal
Fields: - Proposal Other Stakeholder ID: Long - Proposal ID: Long - Proposal Other Stakeholder: Text
Proposal Status History
Primary Key: Proposal
Fields: - Proposal Status History ID: Long - Proposal ID: Long - Proposal Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text
Proposal Status
Primary Key: Proposal
Fields: - Proposal Status ID: Long - Proposal Status: Text - Sort Order: Long
Proposal Time Tracking
Primary Key: Proposal
Fields: - Proposal Time Tracking ID: Long - Proposal ID: Long - Time Tracking Date: DateTime - Time Tracking Time: Long - Time Tracking Description: Text
Proposal Top Priorities
Primary Key: Proposal
Fields: - Proposal Top Priority ID: Long - Proposal ID: Long - Proposal Top Priority: Text - Proposal Top Priority Ranking: Long
Proposal Tried So Far
Primary Key: Proposal
Fields: - Proposal Tried So Far ID: Long - Proposal ID: Long - Proposal Tried So Far: Text
Proposal Type of Document LkUp
Primary Key: Proposal
Fields: - Proposal Type of Document ID: Long - Proposal Type of Document: Text - Proposal Document Definition: Memo - Proposal Max Production Time: Text - Proposal Max Turnaround Time: Text - Proposal or Tender: Long - Proposal Max TAT: Long - SSMA_TimeStamp: Binary
Proposal Who is Reading
Primary Key: Proposal
Fields: - Proposal Who is Reading ID: Long - Proposal ID: Long - Name: Text - Role: Text - Strategic Lens: Text
Proposal Writers
Primary Key: Proposal
Fields: - Proposal Writers ID: Long - Proposal ID: Long - Writer Role: Text - Writer Role Other: Text - Writer Name: Text - Writer Name Other: Text
Proposal
Primary Key: Proposal
Fields: - Proposal ID: Long - Proposal Number: Text - Version Number: Double - Been Revised: Boolean - Date Created: DateTime - Proposal Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text - Principal ID: Long - Old Principal ID: Long - Proposal Type: Text - Contract Type: Text - Contract Duration: Text - Contract Duration Other: Text - Budget Type: Text - Budget Amount: Double - BDS/Funding split: Long - BDS Amount: Double - Funding Amount: Double - Funding Amount Administered By: Text - Funding Amount Administered By Other: Text - Funding Amount Includes Admin Fee: Long - Raizcorp Admin Fee Percentage: Double - Entrepreneur Stipend Included: Long - Entrepreneur Stipend: Double - Other Frameworks: Text - Other Frameworks Comments: Memo - Anticipated Spend Date: DateTime - Prosperator Opportunity Originated: Long - Entity Contracted: Text - Opportunity Owner: Text - Key Account Manager: Text - Channel Partner: Text - S2S Role Required: Long - S2S Role Required Comments: Text - Growth Stage Comments: Memo - Specific Number of Entrepreneurs Required: Long - Specific Number of Entrepreneurs: Text - Gauteng Impacted: Boolean - Gauteng Areas Impacted: Text - KwaZulu-Natal Impacted: Boolean - KwaZulu-Natal Areas Impacted: Text - Eastern Cape Impacted: Boolean - Eastern Cape Areas Impacted: Text - Western Cape Impacted: Boolean - Western Cape Areas Impacted: Text - Northern Cape Impacted: Boolean - Northern Cape Areas Impacted: Text - Northwest Impacted: Boolean - Northwest Areas Impacted: Text - Mpumalanga Impacted: Boolean - Mpumalanga Areas Impacted: Text - Limpopo Impacted: Boolean - Limpopo Areas Impacted: Text - Free State Impacted: Boolean - Free State Areas Impacted: Text - Other Impacted: Boolean - Other Impacted Comments: Text - Technical Buyer: Text - Technical Buyer Engaged: Long - Commercial Buyer: Text - Commercial Buyer Engaged: Long - External Service Providers Included: Long - External Service Providers Other: Memo - Delivery Region Comments: Memo - Feasibility Study Required: Long - Feasibility Study Comments: Memo - Selection Process Modifications Needed: Long - Selection Process Modifications: Memo - White Label Product Needed: Long - White Label Product: Text - New Product or Recipe Required: Long - New Product or Recipe: Memo - Include SD Manager Offerings: Long - Include SD Manager Offerings Comments: Memo - Funding Solution Other: Memo - Number Impacted Entrepreneurs: Long - Access to Market Info Included: Long - Access to Market Info: Memo - Client Pay EP Committment Fee: Long - Changes to Monitoring and Reporting Included: Long - Changes to Monitoring and Reporting: Memo - Impact Guarantee Applies: Long - Replacement Guarantee Applies: Long - BBBEE Section Included: Long - BBBEE Section Comments: Memo - Project Delivery Timeline Included: Long - Project Delivery Timeline Comments: Memo - Proposal Pricing Included: Long - Proposal Pricing Comments: Memo - Outstanding Queries Remaining: Long - Outstanding Queries Comments: Text - Other Solutions for Appendix Needed: Long - Other Solutions for Appendix Needed Comments: Text - Impact Statistics Needed: Long - Impact Statistics Comments: Text - EP Success Stories Needed: Long - EP Success Stories Comments: Text - Showcase Previous Experience: Long - Showcase Previous Experience Comments: Text - Infographic Needed: Long - Infographic Comments: Text - Photographs Needed: Long - Photographs Comments: Text - Other Custom Aspects Needed: Long - Other Custom Aspects Comments: Text - Signoff Send Date: DateTime - Final Sign Off Date: DateTime - Latest Date to Client: DateTime - Proposal Provided In Advance: Long - Date Proposal Needed: DateTime - Tender Contract Number: Text - Tender Project Title: Text - Tender Sourcing: Text - Prequalification Criteria: Long - Prequalification Unknown Comments: Memo - Tender Closing Date: DateTime - Tender Closing Time of Day: Text - Intention Submit Deadline Exists: Long - Intention Submit Deadline Comments: Memo - Intention Submit Deadline Sent: Long - Email Submit a Bid Sent: Long - Email Submit a Bid Comments: Memo - Client Tender Brief Meeting: Text - Client Tender Brief Meeting Date: DateTime - Client Tender Brief Meeting Time: Text - Client Tender Brief Meeting Venue: Text - Raizcorp Person Attending Brief Meeting: Text - Client Tender Brief Meeting Comments: Memo - Physical Submission: Boolean - Physical Submission Number Copies: Long - Physical Submission Address: Text - Physical Submission Comments: Memo - Email Submission: Boolean - Email Submission Number Copies: Long - Email Submission Address: Text - Email Submission Comments: Memo - Website Submission: Boolean - Website Submission Login Details: Text - Website Submission Comments: Memo - Technical Queries Deadline Exists: Long - Technical Queries Deadline: DateTime - Technical Queries Deadline Time: Text - Technical Queries Deadline How Send: Text - Technical Queries Deadline Raizcorp Staff Liaise: Text - Technical Queries to be Sent: Text - Tender Pricing Format Exists: Long - Tender Pricing Format Comments: Memo - Tender Contract TC Exists: Long - Tender Contract TC Given FD: Long - Tender Evaluation Info: Memo - Tender Competitors: Memo - Tender Validity Period: Text - Tender Duration of Contract: Text - Proposal Brief Completed: DateTime - Proposal Type of Document ID: Long - Who Will Submit: Long - Tender Project Plan Created: Long - Who Will Sign Off: Text - CEO Needs to be Consulted: Boolean - COO Needs to be Consulted: Boolean - CRO Needs to be Consulted: Boolean - CFO Needs to be Consulted: Boolean - Marketing Manager Needs to be Consulted: Boolean - Proposal Due Date: DateTime - Proposal Drive Location: Text - Proposal Submission Type: Long - Proposal Proofread and QC Complete: Long - Proposal Date Submitted: DateTime - Proposal Turnaround Time Comments: Text - Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary - Opportunity Notes: Memo - Pricing Mode: Long - Contract Currency: Text - Exchange Rate: Double - Budget Period: Long - Budget Notes: Memo - Admin Fee Other: Text - Stipend Period Conditions: Memo - Expected Payment Frequency: Text - Commission Mode: Long - Who Is S2S Role: Text - Proposal Pricing Type: Long - Sales Manager Needs to be Consulted: Boolean - Proposal Lost Reason: Text - Include PR and Marketing Offerings: Long - Include PR and Marketing Offerings Comments: Memo
Report Writer Proposal Included Field Names
Primary Key: ID
Fields: - ID: Long (PK) - Description: Text - Include Field Name: Text - Sort Order: Long
Reporting Frequency
Primary Key: Reporting
Fields: - Reporting Frequency ID: Long - Reporting Frequency: Text - Reporting Frequency Description: Text
RoleLookup
Primary Key: Role
Fields: - Role ID: Long - Role: Text (PK)
Sales Brief Bookkeeping Process Description
Primary Key: Bookkeeping
Fields: - Bookkeeping Process Description ID: Long - Sales Brief ID: Long - Bookkeeping Process Description: Text
Sales Brief Contract Numbers
Primary Key: Sales
Fields: - Sales Brief Contract Numbers ID: Long - Sales Brief ID: Long - Contract Number: Text
Sales Brief Efficacy Non Standard Elements
Primary Key: Efficacy
Fields: - Efficacy Non Standard Elements Description ID: Long - Sales Brief ID: Long - Efficacy Non Standard Elements Description: Text
Sales Brief Extra Sponsor Elements
Primary Key: Sales
Fields: - Sales Brief Extra Sponsor Elements ID: Long - Sales Brief ID: Long - BBBEE Pillar: Text - Element Type: Text - Sponsorship Amount: Double - Admin Fee: Double - Number of Entrepreneurs: Long - Frequency of Payments: Text - Once Off Payment Date: DateTime - Monthly Day of Month: Text - Payment Amount: Double
Sales Brief Finance Distribution Model Type Fees
Primary Key: Sales
Fields: - Sales Brief Finance Distribution Model Type Fee ID: Long - Sales Brief ID: Long - Distribution Model Type ID: Long - Set-up Fee: Double - Management Fee: Double - Operational Expenses: Double - SSMA_TimeStamp: Binary
Sales Brief Finance Invoice Month
Primary Key: Sales
Fields: - Sales Brief Finance Invoice Month ID: Long - Sales Brief ID: Long - Sales Brief Finance Invoice Month: Text
Sales Brief Finance Special Payment Terms
Primary Key: Sales
Fields: - Sales Brief Special Payment Terms ID: Long - Sales Brief ID: Long - Sales Brief Special Payment Terms Item: Text
Sales Brief Guiding Deliverables Bespoke
Primary Key: Sales
Fields: - Sales Brief Guiding Deliverables Bespoke ID: Long - Sales Brief ID: Long - Sales Brief Guiding Deliverables Bespoke Item: Text
Sales Brief Guiding Towards
Primary Key: Sales
Fields: - Sales Brief Guiding Towards ID: Long - Sales Brief ID: Long - Sales Brief Guiding Towards Item: Text
Sales Brief Learning Deliverables Bespoke
Primary Key: Sales
Fields: - Sales Brief Learning Deliverables Bespoke ID: Long - Sales Brief ID: Long - Sales Brief Learning Deliverables Bespoke Item: Text
Sales Brief Learning Guides Notified
Primary Key: Sales
Fields: - Sales Brief Learning Guides Notified ID: Long - Sales Brief ID: Long - Sales Brief Learning Guides Notified Item: Text
Sales Brief Principal Priorities
Primary Key: Principal
Fields: - Principal Priorities ID: Long - Sales Brief ID: Long - Principal Priority: Text
Sales Brief Principal Referral Contacts
Primary Key: Principal
Fields: - Principal Referral Contact ID: Long - Sales Brief ID: Long - Principal Contact First Name: Text - Principal Contact Surname: Text - Principal Contact EOI Business Name: Text - Principal Contact Email: Text - Principal Contact Telephone Number: Text
Sales Brief Revision Edit History
Primary Key: Sales
Fields: - Sales Brief Edit ID: Long - Sales Brief ID: Long - Field Modified: Text - Modified By: Text - Date Modified: DateTime
Sales Brief SD Initiatives
Primary Key: Sales
Fields: - Sales Brief SD Initiatives ID: Long - Sales Brief ID: Long - Sales Brief SD Initiatives Item: Text
Sales Brief Selection Marketing Candidates Sourced From
Primary Key: Candidates
Fields: - Candidates Sourced From ID: Long - Sales Brief Selection Marketing ID: Long - Candidates Sourced From: Text
Sales Brief Selection Marketing Client Supply Chain Requirement
Primary Key: Client
Fields: - Client Supply Chain Requirement ID: Long - Sales Brief Selection Marketing ID: Long - Client Supply Chain Requirement: Text
Sales Brief Selection Marketing Commodities
Primary Key: Sales
Fields: - Sales Brief Selection Marketing Commodity ID: Long - Sales Brief Selection Marketing ID: Long - Commodity: Text
Sales Brief Selection Marketing Products
Primary Key: Sales
Fields: - Sales Brief Selection Marketing Products ID: Long - Sales Brief Selection Marketing ID: Long - Product ID: Long - Sponsorship Amount: Double - SSMA_TimeStamp: Binary - Sales Brief ID: Long - BBBEE Pillar: Text
Sales Brief Selection Marketing Selection Criteria
Primary Key: Sales
Fields: - Sales Brief Selection Marketing Selection Criteria ID: Long - Sales Brief Selection Marketing ID: Long - Selection Criteria: Text
Sales Brief Selection Marketing Sourced From
Primary Key: Sales
Fields: - Sales Brief Selection Marketing Companies Sourced From ID: Long - Sales Brief Selection Marketing ID: Long - Delivery Location ID: Long - Delivery Location Other: Text - SSMA_TimeStamp: Binary
Sales Brief Selection Marketing
Primary Key: Sales
Fields: - Sales Brief Selection Marketing ID: Long - Sales Brief ID: Long - BBBEE Pillar: Text - DELETE Product ID: Long - DELETE Sponsorship Amount: Double - Minimum Companies Required: Long - Marketing Campaign Required: Long - Principal Campaign Branded: Long - Launch Required: Long - Principal Launch Budget: Double - Raizcorp Launch Budget: Double - Who Arranges Launch: Long - PR Type: Text - Info Session Type: Text - Principal Approve Candidate Leads: Long - Principal Approve Candidate: Long - Cohort Ignition Qtr: Text - Cohort Ignition Year: Long - Principal Subsidise Assessment Fee: Long - Subsidised Assessment Amount: Double - Supply Chain Requirement: Text - Supporting Doc Affidavit (EME): Boolean - Supporting Doc BEE Certificate: Boolean - Supporting Doc Certified ID Copy: Boolean - Supporting Doc CK1 Document: Boolean - Supporting Doc EMP201: Boolean - Supporting Doc Employee Payslips: Boolean - Supporting Doc IRP5: Boolean - Supporting Doc VAT Registration: Boolean - Supporting Doc Proof of Turnover: Boolean - Supporting Doc Tax Clearance Certificate: Boolean - Supporting Doc Other: Boolean - Supporting Doc Other Text: Text - SSMA_TimeStamp: Binary - Supporting Doc Employee Contract: Boolean - Supporting Doc Appreciation Letter: Boolean
Sales Brief Status History
Primary Key: Sales
Fields: - Sales Brief Status History ID: Long - Sales Brief ID: Long - Sales Brief Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text
Sales Brief Status
Primary Key: Sales
Fields: - Sales Brief Status ID: Long - Sales Brief Status: Text - Sort Order: Long
Sales Brief Sub Products
Primary Key: Sales
Fields: - Sales Brief Sub Product ID: Long - Sales Brief ID: Long - BBBEE Pillar: Text - Sub Product ID: Long - Sponsorship Amount: Double - Number of Entrepreneurs: Long - Frequency: Text - SSMA_TimeStamp: Binary
Sales Brief
Primary Key: Sales
Fields: - Sales Brief ID: Long - Sales Brief Number: Text - Version Number: Double - Been Through Gateway: Boolean - Been Revised: Boolean - Date Created: DateTime - Sales Brief Status ID: Long - Date Status Changed: DateTime - Status Modified By: Text - Solutions Architect: Text - Key Account Manager: Text - Sales Manager: Text - Principal ID: Long - Contract Type: Text - Contract Duration: Text - Contract Duration Other: Text - How Lead Generated: Text - Channel Partner: Text - Client (Lead Generated): Text - Conference (Lead Generated): Text - Solution Architect (Lead Generated): Text - Marketing Campaign (Lead Generated): Text - Which Database (Lead Generated): Text - Raizcorp Management (Lead Generated): Text - Lead Report Frequency: Text - Verification Agency Name: Text - Principal Verified Date: DateTime - VA Pack Date: DateTime - Non Standard Bookkeeping Process: Long - Efficacy Non Standard Elements: Long - Standard Ignition Apply: Long - Ignition Description: Text - Reporting Frequency ID: Long - Additional Marketing Costs: Double - Standard Marketing Budget: Double - Total Stipend Costs: Double - Funding Fee Percentage: Double - Funding Fee Added to Programme Fee: Long - Funding Notes: Text - Contract Payment Terms: Text - Invoice Day of Month: Text - Invoice Day of Month Other: Text - Once Off Invoice Date: DateTime - Entity Contracted: Text - Channel Partner Percentage: Double - Channel Partner Approved: Long - Channel Partner Approver: Text - Notes: Memo - Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary - Pricing Mode: Long - Contract Start Date: DateTime - Contract End Date: DateTime - Date Principal Needs Spend: DateTime - Procurement Commit to Meeting: Long - Project: Text - Special Negotiated Price Notes: Text - Contract FYE: Text - Verification Year: Long - Store Standard Marketing Budget: Double - DeliveryNotes: Memo - MarketingNotes: Memo - FinanceNotes: Memo
Sourcing and Selection LkUp
Primary Key: Sourcing
Fields: - Sourcing and Selection ID: Long - Sourcing and Selection: Text
Sub Products Sales
Primary Key: Sub
Fields: - Sub Product ID: Long - Sub Product: Text - BBBEE Pillar: Text - Frequency: Text - Active: Boolean - SSMA_TimeStamp: Binary
Supply Chain Requirements LkUp
Primary Key: Supply
Fields: - Supply Chain Requirement ID: Long - Supply Chain Requirement: Text
Temp Copy Ids
Primary Key: Not defined
Fields: - Org ID: Long - New ID: Long
Tender Brief Meeting LkUp
Primary Key: Tender
Fields: - Tender Brief Meeting ID: Long - Tender Brief Meeting: Text
Tender Sources LkUp
Primary Key: Tender
Fields: - Tender Source ID: Long - Tender Source: Text
Top Priorities LkUp
Primary Key: Top
Fields: - Top Priority ID: Long - Top Priority: Text
Writer Role LkUp
Primary Key: Writer
Fields: - Writer Role ID: Long - Writer Role: Text
Year LkUp
Primary Key: Year
Fields: - Year ID: Long - Year Number: Long
zstblODBC_db
Primary Key: DBID
Fields: - DBID: Long (PK) - SelectDB: Boolean - DatabaseName: Text - ServerName: Text - DBName: Text - Authentication: Text - UID: Text - PWD: Text - Driver: Text - DateAdded: DateTime
zstblODBC_tables
Primary Key: TableID
Fields: - TableID: Long (PK) - Link: Boolean - Hidden: Boolean - DatabaseName: Text - TableName: Text - SourceTableName: Text - AfterDDL: Text - Comment: Text - DateAdded: DateTime
Code Components
Modules (144)
| Module | Type | Lines | Procedures |
|---|---|---|---|
| Form_Add and Edit Appendices | Form | 58 | 3 |
| Form_Add and Edit BBBEE Pillar | Form | 35 | 2 |
| Form_Add and Edit Candidates Sourced From | Form | 58 | 3 |
| Form_Add and Edit Channel Partner | Form | 58 | 3 |
| Form_Add and Edit Client Tender Brief Meeting | Form | 58 | 3 |
| Form_Add and Edit Contact Type | Form | 60 | 3 |
| Form_Add and Edit Contract Currency | Form | 58 | 3 |
| Form_Add and Edit Contract Duration | Form | 58 | 3 |
| Form_Add and Edit Contract Type | Form | 58 | 3 |
| Form_Add and Edit Country | Form | 20 | 1 |
| Form_Add and Edit Delivery Location Sales | Form | 72 | 3 |
| Form_Add and Edit Distribution Model Proposal | Form | 35 | 2 |
| Form_Add and Edit Distribution Model Type | Form | 72 | 3 |
| Form_Add and Edit Divisions Proposal | Form | 35 | 2 |
| Form_Add and Edit Entity Contracted | Form | 58 | 3 |
| Form_Add and Edit Expected Payment Frequency | Form | 58 | 3 |
| Form_Add and Edit External Service Providers | Form | 58 | 3 |
| Form_Add and Edit Feasibility Study Length | Form | 58 | 3 |
| Form_Add and Edit Funding Amount Administered By | Form | 58 | 3 |
| Form_Add and Edit Funding Solution | Form | 58 | 3 |
| Form_Add and Edit Growth Stage | Form | 58 | 3 |
| Form_Add and Edit Impact Statistic Type | Form | 58 | 3 |
| Form_Add and Edit Industry Charter | Form | 58 | 3 |
| Form_Add and Edit Industry Sales | Form | 35 | 2 |
| Form_Add and Edit Info Session Type | Form | 58 | 3 |
| Form_Add and Edit Invoice Day | Form | 58 | 3 |
| Form_Add and Edit Language | Form | 58 | 3 |
| Form_Add and Edit Lead Generated Method | Form | 58 | 3 |
| Form_Add and Edit Lead Report Frequency | Form | 58 | 3 |
| Form_Add and Edit Other Frameworks | Form | 58 | 3 |
| Form_Add and Edit Other Solutions for Appendix | Form | 58 | 3 |
| Form_Add and Edit Paid For Database | Form | 58 | 3 |
| Form_Add and Edit Payment Terms | Form | 58 | 3 |
| Form_Add and Edit Pillar Proposal | Form | 35 | 2 |
| Form_Add and Edit PR Type | Form | 58 | 3 |
| Form_Add and Edit Principal Sales | Form | 62 | 2 |
| Form_Add and Edit Product Proposal | Form | 28 | 2 |
| Form_Add and Edit Product Sales | Form | 64 | 3 |
| Form_Add and Edit Proposal Delivery Regions | Form | 53 | 6 |
| Form_Add and Edit Proposal Department Dates | Form | 164 | 4 |
| Form_Add and Edit Proposal Lost Reason | Form | 58 | 3 |
| Form_Add and Edit Proposal Opportunity Owner Dates | Form | 114 | 3 |
| Form_Add and Edit Proposal Products | Form | 50 | 3 |
| Form_Add and Edit Proposal Status | Form | 35 | 2 |
| Form_Add and Edit Proposal Type of Document | Form | 72 | 3 |
| Form_Add and Edit Proposal | Form | 2321 | 185 |
| Form_Add and Edit Roles | Form | 58 | 3 |
| Form_Add and Edit Sales Brief Status | Form | 35 | 2 |
| Form_Add and Edit Sales Brief | Form | 1131 | 50 |
| Form_Add and Edit Sourcing and Selection | Form | 58 | 3 |
| Form_Add and Edit Sub Products Sales | Form | 71 | 4 |
| Form_Add and Edit Supply Chain Requirements | Form | 58 | 3 |
| Form_Add and Edit Tender Brief Meeting | Form | 58 | 3 |
| Form_Add and Edit Tender Sources | Form | 58 | 3 |
| Form_Add and Edit Top Priorities | Form | 58 | 3 |
| Form_Add and Edit Users | Form | 40 | 3 |
| Form_Add and Edit Writer Role | Form | 58 | 3 |
| Form_Add Sales Brief Procurement Commit to Meeting | Form | 25 | 3 |
| Form_Change Password | Form | 138 | 5 |
| Form_Edit Email Recipient List | Form | 62 | 4 |
| Form_Edit Proposal Status | Form | 95 | 3 |
| Form_Edit Sales Brief Status | Form | 192 | 3 |
| Form_Maintenance Menu | Form | 224 | 52 |
| Form_Opening Dialog | Form | 107 | 4 |
| Form_Principal List | Form | 157 | 10 |
| Form_Product List Proposal | Form | 80 | 5 |
| Form_Proposal List | Form | 227 | 16 |
| Form_Report Menu Proposal | Form | 30 | 3 |
| Form_Report Writer Dialog | Form | 345 | 7 |
| Form_Reports Date Dialog | Form | 52 | 3 |
| Form_Sales Brief List | Form | 956 | 19 |
| Form_SubFrm Product Distribution Models | Form | 20 | 1 |
| Form_SubFrm Product Divisions | Form | 20 | 1 |
| Form_SubFrm Proposal Appendices | Form | 29 | 2 |
| Form_SubFrm Proposal Client Needs | Form | 36 | 3 |
| Form_SubFrm Proposal Commodities | Form | 36 | 3 |
| Form_SubFrm Proposal Divisions | Form | 37 | 2 |
| Form_SubFrm Proposal External Service Providers | Form | 29 | 2 |
| Form_SubFrm Proposal Feasibility Study | Form | 29 | 2 |
| Form_SubFrm Proposal Funding Solution | Form | 29 | 2 |
| Form_SubFrm Proposal Growth Stages | Form | 32 | 2 |
| Form_SubFrm Proposal Impact Statistics Types | Form | 32 | 2 |
| Form_SubFrm Proposal Non South African Regions | Form | 29 | 2 |
| Form_SubFrm Proposal Other Solutions for Appendix | Form | 29 | 2 |
| Form_SubFrm Proposal Pillars | Form | 38 | 3 |
| Form_SubFrm Proposal Products | Form | 23 | 1 |
| Form_SubFrm Proposal Sourcing and Selection | Form | 29 | 2 |
| Form_SubFrm Proposal Stakeholders Other | Form | 29 | 2 |
| Form_SubFrm Proposal Time Tracking | Form | 27 | 2 |
| Form_SubFrm Proposal Top Priorities | Form | 54 | 3 |
| Form_SubFrm Proposal Tried So Far | Form | 36 | 3 |
| Form_SubFrm Proposal Who Is Reading | Form | 36 | 3 |
| Form_SubFrm Proposal Writers | Form | 50 | 5 |
| Form_SubFrm Sales Brief Bookkeeping Process Description | Form | 36 | 3 |
| Form_SubFrm Sales Brief Contract Numbers | Form | 36 | 3 |
| Form_SubFrm Sales Brief Efficacy Non Standard Elements | Form | 36 | 3 |
| Form_SubFrm Sales Brief Extra Sponsor Elements | Form | 95 | 10 |
| Form_SubFrm Sales Brief Finance Distribution Model Type Fees | Form | 47 | 5 |
| Form_SubFrm Sales Brief Finance Invoice Month | Form | 36 | 3 |
| Form_SubFrm Sales Brief Finance Special Payment Terms | Form | 36 | 3 |
| Form_SubFrm Sales Brief Guiding Deliverables Bespoke | Form | 36 | 3 |
| Form_SubFrm Sales Brief Guiding Towards | Form | 36 | 3 |
| Form_SubFrm Sales Brief Learning Deliverables Bespoke | Form | 36 | 3 |
| Form_SubFrm Sales Brief Learning Guides Notified | Form | 36 | 3 |
| Form_SubFrm Sales Brief Marketing ED | Form | 109 | 8 |
| Form_SubFrm Sales Brief Marketing SD | Form | 143 | 12 |
| Form_SubFrm Sales Brief Marketing SED | Form | 143 | 12 |
| Form_SubFrm Sales Brief Marketing SkD | Form | 143 | 12 |
| Form_SubFrm Sales Brief Principal Contacts | Form | 136 | 9 |
| Form_SubFrm Sales Brief Principal Countries | Form | 49 | 3 |
| Form_SubFrm Sales Brief Principal Languages | Form | 38 | 2 |
| Form_SubFrm Sales Brief Principal Priorities | Form | 36 | 3 |
| Form_SubFrm Sales Brief Principal Referral Contacts | Form | 60 | 7 |
| Form_SubFrm Sales Brief Principal | Form | 118 | 12 |
| Form_SubFrm Sales Brief SD Initiatives | Form | 36 | 3 |
| Form_SubFrm Sales Brief Selection Candidates Sourced From ED | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection Candidates Sourced From SD | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection Candidates Sourced From SED | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection Candidates Sourced From SkD | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection Client Supply Chain Req SD | Form | 36 | 3 |
| Form_SubFrm Sales Brief Selection Commodities ED | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection Commodities SD | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection ED | Form | 130 | 19 |
| Form_SubFrm Sales Brief Selection Marketing Products | Form | 194 | 6 |
| Form_SubFrm Sales Brief Selection SD | Form | 141 | 20 |
| Form_SubFrm Sales Brief Selection SED | Form | 130 | 19 |
| Form_SubFrm Sales Brief Selection Selection Criteria ED | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection Selection Criteria SD | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection Selection Criteria SED | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection Selection Criteria SkD | Form | 29 | 2 |
| Form_SubFrm Sales Brief Selection SkD | Form | 130 | 19 |
| Form_SubFrm Sales Brief Selection Sourced From ED | Form | 34 | 3 |
| Form_SubFrm Sales Brief Selection Sourced From SD | Form | 35 | 3 |
| Form_SubFrm Sales Brief Selection Sourced From SED | Form | 35 | 3 |
| Form_SubFrm Sales Brief Selection Sourced From SkD | Form | 35 | 3 |
| Form_SubFrm Sales Brief Sub Products | Form | 61 | 6 |
| basRelink | Standard | 562 | 6 |
| Global | Standard | 4 | 0 |
| Mod Export to Excel | Standard | 312 | 1 |
| Mod Send Outlook Message | Standard | 53 | 1 |
| Mod Utilities | Standard | 220 | 11 |
| Module1 | Standard | 1 | 0 |
| Module2 | Standard | 341 | 12 |
| Module3 | Standard | 1 | 0 |
Forms (139)
| Form | Record Source | Controls | Has Code |
|---|---|---|---|
| Add and Edit Appendices | Appendices LkUp | 8 | Yes |
| Add and Edit BBBEE Pillar | BBBEE Pillar Sales LkUp | 12 | Yes |
| Add and Edit Candidates Sourced From | Candidates Sourced From LkUp | 11 | Yes |
| Add and Edit Channel Partner | Channel Partner LkUp | 11 | Yes |
| Add and Edit Client Tender Brief Meeting | Client Tender Brief Meeting LkUp | 8 | Yes |
| Add and Edit Contact Type | Contact Type LkUp | 11 | Yes |
| Add and Edit Contract Currency | ContractCurrencyLookup | 11 | Yes |
| Add and Edit Contract Duration | Contract Duration LkUp | 11 | Yes |
| Add and Edit Contract Type | Contract Type LkUp | 11 | Yes |
| Add and Edit Country | CountryLookup | 14 | Yes |
| Add and Edit Delivery Location Sales | Delivery Locations Sales | 11 | Yes |
| Add and Edit Distribution Model Proposal | Distribution Models Proposal | 10 | Yes |
| Add and Edit Distribution Model Type | Distribution Model Types | 15 | Yes |
| Add and Edit Divisions Proposal | Divisions Proposal | 10 | Yes |
| Add and Edit Entity Contracted | Entity Contracted LkUp | 11 | Yes |
| Add and Edit Expected Payment Frequency | ExpectedPaymentFrequencyLookup | 11 | Yes |
| Add and Edit External Service Providers | External Service Providers LkUp | 11 | Yes |
| Add and Edit Feasibility Study Length | Feasibility Study Length LkUp | 11 | Yes |
| Add and Edit Funding Amount Administered By | Funding Amount Administered By LkUp | 11 | Yes |
| Add and Edit Funding Solution | Funding Solution LkUp | 11 | Yes |
| Add and Edit Growth Stage | Growth Stage LkUp | 11 | Yes |
| Add and Edit Impact Statistic Type | Impact Statistic Type LkUp | 11 | Yes |
| Add and Edit Industry Charter | Industry Charter LkUp | 11 | Yes |
| Add and Edit Industry Sales | IndustryLookupSales | 10 | Yes |
| Add and Edit Info Session Type | Info Session Type LkUp | 11 | Yes |
| Add and Edit Invoice Day | Invoice Day LkUp | 11 | Yes |
| Add and Edit Language | Language LkUp | 11 | Yes |
| Add and Edit Lead Generated Method | Lead Generated Method LkUp | 11 | Yes |
| Add and Edit Lead Report Frequency | Lead Report Frequency LkUp | 11 | Yes |
| Add and Edit Other Frameworks | Other Frameworks LkUp | 11 | Yes |
| Add and Edit Other Solutions for Appendix | Other Solutions for Appendix LkUp | 8 | Yes |
| Add and Edit Paid For Database | Paid For Database LkUp | 11 | Yes |
| Add and Edit Payment Terms | Payment Terms LkUp | 11 | Yes |
| Add and Edit Pillar Proposal | Pillar Proposal LkUp | 14 | Yes |
| Add and Edit PR Type | PR Type LkUp | 11 | Yes |
| Add and Edit Principal Sales | Principals Sales | 31 | Yes |
| Add and Edit Product Proposal | Products Proposal | 11 | Yes |
| Add and Edit Product Sales | Products Sales | 9 | Yes |
| Add and Edit Proposal Delivery Regions | Proposal Delivery Regions | 21 | Yes |
| Add and Edit Proposal Department Dates | Unbound | 12 | Yes |
| Add and Edit Proposal Lost Reason | Proposal Lost Reason LkUp | 11 | Yes |
| Add and Edit Proposal Opportunity Owner Dates | Unbound | 6 | Yes |
| Add and Edit Proposal Products | Proposal | 12 | Yes |
| Add and Edit Proposal Status | Proposal Status | 12 | Yes |
| Add and Edit Proposal Type of Document | Proposal Type of Document LkUp | 24 | Yes |
| Add and Edit Proposal | Proposal | 518 | Yes |
| Add and Edit Roles | RoleLookup | 11 | Yes |
| Add and Edit Sales Brief Status | Sales Brief Status | 10 | Yes |
| Add and Edit Sales Brief | Sales Brief | 173 | Yes |
| Add and Edit Sourcing and Selection | Sourcing and Selection LkUp | 11 | Yes |
| Add and Edit Sub Products Sales | Sub Products Sales | 11 | Yes |
| Add and Edit Supply Chain Requirements | Supply Chain Requirements LkUp | 11 | Yes |
| Add and Edit Tender Brief Meeting | Tender Brief Meeting LkUp | 8 | Yes |
| Add and Edit Tender Sources | Tender Sources LkUp | 8 | Yes |
| Add and Edit Top Priorities | Top Priorities LkUp | 11 | Yes |
| Add and Edit Users | DatabaseUsersSales | 25 | Yes |
| Add and Edit Writer Role | Writer Role LkUp | 11 | Yes |
| Add Sales Brief Procurement Commit to Meeting | Unbound | 7 | Yes |
| Change Password | Unbound | 19 | Yes |
| Edit Email Recipient List | Email Recipient List | 13 | Yes |
| Edit Proposal Status | Unbound | 11 | Yes |
| Edit Sales Brief Status | Unbound | 9 | Yes |
| Maintenance Menu | Unbound | 55 | Yes |
| Opening Dialog | Unbound | 12 | Yes |
| Principal List | Unbound | 16 | Yes |
| Product List Proposal | Unbound | 13 | Yes |
| Proposal List | Unbound | 33 | Yes |
| Report Menu Proposal | Unbound | 4 | Yes |
| Report Writer Dialog | Unbound | 19 | Yes |
| Reports Date Dialog | Unbound | 6 | Yes |
| Sales Brief List | Unbound | 31 | Yes |
| SubFrm Company Status History | Entrepreneur Company Status History | 10 | No |
| SubFrm Product Distribution Models | Product Distribution Models Proposal | 7 | Yes |
| SubFrm Product Divisions | Product Divisions Proposal | 7 | Yes |
| SubFrm Proposal Appendices | Proposal Appendices | 6 | Yes |
| SubFrm Proposal Client Needs | Proposal Client Needs | 7 | Yes |
| SubFrm Proposal Commodities | Proposal Commodities | 7 | Yes |
| SubFrm Proposal Divisions | Proposal Delivery Regions | 7 | Yes |
| SubFrm Proposal External Service Providers | Proposal External Service Providers | 8 | Yes |
| SubFrm Proposal Feasibility Study | Proposal Feasibility Study | 8 | Yes |
| SubFrm Proposal Funding Solution | Proposal Funding Solution | 8 | Yes |
| SubFrm Proposal Growth Stages | Proposal Growth Stages | 7 | Yes |
| SubFrm Proposal Impact Statistics Types | Proposal Impact Statistics Types | 7 | Yes |
| SubFrm Proposal Non South African Regions | Proposal Non SA Regions | 8 | Yes |
| SubFrm Proposal Other Solutions for Appendix | Proposal Other Solutions for Appendix | 5 | Yes |
| SubFrm Proposal Pillars | Proposal Pillars | 7 | Yes |
| SubFrm Proposal Products | Proposal Products | 8 | Yes |
| SubFrm Proposal Sourcing and Selection | Proposal Sourcing and Selection | 8 | Yes |
| SubFrm Proposal Stakeholders Other | Proposal Stakeholders Other | 8 | Yes |
| SubFrm Proposal Status History | Proposal Status History | 8 | No |
| SubFrm Proposal Time Tracking | Proposal Time Tracking | 11 | Yes |
| SubFrm Proposal Top Priorities | Proposal Top Priorities | 9 | Yes |
| SubFrm Proposal Tried So Far | Proposal Tried So Far | 7 | Yes |
| SubFrm Proposal Who Is Reading | Proposal Who is Reading | 12 | Yes |
| SubFrm Proposal Writers | Proposal Writers | 13 | Yes |
| SubFrm Sales Brief Bookkeeping Process Description | Sales Brief Bookkeeping Process Description | 6 | Yes |
| SubFrm Sales Brief Contract Numbers | Sales Brief Contract Numbers | 7 | Yes |
| SubFrm Sales Brief Efficacy Non Standard Elements | Sales Brief Efficacy Non Standard Elements | 6 | Yes |
| SubFrm Sales Brief Extra Sponsor Elements | Sales Brief Extra Sponsor Elements | 24 | Yes |
| SubFrm Sales Brief Finance Distribution Model Type Fees | Sales Brief Finance Distribution Model Type Fees | 19 | Yes |
| SubFrm Sales Brief Finance Invoice Month | Sales Brief Finance Invoice Month | 7 | Yes |
| SubFrm Sales Brief Finance Special Payment Terms | Sales Brief Finance Special Payment Terms | 7 | Yes |
| SubFrm Sales Brief Guiding Deliverables Bespoke | Sales Brief Guiding Deliverables Bespoke | 7 | Yes |
| SubFrm Sales Brief Guiding Towards | Sales Brief Guiding Towards | 7 | Yes |
| SubFrm Sales Brief Learning Deliverables Bespoke | Sales Brief Learning Deliverables Bespoke | 7 | Yes |
| SubFrm Sales Brief Learning Guides Notified | Sales Brief Learning Guides Notified | 7 | Yes |
| SubFrm Sales Brief Marketing ED | SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [ | 43 | Yes |
| SubFrm Sales Brief Marketing SD | SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [ | 44 | Yes |
| SubFrm Sales Brief Marketing SED | SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [ | 44 | Yes |
| SubFrm Sales Brief Marketing SkD | SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [ | 44 | Yes |
| SubFrm Sales Brief Principal Contacts | Principals Sales Contacts | 21 | Yes |
| SubFrm Sales Brief Principal Countries | Principals Sales Countries | 7 | Yes |
| SubFrm Sales Brief Principal Languages | Principals Sales Languages | 7 | Yes |
| SubFrm Sales Brief Principal Priorities | Sales Brief Principal Priorities | 7 | Yes |
| SubFrm Sales Brief Principal Referral Contacts | Sales Brief Principal Referral Contacts | 15 | Yes |
| SubFrm Sales Brief Principal | Principals Sales | 26 | Yes |
| SubFrm Sales Brief SD Initiatives | Sales Brief SD Initiatives | 7 | Yes |
| SubFrm Sales Brief Selection Candidates Sourced From ED | Sales Brief Selection Marketing Candidates Sourced From | 8 | Yes |
| SubFrm Sales Brief Selection Candidates Sourced From SD | Sales Brief Selection Marketing Candidates Sourced From | 8 | Yes |
| SubFrm Sales Brief Selection Candidates Sourced From SED | Sales Brief Selection Marketing Candidates Sourced From | 8 | Yes |
| SubFrm Sales Brief Selection Candidates Sourced From SkD | Sales Brief Selection Marketing Candidates Sourced From | 9 | Yes |
| SubFrm Sales Brief Selection Client Supply Chain Req SD | Sales Brief Selection Marketing Client Supply Chain Requirement | 8 | Yes |
| SubFrm Sales Brief Selection Commodities ED | Sales Brief Selection Marketing Commodities | 8 | Yes |
| SubFrm Sales Brief Selection Commodities SD | Sales Brief Selection Marketing Commodities | 8 | Yes |
| SubFrm Sales Brief Selection ED | SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [ | 64 | Yes |
| SubFrm Sales Brief Selection Marketing Products | Sales Brief Selection Marketing Products | 13 | Yes |
| SubFrm Sales Brief Selection SD | SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [ | 66 | Yes |
| SubFrm Sales Brief Selection SED | SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [ | 60 | Yes |
| SubFrm Sales Brief Selection Selection Criteria ED | Sales Brief Selection Marketing Selection Criteria | 8 | Yes |
| SubFrm Sales Brief Selection Selection Criteria SD | Sales Brief Selection Marketing Selection Criteria | 8 | Yes |
| SubFrm Sales Brief Selection Selection Criteria SED | Sales Brief Selection Marketing Selection Criteria | 8 | Yes |
| SubFrm Sales Brief Selection Selection Criteria SkD | Sales Brief Selection Marketing Selection Criteria | 8 | Yes |
| SubFrm Sales Brief Selection SkD | SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [ | 60 | Yes |
| SubFrm Sales Brief Selection Sourced From ED | Sales Brief Selection Marketing Sourced From | 10 | Yes |
| SubFrm Sales Brief Selection Sourced From SD | Sales Brief Selection Marketing Sourced From | 10 | Yes |
| SubFrm Sales Brief Selection Sourced From SED | Sales Brief Selection Marketing Sourced From | 10 | Yes |
| SubFrm Sales Brief Selection Sourced From SkD | Sales Brief Selection Marketing Sourced From | 10 | Yes |
| SubFrm Sales Brief Status History | Sales Brief Status History | 8 | No |
| SubFrm Sales Brief Sub Products | Sales Brief Sub Products | 16 | Yes |
Reports (37)
| Report | Record Source | Sections |
|---|---|---|
| Calibri | Qry Rpt Sales Brief Past In Progress No Contract Number | 2 |
| Calibri | Qry Report Sales Brief | 2 |
| Calibri | Qry SubRpt Corhort Ignition Qty Year by Sales Brief | 0 |
| Calibri | Qry SubRpt Principals Sales Contacts | 0 |
| Calibri | Qry SubRpt Principals Sales Countries | 0 |
| Calibri | Principals Sales Languages | 0 |
| Calibri | Qry SubRpt Principals Sales | 0 |
| Calibri | Sales Brief Bookkeeping Process Description | 0 |
| Calibri | Sales Brief Contract Numbers | 0 |
| Calibri | Sales Brief Efficacy Non Standard Elements | 0 |
| Calibri | Qry SubRpt Extra Sponsor Elements | 0 |
| Calibri | Qry SubRpt Finance Distribution Model Type Fees | 0 |
| Calibri | Sales Brief Finance Invoice Month | 0 |
| Calibri | Qry SubRpt Finance Programme Fees | 0 |
| Calibri | Sales Brief Finance Special Payment Terms | 0 |
| Calibri | Sales Brief Guiding Deliverables Bespoke | 0 |
| Calibri | Sales Brief Guiding Towards | 0 |
| Calibri | Sales Brief Learning Deliverables Bespoke | 0 |
| Calibri | Sales Brief Learning Guides Notified | 0 |
| Calibri | SELECT [Qry SubRpt Sales Brief Marketing].[Sales Brief ID], [Qry SubRpt Sales Br | 0 |
| Calibri | SELECT [Qry SubRpt Sales Brief Marketing].[Sales Brief ID], [Qry SubRpt Sales Br | 0 |
| Calibri | SELECT [Qry SubRpt Sales Brief Marketing].[Sales Brief ID], [Qry SubRpt Sales Br | 0 |
| Calibri | SELECT [Qry SubRpt Sales Brief Marketing].[Sales Brief ID], [Qry SubRpt Sales Br | 0 |
| Calibri | Sales Brief Principal Priorities | 0 |
| Calibri | Sales Brief Revision Edit History | 0 |
| Calibri | Sales Brief SD Initiatives | 0 |
| Calibri | SELECT [Qry SubRpt Sales Brief Selection].[Sales Brief ID], [Qry SubRpt Sales Br | 0 |
| Calibri | Sales Brief Selection Marketing Candidates Sourced From | 0 |
| Calibri | Sales Brief Selection Marketing Client Supply Chain Requirement | 0 |
| Calibri | Sales Brief Selection Marketing Commodities | 0 |
| Calibri | Sales Brief Selection Marketing Selection Criteria | 0 |
| Calibri | Qry SubRpt Sales Brief Selection Marketing Sourced From | 0 |
| Calibri | SELECT [Qry SubRpt Sales Brief Selection].[Sales Brief ID], [Qry SubRpt Sales Br | 0 |
| Calibri | SELECT [Qry SubRpt Sales Brief Selection].[Sales Brief ID], [Qry SubRpt Sales Br | 0 |
| Calibri | SELECT [Qry SubRpt Sales Brief Selection].[Sales Brief ID], [Qry SubRpt Sales Br | 0 |
| Calibri | Qry SubRpt Sales Brief Status and Revision History | 0 |
| Calibri | Qry SubRpt Sub Products | 0 |
Queries (52)
| Query | Type | Tables |
|---|---|---|
| aa1 | Select | Sales Brief Selection Marketing, Sales |
| aa2 | Select | Sales Brief Selection Marketing, Sales |
| Find duplicates for Sales Brief Selection Marketing | Select | Sales Brief Selection Marketing, Sales |
| JB Check it | Select | Sales, Sales Brief |
| JB Convert Delete Extra Records | Select | Sales Brief Selection Marketing, Sales |
| JB Qry Append Proposal Writers | Delete | Proposal |
| JB Qry Append Selection Marketing Products | Delete | Sales Brief Selection Marketing, Sales |
| JB Qry Check Sales Brief Selection Marketing Products | Select | Sales Brief Selection Marketing, Sales |
| JB Qry Check the conversion | Select | Sales Brief Selection Marketing Products, Principals Sales |
| JB Qry Update Principal Countries | Delete | Principals, Principals Sales |
| JB Qry Update Principal Languages | Delete | Principals, Principals Sales |
| Qry Application Versions | Select | |
| Qry Calculate Standard Marketing Budget by Sales Brief | Select | Qry Sum Total Programme Fee by Sales Brief, Sales Brief |
| Qry Get Date Sales Brief Submitted to Business | Select | Sales, Sales Brief Status History |
| Qry Get Emerald Users | Select | DatabaseUsers Module Permissions, DatabaseUsers |
| Qry Get Principal Marketing Contact by Sales Brief | Select | Sales, Principals Sales Contacts |
| Qry Get Unique Proposal Divisions | Select | Divisions Proposal, Proposal Delivery Regions |
| Qry Principal List | Select | Principals, Principals Sales |
| Qry Product Distribution Models Proposal | Select | Distribution Models Proposal, Product Distribution Models Proposal |
| Qry Product Divisions Proposal | Select | Divisions Proposal, Product |
| Qry Product List Proposal | Select | Products Proposal, Products |
| Qry Products NOT in Proposal | Select | Products Proposal, SubQry Products NOT in Proposal |
| Qry Proposal Delivery Regions List | Select | Delivery Locations Sales, Proposal |
| Qry Proposal List | Select | Principals, Proposal |
| Qry Proposal Product List | Select | Proposal Products, Products Proposal |
| Qry Proposals Assigned to Principal List | Select | Principals, Proposal |
| Qry Report Proposal TAT Non Standard | Select | Qry Sum Time Tracker Minutes by Proposal, Principals Sales |
| Qry Report Proposal TAT Standard | Select | Qry Sum Time Tracker Minutes by Proposal, Principals Sales |
| Qry Report Sales Brief | Select | Qry Get Date Sales Brief Submitted to Business, Reporting Frequency |
| Qry Report Writer | Select | Qry Sum Time Tracker Minutes by Proposal, Principals Sales |
| Qry Rpt Sales Brief Past In Progress No Contract Number | Select | Principals Sales, Client Tiers |
| Qry Sales Brief List | Select | Sales, Sales Brief Status |
| Qry Sales Briefs Assigned to Principal List | Select | Principals, Sales Brief Status |
| Qry SubRpt Corhort Ignition Qty Year by Sales Brief | Select | Sales Brief Selection Marketing, Sales |
| Qry SubRpt Extra Sponsor Elements | Select | Sales, Sales Brief Extra Sponsor Elements |
| Qry SubRpt Finance Distribution Model Type Fees | Select | Distribution Model Types, Sales |
| Qry SubRpt Finance Programme Fees | Select | Sales, Sales Brief Selection Marketing Products |
| Qry SubRpt Principals Sales Contacts | Select | Contact Type LkUp, Principals Sales Contacts |
| Qry SubRpt Principals Sales Countries | Select | CountryLookup, Principals Sales Countries |
| Qry SubRpt Principals Sales | Select | Principals, Client Tiers |
| Qry SubRpt Sales Brief Marketing | Select | Sales Brief Selection Marketing, Qry Get Principal Marketing Contact by Sales Brief |
| Qry SubRpt Sales Brief Selection Marketing Sourced From | Select | Delivery Locations Sales, Sales |
| Qry SubRpt Sales Brief Selection | Select | Sales Brief Selection Marketing, Sales |
| Qry SubRpt Sales Brief Status and Revision History | Select | Sales, Sales Brief Status |
| Qry SubRpt Sub Products | Select | Sub Products Sales, Sales |
| Qry Sum Time Tracker Minutes by Proposal | Select | Proposal Time Tracking, Proposal |
| Qry Sum Total Distribution Model Fees by Sales Brief | Select | Sales, Sales Brief Finance Distribution Model Type Fees |
| Qry Sum Total Extra Sponsor Elements by Sales Brief | Select | Sales, Sales Brief Extra Sponsor Elements |
| Qry Sum Total Programme Fee by Sales Brief | Select | Sales, Sales Brief Selection Marketing Products |
| Qry Sum Total Sub Product Fee by Sales Brief | Select | Sales, Sales Brief Sub Products |
| qryLinkODBC | Select | zstblODBC_tables, zstblODBC_db |
| SubQry Products NOT in Proposal | Select | Proposal Products, Proposal |