|
C&P Data
Dictionary: DEPTS |
Other files:
ACC_PERIODS
ACCOUNTS
AP
AR
AR_ITEMS
BILLING_INFO
CHANGE_ITEMS
CHANGE_ORDER
CHECKS
CHECK_ITEMS
CLIENTS
COSTS
DATE_COUNT
EST_REVS
FINANCE
GROUPS
INT_ITEMS
JE
JOBS
JOB_ORDER
JOB_TASK
JOB_TYPES
MEDIA_BRIEFS
MEDIA_EST
MEDIA_EST_ITEMS
MEDIA_ITEMS
MEDIA_PLANS
PAYMENTS
PAYMENT_ITEMS
PC
PO_ITEMS
PO_TEMPLATE
PRINT_SPECS
PROGRAMS
PROJECTS
PROPOSALS
PURCHASE_ORDER
RATES
RECUR_AP
RETAINERS
SCHEDULE_CHART
SCHEDULE_HEADER
STATEMENTS
STATIONS
STATUS_CODES
SUB_CLASSES
TASK_TABLE
TEMP_TASKS
TIMECARD
TIMELINE
VENDORS
WORKING
WORKSHEETS
Y1099
|
DEPTS is
the lookup file that stores the departments. Each DEPTS record
contains a single department. Each DEPTS record has fields for
office, name, description, manager etc. (i.e., DEPT_OFFICE, DEPT_NAME,
DEPT_DESC, DEPT_MGR). Some productivity reports use information
stored in these fields.
See related data files: STAFF ACCOUNTS
Field
Name: |
Type: |
Length: |
Index: |
Description: |
DEPT_SEQ |
sequence |
|
x |
|
DEPT_OFFICE |
char |
10 |
|
|
DEPT_NAME |
char |
15 |
x |
department name |
DEPT_DESC |
char |
40 |
|
department description |
DEPT_MGR |
char |
10 |
|
department manager (S_INITIALS) |
DEPT_NUM |
short num |
0dp |
x |
department number |
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.
|
|
|
© 2012 Clients & Profits Worldwide w
e l o v e a d v e r t i s i n g |
|
|