Atributos

Índices

Anexos

Tabela de Empresas do Grupo Tramontina (Company)

Site de destino (TargetSite)

Tabela Vendável

Exemplos

• Retorna todos os dados cadastrais do produto 22202000 da empresa Cutelaria do site Tramontina.

SELECT * 
  FROM vw_ProductDataBDSite 
 WHERE ProductCode = '22202000' 
   AND Company = 2 
   AND TargetSite = 'T'

Código da View

CREATE VIEW `vw_ProductDataBDSite` AS
SELECT `pro`.`empcod` AS `Company`,
       `pro`.`itecod` AS `ProductCode`,
       `pro`.`pro_pesoliq` AS `NetWeight`,
       `pro`.`pro_pesobruto` AS `GrossWeight`,
       `pro`.`pro_identven` AS `Salable`,
       `prc`.`prccompr` AS `Length`,
       `prc`.`prclarg` AS `Width`,
       `prc`.`prcaltura` AS `Height`,
       `prc`.`prcdiam` AS `Diameter`,
       `prc`.`prccapac` AS `Capacity`,
       `prc`.`prcuncapac` AS `MeasureCapacity`,
       `prc`.`prcesp` AS `Thickness`,
       `prc`.`prccor1` AS `Color1`,
       `prc`.`prccor2` AS `Color2`,
       `prc`.`lprcodlin` AS `CommercialLineCode`,
       `lpr`.`lprnomelin` AS `CommercialLine`,
       `prc`.`prcdimextraa` AS `ExtraDimensionA`,
       `prc`.`prcdimextrab` AS `ExtraDimensionB`,
       `prc`.`prcdimextrac` AS `ExtraDimensionC`,
       `prc`.`prcdimextrad` AS `ExtraDimensionD`,
       `prc`.`prcdimextrae` AS `ExtraDimensionE`,
       `prc`.`prcdimextraf` AS `ExtraDimensionF`,
       `prc`.`prcdimextrag` AS `ExtraDimensionG`,
       `prc`.`prcdimextrah` AS `ExtraDimensionH`,
       `prc`.`prcnomefant` AS `ProductName`,
       `pro`.`pro_codbar` AS `EAN13`,
       `pro`.`ncm_codncm` AS `NCMCode`,
       `prc`.`prcsite` AS `TargetSite`
  FROM (`imapro` `pro` JOIN (`diaprc` `prc` LEFT JOIN `dialpr` `lpr` ON(((`prc`.`lprcodlin` = `lpr`.`lprcodlin`)
   AND (`prc`.`empcod` = `lpr`.`empcod`)))))
 WHERE ((`pro`.`empcod` = `prc`.`empcod`)
   AND (`pro`.`itecod` = `prc`.`itecod`)
   AND (`prc`.`prcdest` IN ('S','T'))
   AND (`prc`.`prcsit` = 'O'))