Skip to content

Table Extension Reference Image title

Table Extensions

This is a complete list of the tables and fields that have been extended to enable the features of FreshFocus. In most cases the extended field provide support for item properties to be used as a filter or to define lot information when lot number are created via receipts or production output.

Assembly Header

Adds support for item properties, and defines the output lot item properties to be built.

tableextension 71506741 DLGFF Assembly Header extends Assembly Header

Caption Type Description Release
Producer Code Specifies the producer code that the assembly output lot numbers will inherit. 1.0.0.1
Producer Site Code Specifies the producer site code that the assembly output lot numbers will inherit. 1.0.0.1
Producer Block Code Specifies the producer block code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Crop Code Specifies the produce crop code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Variety Code Specifies the produce variety code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Size Code Specifies the produce size code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Grade Code Specifies the produce grade code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Processing Facility Code Specifies the packaging code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Packaging Code Specifies the packaging code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Brand Code Specifies the packaging code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Target Market Code Specifies the packaging code that the assembly output lot numbers will inherit. 1.0.0.1
Harvest Date Date Specifies the harvest date that the assembly output lot numbers will inherit. 1.0.0.1
Packing Date Date Specifies the packing date that the assembly output lot numbers will inherit. 1.0.0.1

Assembly Line

Adds support for item properties, as filters for input lots to be consumed

tableextension 71506740 DLGFF Assembly Line extends Assembly Line

Caption Type Description Release
Producer Filter Code Specifies a producer filter to be used for input lots on the assembly order line. 1.0.0.1
Producer Site Filter Code Specifies a producer site filter to be used for input lots on the assembly order line. 1.0.0.1
Producer Block Filter Code Specifies a producer block filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Crop Filter Code Specifies a produce crop filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Commodity Filter Code Specifies a produce commodity filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Variety Filter Code Specifies a produce variety filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Size Filter Code Specifies a produce size filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Grade Filter Code Specifies a produce grade filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Processing Facility Filter Code Specifies a processing facility filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Packaging Filter Code Specifies a packaging filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Brand Filter Code Specifies a brand filter to be used for input lots on the assembly order line. 1.0.0.1
Produce Target Market Filter Code Specifies a target market filter to be used for input lots on the assembly order line. 1.0.0.1
Harvest Date Filter Date Specifies a harvest date filter to be used for input lots on the assembly order line. 1.0.0.1
Packing Date Filter Date Specifies packing date filter to be used for input lots on the assembly order line. 1.0.0.1

Entry Summary

Adds support for produce item properties.

tableextension 71506692 DLGFF Entry Summary extends Entry Summary

Caption Type Description Release
Producer Code Specifies the producer code in connection with the lot number. 1.0.0.1
Producer Site Code Specifies the producer site code in connection with the lot number. 1.0.0.1
Producer Block Code Specifies the producer block code in connection with the lot number. 1.0.0.1
Produce Crop Code Specifies the produce crop code in connection with the lot number. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code in connection with the lot number. 1.0.0.1
Produce Variety Code Specifies the produce variety code in connection with the lot number. 1.0.0.1
Produce Size Code Specifies the produce size code in connection with the lot number. 1.0.0.1
Produce Grade Code Specifies the produce grade code in connection with the lot number. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code in connection with the lot number. 1.0.0.1
Produce Packaging Code Specifies the packaging code in connection with the lot number. 1.0.0.1
Produce Brand Code Specifies the brand code in connection with the lot number. 1.0.0.1
Produce Target Market Code Specifies the target market code in connection with the lot number. 1.0.0.1
Harvest Date Date Specifies the harvest date in connection with the lot number. 1.0.0.1
Packing Date Date Specifies the packing date in connection with the lot number. 1.0.0.1

Item

Adds produce item flag, properties and property criteria

tableextension 71506681 DLGFF Item extends Item

