ItemsEx: Exact Online Items
insert update per partition XML
- Catalogus:
ExactOnlineXML - Schema:
XML - Primaire sleutels:
code_attr - Label: Items
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Je kunt gegevens ophalen en wijzigen met insert en update.
Samenvatting
The ExactOnlineXML table "Items" also contains the values of additional fields defined on Items in columns such as "ITEMEXTRAFIELDS_EXTRAFIELD1", which are also known as "Extra fields" or "Free fields". The REST API "ItemExtraField" is not supported since it requires one call for each Item which would quickly deplete the allowance of API requests. The REST API "Items" has no values for the free fields currently.
Additional where-clause columns supported:
- division
- downloadid
- code
- assortmentcode
- topselection
- itemstatus
- ispurchase
- isstock
- issales
- ismake
- isordercontroled
- istime
- iswebshop
- isserial
- isbatch
API-bron
- XML-service:
Items - XML-onderwerp:
Items - XML-pad:
/
Parameters
| Name | Datatype | Required | Default | Documentation |
|---|---|---|---|---|
division |
int32 |
Company code. | ||
Params_ |
varchar2 |
Code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Class code. | ||
Params_ |
varchar2 |
Assortment code. | ||
Params_ |
varchar2 |
Data subscription token. | ||
Params_ |
boolean |
Property: batch. | ||
Params_ |
boolean |
Property: make. | ||
Params_ |
boolean |
Property: order controlled. | ||
Params_ |
boolean |
Property: purchase. | ||
Params_ |
boolean |
Property: sales. | ||
Params_ |
boolean |
Property: serial number. | ||
Params_ |
boolean |
Property: stock. | ||
Params_ |
boolean |
Property: time. | ||
Params_ |
boolean |
Property: web shop. | ||
Params_ |
varchar2 |
Multi-select; 1: active, 2: future, 4: inactive. | ||
Params_ |
int32 |
Maximum number to retrieve. |
Tabelkolommen
De kolommen van de tabel ItemsEx worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: