Integrated APIs
Erply brands
Client code
Brand ID
Brand name
Erply (purchase) orders
Client code
Version
Product ID
Location ID
Qty on order
Year
Week
ISO Week
Erply priority groups ∑
Client code
PTY ID
PTY name
Erply product categories ∑
Client code
Category ID
Parent ID
Category name
Erply product groups
Client code
Group ID
Group name
Erply products
Client code
Product ID
Product name
Product type
Group ID
Category ID
Supplier ID
Brand ID
Priority ID
Option 1
Option 2
Default price
Default retail price
Default cost
Supplier name
Code
Code 2
Erply sales
Client code
Attendant name
Currency code
Customer email
Customer name
Sales date
Invoice #
Invoice type
Location ID
Location name
Brand ID
Product category ID
Product category
Product group ID
Product group
Product ID
Product name
Sales cost
Sales incl tax
Sales units
Sales excl Tax
Total discount
ISO Week
NOTE: Sales data only includes document types CASHINVOICE,INVOICE,CREDITINVOICE. Sales orders are not included.
Erply stock
Client code
Version
Product ID
Location ID
EOP Qty
EOP Cost
Last purchase
Last sold
Year
Week
ISO Week
Erply suppliers ∑
Client code
Supplier ID
Supplier name
Erply locations ∑
Client code
Location ID
Location name
City
State
Country
NOTES
ISO Week logic applies to time-based states such as inventory levels or purchase orders. By specifying ISO Week it is possible to retrieve point-in-time states of respoctive datastreams. Year and week are derived using the ISO week date standard. For any week the data represents the most recent known state for that week.
Datastreams marked with ∑ are also available as dynamic dimensions.