|
Database tables
|
Previous Top Next |
|
Database name
|
HQL name
|
Description
|
|
CUS
|
Cus
|
List of customers
|
|
ACIT
|
acit
|
Address - city
|
|
ACTR
|
actr
|
Address - Country
|
|
ACTY
|
acty
|
Address - county
|
|
APCO
|
apco
|
Address - post code
|
|
ASTR
|
astr
|
Address - street
|
|
DSCR
|
dscr
|
Descripton
|
|
EMAL
|
emal
|
Contact email address
|
|
FNAM
|
fnam
|
FIrst name of a person
|
|
NAME
|
name
|
Name of company/last name
of a person
|
|
NCUS
|
ncus
|
Identificator
|
|
PERS
|
pers
|
Flag (Y/N) if this record
describes a person (Y) or a
company (N)
|
|
PHON
|
phon
|
Contact phone
|
|
SACTD
|
sactd
|
Record's last update date
|
|
SCRTD
|
scrtd
|
Record's created date
|
|
|
jobs
|
List of jobs that belong to
customer
|
|
DIC
|
Dic
|
Dictionary entries;
Dictionary types grouped
by DTYP field.
|
|
ACTV
|
actv
|
Flag if entry is still in use (Y)
or not (N)
|
|
DETA
|
deta
|
Details
|
|
DTYP
|
dtyp
|
Dictionary to which entry
belongs to: 1 - Job status; 2 -
Payment type
|
|
NDIC
|
ndic
|
Identificator
|
|
SACTD
|
sactd
|
Record's update date
|
|
SCRTD
|
scrtd
|
Record's created date
|
|
VALU
|
valu
|
Value
|
|
JOB
|
Job
|
List of jobs
|
|
DSCR
|
dscr
|
Description
|
|
INVD
|
invd
|
Invoice send date
|
|
JDTE
|
jdte
|
Date of job
|
|
NCUS
|
ncus
|
Identificator of customer
(foreign key to CUS table)
|
|
NJOB
|
njob
|
Identificator
|
|
PAYD
|
payd
|
Date of payemnt; If null - not
paid;
|
|
PAYT
|
payt
|
Payment type (foreign key to
DIC table)
|
|
PRIC
|
pric
|
Price
|
|
SACTD
|
sactd
|
Record's update date
|
|
SCRTD
|
scrtd
|
Record's created date
|
|
SRTY
|
srty
|
Not used
|
|
STAT
|
stat
|
Job status (foreign key to DIC
table)
|
|
TITL
|
titl
|
Title
|
|
|
dicByStat
|
Dic object referenced by
STAT field;
|
|
|
dicByPayt
|
Dic object referenced by
PAYT field;
|
|
|
cus
|
Cus object referenced by
NCUS;
|
|
RDF
|
Rdf
|
Reports definitions
|
|
ADMN
|
admn
|
Flag if report is for
administratorr only (Y) or fol
all users (N); Not used;
|
|
GRBY
|
grby
|
GROUP BY statement of
report's summary query
|
|
NAME
|
name
|
Name of report
|
|
NRDF
|
nrdf
|
Identificator
|
|
ORBY
|
orby
|
ORDER BY part of report
query
|
|
SACTD
|
sactd
|
Record's updated date
|
|
SCRTD
|
scrtd
|
Record's created date
|
|
SLFR
|
slfr
|
FROM part of report query
|
|
SLSC
|
slsc
|
Part of WHERE clause added
for non-admin users for
security reasons; Not used;
|
|
SLSE
|
slse
|
SELECT part of report query
|
|
SLWH
|
slwh
|
WHERE part of report query
|
|
SUSE
|
suse
|
SELECT statement of
report's summary
|
|
RPR
|
Rpr
|
List of reports parameters
|
|
DSEC
|
dsec
|
Additional WHERE clause
added to DSQL if user is not
administrator; Not used in
Simple CRM.
|
|
DSQL
|
dsql
|
Full HQL query to get data if
PTYP=C; The first column in
HQL must be an id field, the
second - visible description
|
|
DVAL
|
dval
|
Default value
|
|
NAME
|
name
|
Name of parameter, visible to
user
|
|
NRDF
|
nrdf
|
Identificator of report to which
the parameter belongs
(foreign key to RDF table)
|
|
NRPR
|
nrpr
|
Identificator
|
|
PARM
|
parm
|
Name of placeholder in
SLWH field which will be
replaced with value entered
by user;
|
|
PTYP
|
ptyp
|
Type of parameter: S - text, D
- date, F - float, I - integer, C -
combo box with values from
database, V - check box
(NULL/NOT NULL)
|
|
REQU
|
requ
|
Flag if parameter is required
(Y) or ot (N)
|
|
SACTD
|
sactd
|
Record's update date
|
|
SCRTD
|
scrtd
|
Record's creation date
|
|
SLWH
|
slwh
|
WHERE clause added to the
report query if this parameter
is selected; PARM is
replaced with value entered
by user;
|
|
VER
|
Ver
|
Database version,
upgrades history
|
|
DBVR
|
dbvr
|
Version
|
|
SACTD
|
sactd
|
Record update date
|
|
SCRTD
|
scrtd
|
Record creation date
|