AR Customers (BPCUSTOMERS)

This folder is a list of customers. It includes customer codes, names, addresses, contact information, collector codes, class codes, terms codes, bank account numbers, tax codes, department codes, and various flags.

AR Invoices (INVOICE)

This folder is a list of AR invoices. It includes customer codes, invoice numbers, amounts, post dates, batch numbers, job codes, term codes, charge codes, descriptions, tax codes, days to pay, etc.

AR Cash Receipts (PAYMENT)

This folder is a list of AR cash receipts. It includes invoice numbers, batch numbers, check numbers, check dates, account codes, amounts, reversal codes, etc.

AR Credit/Debit Notes (INVMEMO)

This folder is a list of AR credit and debit notes/memos. It includes invoice numbers, batch numbers, apply numbers, amounts, tax amounts, and memo dates.

AR Distributions (ARGLDIST)

This folder shows information about the distribution of AR invoices. It includes invoice numbers, journal codes, department codes, account codes, amounts, dates, source codes, job codes, etc.

AR Customer Classes (CUSTCLAS)

This folder lists the AR customer classes. It includes class codes, class names, and control codes.

AR Collectors (COLLECT)

This folder lists the entities for collecting overdue receivables. It includes collector codes, names, and descriptions.

AR Interest Invoices (INVFIN)

This folder lists AR interest invoices. It includes apply numbers, customer codes, batch numbers, charge codes, statement dates, and amounts.

AR Batches (ARBATCH_TABLE)

This folder lists AR batches. It includes batch numbers, names, users, post dates, type codes, etc.

AR Invoice Adjustment Headers (INVADJ)

This folder lists AR invoice adjustments. It includes invoice numbers, apply numbers, batch numbers, dates, and descriptions.

AR Invoice Details (ARINVDET)

This folder lists details from AR invoices. It includes invoice numbers, line numbers, item codes, quantities, amounts, tax codes, tax amounts, etc.

AR Invoice Distributions (INVDIST)

This folder details AR invoice distributions. It includes source codes, invoice numbers, type codes, dates, amounts, account codes, job cost and category codes, equipment codes, etc.

AR Invoice Payments (INVPAY)

This folder details AR invoice payments. It includes invoice numbers, source codes, pay amounts, holdback amounts, post dates, revision dates, tax amounts, etc.

AR Invoice Series Codes (ARINVSERC)

This folder lists all AR invoice series codes. It includes series codes, series descriptions, invoice number masks, department codes, account codes, etc.

AR Tax Codes (ARTAX)

This folder lists all the tax codes used in accounts receivable. It includes department codes, account codes, AP department codes, tax percents, and various flags.

AR Aged Receivables (AR_INVOICE_OUTSTANDING)

This folder lists the aged receivables. It includes invoice numbers, customer codes, and outstanding amounts by different aging periods including 31 to 60 days, 61 to 90 days, 91-120 days, etc.

ARBI Company Summary (AR_OUTSTANDING_BY_COMPANY)

This folder summarizes, by company, the days sales outstanding, the days delinquent sales outstanding, and the outstanding AR invoice amounts.

ARBI Customer Summary (AR_OUTSTANDING_BY_CUSTOMER)

This folder summarizes, by customer, the days sales outstanding, the days delinquent sales outstanding, and the outstanding AR invoice amounts.

ARBI Days to Pay (AR_INVOICE_DAYS_TO_COLLECT)

This folder shows the days to pay by invoice. It includes customer codes, invoice codes, invoice dates, final paid dates, and the days to pay.

ARBI Outstanding by Period (AR_CUSTOMER_BY_PERIOD)

This folder shows the outstanding AR invoice amounts by period. It includes invoice codes, customer codes, fiscal years, fiscal periods, invoice amounts, paid amounts, and outstanding amounts.