Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
SPTINR | INR of the Associated SPT | Text | 8 | |
OBJTYP | Object Type | Text | 6 | |
OBJINR | Object INR | Text | 8 | |
CREDAT | Date Created | Date | 12 | |
CRETIM | Time of Creation | Numeric | 6 | |
CREUSR | Creating User ID | Text | 8 | |
CRESSNINR | INR of Creating Session | Text | 8 | |
RELLEV | Release Level | Text | 1 | |
RELDAT | Date of Release | Date | 12 | |
RELTIM | Time of Release | Numeric | 6 | |
RELUSR | Releasing User ID | Text | 8 | |
RELSSNINR | INR of Releasing Session | Text | 8 | |
RELSTA | Release Status | Text | 1 | Embedded |
PUPSTA | Processing Status | Text | 1 | Embedded |
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.
Unique ID of the pending transaction entry holding the relevant pending PUR or PUP.
Type of object the pending entry refers to. Usually this is the table the object is associated to.
Unique ID of the object within the table, defined in the Object Type field.
This date field identifies the date the entry was physically added to the database.
This field defines the time when this pending transaction was initially created. The date field holds the corresponding date.
This identifies the user who created this entry.
This field holds the ID of the session that created the pending transaction.
This field contains the results of running the globally accessible routine GetSprRelLev, that controls the 4-eye principle in the application.
This date defines the date when this pending transaction was released (or sent to correction/deletion). The time field holds the corresponding time.
This field defines the time when this pending transaction was released (or sent to correction/deletion). The date field holds the corresponding date.
The field identifies the user who released this entry (or sent it to correction/deletion).
This field holds the unique ID of the session that released (or sent to correction/deletion) this pending transaction.
Code | Text |
---|---|
Waiting | |
R | Released |
C | Sent to Correction |
D | Sent to Deletion |
Any non-empty content indicates that this masterfile modification has been processed and is no longer pending.
Code | Text |
---|---|
Waiting | |
P | Finally Processed |
E | Update Canceled |
N | Not Released |