Tabela |
GIC |
Bilhetes |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
GIC_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
GIC_LOTE |
C |
8 |
0 |
Lote |
@! |
|
|
R |
|
|
S |
GIC_ITEM |
C |
4 |
0 |
Item |
@! |
|
|
R |
|
|
S |
GIC_SERIE |
C |
3 |
0 |
Serie |
@! |
|
GICGQG |
R |
|
|
S |
GIC_BILHET |
C |
36 |
0 |
Num.Bilhete |
@! |
|
|
R |
|
|
S |
GIC_DTVIAG |
D |
8 |
0 |
Dt.Viagem |
|
|
|
R |
|
|
S |
GIC_LOCORI |
C |
6 |
0 |
Loc.Origem |
@! |
Vazio() .or. ExistCpo('GI1') |
GI1 |
R |
|
|
S |
GIC_NLOCOR |
C |
40 |
0 |
Local Origem |
@! |
|
|
V |
|
|
S |
GIC_LOCDES |
C |
6 |
0 |
Cod.Loc.Des. |
@! |
Vazio() .or. ExistCpo('GI1') |
GI1 |
R |
|
|
S |
GIC_NLOCDE |
C |
40 |
0 |
Local Dest. |
@! |
|
|
V |
|
|
S |
GIC_HORA |
C |
4 |
0 |
Hora Saida |
@R 99:99 |
Vazio() .Or. AtVldHora(M->GIC_HORA) |
|
R |
|
|
S |
GIC_LINHA |
C |
6 |
0 |
Cod.Linha |
@! |
Vazio() .or. ExistCpo('GI2') |
GI2 |
R |
|
|
S |
GIC_NLINHA |
C |
81 |
0 |
Nome Linha |
@! |
|
|
V |
|
|
S |
GIC_SECORI |
C |
4 |
0 |
Sec.Origem |
@! |
|
|
R |
|
|
S |
GIC_SECDES |
C |
4 |
0 |
Sec.Destino |
@! |
|
|
R |
|
|
S |
GIC_TAR |
N |
8 |
2 |
Tarifa |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_TAX |
N |
8 |
2 |
Tx.Embarque |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_PED |
N |
8 |
2 |
Pedagio |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_SGFACU |
N |
8 |
2 |
Seg.Faculta. |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_TARTAB |
N |
8 |
2 |
TarifaTabela |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_TAXTAB |
N |
8 |
2 |
TxEmbarqueTb |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_PEDTAB |
N |
8 |
2 |
Pedagio Tb. |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_SGTAB |
N |
8 |
2 |
Seg. Tabela |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_NUMCOM |
C |
3 |
0 |
Num.Compl. |
@! |
|
|
R |
|
|
S |
GIC_ITECOM |
C |
4 |
0 |
Item Comiss. |
@! |
|
|
R |
|
|
S |
GIC_CANCEL |
C |
1 |
0 |
Cancelado |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
GIC_ABERTO |
C |
1 |
0 |
Em Aberto |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
GIC_AGENCI |
C |
6 |
0 |
Agencia |
@! |
Vazio() .Or. ExistCpo('GI6') |
GI6 |
R |
|
|
S |
GIC_DOC |
C |
4 |
0 |
Doc. Apurac. |
@! |
|
|
R |
|
|
S |
GIC_SENTID |
C |
1 |
0 |
Sentido |
@R 9 |
Pertence("12") |
|
R |
1=Ida;2=Volta |
|
S |
GIC_SDOCNF |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |
GIC_SERNFS |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |
GIC_CODIGO |
C |
8 |
0 |
Codigo |
@! |
ExistChav('GIC') |
|
R |
|
|
S |
GIC_TIPO |
C |
1 |
0 |
Tipo |
|
Pertence("ITEMPW") |
|
R |
I=Informatizada;T=Troca;E=Embarcada;M=Manual;P=Impressao Posterior;W=Venda Web |
|
S |
GIC_CODGID |
C |
11 |
0 |
Cod. Horario |
@! |
vazio() .or. existcpo("GID") |
GIDGIC |
R |
|
|
S |
GIC_CODSRV |
C |
6 |
0 |
Cod. Viagem |
@! |
Vazio() .Or. ExistCpo('GYN') |
GYNGIC |
R |
|
|
S |
GIC_OUTTOT |
N |
8 |
2 |
Outros Tot. |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_VALTOT |
N |
9 |
2 |
Val. Total |
@E 999,999.99 |
|
|
R |
|
|
S |
GIC_DESAGE |
C |
30 |
0 |
Nome Agencia |
@! |
|
|
V |
|
|
S |
GIC_COLAB |
C |
6 |
0 |
Cod. Colab |
|
Vazio() .Or. existcpo("GYG") |
GYG |
R |
|
|
S |
GIC_NCOLAB |
C |
30 |
0 |
Nome Colab. |
@! |
|
|
V |
|
|
S |
GIC_ECF |
C |
3 |
0 |
Codigo ECF |
@! |
Vazio() |
SLG |
R |
|
|
S |
GIC_DTVEND |
D |
8 |
0 |
Dt Emissao |
|
|
|
R |
|
|
S |
GIC_HRVEND |
C |
8 |
0 |
Hr Emissao |
@r 99:99 |
Vazio() .Or. AtVldHora(M->GIC_HRVEND) |
|
R |
|
|
S |
GIC_STATUS |
C |
1 |
0 |
Status |
|
Pertence("VCTEDI") |
|
R |
V=Vendido;C=Cancelado;T=Transferido;E=Entregue;D=Devolvido;I=Inutilizado |
|
S |
GIC_CODREQ |
C |
6 |
0 |
Num. Req. |
@! |
ExistChav("GQW") |
|
R |
|
|
S |
GIC_REQDSC |
N |
9 |
2 |
Desc. Req. |
@E 999,999.99 |
Positivo() |
|
R |
|
|
S |
GIC_REQTOT |
N |
9 |
2 |
Tot. Req. |
@E 999,999.99 |
Positivo() |
|
R |
|
|
S |
GIC_NUMFCH |
C |
10 |
0 |
Fch. Remessa |
@! |
|
|
R |
|
|
S |
GIC_CARGA |
L |
1 |
0 |
Carga |
|
|
|
R |
|
|
S |
GIC_BILREF |
C |
8 |
0 |
Bilhete Ref |
@! |
|
GIC |
R |
|
|
S |
GIC_MOTCAN |
C |
120 |
0 |
Motiv Cancel |
@! |
|
|
R |
|
|
S |
GIC_ORIGEM |
C |
1 |
0 |
Origem |
|
Pertence("12") |
|
R |
1=Manual;2=Eletronica |
|
S |
GIC_TIPDOC |
C |
6 |
0 |
Tipo Docto. |
@! |
|
GYA |
R |
|
|
S |
GIC_SUBSER |
C |
3 |
0 |
Sub Serie |
@! |
|
|
R |
|
|
S |
GIC_CONFER |
C |
1 |
0 |
Conferencia |
@! |
|
|
R |
1=Nao Conferido;2=Conferido;3=Rejeitado |
|
S |
GIC_CODGY3 |
C |
6 |
0 |
Cod.Demonstr |
@! |
|
|
R |
|
|
S |
GIC_VLACER |
N |
8 |
2 |
Vlr. Acerto |
@E 99,999.99 |
Positivo() |
|
R |
|
|
S |
GIC_NUMDOC |
C |
6 |
0 |
Num.Docto. |
@! |
|
GICGII |
R |
|
|
S |
GIC_DTCONF |
D |
8 |
0 |
Data Conf. |
|
|
|
R |
|
|
S |
GIC_MOTREJ |
C |
80 |
0 |
Mot. Rej. |
@! |
|
|
R |
|
|
S |
GIC_CODGQ6 |
C |
6 |
0 |
Cīd.Calculo |
@! |
|
|
R |
|
|
S |
GIC_PERCOM |
N |
6 |
2 |
Perc. Com. |
@E 999.99 |
|
|
R |
|
|
S |
GIC_PERIMP |
N |
6 |
2 |
Perc. Imp. |
@E 999.99 |
|
|
R |
|
|
S |
GIC_VALCOM |
N |
8 |
2 |
Vlr.Comissao |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_VALIMP |
N |
8 |
2 |
Vlr. Imposto |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_NOTA |
C |
9 |
0 |
Nota |
@! |
|
|
R |
|
|
S |
GIC_CLIENT |
C |
6 |
0 |
Cliente |
@! |
|
|
R |
|
|
S |
GIC_LOJA |
C |
2 |
0 |
Loja |
@! |
|
|
R |
|
|
S |
GIC_STAPRO |
C |
1 |
0 |
Status Proc |
@! |
|
|
R |
0=Nao Processado;1=Gerado NF;2=Erro no processamento |
|
S |
GIC_FILNF |
C |
2 |
0 |
Filial NF |
|
|
|
R |
|
|
S |
GIC_SERINF |
C |
3 |
0 |
Serie NF |
@! |
|
|
R |
|
|
S |
GIC_ECFSER |
C |
25 |
0 |
Serie ECF |
@! |
|
|
R |
|
|
S |
GIC_ECFSEQ |
C |
3 |
0 |
Seq. ECF |
@! |
|
|
R |
|
|
S |
GIC_CCF |
C |
6 |
0 |
CCF |
@! |
|
|
R |
|
|
S |
GIC_HRREAL |
C |
4 |
0 |
Hr Part Real |
@R 99:99 |
Vazio() .Or. AtVldHora(M->GIC_HRREAL) |
|
|
|
|
S |
GIC_DTMOVI |
D |
8 |
0 |
Data Mov. |
|
|
|
R |
|
|
S |
GIC_NFORMU |
C |
10 |
0 |
Formulario |
@! |
|
|
R |
|
|
S |
GIC_TPVEND |
C |
6 |
0 |
Tipo Venda |
@! |
|
|
R |
|
|
S |
GIC_PAGTXE |
C |
1 |
0 |
Tit Pg Tx Em |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
GIC_QTXEMB |
N |
2 |
0 |
Qtd.Tx.Emb. |
99 |
|
|
R |
|
|
S |
GIC_DESCLO |
C |
40 |
0 |
Local |
|
|
|
V |
|
|
S |
GIC_DTREM |
D |
8 |
0 |
Data Remissa |
|
|
|
R |
|
|
S |
GIC_TITCAN |
C |
18 |
0 |
Tit.Pag.Can |
@! |
|
|
R |
|
|
S |
GIC_TOTGER |
N |
8 |
2 |
Total Geral |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_TOTSEG |
N |
8 |
2 |
Total Seguro |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_TTXEM |
N |
8 |
2 |
Tot.Tx.Emb. |
@E 99,999.99 |
|
|
R |
|
|
S |
GIC_CATEG |
C |
6 |
0 |
Categoria |
@! |
|
|
R |
|
|
S |
GIC_TITPAG |
C |
18 |
0 |
Tit.Pagar |
@! |
|
|
R |
|
|
S |
GIC_NCOMPL |
C |
3 |
0 |
Num.Complem. |
@! |
|
|
R |
|
|
S |
GIC_CODLOC |
C |
6 |
0 |
Local |
|
|
GI1 |
R |
|
|
S |
GIC_VLBICM |
N |
14 |
2 |
Vlr.BaseICMS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
GIC_VLICMS |
N |
14 |
2 |
Vlr.ICMS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
GIC_VLPIS |
N |
14 |
2 |
Vlr.PIS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
GIC_VLCOF |
N |
14 |
2 |
Vlr.Cofins |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
GIC_CODRMD |
C |
12 |
0 |
Cod.RMD |
|
|
|
R |
|
|
S |
GIC_ALICMS |
N |
5 |
2 |
Aliq. ICMS |
@E 99.99 |
|
|
R |
|
|
S |
GIC_CODG9B |
C |
3 |
0 |
Cod Categ. |
@! |
ExistCpo('G9B') |
G9B |
R |
|
|
S |
GIC_DSCG9B |
C |
60 |
0 |
Desc Categ. |
@! |
|
|
V |
|
|
S |
GIC_MOTIVO |
M |
10 |
0 |
Motivo |
@! |
|
|
R |
|
|
S |
GIC_DTERRO |
D |
8 |
0 |
Data Motivo |
|
|
|
R |
|
|
S |
GIC_DTINCL |
C |
20 |
0 |
Dt Inclusao |
|
|
|
R |
|
|
S |
GIC_DTALTE |
C |
20 |
0 |
Dt Alteracao |
|
|
|
R |
|
|
S |
GIC_CHVBPE |
C |
44 |
0 |
Chave BPe |
|
|
|
R |
|
|
S |
GIC_NUMPRO |
C |
15 |
0 |
Nr Protocolo |
|
|
|
R |
|
|
S |
GIC_NUMBPE |
C |
9 |
0 |
Nr BP-e |
|
|
|
R |
|
|
S |
GIC_SERBPE |
C |
3 |
0 |
Serie BP-e |
|
|
|
R |
|
|
S |
GIC_TABBPE |
N |
15 |
2 |
Tarifa Tabel |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
GIC_VLRBPE |
N |
15 |
2 |
Vlr Br. BPe |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
GIC_VLRDSC |
N |
15 |
2 |
Vlr Desc BPe |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
GIC_VLRPGT |
N |
15 |
2 |
Vlr Pago BPe |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
GIC_TIPDSC |
C |
2 |
0 |
Tp Desc BPe |
|
|
|
R |
|
|
S |
GIC_DESDSC |
C |
100 |
0 |
Dsc Desconto |
|
|
|
R |
|
|
S |
GIC_CODCST |
C |
2 |
0 |
Codigo CST |
|
|
|
R |
|
|
S |
GIC_PREDBP |
N |
6 |
2 |
% Red BPe |
@E 999.99 |
|
|
R |
|
|
S |
GIC_VLRBCB |
N |
15 |
2 |
Vlr. BCB |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
GIC_ALIBPE |
N |
6 |
2 |
Ali ICMS BPe |
@E 999.99 |
|
|
R |
|
|
S |
GIC_VLIBPE |
N |
15 |
2 |
Vlr ICMS BPe |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
GIC_VLCRIC |
N |
15 |
2 |
Vlr Cred ICM |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
GIC_VLICDV |
N |
15 |
2 |
Vlr ICMS Dev |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
GIC_SIMPNA |
C |
1 |
0 |
Simp. Nascio |
|
|
|
R |
|
|
S |
GIC_VLTRIC |
N |
15 |
2 |
Vl Trib ICMS |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
GIC_INFADC |
M |
10 |
0 |
Info Adicion |
|
|
|
R |
|
|
S |
GIC_CHVACE |
C |
9 |
0 |
Chave Acesso |
|
|
|
R |
|
|
S |
GIC_MODALI |
C |
1 |
0 |
Modalidade |
|
|
|
R |
|
|
S |
GIC_TPEMIS |
C |
1 |
0 |
Tipo Emissao |
|
|
|
R |
|
|
S |
GIC_TPBPE |
C |
1 |
0 |
Tipo de BPe |
|
|
|
R |
|
|
S |
GIC_CHVSUB |
C |
44 |
0 |
Chv Substitu |
|
|
|
R |
|
|
S |
GIC_TPSUBS |
C |
1 |
0 |
Tp Subst BPe |
|
|
|
R |
|
|
S |
GIC_TPVIAG |
C |
2 |
0 |
Tp. Viagem |
|
|
|
R |
|
|
S |
GIC_INTEGR |
C |
1 |
0 |
Integrado? |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |