create view TBTRANSPORTADORA ( RAZAOSOCIAL, CODIGO, UF, STATUS, ENVIA_XML, ECOMMERCE, AVERBACAO, CAMINHONEIRO )
as
select
    RAZAOSOCIAL,
    CODIGO,
    UF,
    STATUS,
    0 ENVIA_XML,
    0 ECOMMERCE,
    0 AVERBACAO,
    0 AMINHONEIRO
from tbempresa_t f;

