FTR DATA DICTIONARY

Contents

    FTR dictionary

    NAME DESCRIPTION


    TSEQ Trx#, or Sequence # (assigned by computer)
    TDATE Entry Date (not used for accounting)
    TPDATE Post Date (Accrual Accounting Date)
    TCRAMT CREDIT AMOUNT
    TDRAMT DEBIT AMOUNT
    TCHECK_NUM Check Number, blank or 0 if not a check
    TDESC Description
    TCLEAR Implementation changed in Version 5.02m 5.1d
    2=cks not deposited, 3=cc not deposited, 4 = deposited,
    5=cks or deposits Not Cleared, 6= trx cleared bank

    TBAL Account Balance After Trx (partially implemented)
    TPOST Posted to General Ledger Summary File?
    TMEMO Extended Description
    TSOURCE journal source
    T_OFCODE niu, not in use
    TD_DATE Account 1190: Deposited Date; 2100: Due date
    T_ID User I D stamp for Security Module
    T_DATETIME DATE stamp for Security Module

    not fully implemented or used:
    T_AUNUM Pointer to AUNUM (No cascading update!)
    T_CCODE Pointer to Customer Code (No Cascading Updates!)
    T_VCODE Pointer to Vendor Code (No Cascading Updates!)
    T_INNUM Pointer to Invoice Number (No Cascading Updates!)
    T_OFFSET_AUNUM Offset Account (not strictly updated)

    PF7
    To view field names in other files go to menus > maintenance > prog > windows > df browser.

    Updated on October 23, 2026