C&P Data Dictionary: WORKSHEET

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

WORKSHEET is the data file that stores the Estimate Worksheet. Each WORKSHEET record contains a single expense worksheet estimate. Each WORKSHEET record has fields for Staff initials, estimated hours and estimated rate (i.e., EST_LINE1 through EST_LINE4, EST_HRS1 thru EST_HRS4, EST_RATE1thru EST_RATE4) and estimated expenses (i.e., EST_RESOURCE1 through EST_RESOURCE4 and EST_AMT1 thru EST_AMT4) for each different accounting period. These amount fields update the estimated hours column of the Job Schedule. See related data files:  STATUS_CODES Field Name: Type: Length: Index: Description: EST_SEQ sequence x EST_KEY char 15 x job+task+column number EST_LINE1 char 20 EST_LINE2 char 20     EST_LINE3 char 20 EST_LINE4 char 20     EST_AMT1 number 2dp EST_AMT2 number 2dp     EST_AMT3 number 2dp EST_AMT4 number 2dp     EST_RESOURCE1 char 10 EST_RESOURCE2 char 10     EST_RESOURCE3 char 10 EST_RESOURCE4 char 10     EST_RATE1 number 2dp EST_RATE2 number 2dp     EST_RATE3 number 2dp EST_RATE4 number 2dp     EST_HRS1 number 2dp EST_HRS2 number 2dp     EST_HRS3 number 2dp EST_HRS4 number 2dp     EST_JOB_NUM char 10 x EST_COLUMN integer       EST_TASK char 4 EST_MARKUP number 2dp     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.