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
LANGUAGE_CDRO_PK_CVTOR_VWL(SQL View) |
Index Back |
|---|---|
Conversion Order - PricingLanguage view for the pricing engine to know if the order is a conversion order. |
| SELECT FIELDVALUE , LANGUAGE_CD , XLATLONGNAME FROM PSXLATITEMLANG 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |