Definition of table emp-distrib
Employee Distributions , Table Dump Name emp-dist

Alphabetical Field Summary

  • acct-num: (CHAR) Expense account to distribute to
  • cur-acct-num: (CHAR) Account number this was last distributed to
  • cur-amount: (DECM) Current distribution amount for this payroll
  • dist-active: (LOGC) Distribution Active?
  • dist-code: (CHAR) Distibution Code letter
  • dist-percent: (DECM) Percentage to distribute to account
  • dist-seq: (INTG) Distribution Sequence #
  • emp-seq: (INTG) Employee's Unique Sequence #
  • extern-guid: (CHAR) External Global Unique ID for this record
  • fytd-amount: (DECM) FYTD Amount for this distribution
  • last-used-pay-id: (INTG) Last payroll # record was used on
  • last-used-pay-seq: (INTG) Last employee payroll seq # record was used on
  • mtd-amount: (DECM) MTD amount for distribution
  • pay-id: (INTG) Payroll Identifier
  • pay-seq: (INTG) Payroll Sequence within a given pay for an employee
  • primary-key: (INTG) Unique, Primary key for record
  • qtd-amount: (DECM) QTD Amount for this distribution
  • ytd-amount: (DECM) YTD Amount for this distribution

    Alphabetical Index Summary

  • dist-acct: pay-id, acct-num, emp-seq, pay-seq
  • dist-seq: pay-id, emp-seq, pay-seq, dist-seq
  • emp-distrib: (PRIMARY) pay-id, emp-seq, pay-seq, dist-code, acct-num
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

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

    Tables emp-distrib references

  • emp-adjust - Employee Adjustments
  • emp-counter - Employee Counters
  • emp-dc - (no description available)
  • emp-demo - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-pay-master - Employee Payroll Master
  • emp-payroll - The one per employee, once per payroll control file
  • emp-retire - Employee Retirment Records
  • emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)
  • emp-tdp - Employee DTL3 record
  • emp-unemp - Employee Unemployement counters
  • pay-acct - Payroll Distribution Account List
  • pay-check - Payroll Check file, one record per payroll check issued
  • pay-cycle-schd - Linkage file between cycles and the payroll active for them
  • pay-disburse - Record of per-payroll vendor disburements
  • pay-distrib - Payroll DIstributions file
  • pay-schd - Payroll Schedule for a year One entry per

    Detailed Alphabetical Field Listing
    acct-num Data type: CHARACTER
    Format: x(30)
    Help: Expense account to distribute to
    Attributes: Index Component

    cur-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account number this was last distributed to

    cur-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: Current distribution amount for this payroll

    dist-active Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Distribution Active?

    dist-code Data type: CHARACTER
    Format: x
    Help: Distibution Code letter
    Attributes: Index Component

    dist-percent Data type: DECIMAL (Decimals: 2)
    Format: zz9.99% (Initial Value: 0)
    Help: Percentage to distribute to account

    dist-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Distribution Sequence #
    Attributes: Index Component

    emp-seq Data type: INTEGER
    Format: zzzzzzzz9
    Description: Employee's Unique Sequence #
    Attributes: Index Component

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

    fytd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: FYTD Amount for this distribution

    last-used-pay-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Last payroll # record was used on

    last-used-pay-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Last employee payroll seq # record was used on

    mtd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: MTD amount for distribution

    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

    qtd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: QTD Amount for this distribution

    ytd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Help: YTD Amount for this distribution

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