| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| OHF | Itens de Desdobramento Financ. | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| OHF_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| OHF_IDDOC | C | 32 | 0 | Id. Doc. | !@ | R | S | ||||
| OHF_CITEM | C | 4 | 0 | Cod item | R | S | |||||
| OHF_CNATUR | C | 10 | 0 | Cod Natureza | Vazio().Or.(JurValNat('OHF_CNATUR','1') .And. JVldNatDes()) | SEDOHF | R | S | |||
| OHF_DNATUR | C | 30 | 0 | Desc Naturez | V | S | |||||
| OHF_SALDO | N | 16 | 2 | Saldo Natur. | @E 9,999,999,999,999.99 | V | S | ||||
| OHF_VALOR | N | 16 | 2 | Vlr Desdobr. | @E 9,999,999,999,999.99 | Vazio().Or.(Positivo().And.JAtuValDes('OHF')) | R | S | |||
| OHF_SIGLA | C | 5 | 0 | Sigla Solic. | Vazio() .OR. ExistCpo('RD0', FwFldGet('OHF_SIGLA'), 9) | RD0ATV | V | S | |||
| OHF_CPART | C | 6 | 0 | Cod Solic | R | S | |||||
| OHF_DPART | C | 30 | 0 | Nome Solic | V | S | |||||
| OHF_CESCR | C | 5 | 0 | Escritorio | Vazio().Or.J246VldEscr(FwFldGet('OHF_CESCR')) | NS7ATV | R | JA246WHEN() | S | ||
| OHF_DESCR | C | 100 | 0 | Desc. Escrit | @S50 | V | S | ||||
| OHF_CCUSTO | C | 9 | 0 | Centro Custo | @! | Vazio().OR.JVldCTTNS7("OHF_CESCR","OHF_CCUSTO") | CTTNS7 | R | JA246WHEN() | S | |
| OHF_DCUSTO | C | 40 | 0 | Desc C Custo | V | S | |||||
| OHF_SIGLA2 | C | 5 | 0 | Sigla Partic | Vazio().Or.ExistCpo('RD0', FwFldGet("OHF_SIGLA2"), 9) | RD0ATV | V | JA246WHEN() | S | ||
| OHF_CPART2 | C | 6 | 0 | Cod. Part. | R | S | |||||
| OHF_DPART2 | C | 30 | 0 | Nome Part. | V | S | |||||
| OHF_CRATEI | C | 10 | 0 | Tab. Rateio | Vazio().Or.(ExistCpo('OH6',FwFldGet('OHF_CRATEI'),1)) | OH6 | R | JA246WHEN() | S | ||
| OHF_DRATEI | C | 100 | 0 | Desc. Rateio | @S50 | V | S | ||||
| OHF_CCLIEN | C | 6 | 0 | Cod Cliente | @! | Vazio().OR.JurVldCli('',FwFldGet('OHF_CCLIEN'), FwFldGet('OHF_CLOJA'),,,'CLI') | SA1NUH | R | JA246WHEN() | S | |
| OHF_CLOJA | C | 2 | 0 | Loja | @! | Vazio().OR.JurVldCli('', FwFldGet('OHF_CCLIEN'), FwFldGet('OHF_CLOJA'),,,'LOJ') | R | JA246WHEN() | S | ||
| OHF_DCLIEN | C | 40 | 0 | Nome Cliente | V | S | |||||
| OHF_CCASO | C | 6 | 0 | Codigo Caso | Vazio().OR.JurVldCli('', FwFldGet('OHF_CCLIEN'), FwFldGet('OHF_CLOJA'),FwFldGet('OHF_CCASO'),'NVE_LANDSP','CAS') | NVELOJ | R | JA246WHEN() | S | ||
| OHF_DCASO | C | 100 | 0 | Desc. Caso | V | S | |||||
| OHF_CTPDSP | C | 4 | 0 | Tipo Despesa | Vazio().Or.JurVlTpDp(FwFldGet("OHF_CTPDSP")) | NRH | R | JA246WHEN() | S | ||
| OHF_DTPDSP | C | 50 | 0 | Desc Tp Desp | V | S | |||||
| OHF_QTDDSP | N | 3 | 0 | Qtd despesa | @E 999 | Positivo() | R | JA246WHEN() | S | ||
| OHF_DTDESP | D | 8 | 0 | Data Despesa | Vazio().Or.JurVlDtDp(FwFldGet("OHF_DTDESP")) | R | JA246WHEN() | S | |||
| OHF_COBRA | C | 1 | 0 | Cobrar Desp? | Vazio().OR.Pertence('12') | R | 1=Sim;2=Nao | JA246WHEN() | S | ||
| OHF_CPROJE | C | 6 | 0 | Cod. Projeto | Vazio().Or.J246VldPro(FwFldGet('OHF_CPROJE')) | OHL | R | S | |||
| OHF_DPROJE | C | 200 | 0 | Desc Projeto | V | S | |||||
| OHF_CITPRJ | C | 6 | 0 | Cod Item Prj | Vazio().Or.ExistCpo('OHM',FwFldGet("OHF_CPROJE")+FwFldGet("OHF_CITPRJ"),1) | OHM | R | !Empty(FwFldGet("OHF_CPROJE")) | S | ||
| OHF_DITPRJ | C | 200 | 0 | Descr. Item | V | S | |||||
| OHF_CHISTP | C | 4 | 0 | Cod Hist Pad | Vazio().Or.J246VldHis(FWFLDGET('OHF_CHISTP')) | OHA | R | S | |||
| OHF_HISTOR | M | 10 | 0 | Historico | R | S | |||||
| OHF_CDESP | C | 8 | 0 | Cod Despesa | R | S | |||||
| OHF_DTINCL | D | 8 | 0 | Dt. Inclusao | R | S | |||||
| OHF_DTCONT | D | 8 | 0 | Data Cont. | R | S | |||||
| OHF_NZQCOD | C | 8 | 0 | Cod Solic | R | S | |||||