/
Ticket Line Stat Area History Inquiry

Ticket Line Stat Area History Inquiry

Aug 24, 2023

 The purpose of this inquiry is to display Ticket Items, on posted Fish Tickets, by Stat Area and ratio of lbs caught for each. Users may utilize search options to filter the results. From this inquiry, users can open the Ticket, Journal Details, Ticket Reprice, or the Void/Correct page.

 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: 2023.08.31 and newer

[ 1 Page Header ] [ 1.1 Search ] [ 1.1.1 Filter Items ] [ 1.2 Page Detail ] [ 1.2.1 Related Topics ]

Page Header

Search

Filter Items

Description

Filter Items

Description

Auto Hide Filters

Auto Refresh on Open

Date Type

  • Delivered Date

  • GL Date

  • Landed Date

Date Range

Help

Include

  • Voids. Select if you want Items from Voided Tickets. Defaults as unselected.

Saved Searches

Search

  • Ticket

  • Delivery #

  • Site Processed ID

  • Ticket Class

  • Permit

  • Fishing Vessel

  • Tender

Stat Area

A text box to enter all or part of a Stat Area. 

Version

A single select lookup to specify which Ticket Version(s) to return. The options include:

  • All Versions. Use this method if you want all versions of the the ticket.

  • Current Posted Version. Use this method if only want to return the 'Current' version of the the ticket. This is the default value.

Page Detail

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

More Actions

  • RV: Journal Details: Opens the Journal Details page. 

  • Item Reprice: Opens the 'Fish Ticket Items Reprice' page.

  • Premium Reprice: Opens the 'Fish Ticket Premium Reprice' page.

  • Void/Correct: Opens the 'Void/Correct Fish Ticket' page.

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

Checkbox

Chill Type

 This is not required and can be edited from the 'Chill Type' field on the 'Home' tab of the Fish Ticket Record View. 

Database Fields: ERPx_APChillType. ChillTypeID, ERPx_APDeliveryTicketHeader.ChillTypeSK

Condition

Identifies the Condition for the Fish Ticket Item.

Database Fields: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APCondition. ConditionID + ERPx_APCondition. ConditionDescription

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

Delivered

This is required and can be edited from the 'Delivered' field on the 'Home' tab of the Fish Ticket Record View.

 The Delivery Date can be also updated from the Tickets list view using the Mass Update tool. 

Database Field: ERPx_APDeliveryTicketHeader.DeliveryDate

DeliveryTicketLineSK

Identifies the unique identifier of the line item.

Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketLineSK

Disposition

Identifies the 'Disposition' for the Fish Ticket Item. 

Database Fields: 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

Ext. Amount

Identifies the Extended Amount of the Ticket Item.

The 'Ext. Amount' is calculated as: [Weight] x [Price].

Fishing Vessel

This is not required and can be edited from the 'Fishing Vessel' field on the 'Home' tab of the Fish Ticket Record View.

Database Fields: ERPx_APVessels.VesselName, ERPx_APVessels.VesselNumber, ERPx_APDeliveryTicketHeader.VesselSK

Gear

This is required and can be edited from the 'Gear' field on the 'Home' tab of the Fish Ticket Record View.

Database Fields: ERPx_APGear.GearDescription, ERPx_APVendorPermit.GearSK, ERPx_APDeliveryTicketHeader.VendorPermitSK

GL Date

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 Fish Ticket Record View.

Database Field: ERPx_APDeliveryTicketHeader.GLDate

GL Period

 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 Fish Ticket Record View. This field is not stored in the database.

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 Fish Ticket Record View. This field is not stored in the database.

Grade

Identifies the Grade of the Fish Ticket Item.

Database Fields: 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

Item ID

Database Fields: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.ItemID

Item ID Description

Database Fields: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.GeneratedItemDescription

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

Major Specie

Identifies the Major Specie that the Specie belongs to.

Database Fields: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.MajorSpecie

Net Amount

Identifies the Net Amount of the Ticket Item. The 'Net Amount' is calculated as: [Gross Amount] - [Tax - Fisherman].

Database Field: ERPx_APDeliveryTicketLine.NetAmount

Net Weight

Identifies the Net Weight of the Ticket Item. The 'Net Weight' is calculated as: [Weight] * [Wt. Mod].

Database Field: ERPx_APDeliveryTicketLine.NetWeight 

Paid Account

