MESSAGE_TBL(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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | MESSAGE_ACTION | Character(2) | VARCHAR2(2) NOT NULL |
Action
H=Hold N=None R=Reject Default Value: N |
| 8 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | This field determine the hold code of an item. |
| 9 | PASS_THRU_INV | Character(1) | VARCHAR2(1) NOT NULL |
Process Thru Inventory
Y/N Table Edit Default Value: N |
| 10 | INCL_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Include in Planning
Y/N Table Edit Default Value: N |
| 11 | PASS_TO_PURCH | Character(1) | VARCHAR2(1) NOT NULL |
Pass to Purchasing
Y/N Table Edit Default Value: N |