Definition of table pay-acct
Payroll Distribution Account List , Table Dump Name pay-acct

Alphabetical Field Summary

  • acct-num: (CHAR) Employee wages expense account
  • extern-guid: (CHAR) External Global Unique ID for this record
  • federal-retire-acct-num: (CHAR) Federal retirement expense account
  • federal-retire-rate: (DECM) Federal retirement %age rate for Expense Account
  • fica-acct-num: (CHAR) Employer Share FICA Expense account
  • futa-acct-num: (CHAR) FUTA Expense Account
  • grant-code-id: (INTG) Grnat Coding ID for this account, if any
  • medicare-acct-num: (CHAR) Employer Share Medicare Expense account
  • payroll-year: (INTG) Payroll year associated with this record
  • primary-key: (INTG) Unique, Primary key for record
  • state-retire-acct-num: (CHAR) State retirement expense account
  • state-retire-rate: (DECM) State retirement %age rate for Expense Account
  • suta-acct-num: (CHAR) SUTA Expense Account

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • pay-acct: (UNIQUE, PRIMARY) payroll-year, acct-num
  • pay-acct-grant: grant-code-id, payroll-year, acct-num

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-pac.p
  • DELETE: Overridable, Procedure is tr-d-pac.p
  • REPLICATION-CREATE: Procedure is rp-c-pac.p
  • REPLICATION-DELETE: Procedure is rp-d-pac.p
  • REPLICATION-WRITE: Procedure is rp-u-pac.p
  • WRITE: Overridable, Procedure is tr-u-pac.p

    Other tables who reference pay-acct

  • atnd-code - Attendance Code Definitions
  • benefit-code - Benefit Code Descriptions
  • emp-atnd - Employee Attendance Entries
  • emp-benefit - Employee Benefits
  • emp-deduct - Employee Deductions file
  • emp-distrib - Employee Distributions
  • emp-pay-master - Employee Payroll Master
  • emp-rate-hours - Employee Payrate Hourly detail
  • emp-retire - Employee Retirment Records
  • emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)
  • emp-unemp - Employee Unemployement counters
  • fringe-class - Fringe benefit classes
  • fringe-period - Fringe Benefit Period
  • pay-deduct - Payroll Master Deductions definition
  • pay-disburse - Record of per-payroll vendor disburements
  • pay-distrib - Payroll DIstributions file
  • pay-profile - Payroll System Profile
  • tax-table - Federal, State and Local tax tables

    Tables pay-acct references

  • emp-distrib - Employee Distributions
  • grant-fund - (no description available)
  • pay-disburse - Record of per-payroll vendor disburements
  • pay-distrib - Payroll DIstributions file
  • pay-year - Payroll Year definitions

    Detailed Alphabetical Field Listing
    acct-num Data type: CHARACTER
    Format: x(30)
    Help: Employee wages expense account
    Attributes: Index Component

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    federal-retire-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Federal retirement expense account

    federal-retire-rate Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 5)
    Help: Federal retirement %age rate for Expense Account

    fica-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Employer Share FICA Expense account

    futa-acct-num Data type: CHARACTER
    Format: x(30)
    Help: FUTA Expense Account

    grant-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Grnat Coding ID for this account, if any
    Attributes: Index Component

    medicare-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Employer Share Medicare Expense account

    payroll-year Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Payroll year associated with this record
    Attributes: Index Component

    primary-key Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Unique, Primary key for record

    state-retire-acct-num Data type: CHARACTER
    Format: x(30)
    Help: State retirement expense account

    state-retire-rate Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 5)
    Help: State retirement %age rate for Expense Account

    suta-acct-num Data type: CHARACTER
    Format: x(30)
    Help: SUTA Expense Account

    Created on 12/28/2020 by DBHTML V1.2