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

Page Header 

...

Toolbar Icons

...

Columns

...

Column Headers

...

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

...

Database Field: ERPx_CPTicketHeader.CropSK

...

 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

Page Header 

Columns

the Farmer that the ticket is assigned to. This can only be edited when initially creating a ticket. Farmer FarmerFarmerSKIdentifies the Field the ticket was harvested from. This can only be edited when initially creating a ticket.trueCPTicketHeader.FieldSKGross AmountDef - Gross Amt. Def - Gross Amt.  This is a calculated field and by changing the weight or price of the line itemGrossAmount

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.

CPTicketHeader.HarvestDate Harvester Harvester

Database Field: ERPx_CPTicketHeader.HarvesterSK

Identifies who delivered the crop. This is not required and can be edited on the 'Properties' tab of

Database Field: ERPx_CPTicketHeader.HaulerSK

For Ticket Items - For Charge and Accrual Items - Display the Program IDItemSK, ERPx_CPItem.ItemID, ERPx_CPItem.ItemDescriptionItem Last Updated (Date & Time)

Item Type (GA)

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.FarmerSK
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
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.GLDate
GL Period	Insert excerpt 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 - Gross Amt. (GA) Def - 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
Harvested	Identifies the date the ticket was harvested. This can only be edited by editing the 'DeliveredHarvested' field on the Ticket Record View for tickets that have not yet been Approved or Posted. Database Field: ERPx_CPTicketHeader.DeliveryDateHarvestDate Farmer
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
Farmer ClassHauler	Identifies the Class assigned to the Farmer on the ticket. This can only be edited from the Farmer Master Filewho 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 - Farmer Class Hauler Def - Farmer Class Hauler nopanel true Linked Database Field: ERPx_APVendorCPTicketHeader.VendorClassSKHaulerSK	Field
Item	Def - Field	nopanel	For Ticket Items -  Insert excerpt	Def - Field		Item ID & Item Description Item ID & Item Description nopanel true For Charge and Accrual Items - Display the Program ID Database Field: 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.	Harvest Date	ItemSK, ERPx_CPItem.ILineTypeEN
Last Updated	Insert excerpt Last Updated Last Updated nopanel true Database Field: ERPx_CPTicketItem.LastUpdated
Last Updated By	Insert excerpt Last Updated By Last Updated By nopanel true Database Field: ERPx_	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 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.NetAmount
Paid Wt.	Insert excerpt Def -	Paid Weight Def -	Paid Weight nopanel true	Hauler	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 - Hauler	Def - Hauler
nopanel	true
Item
Insert excerpt
Item ID & Item Description	Item ID & Item Description
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.	Item CR Acct	Item DR Acct	Item Type	PaidWeight
Price
Insert excerpt
Item Last Updated (Date & Time)

Insert excerpt

Item Type (GA)

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

Identifies the Price List associated with the Farmer on the ticket. This can only be edited by changing the price list assigned to the farmer.

Database Field: ERPx_CPTicketItem.LastUser

Database Field: ERPx_CPTicketItemCPTicketHeader.LastUpdated

PriceListSK

Identifies the unit of measure which the line item's price is based upon. This can only be edited by changing the value selected in the "Scale Weight UOM" preference.

Database Field: ERPx_MFPriceListItemHistory.PriceUOMSK

 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

been Approved or Posted.

Database Field: ERPx_CPTicketItem.

SampleWeight

Database Field: ERPx_CPTicketItem.SampleWeightPercent

Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK

Database Field: ERPx_CPTicketHeader.TicketNumber

Database Field: ERPx_CPTicketHeader.TransactionClassSK

Database Field: ERPx_CPTicketHeader.CreatedDate

Database Field: ERPx_CPTicketHeader.CreatedBy

Identifies the

# of containers the Ticket Item was delivered in.

This is

not required and is

Database Field: ERPx_CPTicketHeader.TicketVersion

editable from the Item's grid until the Ticket is Approved or Posted.

Database Field: ERPx_CPTicketItem.Units

Identifies the

version of the 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.

Database Field: ERPx_CPTicketHeader.TicketVersion