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
...
- Purchase Account
...
- Void/Correct: Opens the Void/Correct Fish Ticket utility to allow users to void or correct one or more posted tickets.
- /wiki/spaces/HELP/pages/1239253130: Opens the Fish Ticket Item Reprice utility to allow users to reprice ticket line items on one or more posted tickets.
- Fish Ticket Premium Reprice: Opens the Fish Ticket Premium Reprice utility to allow users to reprice the Premiums attached to ticket line items on one or more posted tickets.
...
Columns
...
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
Toolbar Icons | Description | ||||||||||||||||||||||||||||||||||||||||
Edit |
| ||||||||||||||||||||||||||||||||||||||||
Excel |
| ||||||||||||||||||||||||||||||||||||||||
Favorites |
| ||||||||||||||||||||||||||||||||||||||||
Grid Layout |
| ||||||||||||||||||||||||||||||||||||||||
Mass Update |
| ||||||||||||||||||||||||||||||||||||||||
More Actions |
| ||||||||||||||||||||||||||||||||||||||||
New |
| ||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||
Columns | Description | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Checkbox |
| ||||||||||||||||||||||||||||||||||||||||
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_APContition. ContitionID + ERPx_APContition. ContitionDescription | ||||||||||||||||||||||||||||||||||||||||
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 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.View while the transaction is in a Status of New.
Database Field: ERPx_APDeliveryTicketHeader. | BuyingStationNameFloating | ||||||||||||||||||||||||||||||||||||||
CFECIDGear |
Database FieldFields: ERPx_APGear.GearDescription, ERPx_APVendorPermit.GearSK, ERPx_APDeliveryTicketHeader.CFECIDVendorPermitSK | ||||||||||||||||||||||||||||||||||||||||
Chill TypeGL Date | Chill Type ID | Chill Type ID |
|
Identifies the Condition for the Fish Ticket Item.
Database FieldsField: ERPx_APChillType. ChillTypeID, ERPx_APDeliveryTicketHeader.ChillTypeSK
APDeliveryTicketHeader.GLDate
Insert excerpt |
---|
|
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APContition. ContitionID
Created 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.Insert excerpt |
---|
|
|
Database Field: ERPx_APDeliveryTicketHeader.CreatedDate
Created By. 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.Identifies the Grade of the Fish Ticket Item.
Insert excerpt |
---|
|
Database Field: ERPx_
APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.GradesSK, ERPx_APGrade. GradeID + ERPx_APGrade. GradeDescription
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 -
Landed Date Def -
Landed Date nopanel true
Database Field:
ERPx_APDeliveryTicketHeader.TicketDate
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.
Identifies the Extended Amount of the Ticket Item.
The 'Ext. Amount' is calculated as: [Weight] x [Price].
LandingNumber
This is required and is not editable. Insert excerpt Last Updated Last Updated nopanel true
Database Field: ERPx_APDeliveryTicketHeader.
LastUpdated
Insert excerpt
This is Last Updated By Last Updated By nopanel true
Database Fields: ERPx_APVessels.VesselName, ERPx_APVessels.VesselNumber, ERPx_APDeliveryTicketHeader.VesselSK
required and is not editable.
Database Field: ERPx_APDeliveryTicketHeader.LastUser
Identifies the Major Specie that the Specie belongs to.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.MajorSpecie
This is required for the transaction to be approved or posted. It can be edited from the ' Insert excerpt Management Program ID and Desc Management Program ID and Desc nopanel true
Mgmt. Program' field on the '
PropertiesHome' tab of the Fish Ticket Record
View while the transaction is in a Status of NewView.
Insert excerpt Def - Management Program Def -
Database Field: ERPx_APDeliveryTicketHeader.Floating
GearManagement 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].
Insert excerpt
Paid Account
This is required and can be edited from the 'Paid Account nopanel true
Paid Account' field on the 'Home' tab of the Fish Ticket Record View.
Database Fields: ERPx_
APVendor.
VendorName, ERPx_
APDeliveryTicketHeader.FishermanAccountVendorSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
The GL Account Description of the Payable Account.
Insert excerpt |
---|
|
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.
Insert excerpt Def - Permit Def - Permit nopanel true
Database
Fields: ERPx_
APVendorPermit.Permit, ERPx_APDeliveryTicketHeader.VendorPermitSK
Insert excerpt
This is a non-editable text box that is requiredPermit Holder Permit Holder nopanel true
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.
Database Field: ERPx_APDeliveryTicketHeader.TicketDate
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
Database Field: ERPx_APDeliveryTicketHeader.LastUpdated
Database Field: ERPx_APDeliveryTicketHeader.LastUser
Identifies the Major Specie that the Specie belongs to.
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.MajorSpecie
Insert excerpt
Database Fields: ERPx_APVendor.VendorSK.VendorName , ERPx_APDeliveryTicketHeader.PermitHolderVendorSK
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
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 the dollar amount of the "Chill" type premiums assigned to the Ticket Item.
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 the dollar amount of the "Dock" type premiums assigned to the Ticket Item.
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".
Identifies the dollar amount of the "Other" type premiums assigned to the Ticket Item.
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
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].
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 | ||||||
---|---|---|---|---|---|---|
|
Identifies the Permit number belonging to the fisherman that was used to catch the fish.
Insert excerpt
The GL Account Description of the Payable Account.
Identifies the 'Season' assigned to the Fish Ticket.
Identifies the name of the Site that processed the fish from the Ticket.
Identifies the Condition the Fish Ticket Item was sold in.
Identifies whether the Fish Ticket was manually entered or imported from eLandings.
Identifies the ID and Description of the Specie assigned to the Ticket Item.
Reprice Comment Reprice Comment nopanel true
Identifies the Port of Landing specified on the Properties tab of the Fish Ticket.
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 the dollar amount of the "Chill" type premiums assigned to the Ticket Item.
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 the dollar amount of the "Dock" type premiums assigned to the Ticket Item.
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".
Identifies the dollar amount of the "Other" type premiums assigned to the Ticket Item.
Identifies the ID of the Price List assigned to the Fish Ticket.
This is only required if the Fish Ticket has been repriced. This field is not editable.
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 | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APDeliveryTicketHeader.TransactionStatusSK
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 the dollar amount of the "Borough Tax" assigned to the Ticket Item.
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 the dollar amount of the "City Tax" assigned to the Ticket Item.
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 the dollar amount of the "Observer Tax" assigned to the Ticket Item.
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 the dollar amount of the "Other Tax" assigned to the Ticket Item.
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 dollar amount of the "State Tax" the "State Tax" assigned to the Ticket Item.
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.
Displays the 'Vessel Name' of the Vessel assigned to the Tender.
Identifies the Ticket Class of the Ticket
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
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
...