Table: dbo.Payable_Transaction_N_Payroll_Check_Tax_Item | |||
This dictionary table associates payroll check tax items with the liabilities created from them. | |||
Columns | |||
Name | Type | Constraints | Description |
payable_transaction_n_payroll_check_tax_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_tax_item_KEY | int (4) | NOT NULL | Foreign key to Payroll_Check_Tax_Item table. |
Primary key | |||
Name | Columns | Description | |
PK_Payable_Transaction_N_Payroll_Check_Tax_Item | payable_transaction_n_payroll_check_tax_item_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Payable_Transaction_N_Payroll_Check_Tax_Item$payroll_check_tax_item_KEY$payable_transaction_KEY | payroll_check_tax_item_KEY, payable_transaction_KEY |