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