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
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 |