Database Field: ERPx_APProgram.APProgramID - ERPx_APProgram.APProgramName

Database Field: ERPx_APProgram.APProgramID

Database Field: ERPx_APProgram.APProgramName

Identifies the Program Class associated with the Tax record. This is a single-select lookup that is required. If missing, the message "Class is required." will be displayed on Save. 

It defaults to blank and is always editable.

The lookup contains a blank value, the current assigned values and all the records in the Tax & Premium Classes list view with a 'Program Type' of "Tax". 

Database Field: ERPx_APProgram.

APProgramClassSK

This is a

date picker that is required. If missing, the message "Landed Date Start is required." will be displayed on Save. This defaults as blank on new records and is always editable. Fish Tickets with a Landed Date before the 'Landed Date Start' will not be evaluated for the Tax. This date may not overlap with dates from other versions of the same program. Else the message "[Program ID] Version [Version - 1]'s Landed Start and End Dates may not overlap other version of the same Program." will be displayed on Save.

Database Field: ERPx_APProgram.

APProgramStart

This is a

date picker that is not required. This defaults as blank and is always editable. A blank value assumes the Tax never ends, but if a date is entered it must be >= the 'Landed Date Start' field. Else the message "Landed Date End must be on or after Landed Date Start." will be displayed on Save.  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 date may not overlap with dates from other versions of the same program. Else the message "[Program ID] Version [Version + 1]'s Landed Start and End Dates may not overlap other version of the same Program." will be displayed on Save.

Database Field: ERPx_APProgram.

APProgramEnd

Yes/No lookup that is required. it defaults to "No" and is always editable. This field is not visible until after the record is initially saved.

Database Field: ERPx_APProgram.IsInactive

Specifies how taxes are assigned fish tickets. This is a multi-select lookup where at least one selection is required. If missing, the message "Assign Rules By is required." will be displayed on Save. This field defaults as blank and is always editable. When one or more values are selected, on Save, additional tabs for each of the selected items will be added to the record view.

This lookup contains all the values in the APProgramAssignBy Enumeration Class.

Database Field: ERPx_APProgram.AssignRulesByEN

 Specifies where the Tax Rate comes from. This is a single-select

standard lookup that is required. It defaults to "GLOBAL" and is always editable. 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.

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

 This is a text box that is required. If

missing, the message "

Rate is required."

 will be displayed on Save.

 It defaults to "0.000000" and is always editable. If the tax is configured to be an expense for the company and the fisherman, the default rate is automatically divided. If this causes the rate to be more than 6 decimals, then the company rate is rounded up and the fisherman rate is rounded down.

 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.

 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

standard lookup that is required. If missing, the message "Calculated On is required." will be displayed on Save. It defaults to blank and is always editable.

This lookup contains all the values in the APProgramCalcMethod Enumeration Class.

Database Field: ERPx_APProgram.APProgramCalcMethodEN

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgram.CompanyExpenseAccountSK

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgram.CRAccountSK

standard lookup that is not required. It defaults to blank and is always editable.

This lookup contains a list of all the 'Active' Fishermen, Tenders, Fishermen & Tenders and Vendors.

Database Field: ERPx_APProgram.VendorSK

Identifies the Chill Type that the Tax Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Tax Program is created, all Chill Types are assigned. If you want only specific Chill Types to apply to the Tax Program, click the ‘New’ icon and manually add the Chill Type(s) that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' records in the Chill Type Master List.

Database Field: ERPx_APProgramEntity.

EntitySK where ERPx_APProgramEntity.ProgramEntityEN =

7

a single-select standard lookup that is not required. This field is only enabled when "Chill Type" is selected as the 'Assign Rate By' value and "

Company" is selected as the 'Expense For' value in the Properties tab.

This field defaults to

the 'Company Expense GL Account' value selected in the Properties tab. This field is

always editable.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 7

that is not required. This field is only enabled when "

Chill Type" is selected as the 'Assign Rate By' value and "

Company" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab

and is always editable.

 If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate

to 0.827160.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 7

standard lookup that is not required. This field is only enabled when "

