Tabela
SI3 Centros de Custos
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
I3_FILIAL C 2 0 Filial S
I3_CUSTO C 9 0 Cod Custo @! existchav("SI3",m->i3_custo+m->i3_conta+m->i3_moeda) .And. Ctba030Cus(m->i3_custo) S
I3_CONTA C 20 0 Cod Conta @! existcpo("SI1") SI1 S
I3_MOEDA C 1 0 Moeda @! existchav("SI3",m->i3_custo+m->i3_conta+m->i3_moeda) .and. pertence(" 12345") 1=Moeda 1;2=Moeda 2;3=Moeda 3;4=Moeda 4;5=Moeda 5 S
I3_DESC C 25 0 Desc CCusto @! S
I3_SALINI N 16 2 Saldo Inic @E 9,999,999,999,999.99 S
I3_DEB01 N 16 2 Deb Per 01 @E 9,999,999,999,999.99 S
I3_CRE01 N 16 2 Cred Per 01 @E 9,999,999,999,999.99 S
I3_DEB02 N 16 2 Deb Per 02 @E 9,999,999,999,999.99 S
I3_CRE02 N 16 2 Cred Per 02 @E 9,999,999,999,999.99 S
I3_DEB03 N 16 2 Deb Per 03 @E 9,999,999,999,999.99 S
I3_CRE03 N 16 2 Cred Per 03 @E 9,999,999,999,999.99 S
I3_DEB04 N 16 2 Deb Per 04 @E 9,999,999,999,999.99 S
I3_CRE04 N 16 2 Cred Per 04 @E 9,999,999,999,999.99 S
I3_DEB05 N 16 2 Deb Per 05 @E 9,999,999,999,999.99 S
I3_CRE05 N 16 2 Cred Per 05 @E 9,999,999,999,999.99 S
I3_DEB06 N 16 2 Deb Per 06 @E 9,999,999,999,999.99 S
I3_CRE06 N 16 2 Cred Per 06 @E 9,999,999,999,999.99 S
I3_DEB07 N 16 2 Deb Per 07 @E 9,999,999,999,999.99 S
I3_CRE07 N 16 2 Cred Per 07 @E 9,999,999,999,999.99 S
I3_DEB08 N 16 2 Deb Per 08 @E 9,999,999,999,999.99 S
I3_CRE08 N 16 2 Cred Per 08 @E 9,999,999,999,999.99 S
I3_DEB09 N 16 2 Deb Per 09 @E 9,999,999,999,999.99 S
I3_CRE09 N 16 2 Cred Per 09 @E 9,999,999,999,999.99 S
I3_DEB10 N 16 2 Deb Per 10 @E 9,999,999,999,999.99 S
I3_CRE10 N 16 2 Cred Per 10 @E 9,999,999,999,999.99 S
I3_DEB11 N 16 2 Deb Per 11 @E 9,999,999,999,999.99 S
I3_CRE11 N 16 2 Cred Per 11 @E 9,999,999,999,999.99 S
I3_DEB12 N 16 2 Deb Per 12 @E 9,999,999,999,999.99 S
I3_CRE12 N 16 2 Cred Per 12 @E 9,999,999,999,999.99 S
I3_DEB13 N 16 2 Deb Per 13 @E 9,999,999,999,999.99 S
I3_CRE13 N 16 2 Cred Per 13 @E 9,999,999,999,999.99 S
I3_DEB14 N 16 2 Deb Per 14 @E 9,999,999,999,999.99 S
I3_CRE14 N 16 2 Cred Per 14 @E 9,999,999,999,999.99 S
I3_DEB15 N 16 2 Deb Per 15 @E 9,999,999,999,999.99 S
I3_CRE15 N 16 2 Cred Per 15 @E 9,999,999,999,999.99 S
I3_DEB16 N 16 2 Deb Per 16 @E 9,999,999,999,999.99 S
I3_CRE16 N 16 2 Cred Per 16 @E 9,999,999,999,999.99 S
I3_DEB17 N 16 2 Deb Per 17 @E 9,999,999,999,999.99 S
I3_CRE17 N 16 2 Cred Per 17 @E 9,999,999,999,999.99 S
I3_PERCACI N 8 4 % Acid.Trab. @E 999.9999 S
I3_DESCEST C 25 0 Desc Estrang S
I3_PERFPAS N 7 3 % Terceiros @E 999.999 S
I3_PERLP C 6 0 Periodo LP @! S
I3_STATUS C 1 0 Status @! Pertence("AI") A=Ativo;I=Inativo S
I3_VLRLPD N 16 2 Vlr LP Debit @E 9,999,999,999,999.99 S
I3_FILMAT C 2 0 Fil.Respons QA_CHKFIL(M->I3_FILMAT) SM0 S
I3_VLRLPC N 16 2 Vlr LP Credt @E 9,999,999,999,999.99 S
I3_MAT C 6 0 Cod.Respons. QA_CHKMAT(M->I3_FILMAT,M->I3_MAT) .AND. !EMPTY(M->I3_NMAT := QA_NUSR(M->I3_FILMAT,M->I3_MAT,.T.)) SRA S
I3_NMAT C 40 0 Nom.Respons. V S
I3_NOME C 40 0 Nome Tomador @! S
I3_ENDEREC C 40 0 End. Tomador @! S
I3_BAIRRO C 20 0 Bair.Tomador @! S
I3_CEP C 8 0 Cep Tomador @R 99999-999 S
I3_MUNICIP C 20 0 Mun.Tomador @! S
I3_ESTADO C 2 0 Estado @! EXISTCPO("SX5","12"+M->I3_ESTADO) 12 S
I3_TIPO C 1 0 T.Insc.Tomad ! Vazio() .Or. Pertence ("12") 1=CNPJ;2=CEI S
I3_CEI C 14 0 CNPJ/CEI Tom S
I3_VALFAT N 12 2 Vlr.Fatura @E 999,999,999.99 S
I3_RETIDO N 12 2 Vlr.Retido @E 999,999,999.99 S
I3_LOCAL C 2 0 Almoxarifado @! S
I3_OCORREN C 2 0 Ocorrencia @! S
I3_OPERAC C 3 0 Operacao @! EXISTCPO('TSZ',M->I3_OPERAC) TSZ S
I3_DTEXIS D 8 0 Dt.Ini.Exis. 99/99/9999 S
I3_CODMUN C 7 0 Cod.Munic. @! R S
I3_PEREMP N 8 4 % Empresa @E 999.9999 Positivo() R S
I3_RECFAT C 1 0 Rec.Fatur. @! R 1=Sim;2=Nao S