SDM_TARGET_ATTRIBUTE
This table stores properties of the Target ERP system attribute.
Primary Key
Table 4-192 Primary Key Table
| Constraint Name | Columns |
|---|---|
| SDM_TRGT_ATTRID_PK | TARGET_ATTR_ID |
Foreign Key
Table 4-193 Foreign Key Table
| Table | Foreign Table | Foreign Key Columns |
|---|---|---|
| SDM_TARGET_ATTRIBUTE | SDM_TARGET | TARGET_ID |
Columns
Table 4-194 Column Details Table
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
| TARGET_ATTR_ID | NUMBER | 18 | 0 | No | Unique identifier of the record. | |
| TARGET_ID | NUMBER | 18 | 0 | No | Stores the Target ID value of SDM_TARGET. | |
| TRGT_ATTR_NAME | VARCHAR2 | 80 | No | Stores the unique name for the target attribute. | ||
| DATA_TYPE | VARCHAR2 | 20 | No | Data type for the attribute value for posting to Target. | ||
| IS_REQUIRED | CHAR | 1 | No | Defines whether value for this attribute is mandatory while posting. | ||
| ATTRIBUTE_ORDER | NUMBER | 4 | 0 | No | Defines order of the attribute. | |
| VALUE_TYPE | VARCHAR2 | 20 | No | Type of the attribute value assignment. Example: Explicit, Mapped, System. | ||
| ATTRIBUTE_TYPE_INTERNAL | VARCHAR2 | 30 | No | Specifies whether value for attribute is UserDefined or internally generated. | ||
| FIELD_TYPE | VARCHAR2 | 20 | Yes | Field type for target attribute. Currently Amount, Debit or Credit. | ||
| VALUE_FORMAT | VARCHAR2 | 20 | Yes | Stores the format of the output for Date type attribues. | ||
| EXPLICIT_VALUE_TEXT | VARCHAR2 | 300 | Yes | Stores the attribute value if type is explicit and Text. | ||
| EXPLICIT_VALUE_NUM | NUMBER | 29 | 12 | Yes | Stores the attribute value if type is explicit and Number or Integer. | |
| EXPLICIT_VALUE_DATE | DATE | Yes | Stores the attribute value if type is explicit and Date or DateTime. | |||
| SYSTEM_VALUE | VARCHAR2 | 20 | Yes | Stores the type of system value. Ex. User Name, Start Date, End Date. | ||
| APP_ID | NUMBER | 1 | 0 | No | Identifier for the application to which the row corresponds to, for example, SDM:4. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 0 | No | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 255 | Yes | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 255 | No | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | DATE | No | Who column: indicates the date and time of the last update of the row. | |||
| CREATED_BY | VARCHAR2 | 255 | No | Who column: indicates the user who created the row. | ||
| CREATION_DATE | DATE | No | Who column: indicates the date and time of the creation of the row. |
Indexes
Table 4-195 Index Table
| Index | Uniqueness | Columns |
|---|---|---|
| SDM_TRGT_ATTRID_PK | UNIQUE | TARGET_ATTR_ID |
| SDM_TRGT_ATTR_U1_TRGTIDNAME | UNIQUE | TARGET_ID, SYS_NC00022$ |