Ticket History
In ScopeTechnical: TICKET_HISTORY | ID: OR-SIOCS-TICKET_HISTORY
Stores ticket history data.
See how this object fits into Store Operations
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- TICKET_HISTORY
Field Definitions(58)
Rules & Considerations(138)
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDRPK | STORE_IDRPK | AUTO_PRINTR | CREATE_DATER | CREATE_USERR | ORIGIN_TYPER | PRINTED_DATER | PRINTED_USERR | TICKET_COUNTR | TICKET_SEQUENCER | TICKET_FORMAT_IDRPK | TICKET_FORMAT_TYPER | CLASS_ID | GROUP_ID | PRICE_UOM | CLASS_NAME | PRICE_TYPE | PRINT_DATE | DIFF_TYPE_1 | DIFF_TYPE_2 | DIFF_TYPE_3 | DIFF_TYPE_4 | PRICE_VALUE | PRIMARY_UPC | SUBCLASS_ID | DEPARTMENT_ID | SUBCLASS_NAME | COUNTRY_OF_MFR | PRICE_CURRENCY | PRINT_QUANTITY | DEPARTMENT_NAME | LONG_DESCRIPTION | GROUP_ID_EXTERNAL | PRICE_ACTIVE_DATE | PRICE_EXPIRE_DATE | SHORT_DESCRIPTION | TICKET_FORMAT_REF | DIFF_DESCRIPTION_1 | DIFF_DESCRIPTION_2 | DIFF_DESCRIPTION_3 | DIFF_DESCRIPTION_4 | TICKET_FORMAT_DESC | MULTI_UNIT_QUANTITY | PREVIOUS_PRICE_TYPE | MULTI_UNIT_PRICE_UOM | OVERRIDE_PRICE_VALUE | PREVIOUS_PRICE_VALUE | TICKET_FORMAT_ZPL_ID | LONG_DESCRIPTION_LANG | MULTI_UNIT_PRICE_VALUE | SHORT_DESCRIPTION_LANG | OVERRIDE_PRICE_CURRENCY | PREVIOUS_PRICE_CURRENCY | LOWEST_MONTHLY_PRICE_TYPE | MULTI_UNIT_PRICE_CURRENCY | LOWEST_MONTHLY_PRICE_VALUE | LOWEST_MONTHLY_PRICE_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | STD-TICKET_HIS-001 | 1000000001 | N | 2026-01-01 | Ticket History-001 | 1 | 2026-01-01 | Ticket History-001 | 001 | 001 | 1000000001 | 0001 | 1000000001 | 1000000001 | Ticket History-001 | Menswear | 001 | 2026-01-01 | Ticket History-001 | Ticket History-001 | Ticket History-001 | Ticket History-001 | 11.0000 | Ticket History-001 | 1000000001 | 1000000001 | Core Range | Ticket History-001 | Ticket History-001 | 11.0000 | Ticket History Primary | Ticket History: Baseline migration row | Ticket History-001 | 2026-01-01 | 2026-01-01 | Ticket History: Baseline migration row | Ticket History-001 | Ticket History-001 | Ticket History-001 | Ticket History-001 | Ticket History-001 | Ticket History-001 | 11.0000 | 001 | Ticket History-001 | 11.0000 | 11.0000 | 1000000001 | Ticket History-001 | 11.0000 | Ticket History-001 | Ticket History-001 | Ticket History-001 | 001 | Ticket History-001 | 11.0000 | Ticket History-001 |
default
- IDRPK
- 1
- ITEM_IDRPK
- STD-TICKET_HIS-001
- STORE_IDRPK
- 1000000001
- AUTO_PRINTR
- N
- CREATE_DATER
- 2026-01-01
- CREATE_USERR
- Ticket History-001
- ORIGIN_TYPER
- 1
- PRINTED_DATER
- 2026-01-01
- PRINTED_USERR
- Ticket History-001
- TICKET_COUNTR
- 001
- TICKET_SEQUENCER
- 001
- TICKET_FORMAT_IDRPK
- 1000000001
- TICKET_FORMAT_TYPER
- 0001
- CLASS_ID
- 1000000001
- GROUP_ID
- 1000000001
- PRICE_UOM
- Ticket History-001
- CLASS_NAME
- Menswear
- PRICE_TYPE
- 001
- PRINT_DATE
- 2026-01-01
- DIFF_TYPE_1
- Ticket History-001
- DIFF_TYPE_2
- Ticket History-001
- DIFF_TYPE_3
- Ticket History-001
- DIFF_TYPE_4
- Ticket History-001
- PRICE_VALUE
- 11.0000
- PRIMARY_UPC
- Ticket History-001
- SUBCLASS_ID
- 1000000001
- DEPARTMENT_ID
- 1000000001
- SUBCLASS_NAME
- Core Range
- COUNTRY_OF_MFR
- Ticket History-001
- PRICE_CURRENCY
- Ticket History-001
- PRINT_QUANTITY
- 11.0000
- DEPARTMENT_NAME
- Ticket History Primary
- LONG_DESCRIPTION
- Ticket History: Baseline migration row
- GROUP_ID_EXTERNAL
- Ticket History-001
- PRICE_ACTIVE_DATE
- 2026-01-01
- PRICE_EXPIRE_DATE
- 2026-01-01
- SHORT_DESCRIPTION
- Ticket History: Baseline migration row
- TICKET_FORMAT_REF
- Ticket History-001
- DIFF_DESCRIPTION_1
- Ticket History-001
- DIFF_DESCRIPTION_2
- Ticket History-001
- DIFF_DESCRIPTION_3
- Ticket History-001
- DIFF_DESCRIPTION_4
- Ticket History-001
- TICKET_FORMAT_DESC
- Ticket History-001
- MULTI_UNIT_QUANTITY
- 11.0000
- PREVIOUS_PRICE_TYPE
- 001
- MULTI_UNIT_PRICE_UOM
- Ticket History-001
- OVERRIDE_PRICE_VALUE
- 11.0000
- PREVIOUS_PRICE_VALUE
- 11.0000
- TICKET_FORMAT_ZPL_ID
- 1000000001
- LONG_DESCRIPTION_LANG
- Ticket History-001
- MULTI_UNIT_PRICE_VALUE
- 11.0000
- SHORT_DESCRIPTION_LANG
- Ticket History-001
- OVERRIDE_PRICE_CURRENCY
- Ticket History-001
- PREVIOUS_PRICE_CURRENCY
- Ticket History-001
- LOWEST_MONTHLY_PRICE_TYPE
- 001
- MULTI_UNIT_PRICE_CURRENCY
- Ticket History-001
- LOWEST_MONTHLY_PRICE_VALUE
- 11.0000
- LOWEST_MONTHLY_PRICE_CURRENCY
- Ticket History-001