CONVERT_ORDER_FLAG1=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
RO_PK_CVT_ORDR(SQL View) |
Index Back |
|---|---|
Pricing Key for ConversionsPricing Key for a Conversion Order from Prepaid to a normal billing account. |
| SELECT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'CONVERT_ORDER_FLAG' AND %EffdtCheck(PSXLATITEM A1, A, %currentdatein) AND A.EFF_STATUS = 'A' |
| # | 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 |