Table: dbo.Direct_Deposit_Bank_Transaction_Allocation_Distribution
This table stores off location/department portions of the values in the Direct_Deposit_Bank_Transaction_Allocation table. These values are distributed based on the payroll item portion per location/department of the net check amount.
Columns
Name | Type | Constraints | Description
direct_deposit_bank_transaction_allocation_distribution_KEY | int (4) | NOT NULL | Primary key.
direct_deposit_bank_transaction_allocation_KEY | int (4) | NOT NULL | Foreign key to associated direct deposit bank transaction allocation. The direct deposit bank transaction allocation distributions must sum the the associated allocation and are broken down for location / department.
work_location_KEY | int (4) | NOT NULL | Foreign key to associated work location. These direct deposit bank transaction allocation distriubtions are all assigned to a location / department.
payroll_department_KEY | int (4) |  | Foreign key to associated payroll department. Can be null. These direct deposit bank transaction allocation distriubtions are all assigned to a location / department.
amount | decimal (9, 2) | NOT NULL | The distribution amount. This amount is the location/department portion of the value in the Direct_Deposit_Bank_Transaction_Allocation table. These values are distributed based on the payroll item portion per location/department of the net check amount.

Primary key
Name | Columns | Description
PK_Direct_Deposit_Bank_Transaction_Allocation_Distribution | direct_deposit_bank_transaction_allocation_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Direct_Deposit_Bank_Transaction_Allocation__direct_deposit_bank_tran | direct_deposit_bank_transaction_allocation_KEY | Direct_Deposit_Bank_Transaction_Allocation (direct_deposit_bank_transaction_allocation_KEY) |
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Department (payroll_department_KEY) |
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Work_Location__work_location_KEY | work_location_KEY | Work_Location (work_location_KEY) |