Table: dbo.Payable_Transaction_N_Payroll_Check_Payroll_Item | |||
This dictionary table associates payroll check payroll items with the liabilities created from them. | |||
Columns | |||
Name | Type | Constraints | Description |
payable_transaction_n_payroll_check_payroll_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_check_payroll_item_KEY | int (4) | NOT NULL | Foreign key to Payroll_Check_Payroll_Item table. |
Primary key | |||
Name | Columns | Description | |
PK_Payable_Transaction_N_Payroll_Check_Payroll_Item | payable_transaction_n_payroll_check_payroll_item_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Payable_Transaction_N_Payroll_Check_Payroll_Item$payroll_check_payroll_item_KEY$payable_transaction_KEY | payroll_check_payroll_item_KEY, payable_transaction_KEY |