Clients & Profits | Data Dictionary

Free help: USER GUIDE } WHAT'S NEW

Home > Support > Data Dictionary > ACCOUNTS

C&P Data Dictionary: ACCOUNTS

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

ACCOUNTS is the data file that stores the Chart of Accounts. Each ACCOUNTS record contains a single G/L account. It is a lookup file used primarly on G/L reports (e.g., Audit Trail) and financials (e.g., Income Statement, Trial Balance, etc.). Each ACCOUNT record has fields for budget amounts (i.e., AC_BUDGET1 through AC_BUDGET24) and actual amounts (i.e., AC_1 through AC_24) for each different accounting period. These amount fields are updated when entries are posted. Financial statements are also created from these amount fields.

See related data files: JE SUB_CLASSES

Field Name:	Type:	Length:	Index:	Description:
AC_NUM	number	2dp	X	account number
AC_NAME	national	40	X	account name (description)
AC_CLASS	number	0dp	X	account classification
AC_SUB_CLASS	number	0dp		sub-class
AC_CONFIDENTIAL	short num	0dp		confidential flag (yes/no)
AC_ROLLUP_ONLY	short int	(0 to 255)	X	Roll-up only account?
AC_CK_NUM	number	0dp		next check number
AC_PC	char	10	X	profit center
AC_1	number	2dp		monthly balances
AC_2	number	2dp		monthly balances
AC_3	number	2dp		monthly balances
AC_4	number	2dp		monthly balances
AC_5	number	2dp		monthly balances
AC_6	number	2dp		monthly balances
AC_7	number	2dp		monthly balances
AC_8	number	2dp		monthly balances
AC_9	number	2dp		monthly balances
AC_10	number	2dp		monthly balances
AC_11	number	2dp		monthly balances
AC_12	number	2dp		monthly balances
AC_BEG_BALN	number	2dp		retained earnings (AM 2.0)
AC_BUDGET1	number	2dp		budgeted balances
AC_BUDGET2	number	2dp		budgeted balances
AC_BUDGET3	number	2dp		budgeted balances
AC_BUDGET4	number	2dp		budgeted balances
AC_BUDGET5	number	2dp		budgeted balances
AC_BUDGET6	number	2dp		budgeted balances
AC_BUDGET7	number	2dp		budgeted balances
AC_BUDGET8	number	2dp		budgeted balances
AC_BUDGET9	number	2dp		budgeted balances
AC_BUDGET10	number	2dp		budgeted balances
AC_BUDGET11	number	2dp		budgeted balances
AC_BUDGET12	number	2dp		budgeted balances
AC_B13	number	2dp		budgeted balances
AC_L1	number	2dp		last year's balances
AC_L2	number	2dp		last year's balances
AC_L3	number	2dp		last year's balances
AC_L4	number	2dp		last year's balances
AC_L5	number	2dp		last year's balances
AC_L6	number	2dp		last year's balances
AC_L7	number	2dp		last year's balances
AC_L8	number	2dp		last year's balances
AC_L9	number	2dp		last year's balances
AC_L10	number	2dp		last year's balances
AC_L11	number	2dp		last year's balances
AC_L12	number	2dp		last year's balances
AC_L_BEG_BALN	number	2dp		last year's balances
AC_GROUP	number	0dp		account group
AC_CATEGORY	number	0dp		account category
AC_YTD	number	2dp		year-to-date account balance
AC_SEQ	sequence		x	sequence
AC_ROLL_UP	number	2 dp		consolidation account
AC_ACTIVE	number	0 dp		active account
AC_CK_ACCT	number	0 dp		checking account?
AC_DESC	char	2000		account description
AC_13	number	2 dp		monthly balances
AC_14	number	2 dp		monthly balances
AC_15	number	2 dp		monthly balances
AC_16	number	2 dp		monthly balances
AC_17	number	2 dp		monthly balances
AC_18	number	2 dp		monthly balances
AC_19	number	2 dp		monthly balances
AC_20	number	2 dp		monthly balances
AC_21	number	2 dp		monthly balances
AC_22	number	2 dp		monthly balances
AC_23	number	2 dp		monthly balances
AC_24	number	2 dp		monthly balances
AC_YTD2	number	2 dp		ytd totals - year 2
AC_CF	short int	(0 to 255)	x	stmt of cash flow category
AC_RATIO	short int	(0 to 255)		ratio caregory
AC_AR_CONTROL	number	0 dp	x	specifies whether account is a/r control account or not
AC_AP_CONTROL	number	0 dp	x	specifies whether account is a/p control account or not
AC_AR_LOCK	char	0		OBSOLETE
AC_AP_LOCK	char	0		OBSOLETE
AC_DEPT	short num	0 dp
AC_BUDGET13	number	2 dp		budgeted balances
AC_BUDGET14	number	2 dp		budgeted balances
AC_BUDGET15	number	2 dp		budgeted balances
AC_BUDGET16	number	2 dp		budgeted balances
AC_BUDGET17	number	2 dp		budgeted balances
AC_BUDGET18	number	2 dp		budgeted balances
AC_BUDGET19	number	2 dp		budgeted balances
AC_BUDGET20	number	2 dp		budgeted balances
AC_BUDGET21	number	2 dp		budgeted balances
AC_BUDGET22	number	2 dp		budgeted balances
AC_BUDGET23	number	2 dp		budgeted balances
AC_BUDGET24	number	2 dp		budgeted balances
AC_CORP_ID	char	100		corporate G/L account 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.

For subscribers: VIDEOS } FAQs/TECH NOTES } LEARN

Sign up for Clients & Profits news:
© Clients & Profits, Inc. w e l o v e a d v e r t i s i n g