stg_postgres__ap_payment_applications

staging view

AP payment applications, cleaned.

Definition

Allocation rows tying AP payments to the vendor bills they settle.

6 of 6

Column

Description

Tests · PII

ap_payment_application_id

Primary key — UInt64.

2 tests

ap_payment_id

FK to `stg_postgres__ap_payments.ap_payment_id`. NOT NULL.

2 tests

vendor_bill_id

FK to `stg_postgres__vendor_bills.vendor_bill_id`. NOT NULL.

applied_amount

Amount applied to this bill. Decimal(12,2).

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When the loader extracted this row from postgres-source.