Table: Billing_Decision_Taxing_Authority | |||
Columns | |||
Name | Type | Constraints | Description |
billing_decision_taxing_authority_KEY | int | NOT NULL | AUTO-INCREMENT: DEPRECATED. Database assigned primary key for this table. |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL | |
billing_decision_KEY | int | NOT NULL | DEPRECATED. Identifies the Billing_Decision row this tax is charged for. |
sheet_entry_KEY | int | NOT NULL | The combination of ledger_entry_KEY and sheet_entry_KEY identifies the Billing_Decision row this tax is charged for. |
ledger_entry_KEY | int | NOT NULL | The combination of ledger_entry_KEY and sheet_entry_KEY identifies the Billing_Decision row this tax is charged for. |
taxing_authority_KEY | int | NOT NULL | Key to the Taxing Authority that this tax is charged for. |
amount | decimal (9, 2) | NOT NULL | The amount of tax charged. |
calculated_amount | decimal (9, 2) | NOT NULL | Calculated amount of tax charged. |
amount_is_overridden | bit | NOT NULL | True when the calculated_amount is overridden and is necessary so that the override is not deleted if the values happen to match later. |
Primary key | |||
Name | Columns | Description | |
PK_Billing_Decision_Taxing_Authority$sheet_entry_KEY$ledger_entry_KEY$taxing_authority_KEY | sheet_entry_KEY, ledger_entry_KEY, taxing_authority_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Billing_Decision_Taxing_Authority$billing_decision_taxing_authority_KEY | billing_decision_taxing_authority_KEY | ||
Indexes | |||
Name | Columns | Description | |
IX_Billing_Decision_Taxing_Authority$billing_decision_KEY$amount | billing_decision_KEY, amount | ||
IX_Billing_Decision_Taxing_Authority$ledger_entry_KEY$amount | ledger_entry_KEY, amount | ||
IX_Billing_Decision_Taxing_Authority$taxing_authority_KEY$amount | taxing_authority_KEY, amount |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Billing_Decision_Tax_Collection__Billing_Decision_Taxing_Authority__sheet_entry_KEY__ledger_entry_KEY__taxing_authority_KEY | sheet_entry_KEY, ledger_entry_KEY, taxing_authority_KEY | Billing_Decision_Tax_Collection | on delete cascade; |