SETIDPrompt Table: SP_SETID_NONVW
PRODUCT_IDPrompt Table: PROD_ITEM
SEQ_NUMDefault Value: 1
Prompt Table: NOTE_TYPE
Prompt Table: STD_NOTE
MOC_PRODNOTE_VW(SQL View) |
Index Back |
|---|---|
Notes for Product for Mobile.Mobile Order Capture uses this Level 1 view to join the product notes with the valid Level 0 Products. |
| SELECT A.SETID , A.PRODUCT_ID , A.SEQ_NUM , A.NOTE_TYPE , A.STD_NOTE_CD , A.TEXT254 , A.SYNCID , A.SYNCDTTM , B.DESCR FROM PS_PROD_NOTE A , PS_NOTE_TYPE B WHERE A.SETID=B.SETID AND A.NOTE_TYPE = B.NOTE_TYPE |
| # | 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.
Prompt Table: SP_SETID_NONVW |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 4 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Note Type
Prompt Table: NOTE_TYPE |
| 5 | STD_NOTE_CD | Character(10) | VARCHAR2(10) NOT NULL |
Standard Note Code
Prompt Table: STD_NOTE |
| 6 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 7 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 8 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |