Table: Billing_Decision_Tax_Collection
This table stores the same thing that [Billing_Decision_Collection] does, but for [Billing_Decision_Taxing_Authority] instead of [Billing_Decision].
Columns
Name | Type | Constraints | Description
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
collection_source__ledger_entry_KEY | int | NOT NULL | Identifies the receipt in the Ledger_Entry table that paid for this collection.
ledger_entry_KEY | int | NOT NULL | The combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for.
from__ledger_entry_KEY | int | NOT NULL | Indicates which [Invoice] row was the source of the application in scenarios such as progress billing. Standard entries that users can create have [from__ledger_entry_KEY] set to the same value as [ledger_entry_KEY].
sheet_entry_KEY | int | NOT NULL | The combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for.
taxing_authority_KEY | int | NOT NULL | The combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for.
amount_collected | decimal (9, 2) | NOT NULL | The amount collected for the tax.

Primary key
Name | Columns | Description
PK_Billing_Decision_Tax_Collection$collection_source__ledger_entry_KEY$ledger_entry_KEY$from__ledger_entry_KEY$sheet_entry_KEY$t | collection_source__ledger_entry_KEY, ledger_entry_KEY, from__ledger_entry_KEY, sheet_entry_KEY, taxing_authority_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Billing_Decision_Tax_Collection$from__ledger_entry_KEY | from__ledger_entry_KEY | Index supports foreign key FK_Billing_Decision_Tax_Collection__Invoice__from__ledger_entry_KEY
IX_Billing_Decision_Tax_Collection$ledger_entry_KEY$collection_source__ledger_entry_KEY$from__ledger_entry_KEY$sheet_entry_KEY@a | ledger_entry_KEY, collection_source__ledger_entry_KEY, from__ledger_entry_KEY, sheet_entry_KEY, amount_collected, taxing_authority_KEY |
IX_Billing_Decision_Tax_Collection$sheet_entry_KEY$ledger_entry_KEY$collection_source__ledger_entry_KEY$from__ledger_entry_KEY@a | sheet_entry_KEY, ledger_entry_KEY, collection_source__ledger_entry_KEY, from__ledger_entry_KEY, amount_collected, taxing_authority_KEY |
IX_Billing_Decision_Tax_Collection$sheet_entry_KEY$ledger_entry_KEY$taxing_authority_KEY | sheet_entry_KEY, ledger_entry_KEY, taxing_authority_KEY | Index supports foreign key FK_Billing_Decision_Tax_Collection__Billing_Decision_Taxing_Authority__sheet_entry_KEY__ledger_entry_KEY__taxing_authority_KEY
IX_Billing_Decision_Tax_Collection$taxing_authority_KEY | taxing_authority_KEY |

Foreign keys
Name | Columns | Referenced 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_Taxing_Authority | on delete cascade;
FK_Billing_Decision_Tax_Collection__Invoice__from__ledger_entry_KEY | from__ledger_entry_KEY | Invoice | on delete cascade;
FK_Billing_Decision_Tax_Collection__Ledger_Entry__collection_source__ledger_entry_KEY | collection_source__ledger_entry_KEY | Ledger_Entry | on delete cascade;