ITEM — Oracle Transportation Management Reference

Item records containing product and material master data.

This page documents the ITEM table in Oracle Transportation Management (OTM) -- columns, primary key, incremental cursor, and the exact REST API endpoints used to extract it. This is one of 18 OTM tables that Supaflow's Oracle Transportation Management connector syncs natively into Snowflake, Databricks, BigQuery, Redshift, or Postgres.

Overview

Attribute	Value
OTM export table name	`ITEM`
OTM metadata resource name	`items`
Primary key	`ITEM_GID`
Incremental cursor field	`UPDATE_DATE`
Category	Core

OTM REST API endpoints

OTM exposes every table through the logistics REST API. Paths depend on the authentication method you use.

Export API (fetch rows)

POST one of the following URLs, depending on your OTM authentication mode:

OAuth 2.0 (IDCS): https://{your-otm-host}/logisticsRestApi/data/v1/exportRequests/
Basic Auth: https://{your-otm-host}/logisticsRestApi/data-int/v1/exportRequests/

Example request body for ITEM:

{
  "schema": "PRIMARY",
  "contentType": "text/plain",
  "tables": {
    "items": [
      { "tableName": "ITEM", "partSize": 5000 }
    ]
  }
}

To pull only rows updated after a given timestamp (the recommended pattern for incremental sync), add a rangeAfter block:

{
  "schema": "PRIMARY",
  "contentType": "text/plain",
  "rangeAfter": { "value": "2026-04-01T00:00:00Z" },
  "tables": {
    "items": [
      { "tableName": "ITEM", "partSize": 5000 }
    ]
  }
}

The response is a CSV payload with the table name on line 1, column headers on line 2, and data rows starting on line 3.

Metadata catalog (fetch schema)

GET the schema for ITEM:

OAuth 2.0: https://{your-otm-host}/logisticsRestApi/resources/v2/metadata-catalog/items
Basic Auth: https://{your-otm-host}/logisticsRestApi/resources-int/v2/metadata-catalog/items

note

The OTM metadata-catalog endpoint returns HTTP 400 for several tables. If you receive a 400 here, fall back to data-driven type inference by sampling rows from the Export API. See the OTM integration guide for the full pattern.

Columns

