Table & Field Reference

Overview

Tables are the fundamental objects in any database, and are required to store and manipulate data. FreshFocus adds a number tables to Business Central to support the unique needs of fresh produce.

Tables can be extended by developers where additional fields or columns are required.

Each table that comprises the FreshFocus 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.1
No. of Produce Items	Integer	Displays the number of items that are marked as produce items.	1.0.0.1
Value of Produce Agreements	Decimal	Displays the expected value of produce agreement lines with the status of open, approved or receiving.	1.0.0.1
No. Of Produce Documents	Integer	Displays the number of produce documents that are open or approved.	1.0.0.1
Value of Produce Agreement Invoices	Decimal	Displays the value of produce agreement invoices not yet posted.	1.0.0.1
No. of Produce Agreements	Integer	Displays a count of the produce agreements in the system.	1.0.0.1
No. of Open Produce Agreements	Integer	Displays a count of the open produce agreement lines.	1.0.0.1
No. of Approved Produce Agreements	Integer	Displays a count of the approved produce agreement lines.	1.0.0.1
No. of Produce Agreements in Receiving	Integer	Displays a count of the produce agreement line that are in receiving.	1.0.0.1
No. of Closed Produce Agreements	Integer	Displays a count of the produce agreement line that closed (ie invoiced).	1.0.0.1
No. of Grading Orders	Integer	Displays a count of production orders that have a grading profile.	1.0.0.1
No. of Released Grading Orders	Integer	Displays the number of released grading orders.	1.0.0.1
No. of Finished Grading Orders	Integer	Displays the number of finished grading orders.	1.0.0.1
No. of Packing Orders	Integer	Displays the number of production order not associated with a grading profile.	1.0.0.1
No. of Firm Planned Packing Orders	Integer	Displays the number of firm planned production orders not associated with a grading profile.	1.0.0.1
No. of Released Packing Orders	Integer	Displays the number of released packing orders.	1.0.0.1
No. of Produce Agreement Invoices	Integer	Displays a count of the produce agreements invoice headers.	1.0.0.1
No. of Open Produce Agreement Invoices	Integer	Displays the number of open produce agreement invoices.	1.0.0.1
No. of Released Produce Agreement Invoices	Integer	Displays the number of released produce agreement invoices.	1.0.0.1
No. of Produce Agreement Invoices Pending Approval	Integer	Displays the number of produce agreement invoices pending approval.	1.0.0.1
No. of Prepared Produce Agreement Invoices	Integer	Displays the number of prepared produce agreement invoices.	1.0.0.1

C2P Overview Buffer

This table is used internally to display linked records during production processing.

Table:71507040 DLGFF C2P Overview Buffer

Caption	Type	Description	Release
Line No.	Integer	Specifies the line number of the buffer record.	1.0.0.1
Layer	Integer	Represents the layer of the C2P Buffer.	1.0.0.1
Event	Text	Specifies for the line a description of the event, such as tip in, or packout	1.0.0.1
Description	Text	Specifies a descripton that is displayed in the C2P Overview.	1.0.0.1
Lot No.	Code	Specifies the Lot no of the C2P Buffer line.	1.0.0.1
Quantity	Decimal	Specifies the quantity of the C2P Buffer line.	1.0.0.1
Order Status	Option	Specifies the production order status of the C2P Buffer line.	1.0.0.1
Order No	Code	Specifies the production order number of the C2P Buffer line.	1.0.0.1
Item No.	Code	Specifies the Item no of the C2P Buffer line.	1.0.0.1
Variant Code	Code	Specifies the variant of the C2P Buffer line.	1.0.0.1

FreshFocus Setup

This table contains the main FreshFocus setup configuration decisions.

Table:71506585 DLGFF FreshFocus Setup

Caption	Type	Description	Release
Primary Key	Code	This field is used internally by the program.	1.0.0.1
Auto. Post Produce Tracking	Boolean	Set this to have FreshFocus automatically create and post produce tracking entries in connection with produce agreements. You can manually post tracking entries from the produce tracking journal. The feature can be toggled based on preference and system performance.	1.0.0.1
Default Produce Agreement Invoice Nos.	Code	Specifies the code that will be used to assign numbers to unposted produce agreement invoices.	1.0.0.1
Default Posted Produce Agreement Invoice Nos.	Code	Specifies the code that will be used to assign numbers to posted produce agreement invoices.	1.0.0.1
Default Grading Profile Nos.	Code	Specifies the code that will be used to assign grading profile numbers in connection with FreshFocus production.	1.0.0.1
Default Produce Agreement Document Nos.	Code	Specifies the code that will be used to assign document numbers in connection with produce agreements.	1.0.0.1
Default Grading Order Nos.	Code	Specifies the code that will be used to assign grading order numbers in connection with FreshFocus production.	1.0.0.1
Produce Agreement Production Price Nos.	Code	Specifies the code that will be used to assign produce agreement production price numbers.	1.0.0.1
Default Produce Agreement Nos.	Code	Specifies the value of the Default Produce Agreement Nos field.	1.0.0.1
Grading Flushing Lot Nos.	Code	Specifies a no. series code that is used for interim lot number during grading flushing operations.	1.0.0.1
Auto. Post Produce Values	Boolean	Set this to have FreshFocus automatically create and post trade charges in connection with produce agreements. You can manually post trade charges from the Trade Charge Journal. The feature can be toggled based on preference and system performance	1.0.0.1
Auto. Adjust Processed Percentage	Boolean	Set this to have FreshFocus automatically calculate the percentage processed in connection with produce agreements. The feature can be toggled based on preference and system performance.	1.0.0.1
Auto. Post Produce Revenue	Boolean	Set this to have FreshFocus automatically create and post produce revenues in connection with produce agreements. You can manually post revenues from the Produce Revenue Journal. The feature can be toggled based on preference and system performance.	1.0.0.1
Auto-Post Purchase Invoices	Boolean	Specifies whether to automatically post purchase invoices or credit memos in connection with posting produce agreement invoices.	1.0.0.1
Produce Agreement Invoice Payback Credit Account	Code	Specifies the G/L Account No. to which produce agreement invoice (purchase) credit memos will be posted.	1.0.0.1
Produce Agreement Invoice Payback Debit Account	Code	Specifies the G/L Account No. to which produce agreement invoice (purchase) invoices will be posted.	1.0.0.1
Credit Reason Code	Code	Specify a reason code in connection with produce agreement invoices that result in a credit memo.	1.0.0.1
Produce Posting Rule Nos.	Code	Specifies the code that will be used to assign produce posting rule codes.	1.0.0.1
Negative Payback Trade Account	Code	Specifies the trade account to which negative payback 'deduction' amounts are to be posted	1.0.0.1
Sales Commission Entry Type	Option	Specifies the default treatment for payback methods that involve commission.	1.0.0.1
Sales Commission Trade Account	Code	Specifies the trade account that is used in produce agreement invoices when an agreement uses the payback method ''Sales Commission''	1.0.0.1
License Level	Option		1.0.0.1

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.

Table:71506990 DLGFF Grading Profile Header

Caption	Type	Description	Release
No.	Code	Specifies the number of grading profile, according to the specified number series (see FreshFocus Setup).	1.0.0.1
Description	Text	Specifies a description for the grading profile	1.0.0.1
Unit of Measure Code	Code	Specifies the default output unit of measure for grading orders.	1.0.0.1
Status	Option	Specifies the status of the grading profile. In order to use a profile the status must be certified	1.0.0.1
Creation Date	Date	Specifies the last date the profile was created.	1.0.0.1
Last Date Modified	Date	Specifies the last date modified.	1.0.0.1

Grading Profile Line

This table provides support for tip-in and grade-out definitions for grading profiles, including production lane definitions.

Table:71506991 DLGFF Grading Profile Line

Caption	Type	Description	Release
Grading Profile No.	Code	Specifies the number of the grading profile record.	1.0.0.1
Line No.	Integer	Specifies the line no. for the grading profile line. This field is used internally by the program.	1.0.0.1
Lane Code	Code	Specifies the lane code of the grading profile line. The field is mandatory, and can represent a virtual production line, or related to factory lane, or grading machine.	1.0.0.1
Item No.	Code	Specifies the item number of the grading profile line.	1.0.0.1
Description	Text	Specifies the description of the item or variant on the line.	1.0.0.1
Unit of Measure Code	Code	Specifies the unit of measure of the item or variant on the line.	1.0.0.1
Lane Type	Option	Specifies the line type of the profile line is grade-out.	1.0.0.1
Variant Code	Code	Specifies the variant code of the grading profile line.	1.0.0.1
Producer	Code	Specifies the unit of measure of the item on the line.	1.0.0.1
Producer Site	Code	Specifies the producer site code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Producer Block	Code	Specifies the producer block code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Crop	Code	Specifies the produce crop code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Commodity	Code	Specifies the produce commodity code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Variety	Code	Specifies the produce variety code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Size	Code	Specifies the produce size code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Grade	Code	Specifies the produce grade code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Processing Facility	Code	Specifies the processing facility code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Packaging	Code	Specifies the packaging code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Brand	Code	Specifies the brand code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Produce Target Market	Code	Specifies the target market code to use in connection with both input and output lots made from this grading profile line.	1.0.0.1
Record as Packout	Boolean	Specifies that the output of this grading lane will be treated as packout for produce agreement that are payback method packout.	1.0.0.1

