Clients & Profits Worldwide :: Data Dictionary

Free help: USER GUIDE } BLOG } SYSTEM MANAGER NEWS

Home > Support > Data Dictionary > PROGRAMS

C&P Data Dictionary: PROGRAMS

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

Field Name:	Type:	Length:	Index:	Description:
PGM_SEQ	sequence		x	PGM/AD SIZE RSN
PGM_CODE	char	20	x	Publication code/Station letters
PGM_TIME_PGM	char	30	x	Program - time
PGM_RATING_EA	short num	2dp		Program - rating/each spot
PGM_COST_EA	short num	2dp		Program - cost/each spot
PGM_GROUP	char	6		Program - group (for sub-totaling)
PGM_NOTE	char	2000		Program - Notes
PGM_TYPE	char	2	x	PR=Print/TV=Television RA=Radio/CA=Cable/
AD_NAME	char	30		Ad Size - Space/Name
AD_POSITION	char	30		Ad Size - Position
AD_NOTES	char	2000		Ad Size - Notes
AD_GROSS_AMT	number	2dp		Ad Size - Gross Amount
AD_COMM	short num	2dp		Ad Size - Commission %
AD_NET_AMT	number	2dp		Ad Size - Net Cost
AD_EXTRA_AMT	number	2dp		Ad Size - Extra amount
AD_BILL_NET	short num	0dp		Ad Size - Bill Net, not Gross
AD_ISSUE_DATE	char	30		Ad Size - Issue date
AD_SPACE_CLOSE	char	30		Ad Size - Space closing
AD_MAT_CLOSE	short num	0dp		Ad Size - Materials close (day)
PGM_KEY	char	50	x
PGM_CLIENT_NUM	char	10	x	Program - client number
AD_RATE_BASIS	char	4		Publication - Rate Basis

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