C&P Data Dictionary: PAYMENTS

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

PAYMENTS See related data files:   JE   SUB_CLASSES Field Name: Type: Length: Index: Description: PAY_SEQ sequence x PAY_CLIENT_NUM char 10 x client number PAY_CHECK_NUM char 10 x clients check number PAY_AMT number 2dp   check amount PAY_CHECK_DATE date x check date PAY_TYPE char 10   type (payment, credit, write-off) PAY_DATE date x date of deposit PAY_DESC char 32000   description PAY_DGL number 2dp PAY_BOOLEAN boolean       PAY_POSTED date x date posted into g/l PAY_ADDED_BY char 4   added by whom? PAY_ADDED_WHEN date x date added PAY_OK integer   x is it in balance? PAY_PERIOD number 0dp accounting period PAY_BANK char 10     PAY_KIND integer 0=one client/1=many clients PAY_BATCH char 10 x Batch ID for bank reconciliation 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.