Skip to main content

CRM

grocerkey

grocerkey_order_item

It contains order item data. Learn more.

nametypedescriptionvalues

user_id

STRING

product_id

STRING

picker_id

STRING

order_id

STRING

total_tax

NUMERIC

total

NUMERIC

subtotal

NUMERIC

quantity

NUMERIC

picked_quantity

NUMERIC

pick_time

TIMESTAMP

pick_status

STRING

original_price

NUMERIC

order_line_updated

TIMESTAMP

order_line_status

STRING

is_modification

NUMERIC

fixed_tax

NUMERIC

discount

NUMERIC

date

TIMESTAMPThe date (yyyy-MM-dd).

grocerkey_order_metrics

It contains order data and caluclated order metrics. Learn more.

nametypedescriptionvalues

user_id

STRINGID of the user.

order_id

STRINGID of the order.

idle_time

NUMERICTime between user placed an order and earliest picking time. Based on the formula idle_time = order_created_at - earliest_start_pick_time.

zip_code

STRINGZip code of the address.

user_weeks_since_registration

NUMERICWeeks since user was created.

user_weeks_since_first_order

NUMERICWeeks since user's first order_completed_date with status 'Complete'.

user_second_order_date

DATEUser second order date. This metric takes into account user's second order_completed_date with status 'Complete'.

user_registration_cohort_week

DATEWeek that user was created.

user_registration_cohort_quarter

DATEQuarter that user was created.

user_registration_cohort_month

DATEMonth that user was created.

user_quarters_since_registration

NUMERICQuarters since user was created.

user_quarters_since_first_order

NUMERICQuarters since user's first order_completed_date with status 'Complete'.

user_months_since_registration

NUMERICMonths since user was created.

user_months_since_first_order

NUMERICMonths since user's first order_completed_date with status 'Complete'.

user_first_order_date

DATEUser first order date. This metric takes into account user's first order_completed_date with status 'Complete'.

user_acquisition_cohort_week

DATEWeek of user's first order_completed_date with status 'Complete'.

user_acquisition_cohort_quarter

DATEQuarter of user's first order_completed_date with status 'Complete'.

user_acquisition_cohort_month

DATEMonth of user's first order_completed_date with status 'Complete'.

total_time

NUMERICTime between user placed an order and order was completed. Based on the formula order_completed_at - order_created_at.

total_sub_categories_picked

NUMERICTotal sub categories picked inside the order basket

total_parent_categories_picked

NUMERICTotal parent categories picked inside the order basket.

total_modification_times

NUMERIC

total_items_picked

NUMERIC

total_items

NUMERIC

subtotal

NUMERICTotal items price (based on original price).

store_name

STRINGName of the store.

store_code

STRINGID of the store.

status

STRINGStatus of an ordercomplete, canceled

state

STRINGState of the address.

start_time_window

TIMESTAMP

revenue_no_vat

NUMERICRevenue of the order (no VAT). Based on the formula revenue_no_vat = (subtotal+delivery_cost)-(coupon_amount+credits+refund_amount).

refund_amount

NUMERIC

pickup_location

STRING

pick_time

NUMERICTime for picking order items.

payment_method

STRINGPayment method.cc, ccu

pack_time

NUMERICTime for packing order items.

order_rank

NUMERICOrder rank per user.

order_frequency

NUMERICFrequency between user's orders.

mode

STRING

is_valid_order

NUMERICValid order is order with status 'Complete'.

is_second_order

NUMERICThe second order of the user, indicating a stronger relation  with the brand.

is_refunded

NUMERIC

is_cancelled

NUMERIC

is_acquisition

NUMERICUser is acquired/converted when his first order is complete.

hour_of_date

NUMERICThe hour of the order date.

gross_revenue_no_vat

NUMERICGross revenue of the order (no VAT). Based on the formula revenue_no_vat = subtotal+delivery_cost.

end_time_window

TIMESTAMP

driver_score

NUMERIC

driver_name

STRING

discount_applied

NUMERIC

discount_amount

NUMERIC

delivery_time

NUMERICTime between packing finished and order was completed. Based on the formula delivery_time = total_time - (pack_time + pick_time).

delivery_cost

NUMERICDelivery fee.

date

DATEThe date (yyyy-MM-dd). Order created date.

credits

NUMERIC

credit

NUMERIC

coupon_used

STRING

coupon_code

STRING

coupon_amount

NUMERIC

city

STRINGCity of the address.

cancelled_reason

STRING

batch_order

STRING

grocerkey_product

It contains product data. Learn more.

nametypedescriptionvalues

product_id

STRING

updated

TIMESTAMP

upc

STRING

total_fat

NUMERIC

sub_category

STRING

quantity

NUMERIC

protein

NUMERIC

price

NUMERIC

parentcategory

STRING

name

STRING

is_vegetarian

NUMERIC

is_vegan

NUMERIC

is_sugar_free

NUMERIC

is_low_fat

NUMERIC

is_lactose_free

NUMERIC

is_dairy_free

NUMERIC

is_active

STRING

created

TIMESTAMP

calories

NUMERIC

amount

NUMERIC

grocerkey_product_historical

It contains product data. Learn more.

nametypedescriptionvalues

product_id

STRING

sub_category

STRING

quantity

NUMERIC

price

NUMERIC

parentcategory

STRING

name

STRING

date

DATEThe date (yyyy-MM-dd).

amount

NUMERIC

hubspot

hubspot_company_contact

nametypedescriptionvalues

contact_id

STRING

company_id

STRING

updated_at

DATEThe latest timestamp that record was updated, in source_service.

hubspot_company

nametypedescriptionvalues

domain_x_id

INT

id

STRING

updated_at

DATEThe latest timestamp that record was updated, in source_service.

domain

STRING

created_at

DATEThe timestamp that record was created, in source_service.

archived

BOOL_BOOL

hubspot_contact

nametypedescriptionvalues

id

STRING

updated_at

DATEThe latest timestamp that record was updated, in source_service.

created_at

DATEThe timestamp that record was created, in source_service.

archived

BOOL_BOOL

hubspot_company_deal

nametypedescriptionvalues

deal_id

STRING

company_id

STRING

updated_at

DATEThe latest timestamp that record was updated, in source_service.

hubspot_contact_deal

nametypedescriptionvalues

deal_id

STRING

contact_id

STRING

updated_at

DATEThe latest timestamp that record was updated, in source_service.

jobtitle

STRING

email

STRING

hubspot_deal

nametypedescriptionvalues

id

STRING

updated_at

DATEThe latest timestamp that record was updated, in source_service.

created_at

DATEThe timestamp that record was created, in source_service.

archived

BOOL_BOOL

pipedrive

pipedrive_deal

nametypedescriptionvalues

user_id_value

STRING

user_id_pic_hash

STRING

user_id_name

STRING

user_id_id

STRING

user_id_has_pic

STRING

user_id_email

STRING

user_id_active_flag

STRING

stage_id

STRING

pipeline_id

STRING

person_id_value

STRING

person_id

STRING

org_id_value

STRING

org_id_people_count

NUMERIC

org_id_owner_id

STRING

org_id_name

STRING

org_id_cc_email

STRING

org_id_address

STRING

org_id_active_flag

STRING

org_id

STRING

next_activity_id

STRING

last_activity_id

STRING

id

STRING

creator_user_id_value

STRING

creator_user_id_pic_hash

STRING

creator_user_id_name

STRING

creator_user_id_id

STRING

creator_user_id_has_pic

STRING

creator_user_id_email

STRING

creator_user_id_active_flag

STRING

creator_user_id

STRING

won_time

DATE

weighted_value_currency

NUMERIC

weighted_value

NUMERIC

visible_to

STRING

value

STRING

update_time

DATE

undone_activities_count

NUMERIC

title

STRING

status

STRING

stage_order_nr

STRING

stage_name

STRING

stage_change_time

DATE

rotten_time

DATE

products_count

NUMERIC

probability

NUMERIC

pipeline_name

STRING

person_name

STRING

person_hidden

STRING

participants_count

NUMERIC

owner_name

STRING

org_name

STRING

org_hidden

STRING

notes_count

NUMERIC

next_activity_type

STRING

next_activity_time

DATE

next_activity_subject

STRING

next_activity_note

STRING

next_activity_duration

NUMERIC

next_activity_date

DATE

lost_time

DATE

lost_reason

STRING

last_outgoing_mail_time

DATE

last_incoming_mail_time

DATE

last_activity_date

DATE

label

STRING

formatted_weighted_value

STRING

formatted_value

STRING

followers_count

NUMERIC

first_won_time

DATE

files_count

