MSG_TBL_HOLD_VW(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. Date Init. Issue # Description 051304 dms F-KNANN-V59N4 Replace old pass thru fields |
| SELECT DISTINCT MSG1.SETID , MSG1.MESSAGE_CD , MSG1.EFFDT , MSG1.EFF_STATUS , OH.BUSINESS_UNIT , OH.ORDER_NO , OH.ORDER_INT_LINE_NO , OH.SCHED_LINE_NBR , OH.PASS_HOLD_LEVEL , MSG1.PASS_HOLD_TO_BI , MSG1.PASS_HOLD_TO_ID , MSG1.PASS_HOLD_TO_IP , MSG1.PASS_HOLD_TO_IR , MSG1.PASS_HOLD_TO_IS , MSG1.PASS_HOLD_TO_IU , MSG1.PASS_TO_PURCH , MSG1.INCL_IN_PLAN FROM PS_MESSAGE_TBL MSG1 , PS_SET_CNTRL_REC SC , PS_ORD_HOLD OH WHERE SC.RECNAME = 'MESSAGE_TBL' AND MSG1.SETID = SC.SETID AND MSG1.MESSAGE_CD = OH.MESSAGE_CD AND OH.EFF_STATUS = 'A' AND MSG1.EFF_STATUS = 'A' |
| # | 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 | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 7 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 8 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 9 | PASS_HOLD_LEVEL | Character(4) | VARCHAR2(4) NOT NULL |
Hold Code Level
CUST=Customer Hold HDR=Header Hold LINE=Line Hold PROD=Product Hold SCH=Schedule Hold SYS=System Holds |
| 10 | PASS_HOLD_TO_BI | Character(1) | VARCHAR2(1) NOT NULL |
Pass to Billing
Y/N Table Edit Default Value: N |
| 11 | PASS_HOLD_TO_ID | Character(1) | VARCHAR2(1) NOT NULL |
Pass to Released
Y/N Table Edit Default Value: N |
| 12 | PASS_HOLD_TO_IP | Character(1) | VARCHAR2(1) NOT NULL |
Pass to Picked/Confirmed
Y/N Table Edit Default Value: N |
| 13 | PASS_HOLD_TO_IR | Character(1) | VARCHAR2(1) NOT NULL |
Pass to Releasable
Y/N Table Edit Default Value: N |
| 14 | PASS_HOLD_TO_IS | Character(1) | VARCHAR2(1) NOT NULL |
Pass to Shipped
Y/N Table Edit Default Value: N |
| 15 | PASS_HOLD_TO_IU | Character(1) | VARCHAR2(1) NOT NULL |
Pass to Unfulfilled
Y/N Table Edit Default Value: N |
| 16 | PASS_TO_PURCH | Character(1) | VARCHAR2(1) NOT NULL | Pass to Purchasing |
| 17 | INCL_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL | Include in Planning |