To Setup Card Schedules via Batch Upload, populate the sheet SetupCardSchedule using the columns described below.
Property | Summary | Format | Required | Example |
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 |
Card.NameOnAccount | The name associated with the card | Alpha Numeric (2-99 chars) | Yes | John Doe and Associates |
Card.CardNumber | The valid credit card number of the customer | Numeric (15-16 digits) | Yes | 4012888888881881 |
Card.ExpirationMonth | The customer's valid bank account number | Numeric (2 digits) | Yes | 12 |
Card.ExpirationYear | The customer's valid bank account number | Numeric (4 digits) | Yes | 2012 |
Card.SecurityCode | The security code associate with the customer's card | Numeric (3-4 digits) | No | 999 |
Card.Address.Street | Street number and name | Alpha Numeric (0-99 chars) | Yes | 400 E. Royal Lane #201 |
Card.Address.City | City of address | Alpha (0-99 chars) | Yes | Irving |
Card.Address.State | State code of address | Alpha (2 chars) | Yes | TX |
Card.Address.Zip | Postal code of address | Numeric (0-10 digits) | Yes | 75039-2291 |
Card.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 |