Table: dbo.Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount | |||
Provide employee reconciliation form override monthly overrride amounts from the employee detail view grid | |||
Columns | |||
Name | Type | Constraints | Description |
employee_reconciliation_tax_form_tax_jurisdiction_override_month_amount_KEY | int (4) | NOT NULL | Primary Key |
employee_reconciliation_tax_form_tax_jurisdiction_override_KEY | int (4) | NOT NULL | employee/tax jurisdiction this override is related to |
reconciliation_tax_form_override_type_KEY | int (4) | NOT NULL | Type of monthly amount this override is for |
month_value | int (4) | NOT NULL | Month (1-12) this override amount is for |
amount | decimal (9, 2) | NOT NULL | override amount |
Primary key | |||
Name | Columns | Description | |
PK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount | employee_reconciliation_tax_form_tax_jurisdiction_override_month_amount_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount$employee_reconciliation_tax_form_tax_jurisdiction_ove | employee_reconciliation_tax_form_tax_jurisdiction_override_KEY, reconciliation_tax_form_override_type_KEY, month_value |