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
NameTypeConstraintsDescription
skipped_direct_deposit_voucher_id_KEYint (4)NOT NULLPrimary Key for this table.
checkbook_KEYint (4)NOT NULLCheckbook the skipped number is associated with.
numberdecimal (9)NOT NULLThe numeric portion of the voucher id we skipped.
Primary key
NameColumnsDescription
PK_Skipped_Direct_Deposit_Voucher_Idskipped_direct_deposit_voucher_id_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Skipped_Direct_Deposit_Voucher_Id__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)

Schema diagram