Definition of table journal
Journal Codes file , Table Dump Name journal

Alphabetical Field Summary

  • credate: (DATE) Date of journal 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)
  • hidden-journal: (LOGC) Yes to hide journal in GL Maintenance, No to show it
  • journal-code: (CHAR) Journal Code
  • journal-desc: (CHAR) Description of journal code
  • journal-type: (CHAR) Type of journal (G/L, Budget or Encumberance)
  • last-tran: (INTG) Last assigned transaction # for this journal
  • primary-key: (INTG) Unique, Primary key for table/record
  • protected: (LOGC) Journal Protected (system journal)
  • upddate: (DATE) Date of last record update

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • journal-code: (UNIQUE, PRIMARY) fiscal-year, journal-code
  • journal-desc: fiscal-year, journal-desc

    Alphabetical Trigger Summary

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

    Other tables who reference journal

  • bi-tran - Billing Transactions file
  • billing-group - (no description available)
  • fa-transaction-code - Transaction Codes for Fixed Asset Item History
  • gl-line - GL Transaction Line items
  • gl-tran - GL Transaction headers
  • item-history - Item History Table for Fixed Assets

    Tables journal references

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

    Detailed Alphabetical Field Listing
    credate Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date of journal 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

    hidden-journal Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to hide journal in GL Maintenance, No to show it

    journal-code Data type: CHARACTER
    Format: x(6)
    Help: Journal Code
    Attributes: Index Component, Mandatory

    journal-desc Data type: CHARACTER
    Format: x(32)
    Help: Description of journal code
    Attributes: Index Component, Mandatory

    journal-type Data type: CHARACTER
    Format: x(12) (Initial Value: G/L)
    Help: Type of journal (G/L, Budget or Encumberance)

    last-tran Data type: INTEGER
    Format: 999999 (Initial Value: 0)
    Description: Last assigned transaction # for this journal

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

    protected Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Journal Protected (system journal)

    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