Ticket History Data
In ScopeTechnical: TICKET_HISTORY | ID: OR-STO-TICKET_HISTORY-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- TICKET_HISTORY
Field Definitions(5)
Rules & Considerations(73)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDR | ORIGIN_TYPER | TICKET_FORMAT_IDR | CLASS_ID | GROUP_ID | PRICE_UOM | AUTO_PRINT | CLASS_NAME | PRICE_TYPE | PRINT_DATE | CREATE_DATE | CREATE_USER | DIFF_TYPE_1 | DIFF_TYPE_2 | DIFF_TYPE_3 | DIFF_TYPE_4 | PRICE_VALUE | PRIMARY_UPC | SUBCLASS_ID | PRINTED_DATE | PRINTED_USER | TICKET_COUNT | DEPARTMENT_ID | SUBCLASS_NAME | COUNTRY_OF_MFR | PRICE_CURRENCY | PRINT_QUANTITY | DEPARTMENT_NAME | TICKET_SEQUENCE | 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 | TICKET_FORMAT_TYPE | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMP | S | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1 | 1 | SAMPLE | SAM | SAM | 1.0000 | SAMPLE | 1 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | 1 | SAMP | 1.0000 | 1.0000 | 1 | SAMPLE | 1.0000 | SAMPLE | SAM | SAM | 1 | SAM | 1.0000 | SAM |
| default | 3 | ALT-TICKET_HIS-002 | 1000000003 | 2 | 1000000003 | 1000000003 | 1000000003 | Tick | N | Womenswear | 3 | 2026-01-03 | 2026-01-03 | Ticket History-002-ALT | Ticket His | Ticket His | Ticket His | Ticket His | 12.5000 | Ticket History-002-ALT | 1000000003 | 2026-01-03 | Ticket History-002-ALT | 3 | 1000000003 | Fashion Range | Tic | Tic | 12.5000 | Ticket History Secondary | 3 | Ticket History: Alternate source profile | Ticket History-002-ALT | 2026-01-03 | 2026-01-03 | Ticket History: Alternate source profile | Ticket History-002-ALT | Ticket History-002-ALT | Ticket History-002-ALT | Ticket History-002-ALT | Ticket History-002-ALT | Ticket History-002-ALT | 3 | 12.5000 | 3 | Tick | 12.5000 | 12.5000 | 1000000003 | Ticket History-002-ALT | 12.5000 | Ticket History-002-ALT | Tic | Tic | 3 | Tic | 12.5000 | Tic |
| default | 5 | EDGE-TICKET_HIS-003 | 1000000005 | 3 | 1000000005 | 1000000005 | 1000000005 | Tick | N | Kidswear | 5 | 2026-01-05 | 2026-01-05 | Ticket History-003-EDGE | Ticket His | Ticket His | Ticket His | Ticket His | 14.0000 | Ticket History-003-EDGE | 1000000005 | 2026-01-05 | Ticket History-003-EDGE | 5 | 1000000005 | Value Range | Tic | Tic | 14.0000 | Ticket History Core | 5 | — | Ticket History-003-EDGE | 2026-01-05 | 2026-01-05 | — | Ticket History-003-EDGE | — | — | — | — | Ticket History-003-EDGE | 5 | 14.0000 | 5 | Tick | 14.0000 | 14.0000 | 1000000005 | — | 14.0000 | — | Tic | Tic | 5 | Tic | 14.0000 | Tic |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- STORE_IDR
- 1
- ORIGIN_TYPER
- 1
- TICKET_FORMAT_IDR
- 1
- CLASS_ID
- 1
- GROUP_ID
- 1
- PRICE_UOM
- SAMP
- AUTO_PRINT
- S
- CLASS_NAME
- SAMPLE
- PRICE_TYPE
- 1
- PRINT_DATE
- 2026-01-01
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- DIFF_TYPE_1
- SAMPLE
- DIFF_TYPE_2
- SAMPLE
- DIFF_TYPE_3
- SAMPLE
- DIFF_TYPE_4
- SAMPLE
- PRICE_VALUE
- 1.0000
- PRIMARY_UPC
- SAMPLE
- SUBCLASS_ID
- 1
- PRINTED_DATE
- 2026-01-01
- PRINTED_USER
- SAMPLE
- TICKET_COUNT
- 1
- DEPARTMENT_ID
- 1
- SUBCLASS_NAME
- SAMPLE
- COUNTRY_OF_MFR
- SAM
- PRICE_CURRENCY
- SAM
- PRINT_QUANTITY
- 1.0000
- DEPARTMENT_NAME
- SAMPLE
- TICKET_SEQUENCE
- 1
- LONG_DESCRIPTION
- SAMPLE
- GROUP_ID_EXTERNAL
- SAMPLE
- PRICE_ACTIVE_DATE
- 2026-01-01
- PRICE_EXPIRE_DATE
- 2026-01-01
- SHORT_DESCRIPTION
- SAMPLE
- TICKET_FORMAT_REF
- SAMPLE
- DIFF_DESCRIPTION_1
- SAMPLE
- DIFF_DESCRIPTION_2
- SAMPLE
- DIFF_DESCRIPTION_3
- SAMPLE
- DIFF_DESCRIPTION_4
- SAMPLE
- TICKET_FORMAT_DESC
- SAMPLE
- TICKET_FORMAT_TYPE
- 1
- MULTI_UNIT_QUANTITY
- 1.0000
- PREVIOUS_PRICE_TYPE
- 1
- MULTI_UNIT_PRICE_UOM
- SAMP
- OVERRIDE_PRICE_VALUE
- 1.0000
- PREVIOUS_PRICE_VALUE
- 1.0000
- TICKET_FORMAT_ZPL_ID
- 1
- LONG_DESCRIPTION_LANG
- SAMPLE
- MULTI_UNIT_PRICE_VALUE
- 1.0000
- SHORT_DESCRIPTION_LANG
- SAMPLE
- OVERRIDE_PRICE_CURRENCY
- SAM
- PREVIOUS_PRICE_CURRENCY
- SAM
- LOWEST_MONTHLY_PRICE_TYPE
- 1
- MULTI_UNIT_PRICE_CURRENCY
- SAM
- LOWEST_MONTHLY_PRICE_VALUE
- 1.0000
- LOWEST_MONTHLY_PRICE_CURRENCY
- SAM
default
- IDRPK
- 3
- ITEM_IDR
- ALT-TICKET_HIS-002
- STORE_IDR
- 1000000003
- ORIGIN_TYPER
- 2
- TICKET_FORMAT_IDR
- 1000000003
- CLASS_ID
- 1000000003
- GROUP_ID
- 1000000003
- PRICE_UOM
- Tick
- AUTO_PRINT
- N
- CLASS_NAME
- Womenswear
- PRICE_TYPE
- 3
- PRINT_DATE
- 2026-01-03
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Ticket History-002-ALT
- DIFF_TYPE_1
- Ticket His
- DIFF_TYPE_2
- Ticket His
- DIFF_TYPE_3
- Ticket His
- DIFF_TYPE_4
- Ticket His
- PRICE_VALUE
- 12.5000
- PRIMARY_UPC
- Ticket History-002-ALT
- SUBCLASS_ID
- 1000000003
- PRINTED_DATE
- 2026-01-03
- PRINTED_USER
- Ticket History-002-ALT
- TICKET_COUNT
- 3
- DEPARTMENT_ID
- 1000000003
- SUBCLASS_NAME
- Fashion Range
- COUNTRY_OF_MFR
- Tic
- PRICE_CURRENCY
- Tic
- PRINT_QUANTITY
- 12.5000
- DEPARTMENT_NAME
- Ticket History Secondary
- TICKET_SEQUENCE
- 3
- LONG_DESCRIPTION
- Ticket History: Alternate source profile
- GROUP_ID_EXTERNAL
- Ticket History-002-ALT
- PRICE_ACTIVE_DATE
- 2026-01-03
- PRICE_EXPIRE_DATE
- 2026-01-03
- SHORT_DESCRIPTION
- Ticket History: Alternate source profile
- TICKET_FORMAT_REF
- Ticket History-002-ALT
- DIFF_DESCRIPTION_1
- Ticket History-002-ALT
- DIFF_DESCRIPTION_2
- Ticket History-002-ALT
- DIFF_DESCRIPTION_3
- Ticket History-002-ALT
- DIFF_DESCRIPTION_4
- Ticket History-002-ALT
- TICKET_FORMAT_DESC
- Ticket History-002-ALT
- TICKET_FORMAT_TYPE
- 3
- MULTI_UNIT_QUANTITY
- 12.5000
- PREVIOUS_PRICE_TYPE
- 3
- MULTI_UNIT_PRICE_UOM
- Tick
- OVERRIDE_PRICE_VALUE
- 12.5000
- PREVIOUS_PRICE_VALUE
- 12.5000
- TICKET_FORMAT_ZPL_ID
- 1000000003
- LONG_DESCRIPTION_LANG
- Ticket History-002-ALT
- MULTI_UNIT_PRICE_VALUE
- 12.5000
- SHORT_DESCRIPTION_LANG
- Ticket History-002-ALT
- OVERRIDE_PRICE_CURRENCY
- Tic
- PREVIOUS_PRICE_CURRENCY
- Tic
- LOWEST_MONTHLY_PRICE_TYPE
- 3
- MULTI_UNIT_PRICE_CURRENCY
- Tic
- LOWEST_MONTHLY_PRICE_VALUE
- 12.5000
- LOWEST_MONTHLY_PRICE_CURRENCY
- Tic
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-TICKET_HIS-003
- STORE_IDR
- 1000000005
- ORIGIN_TYPER
- 3
- TICKET_FORMAT_IDR
- 1000000005
- CLASS_ID
- 1000000005
- GROUP_ID
- 1000000005
- PRICE_UOM
- Tick
- AUTO_PRINT
- N
- CLASS_NAME
- Kidswear
- PRICE_TYPE
- 5
- PRINT_DATE
- 2026-01-05
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Ticket History-003-EDGE
- DIFF_TYPE_1
- Ticket His
- DIFF_TYPE_2
- Ticket His
- DIFF_TYPE_3
- Ticket His
- DIFF_TYPE_4
- Ticket His
- PRICE_VALUE
- 14.0000
- PRIMARY_UPC
- Ticket History-003-EDGE
- SUBCLASS_ID
- 1000000005
- PRINTED_DATE
- 2026-01-05
- PRINTED_USER
- Ticket History-003-EDGE
- TICKET_COUNT
- 5
- DEPARTMENT_ID
- 1000000005
- SUBCLASS_NAME
- Value Range
- COUNTRY_OF_MFR
- Tic
- PRICE_CURRENCY
- Tic
- PRINT_QUANTITY
- 14.0000
- DEPARTMENT_NAME
- Ticket History Core
- TICKET_SEQUENCE
- 5
- LONG_DESCRIPTION
- —
- GROUP_ID_EXTERNAL
- Ticket History-003-EDGE
- PRICE_ACTIVE_DATE
- 2026-01-05
- PRICE_EXPIRE_DATE
- 2026-01-05
- SHORT_DESCRIPTION
- —
- TICKET_FORMAT_REF
- Ticket History-003-EDGE
- DIFF_DESCRIPTION_1
- —
- DIFF_DESCRIPTION_2
- —
- DIFF_DESCRIPTION_3
- —
- DIFF_DESCRIPTION_4
- —
- TICKET_FORMAT_DESC
- Ticket History-003-EDGE
- TICKET_FORMAT_TYPE
- 5
- MULTI_UNIT_QUANTITY
- 14.0000
- PREVIOUS_PRICE_TYPE
- 5
- MULTI_UNIT_PRICE_UOM
- Tick
- OVERRIDE_PRICE_VALUE
- 14.0000
- PREVIOUS_PRICE_VALUE
- 14.0000
- TICKET_FORMAT_ZPL_ID
- 1000000005
- LONG_DESCRIPTION_LANG
- —
- MULTI_UNIT_PRICE_VALUE
- 14.0000
- SHORT_DESCRIPTION_LANG
- —
- OVERRIDE_PRICE_CURRENCY
- Tic
- PREVIOUS_PRICE_CURRENCY
- Tic
- LOWEST_MONTHLY_PRICE_TYPE
- 5
- MULTI_UNIT_PRICE_CURRENCY
- Tic
- LOWEST_MONTHLY_PRICE_VALUE
- 14.0000
- LOWEST_MONTHLY_PRICE_CURRENCY
- Tic
Rule Validation Summary
- Source Rule Count
- 93
- Governed Rule Count
- 73