Table: Integration_Invoice_Prior_Payment
Columns
NameTypeConstraintsDescription
integration_invoice_prior_payment_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
row_versiontimestampNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
integration_invoice_KEYintNOT NULLKey of the Integration Invoice record that this payment info applies to.
payment_datesmalldatetimeNOT NULLDate of the payment
payment_amountdecimal (17, 2)NOT NULLAmount of the payment
descriptionnvarchar (250)NOT NULLDescription of the payment.
Primary key
NameColumnsDescription
PK_Integration_Invoice_Prior_Payment$integration_invoice_prior_payment_KEYintegration_invoice_prior_payment_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Integration_Invoice_Prior_Payment$integration_invoice_KEYintegration_invoice_KEYIndex supports foreign key FK_Integration_Invoice_Prior_Payment__Integration_Invoice__integration_invoice_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Integration_Invoice_Prior_Payment__Integration_Invoice__integration_invoice_KEYintegration_invoice_KEYIntegration_Invoiceon delete cascade;

Schema diagram