Chill Type" is selected as the 'Assign Rate By' value in the Properties tab. The GL Account defaults to the 'Tax Liability GL Account' value selected in the Properties tab. This field is

always editable.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN =

7

and not stored in the database.

This is a single-select standard lookup

that is not required. This field is only enabled when "

Fishermen" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is

always editable.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN =

4

Identifies the Fisherman, Fisherman & Tender or Tender that the Tax Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Tax Program is created, all Fishermen, Fishermen & Tenders and Tenders are assigned. If you want only a specific Fisherman, Fisherman & Tender or Tender to apply to the Tax Program, click the ‘New’ icon and manually add the Fisherman, Fisherman & Tender or Tender that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' Fishermen, Fishermen & Tenders and Tenders.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 4

field defaults to "Fisherman Settlement Accrual Account" and is never editable. This field is not stored in the database.

This is a text box that is not required.This field is only enabled when "

Fishermen" is selected as the 'Assign Rate By' value and "Fisherman" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in

the Properties tab and is always editable. If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate to 0.827160.

Database Field: ERPx_APProgramEntity.

FishermanRate where ERPx_APProgramEntity.ProgramEntityEN =

4

 This is a single-select standard lookup that is not required. This field is only enabled when "Fishermen" is selected as the 'Assign Rate By' value in the Properties tab. The GL Account defaults to the 'Tax Liability GL Account' value selected in the Properties tab. This field is always editable.

The lookup contains a list of all the 'Active'

GL Accounts.

Database Field: ERPx_APProgramEntity.

LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN =

4

This is a non-editable text box

that is not required. This field is only calculated when "Fishermen" is selected as the 'Assign Rate By' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. It is calculated on Save as [Fisherman Rate] + [Company Rate]. This field is never editable

and not stored in the database.

This is a single-select standard lookup that is not required. This field is only enabled when "Gear" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab

. This field is always editable.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN =

2

This is a text box that is not required. This field is only enabled when "Gear" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab

and is

always editable. If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate to 0.827160.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN =

2

This is non-editable text box that is not required. This field only displays a value when "Gear" is selected as the 'Assign Rate By' value and "Fisherman" is selected as the 'Expense For' value in the Properties tab. The field defaults to "Fisherman Settlement Accrual Account" and is never editable. This field is not stored in the database.

This is a text box that is not required.This field is only enabled when "Gear" is selected as the 'Assign Rate By' value and "Fisherman" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab

and is

always editable. If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate to 0.827160.

Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN =

2

Identifies the Gear that the Tax Program applies to. This is a single-select standard lookup

that is required to save a line item. By default, when a new Tax Program is created, all

Gear are assigned. If you want only specific

Gear to apply to the Tax Program, click the ‘New’ icon and manually add the

Gear that you wish to apply. This field defaults as blank and is

editable

.

This lookup contains a list of all the 'Active' records in the

Gear Master List.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN =

2

This is a single-select standard lookup that is not required. This field is only enabled when "Gear" is selected as the 'Assign Rate By' value in the Properties tab. The GL Account defaults to the 'Tax Liability GL Account' value selected in the Properties tab

. This field is always editable.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN =

2

This is a non-editable text box

that is not required. This field is only calculated when "Gear" is selected as the 'Assign Rate By' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. It is calculated on Save as [Fisherman Rate] + [Company Rate]. This field is never editable and not stored in the database.

This is a single-select standard lookup

that is not required. This field is only enabled when "

Management Programs" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is

always editable.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN =

5

This is a text box that is not required.This field is only enabled when "

Management Programs" is selected as the 'Assign Rate By' value and "Fisherman" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab

and is always editable. If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate to 0.827160.

Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN =

5

Identifies the Management Program that the Tax Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Tax Program is created, all

Management Programs are assigned. If you want only specific

Management Programs to apply to the Tax Program, click the ‘New’ icon and manually add the

Management Program(s) that you wish to apply. This field defaults as blank

and is editable.

This lookup contains a list of all the 'Active' records in the

Management Programs Master List.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN =

5

This is a single-select standard lookup