Table: Online_Invoice
Information about Invoices that have been sent to the online bill pay service.
Columns
Name | Type | Constraints | Description
ledger_entry_KEY | int | NOT NULL | Primary key for this row and the key of the associated Invoice.
online_invoice_guid | uniqueidentifier | NOT NULL | A unique value that is used to identify this invoice on the portal and in online payments.
update__staff_KEY | int | NOT NULL |
update_date_utc | datetime | NOT NULL |
create_date_utc | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Online_Invoice$ledger_entry_KEY | ledger_entry_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Online_Invoice$online_invoice_guid | online_invoice_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Online_Invoice__Invoice__ledger_entry_KEY | ledger_entry_KEY | Invoice | on delete cascade;