Tabela |
BDC |
Cabecalho de Cobranca |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
BDC_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
BDC_CODOPE |
C |
4 |
0 |
Operadora |
@! |
(lRet := PLSVLDINT(M->BDC_CODOPE), If(lRet, (cCodInt := M->BDC_CODOPE, .T.), .F.)) |
B89PLS |
|
|
Pls625Ope() |
S |
BDC_DESOPE |
C |
40 |
0 |
Descricao |
|
|
|
V |
|
|
S |
BDC_NUMERO |
C |
8 |
0 |
Numero Seq. |
@! |
ExistChav("BDC",M->BDC_CODOPE+M->BDC_NUMERO,1) |
|
|
|
|
S |
BDC_DATGER |
D |
8 |
0 |
Data Geracao |
@D |
|
|
|
|
|
S |
BDC_USUOPE |
C |
25 |
0 |
Operador |
|
|
|
|
|
|
S |
BDC_HORA |
C |
8 |
0 |
Hora Inicial |
@! |
|
|
|
|
|
S |
BDC_HORAF |
C |
8 |
0 |
Hora final |
@! |
|
|
|
|
|
S |
BDC_ANOINI |
C |
4 |
0 |
Ano Inicial |
9999 |
|
|
|
|
|
S |
BDC_MESINI |
C |
2 |
0 |
Mes Inicial |
99 |
Vazio() .or. M->BDC_MESINI >= "01" .And. M->BDC_MESINI <= "12" |
|
|
|
|
S |
BDC_ANOFIM |
C |
4 |
0 |
Ano Final |
9999 |
Vazio() .or. M->BDC_ANOFIM >= M->BDC_ANOINI |
|
|
|
|
S |
BDC_MESFIM |
C |
2 |
0 |
Mes Final |
99 |
PLS627VLD() |
|
|
|
|
S |
BDC_EXPFIF |
C |
249 |
0 |
Filtro Fam. |
@! |
Vazio() .or. A627CTERR() |
|
|
|
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_TIPO |
C |
1 |
0 |
Fis/Juridica |
@! |
|
|
|
1=Juridica;2=Fisica |
|
S |
BDC_GRPCOB |
C |
4 |
0 |
Grupo Cobran |
@! |
Iif(VAZIO() .OR. BR0->(ExistCpo('BR0')),eval({||M->BDC_GRCOBV:=Space(TamSX3('BDC_GRCOBV')[1]),.T.}),.F.) |
BR0PLS |
|
|
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_DESGRP |
C |
30 |
0 |
Descr. Grupo |
@! |
|
|
V |
|
|
S |
BDC_LOTREN |
C |
12 |
0 |
Lote Renovac |
@! |
Vazio() .or. ExistCpo("BDE", M->(BDC_CODOPE + BDC_LOTREN),1) |
BEDPLS |
|
|
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_CONGER |
N |
6 |
0 |
Tit. Gerados |
999999 |
|
|
|
|
|
S |
BDC_CONCRI |
N |
6 |
0 |
Tit. Critic. |
999999 |
|
|
|
|
|
S |
BDC_VALOR |
N |
17 |
2 |
Valor Total |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
BDC_VENINI |
N |
2 |
0 |
Vencto Ini. |
99 |
Entre(01,31,M->BDC_VENINI) |
|
|
|
M->BDC_TIPO=="2" |
S |
BDC_VENFIM |
N |
2 |
0 |
Vencto Final |
99 |
Entre(01,31,M->BDC_VENFIM) |
|
|
|
M->BDC_TIPO=="2" |
S |
BDC_DTEMIS |
D |
8 |
0 |
Dt Emissao |
@D |
|
|
R |
|
|
N |
BDC_VENCTO |
N |
2 |
0 |
Dia Vencto. |
999 |
Vazio() .Or. Entre(1,Day(LastDay(dDataBase)),M->BDC_VENCTO) |
|
|
|
|
S |
BDC_MODPAG |
C |
1 |
0 |
Modal. Cobr. |
@! |
|
|
|
1=Pre-Pagamento;2=Custo Operacional;3=Ambas |
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_INTERC |
C |
1 |
0 |
Intercambio |
@! |
|
|
|
0=Nao;1=Sim |
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_AGLUTI |
C |
1 |
0 |
Aglut. Lanc. |
@! |
|
|
|
0=Nao;1=Sim |
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_CARIMP |
C |
1 |
0 |
Carne ? |
@! |
|
|
|
0=Nao;1=Sim |
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_FATGR |
C |
1 |
0 |
FatGr |
@! |
|
|
|
1=Sim;0=Nao |
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_GRCOBV |
C |
50 |
0 |
Var. Grp Co |
@! |
Iif( PLVLDCGR(),Eval({||M->BDC_GRPCOB := Space(TamSX3('BDC_GRPCOB')[1]),M->BDC_DESGRP:=''}) ,NIL) |
BGVPLS |
V |
|
IIF(BDC->(FieldPos('BDC_REEMB'))>0,M->BDC_REEMB<>'1',.T.) |
S |
BDC_REEMB |
C |
1 |
0 |
Som. Reemb? |
@! |
|
|
R |
0=Nao;1=Sim;2=Ambos |
GETNEWPAR("MV_PLSDTPG",.F.) |
N |
BDC_DTPREE |
D |
8 |
0 |
Dt Pag Reemb |
@D |
|
BDC990 |
R |
|
M->BDC_REEMB=="1" |
N |
BDC_CONSAD |
C |
1 |
0 |
Cons.Adicio. |
@! |
Pertence("01") |
|
|
0=Nao;1=Sim |
|
S |