Grading Posting Buffer

This table is used internally to mass balance distribution when a grading order is finished

Table:71506993 DLGFF Grading Posting Buffer

Caption	Type	Description	Release
Entry No.	Integer	Specifies a unique reference for the grading buffer record.	1.0.0.1
Order Line No.	Integer	Specifies the production order line no of the grading buffer.	1.0.0.1
Lane Code	Code	Specifies the lane code of the buffer record.	1.0.0.1
Item No.	Code	Specifies the item number of the buffer record.	1.0.0.1
Variant Code	Code	Specifies the variant code of the buffer record.	1.0.0.1
Lot No.	Code	Specifies the lot number of the buffer record.	1.0.0.1

Lot No Info Register

This table is a history of changes made to lot information properties via the reclassification journal.

Table:71506692 DLGFF Lot No. Info. Register

Caption	Type	Description	Release
No.	Integer	Specifies the register number of the lot properties change.	1.0.0.1
Item No.	Code	Specifies the item number of the lot that was re-classified.	1.0.0.1
Variant Code	Code	Specifies the variant code of the lot number that was re-classified.	1.0.0.1
Lot No.	Code	Specifies the lot number that was reclassified.	1.0.0.1
Item Ledger Entry No.	Integer	Specifies the related item ledger entry number.	1.0.0.1
ILE Type	Option	Specifies the item ledger entry type of the re-classification.	1.0.0.1
Creation Date	Date	Specifies the creation date of the lot register entry.	1.0.0.1
Creation Time	Time	Specifies the creation time of the lot register entry.	1.0.0.1
Created By User ID	Code	Specifies the user that created the lot register entry.	1.0.0.1
Expiration Date	Date	Specifies the new expiry date.	1.0.0.1
Quantity	Decimal	Specifies the lot quantity that was re-classified.	1.0.0.1
Producer	Code	Specifies the new producer code for the lot property register entry.	1.0.0.1
Producer Site	Code	Specifies the new producer site code for the lot property register entry.	1.0.0.1
Producer Block	Code	Specifies the new producer block code for the lot property register entry.	1.0.0.1
Produce Crop	Code	Specifies the new produce crop code for the lot property register entry.	1.0.0.1
Produce Commodity	Code	Specifies the new produce commodity code for the lot property register entry.	1.0.0.1
Produce Variety	Code	Specifies the new produce variety code for the lot property register entry.	1.0.0.1
Produce Size	Code	Specifies the new produce size code for the lot property register entry.	1.0.0.1
Produce Grade	Code	Specifies the new produce grade code for the lot property register entry.	1.0.0.1
Produce Packaging	Code	Specifies the new packaging code for the lot property register entry.	1.0.0.1
Produce Brand	Code	Specifies the new brand code for the lot property register entry.	1.0.0.1
Produce Processing Facility	Code	Specifies the new processing facility code for the lot property register entry.	1.0.0.1
Produce Target Market	Code	Specifies the new target market code for the lot property register entry.	1.0.0.1
Harvest Date	Date	Specifies the new harvest date of the lot property register entry.	1.0.0.1
Packing Date	Date	Specifies the new packing date of the lot property register entry.	1.0.0.1

PA Inv Header

The Produce Agreement Invoice Header is the organising focus for the invoice calculations involving produce agreements.

Table:71506720 DLGFF PA Inv. Header

Caption	Type	Description	Release
No.	Code	Specifies the unique number of the produce agreement invoice.	1.0.0.1
Vendor No.	Code	Specifies the vendor no. that this produce agreement invoice is for.	1.0.0.1
Vendor Name	Text	Specifies the name of the vendor for the posted produce agreement invoice.	1.0.0.1
Posting Date	Date	Specifies the posting date for the produce agreement invoice.	1.0.0.1
No. Series	Code	Specifies the Number series used to created the produce agreement invoice	1.0.0.1
Posted No. Series	Code	Specifies the number series that will be used when this produce agreement invoice is posted.	1.0.0.1
Status	Option	Specifies the status of the produce agreement invoice. Use the action bar to change the return's status.	1.0.0.1
Unposted Invoice No.	Code	Specifies what type of document was created when the return was posted. this field is relevant if the RCTI field is not checked.	1.0.0.1
Auto-Post Purchase Invoice	Boolean	Specifies if the posting the produce agreement invoice automatically posts the related purchase invoice and/or credit (if any). If not set a purchase invoice (or credit) will be created but must then be posted manually.	1.0.0.1
Unposted Credit Memo No.	Code	Specifies the document number that this produce agreement credit memo generated. This field is relevant if the RCTI field is not checked.	1.0.0.1
Posted Invoice No.	Code	Specifies the document number of the posted purchase invoice that was created.	1.0.0.1
Posted Credit Memo No.	Code	Specifies the document number of the posted purchase credit memo that was created.	1.0.0.1

PA Inv Line

The produce agreement invoice line is the organising focus for produce agreements that are in the process of being invoiced.

Table:71506721 DLGFF PA Inv. Line

Caption	Type	Description	Release
Document No.	Code	Specifies the produce agreement invoice number that the line relates to.	1.0.0.1
Line No.	Integer	Specifies the line number of the produce agreement invoice line.	1.0.0.1
Produce Agreement No.	Code	Specifies the produce agreement number for this produce agreement invoice line.	1.0.0.1
Payback Calculation	Option	Specifies the payback calculation on the produce agreement invoice line, this value determines how the payback is calculated.	1.0.0.1
Received Quantity	Decimal	Specifies the quantity that was received in connection with the produce agreement line.	1.0.0.1
Gross Payback (LCY)	Decimal	Specifies the gross payback amount calculated for the produce agreement invoice line. The agreement basis determines how this amount is derived, for example if the basis is commission then this amount would represent net sales value (sales less rebates taken), and is the amount from which commission, deductions and charges are taken.	1.0.0.1
Total Cost (LCY)	Decimal	Specifies the total cost amount calculated for the produce agreement invoice line. Costs are not involved in the produce agreement invoice payback amount, but are used to assist with determining overall profit for the produce agreement.	1.0.0.1
Total Recharge (LCY)	Decimal	Specifies the total recharge amounts calculated for the produce agreement invoice line. Recharges will be displayed on the produce agreement invoice (RCTI), and post according to the produce posting rules for the given charge.	1.0.0.1
Total Deductions (LCY)	Decimal	Specifies the total deduction amounts calculated for the produce agreement invoice line. Deductions are taken up against the gross return amount, and are not displayed on the produce agreement invoice (RCTI), as such they reduce the unit cost of the item when the RCTI is posted.	1.0.0.1
Total Sales Amount (LCY)	Decimal	Specifies the total sales value (net) calculated for the produce agreement invoice line. This amount is calculated from the lot traceability from the inbound lot to all outbound lots used on sales and will include rebates. This amount is the basis for commission based calculations.	1.0.0.1
Total Advanced Payments (LCY)	Decimal	Calculates the total advance payments made	1.0.0.1
Unit of Measure	Code	Specifies the unit of measure of the received quantity.	1.0.0.1
Item No.	Code	Specifies the item number that the produce agreement relates to.	1.0.0.1
Variant Code	Code	Specifies the item variant code that the produce agreement relates to.	1.0.0.1
Agreement Unit Price	Decimal	Specifies the agreement unit price of the produce agreement invoice Line.	1.0.0.1
Sales Commission	Decimal	Specifies the sales commission rate to apply to the grower produce agreement invoice line.	1.0.0.1
Produce Document No.	Code	Specifies the trade document number (if used) in connection with the produce agreement on the produce agreement invoice line.	1.0.0.1
Processed Percentage	Decimal	Specifies a calculated percentage of the produce agreement receipts that have been sold or traded.	1.0.0.1
Total Quantity Sold	Decimal	Specifies the total quantity calculated for the produce agreement invoice line. This amount is calculated from the lot traceability from the inbound lot to all outbound lots used on sales.	1.0.0.1

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.