This is required and can be edited from the 'Paid Account' field on the 'Home' tab of the Fish Ticket Record View.

Database Fields: ERPx_APVendor.VendorName, ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK

Payable Account

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctRef, ERPx_DeliveryTicketHeader.FishermanAccountVendorSK 

Payable Account Description

The GL Account Description of the Payable Account. 

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.SAGLAcctRef, ERPx_DeliveryTicketHeader.FishermanAccountVendorSK 

Percent

Identifies the percent of the catch from the Stat Area.

Database Fields: ERPx_APDeliveryTicketStatArea.Percent, ERPx_APDeliveryTicketHeader.DileverTicketHeaderSK

Premiums

Displays the total amount of all the Premiums assigned to the Ticket Item.

Price

Identifies the Price assigned to the Ticket Item.

Database Field: ERPx_APDeliveryTicketLine.Price

Price List ID

This is not required and can be edited from the 'Price List' field on the 'Home' tab of the Fish Ticket Record View.

Database Fields: ERPx_MFPriceListHeader.PriceListID, ERPx_APDeliveryTicketHeader.PriceListHeaderSK

Price UOM

Database Fields: ERPx_IMUOM.UOMID, ERPx_APDeliveryTicketLine.PriceUOMSK 

Purchase Account

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APDeliveryTicketLine.PurchaseGLAccountSK

Purchase Account Description

The GL Account Description of the Payable Account. 

Database Fields: ERPx_GLAccount.Description, ERPx_APDeliveryTicketLine.PurchaseGLAccountSK

Reprice Comment

This is only required if the Fish Ticket has been repriced. This field is not editable.

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

This is required and can be edited from the 'Site Processed' field on the 'Home' tab of the Fish Tickets record view.

Database Fields: ERPx_MFSite.SiteName, ERPx_APDeliveryTicketHeader.SiteProcessedSiteSK

Sold - Condition

Identifies the Condition the Fish Ticket Item was sold in.

Database Fields: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SoldConditionSK, ERPx_APCondition. ConditionID + ERPx_APCondition. ConditionDescription

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 Fields: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.SpecieID +  ERPx_APSpecie.SpecieName

Stat Area

Database Fields: ERPx_APStatAreas.StatAreaID, ERPx_APDeliveryTicketStatArea.StatAreaSK, ERPx_APDeliveryTicketHeader.DileverTicketHeaderSK

Status

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APDeliveryTicketHeader.TransactionStatusSK 

Tax District 

Identifies if the Tax District assigned to the Stat Area.

Database Fields: ERPx_APStatAreas.TaxDistrict, ERPx_APDeliveryTicketStatArea.StatAreaSK, ERPx_APDeliveryTicketHeader.DeliveryTicketHeaderSK

Taxes 

Identifies the total amount of tax, from all the Tax Programs, for the Ticket Item. It is calculated as: [Tax - Fisherman] + [Tax - Company]

Tender Delivered

This is not required and can be edited from the 'Tender' field on the 'Home' tab of the Fish Ticket Record View.

Database Fields: ERPx_APVendor.VendorName, ERPx_APDeliveryTicketHeader.TenderDeliveredVendorSK 

Ticket #

The Ticket # can be manually assigned or can come from downloaded eLandings ticket numbers. Clicking on the link opens the Fish Ticket Record View for the selected record. This is required and can be edited from the 'Ticket #' field on the 'Home' tab of the Fish Ticket record view while the transaction is in a Status of New.

Database Field: ERPx_APDeliveryTicketHeader.TicketNumber

Ticket Class

Identifies the type of Fish Ticket associated with the transaction. This is required and is not editable.

Database Fields: ERPx_APTransactionClass.TransactionClassID, ERPx_APDeliveryTicketHeader.TransactionClassSK

Units

Database Field: ERPx_APDeliveryTicketLine.Units

Version

Displays the version number of the Fish Ticket. The version of a transaction will only be visible if it is greater than 1. This is a system assigned value and is required. It is not editable.

Database Field: ERPx_APDeliveryTicketHeader.Version

Version Type

Database Field: ERPx_APDeliveryTicketHeader.DeliveryTicketVersionTypeEN

Weight

Database Field: ERPx_APDeliveryTicketLine.DeliveredWeight 

Wt. Mod.

Database Field: ERPx_APDeliveryTicketLine.WeightModifier