To Update ACH Schedules via Batch Upload, populate the sheet UpdateACHSchedule using the columns described below.
Property | Summary | Format | Required | Example |
ProfileNumber | Identifier for profile to be updated | Numeric (10 digits) | Yes | 1234567890 |
Listing Name | Customer's name as it should appear on schedule | Alpha (0-255 chars) | Yes | John and Mary Doe |
Frequency | How often customer should be billed... One Time Only = 0 Weekly = 52 Semi Weekly = 26 Bi Monthly = 24 Monthly = 12 Quarterly = 4 Bi Annually = 2 Annually = 1 |
Numeric (2 digits) | Yes | 12 |
StartDateTime | Starting date of the schedule | MM/DD/YYYY | Yes | 1/1/2010 |
EndingDateTime | Date schedule should end | MM/DD/YYYY | No | 12/31/2010 |
Amount | Total amount of transaction | 0.00 | Yes | 9.65 |
Currency | Standard currency code | Alpha (3 digits) | Yes | USD |
Check.RoutingNumber | The valid routing number of the customer's bank | Alpha Numeric (9 digits) | Yes | 123456789 |
Check.AccountNumber | The customer's valid bank account number | Alpha Numeric (4-15 digits) | Yes | The customer's checking, business checking or savings bank account number |
Check.NameOnAccount | The name associated with the bank account | Alpha Numeric (2-99 chars) | Yes | John Doe and Associates |
Check.Address.Street | Street number and name | Alpha Numeric (0-99 chars) | Yes | 400 E. Royal Lane #201 |
Check.Address.City | City of address | Alpha (0-99 chars) | Yes | Irving |
Check.Address.State | State code of address | Alpha (2 chars) | Yes | TX |
Check.Address.Zip | Postal code of address | Numeric (0-10 digits) | Yes | 75039-2291 |
Check.Address.Country | Standard Country Code of address | Alpha (2 chars) | Yes | US |
Check.Phone_1.Number | Customer phone number | Numeric (0-13 digits) | No | (214)555-1212 |
Check.Phone_1.Type | Label for phone number | Alpha Numeric (0-9 chars) | No | Home |
Check.Phone_2.Number | Customer phone number | Numeric (0-13 digits) | No | (214)555-1213 |
Check.Phone_2.Type | Label for phone number | Alpha Numeric (0-9 chars) | No | Work |
Check.Identification.IDType |
Type of ID being entered: Drivers License = 1 State Non Driver = 2 Military = 3 Other = 4 |
Numeric (1 digit) | Yes | 1 |
Check.Identification.State | State code of issueing state | Alpha (2 chars) | No | TX |
Check.Identification.Number | Number or identifier of ID | Alpha Numeric (2-15 digit) | Yes | 12345678 |
Check.Identification.Expiration | Date of ID expires | MM/DD/YYYY | No | 12/12/2009 |
Check.Identification.DOB | Date of Birth on ID | MM/DD/YYYY | No | 12/12/1965 |
Check.Identification.Address.Street | Street number and name | Alpha Numeric (0-99 chars) | Yes | 400 E. Royal Lane #201 |
Check.Identification.Address.City | City of address | Alpha (0-99 chars) | Yes | Irving |
Check.Identification.Address.State | State code of address | Alpha (2 chars) | Yes | TX |
Check.Identification.Address.Country | Standard Country Code of address | Alpha (2 chars) | Yes | US |
CustomFields.Field_1 | Optional custom field | |||
CustomFields.Field_2 | Optional custom field | |||
CustomFields.Field_3 | Optional custom field | |||
CustomFields.Field_4 | Optional custom field | |||
CustomFields.Field_5 | Optional custom field | |||
CustomFields.Field_6 | Optional custom field | |||
CustomFields.Field_7 | Optional custom field | |||
CustomFields.Field_8 | Optional custom field | |||
CustomFields.Field_9 | Optional custom field | |||
CustomFields.Field_10 | Optional custom field | |||
CustomFields.Field_11 | Optional custom field | |||
CustomFields.Field_12 | Optional custom field | |||
CustomFields.Field_13 | Optional custom field | |||
CustomFields.Field_14 | Optional custom field | |||
CustomFields.Field_15 | Optional custom field | |||
CustomFields.Field_16 | Optional custom field | |||
CustomFields.Field_17 | Optional custom field | |||
CustomFields.Field_18 | Optional custom field | |||
CustomFields.Field_19 | Optional custom field | |||
CustomFields.Field_20 | Optional custom field | |||
CustomFields.Field_21 | Optional custom field | |||
CustomFields.Field_22 | Optional custom field | |||
CustomFields.Field_23 | Optional custom field | |||
CustomFields.Field_24 | Optional custom field | |||
CustomFields.Field_25 | Optional custom field | |||
CustomFields.Field_26 | Optional custom field | |||
CustomFields.Field_27 | Optional custom field | |||
CustomFields.Field_28 | Optional custom field | |||
CustomFields.Field_29 | Optional custom field | |||
CustomFields.Field_30 | Optional custom field |