EOEP_APP_CDPrompt Table: EOEP_APPCD_VW
EOEP_APP_CD_FIELDEOEP_PRCLST_AT_VAL1=Customer
2=Customer Group
3=Region Identification
4=Region Code
5=Price Rule
EOEP_APP_PL_VW(SQL View) |
Index Back |
|---|---|
Price List 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 = 'PRCLST_ATTCH' |
| # | 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 | EOEP_PRCLST_AT_VAL |
Character(1) | VARCHAR2(1) NOT NULL |
Price List Attached To
1=Customer 2=Customer Group 3=Region Identification 4=Region Code 5=Price Rule |