
| 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 | |||