Column Headers | Description |
---|
Checkbox | Insert excerpt |
---|
| Checkbox |
---|
| Checkbox |
---|
nopanel | true |
---|
|
|
Accruals | 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_CPTicketHeader.GrossAccrualsAmount |
Charges | 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_CPTicketHeader.GrossChargesAmount |
Created | Insert excerpt |
---|
| Created |
---|
| Created |
---|
nopanel | true |
---|
|
Database Field: ERPx_CPTicketHeader.CreatedDate |
Created By | Insert excerpt |
---|
| Created By |
---|
| Created By |
---|
nopanel | true |
---|
|
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. 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 Weight |
---|
| Def - Delivered Weight |
---|
nopanel | true |
---|
| This is a calculated field that cannot be edited unless either the 'Weight In', 'Weight Out', or 'Total Tare' amounts are edited.Database Field: ERPx_CPTicketHeader.NetWeight |
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 |
---|
|
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 - Ticket Gross (GA) |
---|
| Def - Ticket Gross (GA) |
---|
nopanel | true |
---|
| This 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. | Insert excerpt |
---|
| Def - Gross Weight |
---|
| Def - Gross Weight |
---|
nopanel | true |
---|
| This is a calculated field that cannot be edited unless either the 'Weight In' or 'Weight Out' amounts are edited.
Database Field: ERPx_CPTicketHeader.GrossWeight |
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 |
Hold Code | Identifies 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. Insert excerpt |
---|
| Def - Hold Code |
---|
| Def - Hold Code |
---|
nopanel | true |
---|
|
Database Fields: ERPx_MFHoldCode.HoldCode, ERPx_CPTicketHeaderHold.HoldCodeSK |
Last Updated | Insert excerpt |
---|
| Last Updated |
---|
| Last Updated |
---|
nopanel | true |
---|
|
Database Field: ERPx_CPTicketHeader.LastUpdated |
Last Updated By | Insert excerpt |
---|
| Last Updated By |
---|
| Last Updated By |
---|
nopanel | true |
---|
|
Database Field: ERPx_CPTicketHeader.LastUser |
Net Amt. | Insert excerpt |
---|
| Def - Net Amount Ticket (GA) |
---|
| Def - Net Amount Ticket (GA) |
---|
nopanel | true |
---|
| This is a calculated field and is not editable.
Database Field: ERPx_CPTicketHeader.NetTicketAmount |
Paid Wt. | Insert excerpt |
---|
| Def - Paid Weight |
---|
| Def - Paid 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: Paid Weight is calculated for line-items with a non-zero Price. Items with a negative price are considered 'paid'.
Database Field: ERPx_CPTicketHeader.PaidWeight |
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 |
Sample Size | Insert excerpt |
---|
| Def - Sample Size (Ticket) |
---|
| Def - Sample Size (Ticket) |
---|
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_CPTicketHeader.SampleWeight |
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 Inquiry 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 |
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. - If the Tare is entered on the Tare tab, this field will populate from the detail totals and be disabled.
- If the Tare is being managed from the Home tab, it is editable until the Ticket is in a Status of Approved, Ready to Post, or Posted.
Insert excerpt |
---|
| Def - Tare Weight |
---|
| Def - Tare Weight |
---|
nopanel | true |
---|
|
Database Field: ERPx_CPTicketHeader.ContainerTare |
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_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. Insert excerpt |
---|
| Def - Version |
---|
| Def - Version |
---|
nopanel | true |
---|
|
Database Field: ERPx_CPTicketHeader.TicketVersion |
Weight In | Insert excerpt |
---|
| Def - Weight In |
---|
| Def - Weight In |
---|
nopanel | true |
---|
| This can be edited from the 'Weight In' field on the Ticket Record View for tickets that have not yet been Approved or Posted.
Database Field: ERPx_CPTicketHeader.WeightIn |
Weight Out | Insert excerpt |
---|
| Def - Weight Out |
---|
| Def - Weight Out |
---|
nopanel | true |
---|
| This can be edited from the 'Weight Out' field on the Ticket Record View for tickets that have not yet been Approved or Posted.
Database Field: ERPx_CPTicketHeader.WeightOut |