# SubscriptionItems: Exact Online Subscription Items
## Documentation:
Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- divisionchr(13) || chr(10) || chr(13) || chr(10)- number_fromchr(13) || chr(10) || chr(13) || chr(10)- number_tochr(13) || chr(10) || chr(13) || chr(10)- subscriptiontypechr(13) || chr(10) || chr(13) || chr(10)- headerstatuschr(13) || chr(10) || chr(13) || chr(10)- linestatuschr(13) || chr(10) || chr(13) || chr(10)- fromdate_fromchr(13) || chr(10) || chr(13) || chr(10)- fromdate_tochr(13) || chr(10) || chr(13) || chr(10)- todate_fromchr(13) || chr(10) || chr(13) || chr(10)- todate_tochr(13) || chr(10) || chr(13) || chr(10)- subscriptionrestrictionschr(13) || chr(10) || chr(13) || chr(10)- details (1 )
- Catalog: `ExactOnlineXML`
- Schema: `XML`
- Label: Subscription Items
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
- number_from
- number_to
- subscriptiontype
- headerstatus
- linestatus
- fromdate_from
- fromdate_to
- todate_from
- todate_to
- subscriptionrestrictions
- details (1 )
## 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.