Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

(Master File Name)'s are (explain what these are and what their purpose is). They are used in the (identify each functional area these are used in) Functional Area(s) (to support other master files, to support transactions, to support other master files and transactions.). 

Insert excerpt
Def - Program Type - FA Ticket Tax
Def - Program Type - FA Ticket Tax
nopaneltrue
The purpose of this page is to add, edit, remove, and activate/inactive these records. Users also have the ability to copy an existing program as a new program or new version.

(lightbulb) These Taxes are only applicable to Fish Tickets, not to calculate Sales Tax on a Fisherman or Customer Sale.

Software Version: 20192021.MM03.DD 12 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Copy

Opens the Program Copy Record View allowing users to copy an existing program as a new program or as a new version. During the Copy, users can specify whether program properties and rates should be copied from the selected program. The Program Copy Record View also allows users to enter Program ID/Description (for new programs) and Start Date for the new program/version. If no row is selected, the message "Please select one item and try again." will be displayed. If more than one row is selected, the message "Please limit your selection to one item and try again." will be displayed. If exactly one row is selected, then the Program Copy Record View will open.

(lightbulb) The user is not required to select the latest version of a program to copy. However, if a new version is being created, then the 'Start Date' field will always be validated against the latest version of the selected program.

Delete

Insert excerpt
Delete -

Global

LV
Delete -

Global

LV
nopaneltrue

Programs used on a Fish Ticket will not be able to be deleted. The message "This Program is used on a Delivery Ticket and cannot be deleted." will be displayed. Additionally, only the latest version of a program will be allowed to be deleted. If the user selects a prior version of a program to delete, the message "([Program ID]) cannot be deleted because it is not the latest version of this program." will be displayed.

Edit
Insert excerpt
Edit - List View Single LineLV
Edit - List View Single LineLV
nopaneltrue
Excel
Insert excerpt
Excel - Global (old)
Excel - Global (old)
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global Icon
Help - Global Icon
nopaneltrue
New
Insert excerpt
New - Global
New - Global
nopaneltrue
FieldsDescription
CheckboxUsed to select one or more records for delete or mass update.
Program Group

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Program Class

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Program IDA hyperlink show the (Field Name) of the transaction. Clicking on the link opens the record view of the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####.
Program Description

The name associated with the (ID Field Name) ID. This is required for all records but does not need to be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

Landed Date StartThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.
Landed Date EndThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.
Default Rate

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Assign Rate By

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Calculated On

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

UOM

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Expense For

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Company Expense Account

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Tax Liability Account

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.Assign Rate By

Identifies where the Tax Rate comes from. This defaults to 'GLOBAL' for new records but can be changed. If it is changed from GLOBAL, it must match one of the values in the 'Assign Rules By' Property. If not, the message "Assign Rate By must be assigned by one of the Assign Rules By values." will be displayed on Save. It can be set to the following values:

  • GLOBAL: The rate assigned as the Default Rate will be used
  • Species: The rate comes from the rate value on the Species Tab
  • Ticket Items: The rate comes from the rate value on the Ticket_Items Tab
  • Gear: The rate comes from the rate value on the Gear Tab
  • Chill Type: The rate comes from the rate value on the Chill_Type Tab
  • Fishermen: The rate comes from the rate value on the Fishermen Tab
  • Management Programs: The rate comes from the rate value on the Management_Programs Tab
  • Site Processed: The rate comes from the rate value on the Site_Processed Tab

This field is always editable from the Record View. This lookup contains all the values in the APProgramAssignBy Enumeration Class except 'Stat Area' and includes an option for GLOBAL.

Database Field: ERPx_APProgram.AssignmentMethodEN

Calculated On

Identifies which weight value on the ticket line the Tax is calculated from. This defaults to blank for new records but is required. If not assigned, the message "Calculated On is required." will be displayed on Save. It can be set to the following values:

  • % Amount: The calculation for each line item will be ((Ext. Amount + Premiums) * Tax %). The 'Ext. Amount' is calculated as (Price * Weight)
  • % Taxable Amount: The calculation for each line item will be (Gross Taxable Amount * Tax %). The 'Gross Taxable Amount' is calculated as ((Tax Price * Weight)+Premiums)
  • Delivered Weight: The rate will be multiplied to the 'Weight' value of the ticket item to calculate the Tax Amount.
  • Fixed Amount: The tax amount will be manually entered for each ticket item
  • Net Weight: The rate will be multiplied to the 'Net Weight' value of the ticket item to calculate the Tax Amount.
  • Paid Weight: The rate will be multiplied to the 'Net Weight' value of only applicable ticket items with a Price >0.00 to calculate the Tax Amount.

This field is always editable from the Record View. This lookup contains all the values in the APProgramCalcMethod Enumeration Class.

Database Field: ERPx_APProgram.APProgramCalcMethodEN

Company Expense Account

The GL Account that is Debited to record the company expense portion of a Tax program for a Fish Ticket Item. This defaults as blank on new records, but is required if "Company" is selected in the 'Expense For' property on the record view. If blank, the message "Company Expense Account is required." will be displayed on Save. This field is always editable from the record view.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts

Database Field: ERPx_APProgram.CompanyExpenseAccountSK

Current Version

Identifies whether or not the program is the current version based on the program's 'Landed Date Start' and 'Landed Date End' fields. If the current date falls between the 'Landed Date Start' and 'Landed Date End' fields, then this field will display as 'Yes". If not, this field will display as blank. This is not a required field and is not stored in the database. This field can be updated by editing the program's 'Landed Date Start' and 'Landed Date End' fields.

(lightbulb) If the 'Landed Date End' field is blank, then the program is continuous and this field will display as 'Yes'.

Default Rate

