FTR DATA DICTIONARY

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.