salessupportnewscompanycontact
Back to: Home : Support



First Resort File Numbers

 
 
 
 
 
 
 
 
The following is a list of ctree file names and numbers.

Note: the "bbb" in the file name is your business code. Add zeroes to the end if you have a 1 or 2 character business code.

File Name File Number File Description
SYCSYS.FIL
0
Business code client file
SYUSYS.FIL
1
User code file
SYLbbb.FIL
2
Rates, taxes, housekeeping, stats table, custom financial setup file
HPMSYS.FIL
3
Help table
GLMbbb.FIL
4
General ledger master file
GLXbbb.FIL
5
General ledger transaction file
APVbbb.FIL
6
Accounts payable vendor file
APXbbb.FIL
7
Accounts payable transaction file
ARVbbb.FIL
8
Accounts receivable vendor file
ARXbbb.FIL
9
Accounts receivable transaction file
PRMbbb.FIL
10
Payroll master and timecard file
PRXbbb.FIL
11
Payroll quarterly history file
PRCbbb.FIL
12
Payroll tax table file
MLMbbb.FIL
13
Mailing list master file
PMPbbb.FIL
14
Property file
PMRbbb.FIL
15
Owner file
PMCbbb.FIL
16
Costcode file
PMXbbb.FIL
17
Property transaction file
RSMbbb.FIL
18
Folio master file
RSCbbb.FIL
19
Management type, source code table file
RSDbbb.FIL
20
Reservation other information, soft block, LT schedule
RSAbbb.FIL
21
Availability information
SYTbbb.FIL
22
Generalized transaction batch file
SYXbbb.FIL
23
Accounting debits and credits file
CLMbbb.FIL
24
Client A/R master file
GLRbbb.FIL
25
Check reconciliation file
WOMbbb.FIL
26
Work order master file
WODbbb.FIL
27
Work order task file
WONbbb.FIL
28
Work order notes file
WOPbbb.FIL
29
not currently used
RSHbbb.FIL
30
Daily managers report file
RSVbbb.FIL
31
Travel agent file
RSBbbb.FIL
32
Soft block file
RAMbbb.FIL
33
Activity file
PMHbbb.FIL
34
Historical owner file
SYDbbb.FIL
35
Change log file
SYCbbb.IDX
36
Index on business code
SYUbbb.IDX
37
Index on user, business, passwords
SYLbbb.IDX
38
Index depends on table type (see #2 above)
HPMbbb.IDX
39
Index on help depending on your location in the software
GLMbbb.IDX
40
Index on GL account number
GLMbbb.IDX
41
Index on GL sortcode (subheadings)
GLXbbb.IDX
42
Index on GL check number, JE#, or cash receipt #
APVbbb.IDX
43
Index on business A/P vendor code
APXbbb.IDX
44
Index on business A/P vendor + invoice
ARVbbb.IDX
45
Index on A/R vendor code
ARXbbb.IDX
46
Index on A/R vendor + invoice
PRMbbb.IDX
47
Index on employee number
PRMbbb.IDX
48
Index on last name
PRXbbb.IDX
49
Index on employee number by quarter by year
PRCbbb.IDX
50
Index on payroll tax type and YYMM
MLMbbb.IDX
51
Index on last name and zip
MLMbbb.IDX
52
Index on zip and last name
PMPbbb.IDX
53
Index on property code
PMRbbb.IDX
54
Index on property code + owner number
PMRbbb.IDX
55
Index on owner last name
PMCbbb.IDX
56
Index on costcode
PMXbbb.IDX
57
Index on PM transaction vendor + invoice
PMXbbb.IDX
58
Index on PM transaction statement month + owner code + sumcode
PMXbbb.IDX
59
Index on folio + sumcode
RSMbbb.IDX
60
Index on folio number
RSMbbb.IDX
61
Index on folio last name
RSMbbb.IDX
62
Index on folio arrival date
RSMbbb.IDX
63
Index on folio departure date
RSMbbb.IDX
64
Index on folio property code
RSCbbb.IDX
65
Index on code
RSDbbb.IDX
66
Reservation misc: folio + tag
RSDbbb.IDX
67
Reservation misc: Lname + tag
RSAbbb.IDX
68
Index on date_range + unit_type + usage
RSAbbb.IDX
69
Index on date_range + prop
SYTbbb.IDX
70
Index on record number
SYTbbb.IDX
71
Index depends on what type of trans
SYXbbb.IDX
72
Index on acct + rectype + trdate
CLMbbb.IDX
73
Index on Client AR Code
CLMbbb.IDX
74
Index on Client AR NAME
GLRbbb.IDX
75
Index on account and check number
WOMbbb.IDX
76
Work order index by number
WOMbbb.IDX
77
Work order index by property/start date
WOMbbb.IDX
78
Work order index by start date
WOMbbb.IDX
79
Work order index by stop date
WODbbb.IDX
80
Work order task index
WONbbb.IDX
81
Work order notes index
WOPbbb.IDX
82
Not currently used
WOPbbb.IDX
83
Not currently used
WOPbbb.IDX
84
Not currently used
RSHbbb.IDX
85
Index for daily managers report
RSVbbb.IDX
86
TA IATA index
RSVbbb.IDX
87
TA PHONE index
RSVbbb.IDX
88
TA Name index
RSBbbb.IDX
89
Soft block prop/beg Date index
RSBbbb.IDX
90
Group id index
RAMbbb.IDX
91
Activity file indexes
RAMbbb.IDX
92
Activity file indexes
RAMbbb.IDX
93
Activity file indexes
RAMbbb.IDX
94
Activity file indexes
PMHbbb.IDX
95
Historical owners index
PMHbbb.IDX
96
Historical owners index
SYDbbb.IDX
97
Change log index
SYDbbb.IDX
98
Change log index


 

 
To make comments or report problems with this site, please contact webmaster@firstres.com.

firstres.com is published by First Resort - An Instant Software Company
155 South Side Drive, Suite 1 | Basalt, CO 81621 | Ph: 800.872.3771
Copyright 2002. All Rights Reserved.

SALES | SUPPORT | NEWS & EVENTS | NEWSLETTER | JOBS | COMPANY