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 |