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 |