SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
MESSAGE_CDEFFDTDefault Value: %date
LANGUAGE_CDMESSAGE_TBL_LG(SQL Table) |
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. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | MESSAGE_CD |
Character(6) | VARCHAR2(6) NOT NULL | Message Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |