Table & Field Reference 
Overview
Tables are the fundamental objects in any database, and are required to store and manipulate data. LicensePlating adds a number tables to Business Central to support the unique needs of logistics units.
Tables can be extended by developers where additional fields or columns are required.
Each table that comprises the LicensePlating application is listed below in alphabetical order.
Activities Cue
This table provides support for the FreshFocus role centre cues.
Table:71506586 DLGFF Activities Cue
| Caption | Type | Description | Release |
|---|---|---|---|
| Primary Key | Code | This field is used internally. | 1.0.0.0 |
| No. of Produce Items | Integer | Displays the number of items that are marked as produce items. | 1.0.0.0 |
| Value of Produce Agreements | Decimal | Displays the expected value of produce agreement lines with the status of open, approved or receiving. | 1.0.0.0 |
| No. Of Trade Documents | Integer | Displays the number of trade documents thare are open or approved. | 1.0.0.0 |
| Value of Produce Agreement Invoice | Decimal | Displays the value of produce agreement invoices not yet posted. | 1.0.0.0 |
| No. of Produce Agreement Lines | Integer | Displays a count of the produce agreements in the system. | 1.0.0.0 |
| Open Produce Agreement Lines | Integer | Displays a count of the open produce agreement lines. | 1.0.0.0 |
| Approved Produce Agreement Lines | Integer | Displays a count of the approved produce agreement lines. | 1.0.0.0 |
| Receiving Produce Agreement Lines | Integer | Displays a count of the produce agreement line that are in receiving. | 1.0.0.0 |
| Closed Produce Agreement Lines | Integer | Displays a count of the produce agreement line that closed (ie invoiced). | 1.0.0.0 |
| No. of Grading Orders | Integer | Displays a count of production orders that have a grading profile. | 1.0.0.0 |
| Released Grading Orders | Integer | Displays the number of released grading orders. | 1.0.0.0 |
| Finished Grading Orders | Integer | Displays the number of finished grading orders. | 1.0.0.0 |
| No. of Packing Orders | Integer | Displays the number of production order not associated with a grading profile. | 1.0.0.0 |
| Firm Planned Packing Orders | Integer | Displays the number of firm planned production orders not associated with a grading profile. | 1.0.0.0 |
| Released Packing Orders | Integer | Displays the number of released packing orders. | 1.0.0.0 |
| No. of Produce Agreement Invoices | Integer | Displays a count of the produce agreements invoice headers. | 1.0.0.0 |
| Open Produce Agreement Invoice | Integer | Displays the number of open produce agreement invoices. | 1.0.0.0 |
| Released Produce Agreement Invoice | Integer | Displays the number of releasded produce agreement invoices. | 1.0.0.0 |
| Pending Approval Produce Agreement Invoice | Integer | Displays the number of produce agreement invoices pending approval. | 1.0.0.0 |
| Prepared Produce Agreement Invoice | Integer | Displays the number of prepared produce agreement invoices. | 1.0.0.0 |