Tabela FQ8 - CUSTOS X PROJETO
Chave Unica: FQ8_FILIAL + FQ8_PROJET + FQ8_OBRA + FQ8_SEQGRU + FQ8_SEQCAR
Modo: E
Modo Unid.: E
Modo Empr.: E
Sumario:
Campos
| Campo | Titulo | Descricao | Tipo | Contexto | Tamanho |
|---|---|---|---|---|---|
| FQ8_FILIAL | Filial | Filial do Sistema | C | Real | 2 |
| FQ8_PROJET | Nro.Projeto | Nro.Projeto | C | Real | 22 |
| FQ8_OBRA | Obra | Obra | C | Real | 3 |
| FQ8_SEQGUI | Seq.Guind. | Seq.Guind. | C | Real | 3 |
| FQ8_SEQTRA | Seq.Transp. | Seq.Transp. | C | Real | 3 |
| FQ8_VALLSR | LSR Ida | LSR Ida | N | Real | 14, 2 |
| FQ8_VALTUV | TUV Ida | TUV Ida | N | Real | 14, 2 |
| FQ8_VALTUR | TUR Ida | TUR Ida | N | Real | 14, 2 |
| FQ8_VALTAP | TAP Ida | TAP Ida | N | Real | 14, 2 |
| FQ8_VALESC | Escolta Ida | Escolta Ida | N | Real | 14, 2 |
| FQ8_VALPRF | PRF Ida | PRF Ida | N | Real | 14, 2 |
| FQ8_VALPRE | PRE Ida | PRE Ida | N | Real | 14, 2 |
| FQ8_VALINV | Inversao Ida | Inversao Ida | N | Real | 14, 2 |
| FQ8_VALADI | Adicional 1 | Adicional Ida | N | Real | 14, 2 |
| FQ8_AQUISI | Aquisicao | Aquisicao | N | Real | 14, 2 |
| FQ8_PERRSD | % Residual | % Residual | N | Real | 14, 2 |
| FQ8_VALRSD | Residual | Residual | N | Real | 14, 2 |
| FQ8_DISPVE | Dispon.Veic. | Dispon.Veic. | N | Real | 14, 2 |
| FQ8_VIDAEF | Vida Ut.Efet | Vida Ut.Efet | N | Real | 14, 2 |
| FQ8_JUROSM | Juros Mes | Juros Mes | N | Real | 14, 2 |
| FQ8_SEGURP | % Seguro | % Seguro | N | Real | 14, 2 |
| FQ8_LICENP | Licenciam. | Licenciam. | N | Real | 14, 2 |
| FQ8_LAVAGE | Custo Lavag. | Custo Lavag. | N | Real | 14, 2 |
| FQ8_FREQLA | Freq.Lavagem | Freq.Lavagem | N | Real | 14, 2 |
| FQ8_COMBUS | Combustivel | Combustivel | N | Real | 14, 2 |
| FQ8_LUBRIF | Custo Lubr. | Custo Lubr. | N | Real | 14, 2 |
| FQ8_INTLUB | Interv.Lubr. | Interv.Lubr. | N | Real | 14, 2 |
| FQ8_QTDPNE | Pneus | Pneus | N | Real | 14, 2 |
| FQ8_PREPNE | Preco Pneu | Preco Pneu | N | Real | 14, 2 |
| FQ8_VIDAPN | Vida Ut.Pneu | Vida Ut.Pneu | N | Real | 14, 2 |
| FQ8_CONSER | Cons.Peca | Cons.Peca | N | Real | 14, 2 |
| FQ8_VALCOM | Combustivel | Combustivel | N | Real | 14, 2 |
| FQ8_VALPNE | Pneus | Pneus | N | Real | 14, 2 |
| FQ8_VALLUB | Lubrificacao | Lubrificacao | N | Real | 14, 2 |
| FQ8_VALLAV | Lavagem | Lavagem | N | Real | 14, 2 |
| FQ8_REMCAP | Remu.Capital | Remu.Capital | N | Real | 14, 2 |
| FQ8_PERRES | % Reserva | % Reserva | N | Real | 14, 2 |
| FQ8_VALRES | Reserva | Reserva | N | Real | 14, 2 |
| FQ8_CASCO | Seguro Casc | Seguro Casco | N | Real | 14, 2 |
| FQ8_LICENC | Licenciam. | Licenciam. | N | Real | 14, 2 |
| FQ8_SEGURO | Seguro Obrig | Seguro Obrig | N | Real | 14, 2 |
| FQ8_QTDCOM | Cons.Combust | Cons.Combust | N | Real | 9, 2 |
| FQ8_VALTRA | Travessia | Travessia | N | Real | 14, 2 |
| FQ8_VALCON | Concession.1 | Concession.Ida | N | Real | 14, 2 |
| FQ8_VALPED | Pedagios Ida | Pedagios Ida | N | Real | 14, 2 |
| FQ8_PERISS | % ISS | % ISS | N | Real | 6, 2 |
| FQ8_PERPIS | % PIS/COFINS | % PIS/COFINS | N | Real | 6, 2 |
| FQ8_PERADM | % Admin | % Admin | N | Real | 6, 2 |
| FQ8_PERLUC | % LUCRO | % LUCRO | N | Real | 6, 2 |
| FQ8_PERSEG | % SEGURO | % SEGURO | N | Real | 6, 2 |
| FQ8_PERJUR | % JUROS | % JUROS | N | Real | 6, 2 |
| FQ8_PERCPM | % CPMF | % CPMF | N | Real | 6, 2 |
| FQ8_PERCSL | % CSLL | % CSLL | N | Real | 6, 2 |
| FQ8_PERIRR | % IRRF | % IRRF | N | Real | 6, 2 |
| FQ8_PERTOT | % BDI | % BDI | N | Real | 6, 2 |
| FQ8_VALISS | ISS | ISS | N | Real | 14, 2 |
| FQ8_VALPIS | PIS/COFINS | PIS/COFINS | N | Real | 14, 2 |
| FQ8_VALADM | Administr. | Administr. | N | Real | 14, 2 |
| FQ8_VALLUC | Lucro | Lucro | N | Real | 14, 2 |
| FQ8_VALSEG | Seguro | Seguro | N | Real | 14, 2 |
| FQ8_VALJUR | Juros | Juros | N | Real | 14, 2 |
| FQ8_VALCPM | CPMF | CPMF | N | Real | 14, 2 |
| FQ8_VALCSL | CSLL | CSLL | N | Real | 14, 2 |
| FQ8_VALIRR | IRRF | IRRF | N | Real | 14, 2 |
| FQ8_VALTOT | Total BDI | Total BDI | N | Real | 14, 2 |
| FQ8_VIDAUT | Vida Util | Vida Util | N | Real | 5 |
| FQ8_VALIPT | Laudo IPT 1 | Laudo IPT Ida | N | Real | 12, 2 |
| FQ8_VALACO | Acomp.Tecn.1 | Acomp.Tecn.Ida | N | Real | 12, 2 |
| FQ8_VALSEM | Semaforica 1 | Semaforica Ida | N | Real | 12, 2 |
| FQ8_VALTVA | TV a Cabo 1 | TV a Cabo Ida | N | Real | 12, 2 |
| FQ8_VALTEL | Cia Telefon1 | Cia Telefon. Ida | N | Real | 12, 2 |
| FQ8_VALOUT | Outros Ida | Outros Ida | N | Real | 12, 2 |
| FQ8_VALAUX | Equips.Auxs1 | Equips.Auxs.Ida | N | Real | 12, 2 |
| FQ8_VALCET | Acomp.CET 1 | Acomp.CET Ida | N | Real | 12, 2 |
| FQ8_VALVIS | Vr.Vistoria | Vr.Vistoria | N | Real | 12, 2 |
| FQ8_VALTCP | Transp.Acess | Transp.Acess | N | Real | 12, 2 |
| FQ8_VALMOB | Mob. | Mob. | N | Real | 12, 2 |
| FQ8_DESMOB | Desmob. | Desmob. | N | Real | 12, 2 |
| FQ8_SEGGUI | Seguro Carga | Seguro Carga | N | Real | 12, 2 |
| FQ8_VALGUI | Resumo Guind | Resumo Guind | N | Real | 12, 2 |
| FQ8_VALEQU | Equipamento | Equipamento | N | Real | 12, 2 |
| FQ8_VRFRET | Vr.Frete | Vr.Frete | N | Real | 12, 2 |
| FQ8_SEQGRU | Seq.Grua | Seq.Grua | C | Real | 3 |
| FQ8_SEQCAR | Seq.Carga | Seq.Carga | C | Real | 3 |
| FQ8_VL2LSR | LSR Volta | LSR Volta | N | Real | 14, 2 |
| FQ8_VL2PRE | PRE Volta | PRE Volta | N | Real | 14, 2 |
| FQ8_VL2PRF | PRF Volta | PRF Volta | N | Real | 14, 2 |
| FQ8_VL2TAP | TAP Volta | TAP Volta | N | Real | 14, 2 |
| FQ8_VL2TUV | TUV Volta | TUV Volta | N | Real | 14, 2 |
| FQ8_VL2TUR | TUR Volta | TUR Volta | N | Real | 14, 2 |
| FQ8_VL2ESC | Escolta 2 | Escolta Volta | N | Real | 14, 2 |
| FQ8_VL2PED | Pedagios 2 | Pedagios Volta | N | Real | 14, 2 |
| FQ8_VL2INV | Inversao 2 | Inversao Volta | N | Real | 14, 2 |
| FQ8_VL2IPT | Laudo IPT 2 | Laudo IPT Volta | N | Real | 12, 2 |
| FQ8_VL2ACO | Acomp.Tecn.2 | Acomp.Tecn. Volta | N | Real | 12, 2 |
| FQ8_VL2CET | Acomp.CET 2 | Acomp.CET Volta | N | Real | 12, 2 |
| FQ8_VL2SEM | Semaforica 2 | Semaforica Volta | N | Real | 12, 2 |
| FQ8_VL2TVA | TV a Cabo 2 | TV a Cabo Volta | N | Real | 12, 2 |
| FQ8_VL2TEL | Cia Telefon2 | Cia Telefon. Volta | N | Real | 12, 2 |
| FQ8_VL2OUT | Outros Volta | Outros Volta | N | Real | 12, 2 |
| FQ8_VL2CON | Adicional 2 | Adicional Volta | N | Real | 14, 2 |
| FQ8_VL2ADI | Adicional 2 | Adicional Volta | N | Real | 14, 2 |
| FQ8_VL2AUX | Equips.Auxs2 | Equips.Auxs.Volta | N | Real | 12, 2 |
| FQ8_USERGI | Log de Inclu | Log de Inclusao | C | Real | 17 |
| FQ8_USERGA | Log de Alter | Log de Alteracao | C | Real | 17 |
| FQ8_INSTRU | Instrument. | Instrumentacao | N | Real | 14, 2 |
| FQ8_BALSA | Balsa | Balsa | N | Real | 14, 2 |
| FQ8_DESDTA | Despac. DTA | Despachante DTA | N | Real | 14, 2 |
| FQ8_MONDES | Despac. DTA | Despachante DTA | N | Real | 14, 2 |
| FQ8_APOGUI | Apoio/Guinda | Carro Apoio / Guindauto | N | Real | 14, 2 |
| FQ8_CAVEXT | Cavalo Extra | Cavalo Extra | N | Real | 14, 2 |
| FQ8_MODENC | DesMob Encar | DesMOB Encarretado | N | Real | 14, 2 |
| FQ8_DMOENC | DesMob Encar | DesMOB Encarretado | N | Real | 14, 2 |
| FQ8_COMPT | Comprim. Tot | Comprimento total | N | Real | 7, 2 |
| FQ8_LARGT | Largura Tot. | Largura Total | N | Real | 7, 2 |
| FQ8_ALTUT | Altura Total | Altura Total | N | Real | 7, 2 |
| FQ8_PESOT | Peso total | Peso total | N | Real | 16, 8 |
| FQ8_VALFEC | Valor Fechad | Valor Fechado | N | Real | 12, 2 |
Indices
| Ordem | Chave | Descricao | Nickname |
|---|---|---|---|
| 1 | FQ8_FILIAL + FQ8_PROJET + FQ8_OBRA + FQ8_SEQTRA + FQ8_SEQGUI + FQ8_SEQGRU + FQ8_SEQCAR | Nro.Projeto + Obra + Seq.Transp. + Seq.Guind. + Seq.Grua + Seq.Carga | |
| 2 | FQ8_FILIAL + FQ8_PROJET + FQ8_OBRA + FQ8_SEQTRA + FQ8_SEQCAR | Nro.Projeto + Obra + Seq.Transp. + Seq.Carga |
Relacionamentos
| Tabela Origem | Tabela Destino | Expressao Origem | Expressao Destino | Relacionamento |
|---|---|---|---|---|
| Sem dados encontrados na SX9 | ||||