RO_PK_CVTORD_VW(SQL View) |
Index Back |
---|---|
Conversion Order - PricingThis 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' |
# | 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 |