Caption Type Description Release
Produce Item Boolean Specifies whether the item can have produce properties associated with it. 1.0.0.1
Producer Criteria Option Specifies the criteria to use in connection with the producer code. 1.0.0.1
Producer Code Specifies the producer code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Producer Site Criteria Option Specifies the criteria to use in connection with the producer site. 1.0.0.1
Producer Site Code Specifies the producer site code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Producer Block Criteria Option Specifies the criteria to use in connection with the producer block. 1.0.0.1
Producer Block Code Specifies the producer block code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Crop Criteria Option Specifies the criteria to use in connection with the produce crop code. 1.0.0.1
Produce Crop Code Specifies the produce crop code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Commodity Criteria Option Specifies the criteria to use in connection with the commodity code. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Variety Criteria Option Specifies the criteria to use in connection with the variety code. 1.0.0.1
Produce Variety Code Specifies the produce variety code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Size Criteria Option Specifies the criteria to use in connection with the produce size code. 1.0.0.1
Produce Size Code Specifies the produce size code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Grade Criteria Option Specifies the criteria to use in connection with the produce grade code. 1.0.0.1
Produce Grade Code Specifies the produce grade code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Processing Facility Criteria Option Specifies the criteria to use in connection with the processing facility code. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Packaging Criteria Option Specifies the criteria to use in connection with the packaging code. 1.0.0.1
Produce Packaging Code Specifies the packaging code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Brand Criteria Option Specifies the criteria to use in connection with the brand code. 1.0.0.1
Produce Brand Code Specifies the brand code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Producer Target Market Criteria Option Specifies the criteria to use in connection with the target market code. 1.0.0.1
Produce Target Market Code Specifies the target market code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Harvest Date Mandatory Boolean Specifies whether a Harvest Date is mandatory in connection with Lots for this item. 1.0.0.1
Packing Date Mandatory Boolean Specifies whether a packing date is mandatory in connection with Lots for this item. 1.0.0.1

Item Journal Line

Adds support for filtering lot selection by produce item properties, and reclassification of properties.

tableextension 71506684 DLGFF Item Journal Line extends Item Journal Line

Caption Type Description Release
Producer Code Specifies the producer code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Producer Site Code Specifies the producer site code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Producer Block Code Specifies the producer block code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Crop Code Specifies the produce crop code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Variety Code Specifies the produce variety code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Size Code Specifies the produce size code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Grade Code Specifies the produce grade code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Packaging Code Specifies the packaging code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Brand Code Specifies the brand code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Target Market Code Specifies the target market code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
New Producer Code Specifies the new producer code to use for the selected produce lot. 1.0.0.1
New Producer Site Code Specifies the new site code to use for the selected produce lot. 1.0.0.1
New Producer Block Code Specifies the new producer block code to use for the selected produce lot. 1.0.0.1
New Produce Crop Code Specifies the new crop code to use for the selected produce lot. 1.0.0.1
New Produce Commodity Code Specifies the new commodity code to use for the selected produce lot. 1.0.0.1
New Produce Variety Code Specifies the new variety code to use for the selected produce lot. 1.0.0.1
New Produce Size Code Specifies the new size code to use for the selected produce lot. 1.0.0.1
New Produce Grade Code Specifies the new grade code to use for the selected produce lot. 1.0.0.1
New Produce Processing Facility Code Specifies the new processing facility code to use for the selected produce lot. 1.0.0.1
Produce Packaging Code Specifies the new packaging code to use for the selected produce lot. 1.0.0.1
New Produce Brand Code Specifies the new brand code to use for the selected produce lot. 1.0.0.1
New Produce Target Market Code Specifies the new target market code to use for the selected produce lot. 1.0.0.1
Property Reclass Boolean This field is used internally by the program to denote the item journal line should create a is derived from grading operations. 1.0.0.1
Harvest Date Date Specifies the harvest date for the journal line. Only lots that match this date will be available for selection in item tracking. 1.0.0.1
Packing Date Date Specifies the packing date for the journal line. Only lots that match this date will be available for selection in item tracking. 1.0.0.1
New Harvest Date Date Specifies the new harvest date for the selected produce lot. 1.0.0.1
New Packing Date Date Specifies the new packing date for the selected produce lot. 1.0.0.1
Grading Engine Boolean This field is used internally by the program to denote the item journal line is derived from grading operations. 1.0.0.1

Item Reference

Adds support for item references based on produce item properties.

tableextension 71506746 DLGFF Item Reference extends Item Reference

Caption Type Description Release
Producer Code Specifies the producer code to use in connection with the item reference record. 1.0.0.1
Producer Site Code Specifies the producer site code to use in connection with the item reference record. 1.0.0.1
Producer Block Code Specifies the producer block code to use in connection with the item reference record. 1.0.0.1
Produce Crop Code Specifies the produce crop code to use in connection with the item reference record. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code to use in connection with the item reference record. 1.0.0.1
Produce Variety Code Specifies the produce variety code to use in connection with the item reference record. 1.0.0.1
Produce Size Code Specifies the produce size code to use in connection with the item reference record. 1.0.0.1
Produce Grade Code Specifies the produce grade code to use in connection with the item reference record. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code to use in connection with the item reference record.. 1.0.0.1
Produce Packaging Code Specifies the packaging code to use in connection with the item reference record. 1.0.0.1
Produce Brand Code Specifies the brand code to use in connection with the item reference record. 1.0.0.1
Produce Target Market Code Specifies the target market code to use in connection with the item reference record. 1.0.0.1

