Sales: Horeko Sales
read only REST
- Catalog:
Horeko - Schema:
Sale - Label: Sales
Retrieves a list of sales that match the search parameters.
Can only retrieve data.
API Source
- Endpoint:
/v4/sales/sales - Operation:
get /v4/sales/sales
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
end |
`` | 12/31/2999 00:00:00 | ||
plu |
`` | article number | ||
pos |
`` | cash register id | ||
start |
`` | 01/01/2020 00:00:00 |
Table Columns
The columns of the table Sales are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Article_ |
varchar2 |
itgen_horeko_article_id | |||
Article_ |
varchar2 |
itgen_horeko_article_name | |||
Article_ |
varchar2 |
itgen_horeko_article_plu | |||
Date |
datetime |
Date | |||
Discount |
double |
Discount | |||
MenuId |
varchar2 |
Menu ID | |||
Pos |
int32 |
POS System ID | |||
Quantity |
double |
Quantity | |||
Sales |
double |
Salesprice | |||
Store_ |
int32 |
itgen_horeko_store_branch_id | |||
Store_ |
varchar2 |
itgen_horeko_store_branch_name | |||
Store_ |
int32 |
itgen_horeko_store_id | |||
Store_ |
varchar2 |
itgen_horeko_store_name | |||
Ticket |
varchar2 |
Ticket ID | |||
Ticket |
int32 |
Ticket Type | |||
Turnover |
int32 |
itgen_horeko_turnovergroup_id | |||
Turnover |
varchar2 |
itgen_horeko_turnovergroup_name |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: