Insert excerpt
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: 2021.06.04 and newer
Table of Contents | ||||
---|---|---|---|---|
|
Page Header
Search
...
Filter Items
...
- Delivered Date
- GL Date
- Landed Date
...
- Voids. Select if you want Items from Voided Tickets. Defaults as unselected.
...
- Ticket
- Delivery #
- Site Processed ID
- Ticket Class
- Permit
- Fishing Vessel
- Tender
...
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
...
- RV: Journal Details: Opens the Journal Details page
- RV Ticket: Opens the Fish Ticket Record View for the selected Ticket.
- Fish Ticket Item Reprice: Opens the 'Fish Ticket Items Reprice' page
- Fish Ticket Premium Reprice: Opens the 'Fish Ticket Premium Reprice' page
- Void/Correct: Opens the 'Void/Correct Fish Ticket' page
...
Database Field: ERPx_APDeliveryTicketHeader.BuyingStationName
...
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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.09.15 and newer
Table of Contents | ||||
---|---|---|---|---|
|
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 | |||||||||||||||||||||
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 # |
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 | |||||||||||||||||||||
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. | CFECIDFishingPeriod Chill Type | ||||||||||||||||||||
Fishing Vessel | Chill Type ID
| Chill Type ID |
| This is not required and can be edited from the ' | Chill TypeFishing Vessel' field on the 'Home' tab of the Fish Ticket Record View. | |||||||||||||||||
Insert excerpt | Def - Chill Type | Def - Chill Type | nopanel | trueDatabase Fields: ERPx_ | APChillType. ChillTypeID, ERPx_APDeliveryTicketHeader.ChillTypeSKCondition | Identifies the Condition for the Fish Ticket ItemAPVessels.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_ APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APContition. ContitionIDCreatedAPDeliveryTicketHeader.Floating | |||||||||||||||||||||
Gear |
| Created
| Created
| and is not editableand can be edited from the 'Gear' field on the 'Home' tab of the Fish Ticket Record View. Database | Field: ERPx_APDeliveryTicketHeader.CreatedDateCreated ByFields: ERPx_APGear.GearDescription, ERPx_APVendorPermit.GearSK, ERPx_APDeliveryTicketHeader.VendorPermitSK | |||||||||||||||||
GL Date | Created By
| Created By |
| required and is not editablerequired 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_ | APDeliveryTicketHeaderAPDeliveryTicketHeader. | CreatedByGLDate | ||||||||||||||||
GL Period | Date - Delivered (FA)
| Date - Delivered (FA) |
| and can be edited from the 'Deliveredfor the transaction to be approved or posted. It is not directly editable. It can be changed by editing the 'GL Date' field on the ' | HomeProperties' tab of the Fish Ticket Record View. | Delivery # | This field is not stored in the database. | |||||||||||||||
GL Year | Delivery Number
| Delivery Number |
| required for required for the transaction to be approved or posted. It is not directly editable. It can be | edited fromchanged by editing the ' | Delivery #GL Date' field on the ' | HomeProperties' tab of the Fish Ticket Record View. | Disposition | Identifies the 'Disposition' forThis field is not stored in the database. | |||||||||||||
Grade | Identifies the Grade of the Fish Ticket Item. |
| Disposition
| Disposition
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem. | DispositionSKGradesSK, ERPx_ | APDisposition. DispositionID|||||||||||||||||
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 | |||||||||||||||||||||
APGrade. GradeID + ERPx_APGrade. GradeDescription | ||||||||||||||||||||||
Gross Amount | Identifies the | Extended Gross Amount of the Ticket Item. The ' | Ext. Gross Amount' is calculated as: [ | WeightExt. Amount] | x [Price].||||||||||||||||||
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 |
| Fishing Vessel | Fishing Vessel | |||||||||||||||||||
nopanel | true | |||||||||||||||||||||
Headland | Displays the nearest headland to where the fish were caught. This is not required and can be edited from the 'Fishing VesselHeadland' field on the 'HomeProperties' tab of the Fish Ticket Record View. Database FieldsField: 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 andAPDeliveryTicketHeader.Headland | |||||||||||||||||||
Landed | Represents the Landed Date of the ticket. This is required and can be edited from the ' | FloatingLanded' field on the ' | PropertiesHome' tab of the Fish Ticket Record | View while the transaction is in a Status of New.View.
| Floating
| Floating
Database Field: ERPx_APDeliveryTicketHeader. | FloatingTicketDate | |||||||||||||||
Gear | Insert excerpt | | Gear | Gear | ||||||||||||||||||
nopanel | true | Identifies the unique landing report number issued by eLandings. This is only required for eLandings tickets. It can be edited from the 'GearLanding #' field on the 'HomeProperties' tab of the Fish Ticket Record View. Database FieldsField: ERPx_APGear.GearDescription, ERPx_APVendorPermit.GearSK, APDeliveryTicketHeader.LandingNumber | ||||||||||||||||||||
Last Updated |
Database Field: ERPx_APDeliveryTicketHeader.VendorPermitSK GL DateLastUpdated | |||||||||||||||||||||
Last Updated By |
Database Field: ERPx_APDeliveryTicketHeader.GLDate GL PeriodAPDeliveryTicketHeader.LastUser | |||||||||||||||||||||
Major Specie | GL Period Identifies the Major Specie that the Specie belongs to.
| GL Period |
|
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.MajorSpecie
This is required for the transaction to be approved or posted Insert excerpt Management Program ID and Desc Management Program ID and Desc nopanel true
.
It can be
changed by editingedited from the '
GL DateMgmt. Program' field on the '
PropertiesHome' tab of the Fish Ticket Record View
. This field is not stored in the database.Identifies the Grade of the Fish Ticket Item.
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.GradesSK, ERPx_APGrade. GradeID
Identifies the Gross Amount of the Ticket Item.
The 'Gross Amount' is calculated as: [Ext. Amount] + [Premiums].
Database Field: ERPx_APDeliveryTicketLine.GrossAmount
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
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..
Insert excerpt Def - Management Program Def - Management Program nopanel true
Database Fields: ERPx_APManagementPrograms.ManagementProgramID, ERPx_APManagementPrograms.ManagementProgramName, ERPx_APDeliveryTicketHeader.ManagementProgramSK
Identifies the Net Amount of the Ticket Item.
The 'Net Amount' is calculated as: [Gross Amount] - [Tax - Fisherman].
Identifies the Net Weight of the Ticket Item.
The 'Net Weight' is calculated as: [Weight] * [Wt. Mod].
This is required and can be edited from the 'Paid Account' field on the 'Home' tab of the Fish Ticket Record View. Insert excerpt Paid Account Paid Account nopanel true
Database Fields: ERPx_APVendor.VendorName, ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK
Identifies the Account Class assigned to the Fisherman that was/will be paid for the Fish Ticket.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
The GL Account Description of the Payable Account.
Insert excerpt | ||
---|---|---|
|
|
|
Database Field: ERPx_APDeliveryTicketHeader.TicketDate
Identifies the unique landing report number issued by eLandings. This is only required for eLandings tickets. It permit number that is associated to the Permit Holder. This is required and can be edited from the 'Landing #Permit' field on the 'PropertiesPermits' tab of the Fish Ticket Fishermen & Tenders Record View.
Database Field: ERPx_APDeliveryTicketHeader.LandingNumber
Last UpdatedLast Updated Insert excerpt
|
Database FieldDatabase Fields: ERPx_APVendorPermit.Permit, ERPx_APDeliveryTicketHeader.LastUpdated
Last Updated ByVendorPermitSK
Last Updated By Insert excerpt
|
Database FieldFields: ERPx_APVendor.VendorSK.VendorName , ERPx_APDeliveryTicketHeader.LastUser
Major SpeciePermitHolderVendorSK
Identifies
the Major Specie that the Specie belongs to.Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.MajorSpecie
Database Fields: ERPx_APManagementPrograms.ManagementProgramID, ERPx_APManagementPrograms.ManagementProgramName, ERPx_APDeliveryTicketHeader.ManagementProgramSK
Identifies the Net Amount of the Ticket Item.
The 'Net Amount' is calculated as: [Gross Amount] - [Tax - Fisherman].
Identifies the Net Weight of the Ticket Item.
The 'Net Weight' is calculated as: [Weight] * [Wt. Mod].
Identifies the Account Class assigned to the Fisherman that was/will be paid for the Fish Ticket.
The GL Account Description of the Payable Account.
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".
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".
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".
The GL Account Description of the Payable Account.
Identifies the Condition the Fish Ticket Item was sold in.
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
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".
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".
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".
This is not required and can be edited from the 'Price List' field on the 'Home' tab of the Fish Ticket Record View. Insert excerpt Price List - ID Price List - ID nopanel true
Insert excerpt Def - Price List Def - Price List nopanel true
Database Fields: ERPx_MFPriceListHeader.PriceListID, ERPx_APDeliveryTicketHeader.PriceListHeaderSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
The GL Account Description of the Payable Account.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
This is only required if the Fish Ticket has been repriced. This field is not editable. Insert excerpt Reprice Comment Reprice Comment nopanel true
Database Field: ERPx_APDeliveryTicketHeader.RepriceComment
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
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_MFSite.SiteName, ERPx_APDeliveryTicketHeader.SiteProcessedSiteSK
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.
Insert excerpt Def - Slide Def - Slide nopanel true
Database Field: ERPx_APDeliveryTicketHeader.Slide
Identifies the Condition the Fish Ticket Item was sold in.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SoldConditionSK, ERPx_APContition. ContitionID + ERPx_APContition. ContitionDescription
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
Identifies the ID and Description of the Specie assigned to the Ticket Item.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.SpecieID + ERPx_APSpecie.SpecieName
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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".
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".
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".
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".
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".
Identifies the total amount of tax, from all the Tax Programs, for the Ticket Item. It is calculated as: [Tax - Fisherman] + [Tax - Company]
Identifies the total amount of tax, from all the Tax Programs, for the Ticket Item. It is calculated as: [Tax - Fisherman] + [Tax - Company]
Identifies the Tender that delivered the Fish.
This is not required and can be edited from the 'Tender' field on the 'Home' tab of the Fish Ticket Record View. Insert excerpt Tender Tender nopanel true
Insert excerpt Def - Tender Def - Tender nopanel true
Database Fields: ERPx_APVendor.VendorName, ERPx_APDeliveryTicketHeader.TenderDeliveredVendorSK
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
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. Insert excerpt Ticket Number Ticket Number nopanel true
Database Field: ERPx_APDeliveryTicketHeader.TicketNumber
Identifies the type of Fish Ticket associated with the transaction. This is required and is not editable.
Insert excerpt Def - Ticket Class (FA) Def - Ticket Class (FA) nopanel true
Database Fields: ERPx_APTransactionClass.TransactionClassID, ERPx_APDeliveryTicketHeader.TransactionClassSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.GeneratedItemDescription
Insert excerpt | ||||
---|---|---|---|---|
|
|
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.ItemID
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APDeliveryTicketLine.Units
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APDeliveryTicketLine.UnitsUOMSK, ERPx_IMUOM.UOMID
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.
Insert excerpt Def - Version Def - Version nopanel true
Database Field: ERPx_APDeliveryTicketHeader.Version
Identifies the Gross Amount of the Ticket Item for the selected ticket version. If the Ticket Version is > 1 then this represents the difference between the current version's Gross Amount and the previous versions Gross Amount.
The 'Gross Amount' is calculated as: [Ext. Amount] + [Premiums].
Identifies the Net Amount of the Ticket Item for the selected ticket version. If the Ticket Version is > 1 then this represents the difference between the current version's Net Amount and the previous versions Net Amount.
The 'Net Amount' is calculated as: [Gross Amount] - [Tax - Fisherman].
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
...