| Table: dbo.Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail | |||
| Columns | |||
| Name | Type | Constraints | Description |
| payroll_check_payroll_item_distribution_child_support_detail_KEY | int (4) | NOT NULL | Primary Key |
| payroll_check_payroll_item_distribution_KEY | int (4) | NOT NULL | Key to distribution record. |
| child_support_order_KEY | int (4) | NOT NULL | Key to related child support order record. |
| amount | decimal (9, 2) | NOT NULL | The amount of this distribution associated with this child support 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_Child_Support_Detail | payroll_check_payroll_item_distribution_child_support_detail_KEY | ||