Page Comparison

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.04.22 and newer

Table of Contents

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

...

Database Field: ERPx_CPTicketHeader.CreatedDate

Database Field: ERPx_CPTicketHeader.CreatedBy

Item Last Updated (Date & Time)

Database Field: ERPx_CPTicketItem.LastUpdated

Database Field: ERPx_CPTicketItem.LastUser

ItemIdentifies the weight of the line item with a non-zero price. Def - Paid Weight

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

Received:

Graded:

Reviewed:

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

Column Headers

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Created

Insert excerpt

Created

nopanel

true

Created By

Insert excerpt

Created By

nopanel

true

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

Delivery Date

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

Farmer

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

Insert excerpt

	Def - Farmer
	Def - Farmer
nopanel	true

Database Field: ERPx_CPTicketHeader.FarmerSK

Farmer Class

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

Insert excerpt

	Def - Farmer Class
	Def - Farmer Class
nopanel	true

Linked Database Field: ERPx_APVendor.VendorClassSK

Field

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

Insert excerpt

	Def - Field
	Def - Field
nopanel	true

Database Field: ERPx_CPTicketHeader.FieldSK

Gross Amount

Insert excerpt

	Def - Ext Amount

Displays the Extended Amount of the line item. This

(GA)
	Def - Ext Amount (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 Date

Identifies the date the ticket was harvested. This 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

Hauler

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
	Def - Hauler
nopanel	true

Database Field: ERPx_CPTicketHeader.HaulerSK

Last Updated

Insert excerpt

Item Last Updated (Date & Time)

nopanel

true

Last Updated By

Insert excerpt

Item Last Updated By

nopanel

true

For Ticket Items -

Insert excerpt

	Item ID & Item Description
	Item ID & Item Description
nopanel	true

This is required.

For Charge and Accrual Items - Display the Program ID

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

Item CR Acct

Item DR Acct

Item Type

A text box to display the 'Item Type' assigned to the Ticket Item. This

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

	Item

Type (GA

Last Updated (Date & Time)
	Item

Type (GA

Last Updated (Date & Time)
nopanel	true

Database Field: ERPx_CPTicketItem.

ItemSK,

LastUpdated

Last Updated By

Insert excerpt

	Item Last Updated By
	Item Last Updated By
nopanel	true

Database Field: ERPx_

CPItem.ILineTypeEN

Row Type

Paid Weight

CPTicketItem.LastUser

Row Type

Insert excerpt

	Row Type (GA)
	Row Type (GA)
nopanel	true

This is not editable.

Paid Weight

Insert excerpt

	Def - Paid Weight
	Def - Paid Weight
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.

Insert excerpt

Def - Paid Weight

nopanel

true

Price

Identifies the price of the line item.

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.Price

Sample Percent

Identifies the percentage of the entire sample that graded out for the line item.

Insert excerpt

	Def - Percent (Sample Size)
	Def - Percent (Sample Size)
nopanel	true

This is a calculated field and that can only be edited by editing changing either the Ticket Item's 'Sample Size' from the Item's Grid on the Ticket Record View for tickets that have not been Approved or Postedor one of the Ticket Header Properties that impact the Ticket's Net Weight or Ticket's Sample Size.

Database Field: ERPx_CPTicketItem.SampleWeightPercent

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

Insert excerpt

	Def - Sample Size (Ticket Item)
	Def - Sample Size (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 Posted

.

Database Field: ERPx_CPTicketItem.SampleWeight

Site Name

Insert excerpt

	Site
	Site
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:

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 - Reviewed
	Def - Status - Reviewed
nopanel	true

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.

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

	Created By
	Created By
nopanel	true

Database Field: ERPx_CPTicketHeader.CreatedBy

Ticket Version

Identifies the version of the Ticket.

A

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 - Version
	Def - Version
nopanel	true

Database Field: ERPx_CPTicketHeader.TicketVersion

Unpaid Weight

Identifies the weight of the line item with a 0.00 price.

Insert excerpt

	Def - Unpaid Weight
	Def - Unpaid Weight
nopanel	true

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 excerpt

Def - Unpaid Weight

nopanel

true

Weight

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

Insert excerpt

	Def -

Net

Total Weight (GA)
	Def -

Net

Total Weight (GA)
nopanel	true

This is editable from the Ticket Record View.

Database Field: ERPx_CPTicketItem.TotalWeight

Weight UOM

Identifies the Weight 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 only be edited from the preference for tickets that have not yet been Approved or Posted.

Database Fields: ERPx_IMUOM.UOMName, ERPx_CPTicketItem.UOMSK

...

Versions Compared

Old Version 5

New Version 6

Key

Column Headers