Table: Integration_Invoice_Prior_Payment | |||
Columns | |||
Name | Type | Constraints | Description |
integration_invoice_prior_payment_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table |
row_version | timestamp | NOT NULL | |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL | |
integration_invoice_KEY | int | NOT NULL | Key of the Integration Invoice record that this payment info applies to. |
payment_date | smalldatetime | NOT NULL | Date of the payment |
payment_amount | decimal (17, 2) | NOT NULL | Amount of the payment |
description | nvarchar (250) | NOT NULL | Description of the payment. |
Primary key | |||
Name | Columns | Description | |
PK_Integration_Invoice_Prior_Payment$integration_invoice_prior_payment_KEY | integration_invoice_prior_payment_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Integration_Invoice_Prior_Payment$integration_invoice_KEY | integration_invoice_KEY | Index supports foreign key FK_Integration_Invoice_Prior_Payment__Integration_Invoice__integration_invoice_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Integration_Invoice_Prior_Payment__Integration_Invoice__integration_invoice_KEY | integration_invoice_KEY | Integration_Invoice | on delete cascade; |