# RecurringPayments: ActiveCampaign Recurring Payments ## Documentation Recurring payments imported into ActiveCampaign - Catalog: `ActiveCampaign` - Schema: `CustomObjects` - Primary Keys: `id` - Label: Recurring Payments - Retrieve: True - Insert: True - Update: False - Delete: False ## Table Columns The columns of the table `RecurringPayments` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `anchor_date` | `datetime` | Anchor Date | ☐ | Anchor Date | | `billing_address_address_1` | `varchar2` | Billing Address Address 1 | ☐ | Billing Address Line 1 | | `billing_address_address_2` | `varchar2` | Billing Address Address 2 | ☐ | Billing Address Line 2 | | `billing_address_address_3` | `varchar2` | Billing Address Address 3 | ☐ | Billing Address Line 3 | | `billing_address_city` | `varchar2` | Billing Address City | ☐ | Billing Address City | | `billing_address_company` | `varchar2` | Billing Address Company | ☐ | Billing Address Company | | `billing_address_country` | `varchar2` | Billing Address Country | ☐ | Billing Address Country | | `billing_address_email` | `varchar2` | Billing Address Email | ☐ | Billing Address Email | | `billing_address_first_name` | `varchar2` | Billing Address First Name | ☐ | Billing Address First Name | | `billing_address_last_name` | `varchar2` | Billing Address Last Name | ☐ | Billing Address Last Name | | `billing_address_phone` | `varchar2` | Billing Address Phone | ☐ | Billing Address Phone | | `billing_address_postal` | `varchar2` | Billing Address Postal | ☐ | Billing Address Postal Codes | | `billing_address_province` | `varchar2` | Billing Address Province | ☐ | Billing Address Province | | `billing_interval_count` | `int64` | Billing Interval Count | ☐ | Billing Interval Count | | `billing_interval` | `varchar2` | Billing Interval | ☐ | Billing Interval | | `cancel_at_period_end` | `varchar2` | Cancel at Period End | ☐ | Cancel at Period End | | `cancelled_date` | `datetime` | Cancelled Date | ☐ | Cancelled Date | | `createdTimestamp` | `datetime` | Created | ☐ | Moment of creation. | | `currency` | `varchar2` | Currency | ☐ | Currency | | `discount_amount_currency` | `varchar2` | Discount Amount Currency | ☐ | Currency of the amount in column discount_amount. | | `discount_amount` | `decimal` | Discount Amount | ☐ | Discount Amount | | `email` | `varchar2` | Email Address | ☐ | Email | | `id` | `varchar2` | ID | ☑ | Unique ID of the record, in the form of a GUID. | | `is_trial` | `varchar2` | Is Trial | ☐ | Is Trial | | `last_payment_date` | `datetime` | Last Payment Date | ☐ | Last Payment Date | | `last_payment_status` | `varchar2` | Last Payment Status | ☐ | Last Payment Status | | `legacy_connection_id` | `int64` | Legacy Connection ID | ☐ | Legacy Connection ID | | `line_item_brands` | `varchar2` | Line Item Brands | ☐ | Line Item Brand | | `line_item_categories` | `varchar2` | Line Item Categories | ☐ | Line Item Category | | `line_item_names` | `varchar2` | Line Item Names | ☐ | Line Item Name | | `line_item_skus` | `varchar2` | Line Item SKUs | ☐ | Line Item Sku | | `line_item_store_primary_ids` | `varchar2` | Line Item Store Primary IDs | ☐ | Line Item Store Primary ID | | `line_item_tags` | `varchar2` | Line Item Tags | ☐ | Line Item Tag | | `name` | `varchar2` | Name | ☐ | Recurring Payment Name | | `next_payment_date` | `datetime` | Next Payment Date | ☐ | Next Payment Date | | `normalized_status` | `varchar2` | Normalized Status | ☐ | Recurring Payment Status | | `notes` | `varchar2` | Notes | ☐ | Note | | `origin_order_id` | `varchar2` | Origin Order ID | ☐ | Origin Order ID | | `payment_amount_currency` | `varchar2` | Payment Amount Currency | ☐ | Currency of the amount in column payment_amount. | | `payment_amount` | `decimal` | Payment Amount | ☐ | Payment Amount | | `payment_method_expiration` | `datetime` | Payment Method Expiration | ☐ | Payment Method Expiration | | `primary_contact` | `varchar2` | Primary Contact | ☐ | Contact for Recurring Payment | | `renewal_date` | `datetime` | Renewal Date | ☐ | Renewal Date | | `schemaId` | `varchar2` | Schema ID | ☐ | Unique ID of the custom object the record belongs to. | | `shipping_address_address_1` | `varchar2` | Shipping Address Address 1 | ☐ | Shipping Address Line 1 | | `shipping_address_address_2` | `varchar2` | Shipping Address Address 2 | ☐ | Shipping Address Line 2 | | `shipping_address_address_3` | `varchar2` | Shipping Address Address 3 | ☐ | Shipping Address Line 3 | | `shipping_address_city` | `varchar2` | Shipping Address City | ☐ | Shipping Address City | | `shipping_address_company` | `varchar2` | Shipping Address Company | ☐ | Shipping Address Company | | `shipping_address_country` | `varchar2` | Shipping Address Country | ☐ | Shipping Address Country | | `shipping_address_email` | `varchar2` | Shipping Address Email | ☐ | Shipping Address Email | | `shipping_address_first_name` | `varchar2` | Shipping Address First Name | ☐ | Shipping Address First Name | | `shipping_address_last_name` | `varchar2` | Shipping Address Last Name | ☐ | Shipping Address Last Name | | `shipping_address_phone` | `varchar2` | Shipping Address Phone | ☐ | Shipping Address Phone | | `shipping_address_postal` | `varchar2` | Shipping Address Postal | ☐ | Shipping Address Postal Codes | | `shipping_address_province` | `varchar2` | Shipping Address Province | ☐ | Shipping Address Province | | `shipping_amount_currency` | `varchar2` | Shipping Amount Currency | ☐ | Currency of the amount in column shipping_amount. | | `shipping_amount` | `decimal` | Shipping Amount | ☐ | Shipping Amount | | `start_date` | `datetime` | Start Date | ☐ | Start Date | | `store_created_date` | `datetime` | Store Created Date | ☐ | Store Created Date | | `store_customer_id` | `varchar2` | Store Customer ID | ☐ | Store's Customer ID | | `store_external_id` | `varchar2` | Store External ID | ☐ | Store External ID | | `store_modified_date` | `datetime` | Store Modified Date | ☐ | Store Modified Date | | `store_recurring_payment_id` | `varchar2` | Store Recurring Payment ID | ☐ | Store Recurring Payment ID | | `store_status` | `varchar2` | Store Status | ☐ | Store's Recurring Payment Status | | `suppress_automations` | `varchar2` | Suppress Automations | ☐ | Suppress Automation | | `tax_amount_currency` | `varchar2` | Tax Amount Currency | ☐ | Currency of the amount in column tax_amount. | | `tax_amount` | `decimal` | Tax Amount | ☐ | Tax Amount | | `total_cycles` | `int64` | Total Cycles | ☐ | Total Cycles | | `updatedTimestamp` | `datetime` | Last Modified | ☐ | Moment of last change. |