Table: dbo.Skipped_Direct_Deposit_Voucher_Id | |||
Each record lists a voucher id that we tried to use but for some reason were not able to, and we choose not to return to the pool of available voucher ids. | |||
Columns | |||
Name | Type | Constraints | Description |
skipped_direct_deposit_voucher_id_KEY | int (4) | NOT NULL | Primary Key for this table. |
checkbook_KEY | int (4) | NOT NULL | Checkbook the skipped number is associated with. |
number | decimal (9) | NOT NULL | The numeric portion of the voucher id we skipped. |
Primary key | |||
Name | Columns | Description | |
PK_Skipped_Direct_Deposit_Voucher_Id | skipped_direct_deposit_voucher_id_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Skipped_Direct_Deposit_Voucher_Id__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |