SBYN_OVERWRITE
This table stores information about the fields that are locked for updates in the SBRs. It stores the EUID of the SBR, the ePath to the field, and the current locked value of the field. The following table lists Oracle data types. For information about the differences in data types between database vendors, see Table 3.
Table 14 SBYN_OVERWRITE Table Description|
Column Name |
Data Type |
Description |
|---|---|---|
|
VARCHAR2(20) |
The EUID of an SBR containing fields for which the overwrite lock is set. |
|
|
VARCHAR2(200) |
The ePath to a field that is locked in an SBR from the MIDM. |
|
|
VARCHAR2(20) |
The data type of a field that is locked in an SBR. |
|
|
NUMBER(38) |
The data that is locked for overwrite in an integer field. |
|
|
NUMBER(38) |
The data that is locked for overwrite in a boolean field. |
|
|
VARCHAR2(200) |
The data that is locked for overwrite in a string field. |
|
|
CHAR(2) |
The data that is locked for overwrite in a byte field. |
|
|
LONG |
The data that is locked for overwrite in a long integer field. |
|
|
DATE |
The data that is locked for overwrite in a date field. |
|
|
NUMBER(38,4) |
The data that is locked for overwrite in a floating decimal field. |
|
|
DATE |
The data that is locked for overwrite in a timestamp field. |
- © 2010, Oracle Corporation and/or its affiliates