Table:71506722 DLGFF PA Inv. Line Det.

Caption	Type	Description	Release
Produce Agreement Invoice No.	Code	Specifies the produce agreement invoice number that the line relates to.	1.0.0.1
Produce Agreement Invoice Line No.	Integer	Specifies the line number of the produce agreement invoice line.	1.0.0.1
Line No.	Integer	Specifies the line number of the produce agreement invoice line detail.	1.0.0.1
Produce Value Posting Type	Option	Specifies the line entry type for the produce agreement invoice detail line.	1.0.0.1
Trade Account	Code	Specifies the line entry type for the produce agreement invoice detail line.	1.0.0.1
Description	Text	Specifies the document number that originated this detail line.	1.0.0.1
Description 2	Text	Specifies the additional description of the produce agreement invoice line detail.	1.0.0.1
Unit Amount (LCY)	Decimal	Specifies the unit amount of the produce agreement invoice line detail in local currency.	1.0.0.1
Quantity	Decimal	Specifies the reference quantity of the produce agreement invoice line detail.	1.0.0.1
Unit Of Measure	Code	Specifies the unit of measure of the produce agreement invoice line detail.	1.0.0.1
Line Amount (LCY)	Decimal	Specifies the line amount of the produce agreement invoice line detail in local currency.	1.0.0.1
Item No.	Code	Specifies the reference item number of the produce agreement invoice line detail.	1.0.0.1
Variant Code	Code	Specifies the reference item variant number of the produce agreement invoice line detail.	1.0.0.1
Lot No.	Code	Specifies the reference lot number of the produce agreement invoice line detail.	1.0.0.1
Produce Posting Rule Code	Code	Specifies the related produce posting code of the produce agreement invoice line detail.	1.0.0.1
Produce Tracking Entry	Integer	Specifies the related produce tracking entry number of the produce agreement invoice line detail.	1.0.0.1
Produce Value Entry	Integer	Specifies the related produce value entry number of the produce agreement invoice line detail.	1.0.0.1
Produce Agreement No.	Code	Specifies the produce agreement number that the produce agreement invoice line detail relates to.	1.0.0.1
Purchase Line Type	Option	Specifies the charge line type to use in connection with the account no. Generally speaking a G/L Account type is specified.	1.0.0.1
Purchase Line Type No.	Code	Specifies the account number to use in connection with this produce agreement invoice line detail record.	1.0.0.1
Posting Date	Date	Specifies the posting date of the line, this field is inherited from the produce agreement invoice card.	1.0.0.1
Document No.	Code	Specifies the document number that originated this detail line.	1.0.0.1
System-Created Entry	Boolean	Specifies whether this line detail was system created. System created lines are not editable.	1.0.0.1
Price Code	Code	Specifies the produce agreement price code that was used to determine the unit amount field on the line.	1.0.0.1
Balancing Line	Boolean	Specifies the produce agreement line detail has been inserted as a balancing line (due to net return being negative).	1.0.0.1
Posted Advanced Payment Document No.	Code	Specifies the document number used in connection with an advance payment.	1.0.0.1
No. of Related Entries	Integer	Specifies the number of related produce value entries to this agreement line detail.	1.0.0.1

PA Inv Entry Relation

This table maintains the links to the agreement line detail and the related produce value entries.

Table:71506726 DLGFF PAI Entry Relation

Caption	Type	Description	Release
Allocation Type	Option	Species whether the allocation is open or posted.	1.0.0.1
PA Invoice No.	Code	Specifies the Produce Agreement Invoice Number of the entry	1.0.0.1
PA Invoice Line No.	Integer	Specifies the Produce Agreement Invoice Line Number of the entry	1.0.0.1
PA Invoice Detail Line	Integer	Specifies the Produce Agreement Invoice Detail Line Number of the entry	1.0.0.1
Produce Value Entry No.	Integer	Specifies the related Produce Value Entry.	1.0.0.1
Produce Revenue Entry No.	Integer	Specifies the related Produce Revenue Entry.	1.0.0.1

Production Payback Price

Production payback prices define the return prices to be used for assembly, grade-out and pack-out production.

Table:71507015 DLGFF Production Payback Price

Caption	Type	Description	Release
Code	Code	Specifies the code to used with this produce agreement production price. The number is defined in FreshFocus setup	1.0.0.1
Description	Text	Specifies the description that this produce agreement production price applies to.	1.0.0.1
Vendor No.	Code	Specifies the vendor number code that this produce agreement production price applies to.	1.0.0.1
Production Type	Option	Specifies the value of the production type that this produce agreement production price applies to.	1.0.0.1
Starting Date	Date	Specifies the starting date that this produce agreement production price applies to.	1.0.0.1
Ending Date	Date	Specifies the ending date that this produce agreement production price applies to.	1.0.0.1
Item No.	Code	Specifies the item number code that this produce agreement production price applies to.	1.0.0.1
Variant Code	Code	Specifies the variant code that this produce agreement production price applies to.	1.0.0.1
Location Code	Code	Specifies the location code that this produce agreement production price applies to.	1.0.0.1
Unit Price Per	Decimal	Specifies the unit price for this produce agreement production price.	1.0.0.1
Producer	Code	Specifies the producer code that this produce agreement production price applies to.	1.0.0.1
Producer Site	Code	Specifies the producer site code that this produce agreement production price applies to.	1.0.0.1
Producer Block	Code	Specifies the producer block code that this produce agreement production price applies to.	1.0.0.1
Produce Crop	Code	Specifies the crop code that this produce agreement production price applies to.	1.0.0.1
Produce Commodity	Code	Specifies the commodity code that this produce agreement production price applies to.	1.0.0.1
Produce Variety	Code	Specifies the produce variety that this produce agreement production price applies to.	1.0.0.1
Produce Size	Code	Specifies the produce size code that this produce agreement production price applies to.	1.0.0.1
Produce Grade	Code	Specifies the produce grade code that this produce agreement production price applies to.	1.0.0.1
Produce Processing Facility	Code	Specifies the processing facility code that this produce agreement production price applies to.	1.0.0.1
Produce Packaging	Code	Specifies the packaging code that this produce agreement production price applies to.	1.0.0.1
Produce Brand	Code	Specifies the brand code that this produce agreement production price applies to.	1.0.0.1
Produce Target Market	Code	Specifies the target market code that this produce agreement production price applies to.	1.0.0.1

Posted PA Inv Hdr

The Posted Produce Agreement Invoice Header is the organising focus for the invoice calculations involving posted produce agreements.

Table:71506723 DLGFF Posted PA Inv. Hdr.

Caption	Type	Description	Release
No.	Code	Specifies the unique number of the posted produce agreement invoice.	1.0.0.1
Vendor No.	Code	Specifies the vendor no. that this posted produce agreement invoice was for.	1.0.0.1
Vendor Name	Text	Specifies the name of the vendor for this posted produce agreement invoice.	1.0.0.1
Posting Date	Date	Specifies the posting date of the posted produce agreement invoice.	1.0.0.1
No. Series	Code	Specifies the number series used to created the unposted produce agreement invoice	1.0.0.1
Posted No. Series	Code	Specifies the number series that was used when this produce agreement invoice was posted.	1.0.0.1
Produce Agreement Invoice No.	Code	Specifies what type of document was created when the return was posted. this field is relevant if the RCTI field is not checked.	1.0.0.1
Posted Invoice No.	Code	Specifies the posted invoice number of the produce agreement invoice.	1.0.0.1
Posted Credit Memo No.	Code	Specifies the posted credit memo no for this produce agreement invoice.	1.0.0.1

Posted PA Inv Line

The posted produce agreement invoice line is the organising focus for produce agreements that have been posted.

Table:71506724 DLGFF Posted PA Inv. Line

