Definition of table pay-disburse
Record of per-payroll vendor disburements , Table Dump Name pay-disb

Alphabetical Field Summary

  • acct-num: (CHAR) Account to be debited for disbursement
  • check-run: (INTG) Check run # used for disbursement
  • cur-amount: (DECM) Amount to disburse for this account/vendor
  • ds-tran-num: (INTG) Disbursement transaction #
  • ent-id: (CHAR) Vendor used for disbursement
  • extern-guid: (CHAR) External Global Unique ID for this record
  • last-amount: (DECM) Amount last disbursed to vendor
  • pay-id: (INTG) Payroll Identifier
  • primary-key: (INTG) Unique, Primary key for record

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • pay-disburse: (UNIQUE, PRIMARY) pay-id, ent-id, check-run, acct-num

    Alphabetical Trigger Summary

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

    Other tables who reference pay-disburse

  • 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-distrib - Payroll DIstributions file
  • pay-profile - Payroll System Profile
  • tax-table - Federal, State and Local tax tables

    Tables pay-disburse 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-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)
    Description: Account to be debited for disbursement
    Attributes: Index Component

    check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Description: Check run # used for disbursement
    Attributes: Index Component

    cur-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Description: Amount to disburse for this account/vendor

    ds-tran-num Data type: INTEGER
    Format: 999999
    Description: Disbursement transaction #

    ent-id Data type: CHARACTER
    Format: x(6)
    Description: Vendor used for disbursement
    Attributes: Index Component

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

    last-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Description: Amount last disbursed to vendor

    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

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