| 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 | ||||
|---|---|---|---|---|
|
...
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:
|
...
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_APContition. ContitionID + ERPx_APContition. ContitionDescription | ||||||||||||||||
| Created |
Database Field: ERPx_APDeliveryTicketHeader.CreatedDate | ||||||||||||||||
| Created By |
Database Field: ERPx_APDeliveryTicketHeader.CreatedBy | ||||||||||||||||
| Delivered |
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 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| Ticket Item Description |
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.GeneratedItemDescription | ||||||||||||||||
| Ticket Item ID |
Database Field: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.ItemID | ||||||||||||||||
| Units |
Database Field: ERPx_APDeliveryTicketLine.Units | ||||||||||||||||
| Units UOM |
Database Field: ERPx_APDeliveryTicketLine.UnitsUOMSK, ERPx_IMUOM.UOMID | ||||||||||||||||
| 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 Company Tax Amount | Identifies the total amount of tax, from all the Tax Programs, that is expensed to the Company for the selected ticket version. If the Ticket Version is > 1 then this represents the difference between the current version and the previous version. | ||||||||||||||||
| Version Fisherman Tax Amount | Identifies the total amount of tax, from all the Tax Programs, that was/is being withheld from the Fisherman for the selected ticket version. If the Ticket Version is > 1 then this represents the difference between the current version and the previous version. | ||||||||||||||||
| Version Gross Amount | 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]. | ||||||||||||||||
| Version Net Amount | 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]. | ||||||||||||||||
| Version Type |
| ||||||||||||||||
| Weight |
| ||||||||||||||||
| Wt. Mod. |
|
...