C&P Data Dictionary: AR

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

AR is the data file that stores data for client invoices. Each AR record contains a single invoice with total balance due from the client. Each AR record has fields for the client and invoce number(i.e., AR_CLIENT_NUM, AR_NUM), billing information including total amount that client has been charged, client has been paid, payment terms, etc. (i.e., AR_TOTAL, AR_AMT_PAID, AR_TERMS), and a record for the AR aging report (i.e. AR_PERIOD, Ar_30, AR_60, AR_90). See related data files:   AR_ITEMS    CLIENTS    PAYMENT_ITEMS    JE Field Name: Type: Length: Index: Description: AR_SEQ sequence x sequence # AR_NUM char 10 x invoice number AR_JOB_NUM char 10 x job number (-- for multi-job or non-job billings) AR_CLIENT_NUM char 10 x client number AR_DATE date x invoice date AR_POSTED date   x date posted to G/L AR_AE char 10 AE (from job; initials) AR_TERMS char 20   payment terms AR_PERIOD number 0dp accounting period AR_PO char 15 x client's PO number AR_DESC char 32000 invoice description AR_DUE_DATE date   x date payment expected to be made (for cash flow reports) AR_COUNT number 0dp number of payments made so far AR_DISC_DUE date     date to get a early-pay discount AR_DISC_AMT number 2dp early-pay discount amount AR_AMT_PAID number 2dp   amount paid by client AR_TOTAL number 2dp amount charged to client, including tax AR_DAYS number 0dp   days taken to pay invoice completely AR_TAX_AMT1 number 2dp sales tax amount billed 1 AR_TAX_AMT2 number 2dp   sales tax amount billed 2 AR_TAXABLE1 number 2dp taxable sales 1 AR_TAXABLE2 number 2dp   taxable sales 2 AR_TAX_RATE1 number 4dp sales tax rate 1 AR_TAX_RATE2 number 4dp   sales tax rate 2 AR_TAX_CGL1 number 2dp tax cGL 1 AR_TAX_CGL2 number 2dp   tax cGL 2 AR_AE_TITLE char 20 agency contact title AR_OPEN integer     open item (1) balance forward (0) AR_JUMP integer added with jump start? (for compatibility) AR_DGL number 2dp   invoice's debit G/L# AR_CURR number 2dp current balance due (< 30 days) AR_30 number 2dp   30-day balance due AR_60 number 2dp 60-day balance due AR_90 number 2dp   90-day balance due AR_120 number 2dp 120-day balance due (unused) AR_ADDED_BY char 4   who added this? AR_ADDED_WHEN date added when? AR_CLIENT_CONTACT char 40   client contact (copied form job) AR_AGENCY_CONTACT char 40 agency contact (copied from job) AR_SHOW_SPECS integer     show job specs? flag AR_RETAINR_NOTE char 80 retainer description AR_RETAINER_AMT number 2dp   retainer amount applied to invoice AR_RETAINER_GL number 2dp retainer cGL AR_BILLING_TYPE number 0dp   invoice style (determines which invoice to use) AR_COMM_AMT number 2dp commission amount AR_COMM_GL number 2dp   commission cGL AR_COMM_DESC char 32000 commission description AR_MISC_AMT1 number 2dp   misc amount AR_MISC_GL1 number 2dp misc cGL AR_MISC_DESC1 char 32000   misc description 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.