Insert excerptDef - Grower TicketDef - Grower Ticketnopaneltrue The purpose of this list view is to display Ticket items, Accruals and Charges (if applicable) for all Tickets that have not been posted. From this list view, users may open the corresponding Ticket.

This list view also contains columns for each Attribute that is set up under the 'Grower Accounting Items' Master File attribute type and the 'Grower Accounting' Transaction attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout. User configured attributes are not included in the help documentation.

Software Version: 2022.04.22 and newer

Table of Contents

exclude	(Toolbar Icons\|Column Headers\|Toolbar Icon)
type	flat

Page Header

...

Toolbar Icons

...

Columns

...

Column Headers

...

Database Field: ERPx_CPTicketHeader.CreatedDate

...

Insert excerpt

	Def - Grower Ticket
	Def - Grower Ticket
nopanel	true

The purpose of this list view is to display Ticket items, Accruals and Charges (if applicable) for all Tickets that have not been posted. From this list view, users may open the corresponding Ticket.

This list view also contains columns for each Attribute that is set up under the 'Grower Accounting Items' Master File attribute type and the 'Grower Accounting' Transaction attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout. User configured attributes are not included in the help documentation.

Software Version: 2022.08.26 and newer

Table of Contents

exclude	(Toolbar Icons\|Column Headers\|Toolbar Icon)
type	flat

Page Header

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Edit

Insert excerpt

	Edit - LV 3.0
	Edit - LV 3.0
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

New

Insert excerpt

	New - Multi-Select Trans Type - Global 3.0
	New - Multi-Select Trans Type - Global 3.0
nopanel	true

Print

Insert excerpt

	Print - LV 3.0
	Print - LV 3.0
nopanel	true

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Refresh

Insert excerpt

	Refresh - Global 3.0
	Refresh - Global 3.0
nopanel	true

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Columns

yet DeliveryDateIdentifies the Farmer that the ticket is assigned to. This can only be edited when initially creating a ticket.

Database Field: ERPx_CPTicketHeader.FarmerSK

Identifies the Class assigned to the Farmer on the ticket. This can only be edited from the Farmer Master File.

Linked Database Field: ERPx_APVendor.VendorClassSK

Identifies the Field the ticket was harvested from. This can only be edited when initially creating a ticket

Database Field: ERPx_CPTicketHeader.FieldSK

yet HarvestDateDef - Hauler

For Ticket Items -

Column Headers

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Accrual Amt.

Insert excerpt

	Def - Accrual Amt. (GA)
	Def - Accrual Amt. (GA)
nopanel	true

Insert excerpt

	Def - Program Type - GA Accrual
	Def - Program Type - GA Accrual
nopanel	true

Database Field: ERPx_CPTicketItem.AccrualAmount

Charge Amt.

Insert excerpt

	Def - Charge Amt. (GA)
	Def - Charge Amt. (GA)
nopanel	true

Insert excerpt

	Def - Program Type - GA Charges
	Def - Program Type - GA Charges
nopanel	true

Database Field: ERPx_CPTicketItem.ChargeAmount

Crop

Identifies the Crop that was harvested from the Field assigned to the Ticket. This can only be edited when initially creating a ticket.

Insert excerpt

	Def - Crop
	Def - Crop
nopanel	true

Database Field: ERPx_CPTicketHeader.CropSK

Delivered

Identifies the date the ticket was delivered. This can only be edited by editing the 'Delivered' field on the Ticket Record View for tickets that have not yet been Approved or Posted.

Database Field: ERPx_CPTicketHeader.DeliveryDate

Delivered Wt.

Insert excerpt

	Def - Delivered Wt. (GA)
	Def - Delivered Wt. (GA)
nopanel	true

This is a calculated field that cannot be edited unless:

One or more of the following header values are edited: Weight In, Weight Out, or Total Tare
One or more of the following ticket items values are edited: Sample or Sample Pct.

Database Field: ERPx_CPTicketItem.TotalWeight

Farmer Class

Identifies the Class assigned to the Farmer. This can only be edited by changing the 'Vendor Class ID' value on the Vendor Record View.

Insert excerpt

	Def - Farmer Class
	Def - Farmer Class
nopanel	true

Linked Database Field: ERPx_APVendor.VendorClassSK

Farmer ID

Identifies the ID of the Farmer that the ticket is assigned to. This can only be edited by changing the 'Vendor ID' value on the Vendor Record View.

Insert excerpt

	Def - Farmer
	Def - Farmer
nopanel	true

Database Field: ERPx_APVendor.VendorID

Farmer Name

Identifies the Farmer that the ticket is assigned to. This can only be edited by changing the 'Vendor Name' value on the Vendor Record View.

Insert excerpt

	Def - Farmer
	Def - Farmer
nopanel	true

Database Field: ERPx_CPTicketHeader.

CreatedBy

FarmerSK

CropField

Identifies the Field the Crop that ticket was harvested from the Field assigned to the Ticket. This can only be edited when initially creating a ticket.

Insert excerpt

	Def - CropField
	Def - CropField
nopanel	true

Database Field: ERPx_CPTicketHeader.CropSK

Delivery Date

Identifies the date the ticket was delivered. This can only be edited by editing the 'Delivered' field on the FieldSK

GL Date

Insert excerpt

	GL Date
	GL Date
nopanel	true

This is required for the transaction to be approved or posted. It can be edited from the 'GL Date' field on the 'Properties' tab of the Ticket Record View for tickets that have not

been Approved or Posted.

Database Field: ERPx_CPTicketHeader.

Farmer

GLDate

GL Period

Insert excerpt

Def - Farmer

nopanel

true

Farmer Class

Insert excerpt

Def - Farmer Class

nopanel

true

Field

	GL Period
	GL Period
nopanel	true

This is required for the transaction to be approved or posted. It is not directly editable. It can only be changed by editing the 'GL Date' field on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted. This field is not stored in the database.

GL Year

Insert excerpt

	GL Year
	GL Year
nopanel	true

This is required for the transaction to be approved or posted. It is not directly editable. It can be changed by editing the 'GL Date' field on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted. This field is not stored in the database.

Gross Amt.

Insert excerpt

	Def -

Field

Gross Amt. (GA)
	Def -

Field

nopanel

true

Gross Amount

Displays the Extended Amount of the line item. This

Gross Amt. (GA)
nopanel	true

This is a calculated field and can only be edited by changing the weight or price of the line item.

Database Field: ERPx_CPTicketItem.GrossAmount

Harvest DateHarvested

Identifies the date the ticket was harvested. This can only be edited by editing the 'Harvested' field on can only be edited by editing the 'Harvested' field on the Ticket Record View for tickets that have not yet been Approved or Posted.

Database Field: ERPx_CPTicketHeader.HarvestDate

Harvester

Identifies who harvested the crop. This is not required and can be edited on the 'Properties' tab of the Ticket Record View for tickets that have not

been Approved or Posted.

Insert excerpt

	Def - Harvester
	Def - Harvester
nopanel	true

Database Field: ERPx_CPTicketHeader.

HarvesterSK

HarvesterHauler

Identifies who

harvested

delivered the crop. This is not required and can be edited on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved

or Posted.

Insert excerpt

	Def - Hauler
	Def - Hauler
nopanel	true

Database Field: ERPx_CPTicketHeader.HaulerSK

Item

Identifies who delivered the crop. This is not required and can be edited on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted.

Insert excerpt

Def - Hauler

Insert excerpt

	Def - Harvester	Def - HarvesterItem ID & Item Description
	Item ID & Item Description
nopanel	true

For Charge and Accrual Items - Display the Program ID

Database Field: ERPx_CPTicketHeader.HarvesterSK

Hauler

ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ItemID, ERPx_CPItem.ItemDescription

Item Type

Insert excerpt

	Item Type (GA)
	Item Type (GA)
nopanel	true

This can only be edited from the Ticket Items Record View.

This is not populated for rows where the 'Row Type' = 'Charge' or 'Accrual'.

Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN

Last Updated

Insert excerpt

	Last Updated
	Last Updated
nopanel	true

Database Field: ERPx_CPTicketHeaderCPTicketItem.HaulerSKLastUpdated

Last Updated ByItem Last Updated (Date & Time

Insert excerpt

Item Last Updated (Date & Time)

Last Updated By
	Last Updated By
nopanel	true

Database Field: ERPx_CPTicketItem.LastUser

Net Amt.

Insert excerpt

	Def - Net Amt. (GA)
	Def - Net Amt. (GA)
nopanel	true

This is a calculated field and is not editable.

Database Field: ERPx_CPTicketItem.LastUpdated

Last Updated By

NetAmount

Paid Wt.Item Last Updated By

Insert excerpt

Item Last Updated By

Def - Paid Weight
	Def - Paid Weight
nopanel	true

Database Field: ERPx_CPTicketItem.LastUser

Item Insert excerptItem ID & Item DescriptionItem ID & Item Descriptionnopaneltrue This is required.

Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ItemID, ERPx_CPItem.ItemDescription

Item CR AcctItem DR AcctItem Type

A text box to display the 'Item Type' assigned to the Ticket Item. This can only be edited from the Ticket Items Record View.

Insert excerptItem Type (GA)Item Type (GA)nopaneltrue

This can only be edited by editing the 'Price' on the ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted.

Note: Paid Weight is calculated for line-items with a non-zero Price. Items with a negative price are considered 'paid'.

Database Field: ERPx_CPTicketItem.PaidWeight

PricePaid Weight

Insert excerpt

	Price
	Price
nopanel	true

This can only be edited by editing the 'Price' on the ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted.

Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN

Row Type

Price

Price List

Identifies the

weight of the line item with a non-zero price.

Price List associated with the Farmer on the ticket. This can only be

edited by editing the 'Price' on the ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted.

edited by changing the price list assigned to the farmer.

Insert excerpt

	Def -

Paid Weight

Price List
	Def -

Paid Weight

Price List
nopanel	true

Note: Paid Weight is calculated for line-items with a non-zero Price. Items with a negative price are considered 'paid'.

Database Field: ERPx_

CPTicketItem

CPTicketHeader.

PaidWeight

PriceListSK

Price UOM

Identifies the

price

unit of measure which the line item

. This

's price is based upon. This can only be edited by

editing the 'Price' on the ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted.

Database Field: ERPx_CPTicketItem.Price

Sample PercentIdentifies the percentage of the entire sample that graded out for the line item. This is a calculated field and can be edited by editing the 'Sample Size' from the Item's Grid on the Ticket Record View for tickets that have not been

changing the value selected in the "Scale Weight UOM" preference.

Database Field: ERPx_MFPriceListItemHistory.PriceUOMSK

Purchase GL Account

Insert excerpt

	GL Account - Purchases (GA)
	GL Account - Purchases (GA)
nopanel	true

This is required for any Ticket Item that has a Net Amount <> 0.00. This is editable from the Item grid on the Ticket Record View until the Ticket is Approved or Posted.

Database

Field

Fields:

ERPx_

CPTicketItem.SampleWeightPercentSample WeightIdentifies the weight of the sample that graded out for the line item. This is required and can be edited from the

GLAccount.AccountNumber - Description, ERPx_CPTicketItem.PurchaseGLAccountSK

Sample

Insert excerpt

	Def - Sample (Ticket Item)
	Def - Sample (Ticket Item)
nopanel	true

This is editable from the Item's Grid on the Ticket Record View for tickets that have not been Approved or Postedor Posted.

Database Field: ERPx_CPTicketItem.SampleWeight

Sample Pct.

Insert excerpt

	Def - Sample Pct
	Def - Sample Pct
nopanel	true

This is a calculated field that can only be edited by changing either the 'Sample' or 'Sample Pct.' on a Ticket Item.

Database Field: ERPx_CPTicketItem.

SampleWeight

SampleWeightPercent

Site Name

Insert excerpt

	Site Name
	Site Name
nopanel	true

This comes from the 'Site' lookup on the Ticket Record View. It is not editable.

Insert excerpt

	Def - Site
	Def - Site
nopanel	true

Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK

Status

Insert excerpt

	Status
	Status
nopanel	true

This comes from the 'Status' on the 'Home' tab of the Ticket Record View. It is not editable.

Insert excerpt

	Def - Status
	Def - Status
nopanel	true

The Statuses that apply to transactions in this

Inquiry include:

List View include:

Insert excerpt

	Def - Status - New
	Def - Status - New
nopanel	true

Insert excerpt

	Def - Status - Received
	Def - Status - Received
nopanel	true

Insert excerpt

	Def - Status - Graded
	Def - Status - Graded
nopanel	true

Insert excerpt

	Def - Status -

New

Reviewed
	Def - Status -

New

Reviewed
nopanel	true

Received:

Graded:

Reviewed:

Insert excerpt

	Def - Status - Approved
	Def - Status - Approved
nopanel	true

Insert excerpt

	Def - Status - Ready to Post
	Def - Status - Ready to Post
nopanel	true

Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName

Ticket

Insert excerpt

	Transaction ID
	Transaction ID
nopanel	true

This is a system assigned value and is not editable. Clicking on this link opens the transaction record view.

Database Field: ERPx_CPTicketHeader.TicketNumber

Ticket Class

Insert excerpt

	Transaction Class
	Transaction Class
nopanel	true

This comes from the 'Transaction Class' value selected by the user when the transaction was created. It is not editable.. It is not editable.

Insert excerpt

	Def - Transaction Class - General
	Def - Transaction Class - General
nopanel	true

Database Field: ERPx_CPTicketHeader.TransactionClassSK

Ticket Created

Insert excerpt

	Created
	Created
nopanel	true

Database Field: ERPx_CPTicketHeader.CreatedDate

Ticket Created By

Insert excerpt

	Def - Transaction Class - General	Def - Transaction Class - GeneralCreated By
	Created By
nopanel	true

Database Field: ERPx_CPTicketHeader.TransactionClassSKCreatedBy

Ticket VersionUnits

Identifies the version # of containers the Ticket . A blank value signifies a version 1 ticket. All ticket versions greater than 1 will displayItem was delivered in. This is not required and is editable from the Item's grid until the Ticket is Approved or Posted.

Database Field: ERPx_CPTicketItem.Units

Unpaid Wt.

Insert excerpt

	Def -

Version

Unpaid Weight
	Def -

Version

Unpaid Weight
nopanel	true

Database Field: ERPx_CPTicketHeader.TicketVersion

Unpaid Weight

Identifies the weight of the line item with a 0.00 price. This can only be edited by editing the 'Price' of a ticket line on the Ticket Record View for tickets that have not yet been Approved or Posted. Insert excerptDef - Unpaid WeightDef - Unpaid WeightnopaneltruePosted.

Note: Unpaid Weight is only calculated for line-items with a 0.00 Price. Items with a negative price are not considered 'Unpaid'.

Database Field: ERPx_CPTicketItem.UnpaidWeight

WeightVersion

Identifies the

Net Weight

version of the

line item. This can only be edited on the Ticket Record View for tickets that have not yet been Approved or Posted

Ticket. This is a system assigned value and is not editable. A blank value signifies a version 1 ticket. All ticket versions greater than 1 will display with a numeric value.

Insert excerpt

	Def -

Net Weight

Version
	Def -

Net Weight

Version
nopanel	true

Database Field: ERPx_

CPTicketItem.TotalWeightWeight UOM

Identifies the Unit of Measure of the line item. This comes from the Scale Weight UOM preference and UOM field on the Ticket Record View. It can be edited from the preference for tickets that have not yet been Approved or Posted.

Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.UOMSK

CPTicketHeader.TicketVersion

Versions Compared

Old Version 5

New Version Current

Key

Page Header

Toolbar Icons

Columns

Column Headers

Page Header

Toolbar Icons

Columns

Column Headers

Related Topics

Page Comparison

Versions Compared

Old Version 5

New Version Current

Key

Page Header

Toolbar Icons

Columns

Column Headers

Page Header

Toolbar Icons

Columns

Column Headers

Related Topics