Clients & Profits Worldwide :: Data Dictionary

Free help: USER GUIDE } BLOG } SYSTEM MANAGER NEWS

Home > Support > Data Dictionary > VENDORS

C&P Data Dictionary: VENDORS

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:
V_SEQ	sequence		x
V_NUM	char	10	x
V_ORG	char	50	x
V_NOTE1	char	50
V_STREET	char	50
V_CITY	char	50
V_NOTE2	char	50
V_ZIP	char	50
V_CONTACT	char	50
V_PHONE	char	20
V_YTD	number	2dp
V_MARKUP	number	2dp
V_NOTE3	char	55
V_TASK	char	4
V_TYPE	char	20
V_OPEN	boolean
V_ALLOCATE	boolean
V_TAX_ID	char	15
V_ACCT_NUM	char	10
V_CURRN	number	2dp
V_30DAY	number	2dp
V_60DAY	number	2dp
V_90DAY	number	2dp
V_BALN	number	2dp
V_LAST_AP	short date	1980..2079
V_ADDED_BY	char	3
V_ADDED_WHEN	short date	1980..2079
V_TIME	date
V_1	number	2dp
V_2	number	2dp
V_3	number	2dp
V_4	number	2dp
V_5	number	2dp
V_6	number	2dp
V_7	number	2dp
V_8	number	2dp
V_9	number	2dp
V_10	number	2dp
V_11	number	2dp
V_12	number	2dp
V_L1	number	2dp
V_L2	number	2dp
V_L3	number	2dp
V_L4	number	2dp
V_L5	number	2dp
V_L6	number	2dp
V_L7	number	2dp
V_L8	number	2dp
V_L9	number	2dp
V_L10	number	2dp
V_L11	number	2dp
V_L12	number	2dp
V_TERMS1	number	0dp
V_TERMS2	number	0dp
V_TERMS3	number	0dp
V_CGL	number	2dp
V_DGL	number	2dp
V_CK_MEMO	char	80		default memo for checks
V_NOTES	char	2000
V_FAX	char	20		fax phone
V_DISC_DGL	number	2dp		discount dGL
V_NAME1	char	40		vendor rep
V_PHONE1	char	20
V_FAX1	char	20
V_PAGER1	char	20
V_CAR_PHONE1	char	20
V_NAME2	char	40
V_PHONE2	char	20
V_FAX2	char	20
V_CAR_PHONE2	char	20
V_PAGER2	char	20
V_NAME3	char	40
V_PHONE3	char	20
V_FAX3	char	20
V_PAGER3	char	20
V_CAR_PHONE3	char	20
V_HOME_PHONE1	char	20
V_HOME_PHONE2	char	20
V_HOME_PHONE3	char	20
V_ACTIVE	number	0dp	x	active vendor? yes or no
V_1099	number	0dp
V_MEDIA_VNUM	char	10	x
V_ADDRESS2_1	char	50
V_ADDRESS2_2	char	50
V_ADDRESS2_3	char	50
V_ADDRESS2_4	char	50
V_ADDRESS3_1	char	50
V_ADDRESS3_2	char	50
V_ADDRESS3_3	char	50
V_ADDRESS3_4	char	50
V_COMM	short num	2dp		media commission
V_HOLD	short int	(0 to 255)		vendor on-hold?
V_HOLD_WHY	char	2000		why is the vendor on hold?
V_MEDIA_KIND	short int	(0 to 255)
V_WEB_URL	char	50
V_EMAIL	char	50
V_CORP_ID	char	100		corporate vendor ID number
V_MARKET	char	40		media market (for media vendors)

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