Definition of table fund
Description file for the funds , Table Dump Name fund

Alphabetical Field Summary

  • acct-fund: (CHAR) Fund number
  • bal-acct-num: (CHAR) Account Number that contains Fund Balance
  • beg-acct-num: (CHAR) Account to record new year begining balances against
  • budget-acct-num: (CHAR) Budget Equity Account for this fund
  • credate: (DATE) Date of record creation
  • enc-equity-acct-num: (CHAR) Account used to record encumberance for this fund
  • enc-liab-acct-num: (CHAR) Encumberances Liability Account for this fund
  • extern-guid: (CHAR) External Global Unique ID for this record
  • fa-credit-acct-num: (CHAR) Enter the Account Number to Credit when Adding Fixed Assets
  • fiscal-year: (CHAR) Start year of fiscal year (i.e. 1992 for FY 1992/1993)
  • from-acct-num: (CHAR) Account used to import from other funds
  • fund-closed: (LOGC) Set when the fund has been closed for the fiscal year
  • fund-desc: (CHAR) Description of funds purpose
  • net-acct-num: (CHAR) Account for recording previous years net change in fund bala
  • ny-activated: (LOGC) Set if the next year has been activated
  • primary-key: (INTG) Unique, Primary key for table/record
  • state-fund-code: (CHAR) Fund code to report to MI for this fund
  • to-acct-num: (CHAR) Account used to export to other funds
  • upddate: (DATE) Date of last record update

    Alphabetical Index Summary

  • bal-acct-num: fiscal-year, bal-acct-num
  • beg-acct-num: fiscal-year, beg-acct-num
  • budget-acct-num: fiscal-year, budget-acct-num
  • encum-equity-acct: fiscal-year, enc-equity-acct-num
  • encum-liability-acct: fiscal-year, enc-equity-acct-num
  • extern-guid: extern-guid
  • fa-credit-acct-num: fiscal-year, fa-credit-acct-num
  • from-acct-num: fiscal-year, from-acct-num
  • fund-acct: (UNIQUE, PRIMARY) fiscal-year, acct-fund
  • fund-desc: fiscal-year, fund-desc
  • net-acct-num: fiscal-year, net-acct-num
  • to-acct-num: fiscal-year, to-acct-num

    Alphabetical Trigger Summary

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

    Other tables who reference fund

  • acct - Accounts file.
  • bud-detail - Detail account budgeting
  • cash-acct - Cash Accounts definition file. This defines each possible
  • fa-item-group - Item Grouping table for fixed assets
  • level-desc - Account Level descriptions. There is one record for each
  • level-item - Name or description of each component of an account number a

    Tables fund references

  • period - Period definition file. This defines the start/stop of each

    Detailed Alphabetical Field Listing
    acct-fund Data type: CHARACTER
    Format: x(8)
    Help: Fund number
    Attributes: Index Component, Mandatory

    bal-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account Number that contains Fund Balance
    Attributes: Index Component

    beg-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account to record new year begining balances against
    Attributes: Index Component

    budget-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Budget Equity Account for this fund
    Attributes: Index Component

    credate Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date of record creation

    enc-equity-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account used to record encumberance for this fund
    Attributes: Index Component

    enc-liab-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Encumberances Liability Account for this fund

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

    fa-credit-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Enter the Account Number to Credit when Adding Fixed Assets
    Attributes: Index Component

    fiscal-year Data type: CHARACTER
    Format: 9999
    Description: Start year of fiscal year (i.e. 1992 for FY 1992/1993)
    Attributes: Index Component

    from-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account used to import from other funds
    Attributes: Index Component

    fund-closed Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Set when the fund has been closed for the fiscal year

    fund-desc Data type: CHARACTER
    Format: x(28)
    Help: Description of funds purpose
    Attributes: Index Component, Mandatory

    net-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account for recording previous years net change in fund bala
    Attributes: Index Component

    ny-activated Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Set if the next year has been activated

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

    state-fund-code Data type: CHARACTER
    Format: x(8)
    Help: Fund code to report to MI for this fund

    to-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account used to export to other funds
    Attributes: Index Component

    upddate Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date of last record update

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