Definition of table ent-calendar
Entity information on a calendar year basis , Table Dump Name ent-cale

Alphabetical Field Summary

  • adj-1099-amount: (DECM) Amount to adjust the reported 1099 amount by
  • calendar-year: (CHAR) Calendar year for record
  • ent-id: (CHAR) Vendors ID Code
  • ent-name: (CHAR) The name of the organization
  • exp-1099-amount: (DECM) Total amount of 1099 payments for this calendar year
  • exp-amount: (DECM) Total amount paid to be paid to an entity
  • exp-applied: (DECM) Total amount paid to an entity
  • exp-balance: (DECM) Balance to be paid to an entity
  • exp-discount: (DECM) Total discounts applied for this vendor
  • extern-guid: (CHAR) External Global Unique ID for this record
  • per-exp-amount[12]: (DECM) Total amount to be paid to an entity for a period
  • per-exp-applied[12]: (DECM) Total amount paid to an entity for a period
  • per-exp-discount[12]: (DECM) Total amount of discounts applied to a vendor for a month
  • per-rev-amount[12]: (DECM) Total amount to be collected from an entity for a period
  • per-rev-applied[12]: (DECM) Total amount received from an entity for a period
  • primary-key: (INTG) Unique, Primary key for table/record
  • rev-amount: (DECM) Total amount to be collected from entity
  • rev-applied: (DECM) Total amount received from entity
  • rev-balance: (DECM) Balance due from an entity

    Alphabetical Index Summary

  • ec-id: (UNIQUE, PRIMARY) calendar-year, ent-id
  • ec-name: calendar-year, ent-name
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-eny.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-eny.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-eny.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-eny.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-eny.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-eny.p (SOURCE NOT AVAILABLE)

    Other tables who reference ent-calendar

  • ap-line - AP Transaction Line/Account file
  • ap-tran - AP Transaction Header file.
  • ar-line - AR Line item files
  • ar-tran - Accounts Receivable transactions file
  • bi-desc - Invoice Line Descriptions
  • bi-line - Invoice Account Line Items
  • bi-tran - Billing Transactions file
  • billing-period-item - (no description available)
  • ds-desc - Disbursment invoice description file
  • ds-line - Disbursment Line/Account file
  • ds-tran - Disbursment transaction file
  • entity - Definitions for vendors & customers
  • fa-class-code - Fixed Assets Item Class Table
  • inv-line - Invoice Line items file
  • invoice - Invoice file. This keeps a detail of vendor invoices.
  • item-tran - Fixed Assets Item
  • po-desc - Description items for the PO
  • po-line - Line/Account file for the PO
  • po-recv - Receiving detail of PO item
  • po-tran - PO transaction/file entries
  • rc-desc - Receipt Invoice lines
  • rc-line - Receipts Line Item file
  • rc-tran - Receipts Transaction file
  • _Segments - (no description available)

    Tables ent-calendar references

  • entity - Definitions for vendors & customers

    Detailed Alphabetical Field Listing
    adj-1099-amount Data type: DECIMAL (Decimals: 2)
    Format: -z,zzz,zz9.99 (Initial Value: 0)
    Help: Amount to adjust the reported 1099 amount by

    calendar-year Data type: CHARACTER
    Format: xxxx
    Description: Calendar year for record
    Attributes: Index Component

    ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendors ID Code
    Attributes: Index Component

    ent-name Data type: CHARACTER
    Format: x(32)
    Help: The name of the organization
    Attributes: Index Component, Mandatory

    exp-1099-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Help: Total amount of 1099 payments for this calendar year

    exp-amount Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>>,>>9.99 (Initial Value: 0)
    Description: Total amount paid to be paid to an entity

    exp-applied Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>>,>>9.99 (Initial Value: 0)
    Description: Total amount paid to an entity

    exp-balance Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>>,>>9.99 (Initial Value: 0)
    Description: Balance to be paid to an entity

    exp-discount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Description: Total discounts applied for this vendor

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

    per-exp-amount Data type: DECIMAL (Extent: 12, Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Total amount to be paid to an entity for a period

    per-exp-applied Data type: DECIMAL (Extent: 12, Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Total amount paid to an entity for a period

    per-exp-discount Data type: DECIMAL (Extent: 12, Decimals: 2)
    Format: zzz,zzz,zz9.99 (Initial Value: 0)
    Description: Total amount of discounts applied to a vendor for a month

    per-rev-amount Data type: DECIMAL (Extent: 12, Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Total amount to be collected from an entity for a period

    per-rev-applied Data type: DECIMAL (Extent: 12, Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Description: Total amount received from an entity for a period

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

    rev-amount Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>>,>>9.99 (Initial Value: 0)
    Description: Total amount to be collected from entity

    rev-applied Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>>,>>9.99 (Initial Value: 0)
    Description: Total amount received from entity

    rev-balance Data type: DECIMAL (Decimals: 2)
    Format: ->>,>>>,>>9.99 (Initial Value: 0)
    Description: Balance due from an entity

    Created on 04/17/2012 by DBHTML V1.2