SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
MESSAGE_CDLANGUAGE_CDHWB_MSGTBL_LVW(SQL View) |
Index Back |
|---|---|
Message TableThis table holds the message codes which can be associated to customers and products. Messages may have actions such as "hold" or "reject", and these actions will be considered during transactions and appropriate processing will take place. |
| SELECT DISTINCT M.SETID , M.MESSAGE_CD , L.LANGUAGE_CD , L.DESCR , L.DESCR FROM PS_MESSAGE_TBL M , PS_MESSAGE_TBL_LG L WHERE %Join(COMMON_KEYS, MESSAGE_TBL M, MESSAGE_TBL_LG L) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | MESSAGE_CD |
Character(6) | VARCHAR2(6) NOT NULL | Message Code |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | OM_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |