EOEP_APP_CDPrompt Table: EOEP_APPCD_VW
RECNAMEPrompt Table: PSRECDEFN
FIELDNAMEPrompt Table: RECFIELD_VW
Prompt Table: PSRECDEFN
EOEP_APPKEY_FLD(SQL Table) |
Index Back |
|---|---|
Pricing Application Key Fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEP_APP_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table: EOEP_APPCD_VW |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: RECFIELD_VW |
| 4 | PROMPT_TBL | Character(15) | VARCHAR2(15) NOT NULL |
Prompt Table
Prompt Table: PSRECDEFN |
| 5 | DTTIME_ADDED | DateTime(26) | TIMESTAMP | Date Time Added |
| 6 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 7 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |