Tabela |
OHB |
Lancamentos |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
OHB_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
OHB_CODIGO |
C |
10 |
0 |
Codigo Lan |
|
ExistChav('OHB',M->OHB_CODIGO,1) |
|
R |
|
|
S |
OHB_DTINCL |
D |
8 |
0 |
Dta Inclusao |
|
|
|
R |
|
|
S |
OHB_CEVENT |
C |
4 |
0 |
Evento Finac |
|
Vazio().Or.J241EVENT() |
OHC |
R |
|
|
S |
OHB_SIGLA |
C |
5 |
0 |
Sigl Solicit |
|
Vazio().OR.J241VldPar(M->OHB_SIGLA) |
RD0ATV |
V |
|
|
S |
OHB_CPART |
C |
6 |
0 |
Cod Solicita |
|
|
RD0ATV |
R |
|
|
S |
OHB_DPART |
C |
30 |
0 |
Nome Solict. |
|
|
|
V |
|
|
S |
OHB_ORIGEM |
C |
1 |
0 |
Origem Lan |
|
Pertence('123456') |
|
R |
1=Contas a Pagar;2=Contas a Receber;3=Tarifador;4=Faturamento (Fatura);5=Digitado;6=Solicitacao de Despesa |
|
S |
OHB_FILORI |
C |
2 |
0 |
Filial Orig |
|
|
|
R |
|
|
S |
OHB_NATORI |
C |
10 |
0 |
Natur Origem |
|
Vazio().Or.J241ValNat('OHB_NATORI') |
SEDOHB |
R |
|
|
S |
OHB_DNATOR |
C |
30 |
0 |
Desc Nat Ori |
|
|
|
V |
|
|
S |
OHB_SALDOO |
N |
16 |
2 |
Saldo Origem |
@E 9,999,999,999,999.99 |
|
|
V |
|
|
S |
OHB_CESCRO |
C |
5 |
0 |
Escrit. Orig |
|
Vazio().OR.J241VldEsc(M->OHB_CESCRO) |
NS7ATV |
R |
|
JA241WHEN() |
S |
OHB_DESCRO |
C |
100 |
0 |
Desc Escrit. |
@S50 |
|
|
V |
|
|
S |
OHB_CCUSTO |
C |
9 |
0 |
Centro Custo |
@! |
Vazio().OR.J241VldCC('O') |
CTTNS7 |
R |
|
JA241WHEN() |
S |
OHB_DCUSTO |
C |
40 |
0 |
Desc C Custo |
|
|
|
V |
|
|
S |
OHB_SIGLAO |
C |
5 |
0 |
Sigla Partic |
|
Vazio().OR.J241VldPar(M->OHB_SIGLAO) |
RD0ATV |
V |
|
JA241WHEN() |
S |
OHB_CPARTO |
C |
6 |
0 |
Cod Particip |
|
|
RD0ATV |
R |
|
|
S |
OHB_DPARTO |
C |
30 |
0 |
Nome Partic |
|
|
|
V |
|
|
S |
OHB_CTRATO |
C |
10 |
0 |
Tab Rat Orig |
|
Vazio().OR.J241VldRat(M->OHB_CTRATO) |
OH6 |
R |
|
JA241WHEN() |
S |
OHB_DTRATO |
C |
100 |
0 |
Tb Rat Ori |
@S50 |
|
|
V |
|
|
S |
OHB_CPROJE |
C |
6 |
0 |
Cod. Projeto |
|
Vazio().OR.J241VldPro(M->OHB_CPROJE) |
OHL |
R |
|
|
S |
OHB_DPROJE |
C |
200 |
0 |
Desc Projeto |
|
|
|
V |
|
|
S |
OHB_CITPRJ |
C |
6 |
0 |
Cod Item Prj |
|
Vazio().Or.ExistCpo('OHM',FwFldGet("OHB_CPROJE")+FwFldGet("OHB_CITPRJ"),1) |
OHM |
R |
|
!Empty(FwFldGet("OHB_CPROJE")) |
S |
OHB_DITPRJ |
C |
200 |
0 |
Descr. Item |
|
|
|
|
|
|
S |
OHB_NATDES |
C |
10 |
0 |
Natur Destin |
|
Vazio().Or.J241ValNat('OHB_NATDES') |
SEDOHB |
R |
|
|
S |
OHB_DNATDE |
C |
30 |
0 |
Desc Nat Des |
|
|
|
V |
|
|
S |
OHB_SALDOD |
N |
16 |
2 |
Saldo Dest. |
@E 9,999,999,999,999.99 |
|
|
V |
|
|
S |
OHB_CESCRD |
C |
5 |
0 |
Escrit. Dest |
|
Vazio().OR.J241VldEsc(M->OHB_CESCRD) |
NS7ATV |
R |
|
JA241WHEN() |
S |
OHB_DESCRD |
C |
100 |
0 |
D Escr Des |
@S50 |
|
|
V |
|
|
S |
OHB_CCUSTD |
C |
9 |
0 |
C Custo Dest |
@! |
Vazio().OR.J241VldCC('D') |
CTTNS7 |
R |
|
JA241WHEN() |
S |
OHB_DCUSTD |
C |
40 |
0 |
D C Cust Des |
|
|
|
V |
|
|
S |
OHB_SIGLAD |
C |
5 |
0 |
Sig Part Des |
|
Vazio().OR.J241VldPar(M->OHB_SIGLAD) |
RD0ATV |
V |
|
JA241WHEN() |
S |
OHB_CPARTD |
C |
6 |
0 |
Cod Part Des |
|
|
RD0ATV |
R |
|
|
S |
OHB_DPARTD |
C |
30 |
0 |
Nom Part Des |
|
|
|
V |
|
|
S |
OHB_CTRATD |
C |
10 |
0 |
Tab Rat Des |
|
Vazio().OR.J241VldRat(M->OHB_CTRATD) |
OH6 |
R |
|
JA241WHEN() |
S |
OHB_DTRATD |
C |
100 |
0 |
Tb Rat Des |
@S50 |
|
|
V |
|
|
S |
OHB_CCLID |
C |
6 |
0 |
Cod Cliente |
@! |
Vazio().OR.J241VldCli('D','CLI') |
SA1NUH |
R |
|
JA241WHEN() |
S |
OHB_CLOJD |
C |
2 |
0 |
Loja Cliente |
@! |
Vazio().OR.J241VldCli('D','LOJ') |
|
R |
|
JA241WHEN() |
S |
OHB_DCLID |
C |
40 |
0 |
Nome Cliente |
|
|
|
V |
|
|
S |
OHB_CCASOD |
C |
6 |
0 |
Codigo Caso |
|
Vazio().OR.J241VldCli('D','CAS') |
NVELOJ |
R |
|
JA241WHEN() |
S |
OHB_DCASOD |
C |
100 |
0 |
Desc Caso |
|
|
|
V |
|
|
S |
OHB_CTPDPD |
C |
4 |
0 |
Tipo Despesa |
|
Vazio().OR.J241VldTpD(M->OHB_CTPDPD) |
NRH |
R |
|
JA241WHEN() |
S |
OHB_DTPDPD |
C |
50 |
0 |
Des Tp Desp |
|
|
|
V |
|
|
S |
OHB_CDESPD |
C |
8 |
0 |
Cod Despesa |
|
Vazio().Or.ExistCpo('NVY',M->OHB_CDESPD,1) |
|
R |
|
|
S |
OHB_QTDDSD |
N |
3 |
0 |
Qtd Despesa |
@E 999 |
Positivo() |
|
R |
|
JA241WHEN() |
S |
OHB_COBRAD |
C |
1 |
0 |
Cobrar Des? |
|
Vazio().OR.Pertence('12') |
|
R |
1=Sim;2=Nao |
JA241WHEN() |
S |
OHB_DTDESP |
D |
8 |
0 |
Data Despesa |
|
Vazio().Or.JurVlDtDp(FwFldGet("OHB_DTDESP")) |
|
R |
|
JA241WHEN() |
S |
OHB_CPROJD |
C |
6 |
0 |
Cd Proj Dest |
|
Vazio().OR.J241VldPro(M->OHB_CPROJD) |
OHL |
R |
|
|
S |
OHB_DPROJD |
C |
200 |
0 |
Dsc Proj Des |
|
|
|
V |
|
|
S |
OHB_CITPRD |
C |
6 |
0 |
Cod Item Prj |
|
Vazio().Or.ExistCpo('OHM',FwFldGet("OHB_CPROJD")+FwFldGet("OHB_CITPRD"),1) |
OHM |
R |
|
!Empty(FwFldGet("OHB_CPROJD")) |
S |
OHB_DITPRD |
C |
200 |
0 |
Descr. Item |
|
|
|
V |
|
|
S |
OHB_DTLANC |
D |
8 |
0 |
Dt Lancament |
|
|
|
R |
|
|
S |
OHB_CMOELC |
C |
2 |
0 |
Cod Moe Lanc |
|
Vazio().OR.J241VLDMOE() |
CTOOHB |
R |
|
|
S |
OHB_DMOELC |
C |
10 |
0 |
Moeda Lanc. |
|
|
|
V |
|
|
S |
OHB_VALOR |
N |
16 |
2 |
Valor Lanc. |
@E 9,999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
OHB_CHISTP |
C |
4 |
0 |
Cod Hist Pad |
|
Vazio().Or.J241VldHis(FWFLDGET('OHB_CHISTP')) |
OHA |
R |
|
|
S |
OHB_HISTOR |
M |
10 |
0 |
Historico |
|
|
|
R |
|
|
S |
OHB_COTAC |
N |
12 |
8 |
Cotacao |
@E 999.99999999 |
Positivo() |
|
|
|
JA241WHEN() |
S |
OHB_CMOEC |
C |
2 |
0 |
Cod Moe Cot. |
|
Vazio().OR.J241VLDMOE() |
|
R |
|
|
S |
OHB_DMOEC |
C |
10 |
0 |
Moeda Cotac. |
|
|
|
V |
|
|
S |
OHB_VALORC |
N |
16 |
2 |
Valor conv. |
@E 9,999,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
OHB_CUSINC |
C |
6 |
0 |
Part. incl. |
|
|
|
R |
|
|
S |
OHB_SIGLAI |
C |
5 |
0 |
Sigla incl. |
|
|
|
V |
|
|
S |
OHB_DTALTE |
D |
8 |
0 |
Dt Alteracao |
|
|
|
R |
|
|
S |
OHB_CUSALT |
C |
6 |
0 |
Part. Alter. |
|
|
|
R |
|
|
S |
OHB_SIGLAA |
C |
5 |
0 |
Sigla Alter. |
|
|
|
V |
|
|
S |
OHB_DURTEL |
N |
16 |
0 |
Tempo Liga |
@E 9,999,999,999,999,999 |
Positivo() |
|
R |
|
|
S |
OHB_SE5SEQ |
C |
2 |
0 |
Seq. Baixa |
|
|
|
R |
|
|
S |
OHB_CPAGTO |
C |
100 |
0 |
C Ctas Pagar |
|
|
|
R |
|
|
S |
OHB_ITDES |
C |
4 |
0 |
It. Desdobra |
|
|
|
R |
|
|
S |
OHB_ITDPGT |
C |
4 |
0 |
It. Desd Pag |
|
|
|
R |
|
|
S |
OHB_CRECEB |
C |
100 |
0 |
C Ctas Receb |
|
|
|
R |
|
|
S |
OHB_VLNAC |
N |
16 |
2 |
Vlr Nacional |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
OHB_DTCONT |
D |
8 |
0 |
Data Cont. |
|
|
|
R |
|
|
S |