spacerspacer
Free help: USER GUIDE } WHAT'S NEW } SYSTEM MANAGER NEWS
Home > Support > Data Dictionary > GLOBAL_VARS
 Search:   


C&P Data Dictionary: GLOBAL_VARS

 

Other files:

acc_periods
access_privs
accounts
addresses
ap
ar
ar_items
archived_jobs
asset_types
asset_files
asset_prefs
avail
billing_info
cal
calendar
change_items
change_order
checks
check_items
clients
contacts
costs
credit_card_prefs
date_count
depts
est_revs
f_preference
finance
global_vars
groups
history
history_client
history_vendor
home
int_items
je
jobs
job_order
job_task
job_types
media_briefs
media_est
media_est_items
media_items
media_plans
media_prefs
meetings
mlink
mlink_prefs
odbcusers
outbox
palm_cats
palm_jobs
palm_tasks
payments
payment_items
pc
pictures
po_items
po_template
prefs
print_specs
programs
projects
proposals
purchase_order
rates
recur_ap
retainers
sales_actions
sales_campaigns
sales_letters
schedule_chart
schedule_header
staff
statements
stations
status_codes
sub_classes
task_table
temp_tasks
thought
time_import
timecard
timeline
user_info
vendors
version
web_html
web_ip_log
web_log
web_prefs
web_users_log
working
worksheets
y1099

GLOBAL_VARS is the data file that stores the Job Diary Entries. Each HISTORY record contains a single Job diary Entry. It is a data file used for the printable version of the Job History. Each HISTORY record has fields for the person's initials that added the entry (H_WHO) the date and time of the entry (H_DATE) and a description of the entry (H_DESC) for each job diary entry. These amount fields are updated when entries are posted.

See related data files:   CHANGE_ORDERS   PICTURES


Field Name:

Type:

Length:

Index:

Description:

gSEQUENCE Sequence
 
gFIND_WHAT char
25
Name of window, label on find window
gFIND_LIST1 List
List of fields to find by
gFIND_LIST2 List
List of ways to find
gFIND_ITEM1 char
25
Element of list 1
gFIND_ITEM2 char
25
Element of list 2
gFIND_BY Boolean
Determines if an input field is required
gFIND_BY_FIELD char
40
Input field
gFIND_NAME char
25
Field name to find on
gFIND_DATE Boolean
True if field is a date
gPRINT_WHERE char
15
 
gLIST_TARGET char
40
 
gSEE_TASK_NOTES short int
(0 to 255)
show task notes - report option
gSEE_JOB_SPECS short int
(0 to 255)
show job specs - report option
gSEE_COST_NOTES short int
(0 to 255)
show cost notes - report option
gSEE_KIND short int
(0 to 255)
cost kind (0=costs, 1=time, 2=expenses, 3=transfers)
gPERCENT Number
2 dp
generic percentage
gMODE char
15
enter data mode: ADD or EDIT; also used for job diary
gALLOCATE Boolean
auto-allocate payments
gRADIO1 short int
(0 to 255)
Temporary radio button
gDISCOUNT_GL Number
2 dp
AR, AP discount GL#
gRETAINER_GL Number
2 dp
retainer GL#
gSEQ Number
0 dp
temporary seq number
gBALN Number
2 dp
generic balance amount
gCHECKBOX1 Short num
0 dp
Temporary checkbox
gCHECKBOX2 Boolean
Another checkbox
gCHECKBOX3 Boolean
Another checkbox
gCHECKBOX4 Boolean
Another checkbox
gCHECKBOX5 Boolean
 
gCHECKBOX6 Boolean
 
gCHECKBOX7 Boolean
 
gCHECKBOX8 Boolean
 
gPERIOD_DATE Short date
1980..2079
Yes/Empty.
gCLONE Boolean
 
gPMT Number
2 dp
generic payment amount
gLAST_JOB_NUM char
10
last job number used
gSTATUS Number
0 dp
status code
gAE_TEAM char
10
 
gTEXT1 char
32000
General Purpose String
gTEXT2 char
32000
 
gRIGHT_POSITION Number
0 dp
 
gBOTTOM_POSITION Number
0 dp
 
gTO_DO List
What's Due Today list
gGL Number
2 dp
misc G/L#
gPOST short int
(0 to 255)
posting option - one/all/proof list
gPOST_USER char
4
posting option - which user's entries?
gPOST_ONLY short int
(0 to 255)
posting option - post only one user's entries
gPOST_PER_ONLY short int
(0 to 255)
posting option - post only one period
gPOST_PERIOD short int
(0 to 255)
posting option - post which period?
gINTEGER1 short int
(0 to 255)
 
gBILLING_TYPE char
15
type of A/R invoice
gTIME_PRINTED Date
h:N A
date and time report was printed
gPC char
10
profit center variable for printing financials
gPERIOD Short num
0 dp
variable for printing
gSORT1 char
1
sort indicator: »
gSORT2 char
1
sort indicator: »
gSORT3 char
1
sort indicator: »
gSORT4 char
1
sort indicator: »
gSORT5 char
1
sort indicator: »
gSORT_DIRECTION char
1
sort direction (up or down)
gREPORT_NOTE char
32000
user-defined note on reports at time of printing
gLABEL1 char
20
user-defined report column heading
gLABEL2 char
20
 
gLABEL3 char
20
 
gDGL Short num
2 dp
 
gCGL Short num
2 dp
 
gVIEW_TIME_SHEET List
view time sheets
gLINE_EMPTY short int
(0 to 255)
 
gSEE_DESC short int
(0 to 255)
show description on reports
gCHECKS_LIST List
 
gHIDE short int
(0 to 255)
hide sub-total heading, sub-total sections on reports
gHILITE char
10
underline/hilite character
gSEE_TASK_SPECS National
0
 
gFROM_NUMBER Number
2 dp
used in searches
gTO_NUMBER Number
2 dp
used in searches
gTITLE char
120
report title
gAGING_PER1 Short num
0 dp
 
gAGING_PER2 Short num
0 dp
 
gAGING_PER3 Short num
0 dp
 
gAGING_PER4 Short num
0 dp
 
gJOB char
10
job number; used to decrement auto-job number
gDATE Short date
1980..2079
Yes/Empty.
gDATE_FROM Short date
1980..2079
Yes/Empty.
gDATE_TO Short date
1980..2079
Yes/Empty.
gLINE Short num
0 dp
line number
gTASK char
4
 
gLIST_TARGET2 char
40
original list target (before using lookup lists)
gPRINT Short num
0 dp
 
gVENDOR char
20
 
gDATE_TIME1 Date and time
(#FDT)
 
gDATE_TIME2 Date and time
(#FDT)
 
gPUB_LIST List
Publications list
gAD_SIZE_LIST List
Ad Sizes list
gCLIENT char
10
 
gPERCENT2DPS Number
2 dp
 
gSTART_TIME Short time
 
gELAPSED_TIME Number
1 dp
 
gSTOP_TIME Short time
 
gPMT_AMT Number
2 dp
 
gPMT_TO_GO Number
2 dp
 
gLIST_TASKTABLE List
 
gW_WORK char
4
user's inititals (to lookup W_WORK)
gPERIOD_LIST List
period list for add, edit windows
gPERIOD_NAME char
40
period name + number
gPERIOD_PRINT_LIST List
period list for print windows
gSHOW short int
(0 to 255)
gSHOW/gHIDE (show/hide lines on reports)
gCOST Number
2 dp
cost amount
gGROSS Number
2 dp
gross amount
gFIND_JOB_LIST List
 
gGraph1 Picture
picture of graph 1 to appear on reports
gGraph2 Picture
picture of graph 2 to appear on reports
gSMTP_SERVER_NAME char
40
e-mail: name of server to contact
gFROM_EMAIL_ADDRE SS char
40
e-mail: from address
gTO_EMAIL_ADDRESS char
40
e-mail: the TO recipient
gSUBJECT char
120
e-mail: subject of mail
gBODY char
32000
e-mail: body of email
gCC char
40
e-mail: contains the CC recipient
gBCC char
40
e-mail: contains the BCC recipient
gREAL_NAME char
100
e-mail: real name of sender
gFIND_JE_LIST List
list on the Find JE window
gFIND_COST_LIST List
list on the Find Expense window
gFIND_PAYMENT_LIST List
list on Find Payments window
gITEM char
10
charge items - item code
gSIZE char
6
charge items - size
gTITLE2 char
100
 
gHIDE2 short int
(0 to 255)
 
gBLOCK_CALLS short int
(0 to 255)
 
gSORT Number
0 dp
 
gEDATA short int
(0 to 255)
global flag for enter data
gMENU_TITLE char
20
user-defined context menu variable
gFIND_AP_LIST List
 
gWEB_WORK char
4
web access - current user
gWEB_STATUS char
200
web access - current system status
gWEB_SINCE Date and time
(#FDT)
web access - date/time since last start
gCGI_VALUES_LIST List
web access
gURL char
10000000
web access
gCGI_LIST List
web access
gWEB_LOG List
web access
gCHECK1 char
10
web access
gCHECK2 char
10
web access
gCHECK3 char
10
web access
gCHECK4 char
10
web access
gCHECK5 char
10
web access
gCHECK6 char
10
web access
gCHECK7 char
10
web access
gCHECK8 char
10
web access
gCHECK9 char
10
web access
gCHECK10 char
10
web access
gCOOKIE char
10000000
web access
gREFERRER char
100
web access
gREMOTE_ADDRESS char
20
web access
gDATABASE_PATH char
100
web access
gPROGRAM short int
(0 to 255)
which version? 0=CL/1=JT/2=PRO/3=S QL
gDEMO short int
(0 to 255)
demo mode (0=no/1=trial)
gWEB_IP_LIST List
 
gNEXT_CHECKED short int
(0 to 255)
did the software update run today?

LEGEND:

Type indicates whether a field contains characters (i.e., "char") which contains any combination of letters or numbers, numbers (which has a set number of decimal places), or integers (i.e., numbers that range from 0 to 255 only).

Length shows the size of a field. Character fields have lengths that are fixed, depending on their purpose. Description and note fields have a length of 32000, which make them variable-length; their actual size depends on how much data is entered into them.

Index indicates fields that are indexed in the database, which makes them key fields for finding and sorting data. For best performances on reporting and exporting, searches should made on index fields first.

Need help exporting? See the Exporting Data from Clients & Profits tech note.


For subscribers: VIDEOS } FAQs/TECH NOTES } COMMUNITY } LEARN } BUGS/WISH LIST } TIPS Most popular:
     Sign up for Clients & Profits news:
   flag  © Clients & Profits Worldwide   w e  l o v e  a d v e r t i s i n g