Item Template

Adds item properties and property criteria for items based on a template.

tableextension 71506747 DLGFF Item Templ. extends Item Templ.

Caption Type Description Release
Produce Item Boolean Specifies whether the item can have produce properties associated with it. 1.0.0.1
Producer Criteria Option Specifies the criteria to use in connection with the producer code. 1.0.0.1
Producer Code Specifies the producer code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Producer Site Criteria Option Specifies the criteria to use in connection with the producer site. 1.0.0.1
Producer Site Code Specifies the producer site code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Producer Block Criteria Option Specifies the criteria to use in connection with the producer block. 1.0.0.1
Producer Block Code Specifies the producer block code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Crop Criteria Option Specifies the criteria to use in connection with the produce crop code. 1.0.0.1
Produce Crop Code Specifies the produce crop code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Commodity Criteria Option Specifies the criteria to use in connection with the commodity code. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Variety Criteria Option Specifies the criteria to use in connection with the variety code. 1.0.0.1
Produce Variety Code Specifies the produce variety code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Size Criteria Option Specifies the criteria to use in connection with the produce size code. 1.0.0.1
Produce Size Code Specifies the produce size code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Grade Criteria Option Specifies the criteria to use in connection with the produce grade code. 1.0.0.1
Produce Grade Code Specifies the produce grade code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Processing Facility Criteria Option Specifies the criteria to use in connection with the processing facility code. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Packaging Criteria Option Specifies the criteria to use in connection with the packaging code. 1.0.0.1
Produce Packaging Code Specifies the packaging code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Produce Brand Criteria Option Specifies the criteria to use in connection with the brand code. 1.0.0.1
Produce Brand Code Specifies the brand code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Producer Target Market Criteria Option Specifies the criteria to use in connection with the target market code. 1.0.0.1
Produce Target Market Code Specifies the target market code of the item. You can control whether the code is used, required, is same code or blocked in connection with FreshFocus lot information and produce posting rules. 1.0.0.1
Harvest Date Mandatory Boolean Specifies whether a Harvest Date is mandatory in connection with Lots for this item. 1.0.0.1
Packing Date Mandatory Boolean Specifies whether a packing date is mandatory in connection with Lots for this item. 1.0.0.1

Lot No Information

Adds support for produce item properties.

tableextension 71506680 DLGFF Lot No. Information extends Lot No. Information

Caption Type Description Release
Produce Agreement No. Code Specifies the produce agreement number that the lot number is related to. 1.0.0.1
Producer Code Specifies the producer code in connection with the lot number. 1.0.0.1
Producer Site Code Specifies the producer site code in connection with the lot number. 1.0.0.1
Producer Block Code Specifies the producer block code in connection with the lot number. 1.0.0.1
Produce Crop Code Specifies the produce crop code in connection with the lot number. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code in connection with the lot number. 1.0.0.1
Produce Variety Code Specifies the produce variety code in connection with the lot number. 1.0.0.1
Produce Size Code Specifies the produce size code in connection with the lot number. 1.0.0.1
Produce Grade Code Specifies the produce grade code in connection with the lot number. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code in connection with the lot number. 1.0.0.1
Produce Packaging Code Specifies the packaging code in connection with the lot number. 1.0.0.1
Produce Brand Code Specifies the brand code in connection with the lot number. 1.0.0.1
Produce Target Market Code Specifies the target market code in connection with the lot number. 1.0.0.1
Harvest Date Date Specifies the harvest date in connection with the lot number. 1.0.0.1
Packing Date Date Specifies the packing date in connection with the lot number. 1.0.0.1
Grade Flushing Boolean Specifies the Lot number is the result of finalising a grading order. This lot number is an interim lot between the tip lanes and the grad out lanes that were processed. 1.0.0.1

Price Calculation Buffer

Adds support for produce item properties, and ship-to pricing (see Price List line).

tableextension 71506745 DLGFF Price Calculation Buffer extends Price Calculation Buffer

