Salve salve, blz?
Tabela BDX. #BDX
SX2 - TABELA
| X2_CHAVE | X2_PATH | X2_ARQUIVO | X2_NOME | X2_NOMESPA | X2_NOMEENG | X2_ROTINA | X2_MODO | X2_MODOUN | X2_MODOEMP | X2_DELET | X2_TTS | X2_UNICO | X2_PYME | X2_MODULO | X2_DISPLAY | X2_SYSOBJ | X2_USROBJ | X2_POSLGT | X2_CLOB | X2_AUTREC | X2_TAMFIL | X2_TAMUN | X2_TAMEMP | X2_STAMP | X2_INSDT |
| BDX | DATA | BDX990 | Glosas das Movimentações | Glosas de los Movimientos | Transaction disallowances | | C | E | E | 0 | | | N | 33 | BDX_CODOPE+BDX_CODLDP+BDX_CODPEG+BDX_NUMERO+BDX_ORIMOV+BDX_CODPAD+BDX_CODPRO+BDX_SEQUEN | | | 1 | 2 | 2 | 2 | 0 | 0 |
SX3 - CAMPOS
| X3_ARQUIVO | X3_ORDEM | X3_CAMPO | X3_TIPO | X3_TAMANHO | X3_DECIMAL | X3_TITULO | X3_DESCRIC | X3_PICTURE | X3_VALID | X3_RELACAO | X3_F3 | X3_NIVEL | X3_TRIGGER | X3_BROWSE | X3_VISUAL | X3_CONTEXT | X3_OBRIGAT | X3_CBOX | X3_PICTVAR | X3_WHEN | X3_INIBRW | X3_GRPSXG | X3_FOLDER |
| BDX | 01 | BDX_FILIAL | C | 2 | 0 | Filial | Filial | | | | | 1 | | | | | | | | | | 033 | |
| BDX | 02 | BDX_IMGCRI | C | 13 | 0 | | Image Status | @BMP | | Iif( BDX->BDX_TIPREG=="2","",IiF(BDX->BDX_CRIANA == '1' ,"ENABLE","DISABLE") ) | | 1 | | | V | V | | | | | | | |
| BDX | 03 | BDX_IMGSTA | C | 13 | 0 | Status | Image Status | @BMP | | "DISABLE" | | 1 | | | V | | | | | | | | |
| BDX | 04 | BDX_SEQUEN | C | 3 | 0 | Item | Item | @! | | BD6->BD6_SEQUEN | | 1 | | S | V | | | | | | | | |
| BDX | 05 | BDX_CODOPE | C | 4 | 0 | Operadora | Operadora | @! | | | | 1 | | S | V | R | | | | | | | |
| BDX | 06 | BDX_CODLDP | C | 4 | 0 | Cd Local Dig | Codigo Local Digitacao | @! | | | | 1 | | S | V | R | | | | | | | |
| BDX | 07 | BDX_CODPEG | C | 8 | 0 | Codigo PEG | Codigo PEG | @! | | | | 1 | | S | V | R | | | | | | | |
| BDX | 08 | BDX_NUMERO | C | 8 | 0 | Numero | Numero da Movimentacao | @! | | | | 1 | | S | V | R | | | | | | | |
| BDX | 09 | BDX_NIVEL | C | 1 | 0 | Nivel | Nivel | @! | | | | 1 | | | V | | | 1=Guia;2=Eventos | | | | | |
| BDX | 10 | BDX_CODPAD | C | 2 | 0 | Cod Tipo Tab | Codigo Tipo Padrao Saude | @! | | BD6->BD6_CODPAD | | 1 | | | V | | | | | | | | |
| BDX | 11 | BDX_CODPRO | C | 16 | 0 | Cod Proced. | Codigo Procedimento | @! | | BD6->BD6_CODPRO | | 1 | | | V | | | | | | | | |
| BDX | 12 | BDX_DESPRO | C | 40 | 0 | Desc.Proced. | Descricao do Procedimento | @! | | | | 1 | | | V | | | | | | | | |
| BDX | 13 | BDX_CODGLO | C | 3 | 0 | Cod Glosa | Codigo da Glosa | @! | PlsSeek("BCT",1,PLSINTPAD()+M->BDX_CODGLO) .And. PLSVLDGD() | | | 1 | S | | V | | | | | | | | |
| BDX | 14 | BDX_DESGLO | C | 120 | 0 | Desc Glosa | Descricao da Glosa | @C | | | | 1 | | | V | | | | | VldCritica() | | | |
| BDX | 15 | BDX_ACAO | C | 1 | 0 | Acao | Acao | @! | | | | 1 | S | | | | | 1=Glosar;2=Reconsiderar | | ChecaAcao() | | | |
| BDX | 16 | BDX_INFGLO | C | 120 | 0 | Infor Glosa | Informacoes da Glosa | @C | | | | 1 | | | V | | | | | | | | |
| BDX | 17 | BDX_PERGLO | N | 9 | 2 | Percentual % | Percentual | @E 999,999.99 | M->BDX_PERGLO > 0 .and. M->BDX_PERGLO <= 100 | | | 1 | S | | | | | | | M->BDX_ACAO=='1' | | | |
| BDX | 18 | BDX_VLRGLO | N | 16 | 2 | Valor Glosa | Valor da Glosa | @E 9,999,999,999,999.99 | M->BDX_VLRGLO > 0 .and. M->BDX_VLRGLO <= (BDX->BDX_VLRMAN + BDX->BDX_VLRGLO) | | | 1 | S | | | | | | | M->BDX_ACAO=='1' | | | |
| BDX | 19 | BDX_RESPAL | C | 120 | 0 | Justificar | Justificar | @! | | | | 1 | | | | | | | | | | | |
| BDX | 20 | BDX_ACAOTX | C | 1 | 0 | Acao Dif Tax | Acao Taxa | @! | | | | 1 | S | | | | | 1=Glosar Tx;2=Reconsiderar Tx | | ChecaAcao() | | | |
| BDX | 21 | BDX_PERGTX | N | 7 | 2 | Percen. % Tx | Percentual Taxa | @E 9,999.99 | M->BDX_PERGTX > 0 .and. M->BDX_PERGTX <= 100 | | | 1 | S | | | | | | | M->BDX_ACAOTX=='1' | | | |
| BDX | 22 | BDX_VLRGTX | N | 16 | 2 | Vlr. Glo. Tx | Valor da Glosa Taxa | @E 9,999,999,999,999.99 | PLSVLGTX() | | | 1 | S | | | | | | | M->BDX_ACAOTX=='1' | | | |
| BDX | 23 | BDX_VLRMAN | N | 16 | 2 | Vlr Bs Pagto | Valor Base Pagamento | @E 9,999,999,999,999.99 | | BD6->BD6_VLRMAN | | 1 | | | V | | | | | | | | |
| BDX | 24 | BDX_VLRBPR | N | 16 | 2 | Valor Contr. | Valor Contrato Prestador | @E 9,999,999,999,999.99 | | BD6->BD6_VLRBPR | | 1 | | | V | | | | | | | | |
| BDX | 25 | BDX_VLRPAG | N | 16 | 2 | Valor Pagto | Valor Pagto | @E 9,999,999,999,999.99 | | BD6->BD6_VLRPAG | | 1 | | | V | | | | | | | | |
| BDX | 26 | BDX_VLRAPR | N | 16 | 2 | Vlr Apresent | Vlr Apresentado | @E 9,999,999,999,999.99 | | nVlrPag | | 1 | | | V | | | | | | | | |
| BDX | 27 | BDX_GLTXPG | C | 1 | 0 | Acao Tx Pg? | Acao | @! | | | | 1 | | N | | | | | | | | | |
| BDX | 28 | BDX_VLTXPG | N | 16 | 2 | Vlr.Taxa Cal | Vlr. Tx Pagto | @E 9,999,999,999,999.99 | | BD6->BD6_VLTXPG | | 1 | | | V | R | | | | | | | |
| BDX | 29 | BDX_VLTXAP | N | 16 | 2 | Vlr.Taxa Apr | Vlr. Tx Apres. | @E 9,999,999,999,999.99 | | BD6->BD6_VLTXAP | | 1 | | | V | R | | | | | | | |
| BDX | 30 | BDX_GLOSIS | C | 3 | 0 | Glosa Sist. | Glosa Sugerida Sistema | @! | | | | 1 | | | V | | | | | | | | |
| BDX | 31 | BDX_TIPREG | C | 1 | 0 | Tipo Reg. | Tipo Registro | @! | | | | 1 | | | V | | | 1=Principal;2=Descritivos | | | | | |
| BDX | 32 | BDX_CRIANA | C | 1 | 0 | Crit. Analis | Critica Analisada | @! | | "0" | | 1 | | | | | | 1=Sim;0=Nao | | VldCritica() | | | |
| BDX | 33 | BDX_TIPGLO | C | 1 | 0 | Tp Glosa | Tipo de Glosa | @! | | "2" | | 1 | | | V | | | 1=Eletronica;2=Manual;3=Automatica | | | | | |
| BDX | 34 | BDX_ORIMOV | C | 1 | 0 | Origem Movto | Origem do Movimento | @! | | | | 1 | | S | V | R | | 1=Guias de Consultas/Servicos;2=Guia de Internacao;3=Outros;4=Autorizacao Odontologica;5=Dig. Off-Line;6=Novo Autorizador | | | | | |
| BDX | 35 | BDX_DTACAO | D | 8 | 0 | Data Acao | Data da Acao | | | dDatabase | | 1 | | | V | | | | | | | | |
| BDX | 36 | BDX_CODTPA | C | 2 | 0 | Tipo PF | Tipo de Part. Financeira | @! | | | | 1 | | S | V | R | | | | | | | |
| BDX | 37 | BDX_VLRAP2 | N | 16 | 2 | Valor Apres. | Valor Apresentado | @E 9,999,999,999,999.99 | | | | 1 | | N | A | R | | | | | | | |
| BDX | 38 | BDX_VLRBP2 | N | 16 | 2 | Valor Contr. | Vlr Contrato Prest. | @E 9,999,999,999,999.99 | | | | 1 | | N | V | R | | | | | | | |
| BDX | 39 | BDX_VLRGL2 | N | 16 | 2 | Valor Glosa | Valor da Glosa | @E 9,999,999,999,999.99 | | | | 1 | | N | A | R | | | | M->BDX_GLACAO=='1' | | | |
| BDX | 40 | BDX_VLRMA2 | N | 16 | 2 | Vlr Bs Pagto | Valor Base Pagamento | @E 9,999,999,999,999.99 | | | | 1 | | N | A | R | | | | | | | |
| BDX | 41 | BDX_VLRPA2 | N | 16 | 2 | Valor Pagto | Valor Pagto | @E 9,999,999,999,999.99 | | | | 1 | | N | A | R | | | | | | | |
| BDX | 42 | BDX_QTDINF | N | 16 | 0 | Qtd Inf. | Quantidade Informada | @E 9,999,999,999,999,999 | | | | 1 | | S | V | R | | | | | | | |
| BDX | 43 | BDX_VLRINF | N | 16 | 2 | Vlr Inf. | Valor Informado | @E 9,999,999,999,999.99 | | | | 1 | | S | V | R | | | | | | | |
| BDX | 44 | BDX_GLACAO | C | 1 | 0 | Acao | Acao | @! | | | | 1 | | N | A | R | | 1=Glosar;2=Reconsiderar | | | | | |
| BDX | 45 | BDX_VLGREA | N | 16 | 2 | Vlr. Glosa | Valor de Glosa | @E 9,999,999,999,999.99 | | | | 1 | | N | V | | | | | | | | |
| BDX | 46 | BDX_PERGL2 | N | 6 | 2 | Percent. % | Percentual | @E 999.99 | M->BDX_PERGL2 <= 100 | | | 1 | | N | A | R | | | | M->BDX_GLACAO=='1' | | | |
| BDX | 47 | BDX_QTDPRO | N | 16 | 0 | Qtd Proc. | Quantidade Realizada | @E 9,999,999,999,999,999 | | | | 1 | | S | V | R | | | | | | | |
| BDX | 48 | BDX_QTDGLO | N | 16 | 0 | Glosa Qtde | Quantidade de Glosa | @E 9,999,999,999,999,999 | M->BDX_QTDGLO <= M->BDX_QTDPRO | | | 1 | | S | A | R | | | | | | | |
| BDX | 49 | BDX_QTDREC | N | 16 | 0 | Recons. Qtde | Reconsiderar Quantidade | @E 9,999,999,999,999,999 | M->BDX_QTDREC <= M->BDX_QTDPRO .And. PLS500VGL() | | | 1 | | S | A | R | | | | | | | |
| BDX | 50 | BDX_VGTXRE | N | 16 | 2 | Recons. Taxa | Reconsidera Taxa | @E 9,999,999,999,999.99 | | | | 1 | | | | | | | | | | | |
| BDX | 51 | BDX_VLRREC | N | 16 | 2 | Recons. Glos | Reconsidera Glosa | @E 9,999,999,999,999.99 | M->BDX_VLRREC <= M->BDX_VLRMA2 .And. PLS500VGL() | | | 1 | | N | A | R | | | | | | | |
| BDX | 52 | BDX_DATPRO | D | 8 | 0 | Dt. Proced. | Data Proced. | | | | | 1 | | S | V | R | | | | | | | |
| BDX | 53 | BDX_OBS | M | 10 | 0 | observ | observação | @M | | | | 1 | | N | A | R | | | | | | | |
| BDX | 54 | BDX_REGREC | C | 1 | 0 | Registro rec | Registro recuperado | @! | | | | 1 | | N | V | R | | | | | | | |
| BDX | 55 | BDX_TAG550 | C | 35 | 0 | Tag A500 | Tag A500 | @C | | | | 1 | | S | A | R | | | | | | | |
SIX - INDICES
| INDICE | ORDEM | CHAVE | DESCRICAO | DESCSPA | DESCENG | PROPRI | F3 | NICKNAME | SHOWPESQ | IX_VIRTUAL | IX_VIRCUST |
| BDX | 1 | BDX_FILIAL+BDX_CODOPE+BDX_CODLDP+BDX_CODPEG+BDX_NUMERO+BDX_ORIMOV+BDX_CODPAD+BDX_CODPRO+BDX_SEQUEN+BDX_CODGLO | Operadora + Cd Local Dig + Codigo PEG + Numero + Origem Movto + Cod Ti | Operadora + Cd Local Dig + Codigo PEG + Numero + Origen Movim + Cod Ti | Operator + Ent.Loc.Code + PEG Code + Number + Transact.Or. + TableTp.C | S | | | S | 2 | 3 |
| BDX | 2 | BDX_FILIAL+BDX_CODOPE+BDX_CODLDP+BDX_CODPEG+BDX_NUMERO+BDX_ORIMOV+BDX_CODPAD+BDX_CODPRO+BDX_SEQUEN+BDX_CODGLO+BDX_TIPREG+BDX_INFGLO | Operadora + Cd Local Dig + Codigo PEG + Numero + Origem Movto + Cod Ti | Operadora + Cd Local Dig + Codigo PEG + Numero + Origen Movim + Cod Ti | Operator + Ent.Loc.Code + PEG Code + Number + Transact.Or. + TableTp.C | S | | | S | 2 | 3 |
| BDX | 3 | BDX_FILIAL+BDX_CODOPE+BDX_CODLDP+BDX_CODPEG+BDX_NUMERO+BDX_ORIMOV+BDX_TIPGLO+BDX_SEQUEN | Operadora + Cd Local Dig + Codigo PEG + Numero + Origem Movto + Tp Glo | Operadora + Cd Local Dig + Codigo PEG + Numero + Origen Movim + Tp Glo | Operator + Ent.Loc.Code + PEG Code + Number + Transact.Or. + DisallowT | S | | | S | 2 | 3 |
| BDX | 4 | BDX_FILIAL+BDX_CODOPE+BDX_CODLDP+BDX_CODPEG+BDX_NUMERO+BDX_ORIMOV+BDX_SEQUEN+BDX_CODPAD+BDX_CODPRO+BDX_TIPGLO | Operadora + Cd Local Dig + Codigo PEG + Numero + Origem Movto + Item + | Operadora + Cd Local Dig + Codigo PEG + Numero + Origen Movim + Item + | Operator + Ent.Loc.Code + PEG Code + Number + Transact.Or. + Item + Ta | S | | | S | 2 | 3 |
| BDX | 5 | BDX_FILIAL+BDX_CODOPE+BDX_CODLDP+BDX_CODPEG+BDX_NUMERO+BDX_ORIMOV+BDX_SEQUEN+BDX_TIPREG | Operadora + Cd Local Dig + Codigo PEG + Numero + Origem Movto + Item + | Operadora + Cd Local Dig + Codigo PEG + Numero + Origen Movim + Item + | Operator + Ent.Loc.Code + PEG Code + Number + Transact.Or. + Item + Re | S | | | S | 2 | 3 |
SX7 - GATILHOS
| X7_CAMPO | X7_SEQUENC | X7_REGRA | X7_CDOMIN | X7_TIPO | X7_SEEK | X7_ALIAS | X7_ORDEM | X7_CHAVE | X7_CONDIC | X7_PROPRI |
| BDX_ACAO | 001 | PL498MANT('1') | BDX_PERGLO | P | N | | 0 | | | S |
| BDX_ACAOTX | 001 | PL498MANT("2") | BDX_PERGTX | P | N | | 0 | | | S |
| BDX_CODGLO | 001 | BCT->BCT_DESCRI | BDX_DESGLO | P | N | | 0 | | | S |
| BDX_PERGLO | 001 | PL498MANT("3") | BDX_VLRGLO | P | N | | 0 | | | S |
| BDX_PERGTX | 001 | PL498MANT("5") | BDX_VLRGTX | P | N | | 0 | | | S |
| BDX_VLRGLO | 001 | PL498MANT("4") | BDX_PERGLO | P | N | | 0 | | | S |
| BDX_VLRGTX | 001 | PL498MANT("6") | BDX_PERGTX | P | N | | 0 | | | S |
SXG - Grupo de Campos
| XG_GRUPO | XG_DESCRI | XG_DESSPA | XG_DESENG | XG_SIZEMAX | XG_SIZEMIN | XG_SIZE | XG_PICTURE |
| 033 | Tamanho da Filial | Tamano de la Sucursal | Branch Size | 12 | 2 | 2 | |
Gostou? Compartilhe com seus amigos e deixe um comentário! ??
Um abraço, e até a próxima