Caption	Type	Description	Release
Document No.	Code	Specifies the posted produce agreement document number.	1.0.0.1
Line No.	Integer	Specifies the lin number of the posted produce agreement line.	1.0.0.1
Produce Agreement No.	Code	Specifies the produce agreement number for this produce agreement invoice line.	1.0.0.1
Payback Calculation	Option	Specifies the payback calculation on the produce agreement invoice line, this value determines how the payback was calculated.	1.0.0.1
Received Quantity	Decimal	Specifies the quantity that was received for this produce agreement line.	1.0.0.1
Gross Payback (LCY)	Decimal	Specifies the gross payback amount of the posted produce agreement invoice line.	1.0.0.1
Total Deductions (LCY)	Decimal	Specifies the total deductions taken for the posted produce agreement invoice line.	1.0.0.1
Total Recharge (LCY)	Decimal	Specifies the total cost amount calculated for the posted produce agreement invoice line. Costs are not involved in the produce agreement invoice payback amount, but are used to assist with determining overall profit for the produce agreement.	1.0.0.1
Total Cost (LCY)	Decimal	Specifies the gross return amount for the produce agreement invoice line. The agreement basis determines how this amount was derived, for example if the basis is commission then this amount would represent net sales value (sales less rebates taken), and is the amount from which commission, deductions and charges were taken.	1.0.0.1
Total Sales Amount (LCY)	Decimal	Specifies the sales amount for the posted produce agreement invoice line.	1.0.0.1
Total Advanced Payments (LCY)	Decimal	Calculates the total advance payments made	1.0.0.1
Total Quantity Sold	Decimal	Specifies the total quantity calculated for the produce agreement invoice line. This amount is calculated from the lot traceability from the inbound lot to all outbound lots used on sales.	1.0.0.1
Unit of Measure	Code	Specifies the total recharge amounts calculated for the posted produce agreement invoice line. Recharges are be displayed on the produce agreement invoice (RCTI), and were posted according to the produce posting rules for the given charge.	1.0.0.1
Item No.	Code	Specifies the item number that this posted produce agreement invoice line relates to.	1.0.0.1
Variant Code	Code	Specifies the item variant code that this posted produce agreement invoice line relates to.	1.0.0.1
Agreement Unit Price	Decimal	Specifies the agreement unit price of the produce agreement invoice Line.	1.0.0.1
Sales Commission	Decimal	Specifies the sales commission rate that was applied to the grower produce agreement invoice line.	1.0.0.1
Produce Document No.	Code	Specifies the produce document that this produce agreement relates to (if applicable).	1.0.0.1
Vendor No.	Code	Specifies the vendor number that the produce agreement was for.	1.0.0.1

Posted PA Inv 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.

Table:71506725 DLGFF Posted PAI Line Detail

Caption	Type	Description	Release
Posted Produce Agreement Invoice No.	Code	Specifies the line number of the posted produce agreement invoice that this entry applies to.	1.0.0.1
Posted Produce Agreement Inv. Line No.	Integer	Specifies the line number of the posted produce agreement invoice line that this entry applies to.	1.0.0.1
Line No.	Integer	Specifies the line number of the produce agreement invoice ledger entry.	1.0.0.1
Produce Value Posting Type	Option	Specifies the produce value posting type of the produce agreement invoice ledger entry.	1.0.0.1
Trade Account	Code	Specifies the trade account of the produce agreement invoice ledger entry.	1.0.0.1
Description	Text	Specifies the description of the produce agreement invoice ledger entry.	1.0.0.1
Description 2	Text	Specifies the additional description of the produce agreement invoice ledger entry.	1.0.0.1
Unit Amount (LCY)	Decimal	Specifies the unit amount of the produce agreement invoice ledger entry.	1.0.0.1
Quantity	Decimal	Specifies the reference quantity of the produce agreement invoice ledger entry. This quantity represents the unit quantity for the cost involved on the entry. It is derived from the item tracking entries.	1.0.0.1
Unit Of Measure	Code	Specifies the unit of measure of the produce agreement invoice ledger entry.	1.0.0.1
Line Amount (LCY)	Decimal	Specifies the line amount of the produce agreement invoice ledger entry.	1.0.0.1
Item No.	Code	Specifies the reference item number of the produce agreement invoice ledger entry. This is normally the item that was used on the produce agreement line.	1.0.0.1
Variant Code	Code	Specifies the reference item variant number of the produce agreement invoice ledger entry.	1.0.0.1
Lot No.	Code	Specifies the reference lot no. of the produce agreement invoice ledger entry.	1.0.0.1
Produce Posting Code	Code	Specifies the reference produce posting code of the produce agreement invoice ledger entry.	1.0.0.1
Produce Tracking Entry	Integer	Specifies the related produce tracking entry number of the produce agreement invoice ledger entry.	1.0.0.1
Produce Value Entry	Integer	Specifies the related produce value entry for this produce agreement invoice ledger entry.	1.0.0.1
Produce Agreement No.	Code	Specifies the produce agreement no that is related to this produce agreement invoice Ledger entry.	1.0.0.1
Purchase Line Type	Option	Specifies the line type of the produce agreement invoice ledger entry. This type is related to the account no used on the line, this will normally be a g/l account type.	1.0.0.1
Purchase Line Type No.	Code	Specifies the account no. of the produce agreement invoice ledger entry. This is the account to which amounts have been posted.	1.0.0.1
Posting Date	Date	Specifies the posting date of the produce agreement invoice ledger entry.	1.0.0.1
Document No.	Code	Specifies the value of the document no. such as the produce agreement number or purchase invoice number of the produce agreement invoice ledger entry.	1.0.0.1
Balancing Line	Boolean	Specifies that the ledger entry was the result of a balancing line inserted on the produce agreement invoice	1.0.0.1
No. of Related Entries	Integer	Specifies the number of related produce value or produce revneu entires that are connected with the line.	1.0.0.1
System-Created Entry	Boolean	Specifies whether this entry is system created or manually entered.	1.0.0.1
Price Code	Code	Specifies the production price code that was used for the payback on the line	1.0.0.1
Posted Advanced Payment Document No.	Code	Specifies the posted invoice number of an advance payment that has been processed for the line.	1.0.0.1

Produce Rule Treatment

Produce Posting Rule Treatments define how trade accounts affected a produce agreement invoice under different produce agreement payback methods.

Table:71506717 DLGFF Produce Rule Treatment

Caption	Type	Description	Release
Trade Account Code	Code	Specifies the trade account that this treatment applies to.	1.0.0.1
Posting Rule Code	Code	Specifies the posting rule code that this treatment applies to. If blank the treatment is a default for the trade account.	1.0.0.1
Payback Method	Enum	Specifies the payback calculation method that this treatment applies to.	1.0.0.1
Vendor No.	Code	Specify a vendor code if this treatment is for a specific vendor.	1.0.0.1
Produce Value Type	Option	Specifies for this treatment whether the posting rule is considered a cost, charge, or deduction.	1.0.0.1
Line Type	Option	Defines the type to use in connection with the Account No. Field	1.0.0.1
Account No.	Code	Specifies the Account to which charges are to apply.	1.0.0.1
Treatment ID	Integer	This field is used internally and system generated	1.0.0.1

Produce Agreement

Produce Agreements are the organising focus for inbound produce receipts including agreement terms and produce specifications.

Table:71506705 DLGFF Produce Agreement

Caption	Type	Description	Release
No.	Code	Specifies the produce agreement no of the worksheet line. The number is not editable and is automatically created and defined in the FreshFocus setup.	1.0.0.1
Document No.	Code	If the worksheet line is associated with a trade document, then the associated document number is shown here.	1.0.0.1
Vendor No.	Code	Specifies the vendor code to use in connection with this agreement line.	1.0.0.1
Payback Calculation	Option	Specifies the payback calculation to use in relation to this agreement line. Depending on the payback calculation chosen, certain fields will; no longer be editable and other fields will become mandatory.	1.0.0.1
Expected Payback Date	Date	Specifies date the produce agreement invoice is expected to occur. The field is for reference purposes only.	1.0.0.1
Expected Receipt Date	Date	Specifies expected receipt date that the produce on this agreement line will be received.	1.0.0.1
Item No.	Code	Specifies the produce item number that this agreement line is for. An agreement line can only relate to a single item. The default produce settings, and other flags will be transferred to the line.	1.0.0.1
Variant Code	Code	Specifies the item variant to use in connection with the agreement line.	1.0.0.1
Unit of Measure	Code	Specifies the item unit of measure that is to be received. This unit is used in conjunction with the quantity to determine the base quantity to receive. For more information, see item units of measure.	1.0.0.1
Expected Quantity	Decimal	Specifies the produce quantity for the agreement line. This quantity is in terms of the base unit of measure for the produce item.	1.0.0.1
Location Code	Code	Specifies the location to receive the produce into.	1.0.0.1
Expected Line Amount	Decimal	This is calculated based on the expected quantity and direct unit cost of the line.	1.0.0.1
Agreement Unit Price	Decimal	Specifies the agreed unit price of the produce in the local currency (LCY) of the agreement line. This field is can be used when the payback calculation method is ''Fixed Price''.	1.0.0.1
Sales Commission	Decimal	Specifies the sales commission in a whole decimal (ie for 10% enter 10). This field is only editable when the agreement Basis is ''agent'' and the payback calculation is ''Sales Commission.''	1.0.0.1
Status	Option	Specifies the status of the worksheet agreement line. The status can only be changed using the action menu.	1.0.0.1
Purchase Document Type	Option	Specifies the purchase document type that is created when the produce agreement is approved.	1.0.0.1
Purchase Document No.	Code	Specifies the purchase document No. that is created when the produce agreement is approved.	1.0.0.1
Purchase Line No.	Integer	Specifies the purchase line no. that this produce agreement is associated with. An agreement line can only be associated with a single purchase line.	1.0.0.1
Produce Agreement Invoice No.	Code	Specifies the related produce agreement invoice for this agreement line	1.0.0.1
Bin Code	Code	Specifies the location bin code that the produce with be received into. If the location does not require bins then this field is not used, see location settings.	1.0.0.1
Producer	Code	Specifies the producer code to use in connection with this agreement line.	1.0.0.1
Producer Site	Code	Specifies the producer site code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Producer Block	Code	Specifies the producer block code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Crop	Code	Specifies the produce crop code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Commodity	Code	Specifies the produce commodity code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Variety	Code	Specifies the produce variety code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Size	Code	Specifies the produce size code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Grade	Code	Specifies the produce grade code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Processing Facility	Code	Specifies the processing facility code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Packaging	Code	Specifies the packaging code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Brand	Code	Specifies the brand code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Produce Target Market	Code	Specifies the target market code for the agreement line. This information will be used to populate the lot no information, and depending on the produce item setting this field may be required, variable or fixed.	1.0.0.1
Harvest Date	Date	Specifies date the produce was harvested. This information will be used to populate the lot no information, and depending on the produce item setting this field may not be required.	1.0.0.1
Packing Date	Date	Specifies the date the produce was packed. This information will be used to populate the lot no information, and depending on the produce item setting this field may not be required.	1.0.0.1
Processed Percentage	Decimal	Calculates the percentage (in quantity) has been processed based on the tracking entries created for this agreement line.	1.0.0.1