Caption Type Description Release
Producer Code Specifies the producer code that the price applies to. 1.0.0.1
Producer Site Code Specifies the producer site code that the price applies to. 1.0.0.1
Producer Block Code Specifies the producer block code that the price applies to. 1.0.0.1
Produce Crop Code Specifies the produce crop code that the price applies to. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code that the price applies to. 1.0.0.1
Produce Variety Code Specifies the produce variety code that the price applies to. 1.0.0.1
Produce Size Code Specifies the produce size code that the price applies to. 1.0.0.1
Produce Grade Code Specifies the produce grade code that the price applies to. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code that the price applies to. 1.0.0.1
Produce Packaging Code Specifies the packaging code that the price applies to. 1.0.0.1
Produce Brand Code Specifies the brand code that the price applies to. 1.0.0.1
Produce Target Market Code Specifies the target market code that the price applies to. 1.0.0.1
Harvest Date Date Specifies the harvest date that the price applies to. 1.0.0.1
Packing Date Date Specifies the packing date that the price applies to. 1.0.0.1
Ship-to Code Code Specifies the ship-to code that the price applies to. 1.0.0.1

Price List Line

Adds support for produce item properties, and ship-to pricing.

tableextension 71506744 DLGFF Price List Line extends Price List Line

Caption Type Description Release
Producer Code Specifies the producer code that the price applies to. 1.0.0.1
Producer Site Code Specifies the producer site code that the price applies to. 1.0.0.1
Producer Block Code Specifies the producer block code that the price applies to. 1.0.0.1
Produce Crop Code Specifies the produce crop code that the price applies to. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code that the price applies to. 1.0.0.1
Produce Variety Code Specifies the produce variety code that the price applies to. 1.0.0.1
Produce Size Code Specifies the produce size code that the price applies to. 1.0.0.1
Produce Grade Code Specifies the produce grade code that the price applies to. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code that the price applies to. 1.0.0.1
Produce Packaging Code Specifies the packaging code that the price applies to. 1.0.0.1
Produce Brand Code Specifies the brand code that the price applies to. 1.0.0.1
Produce Target Market Code Specifies the target market code that the price applies to. 1.0.0.1
Location Code Code Specifies the location code that the price applies to. 1.0.0.1
Ship-to Code Code Specifies the ship-to code that the price applies to. 1.0.0.1

Prod Order Component

Adds support for produce item property filtering in lot selection, and flags for grading order processing.

tableextension 71506687 DLGFF Prod. Order Component extends Prod. Order Component

Caption Type Description Release
Producer Filter Code Specifies the producer code filter used in connection with input lots for this component line. 1.0.0.1
Producer Site Filter Code Specifies the producer site code filter used in connection with input lots for this component line. 1.0.0.1
Producer Block Filter Code Specifies the producer block code filter used in connection with input lots for this component line. 1.0.0.1
Produce Crop Filter Code Specifies the produce crop code filter used in connection with input lots for this component line. 1.0.0.1
Produce Commodity Filter Code Specifies the produce commodity code filter used in connection with input lots for this component line. 1.0.0.1
Produce Variety Filter Code Specifies the produce variety code filter used in connection with input lots for this component line. 1.0.0.1
Produce Size Filter Code Specifies the produce size code filter used in connection with input lots for this component line. 1.0.0.1
Produce Grade Filter Code Specifies the produce grade code filter used in connection with input lots for this component line. 1.0.0.1
Produce Processing Facility Filter Code Specifies the processing facility code filter used in connection with input lots for this component line. 1.0.0.1
Produce Packaging Filter Code Specifies the packaging code filter used in connection with input lots for this component line. 1.0.0.1
Produce Brand Filter Code Specifies the brand code filter used in connection with input lots for this component line. 1.0.0.1
Produce Target Market Filter Code Specifies the target market code filter used in connection with input lots for this component line. 1.0.0.1
Grading Order Status Option Specifies the status of the related grading order. 1.0.0.1
Grading Order No. Code Specifies the grading order no. that the components line will be consumed in. 1.0.0.1
Grading Order Line No. Integer Specifies the grading order no. that the components line will be consumed in. 1.0.0.1

Prod Order Line

Adds support for produce item properties, and flags for grading orders.

tableextension 71506685 DLGFF Prod. Order Line extends Prod. Order Line

Caption Type Description Release
Producer Code If the line type is 'grade-out' then specifies the producer code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the producer code. 1.0.0.1
Producer Site Code If the line type is 'grade-out' then specifies the producer site code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the producer site code. 1.0.0.1
Producer Block Code If the line type is 'grade-out' then specifies the producer block code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the producer block code. 1.0.0.1
Produce Crop Code If the line type is 'grade-out' then specifies the produce crop code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the produce crop code. 1.0.0.1
Produce Commodity Code If the line type is 'grade-out' then specifies the produce commodity code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the produce commodity code. 1.0.0.1
Produce Variety Code If the line type is 'grade-out' then specifies the produce variety code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the produce variety code. 1.0.0.1
Produce Size Code If the line type is 'grade-out' then specifies the producer size code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the produce size code. 1.0.0.1
Produce Grade Code If the line type is 'grade-out' then specifies the produce grade code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the produce grade code. 1.0.0.1
Produce Processing Facility Code If the line type is 'grade-out' then specifies the processing facility code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the processing facility code. 1.0.0.1
Produce Packaging Code If the line type is 'grade-out' then specifies the packaging code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the packaging code. 1.0.0.1
Produce Brand Code If the line type is 'grade-out' then specifies the brand code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the produce brand code. 1.0.0.1
Produce Target Market Code If the line type is 'grade-out' then specifies the target market code to be used on output lots for this line. If the line type is 'Tip-in' then specifies a filter for produce lots based on the target market code. 1.0.0.1
Harvest Date Date Specifies the harvest date that output lot numbers will inherit when processed. 1.0.0.1
Packing Date Date Specifies the packing date that output lot numbers will inherit when processed. 1.0.0.1
Lane Code Code If the line type is 'grade-out' then specifies the lane code of the item that is to be produced. If the line type is 'Tip-in' then 1.0.0.1REVIEW
Quantity Tipped Decimal Specifies the sum of the item ledger entry quantity field associated with this production order line, where the entry type is consumption. 1.0.0.1
Quantity Graded Decimal Specifies the sum of the item ledger entry quantity field associated with this production order line, where the entry type is output. 1.0.0.1
Grading Lane Type Option Specifies the type of grading lane for this line. 1.0.0.1
Linked Grade Out Lane Boolean For tip-in type lanes, specifies whether any gradeout lanes are linked to this production order line. 1.0.0.1
Pack Out Lanes Integer Specifies the number of linked pack out lanes (linked released production order consumption lines.) 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

Production BOM Header

Adds support for produce item properties as default outputs.

tableextension 71507015 DLGFF Production BOM Header extends Production BOM Header

Caption Type Description Release
Nominated Item No. Code Specifies the nominated produce item number for the production BOM. This enables multiple BOMs to be used in connection with packout orders. 1.0.0.1

Production BOM Line

Adds support for default produce item property filtering in lot selection.

tableextension 71507016 DLGFF Production BOM Line extends Production BOM Line

Caption Type Description Release
Producer Filter Code Specifies the producer filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Site Filter Code Specifies the producer site filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Block Filter Code Specifies the producer block filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Crop Filter Code Specifies the produce crop filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Commodity Filter Code Specifies the produce commodity filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Variety Filter Code Specifies the produce variety filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Size Filter Code Specifies the produce size filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Grade Filter Code Specifies the produce grade filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Processing Facility Filter Code Specifies the processing facility filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Packaging Filter Code Specifies the packaging filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Brand Filter Code Specifies the brand filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1
Target Market Filter Code Specifies the target market filter for lots to be consumed on a production order derived from the BOM line. 1.0.0.1

Production Order

Adds flags for commit to pack type orders, and grading default UOM.

tableextension 71506990 DLGFF Production Order extends Production Order

Caption Type Description Release
Grading Unit of Measure Code Specifies the unit of measure of the related grading profile. 1.0.0.1
Process Date Date Specifies the process date of the grading order. 1.0.0.1
Process Time Time Specifies the process time of the grading order. 1.0.0.1
Commit to Pack Boolean Specifies whether the production order is a commit to pack order. 1.0.0.1
Pack Out Lanes Integer Specifies the number of linked pack out lanes. 1.0.0.1
Production BOM Code20 Allows a user to select a Production BOM to use in connection with a released production order (packout). 1.0.0.1
Grading Order Status Option This field is used internally by the program and will be set to 'Released'. 1.0.0.1
Grading Order No. Code20 Allows a user to select a grading order to connect a released production order to. 1.0.0.1
Grading Order Line No. Integer Allows a user to select a grading order lane to connect a released production order to, this establishing a commit-to-pack requirement. 1.0.0.1

Purchase Header

Adds fields to link the purchase header to produce agreements, and the related invoices and credits.

tableextension 71506708 DLGFF Purchase Header extends Purchase Header

Caption Type Description Release
Produce Document Boolean Specifies whether the purchase header relates to a produce document which contains a collection of produce agreements. 1.0.0.1
PAI System Entry Boolean This field is set when a purchase invoice of credit memo is generated from a produce agreement invoice. 1.0.0.1
Linked Produce Agreement Invoice No. Code Specifies the produce agreement invoice number used in connection with this purchase header. 1.0.0.1
Linked PA Invoice Line No. Integer Specifies the produce agreement invoice line number used in connection with this purchase header. 1.0.0.1
Linked PAI Detail Line No. Integer Specifies the produce agreement invoice line detail number used in connection with this purchase header. 1.0.0.1

