C&P Data Dictionary: VENDORS

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

VENDORS See related data files:   JE   SUB_CLASSES 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 12     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 date V_ADDED_BY char 3     V_ADDED_WHEN date 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 32000 V_FAX char 12   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 number 2dp media commission V_HOLD integer     vendor on-hold? V_HOLD_WHY char 32000 why is the vendor on hold? V_MEDIA_KIND integer        V_WEB_URL char 50 V_EMAIL char 50     V_CORP_ID char 100 corporate vendor ID number 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.