gateway - Business Logic Overview
User Interfaces
Forms
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 15 more
Actions: - Calibri - AddPrincipalProject - CloseForm
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 - Contract Type → Contract Type - Contract Start Date → Contract Start Date - Date Principal Requires Packs → Date Principal Requires Packs - ... and 14 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 Company Principal Project
Purpose: Add Company Principal Project Data Source: Unbound
Input Fields: - Calibri - Calibri - Calibri - Entrepreneur Company Principal Project ID - Principal Project Pillar ID - Allocated Amount - Entrepreneur Company Programme Years ID - Monthly Allocated Amount - Replacement For - Selection Fee Type - ... and 3 more
Actions: - Calibri - ChooseFromReplacementList - CloseForm
Company List
Purpose: Double click on a Company Principal Project to Edit. Data Source: Unbound
Input Fields: - Calibri - Calibri - Calibri - StrCriteria1 - CompanyList - PrincipalProjectList
Actions: - Calibri - CloseForm
Company Needs Replacement List
Purpose: Company Needs Replacement List Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - ReplacementList
Actions: - Tahoma - UseThisPrincipalProject - CloseForm
Enter Principal Project Name
Purpose: Edit Sales Brief Status Data Source: Unbound
Input Fields: - Project Name
Actions: - MS Sans Serif - CloseForm - CancelForm
Opening Dialog
Purpose: Password Dialog Data Source: Unbound
Input Fields: - Password - Username - CurrentUser - LEVEL
Actions: - MS Sans Serif - CancelButton
Principal List
Purpose: Principal List Data Source: Unbound
Input Fields: - Tahoma - Tahoma - Tahoma - PrincipalList - StrCriteria1 - PrincipalProjectList
Actions: - Tahoma - AddProject - CloseForm
Sales Brief List
Purpose: Gateway Emerald - Purple Data Source: Unbound
Input Fields: - Calibri - Calibri - Calibri - SalesBriefList - RevisionList
Actions: - Calibri - TransferSalesBrief - PrincipalProjects - EditAllocations - CloseForm
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 11 more
Actions: - Calibri - DeletePrincipalProject - PrevRecord - NextRecord
SubFrm Edit 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 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: Temp Principal Project Pillar Extra Information
Input Fields: - Calibri - Calibri - Lump Sum Allocation → Lump Sum Allocation - Scout → Scout - BBBEE Pillar → BBBEE Pillar - Entrepreneur Delivery Date → Entrepreneur Delivery Date - Temp ID → Temp ID
Actions: - Calibri
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