Table: dbo.Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail
Details of creditor garnishment orders for payroll check payroll item distributions
Columns
NameTypeConstraintsDescription
payroll_check_payroll_item_distribution_creditor_garnishment_detail_KEYint (4)NOT NULLPrimary Key
payroll_check_payroll_item_distribution_KEYint (4)NOT NULLKey to distribution record.
creditor_garnishment_order_KEYint (4)NOT NULLKey to related creditor garnishment order record.
amountdecimal (9, 2)NOT NULLThe amount of this distribution associated with this creditor garnishment order.
case_identifiernvarchar (40)NOT NULL
ste_state_code_KEYnvarchar (4)NOT NULL
ste_county_KEYint (4)
vendor_KEYint (4)Foreign key to Vendor table. A null value means no vendor is associated with this record.
Primary key
NameColumnsDescription
PK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detailpayroll_check_payroll_item_distribution_creditor_garnishment_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Creditor_Garnishment_Order__creditor_garnishment_order_Kcreditor_garnishment_order_KEYCreditor_Garnishment_Order (creditor_garnishment_order_KEY)
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Payroll_Check_Payroll_Item_Distribution__payroll_check_ppayroll_check_payroll_item_distribution_KEYPayroll_Check_Payroll_Item_Distribution (payroll_check_payroll_item_distribution_KEY)
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Ste_County__ste_county_KEYste_county_KEYSte_County (ste_county_KEY)
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)

Schema diagram