Tabela
BA1 Usuarios
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
BA1_CODINT C 4 0 Operadora @R !.!!! BA0->(ExistCpo("BA0")) B89PLS S
BA1_CODEMP C 4 0 Cod. Empresa @! S
BA1_MATRIC C 6 0 Matricula @! S
BA1_CONEMP C 12 0 Contr. Empr. @! S
BA1_VERCON C 3 0 Versao Cont @! S
BA1_SUBCON C 9 0 Sub-Contrato @! S
BA1_VERSUB C 3 0 Versao SubC @! S
BA1_IMAGE C 7 0 @BMP S
BA1_TIPREG C 2 0 Tp. Registro @! S
BA1_DIGITO C 1 0 Digito 9 S
BA1_CPFUSR C 11 0 CPF @R 999.999.999-99 (M->BA1_IDADE < 18) .AND. VAZIO() .OR. (Cgc(M->BA1_CPFUSR) .AND. PLS260VID('I')) S
BA1_PISPAS C 11 0 PIS/PASEP @R !!!.!!!!!.!!.! Iif(Empty(M->BA1_PISPAS),.T.,ChkPis(M->BA1_PISPAS)) S
BA1_DRGUSR C 11 0 RG @! S
BA1_ORGEM C 10 0 Org Emissor @! R S
BA1_MATVID C 8 0 Matric. Vid @! BTS->(ExistCpo("BTS",M->BA1_MATVID,1)) .And. IIf(Type('oBrwUsr') <> "O",.T.,PLS260VLD2()) BYFPLS S
BA1_NOMUSR C 70 0 Nome Benef. @! S
BA1_NREDUZ C 20 0 Nm. Reduzido @! S
BA1_CDMNAS C 7 0 Cd.Mun.Nasc. @! BID->(ExistCpo("BID",M->BA1_CDMNAS,1)) B57PLS R N
BA1_DATNAS D 8 0 Dt. Nascto. @D M->BA1_DATNAS < dDataBase S
BA1_MUNNAS C 30 0 Munic. Nasc. @! R S
BA1_IDADE N 3 0 Idade Atual 999 V S
BA1_ESTNAS C 2 0 Estado Nasc. @! R S
BA1_SEXO C 1 0 Sexo @! 1=Masculino;2=Feminino S
BA1_TIPUSU C 1 0 Tp. Benef. @! Vazio() .Or. (BIH->(ExistCpo("BIH",M->BA1_TIPUSU,1)) .And. IIf(Type('oBrwUsr') <> "O",.T.,PLS260Cha(2))) B47PLS ! lPrim260 S
BA1_DESUSU C 30 0 Descricao @! V S
BA1_ESTCIV C 1 0 Estado Civil @! SX5->(ExistCpo("SX5","33"+M->BA1_ESTCIV)) 33 Pls260IsTit() S
BA1_DESCIV C 30 0 Descricao @! V S
BA1_GRAUPA C 2 0 Grau Parent. @! Vazio() .Or. (BRP->(ExistCpo("BRP",M->BA1_GRAUPA,1)) .And. IIf(Type('oBrwUsr') <> "O",.T.,PLS260Cha(2))) B37PLS Pls260IsTit() S
BA1_DESGRA C 30 0 Descricao @! V S
BA1_DATINC D 8 0 Dt. Inclusao @D IIf(Type('oBrwUsr') <> "O",.T.,PLSA260DIN(oBrwUsr)) S
BA1_NOMPRE C 30 0 Nm. Preposto @! S
BA1_CPFPRE C 11 0 CPF Preposto @R 999.999.999-99 Vazio() .or. CGC(M->BA1_CPFPRE) S
BA1_MAE C 120 0 Mae @! S
BA1_CPFMAE C 11 0 CPF Mae @R 999.999.999-99 If(Empty(M->BA1_CPFMAE),.T.,CGC(M->BA1_CPFMAE)) S
BA1_DATADM D 8 0 Dt Admissao S
BA1_RECNAS C 1 0 Recem-Nascid @! IIf(Type('oBrwUsr') <> "O",.T.,PLSA260DIN(oBrwUsr)) 1=Sim;0=Nao S
BA1_CODPLA C 4 0 Cod.Plano @R !!!! PLSA260BA3() BJ5PLS R S
BA1_DESPLA C 30 0 Descr. Plano @! V S
BA1_VERSAO C 3 0 Versao @! Vazio() .OR. BIL->(EXISTCPO("BIL",M->BA3_CODINT+M->BA1_CODPLA+M->BA1_VERSAO)) .and. PLSA260GCF() BJ6PLS R S
BA1_10ANOS C 1 0 10 Anos Plan @! 0=Nao;1=Sim S
BA1_EMICAR C 1 0 Emitir Cart. @! 0=Nunca Emitir;1=Cad. Alterado;2=Cartao Preparado;3=Cartao Gerado S
BA1_DATCAS D 8 0 Dt Casamento PLSA260DIN(oBrwUsr) S
BA1_CEPUSR C 8 0 CEP @R !!!!!-!!! B83PLS PL260WEND("BA1") S
BA1_ENDERE C 40 0 Endereco @! PL260WEND("BA1") S
BA1_NR_END C 6 0 Numero @! PL260WEND("BA1") S
BA1_COMEND C 20 0 Complemento @! PL260WEND("BA1") S
BA1_BAIRRO C 20 0 Bairro @! PL260WEND("BA1") S
BA1_CODMUN C 7 0 Cd Municipio @! BID->(ExistCpo("BID",M->BA1_CODMUN,1)) B57PLS PL260WEND("BA1") S
BA1_MUNICI C 30 0 Municipio @! PL260WEND("BA1") S
BA1_ESTADO C 2 0 Estado @! PL260WEND("BA1") S
BA1_DDD C 3 0 DDD 999 S
BA1_TELEFO C 15 0 Telefone @R (99)99999-9999 S
BA1_CODPRF C 5 0 Cd Profissao @! BCXPLS S
BA1_DESPRF C 60 0 Descr. Prof. @! V S
BA1_DATMAE D 8 0 Dt. Nasc.Mae @D S
BA1_PAI C 30 0 Nome Pai @! S
BA1_CPFPAI C 11 0 CPF Pai @R 999.999.999-99 If(Empty(M->BA1_CPFPAI),.T.,CGC(M->BA1_CPFPAI)) S
BA1_DATPAI D 8 0 Dt. Nasc.Pai @D S
BA1_MATEMP C 30 0 Matr.Empresa @! S
BA1_MATANT C 17 0 Mat.Sist.Ant @! Empty(M->BA1_MATANT) .Or. (BA1->(ExistChav("BA1",M->BA1_MATANT,2)) .And. BA1->(ExistChav("BA1",M->BA1_MATANT,5))) S
BA1_TIPANT C 2 0 Tipo Antigo @C S
BA1_DATCAR D 8 0 Dt. Carencia @D S
BA1_DATCPT D 8 0 Dt Base CPT @D S
BA1_MUDFAI C 1 0 Muda Faixa ? @! 0=Nao;1=Sim S
BA1_COBRET C 1 0 Cobra Ret ? @! R 0=Nao;1=Sim S
BA1_MESREA C 2 0 Mes Reajuste @! R M->BA3_TIPOUS = "1".OR.GETNEWPAR("MV_PLREAPJ","2")=="1" S
BA1_INDREA C 6 0 Ind Reajuste Vazio() .Or. AAD->(ExistCpo("AAD")) AAD M->BA3_TIPOUS = "2" S
BA1_CB1AMS C 1 0 Cob.1a.Mens? @! 1=Sim;0=Nao S
BA1_VLRIND N 16 2 Vlr. Benef. @E 9,999,999,999,999.99 V S
BA1_UNIVER C 1 0 Universit. ? @! 0=Nao;1=Sim S
BA1_DATBLO D 8 0 Data Bloq. @D S
BA1_MOTBLO C 3 0 Motivo Bloq. @! S
BA1_DESBLO C 30 0 Descr. Bloq. @! V S
BA1_CONSID C 1 0 Consid.Bloq. @! U=Usuario;F=Familia;S=SubContrato S
BA1_INTERD C 1 0 Internado ? @! 0=Nao;1=Sim S
BA1_NUMCON C 20 0 Nro.Contrato @! S
BA1_CORNAT C 1 0 Cor Natural @! 1=Indigena;2=Branca;3=Negra;4=Amarela;5=Parda;6=Nao Informado S
BA1_SANGUE C 2 0 Tipo Sangue @! S
BA1_PRICON D 8 0 Prim. Cons. @D S
BA1_ULTCON D 8 0 Ult.Consulta @D S
BA1_PROCON D 8 0 Prox. Cons. @D S
BA1_VIACAR N 2 0 Num.Via.Cart 99 S
BA1_CODFUN C 4 0 Cod. Funcao @! SRJ->(ExistCpo("SRJ")) SRJ S
BA1_DESCFU C 40 0 Desc. Funcao @! V S
BA1_INSALU C 1 0 Insalubre ? @! 0=Nao;1=Sim S
BA1_CODSET C 3 0 Cod. Setor @! BLM->(ExistCpo("BLM")) B86PLS S
BA1_DESSET C 30 0 Descr. Setor @! V S
BA1_PESO C 7 0 Peso(gr.) @! S
BA1_ALTURA C 7 0 Altura(cm.) @! S
BA1_OBESO C 1 0 Obesidade ? @! 1=Sim;0=Nao S
BA1_RGIMP C 1 0 Reg. Import. @! 1=Sim;0=Nao S
BA1_CBTXAD C 1 0 Cobrada Taxa @! 1=Sim;0=Nao S
BA1_VLTXAD N 16 2 Vlr. Tx Ades @E 9,999,999,999,999.99 S
BA1_NUMCOB C 12 0 Ult Cobranca @! S
BA1_JACOBR C 1 0 Foi Cobrado? @! 1=Sim;0=Nao S
BA1_TXADOP C 1 0 Tx Ades.Opc. @! 1=Sim;0=Nao S
BA1_VLTXOP N 16 2 Vl.Tx Ad Opc @E 9,999,999,999,999.99 S
BA1_COBINI C 12 0 Cobranca Ini @! S
BA1_ANOMES C 6 0 Ano/Mes Ini @! S
BA1_INFCOB C 1 0 Inf.Cob. @! 1=Sim;0=Nao S
BA1_INFGCB C 1 0 Inf.Grp.Cob. @! 1=Sim;0=Nao S
BA1_INFPRE C 1 0 Inf.Pre-Exis @! 1=Sim;0=Nao S
BA1_NUMCER C 7 0 Num Certific @! S
BA1_CDIDEN C 12 0 Exp/Emi Id. @! S
BA1_NSUBFT C 4 0 Num SubFatur 9999 S
BA1_USRVIP C 1 0 Benef. VIP @! 1=Sim;0=Nao S
BA1_OPEORI C 4 0 Op. Origem @R !.!!! PLSVLDINT(M->BA1_OPEORI) B89PLS S
BA1_OPEDES C 4 0 Op. Destino @R !.!!! PLSVLDINT(M->BA1_OPEDES) B89PLS S
BA1_OPERES C 4 0 Op. Resp. @R !.!!! B89PLS S
BA1_LOCATE C 1 0 Atendimento @! 1=Origem;2=Destino S
BA1_LOCCOB C 1 0 Cobranca @! 1=Origem;2=Destino S
BA1_LOCEMI C 1 0 Carteirinha @! 1=Origem;2=Destino S
BA1_LOCANS C 1 0 ANS @! 1=Origem;2=Destino S
BA1_INFSIB C 1 0 Consid. SIB @! 1=Sim;0=Nao S
BA1_INFANS C 1 0 Consid. Ans @! 1=Sim;0=Nao S
BA1_LOCSIB C 1 0 Status ANS @! 0=N ENV;1=ATV;2=EXC;3=ENV INC;4=ENV ALT;5=ENV EXC;6=CRI INC;7=CRI ALT;8=CRI EXC;9=ENV MC;A=ENV REA;B=CRI MC;C=CRI REA S
BA1_ATUSIB C 1 0 Atualiza SIB @! 1=Sim;0=Nao S
BA1_DTVLCR D 8 0 Data Vld Car @D S
BA1_OK C 2 0 OK @C S
BA1_IMPORT C 20 0 Arq Importad @! S
BA1_DATTRA D 8 0 Data Transf. @D S
BA1_MATUSU C 16 0 Matric. Siga @R !.!!!.!!!!.!!!!!!-!!.! V S
BA1_EQUIPE C 3 0 Cod.Equipe @! (M->BA1_NOMEQ := "", Vazio()) .Or. PlsSeek("BXL",,, "M->BA1_NOMEQ", "BXL_DESEQU") .And. PLS260EQP("BA1") BXLPLS S
BA1_NOMEQ C 40 0 Nome Equipe @! V S
BA1_CODVEN C 6 0 Cod.Vendedor @! Vazio() .Or. (PlsSeek("SA3",1,M->BA1_CODVEN,"M->BA1_NOMVEN","A3_NOME") .and. PL903SA3("M->BA1_CODVEN")) SA3 S
BA1_NOMVEN C 40 0 Nome Vend. @! V S
BA1_CODVE2 C 6 0 Cod Vend 2 @! Vazio() .Or. (PlsSeek("SA3",1,M->BA1_CODVE2,"M->BA1_NOMVE2","A3_NOME") .and. PL903SA3("M->BA1_CODVE2")) SA3 R S
BA1_NOMVE2 C 40 0 Nome Vend 2 @! V S
BA1_FXCOB N 16 2 Valor Cob @E 9,999,999,999,999.99 S
BA1_OUTLAN C 1 0 Outros Lan. @! 1=Sim;0=Nao S
BA1_ESCOLA C 2 0 Escolaridade 99 Vazio() .Or. ExistCpo('SX5','26'+M->BA1_ESCOLA) 26 S
BA1_DESESC C 30 0 Desc Escolar @! V S
BA1_CDORIG C 16 0 Cod Origem @! R S
BA1_PSORIG C 3 0 Pst Origem @! R S
BA1_SOBRN C 30 0 Sobrenome @! R S
BA1_ARQEDI C 20 0 Arq. Imp EDI @! S
BA1_OBSERV C 30 0 Observacao @! R S
BA1_NUMENT C 10 0 Ent.Qualific @! BXAPLS R S
BA1_FILIAL C 2 0 Filial S
BA1_PLAINT C 4 0 Prod.Interc. @! B2IPLS S
BA1_DATREP D 8 0 Data Repasse S
BA1_MATUSB C 17 0 Matr.Ben.Blo @! S
BA1_STAEDI C 1 0 Status EDI @! 1=Enviar Novo;2=Re-envio;3=Enviado;4=Nao Enviar;5=Retorno M->BA3_TIPOUS = "2" S
BA1_PRIENV D 8 0 Dt.1o Envio @D S
BA1_ULTENV D 8 0 Dt.Ult.Envio @D S
BA1_CODERR C 4 0 Codigo Erro S
BA1_DATALT D 8 0 Ultima Alt S
BA1_FAICOB C 3 0 Fx Cobrada @! S
BA1_TIPINC C 1 0 Tipo de incl @! S
BA1_TRADES C 17 0 Dest. Transf @! S
BA1_TRAORI C 17 0 Orig. Transf @! S
BA1_LOTTRA C 4 0 Lote @! S
BA1_BLOFAT C 1 0 Bloq.Fatur.? @! 1=Sim;0=Nao S
BA1_OBTSIP C 4 0 Obto SIP @! vazio() .or. existcpo("SX5","BO"+M->BA1_OBTSIP) BO S
BA1_MATEDI C 17 0 Matr. EDI @! S
BA1_ENVANS D 8 0 Envio ANS @D S
BA1_INCANS D 8 0 Inscr. ANS @D S
BA1_EXCANS D 8 0 Exclusao ANS @D S
BA1_MOTTRA C 2 0 Mot. Transf? @! R 16=Transferencia Voluntaria;17=Transferencia Compulsoria;43=Mud. Portabilidade S
BA1_COBNIV C 1 0 Cb.Neste Niv @! R 1=Sim;0=Nao N
BA1_CODCLI C 6 0 Cod. Cliente @! Empty(M->BA1_CODCLI) .Or. ExistCpo("SA1",M->BA1_CODCLI) R PL260CF(5,"C") N
BA1_LOJA C 2 0 Loja @! (Empty(M->BA1_LOJA) .And. Empty(M->BA1_CODCLI)) .Or. ExistCpo("SA1",M->BA1_CODCLI+M->BA1_LOJA) R M->BA1_COBNIV == "1" N
BA1_NOMCLI C 40 0 Nome Cliente @! V N
BA1_VENCTO N 2 0 Dia Vencto. 99 Entre(01,31,M->BA1_VENCTO) .And. PLSA260Ven(M->BA3_CODINT,M->BA3_CODEMP,M->(BA3_CONEMP+BA3_VERCON),M->(BA3_SUBCON+BA3_VERSUB)) R M->BA1_COBNIV="1" N
BA1_CODFOR C 6 0 Fornecedor @! Empty(M->BA1_CODFOR) .Or. ExistCpo("SA2",M->BA1_CODFOR) SA2 R PL260CF(5,"F") N
BA1_LOJFOR C 2 0 Loja @! (Empty(M->BA1_LOJFOR) .And. Empty(M->BA1_CODFOR)) .Or. ExistCpo("SA2",M->BA2_CODFOR+M->BA1_LOJFOR) R N
BA1_NOMFOR C 40 0 Nome Fornec. @! V N
BA1_NOMTIT C 70 0 Nome Titular @! R N
BA1_ORIEND C 1 0 Orig. Endere @! IIf(Type("oBrwUsr") <> "O",.T.,Pls260AtEnd("BA1")) R 1=Titular;2=Cliente;3=Subcontrato;4=Vida;5=Resp. Fam N
BA1_SENHA C 20 0 Senha Portal @C R N
BA1_CODACE C 6 0 Acess Portal @C AI3 R N
BA1_DTVLCE D 8 0 D.Vld.Cr.Em @D R N
BA1_PLPOR C 9 0 Pln Portab. @! R S
BA1_CODCCO C 12 0 Cod. CCO @! R N
BA1_EMAIL C 30 0 E-mail @! R N
BA1_CODDEP C 2 0 Cod. Depend @! SRB R S
BA1_PACOOK C 1 0 Parcela @! R 0=Sim;1=Nao PL260WENC(1) S
BA1_TREGRA C 1 0 Tp. Regra @! PL260TREG() R 0=Segue regra;1=Fixa prazo;2=Fixa Valor PL260WENC(2) S
BA1_MESLIQ C 2 0 Mes Liqui. @99 M->BA1_MESLIQ $ '01,02,03,04,05,06,07,08,09,10,11,12' R PL260WENC(3) S
BA1_ANOLIQ C 4 0 Ano Liqui. @9999 Len(M->BA1_ANOLIQ) == 4 R PL260WENC(3) S
BA1_VLRFIX N 9 2 Vlr. Fixo @E 999,999.99 R PL260WENC(4) S
BA1_NREPAD C 20 0 Nš Proc Adm @! R S
BA1_CODTES C 3 0 Tipo Saida @! Vazio() .or. Existcpo('SF4').And. MaAvalTes('S',M->BA1_CODTES) SF4 R S
BA1_CODSB1 C 15 0 Produto ERP @! Vazio() .Or. SB1->(ExistCpo('SB1',M->BA1_CODSB1)) SB1 R S
BA1_EMIAVC D 8 0 Dt Emiss Avi R S
BA1_RECAVC D 8 0 Dt Receb Avi R S
BA1_DTRSIB D 8 0 Dt. Ret. SIB R S
BA1_PIPAMA C 11 0 PIS/PAS.Mae @! R S
BA1_DATADP D 8 0 Dt.Adaptacao R S
BA1_REEWEB C 1 0 Reem. Portal R 0=Nao;1=Sim S
BA1_TIPEND C 1 0 Tipo Enderec R 1=Profissional;2=Residencial PL260WEND('BA1') S
BA1_MUNRES C 7 0 Cd Mun Resid B57PLS R PL260WEND('BA1') .AND. M->BA1_TIPEND == '1' S
BA1_RESEXT C 1 0 R.Exterior? R 0=Nao reside no exterior;1=Reside no exterior PL260WEND('BA1') S
BA1_RESFAM C 1 0 Resp. Famili @! R 0=Nao;1=Sim S
BA1_NOMSOC C 50 0 Nome Social @! S
BA1_REMIDO C 1 0 Beneficiar R GETNEWPAR("MV_PLSUNI","0") =="1" S
BA1_COOPER C 1 0 Cooperado? R 0=Nao;1=Sim S
BA1_TIPTEL C 1 0 Tipo Telefon @! Pertence('123') .Or. Vazio() R 1=Residencial;2=Profissional;3=Celular S
BA1_CRINOM C 1 0 Cri. nome be @! 1=Sim;0=Nao S
BA1_CRIMAE C 1 0 Cri. mae ? @! 1=Sim;0=Nao S
BA1_NRCRNA C 15 0 Nr Cart Nac. PL955VALCNS("BA1") R S