Schema Information

This subtopic provides a structured reference to assist you in working with Daton's ePallet ERP connector and the associated fields and tables.

Schema Information

This subtopic provides a structured reference to assist you in working with Daton's ePallet ERP connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the ePallet ERP connector:

orders
products
vendors
users
customers
customer_groups

orders

Purpose: This API is used to fetch the orders associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
id	NUMERIC
order_number	STRING
status	STRING
date_placed	TIMESTAMP
last_updated	TIMESTAMP
has_tracking_number	STRING
fob_company_name	STRING
fob_location_address	STRING
delivery_address	STRING
shipping_service	STRING
payment_status	STRING
is_flat_rate	BOOLEAN
total_delivered_price	NUMERIC
total_delivery_price	NUMERIC
total_payment_option_discount	STRING
total_coupons_amount	STRING
total_vendor_coupons_amount	STRING
total_off_invoice	NUMERIC
total_bill_back_deduction	NUMERIC
total_redemption_value	NUMERIC
total_tax_value	NUMERIC
total_price	NUMERIC
grand_total_price	STRING
grand_total_delivered_price	STRING
epallet_profit	NUMERIC
epallet_profit_percentage	STRING
net_to_bank	NUMERIC
customer	RECORD
vendor	RECORD
order_pallets	RECORD
fob_delivery_accessorials	STRING
shipping_delivery_accessorials	STRING
tags	RECORD

products

Purpose: This API is used to fetch the products associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
name	STRING
upc	STRING
brand_name	STRING
pack_size	STRING
vendor_name	STRING
customer_groups	STRING
last_updated_pricing_time_stamp	STRING
product_category	STRING
product_code	NUMERIC
last_updated	TIMESTAMP

vendors

Purpose: This API is used to fetch the vendors associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

id	Data Type
id	NUMERIC
image	STRING
email	STRING
contact_name	STRING
status	STRING
company_name	STRING
last_login	TIMESTAMP
company_email	STRING
title	STRING
fax	STRING
address	STRING
phone_number	STRING
company_type	STRING
billing_contact_name	STRING
billing_company_name	STRING
billing_company_email	STRING
billing_address	STRING
billing_phone_number	STRING
website	STRING
first_po_date	STRING
payment_overdue	STRING
subscription_plan	STRING
last_updated	TIMESTAMP

users

Purpose: This API is used to fetch the users associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
id	NUMERIC
email	STRING
company_name	STRING
is_active	BOOLEAN
email_verified	BOOLEAN
is_customer	BOOLEAN
is_vendor	BOOLEAN
customer_groups	STRING
last_updated	TIMESTAMP

customers

Purpose: This API is used to fetch the customers associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
id	NUMERIC
date_created	TIMESTAMP
contact_name	STRING
company_name	STRING
company_email	STRING
title	STRING
fax	STRING
address	STRING
status	STRING
phone_number	STRING
customer_groups	STRING
salesperson_email	STRING
is_active	BOOLEAN
email	STRING
need_validation	BOOLEAN
billing_contact_name	STRING
billing_company_name	STRING
billing_company_email	STRING
billing_address	STRING
billing_phone_number	STRING
last_login_datetime	STRING
last_updated	TIMESTAMP

customer_groups

Purpose: This API is used to fetch the customer_groups associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
name	STRING
has_discount	BOOLEAN
is_free_from_taxes	BOOLEAN
available_for_registration	BOOLEAN
assigned_customer	NUMERIC
assigned_products	NUMERIC
last_updated	TIMESTAMP

Table of Contents

Tables/APIs orders Fields products Fields vendors Fields users Fields customers Fields customer_groups Fields

Schema Information

Saras Pulse

Saras Daton

Saras IQ