Table: dbo.Tax_Agent_Direct_Deposit_Allocation
Table for tax agent direct deposit allocations
Columns
Name | Type | Constraints | Description
tax_agent_direct_deposit_allocation_KEY | int (4) | NOT NULL | Primary key for the Tax_Agent_Direct_Deposit_Allocation table.
processing_order | int (4) | NOT NULL | Order in which allocations are processed
tax_agent_KEY | int (4) | NOT NULL | Tax agent allocations are for
bank_KEY | int (4) | NOT NULL | Tax agent bank
bank_account_number | nvarchar (34) | NOT NULL | Tax agent bank account number
bank_account_type_KEY | nvarchar (22) | NOT NULL | Tax agent bank account type
allocation_amount | decimal (9, 2) |  | Allocation amount
allocation_percent | decimal (5, 2) |  | Allocation percent
direct_deposit_status_KEY | nvarchar (40) | NOT NULL | Status of tax agent account
prenote_date | smalldatetime (4) |  | Date tax agent account was prenoted
prenote_created | bit (1) | NOT NULL | Flag indicating that a prenote file have been created for this entry
use_international_format | bit (1) | NOT NULL | This allocation requires international ACH formatting.
us_gateway_operator__bank_KEY | int (4) |  | Key to bank acting as US gateway operator.
destination__country_code_KEY | int (4) |  | Key to destination country code.
prenote_effective_date | smalldatetime (4) |  | The effective date used when prenoting this allocation.
notes | nvarchar (480) | NOT NULL | Direct deposit processing notes when this allocation is prenoted.

Primary key
Name | Columns | Description
PK_Tax_Agent_Direct_Deposit_Allocation | tax_agent_direct_deposit_allocation_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Agent_Direct_Deposit_Allocation__Bank__bank_KEY | bank_KEY | Bank (bank_KEY) |
FK_Tax_Agent_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEY | us_gateway_operator__bank_KEY | Bank (bank_KEY) |
FK_Tax_Agent_Direct_Deposit_Allocation__Bank_Account_Type__bank_account_type_KEY | bank_account_type_KEY | Bank_Account_Type (bank_account_type_KEY) |
FK_Tax_Agent_Direct_Deposit_Allocation__Country_Code__destination__country_code_KEY | destination__country_code_KEY | Country_Code (country_code_KEY) |
FK_Tax_Agent_Direct_Deposit_Allocation__Direct_Deposit_Status__direct_deposit_status_KEY | direct_deposit_status_KEY | Direct_Deposit_Status (direct_deposit_status_KEY) |
FK_Tax_Agent_Direct_Deposit_Allocation__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent (tax_agent_KEY) |