Table: dbo.Fund_Payroll_Transaction_Type
The type of payroll transaction funding to be performed. Payroll funding can be done on the entire transaction, or the direct deposit or net check portion only.
Columns
NameTypeConstraintsDescription
fund_payroll_transaction_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (60)NOT NULLContains the different payroll funding transaction segment types.
Primary key
NameColumnsDescription
PK_Fund_Payroll_Transaction_Typefund_payroll_transaction_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Checkbook__Fund_Payroll_Transaction_Type__fund_payroll_transaction_type_KEYfund_payroll_transaction_type_KEYCheckbook
FK_Direct_Deposit_Bank_Transaction__Fund_Payroll_Transaction_Type__fund_payroll_transaction_type_KEYfund_payroll_transaction_type_KEYDirect_Deposit_Bank_Transaction

Schema diagram