EOEP_APP_CDPrompt Table: EOEP_APPCD_VW
EOEP_APP_CD_FIELDPRC_BREAK_DATEA=Requested Arrival Date
O=Order Date
S=Schedule Ship Date
EOEP_APP_BRDTVW(SQL View) |
Index Back |
|---|---|
Application Code Price Types |
| SELECT EOEP_app_cd , EOEP_app_cd_field , %Substring(EOEP_trans_value, 1, 1) FROM PS_EOEP_APP_CD_DTL WHERE EOEP_app_cd_field = 'BREAK_DT' |
| # | 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 | EOEP_APP_CD_FIELD |
Character(30) | VARCHAR2(30) NOT NULL | Transaction Code Field |
| 3 | PRC_BREAK_DATE |
Character(1) | VARCHAR2(1) NOT NULL |
Price Break Date Type
A=Requested Arrival Date O=Order Date S=Schedule Ship Date |