Make your own free website on Tripod.com

Sr Accountant tm DATABASE CONTENTS

Source file

Database Name: SOURCE.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
SRC Source Code
SRCDESC 30 Source Description
LDATE D 8 Date of Last entry for the source
LREF  Last Reference Number
SRCREF  Left characters of the Reference for the Source (e.g. JE-)
NEXTNO  8 Next Reference Number
BDGREF  4 Left characters of Budget Reference for the Source
NEXTBNO 8 Next Reference Number
CRCY 3 Currency of Source
CRCYACCT  Y G/L Account number for Currency exchange
CONTROL 1 Control Account Indicator
SRCGL  7 Source G/L number
SRCTYPE  10  Source Type (e.g. JOURNAL, BANKIN, BANKOUT)
DDESC  25  Document Description (e.g. Invoice, Journal Entry, Deposit)

Xxxxx file

Database Name: XXXX.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
12 
     


Names file

Database Name: NAMES.dbf
 
Field Name  Type  Lgth  Dec.  Indx  Description 
ACCTNO 7 Account Number - must agree with the G/L Account Number
COMPANY C 50  Company Name
ADD 25 N Address
CTY C 20 N City
STATE C 5 N State/Province
ZIP C 10 N Zip code/Postal Code
COUNTRY C 20 N Country
TEL C 14 N Telephone Number
FAX C 14  N Fax Number
MODEM C 14 N Modem Number
FST C 15 N Federal Tax Number
PST C 10 N Provincial/State Tax Number
CRCY  C N Account Currency
LDATE D 10 N Last Aging Date
LBALANCE N 12 2 N Last Aging Balance
LAGE1  N 12 N Age 1 (e.g. 1-30 days)
LAGE2 N 12 2 N Age 2 (e.g. 31-60 days)
LAGE3 N 12 2 N Age 3 (e.g. 61-90 days)
LAGE4 N 12 2 N Age 4 (e.g. 91-120 days)
LAGE5 N 12 2 N Age 5 (e.g. 121-150 days)
LAGE6 N 12 2 N Age 6 (e.g. over 150 days)

Index TAG:     CNME    Key: substr(COMPANY,1,10)
Index TAG:     CACCT   Key: CRCY+ACCTNO


Transaction file

Database Name: TRAN.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
DATE  Date of Check or Journal Entry 
NAME  25  Name of Employee 
REFERENCE  Check No. or Journal Entry No. 
AMOUNT  12  Amount of Check or Journal Entry 
GL  General Ledger Account No. 
SOURCE  Source Code (e.g. AR, AP, CK, DP, JE, PR) 

Sr Accountant Help file

Database Name: SAHELP.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
CONTENTS  65  Help Contents 
KEYS  Key stoke sequence from Master Menu 
SCREEN_NO  15  Screen No from Upper left of screen 
TEXT_HELP  10  Help Text 


[Contents]  [Top]  [Overview]  [Operations]  [Appendix]  [Index]