Skip to content

Data Dictionary

Appendices LkUp

  • Appendix ID: Long *
  • Appendix (PK): Text

BBBEE Pillar Sales LkUp

  • BBBEE Pillar ID: Long *
  • BBBEE Pillar Description: Text
  • BBBEE Pillar: Text

Candidates Sourced From LkUp

  • Candidates Sourced From ID: Long *
  • Candidates Sourced From: Text

Channel Partner LkUp

  • Channel Partner ID: Long *
  • Channel Partner: Text

Client Tender Brief Meeting LkUp

  • Client Tender Brief Meeting ID: Long *
  • Client Tender Brief Meeting: Text

Client Tiers

  • Client Tier ID: Long *
  • Client Tier: Text
  • Client Tier Range: Text

Contact Type LkUp

  • Contact Type ID: Long *
  • Contact Type: Text

Contract Duration LkUp

  • Contract Duration ID: Long *
  • Contract Duration: Text

Contract Type LkUp

  • Contract Type ID: Long *
  • Contract Type: Text

ContractCurrencyLookup

  • Contract Currency ID: Long *
  • Contract Currency: Text

CountryLookup

  • Country ID: Long *
  • Country (PK): Text
  • Country Code: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

DatabaseUsers Module Permissions

  • Module Permission ID: Long *
  • Username: Text *
  • Module Permission: Text
  • LEVEL: Text
  • Role: Text

DatabaseUsers

  • User ID: Long *
  • Username (PK): Text *
  • 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

  • Delivery Location ID: Long *
  • Delivery Location: Text
  • Distribution Model ID: Long

DepartmentLookup

  • ID (PK): Long *
  • Department: Text

Distribution Model Types

  • Distribution Model Type ID: Long *
  • Distribution Model Type: Text
  • Floor Size: Text
  • Capacity: Text

Distribution Models Proposal

  • Distribution Model ID: Long *
  • Distribution Model: Text
  • Distribution Model Code: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Divisions Proposal

  • Division ID: Long *
  • Division (PK): Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Email Recipient List

  • Email Recipient ID: Long *
  • Email Function Name: Text
  • Email Recipient: Text

EmailFunctionLookup

  • Email Function ID: Long *
  • Email Function Name: Text

Entity Contracted LkUp

  • Entity Contracted ID: Long *
  • Entity Contracted: Text

ExpectedPaymentFrequencyLookup

  • Expected Payment Frequency ID: Long *
  • Expected Payment Frequency: Text

External Service Providers LkUp

  • External Service Providers ID: Long *
  • External Service Providers: Text

Extra Sponsor Element Lookup

  • Extra Sponsor Element ID: Long *
  • Extra Sponsor Element: Text
  • Admin Fee: Double

Feasibility Study Length LkUp

  • Feasibility Study Length ID: Long *
  • Feasibility Study Length: Text

Funding Amount Administered By LkUp

  • Funding Amount Administered By ID: Long *
  • Funding Amount Administered By: Text

Funding Solution LkUp

  • Funding Solution ID: Long *
  • Funding Solution: Text

General Sales

  • Front End Version Number: Text *
  • PDFFilePath: Text

Growth Stage LkUp

  • Growth Stage ID: Long *
  • Growth Stage: Text

Impact Statistic Type LkUp

  • Impact Statistic Type ID: Long *
  • Impact Statistic Type: Text

Industry Charter LkUp

  • Industry Charter ID: Long *
  • Industry Charter: Text

IndustryLookupSales

  • Industry ID: Long *
  • Industry (PK): Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Info Session Type LkUp

  • Info Session Type ID: Long *
  • Info Session Type: Text

Invoice Day LkUp

  • Invoice Day ID: Long *
  • Invoice Day: Text

Language LkUp

  • Language ID: Long *
  • Language (PK): Text

Lead Generated Method LkUp

  • Lead Generated Method ID: Long *
  • Lead Generated Method: Text

Lead Report Frequency LkUp

  • Lead Report Frequency ID: Long *
  • Lead Report Frequency: Text

Month LkUp

  • Month Number: Long *
  • Month Name: Text
  • Last Day: Integer

Other Frameworks LkUp

  • Other Framework ID: Long *
  • Other Framework: Text

Other Solutions for Appendix LkUp

  • Other Solutions for Appendix ID: Long *
  • Other Solutions for Appendix: Text
  • Paid For Database ID: Long *
  • Paid For Database: Text

Payment Terms LkUp

  • Payment Terms ID: Long *
  • Payment Terms: Text

Pillar Proposal LkUp

  • Pillar ID: Long *
  • Division ID: Long
  • Pillar Description: Text
  • Pillar (PK): Text

PR Type LkUp

  • PR Type ID: Long *
  • PR Type: Text

Principals Sales Contacts

  • 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

  • Principal Country ID: Long *
  • Principal ID: Long
  • Country ID: Long

Principals Sales Languages

  • Principal Language ID: Long *
  • Principal ID: Long
  • Language: Text

Principals Sales

  • Principal ID: Long *
  • Principal (PK): Text
  • 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

  • Product Distribution Model ID: Long *
  • Product ID: Long
  • Distribution Model ID: Long

Product Divisions Proposal

  • Product Division ID: Long *
  • Product ID: Long
  • Division ID: Long

Products Proposal

  • Product ID: Long *
  • Product (PK): Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Products Sales

  • Product ID: Long *
  • Product (PK): Text
  • BBBEE Pillar: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary *

Proposal Appendices

  • Proposal Appendices ID: Long *
  • Proposal ID: Long
  • Appendix ID: Text

Proposal Client Needs

  • Proposal Client Need ID: Long *
  • Proposal ID: Long
  • Proposal Client Need: Text

Proposal Commodities

  • Proposal Commodity ID: Long *
  • Proposal ID: Long
  • Proposal Commodity: Text

Proposal Delivery Regions

  • 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

  • Proposal External Service Provider ID: Long *
  • Proposal ID: Long
  • Proposal External Service Provider: Text

Proposal Feasibility Study

  • Proposal Feasibility Study ID: Long *
  • Proposal ID: Long
  • Proposal Feasibility Study: Text

Proposal Funding Solution

  • Proposal Funding Solution ID: Long *
  • Proposal ID: Long
  • Proposal Funding Solution: Text

Proposal Growth Stages

  • Proposal Growth Stage ID: Long *
  • Proposal ID: Long
  • Proposal Growth Stage: Text

Proposal Impact Statistics Types

  • Proposal Impact Statistic Type ID: Long *
  • Proposal ID: Long
  • Proposal Impact Statistic Type: Text

Proposal Lost Reason LkUp

  • Proposal Lost Reason ID: Long *
  • Proposal Lost Reason: Text

Proposal Non SA Regions

  • Proposal Non SA Regions ID: Long *
  • Proposal ID: Long
  • Proposal Non SA Regions: Text

Proposal Other Solutions for Appendix

  • Proposal Other Solution for Appendix ID: Long *
  • Proposal ID: Long
  • Proposal Other Solution for Appendix: Text

Proposal Pillars

  • Proposal Pillar ID: Long *
  • Proposal ID: Long
  • Pillar ID: Long

Proposal Products

  • Proposal Products ID: Long *
  • Proposal ID: Long
  • Product ID: Long

Proposal Sourcing and Selection

  • Proposal Sourcing and Selection ID: Long *
  • Proposal ID: Long
  • Proposal Sourcing and Selection: Text

Proposal Stakeholders Other

  • Proposal Other Stakeholder ID: Long *
  • Proposal ID: Long
  • Proposal Other Stakeholder: Text

Proposal Status History

  • Proposal Status History ID: Long *
  • Proposal ID: Long
  • Proposal Status ID: Long
  • Date Status Changed: DateTime
  • Status Modified By: Text

Proposal Status

  • Proposal Status ID: Long *
  • Proposal Status: Text
  • Sort Order: Long

Proposal Time Tracking

  • Proposal Time Tracking ID: Long *
  • Proposal ID: Long
  • Time Tracking Date: DateTime
  • Time Tracking Time: Long
  • Time Tracking Description: Text

Proposal Top Priorities

  • Proposal Top Priority ID: Long *
  • Proposal ID: Long
  • Proposal Top Priority: Text
  • Proposal Top Priority Ranking: Long

Proposal Tried So Far

  • Proposal Tried So Far ID: Long *
  • Proposal ID: Long
  • Proposal Tried So Far: Text

Proposal Type of Document LkUp

  • 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

  • Proposal Who is Reading ID: Long *
  • Proposal ID: Long
  • Name: Text
  • Role: Text
  • Strategic Lens: Text

Proposal Writers

  • Proposal Writers ID: Long *
  • Proposal ID: Long
  • Writer Role: Text *
  • Writer Role Other: Text
  • Writer Name: Text
  • Writer Name Other: Text

Proposal

  • 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

  • ID (PK): Long *
  • Description: Text
  • Include Field Name: Text
  • Sort Order: Long

Reporting Frequency

  • Reporting Frequency ID: Long *
  • Reporting Frequency: Text
  • Reporting Frequency Description: Text

RoleLookup

  • Role ID: Long *
  • Role (PK): Text

Sales Brief Bookkeeping Process Description

  • Bookkeeping Process Description ID: Long *
  • Sales Brief ID: Long
  • Bookkeeping Process Description: Text

