Salve salve, blz?
Tabela GCM. #GCM
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 |
| GCM | DATA | GCM990 | Convênios x Planos | Convenios vs. Planes | Healthcares vs. Plans | | E | E | E | 0 | | | N | 51 | | | | 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 |
| GCM | 01 | GCM_FILIAL | C | 2 | 0 | Filial | Filial | | | | | 1 | | N | V | R | | | | | | 033 | |
| GCM | 02 | GCM_CODCON | C | 3 | 0 | Convenio | Codigo do Convenio | @! | | | | 1 | | N | V | R | | | | | | | |
| GCM | 03 | GCM_CODPLA | C | 6 | 0 | Plano | Plano do Convenio | @! | ExistChav("GCM",M->GCM_CODPLA) | If(Inclui .or. Altera,GETSX8NUM("GCM","GCM_CODPLA",,2), GCM_CODPLA) | | 1 | | S | V | R | | | | | | | |
| GCM | 04 | GCM_DESPLA | C | 30 | 0 | Desc. Plano | Descricao do Plano | @! | | | | 1 | | S | A | R | | | | | | | |
| GCM | 05 | GCM_ACOMOD | C | 1 | 0 | Acomodacao | Acomodacao | @! | Pertence('12') .And. HS_GdAtrib(oGCM, {{nGCMSTAREG, 'BR_AMARELO', 'BR_VERDE'}}) | | | 1 | | S | A | R | | 1=Enfermaria;2=Apartamento | | | | | |
| GCM | 06 | GCM_STATUS | C | 1 | 0 | Status | Status | @! | Pertence('01') .And. HS_VldA18('GCM') .And. HS_GdAtrib(oGCM, {{nGCMSTAREG, 'BR_AMARELO', 'BR_VERDE'}}) | If(Inclui,"0",GCM->GCM_STATUS) | | 1 | | S | A | R | | 0=Desativado;1=Ativado; | | | | | |
| GCM | 07 | GCM_VLDGUI | C | 50 | 0 | Vld. Guia | Validação da guia | @! | | | | 1 | | S | A | R | | | | | | | |
| GCM | 08 | GCM_LOGARQ | C | 40 | 0 | Log do Arq | Log do Arquivo | @! | | HS_LOGARQ() | | 1 | | N | A | R | | | | | | | |
| GCM | 09 | GCM_LAYOUT | C | 6 | 0 | Layout | Layout do Plano | @! | HS_VldA18("GCM") | | GG2001 | 1 | | S | A | R | | | | | | | |
| GCM | 10 | GCM_DSLOUT | C | 40 | 0 | Desc. Layout | Descricao do Layout | @! | | HS_IniPadr("GG2",1,GCM->GCM_LAYOUT,"GG2_DESCRI") | | 1 | | S | V | V | | | | | | | |
| GCM | 11 | GCM_TABMAT | C | 6 | 0 | Tab Mat | Tabela Material | @! | HS_VLDA18('GCM') | | GCA | 1 | | S | A | | | | | | | | |
| GCM | 12 | GCM_DESMAT | C | 60 | 0 | Desc Tab Mat | Descricao Tabela Mat | @! | | HS_INIPADR('GCA',1,GCM->GCM_TABMAT,'GCA_DESCRI') | | 1 | | S | V | V | | | | | | | |
| GCM | 13 | GCM_TABMED | C | 6 | 0 | Tab Med | Tabela Medicamento | @! | HS_VldA18('GCM') | | GCA | 1 | | S | A | R | | | | | | | |
| GCM | 14 | GCM_DESMED | C | 60 | 0 | Desc Tab Med | Descricao Tabela MED | @! | | HS_IniPadr('GCA',1,GCM->GCM_TABMED,'GCA_DESCRI') | | 1 | | S | V | V | | | | | | | |
| GCM | 15 | GCM_TABPRO | C | 6 | 0 | Tab Pro | Tabela Procedimento | @! | HS_VldA18('GCM') | | GDB | 1 | | S | A | R | | | | | | | |
| GCM | 16 | GCM_DESPRO | C | 60 | 0 | Desc Tab Pro | Descricao Tabela PRO | @! | | HS_IniPadr('GDB',1,GCM->GCM_TABPRO,'GDB_DESCRI') | | 1 | | S | V | V | | | | | | | |
| GCM | 17 | GCM_TABTXD | C | 6 | 0 | Tab Tax/Dia | Tabela Taxa/Diaria | @! | HS_VldA18('GCM') | | GD2 | 1 | | S | A | R | | | | | | | |
| GCM | 18 | GCM_DESTXD | C | 60 | 0 | Desc Tab Txd | Descricao Tabela TXD | @! | | HS_IniPadr('GD2',1,GCM->GCM_TABTXD,'GD2_DESCRI') | | 1 | | S | V | V | | | | | | | |
| GCM | 19 | GCM_CTAMED | C | 1 | 0 | Gera Cta Med | Gera Contas Médicas | | NaoVazio() | '0' | | 1 | | S | A | R | | 0=Não;1=Sim | | | | | |
SIX - INDICES
| INDICE | ORDEM | CHAVE | DESCRICAO | DESCSPA | DESCENG | PROPRI | F3 | NICKNAME | SHOWPESQ | IX_VIRTUAL | IX_VIRCUST |
| GCM | 1 | GCM_FILIAL+GCM_CODCON+GCM_CODPLA | Convenio + Plano | Convenio + Plan | Health Care + Health plan | S | | | S | 2 | 3 |
| GCM | 2 | GCM_FILIAL+GCM_CODPLA | Plano | Plan | Health plan | S | | | S | 2 | 3 |
| GCM | 3 | GCM_FILIAL+GCM_DESPLA | Desc. Plano | Desc. Plan | Description | S | | | S | 2 | 3 |
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
