C&P Data Dictionary: CHECK_ITEMS

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

CHECK_ITEMS is the data file that stores the Check line items. Each CHECK_ITEMS record contains a single check line item. Each CHECK_ITEMS record has fields for the check line item's debit G/L (A/P invoice or job cost) held in the CX_DGL field, vendor & invoice numbers for payment (CX_AP_NUM and CX_VENDOR_NUM), and job or task number for expenses (CX_JOB_NUM and CX_TASK). These fields are updated when checks are saved.   See related data files:   CHECKS   AP Field Name: Type: Length: Index: Description: CX_SEQ sequence x sequence CX_CK_DATE date   x check date CX_NET_AMT number 2dp net cost amount CX_DGL number 2dp   check line item's debit G/L# (usually A/P or job cost) CX_AP_NUM char 20 x invoice number (for payment) CX_VENDOR_NUM char 10 x vendor number (for payment) CX_JOB_NUM char 10 job number (for expense) CX_TASK char 4   task (for expense) CX_POSTED date x date posted CX_GROSS_AMT number 2dp   gross amount, including markup CX_CK_NUM number 0dp x check number CX_COMM_AMT number 2dp   commission amount CX_MARKUP_PC number 2dp markup % CX_DISC_AMT number 2dp   discount amount CX_PERIOD integer x accounting period CX_COST_SEQ number 0dp   seq # of COSTS record CX_DISC_DGL number 2dp discount taken dGL CX_BILLABLE integer     billable? 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.