Purchase Line

Add support for default produce item properties in connection with produce agreements.

tableextension 71506705 DLGFF Purchase Line extends Purchase Line

Caption Type Description Release
Produce Agreement No. Code Specifies the produce agreement that this purchase line relates to. 1.0.0.1
Producer Code Specifies the producer code that the assembly output lot numbers will inherit. 1.0.0.1
Producer Site Code Specifies the producer site code that the assembly output lot numbers will inherit. 1.0.0.1
Producer Block Code Specifies the producer block code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Crop Code Specifies the produce crop code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Variety Code Specifies the produce variety code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Size Code Specifies the produce size code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Grade Code Specifies the produce grade code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Packaging Code Specifies the packaging code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Brand Code Specifies the brand code that the assembly output lot numbers will inherit. 1.0.0.1
Produce Target Market Code Specifies the target market code that the assembly output lot numbers will inherit. 1.0.0.1
Harvest Date Date Specifies the harvest date that the assembly output lot numbers will inherit. 1.0.0.1
Packing Date Date Specifies the packing date that the assembly output lot numbers will inherit. 1.0.0.1
Balancing Line Boolean Specifies whether the purchase line was inserted as a balancing line in connection with a linked credit memo. This is used in the case where a produce agreement net value is negative. 1.0.0.1

Purchase Line Archive

Adds support for produce item properties.

tableextension 71506693 DLGFF Purchase Line Archive extends Purchase Line Archive

Caption Type Description Release
Producer Code Specifies the producer code used on the document line. 1.0.0.1
Producer Site Code Specifies the producer site code used on the document line. 1.0.0.1
Producer Block Code Specifies the producer block code used on the document line. 1.0.0.1
Produce Crop Code Specifies the produce crop code used on the document line. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code used on the document line. 1.0.0.1
Produce Variety Code Specifies the produce variety code used on the document line. 1.0.0.1
Produce Size Code Specifies the produce size code used on the document line. 1.0.0.1
Produce Grade Code Specifies the produce grade code used on the document line. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code used on the document line. 1.0.0.1
Produce Packaging Code Specifies the packaging code used on the document line. 1.0.0.1
Produce Brand Code Specifies the brand code used on the document line. 1.0.0.1
Produce Target Market Code Specifies the target market code used on the document line. 1.0.0.1
Harvest Date Date Specifies the harvest date used on the document line. 1.0.0.1
Packing Date Date Specifies the packing date used on the document line. 1.0.0.1

Purch Cr Memo Hdr

Adds flags for tracking related produce agreement invoices.

tableextension 71506707 DLGFF Purch. Cr. Memo Hdr extends Purch. Cr. Memo Hdr

Caption Type Description Release
Posted Produce Agreement Invoice No. Code Specifies the posted produce agreement invoice number that was used to generate this invoice. 1.0.0.1
Produce Agreement Invoice No. Code Specifies the produce agreement invoice that this purchase invoice is connected to. 1.0.0.1
Produce Agreement Invoice Advance Payment Boolean Specifies whether the invoice was created from a produce agreement invoice as an advance payment. 1.0.0.1
Produce Agreement Invoice Detail Line No. Integer Specifies the produce agreement invoice line detail that this invoice is related to. 1.0.0.1

Purch Cr Memo Line

Adds flags for tracking related produce agreement invoices.

tableextension 71506694 DLGFF Purch. Cr. Memo line extends Purch. Cr. Memo Line

Caption Type Description Release
Posted Produce Agreement Invoice No. Code Specifies the posted produce agreement invoice number that the purchase credit memo line relates to. 1.0.0.1
Posted Produce Agreement Invoice Line No. Integer Specifies the posted produce agreement invoice line number that the purchase credit memo line relates to. 1.0.0.1

Purch Inv Header

Adds flags for tracking related produce agreement invoices.

tableextension 71506706 DLGFF Purch. Inv. Header extends Purch. Inv. Header

Caption Type Description Release
Posted Produce Agreement Invoice No. Code Specifies the posted produce agreement invoice number that was used to generate this invoice. 1.0.0.1
Produce Agreement Invoice No. Code Specifies the produce agreement invoice that this purchase invoice is connected to. 1.0.0.1
Produce Agreement Invoice Advance Payment Boolean Specifies whether the invoice was created from a produce agreement invoice as an advance payment. 1.0.0.1
Produce Agreement Invoice Detail Line No. Integer Specifies the produce agreement invoice line detail that this invoice is related to. 1.0.0.1

