Tabela |
VIV |
Nota Fiscal Veiculos GM |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
VIV_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
N |
VIV_CODMAR |
C |
3 |
0 |
Cod Marca |
@! |
|
|
R |
|
|
N |
VIV_NUMNFI |
C |
9 |
0 |
Nro da NF |
@! |
|
|
R |
|
|
N |
VIV_SERNFI |
C |
3 |
0 |
Serie da NF |
!!! |
|
|
R |
|
|
N |
VIV_FABRIC |
C |
2 |
0 |
Fabrica |
@!S2 |
|
|
R |
|
|
N |
VIV_DATNFI |
D |
8 |
0 |
Data NF |
|
|
|
R |
|
|
N |
VIV_CNPJ |
C |
14 |
0 |
CNPJ |
@! |
|
|
R |
|
|
N |
VIV_CODPED |
C |
7 |
0 |
Cod Pedido |
@! |
|
|
R |
|
|
N |
VIV_MODVEI |
C |
30 |
0 |
Mod Veiculo |
@! |
|
|
R |
|
|
N |
VIV_FABMOD |
C |
8 |
0 |
Ano Fabr/Mod |
@R 9999/9999 |
|
|
R |
|
|
N |
VIV_CHASSI |
C |
25 |
0 |
Chassi |
@!S25 |
|
|
R |
|
|
N |
VIV_CABINA |
C |
10 |
0 |
Cabina |
@! |
|
|
R |
|
|
N |
VIV_CAMBIO |
C |
10 |
0 |
Cambio |
@! |
|
|
R |
|
|
N |
VIV_DIFERE |
C |
20 |
0 |
Diferencial |
@! |
|
|
R |
|
|
N |
VIV_MOTOR |
C |
10 |
0 |
Motor |
@! |
|
|
R |
|
|
N |
VIV_COREXT |
C |
48 |
0 |
Cor Externa |
@! |
|
|
R |
|
|
N |
VIV_CORINT |
C |
48 |
0 |
Cor Interna |
@! |
|
|
R |
|
|
N |
VIV_OPCION |
C |
72 |
0 |
Opcionais |
@! |
|
|
R |
|
|
N |
VIV_CODCHA |
C |
10 |
0 |
Cod Chave |
@! |
|
|
R |
|
|
N |
VIV_VALOR |
N |
13 |
2 |
Valor |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_BAICMS |
N |
13 |
2 |
Base ICMS |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_ALICMS |
N |
5 |
2 |
Aliq ICMS |
@E 99.99 |
|
|
R |
|
|
N |
VIV_TOTICM |
N |
13 |
2 |
Total ICMS |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_ALIPI |
N |
5 |
2 |
Aliq IPI |
@E 99.99 |
|
|
R |
|
|
N |
VIV_TOTIPI |
N |
13 |
2 |
Total IPI |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_ICMSUB |
N |
13 |
2 |
ICMS Subst |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_BICMSU |
N |
13 |
2 |
Base ICM Sub |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_SEGURO |
N |
13 |
2 |
Seguro |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_TOTNFI |
N |
13 |
2 |
Total Nf |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_DESCON |
N |
13 |
2 |
Desconto |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_BPISSU |
N |
13 |
2 |
Base PIS Sub |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_PISSUB |
N |
13 |
2 |
PIS Subst |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_BCOFSU |
N |
13 |
2 |
Base COF Sub |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_COFSUB |
N |
13 |
2 |
COFINS Subst |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
VIV_CONPAG |
C |
3 |
0 |
Cond Pagto |
@! |
|
|
R |
|
|
N |
VIV_DESMOD |
C |
40 |
0 |
Desc modelo |
@! |
|
|
R |
|
|
N |
VIV_OK |
C |
2 |
0 |
Iden.Selecao |
|
|
|
R |
|
|
N |
VIV_TIPPLA |
C |
1 |
0 |
Tipo Plano |
@! |
|
|
R |
|
|
S |
VIV_SUBCOD |
C |
2 |
0 |
SUB-CODIGO |
@! |
|
|
|
|
|
S |
VIV_SDOC |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |