This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

MAINTAIN GOVERNMENT REGISTRATIONS#

Government Registrations identify all the types of taxation and filing that must be done with each applicable government department or level.

Government registrations may be established and maintained through the Maintain Government Registrations (IDGV) form.

This form stores all levels of government registration numbers.

Entity

Government registration codes are set up for each entity. Entity_Code from P2K_CM_ENTITIES is a 16-character alphanumeric mandatory field that the user may manually enter or use the LOV (F9) to choose an option.

Govt Regist Set

This field displays the name of the government registration set. You may use ‘Govt Registration Set’ to group similar registrations together.

For example:

Govt Regist Set - MAIN REGIST - Used by High Line as default to group all registrations initially.

Govt Regist Set - REGIST 2 - User may define another set for all levels of registrations for this set.

Govt Regist Set - FED REGIST - User may define Federal level registrations for this set.

Govt Regist Set - STATE REGIST - User may define state level registrations for this set.

Govt Regist Set - LOCAL REGIST - User may define local level registrations for this set.

Govt Regist Set - FULLTIME REGIST - User may define registrations for full time employees for this set.

Govt Regist Set - PARTTIME REGIST - User may define registrations for part time employees for this set.

Govt Regist Set - SEASONAL REG - User may define registrations for seasonal employees for this set.

Govt Regist Set - STATE OHIO - User may define registration for Ohio for this set.

Govt_Regist_Set from P2K_CM_GOVT_REGIST_SETS is a 16-character alphanumeric mandatory field that the user may manually enter.

Description

Description is a description of the Govt Registration Set. Description from P2K_CM_GOVT_REGIST_SETS is a 50-character alphanumeric optional field that the user may manually enter.

---

Registration Types#

U.S. Registration Types

A government registration is required for each tax type for each tax jurisdiction that must be filed. There will be one or many federal registrations for each EIN (Employer Identification number) assigned to you by the Social Security Administration (SSA). In addition, there will be one or many registrations for each State and Local jurisdiction where an organization is required to withhold taxes, unemployment or disability insurance.

Canadian Registration Types

A government registration is required for each federal and provincial tax withholding type that must be calculated. There will be one or more registrations for each Business Number assigned to you by Canada Customs and Revenue Agency (CCRA), and one or more registrations for each provincial tax, health tax or withholding that is made.

---

Maintain Government Registrations (IDGV) - Definition#

Government Registration data is stored in the P2K_CM_GOVT_REGIST_SETS, P2K_CM_GOVT_REGISTRATIONS, P2K_CM_GOVT_RATES, and P2K_CM_GOVT_RATE_DETAILS tables.

Country Name

The Country field from P2K_CM_COUNTRIES displays the country of registration.

State/Province

The State_Province field from P2K_CM_STATE_PROVINCES holds the state or province of registration.

County

The County field from P2K_CM_COUNTIES displays the county of registration. U.S. only

School District

The School_District field from P2K_CM_SCHOOL_DISTRICTS displays the school district of registration. U.S. only

Jurisdiction

The Tax_Jurisdiction field from P2K_CM_TAX_JURISDICTIONS displays the city or county of registration. U.S. only

Registration Type

The type of taxation for which a government registration has been created. Govt_Regist_Type is a mandatory fixed lexicon (X_GOVT_REGIST_TYPE) that you may use to look up the value.

Number

This is the US EIN or Canada BN number for this registration type. Govt_Regist_Number is a 30 character alphanumeric mandatory field that the user must manually enter.

Registration For

This is a derived field which displays which country, state/province, county or school district the registration is defined for.

Description

This is a user-defined description of the Government Registration. Description is a 50 character alphanumeric mandatory field that you must manually enter.

Distribution Mask CR

If the distribution credit mask needs to vary based on the state, local, etc. that the employee is being taxed in then the override needs to be placed here. Distribution_CR_Mask is an optional 50 character alphanumeric field that you may manually enter or use the LOV (F9).

Distribution Mask DR

If the distribution debit mask needs to vary based on the state, local, etc. that the employeeis being taxed in then the override needs to be placed here. Distribution_DR_Mask is a 50 character alphanumeric optional field that you may manually enter

Govt Rate Type

If the standard rate needs to be overridden then the type needs to be indicated. Govt_Rate_Type is a fixed lexicon (X_GOVT_RATE_TYPE) that the user may use to look up the value.

Description

User defined description of why the rate is being overridden. Description is a mandatory 50 character alphanumeric field that the user must manually enter.

Effective as of

This field displays the effective date of the override amount. Effective is a mandatory date field.

Expires on

This field displays the expiry date of the override amount. Expiry is a mandatory date field.

Amount $

The amount/rate/value of the override. Govt_Amount is 18-digit numeric field that the user must manually enter.

Change Reason

The reason for the change of rate is supplied here.