RO_PK_CVTORD_VW

(SQL View)
Index Back

Conversion Order - Pricing

This view is used by the pricing engine to know if the order is a conversion order from prepaid to postpaid.

SELECT FIELDVALUE , XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME = 'YES_NO'

  • Related Language Record: RO_PK_CVTOR_VWL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONVERT_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Convert Order flag indicates the order is a conversion from a prepaid account to postpaid account
    1=Move Nothing
    2=Move Phone, SIM, Number
    3=Move SIM, Number
    4=Move Phone, Number
    5=Move Number
    6=Move Phone, SIM
    7=Move SIM
    8=Move Phone
    N=Not Conversion Order
    Y=Conversion Order
    2 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field