C&P Data Dictionary: TASK_TABLE

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

TASK_TABLE See related data files:   JE   SUB_CLASSES Field Name: Type: Length: Index: Description: T_SEQ sequence x T_TASK char 4 x   T_NAME char 50   task name or description T_TAX1 short int (0-255)   taxable? T_TAX2 short int (0-255) taxable? T_TASK char 4 x   T_MARKUP short num 2dp     T_BILL_RATE short num 2dp   T_DGL num 2dp   T_CGL num 2dp   T_GROUP short num 0dp   T_SORT short num 0dp   T_LEAD_TIME short num 0dp   T_KIND short int (0-255) 0=est, traffic / 1=traffic only / 2=est only / 3=costing only T_HOURS short num 2dp   T_COST short num 2dp   T_PC char 10 profit center T_DESC char 2000 default task desc [old T_TEMPLATE2] T_CHAR2 char 1 old T_TEMPLATE3 T_CHAR3 char 1 old T_TEMPLATE4 T_CHAR4 char 1 old T_TEMPLATE5 T_CHAR5 char 1 old T_TEMPLATE6 T_CHAR6 char 1 old T_TEMPLATE7 T_CHAR7 char 1 old T_TEMPLATE8 T_UNBILLABLE short num 0dp unbillable task (global variable) T_SORT_PROD short num 0dp sort - scheduling only T_PREF3 short num 0dp unused preference T_PREF4 short num 0dp unused preference T_AMT1 short num 0dp unused amount T_AMT2 short num 0dp unused amount T_ICON picture icon / picture T_ROLL_UP char 4   T_ACTIVE short int (0-255) active task? 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.