IIService generar PRICAT

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>

Visites: 615