Purch Inv Line

Adds flags for tracking related produce agreement invoices.

tableextension 71506691 DLGFF Purch. Inv. Line extends Purch. Inv. Line

Caption Type Description Release
Produce Agreement No. Code Specifies the produce agreement number that the purchase invoice line is related to. 1.0.0.1
Posted Produce Agreement Invoice No. Code Specifies the posted produce agreement invoice number that the purchase invoice line relates to. 1.0.0.1
Posted Produce Agreement Invoice Line No. Integer Specifies the posted produce agreement invoice line number that the purchase invoice line relates to. 1.0.0.1

Purch Rcpt Line

Adds flags for tracking related produce agreement invoices.

tableextension 71506576 DLGFF Purch. Rcpt. Line extends Purch. Rcpt. Line

Caption Type Description Release
Produce Agreement No. Code Specifies the produce agreement number that the purchase receipt is related to. 1.0.0.1

Reservation Entry

Adds support for produce properties for active and posted item tracking.

tableextension 71506682 DLGFF Reservation Entry extends Reservation Entry

Caption Type Description Release
New Producer Code Inherits the new producer code from the reservation entry for the selected produce lot. 1.0.0.1
New Producer Site Code Inherits the new site code from the reservation entry for the selected produce lot. 1.0.0.1
New Producer Block Code Inherits the new producer block code from the reservation entry for the selected produce lot. 1.0.0.1
New Produce Crop Code Inherits the new crop code from the reservation entry for the selected produce lot. 1.0.0.1
New Produce Commodity Code Inherits the new commodity code from the reservation entry for the selected produce lot. 1.0.0.1
New Produce Variety Code Inherits the new variety code from the reservation entry for the selected produce lot. 1.0.0.1
New Produce Size Code Inherits the new size code from the reservation entry for the selected produce lot. 1.0.0.1
New Produce Grade Code Inherits the new grade code from the reservation entry for the selected produce lot. 1.0.0.1
New Produce Processing Facility Code Inherits the new processing facility code from the reservation entry for the selected produce lot. 1.0.0.1
Produce Packaging Code Inherits the new packaging code from the reservation entry for the selected produce lot. 1.0.0.1
New Produce Brand Code Inherits the new brand code from the reservation entry for the selected produce lot. 1.0.0.1
New Produce Target Market Code Inherits the new target market code from the reservation entry for the selected produce lot. 1.0.0.1
Harvest Date Date Inherits the harvest date from the lot no information record. 1.0.0.1
Packing Date Date Inherits the harvest date from the lot no information record. 1.0.0.1
New Harvest Date Date Inherits the new harvest date for the selected produce lot. 1.0.0.1
New Packing Date Date Inherits the new packing date for the selected produce lot. 1.0.0.1

Sales Line

Add support for produce item property filtering in lot selection, and modified table relations for produce items.

tableextension 71506683 DLGFF Sales Line extends Sales Line

Caption Type Description Release
Producer Filter Code Specifies the producer filter used on the document line. 1.0.0.1
Producer Site Filter Code Specifies the producer site filter used on the document line. 1.0.0.1
Producer Block Filter Code Specifies the producer block filter used on the document line. 1.0.0.1
Produce Crop Filter Code Specifies the produce crop filter used on the document line. 1.0.0.1
Produce Commodity Filter Code Specifies the produce commodity filter used on the document line. 1.0.0.1
Produce Variety Filter Code Specifies the produce variety filter used on the document line. 1.0.0.1
Produce Size Filter Code Specifies the produce size filter used on the document line. 1.0.0.1
Produce Grade Filter Code Specifies the produce grade filter used on the document line. 1.0.0.1
Produce Processing Facility Filter Code Specifies the processing facility filter used on the document line. 1.0.0.1
Produce Packaging Filter Code Specifies the packaging filter used on the document line. 1.0.0.1
Produce Brand Filter Code Specifies the brand filter used on the document line. 1.0.0.1
Produce Target Market Filter Code Specifies the target market filter used on the document line. 1.0.0.1
Harvest Date Filter Date Specifies the harvest date used on the document line. 1.0.0.1
Packing Date Filter Date Specifies the packing date used on the document line. 1.0.0.1
Produce Parent Line No. Integer This field is used when a sales line is split based on produce properties. The system keep track of the originating sales line. 1.0.0.1

Sales Line Archive

Adds support for produce properties (see sales line).

tableextension 71506697 DLGFF Sales Line Archive extends Sales Line Archive

Caption Type Description Release
Producer Code Specifies the producer code used on the document line. 1.0.0.1
Producer Site Code Specifies the producer site code used on the document line. 1.0.0.1
Producer Block Code Specifies the producer block code used on the document line. 1.0.0.1
Produce Crop Code Specifies the produce crop code used on the document line. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code used on the document line. 1.0.0.1
Produce Variety Code Specifies the produce variety code used on the document line. 1.0.0.1
Produce Size Code Specifies the produce size code used on the document line. 1.0.0.1
Produce Grade Code Specifies the produce grade code used on the document line. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code used on the document line. 1.0.0.1
Produce Packaging Code Specifies the packaging code used on the document line. 1.0.0.1
Produce Brand Code Specifies the brand code used on the document line. 1.0.0.1
Produce Target Market Code Specifies the target market code used on the document line. 1.0.0.1
Harvest Date Date Specifies the harvest date used on the document line. 1.0.0.1
Packing Date Date Specifies the packing date used on the document line. 1.0.0.1

Tracking Specification

Adds support for produce properties for active and posted item tracking.

tableextension 71506690 DLGFF Tracking Specification extends Tracking Specification

Caption Type Description Release
Producer Code Specifies the producer code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Producer Site Code Specifies the producer site code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Producer Block Code Specifies the producer block code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Crop Code Specifies the produce crop code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Commodity Code Specifies the produce commodity code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Variety Code Specifies the produce variety code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Size Code Specifies the produce size code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Grade Code Specifies the produce grade code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Processing Facility Code Specifies the processing facility code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Packaging Code Specifies the packaging code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Brand Code Specifies the brand code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
Produce Target Market Code Specifies the target market code for the journal line. Only lots that match this code will be available for selection in item tracking. 1.0.0.1
New Producer Code Specifies the new producer code to use for the selected produce lot. 1.0.0.1
New Producer Site Code Specifies the new site code to use for the selected produce lot. 1.0.0.1
New Producer Block Code Specifies the new producer block code to use for the selected produce lot. 1.0.0.1
New Produce Crop Code Specifies the new crop code to use for the selected produce lot. 1.0.0.1
New Produce Commodity Code Specifies the new commodity code to use for the selected produce lot. 1.0.0.1
New Produce Variety Code Specifies the new variety code to use for the selected produce lot. 1.0.0.1
New Produce Size Code Specifies the new size code to use for the selected produce lot. 1.0.0.1
New Produce Grade Code Specifies the new grade code to use for the selected produce lot. 1.0.0.1
New Produce Processing Facility Code Specifies the new processing facility code to use for the selected produce lot. 1.0.0.1
Produce Packaging Code Specifies the new packaging code to use for the selected produce lot. 1.0.0.1
New Produce Brand Code Specifies the new brand code to use for the selected produce lot. 1.0.0.1
New Produce Target Market Code Specifies the new target market code to use for the selected produce lot. 1.0.0.1
Harvest Date Date Specifies the harvest date for the journal line. Only lots that match this date will be available for selection in item tracking. 1.0.0.1
Packing Date Date Specifies the packing date for the journal line. Only lots that match this date will be available for selection in item tracking. 1.0.0.1
New Harvest Date Date Specifies the new harvest date for the selected produce lot. 1.0.0.1
New Packing Date Date Specifies the new packing date for the selected produce lot. 1.0.0.1

Transfer Line

Add support for produce property filtering in lot selection.

tableextension 71506689 DLGFF Transfer Line extends Transfer Line

Caption Type Description Release
Producer Filter Code Sets a default producer filter for selection or creation of Lot Nos for the line 1.0.0.1
Producer Site Filter Code Sets a default producer site filter for selection or creation of Lot Nos for the line 1.0.0.1
Producer Block Filter Code Sets a default producer block filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Crop Filter Code Sets a default crop filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Commodity Filter Code Sets a default commodity filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Variety Filter Code Sets a default variety filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Size Filter Code Sets a default size filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Grade Filter Code Sets a default grade filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Processing Facility Filter Code Sets a default processing facility filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Packaging Filter Code Sets a default packaging filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Brand Filter Code Sets a default brand filter for selection or creation of Lot Nos for the line 1.0.0.1
Produce Target Market Filter Code Sets a default target market filter for selection or creation of Lot Nos for the line 1.0.0.1
Harvest Date Filter Date Sets a default filter harvest date selection or creation of Lot Nos for the line 1.0.0.1
Packing Date Filter Date Sets a default filter for packing date selection or creation of Lot Nos for the line 1.0.0.1
See Also

Table Field Reference