SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
STD_NOTE_CDEFFDTDefault Value: %date
LANGUAGE_CDSTD_NOTE_LANG(SQL Table) |
Index Back |
|---|---|
Standard Note TableThis record stores the Note Code information, including long text descriptions of recurring, standard text that should appear on printed documents. Note codes could be associated to Quotes, Orders, Invoices, Customers and Products. This is an optional record. |
| # | 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 | STD_NOTE_CD |
Character(10) | VARCHAR2(10) NOT NULL | Standard Note Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |