Insert excerpt
This list view also contains columns for each Attribute that is set up under 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 | ||||
---|---|---|---|---|
|
Page Header
...
Toolbar Icons
...
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
This list view also contains columns for each Attribute that is set up under 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 | ||||
---|---|---|---|---|
|
Page Header
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide |
| ||||||||||||||||
Delete |
| ||||||||||||||||
Edit |
| ||||||||||||||||
Excel |
| ||||||||||||||||
Favorites |
| ||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||
Help |
| ||||||||||||||||
Mass Update |
| ||||||||||||||||
More Actions |
| ||||||||||||||||
New |
| ||||||||||||||||
Notes |
| ||||||||||||||||
| |||||||||||||||||
Quick Column Filter |
| ||||||||||||||||
Refresh |
| Mass Update||||||||||||||||
Saved Layouts |
| Mass Update - Global
| Mass Update
| true |
|
Columns
Column Headers | Description | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Checkbox | More Actions - Global 3.0
| More Actions - Global 3.0 |
| ||||||||||||||||||||||||||||
Accruals | New - Multi-Select Trans Type - Global 3.0
| New - Multi-Select Trans Type - Global 3.0 |
| PrintPrint - LV 3.0
| Print - LV 3.0 |
| Quick Column FilterDatabase Field: ERPx_CPTicketHeader.GrossAccrualsAmount | ||||||||||||||||||||||||
Charges |
| Quick Column Filter | Quick Column Filter
| RefreshRefresh - Global 3.0
| Refresh - Global 3.0 |
| Saved LayoutsDatabase Field: ERPx_CPTicketHeader.GrossChargesAmount | ||||||||||||||||||||||||
Column Headers | Description | ||||||||||||||||||||||||||||||
Created | Column Layouts for Framework 3.0 - Global
| Column Layouts for Framework 3.0 - Global | |||||||||||||||||||||||||||||
Checkbox
|
Columns
Database Field: ERPx_CPTicketHeader.CreatedDate | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Created By |
| Accruals | Displays the sum of the Extended Amount of all 'Accruals'. This is a calculated field and can only be edited by changing the Rate on one or more Accrual lines.Database Field: ERPx_CPTicketHeader. | GrossAccrualsAmountCreatedBy | Charges | Displays the sum of the Extended Amount of all 'Charges'. This is a calculated field and can only be edited by changing the Rate on one or more Charge lines.|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Crop | 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. | GrossChargesAmountCropSK | Created | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Created | Created | nopanel | true|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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. | CreatedDateCreated ByDeliveryDate | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Delivered Wt. | Created By
| Created By |
Database Field: ERPx_CPTicketHeader. | CreatedByNetWeight | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Farmer Class | Identifies the | Crop that was harvested from the Field Class assigned to the | TicketFarmer. This can only be | edited when initially creating a ticketedited by changing the 'Vendor Class ID' value on the Vendor Record View.
| Crop
| Crop
Database Field: | ERPx_ | CPTicketHeaderAPVendor. | CropSKVendorClassSK | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Farmer ID | Identifies the ID of the | date Farmer that the ticket | was deliveredis assigned to. This can only be edited by | editing changing the ' | DeliveredVendor ID' | field value on the | Ticket Record View for tickets that have not yet been Approved or Posted.Vendor Record View.
Database Field: | ERPx_ | CPTicketHeaderAPVendor. | DeliveryDateVendorID | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Farmer Name | Identifies the Farmer that the ticket is assigned to. This can only be edited | when initially creating a ticketby changing the 'Vendor Name' value on the Vendor Record View.
Database Field: ERPx_CPTicketHeader.FarmerSK | Farmer Class||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Field | Identifies the | Class assigned to the Farmer on Field the ticket was harvested from. This can only be edited | from the Farmer Master Filewhen initially creating a ticket.
| Farmer Class
| Farmer Class
| Linked Database Field: ERPx_ | APVendor.VendorClassSKField | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Def - Field | Def - Field | nopanel | trueCPTicketHeader.FieldSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GL Date |
Database Field: ERPx_CPTicketHeader. | FieldSKGLDate | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GL | DatePeriod |
| Date
| Date
| required for required for the transaction to be approved or posted. It is not directly editable. It can | be edited from the 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 |
| Period
| Period
| only be changed by editing | the the 'GL Date' field on the 'Properties' tab of the Ticket Record View for tickets that have not been Approved or Posted. | This This field is not stored in the database. | GL Year||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Gross Amt. | GL Year
| GL Year |
| 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 Amount | Displays the sum of the Extended Amount for all line items. This is a calculated field and can only be edited by changing the weight or price of one, or more line itemsThis is a calculated field that is only editable by changing the weights and/or prices of one or more ticket items. Database Field: ERPx_CPTicketHeader.GrossTicketAmount | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Gross Wt. |
Database Field: ERPx_CPTicketHeader. | GrossTicketAmountGrossWeight | Gross Weight||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Harvested | Identifies the | 'Gross Weight' from the Ticket. This is a calculated field that date the ticket was harvested. This can only be edited by | changing either editing the ' | Weight In' or 'Weight Out' fields Harvested' field on the Ticket Record View | , for tickets that have not yet been Approved or Posted. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Def - Gross Weight | Def - Gross Weight | nopanel | trueDatabase Field: ERPx_CPTicketHeader. | GrossWeightHarvestDate | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Harvester | Identifies | the date the ticket was harvested. This can only be edited by editing the 'Harvested' field on 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 | yet been Approved or Posted.
Database Field: ERPx_CPTicketHeader. | HarvestDateHarvesterSK | Harvester||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Hauler | 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.
| Harvester
| Harvester
Database Field: ERPx_CPTicketHeader. | HarvesterSKHaulerSK | Hauler|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Hold Code | Identifies | who delivered the crop. the Hold Code that has been assigned to the ticket. 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.
| Hauler
| Hauler
Database | Field:Fields: ERPx_MFHoldCode.HoldCode, ERPx_ | CPTicketHeaderCPTicketHeaderHold. | HaulerSKHoldCodeSK | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Last Updated |
Database Field: ERPx_CPTicketHeader.LastUpdated | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Last Updated By |
| true | Net Amount | Displays the sum of the Extended Amount for all line items, minus any applied 'Charges'. This is a calculated field and is not editable.
Database Field: ERPx_CPTicketHeader. | NetTicketAmountLastUser | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Net | WeightIdentifies the 'Weight In' from the Ticket. This can be edited from the 'Weight In' field on the Ticket Record View for tickets that have not yet been Approved or Posted.Amt. |
Database Field: ERPx_CPTicketHeader.NetTicketAmount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Paid Wt. |
| Net
| Net
| On Hold | Displays as "Yes" for Tickets that have a Hold Code assigned, otherwise this is blank. This is not required and can be edited on the 'Properties' tab ofDef - Hold Code | nopanel | true
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Def - Hold Code | Note: Paid Weight is calculated for line-items with a non-zero Price. Items with a negative price are considered 'paid'. Database Field: ERPx_ | CPTicketHeaderHoldCPTicketHeader. | HoldCodeSKPaidWeight | Paid Weight||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Price List | Identifies the | sum of the weight of all the ticket line items with a non-zero price. Price List associated with the Farmer on the ticket. 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. changing the price list assigned to the farmer.
Database Field: ERPx_CPTicketHeader.PriceListSK | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sample Size |
| Paid Weight
| Paid Weight
| Note: Paid Weight is calculated for line-items with a non-zero Price. Items with a negative price are considered 'paid'This is editable from the Home tab on the Ticket Record View for tickets that have not been Approved or Posted. Database Field: ERPx_CPTicketHeader. | PaidWeightPrice 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.SampleWeight | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Site Name |
| Price List
| Price List
Database | Field:Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader. | PriceListSKSample Weight | Identifies the weight of the delivery that was selected as a sample. This is required and can be edited from the 'Sample Size' field on the 'PropertiesSiteSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Status |
| Ticket Record View for tickets that have not been Approved or Posted.Ticket Record View. It is not editable.
| Site |
| This comes from the 'Site' lookup on the Ticket Record View. It is not editable.
| Site
| Site
|
| This comes from the 'Status' on the 'Home' tab of the Ticket Record View. It is not editable.
| The Statuses that apply to transactions in this Inquiry include:
| New
| - New
Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Ticket | Reviewed:
| 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 | Def - Status - Approved
| Def - Status - Approved |
| Status - Ready to Post
| Status - Ready to Post
Database Field: ERPx_CPTicketHeader. | TicketStatusSK, ERPx_CPTicketStatus.StatusNameTicket | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Transaction ID | Transaction ID | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopanel | true | Ticket Class | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Transaction Class | Transaction Class | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopanel | true | TransactionClassSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total Tare | Identifies the 'Total Tare' weight of delivery. This is not required and is editable from either the 'Total Tare' field on the Home tab or by editing the details on the Tare tab of the ticket record view.
Database Field: ERPx_CPTicketHeader.ContainerTare | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Units | Identifies the # of containers the Ticket Item was delivered in. This is not required and is editable from the Item's Grid on the Ticket Record View for tickets that have not been Approved or Posted. Database Field: ERPx_CPTicketHeader.Units | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Unpaid Wt. |
| Transaction Class - General
| Transaction Class - General||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopanel | true | Ticket Version | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Def - Version | Def - Version | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopanel | true | Unpaid Weight | Identifies the sum of the weight of all the ticket line items 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
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_CPTicketHeader.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.
| Unpaid Weight
| Unpaid Weight
| 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_CPTicketHeader. | UnpaidWeightTicketVersion | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Weight In |
| Identifies the 'Weight In' from the Ticket.
Database Field: ERPx_CPTicketHeader.WeightIn | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Weight Out |
| In
| In
| Database Field:
| ERPx_CPTicketHeader.WeightInWeight Out | Identifies the 'Weight Out' from the Ticket.This can be edited from the 'Weight Out' field on the Ticket Record View for tickets that have not yet been Approved or Posted. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Def - Weight Out | Def - Weight Out | nopanel | trueDatabase Field: ERPx_CPTicketHeader.WeightOut |
Related Topics
Expand | ||
---|---|---|
| ||
...