C&P Data Dictionary: CHANGE_ORDER

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

CHANGE_ORDER is the data file that stores the data for change orders. Each CHANGE_ORDER record contains a single change order. Each CHANGE_ORDER record has fields for Job Number, When, Who, Ammount, and What (i.e. CHANGE_JOB_NUM, CHANGE_DATE, CHANGE_WHO, CHANGE_AM1, CHANGE_NOTE). When a change order is saved it is displayed in the "chg orders" column of the tasks portion of the job window. See related data files:   Field Name: Type: Length: Index: Description: CHANGE_SEQ sequence x sequence # CHANGE_JOB_NUM char 10 x job number CHANGE_TASK1 char 4 job task 1 CHANGE_NUM char 14   change order number in the form of jobnum/001 CHANGE_WHO char 4 who added this? CHANGE_DATE date x change order date CHANGE_DESC char 60 change order description CHANGE_OK number 0dp   ok'd by client? CHANGE_NOTE char 32000 misc notes CHANGE_AMT1 number 2dp   change order amount 1 CHANGE_TYPE number 0dp 0=Add'l info/1=client rev/ 2=agency correction/3=FYI CHANGE_TASK2 char 4   job task 2 CHANGE_TASK3 char 4 job task 3 CHANGE_TASK4 char 4   job task 4 CHANGE_AMT2 number 2dp change order amount 2 CHANGE_AMT3 number 2dp   change order amount 3 CHANGE_AMT4 number 2dp change order amount 4 CHANGE_TOTAL number 2dp   change order total CHANGE_TASK5 char 4 job task 5 CHANGE_TASK6 char 4   job task 6 CHANGE_AMT5 number 2dp change order amount 5 CHANGE_AMT6 number 2dp   change order amount 6 CHANGE_OTHER char 20 text for "other" change order type CHANGE_NAME char 40   client contact CHANGE_BAMT1 number 2dp change order amount 1 - budget CHANGE_BAMT2 number 2dp   change order amount 2 - budget CHANGE_BAMT3 number 2dp change order amount 3 - budget CHANGE_BAMT4 number 2dp   change order amount 4 - budget CHANGE_BAMT5 number 2dp change order amount 5 - budget CHANGE_BAMT6 number 2dp   change order amount 6 - budget CHANGE_SALES_TAX1 number 2dp CHANGE_SALES_TAX2 number 2dp     CHANGE_ROLLUP1 char 4 roll up task CHANGE_ROLLUP2 char 4     CHANGE_ROLLUP3 char 4 CHANGE_ROLLUP4 char 4     CHANGE_ROLLUP5 char 4 CHANGE_ROLLUP6 char 4   CHANGE_HOURS1 number 2dp change order hours 1 CHANGE_HOURS2 number 2dp     CHANGE_HOURS3 number 2dp CHANGE_HOURS4 number 2dp     CHANGE_HOURS5 number 2dp CHANGE_HOURS6 number 2dp     CHANGE_ROLL_UP integer roll up? 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.