Ticket Format
In ScopeTechnical: TICKET_FORMAT | ID: OR-STO-TICKET_FORMAT-TICKET_FORMAT
Stores ticket formats.
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_FORMAT
Field Definitions(5)
Rules & Considerations(25)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | TYPER | STORE_IDR | DESCRIPTIONR | IS_DEFAULT | CREATE_DATE | CREATE_USER | UPDATE_DATE | UPDATE_USER | TICKET_ZPL_ID | FORMAT_REFERENCE | DEFAULT_PRINTER_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | S | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1 | SAMPLE | 1 |
| default | 3 | 2 | 1000000003 | Ticket Format-002-ALT | N | 2026-01-03 | Ticket Format-002-ALT | 2026-01-03 | 2026-01-02-ALT | 1000000003 | Ticket Format-002-ALT | 100003 |
| default | 5 | 1 | 1000000005 | Ticket Format-003-EDGE | N | 2026-01-05 | Ticket Format-003-EDGE | 2026-01-05 | 2026-01-03-EDGE | 1000000005 | — | 100005 |
Example values from field definitions
- IDRPK
- 1
- TYPER
- 1
- STORE_IDR
- 1
- DESCRIPTIONR
- SAMPLE
- IS_DEFAULT
- S
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- TICKET_ZPL_ID
- 1
- FORMAT_REFERENCE
- SAMPLE
- DEFAULT_PRINTER_ID
- 1
default
- IDRPK
- 3
- TYPER
- 2
- STORE_IDR
- 1000000003
- DESCRIPTIONR
- Ticket Format-002-ALT
- IS_DEFAULT
- N
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Ticket Format-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- TICKET_ZPL_ID
- 1000000003
- FORMAT_REFERENCE
- Ticket Format-002-ALT
- DEFAULT_PRINTER_ID
- 100003
default
- IDRPK
- 5
- TYPER
- 1
- STORE_IDR
- 1000000005
- DESCRIPTIONR
- Ticket Format-003-EDGE
- IS_DEFAULT
- N
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Ticket Format-003-EDGE
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- TICKET_ZPL_ID
- 1000000005
- FORMAT_REFERENCE
- —
- DEFAULT_PRINTER_ID
- 100005
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 25