This table stores the same thing that [Billing_Decision_Collection] does, but for [Billing_Decision_Taxing_Authority] instead of [Billing_Decision]. |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | 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. |
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 |
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 | |