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 |