RB_NOTES_LST_LN(SQL Table) |
Index Back |
---|---|
Customer NotesLanguage record for notes list. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | 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
|
4 | ID_NOTE | Character(20) | VARCHAR2(20) NOT NULL | ID Number |
5 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
7 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
8 | OPPORTUNITY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Opportunity Name - User Enters this field in Mixed Case. |
9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
10 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
11 | NOTE_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | The original location a note came from. Or the source location of the note, either a lead, opportunity, customer, contact, case or service order. |
12 | DESCRLONG | Long Character | CLOB | Long Description |