Definition of table pay-distrib
Payroll DIstributions file , Table Dump Name pay-dist

Alphabetical Field Summary

  • acct-num: (CHAR) Distribution Account
  • dist-amount: (DECM) Amount to distribute to account
  • dist-credit: (DECM) Total amount credited to this account
  • dist-debit: (DECM) Total amount debited to this account
  • extern-guid: (CHAR) External Global Unique ID for this record
  • last-credit: (DECM) Last credit amount pushed to FAS
  • last-debit: (DECM) Last debit amount pushed to FASE
  • last-dist-amount: (DECM) Last Amount Distributed to GL
  • pay-id: (INTG) Payroll Identifier
  • primary-key: (INTG) Unique, Primary key for record
  • use-debits: (LOGC) If TRUE, use the debit/credit fields. Otherwise, use the 'ol

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • pay-dist: (UNIQUE, PRIMARY) pay-id, acct-num

    Alphabetical Trigger Summary

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

    Other tables who reference pay-distrib

  • 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-acct - Payroll Distribution Account List
  • pay-deduct - Payroll Master Deductions definition
  • pay-disburse - Record of per-payroll vendor disburements
  • pay-profile - Payroll System Profile
  • tax-table - Federal, State and Local tax tables

    Tables pay-distrib references

  • emp-distrib - Employee Distributions
  • emp-payroll - The one per employee, once per payroll control file
  • pay-acct - Payroll Distribution Account List
  • pay-cycle-schd - Linkage file between cycles and the payroll active for them
  • pay-disburse - Record of per-payroll vendor disburements
  • pay-schd - Payroll Schedule for a year One entry per

    Detailed Alphabetical Field Listing
    acct-num Data type: CHARACTER
    Format: x(30)
    Help: Distribution Account
    Attributes: Index Component

    dist-amount Data type: DECIMAL (Decimals: 2)
    Format: zz,zzz,zz9.99 (Initial Value: 0)
    Description: Amount to distribute to account

    dist-credit Data type: DECIMAL (Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Total amount credited to this account

    dist-debit Data type: DECIMAL (Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Total amount debited to this account

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

    last-credit Data type: DECIMAL (Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Last credit amount pushed to FAS

    last-debit Data type: DECIMAL (Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Last debit amount pushed to FASE

    last-dist-amount Data type: DECIMAL (Decimals: 2)
    Format: zz,zzz,zz9.99 (Initial Value: 0)
    Description: Last Amount Distributed to GL

    pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Payroll Identifier
    Attributes: Index Component

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

    use-debits Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: If TRUE, use the debit/credit fields. Otherwise, use the 'ol

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