garnet - Business Logic Overview
User Interfaces
Forms
Add and Edit Company Programme Year Status
Purpose: Add and Edit Company Programme Year Status Data Source: CompanyProgrammeYearStatus
Input Fields: - Company Programme Year Status ID → Company Programme Year Status ID - Programme Year Status → Programme Year Status - Active → Active - Sort Order → Sort Order - RecNum → =GetXofY([Forms]![Frm Add and Edit Company Programme Year Status])
Actions: - MS Sans Serif - CloseForm
Add and Edit Company Programme Year
Purpose: Edit Programme Year Data Source: Entrepreneur Company Programme Years
Input Fields: - Calibri - Calibri - Calibri - DisplayCompanyName - Entrepreneur Company ID → Entrepreneur Company ID - Programme Year → Programme Year - Contract Start Date → Contract Start Date - Company Programme Year Status ID → Company Programme Year Status ID - Company Programme Year Status Text → =[Company Programme Year Status ID].Column - Status Modified By → Status Modified By - ... and 21 more
Actions: - Calibri - EditProgrammeYearStatus - AddPrincipalProject - CloseForm
Add and Edit Company Status
Purpose: Add and Edit Company Status Data Source: CompanyStatus
Input Fields: - Company Status ID → Company Status ID - Status → Status - Active → Active - Sort Order → Sort Order - RecNum → =GetXofY(Forms![Frm Add and Edit Company Status])
Actions: - MS Sans Serif - CloseForm
Add and Edit Entrepreneur Company Sub Products
Purpose: Entrepreneur Company Sub Products Data Source: Entrepreneur Company Sub Products
Input Fields: - Calibri - Calibri - Calibri - DisplayCompanyName - Sub Product ID → Entrepreneur Company Sub Product ID - Sub Product Allocated Amount → Sub Product Allocated Amount - Entrepreneur Company ID → Entrepreneur Company ID
Actions: - Calibri - CloseForm
Add and Edit Entrepreneur Company
Purpose: Add and Edit Entrepreneur Company Data Source: Entrepreneur Company
Input Fields: - Calibri - Calibri - Calibri - Label87 → =[Company Name] - Company Name → Company Name - Business Address 1 → Business Address 1 - Business Address 2 → Business Address 2 - Business Address 3 → Business Address 3 - Business Postal Code → Business Postal Code - Industry ID → Industry ID - ... and 48 more
Actions: - Calibri - CloseForm
Add and Edit Non Graduate Reason
Purpose: Add and Edit Non Graduate Reason Data Source: NonGraduateReason
Input Fields: - Non Graduate Reason ID → Non Graduate Reason ID - Non Graduate Reason → Non Graduate Reason - RecNum → =GetXofY(Forms![Frm Add and Edit Non Graduate Reason])
Actions: - MS Sans Serif - DeleteRec - CloseForm - NewRecord
Add and Edit Primary Tenant
Purpose: Add and Edit Primary Tenants Data Source: PrimaryTenants
Input Fields: - Replacement Status ID → Replacement Status ID - PrimaryTenant → PrimaryTenant - RecNum → =GetXofY([Forms]![Frm Add and Edit Primary Tenant])
Actions: - MS Sans Serif - DeleteRec - CloseForm - NewRecord
Add and Edit Principal Project
Purpose: Add and Edit Principal Project Data Source: Principal Projects
Input Fields: - Calibri - Calibri - Calibri - Label87 → =[Forms]![Frm Principal List]![PrincipalList].Column - Principal ID → Principal ID - Project Name → Project Name - Principal Project ID → Principal Project ID - Solutions Architect → Solutions Architect - Version Number → Version Number - Contract Type → Contract Type - ... and 12 more
Actions: - Calibri - CloseForm
Add and Edit Principal
Purpose: Add and Edit Principal Data Source: Principals
Input Fields: - Calibri - Calibri - Calibri - Principal ID → Principal ID - Principal → Principal - Principal Address 1 → Principal Address 1 - Principal Address 2 → Principal Address 2 - Principal Address 3 → Principal Address 3 - Principal Address 4 → Principal Address 4 - Industry ID → Industry ID - ... and 6 more
Actions: - Calibri - CloseForm
Add and Edit Replacement Status
Purpose: Add and Edit Replacement Status Data Source: ReplacementStatusLookup
Input Fields: - Replacement Status ID → Replacement Status ID - Replacement Status → Replacement Status - RecNum → =GetXofY(Forms![Frm Add and Edit Replacement Status])
Actions: - MS Sans Serif - DeleteRec - CloseForm - NewRecord
Add and Edit Secondary Tenant
Purpose: Add and Edit Secondary Tenants Data Source: SecondaryTenants
Input Fields: - Replacement Status ID → Replacement Status ID - PrimaryTenant → SecondaryTenant - RecNum → =GetXofY([Forms]![Frm Add and Edit Secondary Tenant])
Actions: - MS Sans Serif - DeleteRec - CloseForm - NewRecord
Add Company Extra Sponsor Element
Purpose: Entrepreneur Company Extra Sponsor Elements Data Source: Entrepreneur Company Extra Sponsor Elements
Input Fields: - Calibri - Calibri - Calibri - DisplayCompanyName - Entrepreneur Company ID → Entrepreneur Company ID - Entrepreneur Company Extra Sponsor Element ID → Entrepreneur Company Extra Sponsor Element ID - Principal Project Pillar Sponsor Element ID → Principal Project Pillar Sponsor Element ID - Extra Sponsorship Amount → Extra Sponsorship Amount - ElementType → =[Principal Project Pillar Sponsor Element ID].Column - PaymentFrequency → =[Principal Project Pillar Sponsor Element ID].Column - ... and 1 more
Actions: - Calibri - CloseForm
Add Company Monthly Billing
Purpose: Add and Edit Principal Data Source: Entrepreneur Company Monthly Billings
Input Fields: - Calibri - Calibri - Calibri - Entrepreneur Company Billings ID → Entrepreneur Company Billings ID - Billing Date → Billing Date - Entrepreneur Company Principal Project ID → Entrepreneur Company Principal Project ID - Billing Description → Billing Description - BBBEE Pillar → =[Entrepreneur Company Principal Project ID].Column - Billing Amount → Billing Amount - CompanyName - ... and 2 more
Actions: - Calibri - CloseForm
Certificate Mail Merge
Purpose: Contract Mail Merge Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - CompanyList - NumberCompanies
Actions: - Tahoma - DoTheExport - DeleteRecs - CloseForm
Change Password
Purpose: Password Dialog Data Source: Unbound
Input Fields: - CurrentPassword - Username - NewPassword - ConfirmPassword
Actions: - MS Sans Serif - CancelButton - OKButton
Company Add Allocation List
Purpose: Allocation List Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - ReplacementList - PrincipalProjectList - Allocated Amount - Monthly Allocated Amount - Selection Fee Type - Selection Fee - StrCriteria1
Actions: - Tahoma - ClearFilters - CloseForm - UseThisPrincipalProject
Company Graduating List
Purpose: Entrepreneur Graduating List Data Source: DatabaseUsers
Input Fields: - Tahoma - Tahoma - Tahoma - Label32 → =\ - CriteriaCombo1 - StrCriteria1 - CompanyList - Filter1 - NumberCompanies
Actions: - Tahoma - ClearFilters - ReportMenu - CloseForm
Company Ignition List
Purpose: Entrepreneur Ignition List Data Source: DatabaseUsers
Input Fields: - Tahoma - Tahoma - Tahoma - Label32 → =\ - CriteriaCombo1 - StrCriteria1 - CompanyList - Filter1 - NumberCompanies
Actions: - Tahoma - ClearFilters - ReportMenu - CloseForm
Company List
Purpose: Garnet Data Source: Unbound
Input Fields: - Calibri - Calibri - Calibri - CriteriaCombo1 - StrCriteria1 - CompanyList - Filter1 - PrincipalProjectList - NumberCompanies - CompanyStatus
Actions: - Calibri - ClearFilters - ReportMenu - MaintenanceFunction - MonthlyBillingsFunction - CloseForm
Company On Programme List
Purpose: Company On Programme List Data Source: DatabaseUsers
Input Fields: - Tahoma - Tahoma - Tahoma - CriteriaCombo1 - StrCriteria1 - Filter1 - CompanyList - NumberCompanies
Actions: - Tahoma - ClearFilters - ReportMenu - CloseForm
Company Raizcorpossible List
Purpose: Raizcorpossibles - Blank, Unallocated or Delivery Raizcorpossible Data Source: Unbound
Input Fields: - Calibri - Calibri - Calibri - CriteriaCombo1 - StrCriteria1 - CompanyList - Filter1 - NumberCompanies
Actions: - Calibri - ClearFilters - LumpSumAllocation - ReportMenu - CloseForm
Contract Mail Merge
Purpose: Contract Mail Merge Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - EntrepreneurList - NumberEntrepreneurs
Actions: - Tahoma - DoTheExport - DeleteRecs - CloseForm
Delivery vs Exited Report Dialog
Purpose: Pipeline Movement Report Dialog Data Source: Unbound
Input Fields: - StartDate
Actions: - MS Sans Serif - OKButton - CancelButton
Edit Company Allocation
Purpose: Edit Company Allocation Data Source: Entrepreneur Company
Input Fields: - Calibri - Calibri - Calibri - Entrepreneur Company ID → Entrepreneur Company ID - Company Name → Company Name - Ring Fencing → Ring Fencing - Company Status ID → Company Status ID - Company Status Text → =[Company Status ID].Column - PrincipalProjectList - Status Modified By → Status Modified By - ... and 5 more
Actions: - Calibri - EditCompany - EditCompanyStatus - AddProgrammeYear - AddExtraSponsor - Command125 - CloseForm
Edit Company Extra Sponsor Element
Purpose: Entrepreneur Company Extra Sponsor Elements Data Source: Entrepreneur Company Extra Sponsor Elements
Input Fields: - Calibri - Calibri - Calibri - DisplayCompanyName - Entrepreneur Company ID → Entrepreneur Company ID - Entrepreneur Company Extra Sponsor Element ID → Entrepreneur Company Extra Sponsor Element ID - Principal Project Pillar Sponsor Element ID → Principal Project Pillar Sponsor Element ID - Extra Sponsorship Amount → Extra Sponsorship Amount - ElementType → =[Principal Project Pillar Sponsor Element ID].Column - PaymentFrequency → =[Principal Project Pillar Sponsor Element ID].Column - ... and 2 more
Actions: - Calibri - CloseForm
Edit Company Monthly Billing
Purpose: Add and Edit Principal Data Source: Entrepreneur Company Monthly Billings
Input Fields: - Calibri - Calibri - Calibri - Entrepreneur Company Billings ID → Entrepreneur Company Billings ID - Billing Date → Billing Date - Entrepreneur Company Principal Project ID → Entrepreneur Company Principal Project ID - Billing Description → Billing Description - BBBEE Pillar → =[Entrepreneur Company Principal Project ID].Column - Billing Amount → Billing Amount
Actions: - Calibri - CloseForm
Edit Company Programme Year Status
Purpose: Edit Company Status Data Source: Unbound
Input Fields: - Company Programme Year Status ID - Entrepreneur Company Programme Years ID - Non Graduate Reason ID - Break Start
Actions: - MS Sans Serif - CloseForm
Edit Company Status
Purpose: Edit Company Status Data Source: Unbound
Input Fields: - Company Status ID - Entrepreneur Company ID - Override Status Rules
Actions: - MS Sans Serif - CloseForm
Edit Email Recipient List
Purpose: Add and Edit Email Recipient List Data Source: Email Recipient List
Input Fields: - Email Recipient → Email Recipient - Email Function Name → Email Function Name - Email Recipient ID → Email Recipient ID - RecNum → =GetXofY(Forms![Frm Edit Email Recipient List])
Actions: - MS Sans Serif - DeleteRec - CloseForm - NewRecord
Lump Sum Allocation Dialog
Purpose: Lump Sum Allocation Dialog Data Source: Unbound
Input Fields: - Calibri - Principal Project
Actions: - MS Sans Serif - OKButton - CancelButton
Lump Sum Allocation
Purpose: Lump Sum Allocation Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - CompanyList - NumberCompanies - Principal Project ID - Programme Year - Contract Start Date - Product ID - Total Programme Amount - ... and 6 more
Actions: - Tahoma - DoTheAllocation - DeleteRecs - CloseForm
Maintenance Menu
Purpose: Maintenance Menu Data Source: Unbound
Actions: - MS Sans Serif - CloseForm - CompanyStatus - NonGraduateReason - ReplacementStatus - CompanyYearStatus - Principals - EmailRecipientList - PrimaryTenants\015\012PrimaryTenants\015\012PrimaryTenants - SecondaryTenants
Monthly Billings Date Dialog
Purpose: Monthly Billings Date Dialog Data Source: Unbound
Input Fields: - Billing Date - Billing Month → =Month([Billing Date]) - Billing Year → =Year([Billing Date])
Actions: - MS Sans Serif - OKButton - CancelButton
Monthly Billings Menu
Purpose: Monthly Billing Menu Data Source: Unbound
Actions: - MS Sans Serif - CloseForm - GenerateMonthlyBillings - ViewEditMonthlyBillings
Monthly Billings
Purpose: Monthly Billings Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - CompanyList - NumberCompanies - Billing Date
Actions: - Tahoma - GenerateMonthlyBillings - DeleteRecs - ExportMonthlyBillings - CloseForm
Opal Scorecard Report Dialog
Purpose: Opal Scorecard Report Dialog Data Source: Unbound
Input Fields: - StartDate
Actions: - MS Sans Serif - OKButton - CancelButton
Opening Dialog
Purpose: Password Dialog Data Source: Unbound
Input Fields: - Password - Username - CurrentUser - LEVEL - Role - Delivery Location ID - Distribution Model ID - UserDeliveryLocation
Actions: - MS Sans Serif - CancelButton
Part Sponsorship History Reports Date Dialog
Purpose: Part Sponsorship History Reports Date Dialog Data Source: Unbound
Input Fields: - StartDate
Actions: - MS Sans Serif - OKButton - CancelButton
Principal List
Purpose: Principal List Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - PrincipalList - StrCriteria1 - PrincipalProjectList
Actions: - Tahoma - CloseForm
Principal Project List
Purpose: Principal Project List Data Source: Unbound
Input Fields: - Calibri - Calibri - Calibri - CriteriaCombo1 - StrCriteria1 - PrincipalProjectList - Filter1 - CompanyList - NumberPrincipalProjects
Actions: - Calibri - ClearFilters - ReportMenu - CloseForm
Principal Project Status Report Dialog
Purpose: Principal Project Status Report Dialog Data Source: Unbound
Input Fields: - Calibri - Principal Project Status
Actions: - MS Sans Serif - OKButton - CancelButton
Principal Report Date Dialog
Purpose: Principal Report Date Dialog Data Source: Unbound
Input Fields: - Calibri - Principal Project
Actions: - MS Sans Serif - OKButton - CancelButton
Report Menu
Purpose: Report Menu Data Source: Unbound
Actions: - MS Sans Serif - CloseForm - RaizcorpPossibilitiesReport - RAG Report - Companies Needs Replacement Report - ExportNewAllocationReport - QuarterlyPrincipalReport - ActiveEntrepreneurEmailReport - ContractMailMergeExport - CertificateMailMergeExport - DeliveryVsExited - OpalScorecardA - PrincipalProjectAllocationReport - Principal Project Allocation Audit Report - SDAllocationsNotNotifiedSDMandSA - FinanceMonthlyReport - PrincipalProjectAllocationReportFinance - PrincipalProjectTotalsbyProsperator - ActiveEntrpreneursbyProsperator - CompaniesNeedToBeAllocated - PartSponsorshipHistoryExport - CompaniesLeftProgramme - CompaniesStartedProgramme - CompaniesAllocated - CompanyTotalsbyProsperator - SummarisedDeferredIncome - PreBillingExceptionReport - PrincipalProjectFinanceAuditReport - CompaniesIgnitedbyProduct - EntrepreneurListReport - ReportWriter
Report Writer Dialog
Purpose: Report Writer Dialog Data Source: Unbound
Input Fields: - Calibri - FieldsToInclude - CriteriaCombo1 - StrCriteria1 - CriteriaCombo2 - Filter1 - Filter2 - StrCriteria2 - CompanyStatus
Actions: - MS Sans Serif - OKButton - CancelButton - ClearFilters
Reports Date Dialog
Purpose: Reports Date Dialog Data Source: Unbound
Input Fields: - StartDate
Actions: - MS Sans Serif - OKButton - CancelButton
Reports Print Export Dialog
Purpose: Reports Print Export Dialog Data Source: Unbound
Actions: - MS Sans Serif - OKButton - CancelButton
View and Edit Monthly Billings
Purpose: Monthly Billings Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - CompanyList - CriteriaCombo1 - StrCriteria1 - Filter1
Actions: - Tahoma - AddMonthlyBilling - CloseForm
SubFrm Company Programme Year Status History
Purpose: Entrepreneur Status History Data Source: Entrepreneur Company Programme Year Status History
Input Fields: - Entrepreneur Company Programme Years ID → Entrepreneur Company Programme Years ID - ID Number → ID Number - Date Status Changed → Date Status Changed - Company Programme Year Status ID → Company Programme Year Status ID - Status Modified By → Status Modified By
Actions: - MS Sans Serif
SubFrm Company Status History
Purpose: Entrepreneur Status History Data Source: Entrepreneur Company Status History
Input Fields: - Entrepreneur Company ID → Entrepreneur Company ID - ID Number → ID Number - Date Status Changed → Date Status Changed - Company Status ID → Company Status ID - Status Modified By → Status Modified By
Actions: - MS Sans Serif
SubFrm Edit Company Principal Project
Purpose: Edit Company Principal Project Data Source: Entrepreneur Company Principal Projects
Input Fields: - Calibri - Calibri - Calibri - Entrepreneur Company Principal Project ID → Entrepreneur Company Principal Project ID - Principal Project Pillar ID → Principal Project Pillar ID - Allocated Amount → Allocated Amount - Replacement Status → Replacement Status - Contract Printed → Contract Printed - Entrepreneur Company Programme Years ID → Entrepreneur Company Programme Years ID - Monthly Allocated Amount → Monthly Allocated Amount - ... and 13 more
Actions: - Calibri - DeletePrincipalProject - PrevRecord - NextRecord
SubFrm Entrepreneur Company Areas of Operation
Purpose: Entrepreneur Company Areas of Operation Data Source: Entrepreneur Company Areas of Operation
Input Fields: - Entrepreneur Area of Operation ID → Entrepreneur Area of Operation ID - Entrepreneur Company ID → Entrepreneur Company ID - Area of Operation → Area of Operation
Actions: - MS Sans Serif - DeleteRec
SubFrm Entrepreneur Company Commodities
Purpose: Entrepreneur Company Commodities Data Source: Entrepreneur Company Commodities
Input Fields: - Entrepreneur Company Commodity ID → Entrepreneur Company Commodity ID - Entrepreneur Company ID → Entrepreneur Company ID - Commodity → Commodity
Actions: - MS Sans Serif - DeleteRec
SubFrm Entrepreneur Company Extra Sponsor Payments
Purpose: Entrepreneur Company Extra Sponsor Payments Data Source: Entrepreneur Company Extra Sponsor Payments
Input Fields: - Entrepreneur Company Extra Sponsor Payment ID → Entrepreneur Company Extra Sponsor Payment ID - Entrepreneur Company Extra Sponsor Element ID → Entrepreneur Company Extra Sponsor Element ID - Payment Date → Payment Date - Payment Amount → Payment Amount - TotalPayments → =Sum([Payment Amount])
Actions: - MS Sans Serif - DeleteRec
SubFrm Entrepreneur Company Supporting Documents
Purpose: SubFrm Entrepreneur Company Data Source: Entrepreneur Company
Input Fields: - Calibri - Calibri - Entrepreneur Company ID → Entrepreneur Company ID - CompanyReg → CompanyReg - BEE Certificate Expire Date → BEE Certificate Expire Date - Tax Clearance Expire Date → Tax Clearance Expire Date - VAT Registration Number → VAT Registration Number - Business Registration Date → Business Registration Date - Sworn Affidavit Date → Sworn Affidavit Date - Proof of Turnover Letter Date → Proof of Turnover Letter Date - ... and 5 more
Actions: - Calibri
SubFrm Entrepreneur Recommended Information
Purpose: Entrepreneur Recommended Information Data Source: Qry Get Entrepreneur Recommended Information
Input Fields: - Entrepreneur Company Programme Years ID → Entrepreneur Company Programme Years ID - ID Number → Entrepreneur Company ID - Entrepreneur → Entrepreneur - Lead Type → Lead Type - Lead Source → Lead Source - Division ID → Division ID - Distribution Model ID → Distribution Model ID
Actions: - MS Sans Serif
SubFrm Principal Project Pillar Commodities
Purpose: Principal Project Pillar Commodities Data Source: Principal Project Pillar Commodities
Input Fields: - Principal Project Pillar ID → Principal Project Pillar ID - Commodity → Commodity - Principal Project Pillar Commodity ID → Principal Project Pillar Commodity ID
Actions: - MS Sans Serif
SubFrm Principal Project Pillar Delivery Location
Purpose: Principal Project Pillar Prosperator Data Source: Principal Project Pillar Delivery Location
Input Fields: - Principal Project Pillar ID → Principal Project Pillar ID - Principal Project Pillar Prosperator ID → Principal Project Pillar Delivery Location ID - Delivery Location → Delivery Location
Actions: - MS Sans Serif
SubFrm Principal Project Pillar Sourced From
Purpose: Principal Project Pillar Sourced From Data Source: Principal Project Pillar Sourced From
Input Fields: - Principal Project Pillar Source ID → Principal Project Pillar Source ID - Principal Project Pillar ID → Principal Project Pillar ID - Entrepreneur Sourced → Entrepreneur Sourced
Actions: - MS Sans Serif
SubFrm Principal Project Pillar Sponsor Elements
Purpose: Principal Project Pillar Sponsor Elements Data Source: Principal Project Pillar Sponsor Elements
Input Fields: - Principal Project Pillar ID → Principal Project Pillar ID - Principal Project Pillar Sponsor Element ID → Principal Project Pillar Sponsor Element ID - Element Type → Element Type - Sponsorship Amount → Sponsorship Amount - Admin Fee → Admin Fee - Number of Entrepreneurs → Number of Entrepreneurs - Once Off Payment Date → Once Off Payment Date - Frequency of Payments → Frequency of Payments - Monthly Day of Month → Monthly Day of Month - Payment Amount → Payment Amount - ... and 1 more
Actions: - MS Sans Serif - DeleteRec
SubFrm Principal Project Pillar Sub Products
Purpose: Principal Project Pillar Sponsor Elements Data Source: Principal Project Pillar Sub Products
Input Fields: - Sub Product ID → Sub Product ID - Sponsorship Amount → Sponsorship Amount - Number of Entrepreneurs → Number of Entrepreneurs - Frequency → Frequency - Principal Project Pillar ID → Principal Project Pillar ID - Principal Project Pillar Sub Product ID → Principal Project Pillar Sub Product ID - TotalSponsorElement → =Sum([Sponsorship Amount])
Actions: - MS Sans Serif - DeleteRec
SubFrm Principal Project Pillar Supporting Documents
Purpose: Principal Project Pillar Supporting Documents Data Source: Qry SubFrm Principal Project Pillar Supporting Documents
Input Fields: - Principal Project Pillar ID → Principal Project Pillar ID - Supporting Documents Required → Supporting Documents Required
Actions: - MS Sans Serif
SubFrm Principal Project Pillars
Purpose: SubFrm Principal Project Pillars Data Source: Principal Project Pillars
Input Fields: - Calibri - Calibri - Principal Project Pillar ID → Principal Project Pillar ID - Principal Project ID → Principal Project ID - Amount Sponsored → Amount Sponsored - Number of Companies Required → Number of Companies Required - Does Principal Approve Entrepreneurs → Does Principal Approve Entrepreneurs - BBBEE Pillar → BBBEE Pillar - Lump Sum Allocation → Lump Sum Allocation - Scout → Scout - ... and 2 more
Actions: - Calibri - AddPillar - DeleteRec
SubFrm Principal Project Products Sold
Purpose: Principal Project Pillar Sourced From Data Source: Principal Project Products Sold
Input Fields: - Principal Project Pillar Source ID → Principal Project Pillar Source ID - Principal Project Product Sold ID → Principal Project Product Sold ID - Product → Product
Actions: - MS Sans Serif
SubFrm Total Billed To Date by Company PP
Purpose: Principal Project Pillar Prosperator Data Source: Qry Sum Total Billed by Company PP and Project Pillar
Input Fields: - Entrepreneur Company Principal Project ID → Entrepreneur Company Principal Project ID - Total Billed → Total Billed
Actions: - MS Sans Serif
Reports
- Calibri: Report Delivery vs Exited Entrepreneurs (Source: Qry Report Delivery vs Exited Entrepreneurs)
- Calibri: Principal Project Allocation Audit (Source: Qry Report Principal Project Allocation Audit)
- Calibri: Principal Project Allocation (Source: vwGarnetRptPrincipalProjectAllocation)
- Calibri: Principal Quarterly Reports (Source: Qry Report Principal Quarterly Reports)
- Calibri: Principal SD Letter (Source: Qry Report Principal SD Letter New Allocation)
- Calibri: Principal Project Allocation (Source: Qry Report SD Alocations Not Notified)
- Calibri: Companies in Principal SD Letter (Source: Qry SubRpt Companies in Principal SD Letter)
- Calibri: Current Principal Project Information by Entrepreneurial (Source: Qry Get Current Contract Info by Company)
- Calibri: Entrepreneurs in Principal SD Letter (Source: Qry SubRpt Entrepreneurs in Principal SD Letter)
- Calibri: Principal Project Allocation Audit Replaced Companies (Source: Qry SubRpt Principal Project Allocation Audit Replaced Companies)
- Calibri: SubRpt Principal Project Pillars (Source: Principal Project Pillars)
- Calibri: SubRpt Products Sold by Principal Project (Source: Principal Project Products Sold)