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 '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 |
| Item | For Ticket Items - | Insert excerpt |
|---|
| 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.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_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 |
|---|
|
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 |
| Price | 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 |
| 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. | Insert excerpt |
|---|
| Def - Price List |
|---|
| Def - Price List |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_CPTicketHeader.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 |
|---|
| 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 Fields: ERPx_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 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.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 | 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 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 - 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 |
| Units | Identifies the # of containers the Ticket Item 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 - 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.
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 |
| Version | 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. | Insert excerpt |
|---|
| Def - Version |
|---|
| Def - Version |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_CPTicketHeader.TicketVersion |