EOEP_APP_CDPrompt Table: EOEP_APPCD_VW
EOEP_APP_CD_FIELDDefault Value: PRICE_TYPE
PRICE_TYPEP=Extended Price
Q=Quantity
V=Volume
W=Weight
EOEP_APP_PRTYPV(SQL View) |
Index Back |
|---|---|
Application Code Price Types |
| SELECT eoep_app_cd , eoep_app_cd_field , %Substring(eoep_trans_value, 1, 2) FROM PS_EOEP_APP_CD_DTL WHERE eoep_app_cd_field = 'PRICE_TYPE' |
| # | 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
Default Value: PRICE_TYPE |
| 3 | PRICE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Pricing type
P=Extended Price Q=Quantity V=Volume W=Weight |