Table: dbo.Shortfall_Transaction | |||
Transactions to track tax and deduction shortfalls from checks and restitution payments. | |||
Columns | |||
Name | Type | Constraints | Description |
shortfall_transaction_KEY | int (4) | NOT NULL | Primary key |
shortfall_transaction_type_KEY | int (4) | NOT NULL | Type of transaction |
employee_KEY | int (4) | NOT NULL | Foreign key to the associated employee |
transaction_date | smalldatetime (4) | NOT NULL | Date of the transaction |
amount | decimal (9, 2) | NOT NULL | Dollar amount. Positive is a check shortfall, negative is a restitution or waiver |
Primary key | |||
Name | Columns | Description | |
PK_Shortfall_Transaction | shortfall_transaction_KEY |