C&P Data Dictionary: BILLING INFO

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

BILLING_INFO is the data file that stores the billing information for each cost center. Each BILLING_INFO record contains billing information for a single job. Each BILLING_INFO record has fields for cost conter (i.e., B_COST_CTR1 through B_COST_CTR9), the account number for the cost center (B_ACCT1 through B_acct9), and billing percentage for the cost center (i.e., B_PERCENT1 through B_PERCENT9) for each different cost center. See related data files:   PC    COSTS Field Name: Type: Length: Index: Description: B_SEQ sequence x sequence # B_JOB_NUM char 10 x job number B_COST_CTR1 char 15 cost center 1 B_COST_CTR2 char 15   cost center 2 B_COST_CTR3 char 15 cost center 3 B_COST_CTR4 char 15   cost center 4 B_COST_CTR5 char 15 cost center 5 B_COST_CTR6 char 15   cost center 6 B_COST_CTR7 char 15 cost center 7 B_COST_CTR8 char 15   cost center 8 B_COST_CTR9 char 15 cost center 9 B_ACCT1 char 10   account number 1 B_ACCT2 char 10 account number 2 B_ACCT3 char 10   account number 3 B_ACCT4 char 10 account number 4 B_ACCT5 char 10   account number 5 B_ACCT6 char 10 account number 6 B_ACCT7 char 10   account number 7 B_ACCT8 char 10 account number 8 B_ACCT9 char 10   account number 9 B_PERCENT1 number 2dp % for cost center/account number 1 B_PERCENT2 number 2dp   % for cost center/account number 2 B_PERCENT3 number 2dp % for cost center/account number 3 B_PERCENT4 number 2dp   % for cost center/account number 4 B_PERCENT5 number 2dp % for cost center/account number 5 B_PERCENT6 number 2dp   % for cost center/account number 6 B_PERCENT7 number 2dp % for cost center/account number 7 B_PERCENT8 number 2dp   % for cost center/account number 8 B_PERCENT9 number 2dp % for cost center/account number 9 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.