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 | Character(4) | VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table: EOEP_APPCD_VW |
|
2 | Character(30) | VARCHAR2(30) NOT NULL |
Transaction Code Field
Default Value: PRICE_TYPE |
|
3 | Character(2) | VARCHAR2(2) NOT NULL |
Pricing type
P=Extended Price Q=Quantity V=Volume W=Weight |