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.