CustomerBank

Sedona internal autonumber for the Customer Bank record; required for PUT

Foreign key from AR_Customer table; required for POST/PUT

Foreign key from AR_Bank table (not the Customer_Bank_Id); set automatically on POST; set to zero on PUTS to change the Bank

The bank's 9-digit routing number; required for POST; set automatically on PUT (already created)

BankName (i.e. Wells Fargo, US Bank, etc.); set (and required) only on POST

The customer's bank account number; required for POST; value will come back encrypted on GET

read only; used internally

C = Checking; S = Savings

Checking or Savings (based on CheckingOrSavings field)

Foreign key from AR_Payment_Method table; set automatically during POST/PUT

maps to Bank_Account_Name (changed to be more intuitive)

This bank account should be used for Recurring Auto Processing; if set to true, all other payment methods for this customer will be set to false

Display only; Y if UsedForAutoProcess = true

Day of month to auto-process payment; required if UsedForAutoProcess is true

Last four digits of the Bank Account Number; required

This bank account should be used for Non-Recurring Auto Processing

Set to true only to designate this bank account in conjunction with an initial ACH payment

Optional - pass in the CustomerBillId this is tied to; defaults to 1 if not supplied

Optional - set true on PUT to update the Hold Date for any unsubmitted EFT transactions using this Bank Account to a new AutoProcessDay (same month only)

Optional - set true on PUT to void any existing unsubmitted EFT transactions using this Bank Account

Optional - pass in a previous CustomerBankID that this payment method is replacing; the system will void any pending ACH transactions (unsubmitted only) for that CustomerBankID, and replace them with this new Customer Bank

Optional - pass in an existing CustomerCCID that this payment method is replacing; the system will void any pending ACH transactions (unsubmitted only) for that CustomerCCID, and replace them with this new Customer Bank

Print Cycle Invoices in AR_Customer table