Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

(lightbulb) 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)
typeflat

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.

...

Insert excerpt
Def - Grower Ticket
Def - Grower Ticket
nopaneltrue
 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. 

(lightbulb) 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.06.30 and newer

Table of Contents
exclude(Toolbar Icons|Column Headers|Toolbar Icon)
typeflat

Page Header 

Toolbar Icons

Description
Column Filter Show/Hide

Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue

Edit

Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
nopaneltrue

Excel

Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue

Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
New
Insert excerpt
New - Multi-Select Trans Type - Global 3.0
New - Multi-Select Trans Type - Global 3.0
nopaneltrue
Print
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue

Columns

CropSKDelivery Date the date the ticket was delivered. This can only be edited by editing the 'Delivered' field on yet CPTicketHeader.DeliveryDateIdentifies the Farmer that the ticket is assigned to. This can only be edited when initially creating a ticket.Def - FarmerCPTicketHeader.FarmerSKIdentifies the Class assigned to the Farmer on the ticket. This can only be edited from the Farmer Master File.Def - Farmer Class

Linked Database Field: ERPx_APVendor.VendorClassSK

Identifies the Field the ticket was harvested from. This can only be edited when initially creating a ticket.Def - FieldCPTicketHeaderFieldSKGross AmountDef - Gross Amt. (GA) This is a calculated field and can only be edited by changing the weight or price of the line item.GrossAmount

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.

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 Type

Column Headers

Description
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Accrual Amt.

Insert excerpt
Def - Accrual Amt. (GA)
Def - Accrual Amt. (GA)
nopaneltrue

Database Field: ERPx_CPTicketItem.AccrualAmount

Charge Amt.

Insert excerpt
Def - Charge Amt. (GA)
Def - Charge Amt. (GA)
nopaneltrue

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
nopaneltrue

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)
nopaneltrue
 This is editable from the Ticket Record View.

Database Field: ERPx_CPTicketItem.TotalWeight

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
nopaneltrue

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 from the Vendor Master file. 

Insert excerpt
Def - Farmer
Def - Farmer
nopaneltrue

Database Field: ERPx_APVendor.VendorID

Farmer Name

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
nopaneltrue

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
nopaneltrue

Database Field: ERPx_CPTicketHeader.FieldSK

GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
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
nopaneltrue
 
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
nopaneltrue
 
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)
nopaneltrue
 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 '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
nopaneltrue

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
nopaneltrue

Database Field: ERPx_

Farmer

CPTicketHeader.HaulerSK

Item

For Ticket Items - 

Insert excerpt

Def - Farmer

Item ID & Item Description
Item ID & Item Description
nopaneltrue

For Charge and Accrual Items - Display the Program ID

Database Field: ERPx_

Farmer Class

CPTicketItem.ItemSK, ERPx_CPItem.ItemID, ERPx_CPItem.ItemDescription

Item Type

Insert excerpt

Def - Farmer Class

Item Type (GA)
Item Type (GA)
nopaneltrue

Field

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

(lightbulb) 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

Def - Field

Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_

CPTicketItem.

LastUpdated

Last Updated By

Insert excerpt

Def - Gross Amt. (GA)

Last Updated By
Last Updated By
nopaneltrue

Database Field: ERPx_CPTicketItem.LastUser

Net Amt.
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

Insert excerpt
Def - Net Amt. (GA)
Def - Net Amt. (GA)
nopaneltrue


Insert excerpt
Def - Net Amount Ticket (GA)
Def - Net Amount Ticket (GA)
nopaneltrue
This is a calculated field and is not editable.

Database Field: ERPx_CPTicketItem.NetAmount

Paid Weight

Insert excerpt
Def -

Paid Weight
Def -

Paid Weight
nopaneltrue

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 - HaulerDef - Hauler
nopaneltrue
Item
Insert excerpt
Item ID & Item DescriptionItem ID & Item Description
nopaneltrue

 

(lightbulb) 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 AcctItem DR Acct

PaidWeight

Price

Item Type (GA)

Insert excerpt
Item Type (GA)
Price
Price
nopaneltrue
 
This can only be edited from the Ticket Items Record View.(lightbulb) 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

Last Updated

.Price

