| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VIW | INFORME DIARIO DE PECAS GM | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| VIW_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| VIW_CODMAR | C | 3 | 0 | Marca | @! | R | S | ||||
| VIW_DATPRO | D | 8 | 0 | Data | R | S | |||||
| VIW_GRUITE | C | 4 | 0 | Grupo | @! | R | S | ||||
| VIW_COD | C | 15 | 0 | CODIGO | @! | R | S | ||||
| VIW_CODITE | C | 27 | 0 | Codigo | @! | R | S | ||||
| VIW_DESITE | C | 30 | 0 | Desc. Item | @! | R | S | ||||
| VIW_SINAL | C | 1 | 0 | Sinal | @! | R | S | ||||
| VIW_VUNIT | N | 9 | 2 | Valor Unit. | @E 999,999.99 | R | S | ||||
| VIW_QTDITE | N | 6 | 0 | Qtdade | @E 999,999 | R | S | ||||
| VIW_VTOTPC | N | 10 | 2 | Vl. Tot Peca | @E 9,999,999.99 | R | S | ||||
| VIW_QTDDIS | N | 14 | 2 | Qtd disp | @E 99,999,999,999.99 | R | S | ||||
| VIW_ALQICM | N | 5 | 2 | Aliq. ICM | @E 99.99 | R | S | ||||
| VIW_QTDPED | N | 14 | 2 | Qtd pedido | @E 99,999,999,999.99 | R | S | ||||
| VIW_ALQPC | N | 5 | 2 | Alq Pis/Cof | @E 99.99 | R | S | ||||
| VIW_QTDVEN | N | 14 | 2 | Qtd vendida | @E 99,999,999,999.99 | R | S | ||||
| VIW_DESPC | N | 11 | 2 | Descto Peca | @E 99,999,999.99 | R | S | ||||
| VIW_QTDPER | N | 14 | 2 | Qtd perdida | @E 99,999,999,999.99 | R | S | ||||
| VIW_CODSER | C | 8 | 0 | Cod. Servico | @! | R | S | ||||
| VIW_DESSER | C | 30 | 0 | Desc.Ser. | @! | R | S | ||||
| VIW_HORVEN | N | 5 | 0 | Hora Vend. | @E 99,999 | R | S | ||||
| VIW_TOTSER | N | 10 | 2 | Tot Serv. | @E 9,999,999.99 | R | S | ||||
| VIW_ALQSER | N | 5 | 2 | Alq ISS Serv | @E 99.99 | R | S | ||||
| VIW_DESSR | N | 11 | 2 | Descto Sv | @E 99,999,999.99 | R | S | ||||
| VIW_CODIT2 | C | 20 | 0 | Codigo Item | @! | R | S | ||||
| VIW_DESIT2 | C | 30 | 0 | Desc Item | @! | R | S | ||||
| VIW_QTDIT2 | N | 6 | 0 | Qtdade | @E 999,999 | R | S | ||||
| VIW_VUNIT2 | N | 9 | 2 | Valor Unit. | @E 999,999.99 | R | S | ||||
| VIW_VTOTP2 | N | 10 | 2 | Vl Tot Peca | @E 9,999,999.99 | R | S | ||||
| VIW_ALQIC2 | N | 5 | 2 | Aliq. ICM | @E 99.99 | R | S | ||||
| VIW_ALQPC2 | N | 5 | 2 | Alq Pis/Cof | @E 99.99 | R | S | ||||
| VIW_DESPC2 | N | 11 | 2 | Descto Peca | @E 99,999,999.99 | R | S | ||||
| VIW_CODSE2 | C | 8 | 0 | Cod. Servico | @! | R | S | ||||
| VIW_DESSE2 | C | 30 | 0 | Desc.Ser. | @! | R | S | ||||
| VIW_HORVE2 | N | 5 | 0 | Hora Vend. | @E 99,999 | R | S | ||||
| VIW_TOTSE2 | N | 10 | 2 | Tot Serv. | @E 9,999,999.99 | R | S | ||||
| VIW_ALQSE2 | N | 5 | 2 | Alq ISS Serv | @E 99.99 | R | S | ||||
| VIW_DESSR2 | N | 11 | 2 | Descto Serv | @E 99,999,999.99 | R | S | ||||
| VIW_NUMNFI | C | 9 | 0 | Numero NF | @! | R | S | ||||
| VIW_SERNFI | C | 3 | 0 | Serie NF | !!! | R | S | ||||
| VIW_NUMOSV | C | 8 | 0 | Nro OS | @K! | R | S | ||||
| VIW_TIPSER | C | 1 | 0 | Tipo de Serv | @! | R | S | ||||
| VIW_VLIQPC | N | 8 | 2 | Vl Liq Peca | @E 99,999.99 | R | S | ||||
| VIW_VLIQP2 | N | 8 | 2 | V Liq Peca 2 | @E 99,999.99 | R | S | ||||
| VIW_VLIQSR | N | 8 | 2 | V Liq Serv | @E 99,999.99 | R | S | ||||
| VIW_VLIQS2 | N | 8 | 2 | V Liq Serv 2 | @E 99,999.99 | R | S | ||||
| VIW_TIPSE2 | C | 1 | 0 | Tp Srv 2 | @! | R | S | ||||
| VIW_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||