Table: dbo.Direct_Deposit_Bank_Transaction_Allocation
Columns
NameTypeConstraintsDescription
direct_deposit_bank_transaction_allocation_KEYint (4)NOT NULLPrimary key
bank_transaction_KEYint (4)NOT NULLForeign key to the parent direct deposit bank transaction.
bank_account_numbernvarchar (34)NOT NULLThe direct deposit recipient's account number at their bank.
bank_account_type_KEYnvarchar (22)NOT NULLForeign key to the type of bank account the money is being direct deposited into.
amount_originaldecimal (9, 2)NOT NULLThe amount being deposited for this direct deposit allocation.
direct_deposit_status_KEYnvarchar (40)NOT NULLForeign key to the direct deposit status of this allocation.
is_processedbit (1)NOT NULLFlag indicating that this entry has been processed for ACH and is frozen. ["BR"] Most entries are processed into ACH files. However, some (like reversed bank transactions ["BR"] and zero amount allocations) may simply be marked as processed but not placed into an ACH file.
effective_datesmalldatetime (4)Effective date of the allocation if edited by the user - null otherwise
bank_KEYint (4)NOT NULLBank that the allocation is associated to.
use_international_formatbit (1)NOT NULLThis allocation requires international ACH formatting.
us_gateway_operator__bank_KEYint (4)Key to bank acting as US gateway operator.
destination__country_code_KEYint (4)Key to destination country code.
amount_overridedecimal (9, 2)Overridden amount
amountdecimal (9, 2)NOT NULLAmount of item, either amount_override if not null otherwise amount_original. The trigger is used to determine where to get the value from.
ach_company_batch_header_record_KEYint (4)
is_included_in_ach_filebit (1)NOT NULLAbout the purpose of this column -- this column keeps track of whether an allocation row has ever been added to an ACH file. ["BR"] It should be set true if it is or was once part of an ACH file, and false if it was never placed in an ACH file.["BR"] Here is some more detail:["BR"] this column should be set to true when a non null value is assigned to the ach_company_batch_header_record_KEY, ["BR"] and it should be set to false when a null value is assigned to the ach_company_batch_header_record_KEY. ["BR"] The purpose of is_included_in_ach_file is that its value should be maintained during ["BR"] the CDMU client backup and restore process, even when backing up a client from one database ["BR"] and restoring that client into a different ACS database. ach_company_batch_header_record_KEY ["BR"] will be set to null when restoring into a different database. ["BR"] This special client backup and restore scenario -- back up from one database, restore into another -- ["BR"] is the one situation where is_included_in_ach_file may be true when ach_company_batch_header_record_KEY is null. ["BR"] Otherwise, these two fields should be synchronized.
Primary key
NameColumnsDescription
PK_Direct_Deposit_Bank_Transaction_Allocationdirect_deposit_bank_transaction_allocation_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEYach_company_batch_header_record_KEYAch_Company_Batch_Header_Record (ach_company_batch_header_record_KEY)
FK_Direct_Deposit_Bank_Transaction_Allocation__Bank__bank_KEYbank_KEYBank (bank_KEY)
FK_Direct_Deposit_Bank_Transaction_Allocation__Bank__us_gateway_operator__bank_KEYus_gateway_operator__bank_KEYBank (bank_KEY)
FK_Direct_Deposit_Bank_Transaction_Allocation__Bank_Account_Type__bank_account_type_KEYbank_account_type_KEYBank_Account_Type (bank_account_type_KEY)
FK_Direct_Deposit_Bank_Transaction_Allocation__Country_Code__destination__country_code_KEYdestination__country_code_KEYCountry_Code (country_code_KEY)
FK_Direct_Deposit_Bank_Transaction_Allocation__Direct_Deposit_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYDirect_Deposit_Bank_Transaction (bank_transaction_KEY)
FK_Direct_Deposit_Bank_Transaction_Allocation__Direct_Deposit_Status__direct_deposit_status_KEYdirect_deposit_status_KEYDirect_Deposit_Status (direct_deposit_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_BS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Recorddirect_deposit_bank_transaction_allocation_KEYBS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record
FK_Bank_Transaction_Reconciliation_Detail__Direct_Deposit_Bank_Transaction_Allocation__source__direct_deposit_bank_transaction_asource__direct_deposit_bank_transaction_allocation_KEYBank_Transaction_Reconciliation_Detail
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Direct_Deposit_Bank_Transaction_Allocation__direct_deposit_bank_trandirect_deposit_bank_transaction_allocation_KEYDirect_Deposit_Bank_Transaction_Allocation_Distribution

Schema diagram