Price List

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.

Item Last Updated (Date & Time)

Insert excerpt
Item Last Updated (Date & Time)
Def - Price List
Def - Price List
nopaneltrue

Insert excerptItem Last Updated ByItem Last Updated Bynopaneltrue

Database Field: ERPx_CPTicketItem.LastUser

Row Type

Database Field: ERPx_CPTicketItemCPTicketHeader.LastUpdated

Last Updated By

PriceListSK

Price UOM

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

Purchase GL Account

Insert excerpt
Row Type
GL Account - Purchases (GA)
Row Type (GA)nopaneltrue This is not editable.

Paid Weight Insert excerptDef - Paid WeightDef - Paid Weight

GL Account - Purchases (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. 

(lightbulb) 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

Price

Insert excerptPricePricenopaneltrue This can only be edited by editing the 'Price' on the ticket line on the This is required for any Ticket Item that has a Net Amount <> 0.00. This is editable until the Ticket is Approved or Posted.

Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.PurchaseGLAccountSK

Sample

Insert excerpt
Def - Sample (Ticket Item)
Def - Sample (Ticket Item)
nopaneltrue
 This is editable from the Item's Grid on the Ticket Record View for tickets that have not

yet

been Approved or Posted.

 

Database Field: ERPx_CPTicketItem.

Price

SampleWeight

Sample PercentPct.

Insert excerpt
Def - Sample Pct
Def - Sample Pct
nopaneltrue
 This is a calculated field that can only be edited by changing either the

Ticket Item's

'Sample

Size' or one of the Ticket Header Properties that impact the Ticket

'

s Net Weight

or

Ticket's Sample Size.

Database Field: ERPx_CPTicketItem.SampleWeightPercent

Sample Weight

Insert excerptDef - Sample (Ticket Item)Def - Sample (Ticket Item)nopaneltrue This is editable from the Item's Grid on the Ticket Record View for tickets that have not been Approved or Posted'Sample Pct.' one a Ticket Item.

Database Field: ERPx_CPTicketItem.SampleWeightSampleWeightPercent

Site Name

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

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK

Status

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

Insert excerpt
Def - Status
Def - Status
nopaneltrue
 The Statuses that apply to transactions in this Inquiry List View include:

Insert excerpt
Def - Status - New
Def - Status - New
nopaneltrue

Insert excerpt
Def - Status - Received
Def - Status - Received
nopaneltrue

Insert excerpt
Def - Status - Graded
Def - Status - Graded
nopaneltrue

Insert excerpt
Def - Status - Reviewed
Def - Status - Reviewed
nopaneltrue

Insert excerpt
Def - Status - Approved
Def - Status - Approved
nopaneltrue

Insert excerpt
Def - Status - Ready to Post
Def - Status - Ready to Post
nopaneltrue

Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName

Ticket

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
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
nopaneltrue
 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
nopaneltrue

Database Field: ERPx_CPTicketHeader.TransactionClassSK

Ticket Created

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_CPTicketHeader.CreatedDate

Ticket Created By

Insert excerpt
Created By
Created By
nopaneltrue

Database Field: ERPx_CPTicketHeader.CreatedBy

Ticket VersionUnits

Identifies the

version

# of containers the Ticket Item was delivered in.

 

This is

a system assigned value

not required 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 excerptDef - VersionDef - Versionnopaneltrue

editable until the Ticket is Approved or Posted.

Database Field:

 

ERPx_

CPTicketHeader

CPTicketItem.

TicketVersion

Units

Unpaid Weight

Insert excerpt
Def - Unpaid Weight
Def - Unpaid Weight
nopaneltrue
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.

(lightbulb) 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

Weight

Insert excerptDef - Delivered Wt. (GA)Def - Delivered Wt. (GA)nopaneltrue This is editable from the Ticket Record Viewwith a 0.00 Price. Items with a negative price are not considered 'Unpaid'.

Database Field: ERPx_CPTicketItem.TotalWeightUnpaidWeight

Weight UOMVersion

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

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.

Insert excerpt
Def - Version
Def - Version
nopaneltrue

Database Field: ERPx_CPTicketHeader.TicketVersion

Related Topics


Expand
titlePage Definitions


...