EOEP_APP_CDPrompt Table: EOEP_APPCODE_VW
EOEP_DATE_NAME01=Price Date
02=Effective Date
03=Order Date
04=Requested Arrival Date
05=Schedule Ship Date
06=System Date
99=User Date
Prompt Table: PSRECDEFN
Prompt Table: EOEP_DATEFLD_VW
EOEP_DATE_VAR(SQL Table) |
Index Back |
|---|---|
Pricing Date RecordPricing Date Record |
| # | 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_APPCODE_VW |
| 2 | EOEP_DATE_NAME |
Character(15) | VARCHAR2(15) NOT NULL | Date Name |
| 3 | EOEP_DATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Date Type
01=Price Date 02=Effective Date 03=Order Date 04=Requested Arrival Date 05=Schedule Ship Date 06=System Date 99=User Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EOEP_DATEFLD_VW |