ar_receipt_applications

source

Which receipt cleared which invoice, and for how much.

Definition

Allocation rows tying AR receipts to customer invoices. Grain (ar_receipt_id, customer_invoice_id) UNIQUE on the source.

5 of 5

Column

Description

Tests · PII

ar_receipt_application_id

Primary key — BIGSERIAL on the source.

2 tests

ar_receipt_id

FK to `ar_receipts.ar_receipt_id`. NOT NULL.

1 test

customer_invoice_id

FK to `customer_invoices.customer_invoice_id`. NOT NULL.

1 test

applied_amount

Amount of the receipt applied to this invoice. NUMERIC(12,2).

created_at

Row insert timestamp in the source DB.