Com a procés: URL = http://localhost:6443/eines/executar/IISC4EDICOM
<Parametres> <Operacio>GENERAR_PRICAT</Operacio> <PRICAT> <IC>C000484</IC> <GLN>8422416000016</GLN> <LlistaDePreusPVP>1</LlistaDePreusPVP> <LlistaDePreusPVD>20</LlistaDePreusPVD> <DataEfectiva>20200305</DataEfectiva> <DataEfectivaPreu>20200305</DataEfectivaPreu> <SQL> <![CDATA[ SELECT IT."ItemCode",M."U_ModDesc",IT."ItemName",IT."CodeBars",IT."U_ARGNS_DIV",D."Departament" ,IT."U_ARGNS_SEASON" ,COL."U_ColDesc" ,SZ."U_SizeDesc" ,PVP."PriceList" "PVPPriceList",PVP."Price" "PVPPrice1",PVP."Currency" "PVPCurrency",LPVP."ListName" "PVPListName" ,PVD."PriceList" "PVDPriceList",PVD."Price" "PVDPrice",PVD."Currency" "PVDCurrency",LPVD."ListName" "PVDListName" ,DR."PVP" "PVPPrice" FROM OITM IT JOIN DMB_REFS DR on DR."ARTICULO"=IT."ItemCode" JOIN EDICOMDepartamentsECI D on D."Argns_division"=IT."U_ARGNS_DIV" and D."IdCompanyia"='A20174_ECOALF_PRODL' and D."CardCode"='C000484' JOIN OCRD IC on IC."CardCode"='C000484' JOIN ITM1 PVP on PVP."ItemCode" = IT."ItemCode" and PVP."PriceList"=1 JOIN ITM1 PVD on PVD."ItemCode" = IT."ItemCode" and PVD."PriceList"=20 JOIN OPLN LPVP on LPVP."ListNum" = PVP."PriceList" JOIN OPLN LPVD on LPVD."ListNum" = PVD."PriceList" LEFT JOIN "@ARGNS_MODEL" M on M."U_ModCode" = IT."U_ARGNS_MOD" LEFT JOIN "@ARGNS_COLOR" COL on COL."U_ColCode" = IT."U_ARGNS_COL" LEFT JOIN "@ARGNS_SIZE" SZ on SZ."U_SizeCode" = IT."U_ARGNS_SIZE" and SZ."Code" = M."U_SclCode" WHERE not M."U_ModDesc" is null and not IT."CodeBars" is null ORDER BY IT."U_ARGNS_DIV",IT."ItemCode" ]]> </SQL> </PRICAT> </Parametres>