Alphabetical Field Summary
Alphabetical Index Summary
Alphabetical Trigger Summary
Other tables who reference emp-taxes
Tables emp-taxes references
extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component
fica-acct-num Data type: CHARACTER
Format: x(30)
Description: Account used to create disbursement
fica-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit
fica-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: FICA Adjustment amount
fica-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay
fica-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Limit for adjustment, 0 for no limit
fica-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Help: FICA Adjustment Percentage
fica-adjust-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Adjustment Sequence #
fica-check-run Data type: INTEGER
Format: zzz (Initial Value: 0)
Help: Check run # used for producing this disbursement
fica-ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for producing this disbursement
fica-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: Yes)
Help: 'Reg' to enable for regular pays only, 'All' for all pays
fica-last-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # FICA was adjusted on
fica-last-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last employee payroll seq # FICA was adjusted on
fica-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays adjustment has been applied to
fica-pay-max Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays to apply adjustment or 'ALL'
fica-status Data type: CHARACTER
Format: x(3) (Initial Value: Yes)
Help: FICA Tax Active (Yes, No or 'Adj' for Adjustments Only)
figure-on-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of payrolls to figure taxes over (for annualizing)
figure-taxes-by Data type: CHARACTER
Format: x(11) (Initial Value: Past Pays)
Help: Figure taxes by Annualize, Tax Bracket or Past Pays
fit-acct-num Data type: CHARACTER
Format: x(30)
Description: Account used to create disbursement
fit-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit
fit-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: FIT Adjustment amount
fit-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay
fit-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Limit for adjustment, 0 for no limit
fit-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Help: FIT Adjustment Percentage
fit-adjust-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Adjustment Sequence #
fit-check-run Data type: INTEGER
Format: zzz (Initial Value: 0)
Help: Check run # used for producing this disbursement
fit-ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for producing this disbursement
fit-exempt-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Help: Number of exemptions
fit-exempt2-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Help: FIT Secondary Exemption count
fit-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: Yes)
Help: 'Reg' to enable for regular pays only, 'All' for all pays
fit-gross-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzzz,zz9.99
Help: FIT Gross Adjustment
fit-last-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # FIT was adjusted on
fit-last-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last employee payroll seq # FIT was adjusted on
fit-name Data type: CHARACTER
Format: x(8) (Initial Value: FEDERAL)
Description: Name of tax table to use for federal taxes
Help: Name of tax table to use for federal taxes
fit-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays adjustment has been applied to
fit-pay-max Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays to apply adjustment or 'ALL'
fit-status Data type: CHARACTER
Format: x(3) (Initial Value: Yes)
Help: FIT Tax Active (Yes, No or 'Adj' for Adjusments Only)
fit-step3-adjust Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99
Description: Per-pay W4 Step 3 adjustment amount
Help: Per-Pay W4 Step 3 adjustment amount
hit-fica-limit-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Payroll # employee hit FICA limit
hit-fica-limit-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Payroll Seq# employee hit FICA limit
hit-medicare-limit-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Payroll # employee hit Medicare limit
hit-medicare-limit-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Payroll Seq# employee hit Medicare limit
lit-acct-num Data type: CHARACTER
Format: x(30)
Description: Account used to create disbursement
lit-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit
lit-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: LIT Adjustment amount
lit-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay
lit-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Limit for adjustment, 0 for no limit
lit-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Help: LIT Adjustment Percentage
lit-adjust-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Adjustment Sequence #
lit-check-run Data type: INTEGER
Format: zzz (Initial Value: 0)
Help: Check run # used for producing this disbursement
lit-ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for producing this disbursement
lit-exempt-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Help: Number of exemptions
lit-exempt2-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Help: LIT Secondary Exemption Count
lit-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: Yes)
Help: 'Reg' to enable for regular pays only, 'All' for all pays
lit-gross-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzzz,zz9.99
Help: LIT Gross Adjust
lit-last-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # LIT was adjusted on
lit-last-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last employee payroll seq # LIT was adjusted on
lit-name Data type: CHARACTER
Format: x(8)
Help: Name of tax table to use for 'local' taxes
lit-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays adjustment has been applied to
lit-pay-max Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays to apply adjustment or 'ALL'
lit-status Data type: CHARACTER
Format: x(3) (Initial Value: Yes)
Help: LIT Tax Active (Yes, No or 'Adj' for Adjustments Only)
lit-step3-adjust Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99
Help: Per-payroll W4 step 3 adjustment
marital-code Data type: CHARACTER
Format: x(8)
Help: Martial status as used for taxing purposes
medicare-acct-num Data type: CHARACTER
Format: x(30)
Description: Account used to create disbursement
medicare-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit
medicare-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: Medicare Adjustment amount
medicare-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay
medicare-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Limit for adjustment, 0 for no limit
medicare-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Help: Medicare Adjustment Percentage
medicare-adjust-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Adjustment Sequence #
medicare-check-run Data type: INTEGER
Format: zzz (Initial Value: 0)
Help: Check run # used for producing this disbursement
medicare-ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for producing this disbursement
medicare-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: Yes)
Help: 'Reg' to enable for regular pays only, 'All' for all pays
medicare-last-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # Medicare was adjusted on
medicare-last-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last employee payroll seq # Medicare was adjusted on
medicare-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays adjustment has been applied to
medicare-pay-max Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays to apply adjustment or 'ALL'
medicare-status Data type: CHARACTER
Format: x(3) (Initial Value: Yes)
Help: Medicare Tax Active (Yes, No or 'Adj' for Adjustments Only)
oit-acct-num Data type: CHARACTER
Format: x(30)
Description: Account used to create disbursement
oit-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit
oit-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: OIT Adjustment amount
oit-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay
oit-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Limit for adjustment, 0 for no limit
oit-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Help: OIT Adjustment Percentage
oit-adjust-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Adjustment Sequence #
oit-check-run Data type: INTEGER
Format: zzz (Initial Value: 0)
Help: Check run # used for producing this disbursement
oit-ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for producing this disbursement
oit-exempt-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Help: Number of exemptions
oit-exempt2-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Help: OIT Secondary Exemptions
oit-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: Yes)
Help: 'Reg' to enable for regular pays only, 'All' for all pays
oit-gross-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzzz,zz9.99
Help: OIT Gross Adjust
oit-last-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # OIT was adjusted on
oit-last-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # OIT was adjusted on
oit-name Data type: CHARACTER
Format: x(8)
Help: Name of tax table to use for this tax
oit-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays adjustment has been applied to
oit-pay-max Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays to apply adjustment or 'ALL'
oit-status Data type: CHARACTER
Format: x(3) (Initial Value: Yes)
Help: OIT Tax Active (Yes, No, 'Adj' for Adjustments Only)
oit-step3-adjust Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99
Help: Per-payroll W4 step 3 adjustment amount
pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Payroll Identifier
Attributes: Index Component
pay-seq Data type: INTEGER
Format: zzzzzzzzz9
Description: Payroll Sequence within a given pay for an employee
Attributes: Index Component
primary-key Data type: INTEGER
Format: zzzzzzzzz9
Help: Unique, Primary key for record
sit-acct-num Data type: CHARACTER
Format: x(30)
Description: Account used to create disbursement
sit-adjust-accrued Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Amount accrued toward this adjustments limit
sit-adjust-amount Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Help: SIT Adjustment amount
sit-adjust-applied Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99 (Initial Value: 0)
Description: Adjustment applied for this pay
sit-adjust-limit Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Help: Limit for adjustment, 0 for no limit
sit-adjust-percent Data type: DECIMAL (Decimals: 2)
Format: -zz9.99% (Initial Value: 0)
Help: SIT Adjustment Percentage
sit-adjust-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Adjustment Sequence #
sit-check-run Data type: INTEGER
Format: zzz (Initial Value: 0)
Help: Check run # used for producing this disbursement
sit-ent-id Data type: CHARACTER
Format: x(6)
Help: Vendor # used for producing this disbursement
sit-exempt-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Help: Number of exemptions
sit-exempt2-cnt Data type: INTEGER
Format: -z9 (Initial Value: 0)
Help: SIT Secondary Exemption Count
sit-for-regular-pay Data type: LOGICAL
Format: Reg/All (Initial Value: Yes)
Help: 'Reg' to enable for regular pays only, 'All' for all pays
sit-gross-adjust Data type: DECIMAL (Decimals: 2)
Format: -zzzz,zz9.99
Help: SIT Gross Adjustment
sit-last-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last payroll # SIT was adjusted on
sit-last-pay-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Last employee payroll seq # SIT was adjusted on
sit-name Data type: CHARACTER
Format: x(8)
Help: Name of tax table to use for state tax
sit-pay-cnt Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays adjustment has been applied to
sit-pay-max Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of pays to apply adjustment or 'ALL'
sit-status Data type: CHARACTER
Format: x(3) (Initial Value: Yes)
Help: SIT Tax Active (Yes, No or 'Adj' for Adjustments Only)
sit-step3-adjust Data type: DECIMAL (Decimals: 2)
Format: -zz,zz9.99
Help: Per-pay W4 step 3 adjustment
tax-bracket Data type: INTEGER
Format: 9 (Initial Value: 1)
Help: Tax Bracket (1 - 5)
Created on 12/28/2020 by DBHTML V1.2