Column	Type	Nullable	PK	Foreign key
`ITEM_GID`	`VARCHAR2(101)`		Yes
`ITEM_XID`	`VARCHAR2(50)`
`ITEM_NAME`	`VARCHAR2(240)`	Yes
`COMMODITY_GID`	`VARCHAR2(101)`	Yes		`COMMODITY`
`NMFC_ARTICLE_GID`	`VARCHAR2(101)`	Yes		`NMFC_ARTICLE`
`NMFC_CLASS_GID`	`VARCHAR2(101)`	Yes		`NMFC_CLASS`
`STCC_GID`	`VARCHAR2(101)`	Yes		`STCC`
`HTS_GID`	`VARCHAR2(101)`	Yes		`HTS`
`SITC_GID`	`VARCHAR2(101)`	Yes		`SITC`
`DESCRIPTION`	`VARCHAR2(500)`	Yes
`USER_DEFINED_COMMODITY_GID`	`VARCHAR2(101)`	Yes		`USER_DEFINED_COMMODITY`
`UDC_CLASSIFICATION_LIST_GID`	`VARCHAR2(101)`	Yes		`UDC_CLASSIFICATION_LIST`
`BRAND_NAME`	`VARCHAR2(101)`	Yes
`EFFECTIVE_DATE`	`DATE`	Yes
`EXPIRATION_DATE`	`DATE`	Yes
`MANUFACTURED_COUNTRY_CODE_GID`	`VARCHAR2(101)`	Yes		`COUNTRY_CODE`
`IS_DRAWBACK`	`VARCHAR2(1)` Y/N
`IATA_SCR_CODE_GID`	`VARCHAR2(101)`	Yes		`IATA_SCR_CODE`
`MARKED_FOR_PURGE`	`VARCHAR2(1)` Y/N	Yes
`DOMAIN_NAME`	`VARCHAR2(50)`
`INSERT_USER`	`VARCHAR2(128)`
`INSERT_DATE`	`DATE`
`UPDATE_USER`	`VARCHAR2(128)`	Yes
`UPDATE_DATE`	`DATE`	Yes
`UNIT_OF_MEASURE`	`VARCHAR2(20)`	Yes
`PRICE_PER_UNIT`	`NUMBER()`	Yes
`PRICE_PER_UNIT_BASE`	`NUMBER()`	Yes
`PRICE_PER_UNIT_CURRENCY_GID`	`VARCHAR2(101)`	Yes		`CURRENCY`
`IS_TEMPLATE`	`VARCHAR2(1)` Y/N
`ATTRIBUTE1`	`VARCHAR2(150)`	Yes
`ATTRIBUTE2`	`VARCHAR2(150)`	Yes
`ATTRIBUTE3`	`VARCHAR2(150)`	Yes
`ATTRIBUTE4`	`VARCHAR2(150)`	Yes
`ATTRIBUTE5`	`VARCHAR2(150)`	Yes
`ATTRIBUTE6`	`VARCHAR2(150)`	Yes
`ATTRIBUTE7`	`VARCHAR2(150)`	Yes
`ATTRIBUTE8`	`VARCHAR2(150)`	Yes
`ATTRIBUTE9`	`VARCHAR2(150)`	Yes
`ATTRIBUTE10`	`VARCHAR2(150)`	Yes
`ATTRIBUTE11`	`VARCHAR2(150)`	Yes
`ATTRIBUTE12`	`VARCHAR2(150)`	Yes
`ATTRIBUTE13`	`VARCHAR2(150)`	Yes
`ATTRIBUTE14`	`VARCHAR2(150)`	Yes
`ATTRIBUTE15`	`VARCHAR2(150)`	Yes
`ATTRIBUTE16`	`VARCHAR2(150)`	Yes
`ATTRIBUTE17`	`VARCHAR2(150)`	Yes
`ATTRIBUTE18`	`VARCHAR2(150)`	Yes
`ATTRIBUTE19`	`VARCHAR2(150)`	Yes
`ATTRIBUTE20`	`VARCHAR2(150)`	Yes
`ATTRIBUTE_NUMBER1`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER2`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER3`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER4`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER5`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER6`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER7`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER8`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER9`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER10`	`NUMBER()`	Yes
`ATTRIBUTE_DATE1`	`DATE`	Yes
`ATTRIBUTE_DATE2`	`DATE`	Yes
`ATTRIBUTE_DATE3`	`DATE`	Yes
`ATTRIBUTE_DATE4`	`DATE`	Yes
`ATTRIBUTE_DATE5`	`DATE`	Yes
`ATTRIBUTE_DATE6`	`DATE`	Yes
`ATTRIBUTE_DATE7`	`DATE`	Yes
`ATTRIBUTE_DATE8`	`DATE`	Yes
`ATTRIBUTE_DATE9`	`DATE`	Yes
`ATTRIBUTE_DATE10`	`DATE`	Yes
`INDICATOR`	`VARCHAR2(1)`	Yes
`USER_DEFINED1_ICON_GID`	`VARCHAR2(101)`	Yes		`ICON`
`USER_DEFINED2_ICON_GID`	`VARCHAR2(101)`	Yes		`ICON`
`USER_DEFINED3_ICON_GID`	`VARCHAR2(101)`	Yes		`ICON`
`USER_DEFINED4_ICON_GID`	`VARCHAR2(101)`	Yes		`ICON`
`USER_DEFINED5_ICON_GID`	`VARCHAR2(101)`	Yes		`ICON`
`PRIORITY`	`NUMBER` PRIORITY BETWEEN 1	Yes
`ITEM_TYPE_GID`	`VARCHAR2(101)`	Yes		`ITEM_TYPE`
`COUNTRY_OF_ORIGIN_GID`	`VARCHAR2(101)`	Yes		`COUNTRY_CODE`
`ITEM_TEMPLATE_GID`	`VARCHAR2(101)`	Yes
`PROD_CLASS_TEMPLATE_GID`	`VARCHAR2(101)`	Yes
`ATTRIBUTE_DATE11`	`DATE`	Yes
`ATTRIBUTE_DATE12`	`DATE`	Yes
`ATTRIBUTE_DATE13`	`DATE`	Yes
`ATTRIBUTE_DATE14`	`DATE`	Yes
`ATTRIBUTE_DATE15`	`DATE`	Yes
`ATTRIBUTE_DATE16`	`DATE`	Yes
`ATTRIBUTE_DATE17`	`DATE`	Yes
`ATTRIBUTE_DATE18`	`DATE`	Yes
`ATTRIBUTE_DATE19`	`DATE`	Yes
`ATTRIBUTE_DATE20`	`DATE`	Yes
`ATTRIBUTE_NUMBER11`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER12`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER13`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER14`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER15`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER16`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER17`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER18`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER19`	`NUMBER()`	Yes
`ATTRIBUTE_NUMBER20`	`NUMBER()`	Yes
`WHOLLY_ORIGINATING`	`VARCHAR2(1)` Y/N

Column list source

The column list above is extracted from Oracle's OTM data dictionary included with the February 2025 release snapshot of this connector. Oracle publishes an updated dictionary with every Transportation and Global Trade Management release; for the current version, consult Oracle's Transportation and Global Trade Management documentation.

Incremental sync

The ITEM table supports incremental sync via the UPDATE_DATE cursor. Supaflow's connector handles:

Server-side clock skew -- measured once from OTM's RFC 1123 Date header and applied to every cursor comparison.
Late-arriving updates -- configurable lookback window (recommended 300-600 seconds in production) re-scans the tail of the previous window.
Identical-timestamp batches -- tracks record count at the maximum cursor timestamp so batch updates that stamp thousands of rows with the same UPDATE_DATE don't cause missed or duplicated rows.

Full pattern: The Complete Guide to Oracle Transportation Management Integration.

Sync `ITEM` with Supaflow

Supaflow's Oracle Transportation Management connector syncs ITEM -- along with 17 other OTM tables -- into your cloud data warehouse with:

Sync and async (Object Storage PAR) export modes
Proactive OAuth token refresh (60-second safety margin on IDCS tokens)
Composite primary key preservation for tables with multi-field keys
Automatic handling of the five OTM-specific data quirks (metadata 400s, "0" temporal sentinels, Z-suffixed date fields, 1 MB sync-mode truncation, _TEXT / _COMMENT column type overrides)
Predictable connector-based pricing -- not per-row, not per MAR

Next steps:

Book a 15-minute demo to see the OTM connector against a live instance
Set up the OTM source in your Supaflow workspace
Read the full OTM integration guide

Overview​

OTM REST API endpoints​

Export API (fetch rows)​

Metadata catalog (fetch schema)​

Columns​

Incremental sync​

Sync ITEM with Supaflow​