Table: dbo.Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item
This dictionary table associates payable transaction worker compensation items with the liabilities created from them.
Columns
Name | Type | Constraints | Description
payable_transaction_n_payroll_bank_transaction_worker_compensation_item_KEY | int (4) | NOT NULL | Surrogate primary key for the table.
payable_transaction_KEY | int (4) | NOT NULL | Foreign key to Payable_Transaction table.
payroll_bank_transaction_worker_compensation_item_KEY | int (4) | NOT NULL | Foreign key to Payroll_Bank_Transaction_Worker_Compensation_Item table.

Primary key
Name | Columns | Description
PK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item | payable_transaction_n_payroll_bank_transaction_worker_compensation_item_KEY |
Unique constraints
Name | Columns | Description
UK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item$payroll_bank_transaction_worker_compensation_item_KEY | payroll_bank_transaction_worker_compensation_item_KEY, payable_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item__Payroll_Bank_Transaction_Worker_Compensation_Item__p | payroll_bank_transaction_worker_compensation_item_KEY | Payroll_Bank_Transaction_Worker_Compensation_Item (payroll_bank_transaction_worker_compensation_item_KEY) |
FK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction (payable_transaction_KEY) |