SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
STD_NOTE_CDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: NOTE_TYPE
Y/N Table Edit
Default Value: Y
STD_NOTE(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 |
SetID
Default Value: OPR_DEF_TBL_FS.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 | 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 |
| 8 | CWB_DISPLAY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Options for Collections Workbench
Y/N Table Edit Default Value: Y |