Produce Agreement Header

A Produce Agreement Header is the organising focus for one or more produce agreements.

Table:71506716 DLGFF Produce Agreement Header

Caption	Type	Description	Release
Document No.	Code	Specifies a unique number that identifies the trade document. The number can be generated automatically from a number series (defined in FreshFocus Setup), or you can number each of them manually.	1.0.0.1
Vendor No.	Code	Specifies the related vendor number of the produce code used in this trade document.	1.0.0.1
Payback Calculation	Option	Specifies the way the produce is to be traded or purchased by default.	1.0.0.1
Expected Payback Date	Date	Specifies the date the produce agreement payback is due	1.0.0.1
Expected Receipt Date	Date	Specifies the Date that produce is expected to be received.	1.0.0.1
Location Code	Code	Specifies the location where produce is to be received by default.	1.0.0.1
Sales Commission	Decimal	Specify a commission percentage if the payback calculation is sales commission. For a 10% commission you would enter 10.	1.0.0.1
Status	Option	The status is updated by the system based on activities performed on the trade document such as receiving, or approval.	1.0.0.1
Purchase Document Type	Option	Specifies the related document type that this produce agreement header is related to	1.0.0.1
Purchase Document No.	Code	Specifies the related document number that this produce agreement header is related to.	1.0.0.1
Producer	Code	Specifies the producer code used for this trade document. This can be updated or changed provided the document is open or pending approval.	1.0.0.1

Produce Agreement Buffer

This temporary table is used internally by the program for analysis and reporting.

Table:71506576 DLGFF Produce Agreement Buffer

Caption	Type	Description	Release
Entry No.	Integer	Specifies the entry number of the buffer line.	1.0.0.1
Entry Type	Option	Specifies the type of entry to on the produce agreement buffer line.	1.0.0.1
Source	Integer	An integer that specifies the source query for the buffer line.	1.0.0.1
Vendor No.	Code	Specifies the Vendor number of the agreement.	1.0.0.1
Agreement No.	Code	Specifies the Produce Agreement Number.	1.0.0.1
Document No.	Code	Specifies the Document Number if the Agreement is connected with a produce document.	1.0.0.1
Status	Option	Specifies the produce agreement status.	1.0.0.1
Payback Calculation	Option	Specifies the payback calculation on the buffer line.	1.0.0.1
Agreement Unit Price	Decimal	Specifies the agreement unit price on the buffer line.	1.0.0.1
Sales Commission	Decimal	Specifies the commission rate on the buffer line.	1.0.0.1
Processed Percentage	Decimal	Specifies the processed percentage age the buffer line.	1.0.0.1
Sales Amount (Actual)	Decimal	Specifies the sales amount actual on the buffer line.	1.0.0.1
Sales Amount (Expected)	Decimal	Specifies the sales amount expected on the buffer line.	1.0.0.1
Related Lot Qty Sold	Decimal	Specifies the related lot qty sold on the buffer line.	1.0.0.1
Trade Account	Code	Specifies the trade account for the buffer line.	1.0.0.1
Line Amount	Decimal	Specifies the line amount of the buffer line.	1.0.0.1
Posted PA Invoice No.	Code	Specifies the posted pa invoice no  No. the buffer line.	1.0.0.1

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.

Table:71506690 DLGFF Produce Brand

Caption	Type	Description	Release
Code	Code	Specifies a unique code to identify a brand. The brand code is used in connection with the item card and lot information.	1.0.0.1
Description	Text	Specifies the description of the brand.	1.0.0.1

Produce Commodity

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.

Table:71506684 DLGFF Produce Commodity

Caption	Type	Description	Release
Crop Code	Code	Specifies the crop code to be used in connection with this commodity record.	1.0.0.1
Code	Code	Specifies a code to identify a commodity for this crop. The commodity code is used with lot information properties, and can be defaulted at the item level.	1.0.0.1
Description	Text	Specifies the description of the commodity for this combination of crop and commodity.	1.0.0.1

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.

Table:71506683 DLGFF Produce Crop

Caption	Type	Description	Release
Code	Code	Specifies a unique code to identify a crop. The crop code is used with lot information properties, and can be defaulted at the item level.	1.0.0.1
Description	Text	Specifies the description of the crop.	1.0.0.1

Produce Grade

Grades are used to differentiate produce lots by quality and are specific to a crop and commodity combination.

Table:71506687 DLGFF Produce Grade

Caption	Type	Description	Release
Code	Code	Specifies a code to identify the produce grade for this combination of commodity and crop. The grade code is used with lot information properties, and can be defaulted at the item level.	1.0.0.1
Description	Text	Specifies the Description of the produce grade for this combination of commodity and crop.	1.0.0.1
Crop Code	Code	Specifies the crop code to be used in connection with this produce grade record.	1.0.0.1
Commodity Code	Code	Specifies the commodity code to be used in connection with this produce grade record.	1.0.0.1

Produce Packaging

Packaging Packing is 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).

Table:71506689 DLGFF Produce Packaging

Caption	Type	Description	Release
Code	Code	Specifies a unique code to identify packaging. The packaging code is used in connection with items (as default) and lot information and describes the various forms in which an item can be supplied.	1.0.0.1
Description	Text	Specifies a description for the packaging.	1.0.0.1

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.

Table:71506708 DLGFF Produce Posting Register

Caption	Type	Description	Release
No.	Integer	Specifies the number of the involved entry or record, according to the specified number series.	1.0.0.1
Creation Date	Date	Specifies the date when the entries in the register were posted.	1.0.0.1
Creation Time	Time	Specifies the time when the entries in the register were posted.	1.0.0.1
User ID	Code	Specifies the ID of the user who posted the entry, to be used, for example, in the change log.	1.0.0.1
Batch Name	Code	Specifies the name of the journal batch that the entries were posted from.	1.0.0.1
Produce Entry Type	Option	Specifies the type of posting that was created such as tracking, cost or charge.	1.0.0.1
From Tracking Entry No.	Integer	Specifies the first tracking entry number in the register.	1.0.0.1
To Tracking Entry No.	Integer	Specifies the last tracking entry number in the register.	1.0.0.1
From Produce Value Entry No.	Integer	Specifies the first produce value entry number in the register.	1.0.0.1
To Produce Value Entry No.	Integer	Specifies the last produce value entry number in the register.	1.0.0.1
From Produce Revenue Entry No.	Integer	Specifies the first produce revenue entry number in the register.	1.0.0.1
To Produce Revenue Entry No.	Integer	Specifies the last produce revenue entry number in the register.	1.0.0.1

Produce Posting Rule

Produce posting rules provides for a flexible configuration and assignment of costs and recharges in connection with produce agreements.

Table: 71506714 DLGFF Produce Posting Rule

