Table: dbo.Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail
Details of creditor garnishment orders for payroll check payroll item distributions
Columns
Name | Type | Constraints | Description
payroll_check_payroll_item_distribution_creditor_garnishment_detail_KEY | int (4) | NOT NULL | Primary Key
payroll_check_payroll_item_distribution_KEY | int (4) | NOT NULL | Key to distribution record.
creditor_garnishment_order_KEY | int (4) | NOT NULL | Key to related creditor garnishment order record.
amount | decimal (9, 2) | NOT NULL | The amount of this distribution associated with this creditor garnishment order.
case_identifier | nvarchar (40) | NOT NULL |
ste_state_code_KEY | nvarchar (4) | NOT NULL |
ste_county_KEY | int (4) |  |
vendor_KEY | int (4) |  | Foreign key to Vendor table. A null value means no vendor is associated with this record.

Primary key
Name | Columns | Description
PK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail | payroll_check_payroll_item_distribution_creditor_garnishment_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Creditor_Garnishment_Order__creditor_garnishment_order_K | creditor_garnishment_order_KEY | Creditor_Garnishment_Order (creditor_garnishment_order_KEY) |
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Payroll_Check_Payroll_Item_Distribution__payroll_check_p | payroll_check_payroll_item_distribution_KEY | Payroll_Check_Payroll_Item_Distribution (payroll_check_payroll_item_distribution_KEY) |
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Ste_County__ste_county_KEY | ste_county_KEY | Ste_County (ste_county_KEY) |
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |