Table Reference

Tables are the fundamental objects in any database, and are required to store and manipulate data. FreshFocus includes a number of additional tables, and extends Business Central tables to support the unique needs of Fresh Produce.

Tables
Table Extensions

FreshFocus is a highly extensible solution that enables developers to build upon the core features to satisfy specific customer or even local market requirements.

Tables

FreshFocus adds new tables to Business Central when installed, these are listed below in alphabetical order with links to the field reference for each table.

Table ID	Name	Description	Release
71506586	Activities Cue	The activities cue contains references for the FreshFocus role centre tiles.	1.0.0.1
71507040	C2P Overview Buffer	This table is used internally to display linked records during production processing	1.0.0.1
71506585	FreshFocus Setup	You can configure global parameters that relate to FreshFocus. The various modules can be activated according to business need, trade and cost posting accounts can be configured, along with number series for the various documents and entries used by FreshFocus.	1.0.0.1
71506993	Grading Posting Buffer	This table is used internally to mass balance distribution when a grading order is finished	1.0.0.1
71506990	Grading Profile Header	A grading profiles defines the criteria and relationship between produce inputs and produce outputs and is used as the source number for grading orders. You define the tip lanes (inputs) and associated produce property filters, and then define gradeout lines and produce settings for the possible outputs including waste (if required). This information is then used to create the output lots as the result of the grading.	1.0.0.1
71506991	Grading Profile Line	Define the products that can be produced from the input lanes defined on the grading profile. You can specify one or more lanes and the associated produce properties for each lane. These are the properties that posted output lots will inherit on a grading order that uses this profile.	1.0.0.1
71506692	Lot No. Info. Register	The Lot No Information Register s a history of changes made to lot information properties. Any time a property is changed through the use of a reclassification journal, FreshFocus will create an entry of the previous values and the date it was changed.	1.0.0.1
71506720	PA Inv. Header	Produce agreement invoices represent the finalisation of one or more produce agreements in connection with the vendor. In this page you prepare the return, review the payback and then finalise it by posting the return. The produce agreement invoice contains the associated produce value entries, calculations and amounts that will be taken as deductions, costs or recharges in connection with those agreements.	1.0.0.1
71506722	PA Inv. Line Det.	The Produce agreement invoice lines show the detailed results of the produce agreement invoice and produce tracking. It acts as the audit trail for what will be posted when the return is finalised and posted.	1.0.0.1
71506721	PA Inv. Line	Use the produce agreement invoice lines to organise and calculate grower paybacks in connection with produce agreements and trade documents. You can review the line details, refresh the calculations and drill down to the lot information.	1.0.0.1
71507015	Production Payback Price	Production payback prices determine the prices that apply for assembly, gradeout and packouts given items and item properties. The prices are used by the produce invoicing process to determine the gross payback amount from which deductions and recharges are applied.	1.0.0.1
71506723	Posted PA Inv. Hdr.	Posted produce agreement invoices represent the finalisation of one or more produce agreements in connection with the vendor. Posted produce agreement invoices result in a purchase invoice (or credit) for the vendor. The posted produce agreement invoice contains the associated produce value entries, calculations and amounts that were taken as deductions, costs or recharges in connection with those agreements.	1.0.0.1
71506724	Posted PA Inv. Line	The posted produce agreement invoice lines show the end result of the produce agreement invoice process. You can review the line details and drill down to the lot information.	1.0.0.1
71506725	Posted PAI Line Detail	Posted produce agreement invoice line details are a permanent record of the posted produce agreement invoice, and contain the source data that was used in the calculations of the return. This enables you to always reconcile how a payback amount was determined for any produce agreement where a produce agreement invoice was posted.	1.0.0.1
71506717	Produce Rule Treatment	Posting rule treatments connect trade accounts with payback calculation methods to ensure that only relevant costs are charged for each produce agreement.	1.0.0.1
71506716	Produce Agreement Header	You create produce documents in connection with multiple produce agreement lines. When a produce document is changed to released status, the result is one or more produce agreement lines in the produce agreement worksheet, and an associated purchase order. The purpose is to provide an efficient way to group the resulting receipts together.	1.0.0.1
71506726	Produce Agreement Invoice Entry Relation	This table maintains the links to the agreement line detail and the related produce value entries	1.0.0.1
71506705	Produce Agreement	The produce agreement worksheet is the organising focus for inbound receipts and acts as the starting point for managing the way produce will be costed. The worksheet allows you to create multiple expected inbound produce lines and define for each line the various agreement terms, along with default produce specifications. The worksheet also supports status and controls around what can be changed, and what is mandatory according to the produce item used.	1.0.0.1
71506576	Produce Agreement Buffer	This temporary table is used internally by the program for analysis and reporting.	1.0.0.1
71506690	Produce Brand	Brands are used to differentiate produce lots by a marketing specification. Typically brands are used after produce is graded, and packed to denote that the item was packed for a specific customer or retail pack. There is flexibility in FreshFocus whether brands are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the brand in calculations	1.0.0.1
71506684	Produce Commodity	FreshFocus commodities are used to differentiate produce crops and help in organising grades, sizes and varieties according to the specific needs of the markets they are grown, processed, and traded in. There is flexibility in FreshFocus whether commodities are mandatory, fixed or flexible against items, though each grade, size and variety will require a commodity to be defined. Many of the trade account and produce agreement rules will utilise the commodity code in calculations.	1.0.0.1
71506683	Produce Crop	Crops are used to differentiate produce lots by type and provide a way of organising grades, sizes and varieties according to the specific needs of the markets they are grown, processed, and traded in. There is flexibility in FreshFocus whether crops are mandatory, fixed or flexible against items, though each grade, size and variety will require a crop to be defined. Many of the trade account and produce agreement rules will utilise the crop code in calculations	1.0.0.1
71506687	Produce Grade	Grades are used to differentiate produce lots by quality and are specific to a crop and commodity combination. There is flexibility in FreshFocus whether grades are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the produce grades in calculations.	1.0.0.1
71506706	Produce Journal Batch	It is possible to set up several journal batches under each journal template. That is, the same window can be used to display several different journals, each with its own name. This can be practical, for example, if every user needs to use their own journal. You can have the program number the journal batches automatically with each posting by including a number in the journal batch name.	1.0.0.1
71506707	Produce Journal Line	Use produce journals to post tracking and value entries to lots. In this journal you can define different batches, and perform actions to get tracking lines that have not been posted. If Auto. Post Produce Tracking and/or Auto. Post Produce Value is disabled in FreshFocus setup, you must use the Get Produce Tracking or value action(s) to return and post the entries.	1.0.0.1
71506715	Produce Journal Template	There are several trade journal templates. Each journal template is represented by a dedicated page with particular functions and fields that are required to support those functions, such as the trade tracking and trade value journals. Each journal template can be associated with one or more journal batches to provide an organising focus for users to post entries.	1.0.0.1
71506689	Produce Packaging	Packaging codes are used to differentiate produce lots by their form factor. Packaging (like brands) is typically used after produce is graded, and packed to denote that the item was packed in a particular way (eg cartons). FreshFocus packaging should not be confused with the item's unit of measure. There is flexibility whether packaging codes are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the packaging in calculations.	1.0.0.1
71506708	Produce Posting Register	The produce register is an audit trail of the tracking. A register is created each time a tracking journal is posted either manually or via the various documents posted in FreshFocus.	1.0.0.1
71506714	Produce Posting Rule	Produce posting rules provides for a flexible configuration and assignment of costs and recharges in connection with produce agreements. You can define various filters, apply effective dates, configure the basis rates for any trade accounts that have been setup, and apply these rules to different types of produce tracking entries that are created by the system.	1.0.0.1
71506688	Produce Processing Fclty	Facilities (or factories) are used to differentiate produce lots by where they are made. There is flexibility in FreshFocus whether facilities are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the facility code in calculations for example to add charges.	1.0.0.1
71506719	Produce Revenue Entry	Produce revenue entries are a record of the shipments and sales invoices that have been traced back to produce agreements via produce tracking entries. Produce revenue entries provide the basis for produce agreement invoice calculations. Posting can be automatic (see FreshFocus Setup) or manual via produce revenue journals, and will include returns receipts and credit memos.	1.0.0.1
71506686	Produce Size	Sizes are used to differentiate produce lots by an arbitrary group such as ''small'', or definitive size such as ''28mm'' and are specific to a crop and commodity combination. There is flexibility in FreshFocus whether sizes are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the produce size in calculations.	1.0.0.1
71506691	Produce Target Market	Target markets allow you to differentiate produce lots by the intended destination. Typically target markets are used after produce is graded, and packed to denote that the item was packed for a specific market or country. There is flexibility in FreshFocus whether markets are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the market in calculations.	1.0.0.1
71506711	Produce Tracing Buffer	Use this page to audit and trace the tracking entries that have been generated and applied to each other in FreshFocus. Within this page you can trace up (to origin) or down (to usage) for any lot that was created from a produce agreement line.	1.0.0.1
71506709	Produce Tracking Entry	Produce tracking entries are created when produce lots are transacted. The system records the binding lot-for-lot which is used to determine the share of trade costs and recharges to apply.	1.0.0.1
71506710	Produce Tracking Mapping	Produce tracking entries are associated or mapped to item ledger entries and provide a simple means of identifying for any entry what tracking an given item ledger entry is related to. This can be useful where a cost or entry seems to be misplaced, the tracking mapping will show the source entry and associated mapping that has occurred.	1.0.0.1
71506713	Produce Value Entry	Produce value entries are a record of the costs and charges that have been applied to the produce tracking entries. Produce value entries provide the basis for produce agreement invoice calculations. Posting can be automatic (see FreshFocus Setup) or manual via trade cost and charge journals.	1.0.0.1
71506685	Produce Variety	Varieties (or cultivars) differentiate produce according to the specific needs for pre/post harvest identification, including production processing. Varieties in FreshFocus are specific to a crop and commodity combination but there is flexibility in FreshFocus whether varieties are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the produce variety in calculations.	1.0.0.1
71506682	Producer Block	Producer blocks are used to differentiate produce lots by geography or farm and are specific to a producer and site combination. There is flexibility in FreshFocus whether blocks are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the producer block in calculations.	1.0.0.1
71506681	Producer Site	Producer sites are used to differentiate produce lots by geography or farm and are specific to a producer. There is flexibility in FreshFocus whether sites are mandatory, fixed or flexible against items. Many of the trade account and produce agreement rules will utilise the producer site in calculations.	1.0.0.1
71506680	Producer	Producers are used to differentiate produce lots by geography/farm and ownership. Producers can be related to a vendor for the purposes of processing produce agreement invoices. There is flexibility in FreshFocus whether producers are mandatory, fixed or flexible against items, however producer site, and block records require a producer. Many of the trade account and produce agreement rules will utilise the producer in calculations.	1.0.0.1
71506718	Rules Buffer	This table is used internally during posting to assess which rules apply to produce tracking entries	1.0.0.1
71506712	Trade Account	Trade accounts are used in connection with the produce posting rules to facilitate tracking costs against inventory lots, and are used in the preparation of produce agreement invoices. You specify default cost and charge account information which is then transferred to produce value entries	1.0.0.1

Table Extensions

FreshFocus also extends tables to integrate with standard Business Central functionality, these are listed below with links to the field reference for each table extension.

Table Extension ID	Table Extension Name	Extends	Purpose
71506741	DLGFF Assembly Header	Assembly Header	Adds support for item properties, and defines the output lot item properties to be built.
71506740	DLGFF Assembly Line	Assembly Line	Adds support for item properties, as filters for input lots to be consumed
71506692	DLGFF Entry Summary	Entry Summary	Adds support for produce item properties.
71506681	DLGFF Item	Item	Adds produce item flag, properties and property criteria
71506684	DLGFF Item Journal Line	Item Journal Line	Adds support for filtering lot selection by produce item properties, and reclassification of properties.
71506746	DLGFF Item Reference	Item Reference	Adds support for item references based on produce item properties.
71506747	DLGFF Item Templ.	Item Templ.	Adds item properties and property criteria for items based on a template.
71506680	DLGFF Lot No. Information	Lot No. Information	Adds support for produce item properties.
71506745	DLGFF Price Calculation Buffer	Price Calculation Buffer	Adds support for produce item properties, and ship-to pricing (see Price List line).
71506744	DLGFF Price List Line	Price List Line	Adds support for produce item properties, and ship-to pricing.
71506687	DLGFF Prod. Order Component	Prod. Order Component	Adds support for produce item property filtering in lot selection, and flags for grading order processing.
71506685	DLGFF Prod. Order Line	Prod. Order Line	Adds support for produce item properties, and flags for grading orders.
71507015	DLGFF Production BOM Header	Production BOM Header	Adds support for defining a nominated produce item nonumber for the production Bom. This enabled multiple BOMs to be used in connection with packout orders.
71507016	DLGFF Production BOM Line	Production BOM Line	Adds support for default produce item property filtering in lot selection.
71506990	DLGFF Production Order	Production Order	Adds flags for commit-to-pack type orders, and grading default UOM.
71506708	DLGFF Purchase Header	Purchase Header	Adds fields to link the purchase header to produce agreements, and the related invoices and credits.
71506705	DLGFF Purchase Line	Purchase Line	Add support for default produce item properties in connection with produce agreements.
71506693	DLGFF Purchase Line Archive	Purchase Line Archive	Adds support for produce item properties.
71506707	DLGFF Purch. Cr. Memo Header	Purch. Cr. Memo Header	Adds flags for tracking related produce agreement invoices.
71506694	DLGFF Purch. Cr. Memo Line	Purch. Cr. Memo Line	Adds flags for tracking related produce agreement invoices.
71506706	DLGFF Purch. Inv. Header	Purch. Inv. Header	Adds flags for tracking related produce agreement invoices.
71506691	DLGFF Purch. Inv. Line	Purch. Inv. Line	Adds flags for tracking related produce agreement invoices.
71506576	DLGFF Purch. Rcpt. Line	Purch. Rcpt. Line	Adds flags for tracking related produce agreement invoices.
71506682	DLGFF Reservation Entry	Reservation Entry	Adds support for produce properties for active and posted item tracking.
71506683	DLGFF Sales Line	Sales Line	Add support for produce item property filtering in lot selection, and modified table relations for produce items.
71506697	DLGFF Sales Line Archive	Sales Line Archive	Adds support for produce properties (see sales line).
71506690	DLGFF Tracking Specification	Tracking Specification	Adds support for produce properties for active and posted item tracking.
71506689	DLGFF Transfer Line	Transfer Line	Add support for produce property filtering in lot selection.