Sales Brief Contract Numbers

  • Sales Brief Contract Numbers ID: Long *
  • Sales Brief ID: Long
  • Contract Number: Text

Sales Brief Efficacy Non Standard Elements

  • Efficacy Non Standard Elements Description ID: Long *
  • Sales Brief ID: Long
  • Efficacy Non Standard Elements Description: Text

Sales Brief Extra Sponsor Elements

  • 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

  • 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

  • Sales Brief Finance Invoice Month ID: Long *
  • Sales Brief ID: Long
  • Sales Brief Finance Invoice Month: Text

Sales Brief Finance Special Payment Terms

  • Sales Brief Special Payment Terms ID: Long *
  • Sales Brief ID: Long
  • Sales Brief Special Payment Terms Item: Text

Sales Brief Guiding Deliverables Bespoke

  • Sales Brief Guiding Deliverables Bespoke ID: Long *
  • Sales Brief ID: Long
  • Sales Brief Guiding Deliverables Bespoke Item: Text

Sales Brief Guiding Towards

  • Sales Brief Guiding Towards ID: Long *
  • Sales Brief ID: Long
  • Sales Brief Guiding Towards Item: Text

Sales Brief Learning Deliverables Bespoke

  • Sales Brief Learning Deliverables Bespoke ID: Long *
  • Sales Brief ID: Long
  • Sales Brief Learning Deliverables Bespoke Item: Text

Sales Brief Learning Guides Notified

  • Sales Brief Learning Guides Notified ID: Long *
  • Sales Brief ID: Long
  • Sales Brief Learning Guides Notified Item: Text

Sales Brief Principal Priorities

  • Principal Priorities ID: Long *
  • Sales Brief ID: Long
  • Principal Priority: Text

Sales Brief Principal Referral Contacts

  • 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

  • Sales Brief Edit ID: Long *
  • Sales Brief ID: Long
  • Field Modified: Text
  • Modified By: Text
  • Date Modified: DateTime

Sales Brief SD Initiatives

  • Sales Brief SD Initiatives ID: Long *
  • Sales Brief ID: Long
  • Sales Brief SD Initiatives Item: Text

Sales Brief Selection Marketing Candidates Sourced From

  • Candidates Sourced From ID: Long *
  • Sales Brief Selection Marketing ID: Long
  • Candidates Sourced From: Text

Sales Brief Selection Marketing Client Supply Chain Requirement

  • Client Supply Chain Requirement ID: Long *
  • Sales Brief Selection Marketing ID: Long
  • Client Supply Chain Requirement: Text

Sales Brief Selection Marketing Commodities

  • Sales Brief Selection Marketing Commodity ID: Long *
  • Sales Brief Selection Marketing ID: Long
  • Commodity: Text

Sales Brief Selection Marketing Products

  • 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

  • Sales Brief Selection Marketing Selection Criteria ID: Long *
  • Sales Brief Selection Marketing ID: Long
  • Selection Criteria: Text

Sales Brief Selection Marketing Sourced From

  • 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

  • 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

  • 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

  • Sales Brief Status ID: Long *
  • Sales Brief Status: Text
  • Sort Order: Long

Sales Brief Sub Products

  • 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

  • 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

  • Sourcing and Selection ID: Long *
  • Sourcing and Selection: Text

Sub Products Sales

  • Sub Product ID: Long *
  • Sub Product: Text
  • BBBEE Pillar: Text
  • Frequency: Text
  • Active: Boolean
  • SSMA_TimeStamp: Binary

Supply Chain Requirements LkUp

  • Supply Chain Requirement ID: Long *
  • Supply Chain Requirement: Text

Temp Copy Ids

  • Org ID: Long
  • New ID: Long

Tender Brief Meeting LkUp

  • Tender Brief Meeting ID: Long *
  • Tender Brief Meeting: Text

Tender Sources LkUp

  • Tender Source ID: Long *
  • Tender Source: Text

Top Priorities LkUp

  • Top Priority ID: Long *
  • Top Priority: Text

Writer Role LkUp

  • Writer Role ID: Long *
  • Writer Role: Text

Year LkUp

  • Year ID: Long *
  • Year Number: Long

zstblODBC_db

  • DBID (PK): Long
  • SelectDB: Boolean
  • DatabaseName: Text
  • ServerName: Text *
  • DBName: Text *
  • Authentication: Text *
  • UID: Text
  • PWD: Text
  • Driver: Text *
  • DateAdded: DateTime *

zstblODBC_tables

  • TableID (PK): Long
  • Link: Boolean
  • Hidden: Boolean
  • DatabaseName: Text
  • TableName: Text
  • SourceTableName: Text
  • AfterDDL: Text
  • Comment: Text
  • DateAdded: DateTime *