Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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.01.31 and newer
...
Column Headers | Description | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Checkbox |
| ||||||||||||||||||||||||||||||||||||||||
Accruals | |||||||||||||||||||||||||||||||||||||||||
Charges | |||||||||||||||||||||||||||||||||||||||||
Created | This column has not yet been added.
Database Field: ERPx_CPTicketHeader.CreatedDate | ||||||||||||||||||||||||||||||||||||||||
Created By | This column has not yet been added.
Database Field: ERPx_CPTicketHeader.CreatedBy | ||||||||||||||||||||||||||||||||||||||||
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.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.
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. 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.
Database Field: ERPx_CPTicketHeader.FieldSK | ||||||||||||||||||||||||||||||||||||||||
Gross Amount | Displays the Extended Amount of the line item. 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 | This column has not yet been added. 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.
Database Field: ERPx_CPTicketHeader.HarvesterSK | ||||||||||||||||||||||||||||||||||||||||
Hauler | This column has not yet been added. 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.
Database Field: ERPx_CPTicketHeader.HaulerSK | ||||||||||||||||||||||||||||||||||||||||
Last Updated | This column has not yet been added.
Database Field: ERPx_CPTicketItem.LastUpdated | ||||||||||||||||||||||||||||||||||||||||
Last Updated By | This column has not yet been added.
Database Field: ERPx_CPTicketItem.LastUser | ||||||||||||||||||||||||||||||||||||||||
Item |
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 can only be edited from the Ticket Items Record View.
Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN | ||||||||||||||||||||||||||||||||||||||||
Row Type | |||||||||||||||||||||||||||||||||||||||||
Paid Weight | Identifies the weight of the line item with a non-zero 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.
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 | Identifies the price of the line item. 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. This is a calculated field and can be edited by editing the 'Sample Size' from the Item's Grid on the Ticket Record View for tickets that have not been Approved or Posted. Database Field: ERPx_CPTicketItem.SampleWeightPercent | ||||||||||||||||||||||||||||||||||||||||
Sample Weight | Identifies the weight of the sample that graded out for the line item. This is required and can be edited 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 |
Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK | ||||||||||||||||||||||||||||||||||||||||
Status |
Received: Graded: Reviewed:
Database Field: ERPx_CPTicketHeader.TicketStatusSK, ERPx_CPTicketStatus.StatusName | ||||||||||||||||||||||||||||||||||||||||
Ticket |
Database Field: ERPx_CPTicketHeader.TicketNumber | ||||||||||||||||||||||||||||||||||||||||
Ticket Class |
Database Field: ERPx_CPTicketHeader.TransactionClassSK | ||||||||||||||||||||||||||||||||||||||||
Ticket Version | This column has not yet been added. Identifies the version of the Ticket. A blank value signifies a version 1 ticket. All ticket versions greater than 1 will display.
Database Field: ERPx_CPTicketHeader.TicketVersion | ||||||||||||||||||||||||||||||||||||||||
Unpaid Weight | Identifies the weight of the line item 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_CPTicketItem.UnpaidWeight | ||||||||||||||||||||||||||||||||||||||||
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.
Database Field: ERPx_CPTicketItem.TotalWeight | ||||||||||||||||||||||||||||||||||||||||
Weight UOM |
...