Clients & Profits Worldwide :: Data Dictionary

Free help: USER GUIDE } BLOG } SYSTEM MANAGER NEWS

Home > Support > Data Dictionary > CHANGE_ORDER

C&P X Data Dictionary: CHANGE_ORDER

Other files:

ACC_PERIODS
ACCOUNTS
AP
AR
AR_ITEMS
BILLING_INFO
CHANGE_ITEMS
CHANGE_ORDER
CHECKS
CHECK_ITEMS
CLIENTS
COSTS
DATE_COUNT
EST_REVS
FINANCE
GROUPS
INT_ITEMS
JE
JOBS
JOB_ORDER
JOB_TASK
JOB_TYPES
MEDIA_BRIEFS
MEDIA_EST
MEDIA_EST_ITEMS
MEDIA_ITEMS
MEDIA_PLANS
PAYMENTS
PAYMENT_ITEMS
PC
PO_ITEMS
PO_TEMPLATE
PRINT_SPECS
PROGRAMS
PROJECTS
PROPOSALS
PURCHASE_ORDER
RATES
RECUR_AP
RETAINERS
SCHEDULE_CHART
SCHEDULE_HEADER
STATEMENTS
STATIONS
STATUS_CODES
SUB_CLASSES
TASK_TABLE
TEMP_TASKS
TIMECARD
TIMELINE
VENDORS
WORKING
WORKSHEETS
Y1099

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.

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 & time	(#FDT)	x	change order date
CHANGE_DESC	char	60		change order short description called CHANGE_SUBJECT in DML
CHANGE_OK	number	0dp		ok'd by client?
CHANGE_NOTE	char	2000		full description - misc notes called CHANGE_DESC in DML
CHANGE_AMT1	short num	2dp		change order amount 1
CHANGE_TYPE	short num	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	short num	2dp		change order total
CHANGE_TASK5	char	4		job task 5
CHANGE_TASK6	char	4		job task 6
CHANGE_AMT5	short num	2dp		change order amount 5
CHANGE_AMT6	short num	2dp		change order amount 6
CHANGE_OTHER	char	20		text for "other" change order type
CHANGE_NAME	char	40		client contact
CHANGE_BAMT1	short num	2dp		change order amount 1 - budget
CHANGE_BAMT2	short num	2dp		change order amount 2 - budget
CHANGE_BAMT3	short num	2dp		change order amount 3 - budget
CHANGE_BAMT4	short num	2dp		change order amount 4 - budget
CHANGE_BAMT5	short num	2dp		change order amount 5 - budget
CHANGE_BAMT6	short num	2dp		change order amount 6 - budget
CHANGE_SALES_TAX1	short num	2dp
CHANGE_SALES_TAX2	short num	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	short num	2dp		change order hours 1
CHANGE_HOURS2	short num	2dp
CHANGE_HOURS3	short num	2dp
CHANGE_HOURS4	short num	2dp
CHANGE_HOURS5	short num	2dp
CHANGE_HOURS6	short num	2dp
CHANGE_ROLL_UP	short int	(0 to 255)		roll up?
CHANGE_STATUS	char	40
CHANGE_APPROVE	short int	(0 to 255)		who approved this? 0=CHANGE_NAME 1=job's approvers 2=no approval needed
CHANGE_MAIL_TO	char	2000		e-mail addresses who get approved change orders
CHANGE_SEND_PDF	short int	(0 to 255)		0=send text 1= attach PDF

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.

For subscribers: VIDEOS } FAQs/TECH NOTES } COMMUNITY } LEARN } BUGS/WISH LIST } TIPS