Farmer Deliveries
Purpose
The Farmer Deliveries data-table holds data for the quantities of cocoa received from KKFU farmers. It is a child data-table which links to other data-tables: Farmers and Societies. Each record includes a "SocietiesID" and "FarmersID" to link the record to the main data-entities of KKSys.
The Farmer Deliveries data-table includes data-fields for Date the cocoa was purchased, the quantity purchased in kilos, and 2 reference codes used by KKFU: The "Waybill Number" and "DPR Serial Number." The data-table also records the date and time it was created, and the author of the record.
A full listing of all the fields in the data-table with their purposes and any automation built into the App is laid out below. To fully understand the purpose of the data-fields please consult this.
How and where to access Farmer Deliveries data
The image below shows the "Farmer Deliveries" Edit Form. This is accessed via a child-entity, grouped with the People / Farmers / Staff entity on the System Entities screen.
Farmer Deliveries edit form
Note that the layout of this edit form may have changed if it has been updated by your administrator, and additional actions, reports or resources may have been added.
How access to FarmerDeliveries works in practice in KKSys
Because very large numbers of delivery records must be added, together with other data relating to things like the Fields a Farmer owns, Dues they have paid to KKFU etc., automated systems have been built to enable staff to enter data into multiple entities simulataneously using Rapid-data-entry-grids.
To understand thes more fully please consult the following links:
Farmer Deliveries Rapid Entry Grid
Dynamic Pascal-Scripting in Orixa: Adding a Resource to create Rapid-Entry-Grids in your App
The existance of these Rapid data-entry grids does not remove any of the usual functionality of edit-forms within KKSys. All records that hae been inserted automatically using a rapid-entry process can also be reviewed and updated in their edit-forms, and added to any reporting that management require.
Data-schema: full details of the data-fields and their purpose in the FarmFields data-table
Field- Name / Data-type |
Description / Purpose |
Possible Values |
Coding / Automation |
|---|---|---|---|
| ID (Primary Key) | Unique number which identifies each record. | Automatically set by Orixa, not under the control of users or developers. | |
| DateDone (Date) | Self explanitory | Entered by user | Default value: Current_Date |
| SocietiesID (Link-ID) | Links to the Societies table | Selected from list by User | Will default to the currently open Societies ID |
| FarmersID (Link-ID) | Links to the Farmers table | Selected from list by User | Will default to the currently open Farmers ID |
| Bags (Number) | ReadOnly, value generated by Orixa, currently hidden from view in the Edit Form | ||
| Kilos (Number) | Self explanitory | Any number value | Default value: 0 |
| UnitPrice (Currency Value) | Self explanitory | Any number value | Default value: 0 |
| Value (Currency Value) | ReadOnly, value generated by Orixa, using the current "cocoa price" in the system | ||
| DatePaid (Date) | Not currently in use, hidden from view in the edit form. | ||
| Paid (true/false) | ReadOnly, value generated by Orixa, sets to true when a "DatePaid" is entered. | True / false | |
| DateCreated (Timestamp) | Set to the exact date and time the record was first created. | Automatically set by Orixa, not under the control of users or developers. | |
| AuthorID (Integer) | Self explanitory | Automatically set by Orixa, not under the control of users or developers. | |
| Complete (true/false) | Tick this field to lock the record so further editing is restricted. | True / false | Default value: false |
| PurchaseNumber (Text) | ReadOnly, value generated by Orixa, currently hidden from view in the Edit Form. | Value generated by Orixa using the function "PurchaseNumber". This computes a unique value combining the SocietyStationMark, current date and a unique number. | |
| WaybillNumber (Text) | Self explanitory | Entered by user | |
| DPRSerial (Text) | Self explanitory | Entered by user |