C&P Data Dictionary: AP

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

AP is the data file that stores data for vendor invoices. Each AP record contains a single invoice with total balance due to the vendor. Each AP record has fields for the vendor and invoce number(i.e., AP_VENDOR_NUM, AP_NUM), data that is combined for the total costs (i.e., AP_NET_AMT, AP_GROSS_AMT) and a field for the AP aging report (i.e. AP_PERIOD, AP_30, AP_60, AP_90). See related data files:   RECUR_AP   COSTS  CHECK_ITEMS   VENDORS   JE Field Name: Type: Length: Index: Description: AP_SEQ sequence x sequence # AP_NUM char 20 x invoice number AP_VENDOR_NUM char 10 x vendor number AP_DATE date   x invoice date AP_KEY char 30 x dupe key (vendor+invoice number) AP_DESC char 32000   invoice description AP_CGL number 2dp credit G/L# AP_NET_AMT number 2dp   net cost amount (the amount you'll pay) AP_COMM_NET number 2dp commissionable net amount AP_MARKUP_PC number 2dp   markup % AP_TAX_AMT number 2dp sales tax amount AP_GROSS_AMT number 2dp   gross amount (including markup) AP_POSTED date x date posted AP_TOTAL_AMT number 2dp   invoice total (the amount you'll pay) AP_DISC_DATE date due date to get discount AP_JUMPSTART integer     added from Jump Start (for compatibility) AP_ADDED_BY char 4 who added this entry? AP_ADDED_WHEN date     date entry was added AP_VOUCHER char 10 voucher number - for media interface AP_TERMS1 number 0dp   payment terms - % discount AP_TERMS2 number 0dp payment terms - days for discount AP_TERMS3 number 0dp   payment terms - net days AP_PAY_DATE date x date to pay (for cash flow report) AP_PERIOD number 0dp   accounting period AP_CURRENT number 2dp current balance due (< 30 days) AP_30 number 2dp   30-day balance due AP_60 number 2dp 60-day balance due AP_90 number 2dp   90-day balance due AP_AUTO_PAY char 10 x internal key for auto checkwriting AP_GST_GL number 2dp   GST/VAT tax G/L# AP_GST1 number 2dp GST/VAT tax amount 1 AP_GST2 number 2dp   GST/VAT tax amount 2 AP_AMT_PAID number 2dp amount paid from Checkbook AP_CLIENT_PAID date     date client paid this invoice AP_CLOSE_PO integer close this PO? flag AP_UNPAID number 0dp x yes=unpaid/no=paid AP_KIND integer 0=Job Cost/1=Overhead/2=Accrual/ AP_DISC_TAKEN number 2dp   early pmt discounts taken (checkbook) AP_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.