C&P Data Dictionary: ACCOUNTS

Other files: ACCOUNTS AP AR AR_ITEMS BILLING_INFO CHANGE_ORDER CHECKS CHECK_ITEMS CLIENTS COSTS DEPTS GROUPS HISTORY HISTORY_CLIENT INT_ITEMS JE JOBS JOB_ORDER JOB_TASK JOB_TYPES MEDIA_EST MEDIA_EST_ITEMS MEDIA_ITEMS MEDIA_PLANS PAYMENTS PAYMENT_ITEMS PC PICTURES PO_ITEMS PO_TEMPLATE PRINT_SPECS PROGRAMS PROJECTS PURCHASE_ORDER RATES RECUR_AP RETAINERS STAFF STATIONS STATUS_CODES SUB_CLASSES TASK_TABLE VENDORS WEB_IP_LOG WEB_USERS WORKSHEETS

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 char 40 X account name (description) AC_CLASS number 0dp X account classification AC_SUB_CLASS number 0dp   sub-class AC_CONFIDENTIAL number 0dp confidential flag (yes/no) AC_ROLLUP_ONLY integer 0dp 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 OBSOLETE 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 for period 6 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 32000 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 integer x stmt of cash flow category AC_RATIO short int integer 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.