SETIDSTD_NOTE_CDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: NOTE_TYPE
STD_NOTE_VW(SQL View) |
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. |
| SELECT SETID, STD_NOTE_CD, EFFDT, EFF_STATUS, DESCR, TEXT254, NOTE_TYPE FROM PS_STD_NOTE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 7 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Note Type
Prompt Table: NOTE_TYPE |