Tabela |
FLF |
Prestacao de Contas |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
FLF_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
FLF_TIPO |
C |
1 |
0 |
Tipo |
@! |
Pertence("12") |
|
R |
1=Viagem;2=Avulsa |
|
S |
FLF_PRESTA |
C |
10 |
0 |
Pres. Contas |
@! |
|
|
R |
|
|
S |
FLF_VIAGEM |
C |
10 |
0 |
Cod. Viagem |
@! |
|
|
R |
|
|
S |
FLF_ITEM |
C |
2 |
0 |
Item |
@! |
|
|
|
|
|
S |
FLF_PARTIC |
C |
6 |
0 |
Cod. Partic. |
@! |
|
|
R |
|
|
S |
FLF_NOMEPA |
C |
40 |
0 |
Participante |
@! |
|
|
V |
|
|
S |
FLF_EMISSA |
D |
8 |
0 |
Emissao |
|
|
|
R |
|
|
S |
FLF_DTINI |
D |
8 |
0 |
Saida |
|
|
|
R |
|
M->FLF_TIPO == "2" |
S |
FLF_DTFIM |
D |
8 |
0 |
Chegada |
|
|
|
R |
|
M->FLF_TIPO == "2" |
S |
FLF_NACION |
C |
1 |
0 |
Nacional |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
M->FLF_TIPO == "2" |
S |
FLF_MOTIVO |
M |
10 |
0 |
Motivo |
|
|
|
R |
|
|
S |
FLF_CLIENT |
C |
6 |
0 |
Cliente |
@! |
Vazio() .OR. ExistCpo("SA1",M->FLF_CLIENT) |
SA1 |
R |
|
M->FLF_TIPO == "2" |
S |
FLF_LOJA |
C |
2 |
0 |
Loja |
@! |
IIF(Vazio(),.T., ExistCpo("SA1",M->FLF_CLIENT+M->FLF_LOJA)) |
|
R |
|
M->FLF_TIPO == "2" |
S |
FLF_RAZAO |
C |
40 |
0 |
Nome Cliente |
@! |
|
|
V |
|
|
S |
FLF_CC |
C |
9 |
0 |
Centro Custo |
@! |
Vazio() .Or. ExistCpo('CTT') |
CTT |
R |
|
M->FLF_TIPO == "2" |
S |
FLF_DTFECH |
D |
8 |
0 |
Fechamento |
|
|
|
R |
|
|
S |
FLF_STATUS |
C |
1 |
0 |
Status |
|
|
|
R |
|
|
S |
FLF_FATCLI |
N |
3 |
0 |
% Cliente |
@E 999 |
Positivo() .And. (M->FLF_FATCLI + M->FLF_FATEMP) <= 100 |
|
R |
|
M->FLF_TIPO == "2" |
S |
FLF_FATEMP |
N |
3 |
0 |
% Empresa |
@E 999 |
Positivo() .And. (M->FLF_FATCLI + M->FLF_FATEMP) <= 100 |
|
R |
|
M->FLF_TIPO == "2" |
S |
FLF_RECPAG |
C |
1 |
0 |
Receb/Pagam |
@! |
Pertence("PR") |
|
R |
|
|
S |
FLF_CONFER |
C |
6 |
0 |
Cod. Confer. |
@! |
ExistCpo("RD0") |
RD0 |
R |
|
|
S |
FLF_NOMECF |
C |
40 |
0 |
Conferente |
@! |
|
|
V |
|
|
S |
FLF_DTCONF |
D |
8 |
0 |
Conferencia |
|
|
|
R |
|
|
S |
FLF_OBCONF |
C |
100 |
0 |
Obs. Confer. |
|
|
|
R |
|
|
S |
FLF_CLIFOR |
C |
6 |
0 |
Cli/For |
@! |
|
|
R |
|
|
S |
FLF_FLOJA |
C |
2 |
0 |
Loja Cli/For |
@! |
|
|
R |
|
|
S |
FLF_PREFIX |
C |
3 |
0 |
Prefixo |
@! |
|
|
R |
|
|
S |
FLF_TIPTIT |
C |
3 |
0 |
Tipo Titulo |
@! |
|
|
R |
|
|
S |
FLF_TITULO |
C |
9 |
0 |
Num. Titulo |
@! |
|
|
R |
|
|
S |
FLF_PARCEL |
C |
2 |
0 |
Parcela |
@! |
|
|
R |
|
|
S |
FLF_PEDIDO |
C |
6 |
0 |
Pedido |
@! |
|
|
R |
|
|
S |
FLF_VALCOB |
N |
14 |
2 |
Vlr Cobrado |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
FLF_TDESP1 |
N |
15 |
2 |
Tot. Desp. 1 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TDESP2 |
N |
15 |
2 |
Tot. Desp. 2 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TDESP3 |
N |
15 |
2 |
Tot. Desp. 3 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TVLRE1 |
N |
15 |
2 |
Tot.Reemb.1 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TVLRE2 |
N |
15 |
2 |
Tot.Reemb. 2 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TVLRE3 |
N |
15 |
2 |
Tot.Reemb. 3 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TDESC1 |
N |
15 |
2 |
Tot. Desco 1 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TDESC2 |
N |
15 |
2 |
Tot. Desco 2 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_STATMX |
C |
1 |
0 |
Fecham.Moeda |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
FLF_TDESC3 |
N |
15 |
2 |
Tot. Desco 3 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TADIA1 |
N |
15 |
2 |
Tot. Adia.M1 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TADIA2 |
N |
15 |
2 |
Tot. Adia M2 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_TADIA3 |
N |
15 |
2 |
Tot. Adia M3 |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
FLF_DTBAIX |
D |
8 |
0 |
Dt Baixa |
|
|
|
R |
|
|
S |
FLF_ABONO |
C |
1 |
0 |
Abono |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
FLF_ITECTA |
C |
9 |
0 |
Item Contab. |
@! |
(Vazio() .OR. Ctb105Item()) |
CTD |
R |
|
CtbInUse() |
S |
FLF_DSITCT |
C |
50 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
FLF_CLVL |
C |
9 |
0 |
Classe Valor |
@! |
(Vazio() .OR. Ctb105Clvl()) |
CTH |
R |
|
CtbInUse() |
S |
FLF_DSCLVL |
C |
50 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
FLF_TXTUR2 |
N |
6 |
2 |
Dolar Turis. |
@E 999.99 |
Positivo() |
|
R |
|
|
S |
FLF_TXTUR3 |
N |
6 |
2 |
Euro Turismo |
@E 999.99 |
Positivo() |
|
R |
|
|
S |
FLF_WFKID |
C |
100 |
0 |
Workflow ID |
@! |
|
|
R |
|
|
S |
FLF_MOTVFL |
C |
80 |
0 |
Motivo Rej. |
@! |
|
|
R |
|
|
S |
FLF_SERIE |
C |
3 |
0 |
Serie |
!!! |
|
|
R |
|
|
S |
FLF_DOC |
C |
9 |
0 |
Documento |
@! |
|
|
R |
|
|
S |
FLF_LA |
C |
1 |
0 |
LA |
@! |
|
|
R |
|
|
S |