Gatilhos(SX7) no Campo: BA1_MATVID |
X7_CAMPO | X7_SEQUENC | X7_REGRA | X7_CDOMIN | X7_TIPO | X7_SEEK | X7_ALIAS | X7_ORDEM | X7_CHAVE | X7_CONDIC |
BA1_MATVID | 001 | BTS->BTS_ESTCIV | BA1_ESTCIV | P | S | BTS | 1 | xFilial("BTS")+M->BA1_MATVID | |
BA1_MATVID | 002 | BTS->BTS_NOMUSR | BA1_NOMUSR | P | N | | 0 | | |
BA1_MATVID | 003 | BTS->BTS_CPFUSR | BA1_CPFUSR | P | N | | 0 | | |
BA1_MATVID | 004 | BTS->BTS_DRGUSR | BA1_DRGUSR | P | N | | 0 | | |
BA1_MATVID | 005 | BTS->BTS_DATNAS | BA1_DATNAS | P | N | | 0 | | |
BA1_MATVID | 006 | Pls260DEnd("BTS_CEPUSR") | BA1_CEPUSR | P | N | | 0 | | |
BA1_MATVID | 007 | Pls260DEnd("BTS_ENDERE") | BA1_ENDERE | P | N | | 0 | | |
BA1_MATVID | 008 | Pls260DEnd("BTS_NR_END") | BA1_NR_END | P | N | | 0 | | |
BA1_MATVID | 009 | Pls260DEnd("BTS_COMEND") | BA1_COMEND | P | N | | 0 | | |
BA1_MATVID | 010 | Pls260DEnd("BTS_CODMUN") | BA1_CODMUN | P | N | | 0 | | |
BA1_MATVID | 011 | Pls260DEnd("BTS_MUNICI") | BA1_MUNICI | P | N | | 0 | | |
BA1_MATVID | 012 | Pls260DEnd("BTS_ESTADO") | BA1_ESTADO | P | N | | 0 | | |
BA1_MATVID | 013 | BTS->BTS_TELEFO | BA1_TELEFO | P | N | | 0 | | |
BA1_MATVID | 014 | BTS->BTS_UNIVER | BA1_UNIVER | P | N | | 0 | | |
BA1_MATVID | 015 | BTS->BTS_PAI | BA1_PAI | P | N | | 0 | | |
BA1_MATVID | 016 | BTS->BTS_MAE | BA1_MAE | P | N | | 0 | | |
BA1_MATVID | 017 | BTS->BTS_CPFMAE | BA1_CPFMAE | P | N | | 0 | | |
BA1_MATVID | 018 | BTS->BTS_CPFPAI | BA1_CPFPAI | P | N | | 0 | | |
BA1_MATVID | 019 | BTS->BTS_DATMAE | BA1_DATMAE | P | N | | 0 | | |
BA1_MATVID | 020 | BTS->BTS_DATPAI | BA1_DATPAI | P | N | | 0 | | |
BA1_MATVID | 021 | BTS->BTS_NOMPRE | BA1_NOMPRE | P | N | | 0 | | |
BA1_MATVID | 022 | BTS->BTS_CORNAT | BA1_CORNAT | P | N | | 0 | | |
BA1_MATVID | 023 | BTS->BTS_SANGUE | BA1_SANGUE | P | N | | 0 | | |
BA1_MATVID | 024 | BTS->BTS_CODFUN | BA1_CODFUN | P | N | | 0 | | |
BA1_MATVID | 025 | BTS->BTS_INSALU | BA1_INSALU | P | N | | 0 | | |
BA1_MATVID | 026 | BTS->BTS_CODSET | BA1_CODSET | P | N | | 0 | | |
BA1_MATVID | 027 | BTS->BTS_PESO | BA1_PESO | P | N | | 0 | | |
BA1_MATVID | 028 | BTS->BTS_ALTURA | BA1_ALTURA | P | N | | 0 | | |
BA1_MATVID | 029 | BTS->BTS_OBESO | BA1_OBESO | P | N | | 0 | | |
BA1_MATVID | 030 | DateDiffYear(dDataBase, If(Type("M->BA1_DATNAS")=="D",M->BA1_DATNAS,BA1->BA1_DATNAS)) | BA1_IDADE | P | N | | 0 | | |
BA1_MATVID | 031 | BTS->BTS_SEXO | BA1_SEXO | P | N | | 0 | | |
BA1_MATVID | 032 | Pls260DEnd("BTS_BAIRRO") | BA1_BAIRRO | P | N | | 0 | | |
BA1_MATVID | 033 | BTS->BTS_CPFPRE | BA1_CPFPRE | P | N | | 0 | | |
BA1_MATVID | 034 | BTS->BTS_PISPAS | BA1_PISPAS | P | N | | 0 | | |
BA1_MATVID | 035 | BTS->BTS_DDD | BA1_DDD | P | N | | 0 | | |
BA1_MATVID | 036 | BTS->BTS_ORGEM | BA1_ORGEM | P | N | | 0 | | |
BA1_MATVID | 037 | X5DESCRI() | BA1_DESCIV | P | S | SX5 | 1 | xFilial("SX5")+ "33" + M->BA1_ESTCIV | |
BA1_MATVID | 038 | X5DESCRI() | BA1_DESCIV | P | S | SX5 | 1 | xFilial("SX5")+ "33" + M->BA1_ESTCIV | |