Caption	Type	Description	Release
Code	Code	Specifies the unique identifier for the produce posting rule. See No. Series in FreshFocus setup.	1.0.0.1
Movement Type	Option	Specifies the movement type that this produce posting rule applies to.	1.0.0.1
Movement Detail	Option	(optional) Specifies a detail movement type for the rule. Using this field you can narrow down to an entry type for the rule.	1.0.0.1
Trade Account Code	Code	Specifies the trade account that this produce posting rule applies to.	1.0.0.1
Parent Rule Code	Code	Specifies the another posting rule code that is a parent to this record. When the rules are assessed the child rules are selected if they are a better match.	1.0.0.1
Description	Text	Specifies a description for the produce posting rule, the trade account number description will be used as the default.	1.0.0.1
Item No.	Code	(optional) Specifies item no. that this rule applies to.	1.0.0.1
Variant Code	Code	(optional) Specifies the item variant code that this rule applies to.	1.0.0.1
Location Code	Code	(optional) Specifies the location code that this rule applies to.	1.0.0.1
Bin Code	Code	(optional) Specifies the bin code that this rule applies to.	1.0.0.1
Date From	Date	(optional) Specifies the date from which the produce posting rule applies. Produce tracking entries made on or after this date will be considered by the rule.	1.0.0.1
Date To	Date	(optional) Specifies the date when the produce posting rule expires. Produce tracking entries made on or before this date will be considered by the rule.	1.0.0.1
Calculation Formula	Option	Specifies how the rate is to be applied against the posting rule. It is important that the unit cost and this calculation formula are setup correctly. For example if ''weight (related UOM)'' is selected, then ensure that the item's base unit of measure has a weight defined.	1.0.0.1
Rate	Decimal	The value in this field specifies the rate that applies to the specific rule and its filters. The unit of this field correlates to the Calculation Formula.	1.0.0.1
Active	Boolean	Set this field to activate the rule.	1.0.0.1
Retrospective Ignore Point	Integer	This field is used internally by the program, and is set when a rule is activated. Tracking entries greater than the last entry defined by this field will be considered. When used in conjunction with the starting date, it can ensure value entries are created if processing has occurred but a posting rule was not created in time.	1.0.0.1
Producer	Code	(optional) Specifies the producer code that this rule applies to.	1.0.0.1
Producer Site	Code	(optional) Specifies the producer site that this rule applies to. This would normally be used in conjunction with the producer code to narrow down the rule.	1.0.0.1
Producer Block	Code	(optional) Specifies the producer block that this rule applies to. This would normally be used in conjunction with the producer and site to narrow down the rule.	1.0.0.1
Produce Crop	Code	(optional) Specifies the produce crop that this rule applies to.	1.0.0.1
Produce Commodity	Code	(optional) Specifies the produce commodity that this rule applies to. This would normally be used in conjunction with the crop code to narrow down the rule.	1.0.0.1
Produce Variety	Code	(optional) Specifies the produce variety that this rule applies to. This would normally be used in conjunction with the crop and commodity code to narrow down the rule.	1.0.0.1
Produce Size	Code	(optional) Specifies produce size that this rule applies to.	1.0.0.1
Produce Grade	Code	(optional) Specifies the produce grade that this rule applies to.	1.0.0.1
Produce Processing Facility	Code	(optional) Specifies processing facility that this rule applies to. This would normally be used in conjunction with tracking entry types that relate to production.	1.0.0.1
Produce Packaging	Code	(optional) Specifies the packing code that this rule applies to.	1.0.0.1
Produce Brand	Code	(optional) Specifies produce brand code that this rule applies to.	1.0.0.1
Produce Target Market	Code	(optional) Specifies the target market code that this rule applies to. This can apply to both inbound and outbound tracking entries.	1.0.0.1
No. of Treatments	Integer	Shows how many active treatments are been defined for the current rule	1.0.0.1

Produce Processing Fclty

Produce Processing Facilities (or factories) are used to differentiate produce lots by where they are made.

Table:71506688 DLGFF Produce Processing Fclty

Caption	Type	Description	Release
Code	Code	Specifies a unique code to identify a processing facility. The facility code is used with lot information properties, and can be defaulted at the item level.	1.0.0.1
Description	Text	Specifies the description for the facility record.	1.0.0.1

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.

Table:71506686 DLGFF Produce Size

Caption	Type	Description	Release
Crop Code	Code	Specifies the crop code to be used in connection with this produce size record.	1.0.0.1
Commodity Code	Code	Specifies the commodity code to be used in connection with this produce size record.	1.0.0.1
Crop Code	Code	Specifies a code to identify the produce size or this combination of crop and commodity. The produce size code is used with lot information properties and can be defaulted at the item level.	1.0.0.1
Description	Text	Specifies the description of the produce size for this combination of crop and commodity.	1.0.0.1

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.

Table:71506691 DLGFF Produce Target Market

Caption	Type	Description	Release
Code	Code	Specifies a unique code to identify a target market. The target market code is used with lot information properties, and can be defaulted at the item level.	1.0.0.1
Description	Text	Specifies the description of the target market.	1.0.0.1

Produce Tracing Buffer

The Produce Tracing Buffer is a temporary table used when produce tracing is performed and contains details of the lot-for-lot binding and cost shares.

Table:71506711 DLGFF Produce Tracing Buffer

Caption	Type	Description	Release
Line No.	Integer	Specifies the unique entry for the tracing buffer record	1.0.0.1
Parent Entry No.	Integer	Specifies the buffer record entry of the antecedent buffer record	1.0.0.1
Layer	Integer	Specifies the layer or level of the buffer record, starting at 0 (root level)	1.0.0.1
Item No.	Code	Specifies the Item No. of the traced item.	1.0.0.1
Variant Code	Code	Specifies the variant code of the traced item.	1.0.0.1
Lot No.	Code	Specifies the Lot No. of the traced item.	1.0.0.1
Parent Item No.	Code	Specifies the item no that is associated with the traced item's antecedent lot no.	1.0.0.1
Parent Variant Code	Code	Specifies the variant code is associated with the traced item's antecedent lot no.	1.0.0.1
Parent Lot No.	Code	Specifies the lot number that was derived from item's antecedent lot no.	1.0.0.1
Root Item No.	Code	Specifies the item no that is associated with the produce agreement's originating lot no.	1.0.0.1
Root Variant Code	Code	Specifies the variant code that is associated with the produce agreement's originating lot no.	1.0.0.1
Root Lot No.	Code	Specifies the lot no of the produce agreement.	1.0.0.1
Agreement No.	Code	Specifies the produce agreement number that is the result of tracing.	1.0.0.1
Quantity	Decimal	Specifies the share of the lot in that lots base unit of measure that is invested to the produce agreement that has been traced.	1.0.0.1
Parent Quantity	Decimal	Specifies the share of the associated lot number that is at the next level up in the hierarchy.	1.0.0.1
Root Quantity	Decimal	Specifies the quantity share of the traced lot or agreement that has been applied on each line in the hierarchy.	1.0.0.1
Root Factor	Decimal	Specifies the percentage share of the traced lot or agreement that has been applied on each line in the hierarchy.	1.0.0.1
Inventory	Decimal	Calculates the remaining inventory on hand for the specified lot number.	1.0.0.1
Sold Quantity	Decimal	Calculates the sold quantity for the specified lot number.	1.0.0.1

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 produce costs and recharges to apply.

Table:71506709 DLGFF Produce Tracking Entry

