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(58)
Rules & Considerations(70)
validation
constraint
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | S | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1 | 1 | 1 | 1 | 1 | 1 | SAMP | SAMPLE | 1 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 1 | 1 | SAMPLE | SAM | SAM | 1.0000 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 1 | SAMP | 1.0000 | 1.0000 | 1 | SAMPLE | 1.0000 | SAMPLE | SAM | SAM | 1 | SAM | 1.0000 | SAM |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDRPK
- SAMPLE
- STORE_IDRPK
- 1
- AUTO_PRINTR
- S
- CREATE_DATER
- 2026-01-01
- CREATE_USERR
- SAMPLE
- ORIGIN_TYPER
- 1
- PRINTED_DATER
- 2026-01-01
- PRINTED_USERR
- SAMPLE
- TICKET_COUNTR
- 1
- TICKET_SEQUENCER
- 1
- TICKET_FORMAT_IDRPK
- 1
- TICKET_FORMAT_TYPER
- 1
- CLASS_ID
- 1
- GROUP_ID
- 1
- PRICE_UOM
- SAMP
- CLASS_NAME
- SAMPLE
- PRICE_TYPE
- 1
- PRINT_DATE
- 2026-01-01
- 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
- DEPARTMENT_ID
- 1
- SUBCLASS_NAME
- SAMPLE
- COUNTRY_OF_MFR
- SAM
- PRICE_CURRENCY
- SAM
- PRINT_QUANTITY
- 1.0000
- DEPARTMENT_NAME
- SAMPLE
- 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
- 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
Rule Validation Summary
- Source Rule Count
- 90
- Governed Rule Count
- 70