Record representing customer order
Optional table used for pre-transaction workflow and throughput /
load / performance management
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Transaction | Text | 8 | 1 | Edit | Yes | Public | ||
| NAM | External Readable Identification | Text | 40 | 1 | Edit | Yes | Public | ||
| OBJTYP | Object Type of Associated Contract (Optional) | Text | 6 | 1 | Edit | Yes | Public | ||
| OBJINR | Object INR of Associated Contract (Optional) | Text | 8 | 1 | Edit | Yes | Public | ||
| SMHINR | INR of Associated Incoming Message | Text | 8 | 1 | Edit | Yes | Public | ||
| PTAINR | INR of Ordering Party | Text | 8 | 1 | Edit | Yes | Public | ||
| EXTKEY | External Key | Text | 32 | 1 | Edit | Yes | Public | ||
| INFDSP | Infoflag | Text | 1 | 1 | Edit | Yes | Public | INFDSP | |
| INFTXT | Infotext | Block | 65 | 4 | 4 | Block | Yes | Public | |
| STA | Status | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
| STADATTIM | Timestamp of Last Status Update | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| OWNUSG | Responsible Group (Optional) | Text | 6 | 1 | Edit | Yes | Public | <fixed-length> | |
| OWNUSR | Responsible User (Optional) | Text | 8 | 1 | 20 | Edit | Yes | Public | <fixed-length> |
| INIDATTIM | Timestamp of Creation | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| TARDATTIM | Target for Completion | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| CPLDATTIM | Timestamp of Completion | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| TOTDUR | Duration (in Seconds) | Numeric | 10 | 2 | Edit | Yes | Public | ||
| SLACLA | Predefined Priority Class | Text | 6 | 1 | Edit | Yes | Public | ||
| SLACHA | Channel | Text | 3 | 1 | Edit | Yes | Public | CORTYP | |
| CREOBJTYP | Object Type of Creating Object | Text | 6 | 1 | Edit | Yes | Public | ||
| CREOBJINR | INR of Creating Object | Text | 8 | 1 | Edit | Yes | Public | ||
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| ETYEXTKEY | Entity owning Order | Text | 8 | 1 | Edit | Yes | Public | ||
| CHKFLG | Order OK | Text | 1 | 1 | Edit | Yes | Public | YESNO | |
| GETFLDNRM | Field holding the normalized search fields | Text | 60 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| ORD_CREOBJ | CREOBJTYP, CREOBJINR | |
| ORD_ETYEXTKEY | ETYEXTKEY | |
| ORD_EXTKEY | EXTKEY | |
| ORD_GETFLDNRM | GETFLDNRM | |
| ORD_INR | INR | Unique |
| ORD_OBJIDX | OBJTYP, OBJINR | |
| ORD_SMHINR | SMHINR | |
| ORD_STA | STA |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter ORD. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
External readable name of the order. In creation of order record usually copied from SMH\NAM.
External readable name of the order.
Object Type of Associated Item (i.e. SMH).
Type of object the order entry refers to. This is the table the object is stored in.
The field identifies the object type of associated item,
i.e. the type of object the order entry refers to. This is the table the object is stored in.
INR of the object within the table, defined in OBJTYP.
Internal unique ID of object.
INR of (First) Associated Incoming Message (Optional)
Unique ID of (first) associated Incoming Message (optional).
INR of Ordering Party Address (PTA). Optional.
An optional field supplying the unique ID of the Ordering Party Address.
Field to identify a message: This field is generated for created messages by the routine SMHEXTbased on the TRNINR and the address identification.
Field to identify a message.
Flag to indicate whether the content of an infotext should be displayed when using the contract. No content switches the automatic display off.
Flag to indicate whether the contents of an infotext should be displayed when using the contract. No content switches the automatic display off.
This field is used to store any relevant information about this object.This information is displayed to the user during daily processing, if the display info flag has been activated.
This field is used to store any relevant information about this object.This information is displayed to the user during daily processing, if the display info flag has been activated.
Status of order = TYPe of last Order Event (ORE).
Order is offically closed if status is FIN (finished by SRVFIN) CAN (canceled by DBWORD) JOI (joined with other order) DES (SPT deleted)
In all these cases the CPLDATTIM is set. In all other cases the CPLDATTIM remains open.
Status of order.
| Code | Text |
|---|---|
| CRE | Order created |
| TRN | TRN created |
| COR | TRN sent to correction |
| DEL | TRN deleted |
| FIN | Order closed |
| CAN | Order canceled |
| REL | TRN released |
| DES | SPT deleted |
| BRK | TRN interrupted |
| INC | Message received |
| SPT | SPT released |
| SIG | Signature |
| JOI | Order joined |
Date and time, when the status of this order has changed the last time.
Date and time when the status relating to this order was last changed.
User group responsible to pick up the entry. This field has to be set and handled according to the handling of USFMOD, which handles the filters that can be defined by the user.
User group responsible for picking up the entry.
User responsible to pick up the entry. This field has to be set and handled according to the handling of USFMOD, which handles the filters that can be defined by the user.
This field holds the User ID of the person responsible for picking up the entry.
Date and time, when this order has been stored in the system.
Date and time when this order was stored in the system.
Target time (i.e. date + time) on which the service should be completed.
Target time (i.e. date + time) by which the service is to be completed.
Date and time, when this order has been completed. Set by SRVFIN or ORDMOD when the order is finished or officially canceled (ORD\STA = FIN, CAN, DES, JOI)
Date and time when this order was completed.
Duration contains the time in seconds during which the transaction named in FRM worked on the order (allowing performance statistics). Duration is calculated as difference between INIDATTIM and CPLDATTIM.
The number of seconds the transaction took to process the order (allowing performance statistics). This is the difference between the beginning and end timestamps.
Predefined Priority Class (as defined in service level agreement with ordering customer).
Predefined Priority Class (as defined in the service level agreement with the ordering customer).
This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY of the owning entity to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
This field holds the external key of the owning entity to identify the logical owner of this entry.
This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
Sample for project specific additional fields.
Sample of additional project-specific fields.
Channel (CORTYP) by which this order was received
Channel (CORTYP) by which this order was received
Optional field to identify the object type of the creating object. For SPT's created via autoregistration (STA='RIM') this object type is usual 'TRN', thus the business transaction which created the autoregistered entry is identified by CREOBJTYP and CREOBJINR.
Optional field to identify the object type of the creating object. For SPT's created via autoregistration (STA='RIM') this object type is usual 'TRN', thus the business transaction which created the autoregistered entry is identified by CREOBJTYP and CREOBJINR.
Optional field to identify the concrete object which initiated the creation of this SPT. In SPT's created via autoregistration (STA='RIM') this is usually the INR of the creating business transaction (TRN\INR).
Optional field to identify the concrete object which initiated the creation of this SPT. In SPT's created via autoregistration (STA='RIM') this is usually the INR of the creating business transaction (TRN\INR).
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
This field holds the version counter to keep track of the version history of an ORD entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.