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

Database Field: ERPx_APProgram.APProgramStart

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

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

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

non-editable single-select

standard lookup that is required. This defaults to "FISHERMAN SETTLEMENT ACCRUAL ACCOUNT" and is never editable. This value is not stored in the database.

standard lookup that is required if "Company" is selected in the 'Expense For' property. If

missing, the message "Company Expense Account is required." will be displayed on Save.

This defaults as blank and is always editable.

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

Database Field: ERPx_APProgram.CompanyExpenseAccountSK

is a single-select standard lookup that is required. If

missing, the message "Tax Liability GL Account is required." will be displayed on Save.

This defaults as blank and is always editable

.

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

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

' 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.

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.

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