SEQ_NBRLINE_NBRPrompt Table: SP_BU_PC_NONVW
RS_INT_DMD_ADD(SQL View) |
Index Back |
|---|---|
External Demand Search RecordExternal Demand Search Record , used as a Search record of the RS_INTFC_DMD component. |
| SELECT SEQ_NBR ,LINE_NBR ,LOAD_DESCR ,BUSINESS_UNIT ,DEMAND_ID FROM PS_RS_INTFC_DMD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 2 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 3 | LOAD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Load Description |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 5 | DEMAND_ID | Character(15) | VARCHAR2(15) NOT NULL | Demand ID |