Table: dbo.Vendor_Direct_Deposit_Allocation
Columns
NameTypeConstraintsDescription
vendor_direct_deposit_allocation_KEYint (4)NOT NULLPrimary key for the Vendor_Direct_Deposit_Allocation table.
processing_orderint (4)NOT NULLOrder in which allocations are processed
vendor_KEYint (4)NOT NULLVendor allocations are for
bank_KEYint (4)NOT NULLVendor bank
bank_account_numbernvarchar (34)NOT NULLVendor bank account number
bank_account_type_KEYnvarchar (22)NOT NULLVendor bank account type
allocation_amountdecimal (9, 2)Allocation amount
allocation_percentdecimal (5, 2)Allocation percent
direct_deposit_status_KEYnvarchar (40)NOT NULLStatus of vendor account
prenote_datesmalldatetime (4)Date vendor account was prenoted
prenote_createdbit (1)NOT NULLFlag indicating that a prenote file have been created for this entry
use_international_formatbit (1)NOT NULL
us_gateway_operator__bank_KEYint (4)
destination__country_code_KEYint (4)
prenote_effective_datesmalldatetime (4)The effective date used when prenoting this allocation.
notesnvarchar (480)NOT NULLDirect deposit processing notes when this allocation is prenoted.
Primary key
NameColumnsDescription
PK_Vendor_Direct_Deposit_Allocationvendor_direct_deposit_allocation_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_Direct_Deposit_Allocation__Bank__bank_KEYbank_KEYBank (bank_KEY)
FK_Vendor_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEYus_gateway_operator__bank_KEYBank (bank_KEY)
FK_Vendor_Direct_Deposit_Allocation__Bank_Account_Type__bank_account_type_KEYbank_account_type_KEYBank_Account_Type (bank_account_type_KEY)
FK_Vendor_Direct_Deposit_Allocation__Country_Code__destination__country_code_KEYdestination__country_code_KEYCountry_Code (country_code_KEY)
FK_Vendor_Direct_Deposit_Allocation__Direct_Deposit_Status__direct_deposit_status_KEYdirect_deposit_status_KEYDirect_Deposit_Status (direct_deposit_status_KEY)
FK_Vendor_Direct_Deposit_Allocation__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)

Schema diagram