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 | datetime | NOT NULL |
create_date | 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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Billing_Decision_Taxing_Authority__Billing_Decision__billing_decision_KEY | billing_decision_KEY | Billing_Decision |
FK_Billing_Decision_Taxing_Authority__Billing_Decision__sheet_entry_KEY__ledger_entry_KEY | sheet_entry_KEY, ledger_entry_KEY | Billing_Decision |
FK_Billing_Decision_Taxing_Authority__Taxing_Authority__taxing_authority_KEY | taxing_authority_KEY | Taxing_Authority |

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;