| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MVSCENARIO | TSW: Movement scenario number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | SITYP | Schedule type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | DOCIND | Reference document indicator (PSX) | char | 1 | 0 | | | | Allow NULL? |
| 5 | BOOK_TRANSFER | IS-Oil: Indicator book transfer | char | 1 | 0 | | | | Allow NULL? |
| 6 | VBTYP | SD document category | char | 1 | 0 | | | | Allow NULL? |
| 7 | AUART | Sales Document Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | BSTYP | Purchasing Document Category | char | 1 | 0 | | | | Allow NULL? |
| 9 | BSAKZ | Control indicator for purchasing document type | char | 1 | 0 | | | | Allow NULL? |
| 10 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | BDART | Requirement type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | LOC_TYPE | IS-Oil: Location type in nomination | char | 1 | 0 | | | | Allow NULL? |
| 14 | FUNC_GRP | IS-OIL: Function group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | CORRECTING_GROUP | IS-OIL: Function group for Ticket Correction | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | RPART | OIL-TSW: Role partner type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | RTYPE | OIL-TSW: Role type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | SHIPPING_REL | IS-Oil: Shipping relevance in TSW scheduling | char | 1 | 0 | | | | Allow NULL? |
| 19 | ORIG_PLANT | IS-Oil: TSW check plant | char | 1 | 0 | | | | Allow NULL? |
| 20 | DEST_PLANT | IS-Oil: TSW check plant | char | 1 | 0 | | | | Allow NULL? |
| 21 | SD_COO_TYPE | Sales Document Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | TD_CLOSE | Vehicle close flag; set confirmation to complete (status=6) | char | 1 | 0 | | | | Allow NULL? |
| 23 | MM_COO_TYPE | Purchasing Document Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | POST_AUTOMATIC | IS-Oil TSW: Automatic processing indicator | char | 1 | 0 | | | | Allow NULL? |
| 25 | RELATED_MVSCEN | TSW: Movement scenario number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | REVERTING_GROUP | IS-OIL: Function group for Ticket Reversals | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | BATCH_CREATION | Automatic batch creation allowed within ticketing | char | 1 | 0 | | | | Allow NULL? |
| 28 | BATCH_NOM_UPD | Update Batch in nomination item from ticketing (incl DS peg) | char | 1 | 0 | | | | Allow NULL? |
| 29 | CONS_SCEN | Bunker Consumption Scenario Number for a Movement Scenario | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | BATCH_MAINT | Batch maintenance allowed in ticketing transaction | char | 1 | 0 | | | | Allow NULL? |
