HTML Code:
A,Plan name ,L,M,B,Service Name,Pricing Rule,From Unit,To Unit, DISTI(USD) , MSRP(USD) , DIST(EUR) , MSRP(EUR) , EMEA-DISTI(USD) , EMEA-MSRP(USD) , GLOBAl-DISTI(USD) , GLOBAL-MSRP(USD) , DISTI(GBP) , MSRP(GBP)
C1,P1,L1,M1,1,S1,Standard,1,,255,300,187.85,221,255,300,255,300,151.3,178
C2,P2,L2,M2,1,S2,Standard,1,2,1,2,3,4,5,6,7,8,9,10
C3,P2,L2,M2,1,S2,Standard,3,,11,12,13,14,15,16,17,18,19,20
HTML Code:
<OPERATION_NAME>,<PLAN_SUB_ENTITY>,<plan_name>,<service_name>,<RATE SCHEDULE NAME>,<CURRENCY>,<IS_DEFAULT>,<From Unit>,<To Unit>,<amount>
XX,YY,P1,S1, DISTI , USD ,0,1, ,255
XX,YY,P1,S1, MSRP , USD ,1,1, ,300
XX,YY,P1,S1, DIST , EUR ,0,1, ,187.85
XX,YY,P1,S1, MSRP , EUR ,1,1, ,221
XX,YY,P1,S1, EMEA-DISTI , USD ,0,1, ,255
XX,YY,P1,S1, EMEA-MSRP , USD ,0,1, ,300
XX,YY,P1,S1, GLOBAl-DISTI , USD ,0,1, ,255
XX,YY,P1,S1, GLOBAL-MSRP , USD ,0,1, ,300
XX,YY,P1,S1, DISTI , GBP ,0,1, ,151.3
XX,YY,P1,S1, MSRP , GBP ,1,1, ,178
XX,YY,P2,S2, DISTI , USD ,0,1,2,1
XX,YY,P2,S2, MSRP , USD ,1,1,2,2
XX,YY,P2,S2, DIST , EUR ,0,1,2,3
XX,YY,P2,S2, MSRP , EUR ,1,1,2,4
XX,YY,P2,S2, EMEA-DISTI , USD ,0,1,2,5
XX,YY,P2,S2, EMEA-MSRP , USD ,0,1,2,6
XX,YY,P2,S2, GLOBAl-DISTI , USD ,0,1,2,7
XX,YY,P2,S2, GLOBAL-MSRP , USD ,0,1,2,8
XX,YY,P2,S2, DISTI , GBP ,0,1,2,9
XX,YY,P2,S2, MSRP , GBP ,1,1,2,10
XX,YY,P2,S2, DISTI , USD ,0,3,,11
XX,YY,P2,S2, MSRP , USD ,1,3,,12
XX,YY,P2,S2, DIST , EUR ,0,3,,13
XX,YY,P2,S2, MSRP , EUR ,1,3,,14
XX,YY,P2,S2, EMEA-DISTI , USD ,0,3,,15
XX,YY,P2,S2, EMEA-MSRP , USD ,0,3,,16
XX,YY,P2,S2, GLOBAl-DISTI , USD ,0,3,,17
XX,YY,P2,S2, GLOBAL-MSRP , USD ,0,3,,18
XX,YY,P2,S2, DISTI , GBP ,0,3,,19
XX,YY,P2,S2, MSRP , GBP ,1,3,,20
With jus one extra logic where the RATE SCHEDULE NAME is MSRP the IS_DEFAULT column should have value 1 else 0