NUMERIC

expected_close_date

DATE

email_messages_count

NUMERIC

done_activities_count

NUMERIC

deleted

STRING

currency

STRINGThe currency of the account.

close_time

DATE

cc_email

STRING

add_time

DATE

activities_count

NUMERIC

active

STRING

pipedrive_deal_full

nametypedescriptionvalues

user_id_value

STRING

user_id_pic_hash

STRING

user_id_name

STRING

user_id_id

STRING

user_id_has_pic

STRING

user_id_email

STRING

user_id_active_flag

STRING

stage_id

STRING

pipeline_id

STRING

person_id_value

STRING

person_id

STRING

org_id_value

STRING

org_id_people_count

NUMERIC

org_id_owner_id

STRING

org_id_name

STRING

org_id_cc_email

STRING

org_id_address

STRING

org_id_active_flag

STRING

org_id

STRING

next_activity_id

STRING

last_activity_id

STRING

id

STRING

creator_user_id_value

STRING

creator_user_id_pic_hash

STRING

creator_user_id_name

STRING

creator_user_id_id

STRING

creator_user_id_has_pic

STRING

creator_user_id_email

STRING

creator_user_id_active_flag

STRING

creator_user_id

STRING

won_time

DATE

weighted_value_currency

NUMERIC

weighted_value

NUMERIC

visible_to

STRING

value

STRING

update_time

DATE

undone_activities_count

NUMERIC

title

STRING

status

STRING

stage_order_nr

STRING

stage_name

STRING

stage_change_time

DATE

rotten_time

DATE

products_count

NUMERIC

probability

NUMERIC

pipeline_name

STRING

person_name

STRING

person_hidden

STRING

participants_count

NUMERIC

owner_name

STRING

org_name

STRING

org_hidden

STRING

notes_count

NUMERIC

next_activity_type

STRING

next_activity_time

DATE

next_activity_subject

STRING

next_activity_note

STRING

next_activity_duration

NUMERIC

next_activity_date

DATE

lost_time

DATE

lost_reason

STRING

last_outgoing_mail_time

DATE

last_incoming_mail_time

DATE

last_activity_date

DATE

label

STRING

formatted_weighted_value

STRING

formatted_value

STRING

followers_count

NUMERIC

first_won_time

DATE

files_count

NUMERIC

expected_close_date

DATE

email_messages_count

NUMERIC

done_activities_count

NUMERIC

deleted

STRING

currency

STRINGThe currency of the account.

close_time

DATE

cc_email

STRING

add_time

DATE

activities_count

NUMERIC

active

STRING

pipedrive_person

nametypedescriptionvalues

owner_id

STRING

org_id

STRING

next_activity_id

STRING

last_activity_id

STRING

id

STRING

company_id

STRING

won_deals_count

NUMERIC

visible_to

INT

update_time

DATE

undone_activities_count

NUMERIC
NUMERIC
NUMERIC
NUMERIC
NUMERIC

participant_open_deals_count

NUMERIC

participant_closed_deals_count

NUMERIC

open_deals_count

NUMERIC

notes_count

NUMERIC

next_activity_time

DATE

next_activity_date

DATE

name

STRING

lost_deals_count

NUMERIC

last_outgoing_mail_time

DATE

last_name

STRING

last_incoming_mail_time

DATE

last_activity_date

DATE

label

STRING

followers_count

NUMERIC

first_name

STRING

files_count

NUMERIC

email_messages_count

NUMERIC

done_activities_count

NUMERIC

closed_deals_count

NUMERIC

add_time

DATE

activities_count

NUMERIC

active_flag

NUMERIC

pipedrive_person_full

nametypedescriptionvalues

owner_id

STRING

org_id

STRING

next_activity_id

STRING

last_activity_id

STRING

id

STRING

company_id

STRING

won_deals_count

NUMERIC

visible_to

INT

update_time

DATE

undone_activities_count

NUMERIC
NUMERIC
NUMERIC
NUMERIC
NUMERIC

participant_open_deals_count

NUMERIC

participant_closed_deals_count

NUMERIC

open_deals_count

NUMERIC

notes_count

NUMERIC

next_activity_time

DATE

next_activity_date

DATE

name

STRING

lost_deals_count

NUMERIC

last_outgoing_mail_time

DATE

last_name

STRING

last_incoming_mail_time

DATE

last_activity_date

DATE

label

STRING

followers_count

NUMERIC

first_name

STRING

files_count

NUMERIC

email_messages_count

NUMERIC

done_activities_count

NUMERIC

closed_deals_count

NUMERIC

add_time

DATE

activities_count

NUMERIC

active_flag

NUMERIC

pipedrive_user

nametypedescriptionvalues

role_id

STRING

id

STRING

signup_flow_variation

STRING

phone

STRING

name

STRING

modified

DATE

last_login

DATE

is_admin

BOOLEAN

email

STRING

created

DATE

active_flag

BOOLEAN

pipedrive_user_full

nametypedescriptionvalues

role_id

STRING

id

STRING

signup_flow_variation

STRING

phone

STRING

name

STRING

modified

DATE

last_login

DATE

is_admin

BOOLEAN

email

STRING

created

DATE

active_flag

BOOLEAN

zoho_crm

zoho_crm_accounts

nametypedescriptionvalues

id

STRING

website

STRING

tax_authority

STRING

record_image

STRING

phone

STRING

payment_method

STRING

owner_name

STRING

official_account_name

STRING

next_invoicing_amount

NUMERIC

modified_time

DATE

last_activity_time

DATE

invoicing_date

DATE

industry

STRING

field_states

STRING

exchange_rate

STRING

employees

STRING

email_invoicing

STRING

description

STRING

currency

STRINGThe currency of the account.

created_time

DATE

created_by_name

STRING

account_type

STRING

account_name

STRINGThe name of the account.

zoho_crm_activities

It contains Zoho CRM activities.

nametypedescriptionvalues

who_id_name

STRING

who_id_id

STRING

who_id

STRING

what_id_name

STRING

what_id_id

STRING

what_id

STRING

id

STRING

zip_code

STRING

venue

STRING

type

STRING

top_priority

STRING

tag

STRING

subject

STRING

status

STRING

start_date_time

DATE

se_module

STRING

review_process

STRING

reminder

STRING

participants

STRING

owner_name

STRING

modified_time

DATE

longitude

STRING

latitude

STRING

end_date_time

DATE

due_date

DATE

description

STRING

created_time

DATE

created_by_name

STRING

closed_time

DATE

check_in_time

STRING

check_in_sub_locality

STRING

check_in_status

STRING

check_in_state

STRING

check_in_country

STRING

check_in_comment

STRING

check_in_city

STRING

check_in_by

STRING

check_in_address

STRING

call_type

STRING

call_status

STRING

call_start_time

STRING

call_result

STRING

call_purpose

STRING

call_duration_in_seconds

STRING

call_duration

NUMERIC

all_day

STRING

activity_type

STRING

account_vin

STRING

zoho_crm_contacts

It contains Zoho CRM contacts. Learn more.

nametypedescriptionvalues

id

STRINGThe ID of the Contact.

visitor_score

NUMERICScore for the Contact obtained from SalesIQ.

unsubscribed_time

DATEDate and time at which the Contact was unsubscribed.

unsubscribed_mode

STRINGUnsubscribed mode.

tag

LIST_AS_STRList of tags associated with the Contact.

salutation

STRINGThe salutation for the Contact.Ms, Mr

referrer

STRINGName and ID of the Contact who referred this Contact.

record_image

STRINGThe profile image of the Contact.

owner_name

STRINGName of the Zoho CRM user who created the Contact.

number_of_chats

NUMERICThe number of times the Contact has had a chat with the Zoho CRM team.

modified_time

DATEDate and time at which the Contact was last modified.

mailing_zip

STRINGRepresents address zip details of the Contact.

mailing_street

STRINGRepresents address street details of the Contact.

mailing_country

STRINGRepresents address country details of the Contact.

mailing_city

STRINGRepresents address city details of the Contact.

last_visited_time

DATEThe date and time at which the Contact last visited Zoho CRM.

last_activity_time

DATEThe date and time at which the Contact was last used in an operation.

first_visited_url

STRINGThe URL address of the page that the Contact visited first.

first_visited_time

DATEDate and time at which the Contact first visited Zoho CRM.

first_name

STRINGFirst name of the Contact.

email_opt_out

STRINGSpecifies whether the Contact has opted out of email notifications from Zoho CRM.

email

STRINGEmail ID of the Contact.

days_visited

STRINGThe number of days the Contact visited Zoho CRM.

date_of_birth

STRINGDate of birth of the Contact.

created_time

DATEDate and time at which the Contact was created.

created_by_name

STRINGName of the user who created the Contact.

average_time_spent_minutes

NUMERICThe average time in minutes the Contact spends in Zoho CRM.

account_name_name

STRINGName of the Account the Contact is associated with.

account_name

STRINGThe name of the account. Name of the Account the Contact is associated with.

zoho_crm_leads

It contains Zoho CRM leads. Learn more.

nametypedescriptionvalues

id

STRINGThe ID of the Lead.

zip_code

STRINGThe zip code of the lead.

visitor_score

NUMERICScore for the Lead obtained from SalesIQ.

unsubscribed_time

DATEDate and time at which the Lead was unsubscribed.

unsubscribed_mode

STRINGUnsubscribed mode.

tag

LIST_AS_STRList of tags associated with the Lead.

street

STRINGThe street address of the Lead.

state

STRINGThe state of the Lead.

secondary_email

STRINGAlternative email Id of the Lead.

salutation

STRINGThe salutation for the Lead.Ms, Mr

referrer

STRINGName and ID of the Contact who referred this Lead.

record_image

STRINGThe profile image of the Lead.

owner_name

STRINGName of the company where the Lead is working.

number_of_chats

NUMERICThe number of times the Lead has had a chat with the Zoho CRM team.

modified_time

DATEDate and time at which the Lead was last modified.

lead_status

STRINGStatus of the Lead.

lead_source

STRINGRepresents the source from which the Lead was created.

last_visited_time

DATEThe date and time at which the lead last visited Zoho CRM.

last_activity_time

DATEThe date and time at which the Lead was last used in an operation.

interested_in

STRINGInterests of the Lead.

first_visited_url

STRINGThe URL address of the page that the lead visited first.

first_visited_time

DATEDate and time at which the Lead first visited Zoho CRM.

first_name

STRINGFirst name of the Lead.

exchange_rate

NUMERICRepresents the exchange rate of the current currency to the home currency.

email

STRINGEmail ID of the Lead.

description

NUMERICDescription of the Lead.

days_visited

STRINGThe number of days the lead visited Zoho CRM.

currency

STRINGThe currency of the account. The currency in which the revenue is generated.

created_time

DATEDate and time at which the Lead was created.

created_by_name

STRINGName of the user who created the Lead.

country

STRINGThe name of the country. The country of the Lead.

company

STRINGThe name of the owner of the Lead.

city

STRINGThe city of the Lead.

category

LIST_AS_STRCategory of the Lead.

average_time_spent_minutes

NUMERICThe average time in minutes the Lead spends in Zoho CRM.

zoho_crm_maintenance

nametypedescriptionvalues

vehicle_id

STRING

rider_id

STRING

id

STRING

vehicle_name

STRING

unsubscribed_time

DATE

unsubscribed_mode

STRING

type

STRING

status

STRING

service_minutes

STRING

service_location

STRING

service_date

DATE

rider

STRING

parts

STRING

owner_name

STRING

name

STRING

last_activity_time

DATE

fault

STRING

exchange_rate

NUMERIC

days_waiting_for_parts

STRING

days_in_warehouse

NUMERIC

currency

STRINGThe currency of the account.

cost

NUMERICThe amount of money spend.

contact_date

DATE

zoho_crm_products

It contains Zoho CRM products. Learn more.

nametypedescriptionvalues

id

STRINGThe ID of the product.

tag

STRINGList of tags associated with the product.

record_image

STRINGRepresents the product image details.

product_name

STRINGName of the product.

owner_name

STRINGName of the Zoho CRM user who created the product.

handler

STRINGName of the Zoho CRM user who handles the product.

zoho_subscriptions

zoho_subscriptions_events

It contains Zoho Subscriptions events. Learn more.

nametypedescriptionvalues

table_x_id

INTA surrogate key to uniquely identify specific row.

event_id

STRING

event_type

STRING

event_time

DATE

event_source

STRING

zoho_subscriptions_invoices

It contains Zoho Subscriptions invoices. Learn more.

nametypedescriptionvalues

invoice_id

STRING

customer_id

STRING

updated_time

DATE

transaction_type

STRING

total

NUMERIC

status

STRING

shipping_zipcode

STRING

shipping_street2

STRING

shipping_street

STRING

shipping_state

STRING

shipping_phone

STRING

shipping_country

STRING

shipping_city

STRING

shipping_address_zipcode

STRING

shipping_address_street2

STRING

shipping_address_street

STRING

shipping_address_state

STRING

shipping_address_phone

STRING

shipping_address_fax

STRING

shipping_address_country

STRING

shipping_address_city

STRING

shipping_address_attention

STRING

salesperson

STRING

phone

STRING

payment_expected_date

DATE

number

STRING

mail_last_viewed_time

DATE

mail_first_viewed_time

DATE

is_viewed_in_mail

STRING

is_viewed_by_client

STRING

invoice_date

DATE

has_attachment

STRING

email

STRING

due_date

DATE

customer_name

STRING

currency_symbol

STRING

currency_code

STRING

created_time

DATE

created_by

STRING

country

STRINGThe name of the country.

client_viewed_time

DATE

billing_zipcode

STRING

billing_street2

STRING

billing_street

STRING

billing_state

STRING

billing_phone

STRING

billing_country

STRING

billing_city

STRING

billing_address_zipcode

STRING

billing_address_street2

STRING

billing_address_street

STRING

billing_address_state

STRING

billing_address_phone

STRING

billing_address_fax

STRING

billing_address_country

STRING

billing_address_city

STRING

billing_address_attention

STRING

balance

NUMERIC

ach_payment_initiated

STRING

zoho_subscriptions_plans

It contains Zoho Subscriptions Plans. Learn more.

nametypedescriptionvalues

tax_id

STRING

setup_fee_account_id

STRING

product_id

STRING

plan_id

STRING

account_id

STRINGThe ID of the account.

url

STRING

updated_time_formatted

DATE

updated_time

DATE

unit

STRING

trial_period

NUMERIC

tax_type

STRING

tax_percentage

NUMERIC

tax_name

STRING

store_markup_description

STRING

store_description

STRING

status

STRING

show_in_widget

STRING

shipping_interval_unit

STRING

shipping_interval

NUMERIC

setup_fee_account_name

STRING

setup_fee

NUMERIC

recurring_price

NUMERIC

product_type

STRING

plan_code

STRING

name

STRING

interval_unit

STRING

interval

NUMERIC

description

STRING

created_time_formatted

DATE

created_time

DATE

billing_mode

STRING

billing_cycles

NUMERIC

account

STRINGThe name of the account.

zoho_subscriptions_products

It contains Zoho Subscriptions products. Learn more.

nametypedescriptionvalues

product_id

STRING

email_ids

STRING

updated_time

DATE

status

STRING

redirect_url

STRING

plans_count

NUMERIC

name

STRING

description

STRING

created_time

DATE

coupons_count

NUMERIC

addons_count

NUMERIC

zoho_subscriptions_subscriptions

It contains Zoho Subscriptions. Learn more.

nametypedescriptionvalues

table_x_id

INTA surrogate key to uniquely identify specific row.

zcrm_potential_id

STRING

subscription_id

STRING

salesperson_id

STRING

reference_id

STRING

customer_id

STRING

crm_owner_id

STRING

zcrm_potential_name

STRING

updated_time

DATE

trial_extended_count

NUMERIC

total_orders

NUMERIC

subscription_number

STRING

sub_total

NUMERIC

status

STRING

source

STRING

shipping_interval_unit

STRING

shipping_interval

NUMERIC

scheduled_cancellation_date

DATE

salesperson_name

STRING

resume_date

DATE

plan_name

STRING

plan_code

STRING

payment_terms_label

STRING

payment_terms

STRING

pause_date

DATE

orders_remaining

NUMERIC

orders_created

NUMERIC

next_shipment_day

DATE

next_shipment_at

DATE

next_retry_at

DATE

next_billing_at

DATE

name

STRING

last_shipment_day

DATE

last_shipment_at

DATE

last_billing_at

DATE

is_metered_billing

STRING

interval_unit

STRING

interval

NUMERIC

expires_at

DATE

email

STRING

customer_name

STRING

current_term_starts_at

DATE

current_term_ends_at

DATE

currency_symbol

STRING

currency_code

STRING

created_time

DATE

created_by

STRING

created_at

DATEThe timestamp that record was created, in source_service.

coupon_duration

STRING

cancelled_at

DATE

billing_mode

STRING

auto_collect

STRING

amount

NUMERIC

activated_at

DATE