C&P Data Dictionary: CHECKS

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

CHECKS is the header file that stores checks. Each CHECKS record contains a single check. It is a data file used for printing checks. Each record has fields for payee name and address (i.e.,CK_PAYEE and CK_ADDRESS1-3), amounts to pay (i.e., CK_AMOUNT, CK_NET_AMT, and CK_GROSS [net & gross amounts are for job cost checks]) for each check. These amount fields are updated when entries are posted. Financial statements are also created from these amount fields. See related data files:   VENDORS    CHECK_ITEMS Field Name: Type: Length: Index: Description: CK_SEQ sequence x sequence # CK_NUM number 0dp x check number CK_VENDOR_NUM char 10 x vendor number (-- for direct disbursements) CK_PAYEE char 40 x payee name CK_ADDRESS1 char 40 payee address 1 CK_ADDRESS2 char 40   payee address 2 CK_ADDRESS3 char 40 payee address 3 CK_DATE date   x check date CK_POSTED date x date posted into G/L CK_MEMO char 32000   check memo CK_NET_AMT number 2dp check net amount CK_CGL number 2dp   check's credit G/L# (usually cash) CK_PAY integer check type (1=vendor payment/0 =disbursement) CK_ADDED_BY char 4   added by who? CK_ADDED_WHEN date date added CK_CLEARED integer     cleared the bank? flag CK_DONT_PRINT integer handwritten check/don't print it flag CK_AMOUNT char 80   written amount of check CK_TYPE char 10 x check type (usually "Check") CK_GROSS number 2dp   check amount + markup CK_DISC_AMT number 2dp discount amount CK_DISC_GL number 2dp   discount G/L CK_OK integer x check in balance? flag CK_PERIOD number 0dp   accounting period CK_1099 integer include on year-end 1099 report? flag CK_TAX_ID char 15   vendor tax ID - for 1099s CK_EMP_ADV_EXP number 2dp employee's expense advances - posted so far CK_EMPL_ADV_CK number 0dp   empl's exp adv - their check 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.