Tickets
In ScopeTechnical: TICKET | ID: OR-STO-TICKET-TICKET
Stores tickets.
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
Field Definitions(5)
Rules & Considerations(37)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDR | ORIGIN_TYPER | TICKET_FORMAT_IDR | GROUP_ID | AUTO_PRINT | PRINT_DATE | CREATE_DATE | CREATE_USER | UPDATE_DATE | UPDATE_USER | TICKET_COUNT | COUNTRY_OF_MFR | PRINT_QUANTITY | TICKET_SEQUENCE | GROUP_ID_EXTERNAL | OVERRIDE_PRICE_VALUE | AUTO_REFRESH_QUANTITY | OVERRIDE_PRICE_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 1 | S | 2026-01-01 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1 | SAM | 1.0000 | 1 | SAMPLE | 1.0000 | S | SAM |
| default | 3 | ALT-TICKET-002 | 1000000003 | 2 | 1000000003 | 1000000003 | N | 2026-01-03 | 2026-01-03 | Ticket-002-ALT | 2026-01-03 | 2026-01-02-ALT | 3 | Tic | 12.5000 | 3 | Ticket-002-ALT | 12.5000 | N | Tic |
| default | 5 | EDGE-TICKET-003 | 1000000005 | 3 | 1000000005 | 1000000005 | N | 2026-01-05 | 2026-01-05 | Ticket-003-EDGE | 2026-01-05 | 2026-01-03-EDGE | 5 | Tic | 14.0000 | 5 | Ticket-003-EDGE | 14.0000 | N | Tic |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- STORE_IDR
- 1
- ORIGIN_TYPER
- 1
- TICKET_FORMAT_IDR
- 1
- GROUP_ID
- 1
- AUTO_PRINT
- S
- PRINT_DATE
- 2026-01-01
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- TICKET_COUNT
- 1
- COUNTRY_OF_MFR
- SAM
- PRINT_QUANTITY
- 1.0000
- TICKET_SEQUENCE
- 1
- GROUP_ID_EXTERNAL
- SAMPLE
- OVERRIDE_PRICE_VALUE
- 1.0000
- AUTO_REFRESH_QUANTITY
- S
- OVERRIDE_PRICE_CURRENCY
- SAM
default
- IDRPK
- 3
- ITEM_IDR
- ALT-TICKET-002
- STORE_IDR
- 1000000003
- ORIGIN_TYPER
- 2
- TICKET_FORMAT_IDR
- 1000000003
- GROUP_ID
- 1000000003
- AUTO_PRINT
- N
- PRINT_DATE
- 2026-01-03
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Ticket-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- TICKET_COUNT
- 3
- COUNTRY_OF_MFR
- Tic
- PRINT_QUANTITY
- 12.5000
- TICKET_SEQUENCE
- 3
- GROUP_ID_EXTERNAL
- Ticket-002-ALT
- OVERRIDE_PRICE_VALUE
- 12.5000
- AUTO_REFRESH_QUANTITY
- N
- OVERRIDE_PRICE_CURRENCY
- Tic
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-TICKET-003
- STORE_IDR
- 1000000005
- ORIGIN_TYPER
- 3
- TICKET_FORMAT_IDR
- 1000000005
- GROUP_ID
- 1000000005
- AUTO_PRINT
- N
- PRINT_DATE
- 2026-01-05
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Ticket-003-EDGE
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- TICKET_COUNT
- 5
- COUNTRY_OF_MFR
- Tic
- PRINT_QUANTITY
- 14.0000
- TICKET_SEQUENCE
- 5
- GROUP_ID_EXTERNAL
- Ticket-003-EDGE
- OVERRIDE_PRICE_VALUE
- 14.0000
- AUTO_REFRESH_QUANTITY
- N
- OVERRIDE_PRICE_CURRENCY
- Tic
Rule Validation Summary
- Source Rule Count
- 57
- Governed Rule Count
- 37