Caption	Type	Description	Release
Entry No.	Integer	Specifies the tracking ledger entry no.	1.0.0.1
Posting Date	Date	Specifies the posting date for the entry.	1.0.0.1
Document No.	Code	Specifies the document number on the entry that is associated with the document type.	1.0.0.1
Produce Lot Movement	Option	Specifies the type of movement for the tracking entry. The movements here are associated with the produce posting rule movement types.	1.0.0.1
Lot Movement Detail	Option	Specifies the detail movement type that was used for the tracking entry. The movements here are associated with the produce posting rule movement detail types.	1.0.0.1
Item No.	Code	Specifies item no. of the entry.	1.0.0.1
Variant Code	Code	Specifies the variant of the item on the entry.	1.0.0.1
Lot No.	Code	Specifies the lot number that the tracking ledger entry applies to.	1.0.0.1
Produce Agreement No.	Code	Specifies the produce agreement number that this tracking entry applies to.	1.0.0.1
Location Code	Code	Specifies location code that was used on the document or journal.	1.0.0.1
Bin Code	Code	Specifies the bin code of the tracking entry.	1.0.0.1
Unit of Measure Code	Code	Specifies the unit of measure that was used on the document or journal.	1.0.0.1
Quantity	Decimal	Specifies the number of units of the item in the produce tracking entry.	1.0.0.1
Quantity (Base)	Decimal	Specifies the number of base units of the item in the produce tracking entry.	1.0.0.1
Source Transaction	Option	Specifies which type of source transaction that the entry was created from.	1.0.0.1
Parent Item No.	Code	Specifies the parent item number that this entry was applied from.	1.0.0.1
Parent Variant Code	Code	Specifies the parent item variant that this entry was applied from.	1.0.0.1
Parent Lot No.	Code	Specifies the parent lot no. that this entry was applied from.	1.0.0.1
Parent Quantity	Decimal	Specifies the number of units of the parent item applies to this entry.	1.0.0.1
Positive	Boolean	Specifies true if the quantity on the entry is greater than 0.	1.0.0.1
Source Order Type	Option	Specifies the source document type of the entry such as assembly production or transfer.	1.0.0.1
Source Order No.	Code	Specifies the source order no. of the entry.	1.0.0.1
Source Order Line No.	Integer	Specifies the line no. from the source order of the entry.	1.0.0.1
Document Type	Option	Specifies the document type from the source transaction. see Document No.	1.0.0.1
Document Line No.	Integer	Specifies the document line no. associated with the document no. on the entry.	1.0.0.1
Item Ledger Entry No.	Integer	Specifies the related item ledger entry for this tracking.	1.0.0.1
User Captured	Code	Specifies the user id that created the tracking entry. If auto-post is enabled this will be the user who processed a document that created the tracking.	1.0.0.1
Date Captured	Date	Specifies the system date when the tracking entry was created.	1.0.0.1
Time Captured	Time	Specifies the system time when the tracking entry was created.	1.0.0.1
Reason Code	Code	Specifies the reason code that was used on the journal line that created the tracking entry.	1.0.0.1

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.

Table:71506710 DLGFF Produce Tracking Mapping

Caption	Type	Description	Release
Item Ledger Entry No.	Integer	Specifies an item ledger entry that has tracking.	1.0.0.1
Produce Tracking Entry No.	Integer	Specifies a related produce tracking entry no for this item ledger entry.	1.0.0.1

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.

Table:71506719 DLGFF Produce Revenue Entry

Caption	Type	Description	Release
Entry No.	Integer	Specifies the unique entry number of the record.	1.0.0.1
Produce Tracking Entry No.	Integer	Specifies the related produce tracking entry that this revenue entry relates to	1.0.0.1
Item Ledger Entry No.	Integer	Specifies the related item ledger entry that this revenue value entry relates to.	1.0.0.1
Completely Invoiced	Boolean	Specifies whether the revenue entry is completely invoiced.	1.0.0.1
Posting Date	Date	Specifies the posting date of the produce revenue entry.	1.0.0.1
Document No.	Code	Specifies the document number that this entry relates to.	1.0.0.1
Description	Text	Specifies the description used on the revenue entry	1.0.0.1
Produce Agreement No.	Code	Specifies the related produce agreement that this entry applies to.	1.0.0.1
Item No.	Code	Specifies the item number that this revenue entry relates to	1.0.0.1
Variant Code	Code	Specifies the item variant that this revenue entry relates to.	1.0.0.1
Lot No.	Code	Specifies the lot number that this revenue entry relates to.	1.0.0.1
Unit of Measure	Code	Specifies the unit of measure of the quantity.	1.0.0.1
Quantity	Decimal	Specifies the quantity of the source document line.	1.0.0.1
Quantity Invoiced	Decimal	Specifies the invoiced quantity of the source document line.	1.0.0.1
Unit Sales Price	Decimal	Specifies the unit price used on the source document.	1.0.0.1
Sales Amount (Expected)	Decimal	Specifies the value of an shipment or return that has not been invoiced.	1.0.0.1
Sales Amount (Actual)	Decimal	Specifies the value of an shipment or return that has been invoiced or credited.	1.0.0.1
Cost Share	Decimal	Specifies the percentage of the sale, shipment, return or credit quantity in terms of the related produce agreement number that this entry applies to.	1.0.0.1
Root Lot No. Quantity	Decimal	Specifies the quantity of the sale, shipment, return or credit in terms of the inbound lot no.'s base unit of measure.	1.0.0.1
Root Item No.	Code	Specifies the item number that is related to the produce agreement for this revenue entry.	1.0.0.1
Root Variant Code	Code	Specifies the variant code that is related to the produce agreement for this revenue entry.	1.0.0.1
Root Lot No.	Code	Specifies the lot number that is related to the produce agreement on this revenue entry.	1.0.0.1

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.

Table:71506713 DLGFF Produce Value Entry

Caption	Type	Description	Release
Entry No.	Integer	Specifies the unique entry number of the record.	1.0.0.1
Trade Account Code	Code	Specifies the trade account no. that is associated with the produce posting code.	1.0.0.1
Produce Tracking Entry	Integer	Specifies the tracking entry that this value entry is related to.	1.0.0.1
Posting Date	Date	Specifies the posting date of the produce value entry.	1.0.0.1
Item No.	Code	Specifies the item number that this produce value entry relates to.	1.0.0.1
Variant Code	Code	Specifies the item variant that this value entry relates to.	1.0.0.1
Lot No.	Code	Specifies the lot number that this tracking entry relates to.	1.0.0.1
Description	Text	Specifies the description used on the value entry.	1.0.0.1
Calculation Basis Quantity	Decimal	Specifies the quantity that the produce posting rule used as a basis for the calculations. This was used in conjunction with the cost share field to determine the charge that applies on the value entry.	1.0.0.1
Rate	Decimal	Specifies the rate that applies from the produce posting rule.	1.0.0.1
Line Amount (LCY)	Decimal	Specifies the amount that was posted and is derived from multiplying the calculation basis quantity, cost share and rate fields.	1.0.0.1
Produce Posting Rule Code	Code	Specifies the produce posting rule code that was used when creating the value entry.	1.0.0.1
Produce Agreement No.	Code	Specifies the related produce agreement that this entry applies to.	1.0.0.1
Cost Share	Decimal	Specifies the percentage of the produce posting rule basis quantity in terms of the related produce agreement number that this entry applies to.	1.0.0.1
Location Code	Code	Specifies the location code that this entry applies to.	1.0.0.1
Bin Code	Code	Specifies the bin code that this entry applies to.	1.0.0.1
Root Item No.	Code	Specifies the item number that is related to the produce agreement for this value entry.	1.0.0.1
Root Variant Code	Code	Specifies the variant code that is related to the produce agreement for this value entry.	1.0.0.1
Root Lot No.	Code	Specifies the lot number that is related to the produce agreement on this value entry.	1.0.0.1
System-Created Entry	Boolean	This field is used internally by the program	1.0.0.1
User ID	Code	Specifies the User ID who created the produce value entries, this can be different to the user who created the original source documents if auto posting is disabled. See FreshFocus setup.	1.0.0.1
Line Type	Option	Specifies the line type used in connection with the produce posting rule on this entry.	1.0.0.1
Account No.	Code	Specifies the Account No. used in connection with the produce posting setup rule on this entry. This is the account to which costs will be posted.	1.0.0.1
Document No.	Code	Specifies the document number that this entry relates to.	1.0.0.1
System Date/Time	Date	Specifies the system date and time the value entry was created.	1.0.0.1
Reason Code	Code	Specifies the reason code that was used on the journal line that created this entry.	1.0.0.1
Produce Value Type	Option	Specifies the posting type used in connection with the produce posting code.	1.0.0.1
Produce Rule Treatment ID	Integer	This field is used internally by the program and identifies the unique treatment that was applied to the posting rule.	1.0.0.1

Produce Variety

Varieties (or cultivars) differentiate produce according to to the specific needs for pre/post harvest identification, including production processing.

Table:71506685 DLGFF Produce Variety

Caption	Type	Description	Release
Crop Code	Code	Specifies the crop code to be used in connection with this produce variety record.	1.0.0.1
Commodity Code	Code	Specifies the commodity code to be used in connection with this produce variety record.	1.0.0.1
Code	Code	Specifies a code to identify a produce variety for this combination of crop and commodity. The produce variety is used with lot information properties and can be defaulted at the item level.	1.0.0.1
Description	Text	Specifies the description of the produce variety for this combination of crop and commodity.	1.0.0.1

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.

Table:71506680 DLGFF Producer

Caption	Type	Description	Release
Code	Code	Specifies a unique code to identify a producer. The producer code is used with lot information properties, and can have a many-to-one relationship with the vendor.	1.0.0.1
Producer Name	Text	Specifies name of the producer.	1.0.0.1
Default Vendor No.	Code	Specifies the related vendor no. to be used in connection with produce agreement invoices for this producer.	1.0.0.1

Producer Block

Producer blocks are used to differentiate produce lots by geography or farm and are specific to a producer and site combination.

Table:71506682 DLGFF Producer Block

Caption	Type	Description	Release
Producer Code	Code	Specifies the producer code to be used in connection with this block record.	1.0.0.1
Site Code	Code	Specifies the site code to be used in connection with this block record.	1.0.0.1
Block Code	Code	Specifies a code to identify the block for this combination of producer and site. The block code is used with lot information properties and can be defaulted at the item level.	1.0.0.1
Block Name	Text	Specifies the name of the block for this combination of producer, site and block.	1.0.0.1
Geo Location	Text	Specifies the Geo Location coordinates for the block record. This information is for reference purposes only and can take any valid form (eg google earth, lat./long. coordinates).	1.0.0.1

Producer Site

Producer sites are used to differentiate produce lots by geography or farm and are specific to a producer.

Table:71506681 DLGFF Producer Site

Caption	Type	Description	Release
Producer Code	Code	Specifies the producer code to be used in connection with this site record.	1.0.0.1
Site Code	Code	Specifies a code to identify the site for this producer. The site code is used with lot information properties, and can be defaulted at the item level.	1.0.0.1
Site Name	Text	Specifies the name of the site for this combination of producer and site.	1.0.0.1

Produce Journal Batch

A Produce Journal Batch is the organising focus for Produce Journal lines. Each batch is defined by a type inherited from the Produce Journal Template.

Table:71506706 DLGFF Produce Journal Batch

Caption	Type	Description	Release
Journal Template Name	Code	Specifies the journal template that the journal batch will use.	1.0.0.1
Name	Code	Specifies a name for the journal batch	1.0.0.1
Description	Text	Specifies a description for the journal batch	1.0.0.1
No. Series	Code	Specifies the code for the number series that will be used to new document numbers in produce journals.	1.0.0.1
Posting No. Series	Code	Specifies the number series code used to assign document numbers to tracking entries that are posted from this journal batch.	1.0.0.1
Reason Code	Code	Specifies a reason code to use in connection with trade journals that use this batch.	1.0.0.1
Produce Entry Type	Option	Specifies the type of journal batch	1.0.0.1

Produce Journal Line

Produce Journal lines are used to assign tracking, costs and charges in connection with produce agreements and lot numbers.

Table:71506707 DLGFF Produce Journal Line

Caption	Type	Description	Release
Journal Template Name	Code	Specifies the Journal Template.	1.0.0.1
Journal Batch Name	Code	Specifies the batch name for the journal line	1.0.0.1
Line No.	Integer	Specifies the line number of the journal.	1.0.0.1
Trade Account Code	Code	Specifies the trade account code to use in connection with the journal line.	1.0.0.1
Produce Posting Rule Code	Code	Specifies the value of the produce posting rule code to use in connection with the journal line.	1.0.0.1
Produce Entry Type	Option	Specifies the value of the Produce Entry Type - this value is inherited from the journal template and batch used.	1.0.0.1
Produce Value Posting Type	Option	Specifies the produce posting type to use in connection with the journal. The value is derived from the produce posting rule used.	1.0.0.1
Document No.	Code	Specifies the document number for the journal line.	1.0.0.1
Posting Date	Date	Specifies the posting date for the entry.	1.0.0.1
Item No.	Code	Specifies the number of the item on the journal line.	1.0.0.1
Variant Code	Code	Specifies the variant code of the item on the journal line.	1.0.0.1
Lot No.	Code	Specifies the lot no. that the journal line applies to.	1.0.0.1
Description	Text	Specifies the description for the journal line.	1.0.0.1
Calculation Basis Quantity	Decimal	Specifies the quantity to be assessed for the given produce posting rule	1.0.0.1
Cost Share	Decimal	Specifies the percentage of the produce posting rule basis quantity in terms of the related produce agreement number that this entry applies to.	1.0.0.1
Rate	Decimal	Specifies the unit value of the charge cost or revenue to be applied. The value must be a positive decimal and expressed in base units of the item quantity. Validating the rate will calculate the line amount field.	1.0.0.1
Line Amount LCY	Decimal	Specifies the amount to be posted. This amount is derived from multiplying the calculation basis quantity, cost share and rate fields.	1.0.0.1
Location Code	Code	Specifies the location code to use in connection with the journal line.	1.0.0.1
Bin Code	Code	Specifies the bin code to use in connection with the journal line.	1.0.0.1
Line Type	Option	Specifies the charge line type to use in connection with the journal line. The value is defaulted from the Trade Account Code.	1.0.0.1
Account No.	Code	Specifies the Account No. of the journal line. The value is defaulted from the Trade Account code and type used on the line.	1.0.0.1
Tracking Entry No.	Integer	Specifies the tracking entry no. that the journal record applies to.	1.0.0.1
Produce Agreement No.	Code	Specifies the value of the produce agreement number that the journal line applies to.	1.0.0.1
Item Ledger Entry No.	Integer	Specifies the related item ledger entry for this trade journal line	1.0.0.1
Reason Code	Code	Specifies the reason code, a supplementary source code that enables you to trace the entry.	1.0.0.1
System-Created Entry	Boolean	This field is used internally by the program.	1.0.0.1
Vendor No.	Code	Specifies the value of the Vendor Number to use in connection with the journal line	1.0.0.1
Source Code	Code	Specifies the source code for the journal line. This value is defined by the journal template type.	1.0.0.1
Produce Rule Treatment ID	Integer	This field is used internally by the program and uniquely identified the treatment ID that is being used for the produce posting rule.	1.0.0.1
Root Item No.		Specifies the item number of the root lot no on the journal line.	1.0.0.1
Root Variant Code		Specifies the item variant code of the root lot no on the journal line.	1.0.0.1
Root Lot No.		Specifies the root lot no on the journal line.	1.0.0.1

Produce Journal Template

A Produce journal template is represented by a dedicated page with particular functions and the fields that are required to support those functions, such as the produce tracking, and produce value journals.

Table:71506715 DLGFF Produce Journal Template

Caption	Type	Description	Release
Name	Code	Specifies the name of the journal template you are creating.	1.0.0.1
Produce Entry Type	Option	Specifies the journal type that is used in connection with the template. The trade entry type determines whether tracking, cost or recharges entries are created.	1.0.0.1
Description	Text	Specifies a brief description of the journal you are creating.	1.0.0.1
Page ID	Integer	Specifies one of three pages to be used in connection with trade journals. The system supports Trade Charge Journals (71506707), Produce Tracking Journals (71506729) and Trade Cost Journals (71506728).	1.0.0.1
Source Code	Code	Specifies a source code that identifies where the entry was created, this code is added to transactions and also the produce tracking register when journals are posted.	1.0.0.1
Reason Code	Code	Specifies the reason code, a supplementary source code that enables you to trace the entry.	1.0.0.1
Page Caption	Text	Specifies the name of the page ID that has been entered for this selected journal template record.	1.0.0.1
No. Series	Code	Specifies the code for the number series that will be used to new document numbers in trade entry journals.	1.0.0.1
Posting No. Series	Code	Specifies the code for the number series that will be used to assign document numbers that are posted from this template.	1.0.0.1

Rules Buffer

This table is used internally during posting to assess which rules apply to produce tracking entries.

Table:71506718 DLGFF Rules Buffer

Caption	Type	Description	Release
Line No.	Integer	Specifies the line number of the set of records in the buffer.	1.0.0.1
Posting Rule Code	Code	Specifies the posting rule that has been recorded in the buffer record.	1.0.0.1
Treatment Id	Integer	Specifies the treatment ID that is to be used for this buffer record.	1.0.0.1
Parent No.	Code	Specifies the parent posting rule code that applies to the buffer record.	1.0.0.1

Trade Account

Trade accounts are used in connection with produce posting rules and treatments to facilitate tracking costs against inventory lots, and are used in the preparation of produce agreement invoices.

Table:71506712 DLGFF Trade Account

Caption	Type	Description	Release
Code	Code	Specifies a unique code to identify a trade account. Trade account codes are used in connection with the trade account posting setup to facilitate tracking costs against inventory lots, and are used in the preparation of produce agreement invoices.	1.0.0.1
Name	Text	Specifies the name of the trade account.	1.0.0.1
Lot Filter	Code	Lot Filter is a flow filter used to update the charge balance dynamically.	1.0.0.1
Date Filter	Date	Date filter is a flow filter used to update the charge balance dynamically.	1.0.0.1
Charge Line Type	Option	Specifies the charge line type to use in connection with the Charge Account No. Generally speaking a G/L Account type is specified.	1.0.0.1
Charge Account No.	Code	Specifies the account no. to use in connection with transactions involving trade charges. The available accounts are based on the Charge Line Type chosen.	1.0.0.1

See Also

Extension Table Field Reference