C&P Data Dictionary: AR_ITEMS

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_ITEMS is the data file that stores the AR line items. Each AR _ITEMS record contains a single line item. Each AR_ITEMS record has fields for task descriptions (i.e., AX_DESC), billing ammounts (i.e., AX_CGL), and job information (i.e., AX_JOB_NUM & AX_TASK) for each different line item. These fields update jobs when entries are saved. See related data files:   AR    JOBS Field Name: Type: Length: Index: Description: AX_SEQ sequence x sequence # AX_JOB_NUM char 10 x job number AX_TASK char 4 x job task AX_AR_NUM char 10 x invoice number AX_AMT number 2dp billing amount AX_SORT number 0dp   sort (copied from job task) AX_GROUP number 0dp group (copied from job task) AX_TAXABLE1 boolean     taxable 1 flag (yes/no) AX_TAXABLE2 boolean taxable 2 flag (yes/no) AX_DESC char 32000   line item description AX_DATE date x invoice date AX_CGL number 2dp   billing amount credit G/L# (income) AX_POSTED date x date posted into G/L AX_PERIOD number 0dp   accounting period AX_NAME char 50 task name/billing description AX_HOURS_BILLED number 2dp   hours billed this invoice AX_HIDE number 0dp hide option AX_ROLL_UP char 4   hide item, but roll up billing amount into a task AX_SHOW_DESC integer show line item notes AX_QTY number 0dp   quantity (or number of spots) AX_POX_KEY char 15 for media/pre-billing: POX_PO_NUM+POX_LINE_NUMBER AX_PUB char 20   for media billing: publication/station AX_ISSUE_DATE char 15 media issue date AX_COST number 2dp   for media billing - net cost for WIP JE AX_EXPORTED short date 1980..2079   date exported (SQL only) 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.