# ItemAccounts: Exact Online Item Suppliers
## Documentation:
Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- divisionchr(13) || chr(10) || chr(13) || chr(10)- downloadidchr(13) || chr(10) || chr(13) || chr(10)- codechr(13) || chr(10) || chr(13) || chr(10)- assortmentcodechr(13) || chr(10) || chr(13) || chr(10)- topselectionchr(13) || chr(10) || chr(13) || chr(10)- itemstatuschr(13) || chr(10) || chr(13) || chr(10)- ispurchasechr(13) || chr(10) || chr(13) || chr(10)- isstockchr(13) || chr(10) || chr(13) || chr(10)- issaleschr(13) || chr(10) || chr(13) || chr(10)- ismakechr(13) || chr(10) || chr(13) || chr(10)- isordercontroledchr(13) || chr(10) || chr(13) || chr(10)- istimechr(13) || chr(10) || chr(13) || chr(10)- iswebshopchr(13) || chr(10) || chr(13) || chr(10)- isserialchr(13) || chr(10) || chr(13) || chr(10)- isbatch
- Catalog: `ExactOnlineXML`
- Schema: `XML`
- Label: Item Suppliers
The data in this table is partitioned per value of the `Division` column.
- Retrieve: True
- Insert: True
- Update: True
- Delete: False
- Filters on API Server: division
- downloadid
- code
- assortmentcode
- topselection
- itemstatus
- ispurchase
- isstock
- issales
- ismake
- isordercontroled
- istime
- iswebshop
- isserial
- isbatch
## View Columns
This table has too many columns to be included. Please enter the table name in Invantive Query Tool and press F4 (Describe) to get the column list.