Fish Ticket Item History Inquiry
This inquiry also contains columns for each Attribute that is set up for the Fisherman Accounting → Fish Ticket transactions. Because these are user defined, they are not included in the default view but can be added a saved column layout.
Software Version: 2026.02.26 and newer
Page Header
Search
Filter Items | Description |
|---|---|
Auto Hide Filters | |
Auto Refresh on Open | |
Date Type |
|
Date Range | |
Include |
|
Saved Searches | |
Search |
|
Ticket Number | A text box to enter all or part of a ticket number. |
Version | A single select lookup to specify which Ticket Version(s) to return. The options include:
|
Page Detail
Toolbar Icons | Description |
|---|---|
Column Filter Show/Hide | |
Excel | |
Favorites | |
Group By Show/Hide | |
Help | |
More Actions |
|
Quick Column Filter | |
Refresh | |
Saved Layouts | |
Search Options | |
Fields | Description |
Avg Temp | Displays the average temperature of the Refrigerated Seawater system for the corresponding Fish Ticket. This field is calculated as the average of all temperature values entered on the RSW Temp tab of the Fish Ticket record view. The total of all entered temperature values is divided by the number of values provided. For example, if the values 30.5, 31, and 30 are entered, 30.5 will display in this field ((30.5 + 31 + 30) ÷ 3). This is a system calculated field and is not editable. |
Buying Station | Displays the Buying Station name assigned in the ticket properties. This is not required and can be edited from the 'Buying Station Name' field on the 'Properties' tab of the Fish Ticket Record View. Database Field: ERPx_APDeliveryTicketHeader.BuyingStationName |
CFECID |
Database Field: ERPx_APDeliveryTicketHeader.CFECID |
Chill Type |
Database Fields: ERPx_APChillType. ChillTypeID, ERPx_APDeliveryTicketHeader.ChillTypeSK |
Condition | Identifies the Condition for the Fish Ticket Item. Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APCondtition. ConditionID + ERPx_APCondition. ConditionDescription |
Created |
Database Field: ERPx_APDeliveryTicketHeader.CreatedDate |
Created By |
Database Field: ERPx_APDeliveryTicketHeader.CreatedBy |
Delivered |
The Delivery Date can be also updated from the Tickets list view using the Mass Update tool. Database Field: ERPx_APDeliveryTicketHeader.DeliveryDate |
Delivery # | This is required for the transaction to be approved or posted. It can be edited from the 'Delivery #' field on the 'Home' tab of the Fish Ticket Record View. Database Field: ERPx_APDeliveryTicketHeader.DeliveryNumber |
Disposition | Identifies the 'Disposition' for the Fish Ticket Item. Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.DispositionSK, ERPx_APDisposition. DispositionID + ERPx_APDisposition. DispositionDescription |
Dock Delivery | A Yes/No value to show if the Ticket was delivered to the Dock. This is required and can be edited from the 'Dock Delivery' field on the 'Home' tab of the Fish Ticket Record View. Database Field: ERPx_APDeliveryTicketHeader.DockDeliveryEN |
Dual Permit | Displays if there were combined permits used for the Ticket. This is a Yes/No value and when set to Yes indicates that an additional permit holder was used. When set to 'No', this field displays is blank. This is editable on the Ticket record view 'Properties' tab for the 'Dual Permit' property when the Ticket is in a status of New. Database Field: APDeliveryTicketHeader.DualPermit |
Dual Permit Holder | Displays the permit holders name when combined permits were used on the Ticket. This is editable on the Ticket record view 'Properties' tab for the 'Dual Permit ID' property when the Ticket is in a status of New and the Dual Permit property is set to Yes. Database Fields: ERPx_APVendor.VendorName, APDeliveryTicketHeader.DualPermitVendorPermitSK , APVendorPermit.VendorPermitSK |
Dual Permit ID | Displays the permit ID of the Dual Permit Holder when combined permits were used on the Ticket. This is editable on the Ticket record view 'Properties' tab for the 'Dual Permit ID' property when the Ticket is in a status of New and the Dual Permit property is set to Yes. Database Fields: APDeliveryTicketHeader.DualPermitVendorPermitSK , APVendorPermit.Permit |
Ext. Amount | Identifies the Extended Amount of the Ticket Item. The 'Ext. Amount' is calculated as: [Weight] x [Price]. |
Fishing Began | Identifies the date the fishing trip began and displays the date entered on the corresponding Fish Ticket Record View. This field can be edited at any time from the 'Home tab' of the Fish Ticket Record View, even after posting. Database Field: ERPx_APDeliveryTicketHeader.FishingBegan |
Fishing Period | Identifies the period during which the fish ticket catch was made. This is not required and can be edited from the 'Fishing Period' field on the 'Properties' tab of the Fish Ticket Record View. Database Field: ERPx_APDeliveryTicketHeader.FishingPeriod |
Fishing Vessel |
Database Fields: ERPx_APVessels.VesselName, ERPx_APVessels.VesselNumber, ERPx_APDeliveryTicketHeader.VesselSK |
Floating | Identifies whether or not the fish were "floating" or suspended when they were offloaded. This is a Yes/No lookup that is required. It defaults to "No". This is not required and can be edited from the 'Floating' field on the 'Properties' tab of the Fish Ticket Record View while the transaction is in a Status of New. Database Field: ERPx_APDeliveryTicketHeader.Floating |
Gear |
Database Fields: ERPx_APGear.GearDescription, ERPx_APVendorPermit.GearSK, ERPx_APDeliveryTicketHeader.VendorPermitSK |
GL Date |
Database Field: ERPx_APDeliveryTicketHeader.GLDate |
GL Period |
|
GL Year |
|
Grade | Identifies the Grade of the Fish Ticket Item. Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.GradesSK, ERPx_APGrade. GradeID + ERPx_APGrade. GradeDescription |
Gross Amount | Identifies the Gross Amount of the Ticket Item. The 'Gross Amount' is calculated as: [Ext. Amount] + [Premiums]. Database Field: ERPx_APDeliveryTicketLine.GrossAmount |
Headland | Displays the nearest headland to where the fish were caught. This is not required and can be edited from the 'Headland' field on the 'Properties' tab of the Fish Ticket Record View. Database Field: ERPx_APDeliveryTicketHeader.Headland |
Landed | Represents the Landed Date of the ticket. This is required and can be edited from the 'Landed' field on the 'Home' tab of the Fish Ticket Record View. Database Field: ERPx_APDeliveryTicketHeader.TicketDate |
Landing # | Identifies the unique landing report number issued by eLandings. This is only required for eLandings tickets. It can be edited from the 'Landing #' field on the 'Properties' tab of the Fish Ticket Record View. Database Field: ERPx_APDeliveryTicketHeader.LandingNumber |
Last Updated |
Database Field: ERPx_APDeliveryTicketHeader.LastUpdated |
Last Updated By |
Database Field: ERPx_APDeliveryTicketHeader.LastUser |
Major Specie | Identifies the Major Specie that the Specie belongs to. Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.MajorSpecie |
Mgt. Prog. |
Database Fields: ERPx_APManagementPrograms.ManagementProgramID, ERPx_APManagementPrograms.ManagementProgramName, ERPx_APDeliveryTicketHeader.ManagementProgramSK |
Net Amount | Identifies the Net Amount of the Ticket Item. The 'Net Amount' is calculated as: [Gross Amount] - [Tax - Fisherman]. |
Net Weight | Identifies the Net Weight of the Ticket Item. The 'Net Weight' is calculated as: [Weight] * [Wt. Mod]. |
Paid Account |
Database Fields: ERPx_APVendor.VendorName, ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK |
Paid Account Class | Identifies the Account Class assigned to the Fisherman that was/will be paid for the Fish Ticket. |
Payable Account | |
Payable Account Description | The GL Account Description of the Payable Account. |
Permit | Identifies the permit number that is associated to the Permit Holder. This is required and can be edited from the 'Permit' field on the 'Permits' tab of the Fishermen & Tenders Record View. Database Fields: ERPx_APVendorPermit.Permit, ERPx_APDeliveryTicketHeader.VendorPermitSK |
Permit Holder |
Database Fields: ERPx_APVendor.VendorSK.VendorName , ERPx_APDeliveryTicketHeader.PermitHolderVendorSK |
Port of Landing | Identifies the location the fish or shellfish were unloaded. This is required and can be edited from the 'Port of Landing' field on the 'Properties' tab of the Fish Ticket Record View. Database Fields: ERPx_APPort.PortDescription, ERPx_APDeliveryTicketHeader.PortSK |
Prem - Chill | Identifies if the Ticket Item has a "Chill" type Premium assigned. If so, it will display as "Yes". If not, it will be blank. A 'Chill' Premium is defined as a Premium where the Premium's 'Program Class' has been assigned a Group of "Chill". |
Prem - Chill Amt | Identifies the dollar amount of the "Chill" type premiums assigned to the Ticket Item. |
Prem - Dock | Identifies if the Ticket Item has a "Dock" type Premium assigned. If so, it will display as "Yes". If not, it will be blank. A 'Dock' Premium is defined as a Premium where the Premium's 'Program Class' has been assigned a Group of "Dock". |
Prem - Dock Amt | Identifies the dollar amount of the "Dock" type premiums assigned to the Ticket Item. |
Prem - Other | Identifies if the Ticket Item has a "Other" type Premium assigned. If so, it will display as "Yes". If not, it will be blank. An 'Other' Premium is defined as a Premium where the Premium's 'Program Class' has been assigned a Group of "Other". |
Prem - Other Amt | Identifies the dollar amount of the "Other" type premiums assigned to the Ticket Item. |
Premiums | Displays the total amount of all the Premiums assigned to the Ticket Item. |
Price | Identifies the Price assigned to the Ticket Item. |
Price List ID |
Database Fields: ERPx_MFPriceListHeader.PriceListID, ERPx_APDeliveryTicketHeader.PriceListHeaderSK |
Price UOM | |
Processor ID | Identifies the processor identification code of the buyer. This is required and can be edited from the 'Processor ID' default preference or the 'Processor ID' field on the 'Properties' tab of the Fish Ticket Record View if no value is specified in the preference. Database Field: ERPx_APDeliveryTicketHeader.ProcessorID |
Purchase Account | |
Purchase Account Description | The GL Account Description of the Payable Account. |
Reprice Comment |
Database Field: ERPx_APDeliveryTicketHeader.RepriceComment |
Season | Identifies which fishing season the delivery occurred in. This is not required and can be edited from the 'Season' field on the 'Properties' tab of the Fish Ticket Record View. Database Fields: ERPx_APSeasons.SeasonName, ERPx_APDeliveryTicketHeader.SeasonSK |
Site Processed |
Database Fields: ERPx_MFSite.SiteName, ERPx_APDeliveryTicketHeader.SiteProcessedSiteSK |
Slide | Identifies whether or not the fish were offloaded using a slide. This is a Yes/No Lookup that is required. It defaults to "No". This is not required and can be edited from the 'Slide' field on the 'Properties' tab of the Fish Ticket Record View while the transaction is in a Status of New. Database Field: ERPx_APDeliveryTicketHeader.Slide |
Sold - Condition | Identifies the Condition the Fish Ticket Item was sold in. Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SoldConditionSK, ERPx_APContition. ContitionID + ERPx_APContition. ContitionDescription |
Source | Identifies whether the Fish Ticket was manually entered or imported from eLandings. This is a non-editable text box that is required. If the ticket was manually entered, it will be "Manual". If the ticket was imported from eLandings, it will say "eLandings" + the elandings XML schema version (e.g. ELandings2.5). Database Field: ERPx_APDeliveryTicketHeader.Source |
Specie | Identifies the ID and Description of the Specie assigned to the Ticket Item. Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.SpecieID + ERPx_APSpecie.SpecieName |
Status | |
Tax - Borough | Identifies if the Ticket Item has a "Borough Tax" assigned. If so, it will display as "Yes". If not, it will be blank. A "Borough Tax" is defined as a Tax where the Tax Program's 'Program Class' has been assigned a Group of "Borough". |
Tax - Borough Amt | Identifies the dollar amount of the "Borough Tax" assigned to the Ticket Item. |
Tax - City | Identifies if the Ticket Item has a "City Tax" assigned. If so, it will display as "Yes". If not, it will be blank. A "City Tax" is defined as a Tax where the Tax Program's 'Program Class' has been assigned a Group of "City". |
Tax - City Amt | Identifies the dollar amount of the "City Tax" assigned to the Ticket Item. |
Tax - Company | Identifies the total amount of tax, from all the Tax Programs, that is expensed to the Company. |
Tax - Fisherman | Identifies the total amount of tax, from all the Tax Programs, that was/is being withheld from the Fisherman. |
Tax - Observer | Identifies if the Ticket Item has an "Observer Tax" assigned. If so, it will display as "Yes". If not, it will be blank. An "Observer Tax" is defined as a Tax where the Tax Program's 'Program Class' has been assigned a Group of "Observer". |
Tax - Observer Amt | Identifies the dollar amount of the "Observer Tax" assigned to the Ticket Item. |
Tax - Other | Identifies if the Ticket Item has an "Other Tax" assigned. If so, it will display as "Yes". If not, it will be blank. An "Other Tax" is defined as a Tax where the Tax Program's 'Program Class' has been assigned a Group of "Other". |
Tax - Other Amt | Identifies the dollar amount of the "Other Tax" assigned to the Ticket Item. |
Tax - State | Identifies if the Ticket Item has a "State Tax" assigned. If so, it will display as "Yes". If not, it will be blank. A "State Tax" is defined as a Tax where the Tax Program's 'Program Class' has been assigned a Group of "State". |
Tax - State Amt | Identifies the dollar amount of the "State Tax" assigned to the Ticket Item. |
Tax - Total | Identifies the total amount of tax, from all the Tax Programs, for the Ticket Item. It is calculated as: [Tax - Fisherman] + [Tax - Company] |
Tax Price | Identifies the Tax Price assigned to the Ticket Item. The Tax Price is the price used for calculating the tax basis amount. |
Tender |
Database Fields: ERPx_APVendor.VendorName, ERPx_APDeliveryTicketHeader.TenderDeliveredVendorSK |
Tender Vessel | Displays the 'Vessel Name' of the Vessel assigned to the Tender. This is not required and can be edited from the 'Primary Vessel' field in the 'Properties' tab of the Fishermen & Tenders record view for the selected Tender. Database Fields: ERPx_APVessels.VesselName, ERPx_APVendor.TenderVesselSK, ERPx_APDeliveryTicketHeader.TenderDeliveredVendorSK |
Ticket # |
Database Field: ERPx_APDeliveryTicketHeader.TicketNumber |