ap_payment_applications

source

Which payment cleared which bill, and for how much.

Definition

Allocation rows tying AP payments to vendor bills. Grain (ap_payment_id, vendor_bill_id) UNIQUE on the source — sums to the vendor's settled balance.

5 of 5

Column

Description

Tests · PII

ap_payment_application_id

Primary key — BIGSERIAL on the source.

2 tests

ap_payment_id

FK to `ap_payments.ap_payment_id`. NOT NULL.

1 test

vendor_bill_id

FK to `vendor_bills.vendor_bill_id`. NOT NULL.

applied_amount

Amount of the payment applied to this bill. NUMERIC(12,2).

created_at

Row insert timestamp in the source DB.