C&P Data Dictionary: JOBS

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

JOBS is the data file that stores the Job Ticket Header Data. Each JOBS record contains a single Job Ticket. It is a data file used primarly on . Each JOBS record has fields for Job Ticket data (i.e., J_NUM, J_CLIENT_NUM, J_DESC, etc.), Job Costing data (i.e., J_AMT1 thru J_AMT6) and Milestone Data (i.e., J_MILE1 thru J_MILE12) for each Job Ticket. These fields are updated when a new Job ticked is created. Financial statements are also created from these amount fields. See related data files:   JOB_TYPES    STATUS_CODES   JOB_TASK   CLIENTS Field Name: Type: Length: Index: Description: J_SEQ sequence Indexed sequence # J_NUM char 10 Indexed job number J_START_DATE date Indexed date job is opened/started J_NAME char 60 Indexed job name/title J_CLIENT_NUM char 10 Indexed client number J_CLOSED integer     job closed? flag (yes/no) J_DUE_DATE date Indexed due/finished date J_USER_FIELD2 char 15 Indexed client's PO number J_CONT_AMT number 2dp estimate contingency % J_REVISION number 0dp   current revision # of estimate J_USER_FIELD1 char 20 Indexed project code (user-defined name) J_PROD_STATUS number 0dp Indexed production status J_DESC char 32000 job description or specifications J_WHO char 4   initials of person who opened the job J_CLIENT_CONTACT char 30 Indexed client contact J_AGENCY_CONTACT char 30   agency contact J_AE_TEAM char 10 Indexed AE (dept, or acct team) J_TYPE char 15 Indexed job type (a lookup table) J_AMT1 number 2dp J_AMT2 number 2dp     J_AMT3 number 2dp J_AMT4 number 2dp     J_AMT5 number 2dp J_AMT6 number 2dp     J_NEXT_STEPS char 32000 next steps or status description J_DATE_ADDED date     date job was added, not started J_PC char 10 profit center J_CONT_NOTE char 32000   contingency description J_BILL_STATUS number 0dp Indexed billing status J_MILE1 char 6   traffic milestone J_MILE2 char 6 traffic milestone J_MILE3 char 6   traffic milestone J_MILE4 char 6 traffic milestone J_MILE5 char 6   traffic milestone J_MILE6 char 6 traffic milestone J_MILE7 char 6   traffic milestone J_MILE8 char 6 traffic milestone J_MILE9 char 6   traffic milestone J_MILE10 char 6 traffic milestone J_MILE11 char 6   traffic milestone J_MILE12 char 6 traffic milestone J_HISTORY_COUNT number 0dp   quantity of history records J_CONTINGENCY integer type of contingency (0=%, 1=$) J_CONT_PC number 2dp   contingency $ amount J_EST_FORM char 20 ad hoc report form name J_APPROVAL1 char 40   estimate approval 1 J_APPROVAL2 char 40 estimate approval 2 J_APPROVAL3 char 40   estimate approval 3 J_SHOW_ZERO_AS char 15 show zero as placeholder J_HEADING char 25   estimate heading/title 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.