Tabela |
BGI |
Vigencias Tabela de Precos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
BGI_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
BGI_GRUOPE |
C |
2 |
0 |
Codigo |
@! |
|
|
|
|
|
S |
BGI_CODSEQ |
C |
3 |
0 |
Codigo Seq. |
@! |
|
|
|
|
|
S |
BGI_CODPRO |
C |
16 |
0 |
Cod Tab Padr |
@! |
ExistCpo("BR8",M->BGI_CODPAD+M->BGI_CODPRO,1) .And. PLSGATNIV(M->BGI_CODPAD,M->BGI_CODPRO,"BGI") |
BGHPLS |
|
|
|
S |
BGI_DESPRO |
C |
40 |
0 |
Desc.Proced. |
@! |
|
|
V |
|
|
S |
BGI_TIPLAN |
C |
1 |
0 |
Tp Lanc Acom |
@! |
|
|
|
1=Aplicado a todas as acomodacoes;2=Espeficico para uma unica acomodacao |
|
S |
BGI_CODACO |
C |
2 |
0 |
Acomodacao |
@! |
BI4->(ExistCpo("BI4",M->BGI_CODACO,1)) |
BI4PLS |
|
|
M->BGI_TIPLAN=="2" |
S |
BGI_DESACO |
C |
40 |
0 |
Ds Acomod. |
@! |
|
|
V |
|
M->BGI_TIPLAN=="2" |
S |
BGI_USPCO |
N |
13 |
4 |
US CO Pagto |
@E 99,999,999.9999 |
M->BGI_USPCO >= 0 |
|
|
|
M->BGI_VRPCO==0 |
S |
BGI_VRPCO |
N |
13 |
2 |
VL CO Pagto |
@E 9,999,999,999.99 |
M->BGI_VRPCO >= 0 |
|
|
|
M->BGI_USPCO==0 |
S |
BGI_USRCO |
N |
13 |
4 |
US CO Recto |
@E 99,999,999.9999 |
M->BGI_USRCO >= 0 |
|
|
|
M->BGI_VRRCO==0 |
S |
BGI_VRRCO |
N |
13 |
2 |
VL CO Recto |
@E 9,999,999,999.99 |
M->BGI_VRRCO >= 0 |
|
|
|
M->BGI_USRCO==0 |
S |
BGI_USPPP |
N |
13 |
4 |
US PP Pagto |
@E 99,999,999.9999 |
M->BGI_USPPP >= 0 |
|
|
|
M->BGI_VRPPP==0 |
S |
BGI_VRPPP |
N |
13 |
2 |
VL PP Pagto |
@E 9,999,999,999.99 |
M->BGI_VRPPP >= 0 |
|
|
|
M->BGI_USPPP==0 |
S |
BGI_USRPP |
N |
13 |
4 |
US PP Recto |
@E 99,999,999.9999 |
M->BGI_USRPP >= 0 |
|
|
|
M->BGI_VRRPP==0 |
S |
BGI_VRRPP |
N |
13 |
2 |
VL PP Recto |
@E 9,999,999,999.99 |
M->BGI_VRRPP >= 0 |
|
|
|
M->BGI_USRPP==0 |
S |
BGI_TXADCO |
N |
13 |
2 |
Vlr.Tx.Pagar |
@E 9,999,999,999.99 |
|
|
|
|
|
S |
BGI_NVVLCO |
C |
1 |
0 |
Nivel Valido |
@! |
|
|
|
1=Sim;0=Nao |
M->BGI_TXADCO==0 |
S |
BGI_TXADPP |
N |
13 |
2 |
Vlr.Tx.Receb |
@E 9,999,999,999.99 |
|
|
|
|
|
S |
BGI_NVVLPP |
C |
1 |
0 |
Nivel Valido |
@! |
|
|
|
1=Sim;0=Nao |
M->BGI_TXADPP==0 |
S |
BGI_CODPAD |
C |
2 |
0 |
Cod. Padrao |
@! |
ExistCpo("BR4",M->BGI_CODPAD,1) |
B41PLS |
|
|
|
S |
BGI_CDNV01 |
C |
6 |
0 |
Cd Niv 01 |
@! |
|
|
|
|
|
S |
BGI_CDNV02 |
C |
6 |
0 |
Cd Niv 02 |
@! |
|
|
|
|
|
S |
BGI_CDNV03 |
C |
6 |
0 |
Cd Niv 03 |
@! |
|
|
|
|
|
S |
BGI_CDNV04 |
C |
6 |
0 |
Cd Niv 04 |
@! |
|
|
|
|
|
S |
BGI_NIVEL |
C |
1 |
0 |
Nivel |
@! |
|
|
|
|
|
S |
BGI_FINATE |
C |
2 |
0 |
Finalidade |
@! |
Vazio() .or. BGY->(ExistCpo("BGY",PlsIntPad()+M->BGI_FINATE,1)) |
BGYPLS |
R |
|
|
S |
BGI_DESFIN |
C |
70 |
0 |
Ds Finalidad |
@! |
|
|
V |
|
|
S |