Table: Ledger_Entry_Service_Charge | |||
Columns | |||
Name | Type | Constraints | Description |
ledger_entry_service_charge_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 | |
service_charge__ledger_entry_KEY | int | NOT NULL | Key to the Ledger Entry that is the Service Charge. |
past_due__ledger_entry_KEY | int | NOT NULL | Key to a Ledger Entry that was past due and was charged a fee. |
amount | decimal (17, 2) | NOT NULL | Amount charged because past_due__ledger_entry_KEY has not been paid. |
create_date_utc | datetime | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Ledger_Entry_Service_Charge$ledger_entry_service_charge_KEY | ledger_entry_service_charge_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Ledger_Entry_Service_Charge$service_charge__ledger_entry_KEY$past_due__ledger_entry_KEY | service_charge__ledger_entry_KEY, past_due__ledger_entry_KEY | You can't have more than one charge per past due item on each service charge. | |
Indexes | |||
Name | Columns | Description | |
IX_Ledger_Entry_Service_Charge$past_due__ledger_entry_KEY | past_due__ledger_entry_KEY | Index supports foreign key FK_Ledger_Entry_Service_Charge__Ledger_Entry__past_due__ledger_entry_KEY |