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 |