C&P Data Dictionary: HISTORY

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

HISTORY is the data file that stores the Job Diary Entries. Each HISTORY record contains a single Job diary Entry. It is a data file used for the printable version of the Job History. Each HISTORY record has fields for the person's initials that added the entry (H_WHO) the date and time of the entry (H_DATE) and a description of the entry (H_DESC) for each job diary entry. These amount fields are updated when entries are posted. See related data files:   CHANGE_ORDERS   PICTURES Field Name: Type: Length: Index: Description: H_SEQUENCE sequence x sequence # H_JOB_NUM char 10 x job number H_NUM number 0dp record ID number H_WHO char 4   who added this diary entry? H_DATE date (#FDT) date, time of diary entry H_DESC char 32000   what happened? H_RESOLVED integer x resolved? (yes/no) (not implemented) H_FOR char 4   who is this record for? H_USER_NOTE char 32000 user-defined notes H_MAIL_TO char 32000   e-mail to 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.