| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| G3D | Cartao Turismo | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| G3D_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| G3D_CODIGO | C | 6 | 0 | Codigo | @! | R | INCLUI | S | |||
| G3D_DESCR | C | 60 | 0 | Descricao | @! | R | S | ||||
| G3D_TIPO | C | 6 | 0 | Classific. | @! | ExistCpo('G8Q',FWFldGet('G3D_TIPO')) | G8Q | R | INCLUI | S | |
| G3D_NCARD | C | 32 | 0 | Num. Cartao | @R 9999.9999.9999.9999 | Len (Alltrim (FWFLDGET('G3D_NCARD'))) >= 4 | R | INCLUI | S | ||
| G3D_NRESU | C | 19 | 0 | Num. Cartao | @R****.****.****.9999 | R | S | ||||
| G3D_CODSEG | C | 8 | 0 | Cod. Segur. | @* | Len (Alltrim (FWFLDGET('G3D_CODSEG'))) <= 4 | R | INCLUI | S | ||
| G3D_MVALID | C | 2 | 0 | Mes Validade | 99 | Vazio() .Or. (Val(FWFldGet("G3D_MVALID"))>=1 .And. Val(FWFldGet("G3D_MVALID"))<=12) | R | S | |||
| G3D_AVALID | C | 4 | 0 | Ano Validade | 9999 | TA004VLDDT(FwFldGet("G3D_AVALID")) | R | S | |||
| G3D_TITULA | C | 60 | 0 | Titular | @! | R | S | ||||
| G3D_CODBAN | C | 2 | 0 | Cod. Band. | @! | ExistCpo('SX5', 'L9'+ FWFldGet('G3D_CODBAN')) | L9 | R | INCLUI | S | |
| G3D_BAND | C | 20 | 0 | Bandeira | @! | V | S | ||||
| G3D_CONC | C | 1 | 0 | Concilia | @! | Pertence('12') | R | 1=Sim;2=Nao | S | ||
| G3D_DCONC | C | 2 | 0 | Dia Concilia | 99 | Vazio() .Or. ( Val(M->G3D_DCONC) >= 1 .And. Val(M->G3D_DCONC) <= 31 ) | R | FwFldGet('G3D_CONC') == '1' | S | ||
| G3D_PCONC | C | 3 | 0 | Prazo Conc. | 999 | Vazio() .Or. ( Val(M->G3D_PCONC) >= 1 .And. Val(M->G3D_PCONC) <= 999 ) | R | FWFldGet('G3D_CONC') == '1' | S | ||
| G3D_DFECHA | N | 2 | 0 | Dia Fecham. | 99 | FWFldGet('G3D_DFECHA') >= 0 .and. FWFldGet('G3D_DFECHA') <= 31 | R | S | |||
| G3D_DVENC | N | 2 | 0 | Dia Vencto | 99 | FWFldGet('G3D_DVENC') >= 0 .and. FWFldGet('G3D_DVENC') <= 31 | R | S | |||
| G3D_DIADE | N | 2 | 0 | Dia De | 99 | FWFldGet('G3D_DIADE') >= 1 .and. FWFldGet('G3D_DIADE') <= 31 | R | S | |||
| G3D_DIAATE | N | 2 | 0 | Dia Ate | 99 | FwFldGet('G3D_DIAATE') >= 1 .and. FwFldGet('G3D_DIAATE') <= 31 | R | S | |||
| G3D_CODFOR | C | 6 | 0 | Cod. Fornec. | @! | ExistCpo('SA2',FWFldGet('G3D_CODFOR')) | SA2A | R | S | ||
| G3D_LJFOR | C | 2 | 0 | Loja | @! | ExistCpo('SA2',FWFldGet('G3D_CODFOR')+FWFldGet('G3D_LJFOR')) | R | S | |||
| G3D_FORNEC | C | 40 | 0 | Fornecedor | @! | V | S | ||||
| G3D_CORP | L | 1 | 0 | Corporativo | R | S | |||||
| G3D_EVENTO | L | 1 | 0 | Eventos | R | S | |||||
| G3D_LAZER | L | 1 | 0 | LAZER | R | S | |||||
| G3D_DESCTP | C | 40 | 0 | Desc. Classi | @! | V | S | ||||
| G3D_MSBLQL | C | 1 | 0 | Bloqueado? | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||