Tabela |
BT6 |
Empresa Contrato Produto |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
BT6_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
BT6_CODINT |
C |
4 |
0 |
Operadora |
@R !.!!!-!!!! |
|
|
|
|
|
S |
BT6_CODIGO |
C |
4 |
0 |
Codigo |
@! |
|
|
|
|
|
S |
BT6_NUMCON |
C |
12 |
0 |
Num.Contrato |
@! |
|
|
|
|
|
S |
BT6_VERCON |
C |
3 |
0 |
Versao Cont. |
@! |
|
|
|
|
|
S |
BT6_SUBCON |
C |
9 |
0 |
Sub-Contrato |
@! |
|
|
|
|
|
S |
BT6_VERSUB |
C |
3 |
0 |
Versao Sub. |
@! |
|
|
|
|
|
S |
BT6_CODPRO |
C |
4 |
0 |
Cod. Produto |
@! |
PLSVLDGD({"BT6_CODPRO","BT6_VERSAO"}) .And. PLS800Tipo(BG9->BG9_CODINT,M->BT6_CODPRO,"2,3") |
B25PLS |
|
|
|
S |
BT6_VERSAO |
C |
3 |
0 |
Versao |
@! |
PlsVldVer() |
BSUPLS |
|
|
|
S |
BT6_DESPRO |
C |
65 |
0 |
Desc.Produto |
@! |
|
|
V |
|
|
S |
BT6_TIPOPR |
C |
1 |
0 |
Tipo |
@! |
Pertence("123") |
|
|
1=Plano/Produto;2=Opcional;3=Termo Aditivo |
|
S |
BT6_CODSEG |
C |
3 |
0 |
Segmentacao |
@! |
PlsZero() .And. ExistCpo("BI6",M->BT6_CODSEG,1) |
B52PLS |
|
|
M->BT6_APOSRG=="0" |
S |
BT6_DESSEG |
C |
60 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BT6_MODPAG |
C |
3 |
0 |
Modal. Cobr. |
@! |
Pertence("129") |
|
|
1=Pre-Pagamento;2=Demais Modalidades;9=Nao Definida |
M->BT6_APOSRG=="0" |
S |
BT6_APOSRG |
C |
1 |
0 |
Regulament. |
@! |
Pertence("01") |
|
|
0=Nao;1=Sim |
|
S |
BT6_CODACO |
C |
2 |
0 |
Acomodacao |
@! |
ExistCpo("BI4",M->BT6_CODACO,1) |
B45PLS |
|
|
M->BT6_APOSRG=="0" |
S |
BT6_DESACO |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BT6_ABRANG |
C |
2 |
0 |
Abrangencia |
@! |
PlsZero() .And. ExistCpo("BF7",M->BT6_ABRANG,1) |
BD9PLS |
|
|
M->BT6_APOSRG=="0" |
S |
BT6_DESABR |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
BT6_TIPCON |
C |
3 |
0 |
Tp. Contrato |
@! |
|
|
|
|
|
S |
BT6_DESCON |
C |
30 |
0 |
Ds Tp Contr. |
@! |
|
|
V |
|
|
S |
BT6_CODPTU |
C |
8 |
0 |
Cod EDI |
@! |
|
|
|
|
|
S |
BT6_COBJUR |
C |
1 |
0 |
Cob. Juros ? |
@! |
|
|
|
0=Nao;1=Sim |
|
S |
BT6_TAXDIA |
N |
9 |
2 |
% Juros Dia |
@E 999,999.99 |
|
|
|
|
|
S |
BT6_JURDIA |
N |
9 |
2 |
Vl Juros Dia |
@E 999,999.99 |
|
|
|
|
|
S |
BT6_COBRAT |
C |
1 |
0 |
Cob.Pro Rata |
@! |
|
|
|
0=Nao;1=Sim |
|
S |
BT6_RATSAI |
C |
1 |
0 |
Pro Rata Sai |
@! |
Pertence("01") |
|
|
0=Nao;1=Sim |
|
S |
BT6_CC |
C |
9 |
0 |
Centro Custo |
@! |
Vazio() .Or. Ctb105CC() |
CTT |
|
|
|
S |
BT6_INFCOB |
C |
1 |
0 |
Inf.Cob.? |
@! |
Pertence("01") |
|
|
1=Sim;0=Nao |
|
S |
BT6_INFGRC |
C |
1 |
0 |
Inf.Grp.Cob? |
@! |
|
|
|
1=Sim;0=Nao |
|
S |
BT6_RISCO |
C |
1 |
0 |
Inss Risco |
@! |
Pertence("01") |
|
|
0=Pequeno risco;1=Grande risco |
|
S |
BT6_CPFM |
C |
1 |
0 |
Co-Partic. ? |
@! |
pertence("01") |
|
|
0=Nao;1=Sim |
M->BT6_MODPAG=="1" |
S |
BT6_RETGUI |
C |
1 |
0 |
Ret. Guia? |
@! |
Pertence("01") |
|
|
1=Sim;0=Nao |
|
S |
BT6_CODSIM |
C |
20 |
0 |
Cod Similar. |
|
|
BM0PLS |
R |
|
|
S |
BT6_COBCPF |
C |
1 |
0 |
For.Cob.PF |
@! |
Pertence("01") |
|
R |
0=Comp.Anterior;1=Comp.Atual |
|
S |
BT6_SOMINT |
C |
1 |
0 |
Som.Intern? |
@! |
Pertence("01") |
|
|
1=Sim;0=Nao |
M->BT6_RETGUI=="1" |
S |
BT6_DESMEN |
N |
7 |
2 |
Desc.Mens. |
@E 9,999.99 |
|
|
|
|
|
S |
BT6_ALLCRE |
C |
1 |
0 |
Todos Cred. |
@! |
Pertence("01") |
|
R |
0=Nao;1=Sim |
|
N |
BT6_DATINC |
D |
8 |
0 |
Dt. Inclusao |
|
|
|
R |
|
|
N |
BT6_CODPAT |
C |
6 |
0 |
Cd. Patronal |
@! |
PL660VLPAT("BT6") |
B1JPLS |
R |
|
|
S |
BT6_DESPAT |
C |
40 |
0 |
Ds. Patronal |
@! |
|
|
V |
|
|
S |
BT6_MDFTPT |
C |
1 |
0 |
Mod Cobranca |
@! |
|
|
R |
1=Empresa;2=Titular;3=Compartilhado |
|
S |
BT6_CONTA |
C |
20 |
0 |
Cod.Conta |
@! |
ExistCpo('CT1').or.Vazio() |
CT1 |
R |
|
|
S |
BT6_DESCCT |
C |
60 |
0 |
Desc.Conta |
@! |
|
|
V |
|
|
S |