Identifies the value in the 'Default Rate' property of the TaxProgram. This defaults to 0.000000 for new records but is not required to be changed. This field is always editable from the Record View. 

(lightbulb) Leaving this as 0.000000 and the 'Assign Rate By' to "GLOBAL" and the 'Calculated On' on anything other than "Fixed Amount" will result in no tax being calculated

(lightbulb) If the 'Assign Rate By' is anything other than 'Globally" this is only represents the Default Rate. The actual rates may be different. 

Database Field: ERPx_APProgram.Rate

Expense For

Identifies which entity is charged for the Tax. This defaults to blank for new records but is required. If not assigned, the message "Expense For is required." will be displayed on Save. It can be set to one or both the following values:

  • Fisherman: The Tax will be deducted from what is owed the Fisherman for the Fish Ticket in order for the Company to pay the tax on behalf of the Fisherman.
  • Company: The Tax will be accrued on the Fish Ticket in order for the Company to pay their portion of the tax.

This field is always editable from the Record View. This lookup contains all the values in the APProgramExpenseFor Enumeration Class.

Database Field: ERPx_APProgram.ExpenseForEN

Inactive

A Yes/No field used to identify if the record is Inactive. If set to 'Yes' then

it's

the record is "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then

it's

the record is "Active" and can be freely used

without restrictions. ('No' values display as blank in the grid). This value is always editable. Linked Database Field: ERPx_#####.#####.
(Field Name) ID

The unique identifier of the (what type of record is this). This default to blank but is required for all records, must be unique (what must it be unique by), and must be <= 25 characters.

Linked Database Field: ERPx_####.OOOO

(Field Name) Description

The name associated with the (ID Field Name) ID. This is required for all records but does not need to be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

InactiveA Yes/No field used to identify if the record is Inactive. If set to 'Yes' then it's "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then it's "Active" and can be used without restrictions. ('No' values display as blank in the grid). This value is always editable. Linked Database Field: ERPx_#####.#####.
Date FieldThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.
HyperlinkA hyperlink show the (Field Name) of the transaction

Database Field: ERPx_APProgram.IsInactive

Landed Date End

A date field to indicate when the Tax Program ends. Fish Tickets with a Landed Date after the 'Landed Date End' will not be evaluated for the the Tax, even if the Tax Program is still Active. This defaults as blank on new records, and is not required. A blank Landed Date End assumes the Tax never ends but if a date is entered it must be >= the 'Landed Date Start' if not, the message "Landed Date End must be on or after Landed Date Start." will be displayed on Save. This field is always editable from the record view.

Database Field: ERPx_APProgram.APProgramEnd

Landed Date Start

A date field to indicate when the Tax Program begins. Fish Tickets with a Landed Date before the 'Landed Date Start' will not be evaluated for the Tax. This defaults as blank on new records, but is required. If blank, the message "Landed Date Start is required." will be displayed on Save. This field is always editable from the record view.

Database Field: ERPx_APProgram.APProgramStart

Newest Version

Identifies whether or not the program is the newest version. This is not a required field and is not stored in the database. If the program is not the newest version, this field will display as blank. Else, it will display as "Yes".This field is updated when a new version is created from the same program.

Program Class

Identifies the value in the 'Class' property of the Tax Program. This defaults to blank for new records but is required. If not assigned, the message "Class is required." will be displayed on Save. This field is always editable from the Record View. 

Database Field: ERPx_APProgram.APProgramClassSK

Program Description

The 'Description' property on the Tax record. This defaults to blank for new records and is required but duplicate values are allowed. If not assigned, the message "Description is required." will be displayed on Save. This field is always editable from the record view and must be <= 100 characters. 

The Program Description is used as a long description/name of the Premium.

Database Field: ERPx_APProgram.APProgramName

Program Group

Identifies the 'Program Group' assigned to the 'Program Class'. This is a looked up value and can only be changed in the 'Taxes & Premium Classes' master file. The potential values for this include:

  • Borough
  • City
  • Observer
  • State
  • Other

The values for this field come from the APProgramGroup Enumeration. 

Program ID

A hyperlink that shows the value of the 'Program ID' property on the Tax record. Clicking on the link opens the record view

of the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####.
Lookup (from an Enumeration)A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If

for the selected Tax. 

This defaults to blank for new records and is required. If not assigned, the message "

(what message is displayed)

Program ID is required." will be displayed on Save. This value must be unique. If not, the message "Duplicate Program ID's are not allowed for the same Program Type." will be displayed on Save. This field is

(always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####.

This lookup contains all the values in the (EnumerationClassName) Enumeration Class. 

Lookup (non Enumeration)A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

always editable from the record view and must be <= 50 characters. 

The Program ID is used as a short description and unique identifier of the Tax.

Database Field: ERPx_APProgram.APProgramID

Tax Liability Account

The GL Account that is Credited, to record the liability, when the Tax is assigned to a Fish Ticket Item. This defaults as blank on new records, but is required. If blank, the message "Tax Liability GL Account is required." will be displayed on Save. This field is always editable from the record view.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

Text Field

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Yes/No Lookup

A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime. 

A value of "Yes" means that...

A value of "No" means that...GL Accounts

Database Field: ERPx_APProgram.CRAccountSK

UOM

This value is informational only and always displays as Lbs for Tax program with a Calculated On of either Delivered Weight, Net Weight, or Paid Weight. Edit is not allowed.

Database Field: ERPx_APProgram.UOMSK

Version

Identifies the version of the program. New programs have a version of 1. This is a required field. This is a system assigned value and is never editable by a user.

Database Field: ERPx_APProgram.Version

Related Topics



Expand
titlePage Definitions

Page Definitions



Expand
titleTechnical Details

Technical Details