AP Vendors (BPVENDORS)

This folder is a master list of vendors and includes their names, locations, contact information, vendor codes, buyer codes, tax codes, bank account numbers, etc.

AP Invoices (VOUCHER)

This folder is a list of all the AP invoices (vouchers). It includes batch numbers, voucher numbers, post dates, invoice/paid/retainage/outstanding amounts, tax codes, tax amounts, etc.

AP Registered Invoices (APREGINV)

This folder is a list of all the AP registered invoices (vouchers). It includes the vendor codes, due dates, amounts, descriptions, status codes, tax codes, etc.

AP Checks (CHEQUE)

This folder is a list of all the AP checks (payments made to vendors). It includes check numbers, batch numbers, check dates, account codes, check amounts, reversal information, etc.

AP Check Payee (CHQPAYEE)

This folder is a list of all the AP check payees. It includes their names and addresses.

AP Debit Credit Notes (VOUMEMO)

This folder lists all the AP debit and credit memos. It includes the voucher numbers, vendor codes, amounts, etc.

AP Voucher Adjustments (VOUADJ)

This folder lists all the AP voucher adjustments (changes other than the dollar amount, which would be a debit/credit memo). It includes voucher numbers, batch numbers, descriptions, and post dates.

AP Batch GL Distributions (APGLDIST)

This folder lists the AP Batch GL distributions. It includes the batch numbers, account and department codes, amounts, post dates, source codes, job codes, etc.

AP Invoice Series Codes (APINVSERC)

This folder lists the AP invoice series codes. It includes series codes and descriptions, department codes, account codes, etc.

AP Vendor Classes (VENCLASS)

This folder details the AP vendor classes. It includes class codes, descriptions, and class control codes.

AP Vendor Compliances (INSMASTER)

This folder shows compliance information by vendor. It includes vendor codes, cover types, insurance company codes, certification numbers, amounts, and various flags.

AP Insurance Bonding Companies (INSCOMP)

This folder shows information about the insurance companies for the AP vendors. It includes company codes, names, and ratings.

AP Batches (VOUBCH_TABLE)

This folder shows information about batches created in AP. It includes batch numbers, names, post dates, and various flags.

AP Voucher Distributions (VOUDIST)

This folder shows information about the distribution of AP invoices (vouchers). It includes voucher numbers, line numbers, account codes, amounts, purchase order numbers, job cost and category codes, equipment codes, etc.

AP Voucher Payments (VOUCHQ)

This folder shows information about checks issued against AP invoices (vouchers). It includes voucher numbers, check amounts, holdback amounts, post dates, tax amounts, etc.

AP BP Classification (BPCLASSIFICATION_VIEW)

This folder shows the business partner classifications as they apply to AP vendors. It includes the vendor codes, classification codes, and classification names.

APBI Aged Payables (AP_INVOICE_OUTSTANDING)

This folder shows the AP aged payables by different aging periods as columns. It includes post dates, aging periods such as 31-60 days, 61-90 days, 91-120 days, as well as various overdue periods.

APBI Days to Pay (AP_INVOICE_DAYS_TO_PAY)

This folder shows the amount of days it took to pay past AP invoices (vouchers). It includes invoice numbers, invoice dates, paid dates, and days to pay. The folder shows data for the last 24 months only.

APBI Days to Process (AP_INVOICE_DAYS_TO_PROCESS)

This folder shows the number of days it took to process past AP invoices (vouchers). It includes invoice numbers, entered dates, post dates, and days to process. The folder shows data for the last 24 months only.

APBI Outstanding by Period (AP_VENDOR_BY_PERIOD)

This folder shows the outstanding payables by vendor and by period. It includes voucher numbers, vendor codes, year, period, invoice amounts, paid amounts, and outstanding amounts. The folder shows data for the last 24 months only.

APBI Vendor Comdata (AP_VENDOR_COMDATA)

This folder shows COMDATA information for each vendor. It includes vendor codes, names, address, payment methods, terms, account numbers, transactions over the last 12 months, and spend volume over the last 12 months.