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.04.22 and newer
Table of Contents | ||||
---|---|---|---|---|
|
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 | ||||||
---|---|---|---|---|---|---|
|
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 | ||||
---|---|---|---|---|
|
Page Header
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide |
| ||||||||
Edit |
| ||||||||
Excel |
| ||||||||
Favorites |
| ||||||||
Group By Show/Hide |
| ||||||||
Help |
| ||||||||
New |
| ||||||||
| |||||||||
Quick Column Filter |
| ||||||||
Refresh |
| ||||||||
Saved Layouts |
|
Columns
Column Headers | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Checkbox |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Accrual Amt. |
Database Field: ERPx_CPTicketItem.AccrualAmount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Charge Amt. |
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.
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. |
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. 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.
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.
Database Field: ERPx_CPTicketHeader.FarmerSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Field | Identifies the Field the ticket was harvested from. This can only be edited when initially creating a ticket.
Database Field: ERPx_CPTicketHeader.FieldSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GL Date |
Database Field: ERPx_CPTicketHeader.GLDate | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GL Period |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GL Year |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Gross Amt. |
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.
Database Field: ERPx_CPTicketHeader. | CropSKHarvesterSK | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Hauler | Identifies | the date the ticket was delivered. This can only be edited by editing the 'Delivered' field on 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 | yet been Approved or Posted.
Database Field: ERPx_ | CPTicketHeader.DeliveryDateFarmer | Identifies the Farmer that the ticket is assigned to. This can only be edited when initially creating a ticket.CPTicketHeader.HaulerSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Item | Def - FarmerFor Ticket Items - | Def - Farmer |
For Charge and Accrual Items - Display the Program ID Database Field: ERPx_ | CPTicketHeader.FarmerSKFarmer Class | Identifies the Class assigned to the Farmer on the ticket. This can only be edited from the Farmer Master File.CPTicketItem.ItemSK, ERPx_CPItem.ItemID, ERPx_CPItem.ItemDescription | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Item Type | Def - Farmer Class
| Def - Farmer Class |
| Field | Identifies the Field the ticket was harvested from. This can only be edited when initially creating a ticket.
This is not populated for rows where the 'Row Type' = 'Charge' or 'Accrual'. Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Last Updated | Def - Field
| Def - Field |
Database Field: ERPx_ | CPTicketHeaderCPTicketItem. | FieldSKGross AmountLastUpdated | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Last Updated By | Def - Gross Amt. (GA)
| Def - Gross Amt. (GA) |
| This is a calculated field and can only be edited by changing the weight or price of the line item.Database Field: ERPx_CPTicketItem.LastUser | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Net Amt. | 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 |
Database Field: ERPx_CPTicketItem.NetAmount | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Paid Weight |
| Harvester
| Harvester
| Hauler | Identifies who delivered the crop. This is not required and can be edited on the 'Properties' tab ofThis 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 | For Ticket Items -|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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. | ItemSK, ERPx_CPItem.ItemID, ERPx_CPItem.ItemDescriptionItem CR Acct | Item DR Acct | Item TypePaidWeight | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Price | Item Type (GA) Item Type (GA) |
Database Field: ERPx_CPTicketItem.ItemSK, ERPx_CPItem.ILineTypeEN .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) | Item Last Updated (Date & Time) |
|
Database Field: ERPx_CPTicketItem.LastUser
Row TypeDatabase 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
Row Type Insert excerpt GL Account - Purchases (GA)
GL Account - Purchases (GA) 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.PaidWeight
Insert excerpt
Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPTicketItem.PurchaseGLAccountSK
This is editable from the Item's Grid on the Ticket Record View for tickets that have not Insert excerpt Def - Sample (Ticket Item) Def - Sample (Ticket Item) nopanel true
been Approved or Posted.
Database Field: ERPx_CPTicketItem.
PriceSampleWeight
This is a calculated field that can only be edited by changing either the Insert excerpt Def - Sample Pct Def - Sample Pct nopanel true
'Sample
'
or
Database Field: ERPx_CPTicketItem.SampleWeightPercent
Insert excerpt
Database Field: ERPx_CPTicketItem.SampleWeightSampleWeightPercent
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_MFSite.SiteName, ERPx_CPTicketHeader.SiteSK
This comes from the 'Status' on the 'Home' tab of the Ticket Record View. It is not editable. Insert excerpt Status Status nopanel true
The Statuses that apply to transactions in this Inquiry List View include: Insert excerpt Def - Status Def - Status nopanel true
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
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_CPTicketHeader.TicketNumber
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_CPTicketHeader.TransactionClassSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_CPTicketHeader.CreatedDate
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_CPTicketHeader.CreatedBy
Identifies the
version# of containers the Ticket Item was delivered in.
This is
a system assigned valuenot 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.editable until the Ticket is Approved or Posted.
Database Field:
ERPx_
CPTicketHeaderCPTicketItem.
TicketVersionUnits
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. Insert excerpt Def - Unpaid Weight Def - Unpaid Weight nopanel true
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
Insert excerpt
Database Field: ERPx_CPTicketItem.TotalWeightUnpaidWeight
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 | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_CPTicketHeader.TicketVersion
Related Topics
Expand | ||
---|---|---|
| ||
...