Ticket Request
In ScopeTechnical: TICKET_REQUEST | ID: OR-STO-TICKET_REQUEST-TICKET_REQUEST
This table will be used to communicate to the batch program which prints tickets. This table is used to communicate the types of tickets which need to be printed and...
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_REQUEST
Field Definitions(5)
Rules & Considerations(29)
constraint
validation
Sample Load Data(4)
| _scenario | QTYR | ITEMR | LOCATIONR | LOC_TYPER | TICKET_TYPE_IDR | ID | ORDER_NO | MULTI_UNITS | UNIT_RETAIL | LAST_UPDATE_ID | CREATE_DATETIME | PRICE_CHANGE_ID | PRINT_ONLINE_IND | COUNTRY_OF_ORIGIN | MULTI_UNIT_RETAIL | LAST_UPDATE_DATETIME | PRICE_CHANGE_EFF_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | SAMPLE | 1 | S | SAMP | 1 | 1 | 1.0000 | 1.0000 | SAMPLE | 2026-01-01 | 1 | S | SAM | 1.0000 | 2026-01-01 | 2026-01-01 |
| default | 12.5000 | Ticket Request-002-ALT | 3 | T | ALT- | 3 | 4 | 12.5000 | 12.5000 | MDM_USER | 2026-01-03 | 1000000003 | T | Tic | 12.5000 | 2026-01-03 | 2026-01-03 |
| default | 14.0000 | Ticket Request-003-EDGE | 5 | T | EDGE | 5 | 6 | 14.0000 | 14.0000 | BATCH_USER | 2026-01-05 | 1000000005 | T | Tic | 14.0000 | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- QTYR
- 1.0000
- ITEMR
- SAMPLE
- LOCATIONR
- 1
- LOC_TYPER
- S
- TICKET_TYPE_IDR
- SAMP
- ID
- 1
- ORDER_NO
- 1
- MULTI_UNITS
- 1.0000
- UNIT_RETAIL
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- PRICE_CHANGE_ID
- 1
- PRINT_ONLINE_IND
- S
- COUNTRY_OF_ORIGIN
- SAM
- MULTI_UNIT_RETAIL
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- PRICE_CHANGE_EFF_DATE
- 2026-01-01
default
- QTYR
- 12.5000
- ITEMR
- Ticket Request-002-ALT
- LOCATIONR
- 3
- LOC_TYPER
- T
- TICKET_TYPE_IDR
- ALT-
- ID
- 3
- ORDER_NO
- 4
- MULTI_UNITS
- 12.5000
- UNIT_RETAIL
- 12.5000
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- PRICE_CHANGE_ID
- 1000000003
- PRINT_ONLINE_IND
- T
- COUNTRY_OF_ORIGIN
- Tic
- MULTI_UNIT_RETAIL
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
- PRICE_CHANGE_EFF_DATE
- 2026-01-03
default
- QTYR
- 14.0000
- ITEMR
- Ticket Request-003-EDGE
- LOCATIONR
- 5
- LOC_TYPER
- T
- TICKET_TYPE_IDR
- EDGE
- ID
- 5
- ORDER_NO
- 6
- MULTI_UNITS
- 14.0000
- UNIT_RETAIL
- 14.0000
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- PRICE_CHANGE_ID
- 1000000005
- PRINT_ONLINE_IND
- T
- COUNTRY_OF_ORIGIN
- Tic
- MULTI_UNIT_RETAIL
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
- PRICE_CHANGE_EFF_DATE
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 42
- Governed Rule Count
- 29