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. |
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. |