 
create table PermStatusDocERPB
(
    CodigoEmp          CHAR(2)                not null,
    CodigoUnidade      CHAR(8)                not null,
    Documento          CHAR(3)                not null,
    Funcao             CHAR(5)                not null,
    Status             CHAR(1)                not null,
    DataAtual          datetime               not null,
    CodigoMatricula    CHAR(15)               not null    
);

INSERT INTO PermStatusDocERPB VALUES ('01','01      ','NFS','CNFAT','I',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','NFS','CNFEM',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','NFS','CNFEM','I',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','NFS','CNFRP',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','NFS','CNFRP','I',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','NFS','CNFRP','K',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','OE ','COEEM',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','OE ','COEEM','I',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','OE ','COERP',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','OE ','COERP','I',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPAP',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPAP','L',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPAT',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPAT','L',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPCL',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPCL','L',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPCR',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPCR','L',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPCT',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPCT','L',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPEM',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPEM','L',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPRP',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPRP','L',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','COPRP','S',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','PEDTT',' ',NOW(*),'ERPF           ');
INSERT INTO PermStatusDocERPB VALUES ('01','01      ','PED','PEDTT','L',NOW(*),'ERPF           ');

create unique index PermStatusDocERPB_PK1 on PermStatusDocERPB (CodigoEmp, CodigoUnidade, Documento, Funcao, Status);

GRANT ALL ON PermStatusDocERPB TO BYTEC;