The tables behind Accounts Receivable System

The AR-grain customer record. May shadow a CRM Account; this row carries the credit, billing, and dunning fields finance owns.

Catalog of payment terms. Net 15, Net 30, Net 60, Net 90, EOM, Prepay, Due on Receipt, plus optional late-fee rule.

Branded invoice render formats. Picks the logo, tax footnote language, and remit-to. One template per legal entity / division.

Subscription / retainer billing config. The recurring-invoice generation workflow walks these daily and materializes Invoices. Each occurrence is uniquely keyed by schedule and scheduled date; honor end date and credit holds, and preserve previous generated invoices when changing future terms.

Customer-level credit hold. While Active, no new Invoices may be sent and no recurring invoice schedules generate for the Customer.

The customer invoice — the AR atom. Header carries totals; detail lives in invoice lines.

One line per item billed — product, service, milestone, or late-fee carry-forward.

A credit issued against a Customer or a specific Invoice. Reduces AR; can be applied to an open Invoice or left as a standalone credit on account.

Per-line detail of a credit memo.

The AR-grain customer record. May shadow a CRM Account; this row carries the credit, billing, and dunning fields finance owns.

A customer-raised dispute against an Invoice. Pauses dunning while open.

Read-stream from the bank API. Source for cash auto-application. Not an authoritative ledger record — consumed by payment-application-auto-match.

An incoming payment from a Customer. May be auto-created by the auto-match workflow from a bank feed transaction or manually keyed by an AR Clerk.

Distributes a payment received across one or more Invoices (or leaves the remainder unapplied on the customer’s account).

The customer invoice — the AR atom. Header carries totals; detail lives in invoice lines.

A credit issued against a Customer or a specific Invoice. Reduces AR; can be applied to an open Invoice or left as a standalone credit on account.

Uncollectible AR written off the books. Requires Controller approval; posts a JE in fin-accounting that contras the AR balance and hits Bad Debt Expense.

Per-Customer or default dunning policy. Defines aging-band thresholds, the email template per band, and the escalation contact.

The audit trail of every dunning communication sent. One row per Invoice per band per send.

Escalated collections workflow. Opened when an Invoice crosses dunning policy band4 days or by AR Manager intervention.

A customer-raised dispute against an Invoice. Pauses dunning while open.

The customer invoice — the AR atom. Header carries totals; detail lives in invoice lines.

The AR-grain customer record. May shadow a CRM Account; this row carries the credit, billing, and dunning fields finance owns.

Customer-level credit hold. While Active, no new Invoices may be sent and no recurring invoice schedules generate for the Customer.

Late fees applied per billing term late fee policy. Each late fee spawns a follow-on Invoice of Type: LateFee linked back via OriginalInvoice.

Uncollectible AR written off the books. Requires Controller approval; posts a JE in fin-accounting that contras the AR balance and hits Bad Debt Expense.

The customer invoice — the AR atom. Header carries totals; detail lives in invoice lines.

The AR-grain customer record. May shadow a CRM Account; this row carries the credit, billing, and dunning fields finance owns.

Catalog of payment terms. Net 15, Net 30, Net 60, Net 90, EOM, Prepay, Due on Receipt, plus optional late-fee rule.

Period-frozen aging buckets per Customer. Written by the ar-aging-snapshot scheduled workflow on the last day of each period.

The customer invoice — the AR atom. Header carries totals; detail lives in invoice lines.

An incoming payment from a Customer. May be auto-created by the auto-match workflow from a bank feed transaction or manually keyed by an AR Clerk.

Distributes a payment received across one or more Invoices (or leaves the remainder unapplied on the customer’s account).

Escalated collections workflow. Opened when an Invoice crosses dunning policy band4 days or by AR Manager intervention.

The audit trail of every dunning communication sent. One row per Invoice per band per send.

Uncollectible AR written off the books. Requires Controller approval; posts a JE in fin-accounting that contras the AR balance and hits Bad Debt Expense.

The AR-grain customer record. May shadow a CRM Account; this row carries the credit, billing, and dunning fields finance owns.

A scoped employee identity directory synchronized from the organization identity or HR source. This reference supports ownership and approval attribution; it does not add payroll or HR administration. Role membership alone never grants access to every directory field. External auditors and portal users receive only the identities needed for their granted work.