RF_SHOW_PRI_VW(SQL View) |
Index Back |
---|---|
Agreement Line Info ViewAgreement Line Descr and Service ID info used for display on Entitlement page |
SELECT AG_SVC_LINE_PRICE ,SERVICE_ID , DESCR FROM PS_RF_SHOW_PRICE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | AG_SVC_LINE_PRICE | Number(12,2) | DECIMAL(11,2) NOT NULL | Transaction price for service on an agreement line |
2 | SERVICE_ID | Character(20) | VARCHAR2(20) NOT NULL | Service ID |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |