Table Reference 
Tables are the fundamental objects in any database, and are required to store and manipulate data. LicensePlating includes a number of additional tables, and extends Business Central tables to support the needs of logistics units.
LicensePlating is an extensible solution that enables developers to build upon the core features to satisfy specific customer or even local market requirements.
Tables
LicensePlating 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 center tiles. | 1.0.0.0 |
| 71507040 | C2P Overview Buffer | This table is used internally to display linked records during production processing | 1.0.0.0NEW |
| 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.0 |
| 71506990 | Grading Profile Header | Grading profiles define the criteria and relationship between produce inputs and produce outputs and are 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.0 |
| 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.0 |
| 71506692 | Lot No. Info. Register | The register is 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.0 |
| 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.0 |
| 71506725 | PA Inv. Ledg. Entry | Produce agreement invoice ledger entries 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.0 |
| 71506722 | PA Inv. Line Det. | The Produce agreement invoice lines show the detaled results of the produce agreement invoice and produce tracking. It acts as the audit trail for what will be posted when the retrn is finalised and posted. | 1.0.0.0 |
| 71506721 | PA Inv. Line | Use the produce agreement invoice lines to organise and calculate grower paybacks in connection with produce agreeements and trade documents. You can review the line details, refresh the calculations and drill down to the lot information. | 1.0.0.0 |
| 71507015 | PA Inv. Price | Produce agreement invoice prices determine for assembly, gradeout and packouts the prices that apply for given items and item properties. The prices are used on the produce invocing process to determine the gross payback amaount from which deductions and recharges are applied. | 1.0.0.0 |
| 71506723 | Posted PA Inv. Hdr. | Posted produce agreement invoices represent the finalisation of one or more produce agreements in connection with the vendor. Produce agreement invoices when posted 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.0 |
| 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.0 |
| 71506717 | Posting 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.0 |
| 71506716 | Produce Agreement Header | You create trade documents in connection with multiple produce agreement lines. When a trade 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.0 |
| 71506705 | Produce Agreement | The produce agreement worksheet is the organising focus for inbound receipts and acts as the starting point 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 71506709 | Produce Tracking Entry | Produce tracking entries are created when produce lots are transacted with. 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.0 |
| 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 occured. | 1.0.0.0 |
| 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.0 |
| 71506685 | Produce Variety | Varieties (or cultivars) differentiate produce according to 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.0 |
| 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.0 |
| 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.0 |
| 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.0 |
| 71506718 | Rules Buffer | This table is used internally during posting to assess which rules apply to produce tracking entries | 1.0.0.0NEW |
| 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.0 |
| 71506706 | Trade 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 user 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.0 |
| 71506707 | Trade Journal Line | Use produce tracking journals to post tracking 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'' is disabled in FreshFocus setup, you must use the get produce tracking action to return and post the tracking. | 1.0.0.0 |
| 71506715 | Trade Journal Template | There are several trade journal templates. Each journal template is represented by a dedicated page with particular functions and the fields that are required to support those functions, such as the trade cost and trade charge journal. 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.0 |
Table Extensions
LicensePlating also extends the standard Business Central tables to integrate functionality, these are listed below with links to the field reference for each table extension.
| Table Extension ID | Table Extension Name | Extends | Purpose | Release |
|---|---|---|---|---|
| 71506741 | DLGFF Assembly Header | Assembly Header | Adds support for item properties, and defines the output lot item properties to be built. | 1.0.0.0 |
| 71506740 | DLGFF Assembly Line | Assembly Line | Adds support for item properties, as filters for input lots to be consumed | 1.0.0.0 |
| 71506692 | DLGFF Entry Summary | Entry Summary | Adds support for produce item properties. | 1.0.0.0 |
| 71506681 | DLGFF Item | Item | Adds produce item flag, properties and property criteria | 1.0.0.0 |
| 71506684 | DLGFF Item Journal Line | Item Journal Line | Adds support for filtering lot selection by produce item properties, and reclassification of properties. | 1.0.0.0 |
| 71506746 | DLGFF Item Reference | Item Reference | Adds support for item references based on produce item properties. | 1.0.0.0 |
| 71506747 | DLGFF Item Templ. | Item Templ. | Adds item properties and property criteria for items based on a template. | 1.0.0.0 |
| 71506680 | DLGFF Lot No. Information | Lot No. Information | Adds support for produce item properties. | 1.0.0.0 |
| 71506745 | DLGFF Price Calculation Buffer | Price Calculation Buffer | Adds support for produce item properties, and ship-to pricing (see Price List line). | 1.0.0.0 |
| 71506744 | DLGFF Price List Line | Price List Line | Adds support for produce item properties, and ship-to pricing. | 1.0.0.0 |
| 71506687 | DLGFF Prod. Order Component | Prod. Order Component | Adds support for produce item property filtering in lot selection, and flags for grading order processing. | 1.0.0.0 |
| 71506685 | DLGFF Prod. Order Line | Prod. Order Line | Adds support for produce item properties, and flags for grading orders. | 1.0.0.0 |
| 71507015 | DLGFF Production BOM Header | Production BOM Header | REVISIT Adds support for produce item properties as default outputs. | 1.0.0.0 |
| 71507016 | DLGFF Production BOM Line | Production BOM Line | Adds support for default produce item property filtering in lot selection. | 1.0.0.0 |
| 71506990 | DLGFF Production Order | Production Order | Adds flags for commit to pack type orders, and grading default UOM. | 1.0.0.0 |
| 71506708 | DLGFF Purchase Header | Purchase Header | Adds fields to link the purchase header to produce agreements, and the related invoices and credits. | 1.0.0.0 |
| 71506705 | DLGFF Purchase Line | Purchase Line | Add support for default produce item properties in connection with produce agreements. | 1.0.0.0 |
| 71506693 | DLGFF Purchase Line Archive | Purchase Line Archive | REVISIT (Missing fields) Adds support for produce item properties. | 1.0.0.0 |
| 71506707 | DLGFF Purch. Cr. Memo Hdr | Purch. Cr. Memo Hdr | Adds flags for tracking related produce agreement invoices. | 1.0.0.0 |
| 71506694 | DLGFF Purch. Cr. Memo Line | Purch. Cr. Memo Line | Adds flags for tracking related produce agreement invoices. | 1.0.0.0 |
| 71506706 | DLGFF Purch. Inv. Header | Purch. Inv. Header | Adds flags for tracking related produce agreement invoices. | 1.0.0.0 |
| 71506691 | DLGFF Purch. Inv. Line | Purch. Inv. Line | Adds flags for tracking related produce agreement invoices. | 1.0.0.0 |
| 71506576 | DLGFF Purch. Rcpt. Line | Purch. Rcpt. Line | Adds flags for tracking related produce agreement invoices. | 1.0.0.0 |
| 71506682 | DLGFF Reservation Entry | Reservation Entry | Adds support for produce properties for active and posted item tracking. | 1.0.0.0 |
| 71506683 | DLGFF Sales Line | Sales Line | Add support for produce item property filtering in lot selection, and modified table relations for produce items. | 1.0.0.0 |
| 71506697 | DLGFF Sales Line Archive | Sales Line Archive | REVISIT Adds support for produce properties (see sales line). | 1.0.0.0 |
| 71506715 | DLGFF Source Code Setup | Source Code Setup | Adds support for item tracking journal types. | 1.0.0.0 |
| 71506690 | DLGFF Tracking Specification | Tracking Specification | Adds support for produce properties for active and posted item tracking. | 1.0.0.0 |
| 71506689 | DLGFF Transfer Line | Transfer Line | Add support for produce property filtering in lot selection. | 1.0.0.0 |
| 71506709 | DLGFF Vendor | Vendor | Adds support for produce agreement defaults. | 1.0.0.0 |
See Also
For more information about LicensePlating refer to these links