Definition of table bud-detail
Detail account budgeting , Table Dump Name bud-det

Alphabetical Field Summary

  • acct-desc: (CHAR) Description of account
  • acct-fund: (CHAR) Fund number
  • acct-group: (CHAR) Group (Asset,Liability,Equity,Expense,Revenue,etc)
  • acct-num: (CHAR) Account Number
  • amount: (DECM) Current budget amount
  • credate: (DATE) Date of record creation
  • extern-guid: (CHAR) External Global Unique ID for this record
  • fiscal-year: (CHAR) Start year of fiscal year (i.e. 1992 for FY 1992/1993)
  • level[10]: (CHAR) Each part of the account level is placed in here
  • outcome: (CHAR) Current status of this budget (pending, approved, denied)
  • phase: (INTG) The order in which this step occurs
  • posted: (LOGC) Has this record been posted to the account file
  • primary-key: (INTG) Unique, Primary key for table/record
  • rationale: (CHAR) Rationale for this level
  • upddate: (DATE) Date of last record update
  • user-name: (CHAR) User who created the transaction

    Alphabetical Index Summary

  • acct-num: fiscal-year, acct-num
  • buddet-acct: (UNIQUE, PRIMARY) fiscal-year, acct-fund, acct-group, acct-num, phase
  • buddet-desc: fiscal-year, acct-fund, acct-group, acct-desc, phase
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

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

    Other tables who reference bud-detail

  • bud-phase - Identify each phase (or step) in the budgeting process
  • _Connect - (no description available)

    Tables bud-detail references

  • acct - Accounts file.
  • acct-class-acct - Account Class Account List
  • bud-phase - Identify each phase (or step) in the budgeting process
  • cash-acct - Cash Accounts definition file. This defines each possible
  • fund - Description file for the funds
  • period - Period definition file. This defines the start/stop of each

    Detailed Alphabetical Field Listing
    acct-desc Data type: CHARACTER
    Format: x(28)
    Help: Description of account
    Attributes: Index Component

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

    acct-group Data type: CHARACTER
    Format: x(12)
    Help: Group (Asset,Liability,Equity,Expense,Revenue,etc)
    Attributes: Index Component, Mandatory

    acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account Number
    Attributes: Index Component, Mandatory

    amount Data type: DECIMAL (Decimals: 2)
    Format: (zzz,zzz,zz9.99) (Initial Value: 0)
    Help: Current budget amount

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

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    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

    level Data type: CHARACTER (Extent: 10)
    Format: x(6)
    Description: Each part of the account level is placed in here

    outcome Data type: CHARACTER
    Format: x(8) (Initial Value: Pending)
    Help: Current status of this budget (pending, approved, denied)

    phase Data type: INTEGER
    Format: >9 (Initial Value: 0)
    Help: The order in which this step occurs
    Attributes: Index Component

    posted Data type: LOGICAL
    Format: yes/no (Initial Value: no)
    Description: Has this record been posted to the account file

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

    rationale Data type: CHARACTER
    Format: x(28)
    Help: Rationale for this level

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

    user-name Data type: CHARACTER
    Format: x(16)
    Description: User who created the transaction
    Attributes: Mandatory

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