Tabela |
SN1 |
Ativo Imobilizado |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
N1_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
N1_GRUPO |
C |
4 |
0 |
Grupo |
|
(Vazio() .Or. ExistCpo("SNG")) .And. AF012ATAXA(.T.) .AND. AF012AFNG() .AND. AF012ACHCC(.T.) |
SNG |
|
|
|
S |
N1_INDAVP |
C |
2 |
0 |
Indice AVP |
@! |
FA012VldAvp(M->N1_DTAVP, M->N1_INDAVP) |
FIT |
R |
|
AF012AVPWhen() |
S |
N1_PATRIM |
C |
1 |
0 |
Classificac. |
@! |
Vazio() .Or. ExistCpo("SN0", "07"+M->N1_PATRIM) |
|
|
#AdmCBGener(xFilial("SN0"),"SN0","07","N") |
|
S |
N1_CBASE |
C |
10 |
0 |
Cod. do Bem |
@! |
EXISTCHAV("SN1",M->N1_CBASE+M->N1_ITEM) .And. FreeForUse("SN1",M->N1_CBASE) |
|
|
|
|
S |
N1_BITMAP |
C |
20 |
0 |
Foto do Bem |
|
|
|
|
|
|
S |
N1_ITEM |
C |
4 |
0 |
Item |
@! |
EXISTCHAV("SN1",M->N1_CBASE+M->N1_ITEM) |
|
|
|
|
S |
N1_AQUISIC |
D |
8 |
0 |
Dt.Aquisicao |
|
M->N1_AQUISIC <= DDATABASE .AND. AF012ANALT() .AND. ATFDINDPRE() |
|
|
|
|
S |
N1_QUANTD |
N |
11 |
3 |
Quantidade |
@E 9,999,999.999 |
POSITIVO() |
|
|
|
|
S |
N1_BAIXA |
D |
8 |
0 |
Dt.de Baixa |
|
|
|
|
|
|
S |
N1_DESCRIC |
C |
40 |
0 |
Descr. Sint. |
@! |
|
|
|
|
|
S |
N1_CHAPA |
C |
20 |
0 |
Num.Plaqueta |
@! |
IIF(INCLUI, AF012ACHAP(),.T.) |
|
|
|
|
S |
N1_APOLICE |
C |
15 |
0 |
Num. Apolice |
|
Vazio() .Or. ExistCpo("SNB",M->N1_APOLICE) |
SNB |
R |
|
|
S |
N1_CODSEG |
C |
6 |
0 |
Cod.Cia.Seg. |
@! |
Vazio() .Or. ExistCpo("SNB",M->N1_APOLICE+M->N1_CODSEG) |
SNBSEG |
R |
|
|
S |
N1_DTVENC |
D |
8 |
0 |
Venc Apolice |
|
Vazio() .Or. M->N1_DTVENC >= M->N1_AQUISIC |
|
|
|
|
S |
N1_CSEGURO |
C |
25 |
0 |
Cia.Seguro |
@! |
|
|
|
|
|
S |
N1_TIPOSEG |
C |
5 |
0 |
Tipo Seguro |
@! |
|
|
|
|
|
S |
N1_FORNEC |
C |
6 |
0 |
Cod. Fornec. |
@! |
Vazio() .Or. EXISTCPO("SA2",Iif(!EMPTY(M->N1_LOJA),M->N1_FORNEC +M->N1_LOJA,M->N1_FORNEC ),,,,!EMPTY(M->N1_LOJA)) |
FOR |
|
|
|
S |
N1_LOJA |
C |
2 |
0 |
Loja Fornec. |
@! |
EXISTCPO("SA2",M->N1_FORNEC+M->N1_LOJA) |
|
|
|
|
S |
N1_LOCAL |
C |
6 |
0 |
Endereco |
@! |
Vazio() .Or. ExistCpo("SNL",M->N1_LOCAL) |
SNL |
|
|
|
S |
N1_NSERIE |
C |
3 |
0 |
Serie N.F. |
|
|
|
|
|
|
S |
N1_NFISCAL |
C |
9 |
0 |
Nota Fiscal |
@! |
|
|
|
|
|
S |
N1_PROJETO |
C |
10 |
0 |
Cod. Projeto |
|
Vazio() .Or. ExistCpo("FNB",M->N1_PROJETO,,,,.F.) |
FNB02 |
R |
|
AF012UPRJ() |
S |
N1_CHASSIS |
C |
25 |
0 |
Nro Chassis |
@! |
|
|
|
|
|
S |
N1_PLACA |
C |
7 |
0 |
Numero Placa |
@! |
|
|
|
|
|
S |
N1_STATUS |
C |
1 |
0 |
Status Bem |
@! |
Pertence(" 0|1|2|3|4") |
|
|
0=Pendente de classificacao;1=Em Uso;2=Bloqueado por usuario;3=Bloqueado por local;4=Transferencia interna entre filiais |
|
S |
N1_CODCIAP |
C |
6 |
0 |
Codigo CIAP |
@! |
Vazio() .Or. (ExistCpo("SF9") .And. AF012ACIAP()) |
SF9 |
|
|
|
S |
N1_ICMSAPR |
N |
16 |
2 |
Icms do Item |
@E 9,999,999,999,999.99 |
Positivo() .And. AF012ACIAP() |
|
|
|
|
S |
N1_DTBLOQ |
D |
8 |
0 |
Data bloquei |
|
|
|
|
|
|
S |
N1_CODBEM |
C |
16 |
0 |
Bem MNT |
@! |
Vazio() .Or. ExistCpo("ST9",M->N1_CODBEM) |
ST9 |
|
|
|
N |
N1_BASESUP |
C |
10 |
0 |
Codigo Base |
|
ExistCpo("SN1") .And. If(Empty(M->N1_ITEMSUP), .T., M->N1_CBASE + M->N1_ITEM <> M->N1_BASESUP + M->N1_ITEMSUP) |
SN1 |
|
|
|
S |
N1_ITEMSUP |
C |
4 |
0 |
Item Sup |
|
M->N1_CBASE + M->N1_ITEM <> M->N1_BASESUP + M->N1_ITEMSUP .And. ExistCpo("SN1", M->N1_BASESUP+M->N1_ITEMSUP) |
|
|
|
|
S |
N1_CALCPIS |
C |
1 |
0 |
Calc. PIS |
|
Pertence("123") |
|
|
1=Sim;2=Nao;3=Fracao |
|
S |
N1_CODBAR |
C |
20 |
0 |
Cod. Barras |
|
|
|
|
|
|
S |
N1_CONSAB |
C |
1 |
0 |
Mtd. Deprec. |
@! |
Pertence("12") |
|
|
1=Aquisicao;2=Baixa |
|
S |
N1_PENHORA |
C |
1 |
0 |
Sit. Penhora |
@! |
|
|
R |
0=Normal;1=Em Garantia;2=Em Penhora;3=Penhorado |
|
S |
N1_MESCPIS |
N |
3 |
0 |
Meses Cl.Pis |
999 |
|
|
|
|
|
S |
N1_DTCLASS |
D |
8 |
0 |
Data Classif |
|
|
|
|
|
|
S |
N1_DIACTB |
C |
2 |
0 |
Cod. Diario |
@! |
VldCodSeq() |
CVL |
|
|
CtbWDia() |
S |
N1_NODIA |
C |
10 |
0 |
Seq. Diario |
@! |
|
|
|
|
|
S |
N1_TAXAPAD |
C |
6 |
0 |
Cod.Tx.Pad. |
@! |
Vazio() .Or. ExistCpo('SNH',M->N1_TAXAPAD) |
SNH |
|
|
Empty(M->N1_TAXAPAD) .Or. A012TxRAlt(M->N1_GRUPO) |
S |
N1_CIAP |
C |
1 |
0 |
Gera CIAP? |
@! |
|
|
V |
1=Sim;2=Nao |
|
S |
N1_CODCUSD |
C |
20 |
0 |
Cod. Custod. |
@! |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_TPCUSTD |
C |
1 |
0 |
Tipo Custod. |
@! |
|
|
|
1=CETIP;2=SELIC;3=CBLC;4=Outros |
|
S |
N1_TPBEM |
C |
4 |
0 |
Tipo Bem |
@! |
Vazio() .Or. ExistCpo("SX5",If(Empty(M->N1_TPCUSTD),"GF","GE") + M->N1_TPBEM) |
X5GEGF |
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_TPOUTR |
C |
50 |
0 |
Tp. Outros |
@! |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_CODRGI |
C |
50 |
0 |
Cod. RGI |
@! |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_NOMCART |
C |
50 |
0 |
Nome Cart. |
@! |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_AREA |
N |
13 |
2 |
Area |
@E 9,999,999,999.99 |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_REDE |
C |
1 |
0 |
Rede Prop. |
@! |
|
|
|
S=Sim;N=Nao |
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_LOGIMOV |
C |
80 |
0 |
Lograd.Imov. |
@! |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_NRIMOV |
C |
20 |
0 |
Nro. Imov. |
@1 |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_COMIMOV |
C |
15 |
0 |
Comp.Imov. |
@! |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_BAIIMOV |
C |
20 |
0 |
B. Imovel |
@! |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_MUNIMOV |
C |
40 |
0 |
Mun. Imov. |
@! |
|
|
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_SIGLAUF |
C |
2 |
0 |
UF Imov. |
@! |
ExistCpo('SX5','12'+M->N1_SIGLAUF) |
12 |
|
|
Empty( M->N1_TPCUSTD ) .Or. M->N1_TPCUSTD = "4" |
S |
N1_CEPIMOV |
C |
8 |
0 |
CEP Imovel |
@R 99999-999 |
|
|
|
|
Empty(M->N1_TPCUSTD) |
S |
N1_DETPATR |
C |
2 |
0 |
Identif.Bem |
@! |
Vazio().OR.ExistCpo('SN0','11'+M->N1_DETPATR) |
SN011 |
R |
|
|
S |
N1_QUALIFI |
C |
1 |
0 |
Qualificacao |
@! |
PERTENCE(" 0|1|2|3|4|") |
|
|
1=Recuperavel;2=Ocioso;3=Irrecuperavel;4=Anti-economico |
|
S |
N1_UTIPATR |
C |
2 |
0 |
Utiliz.Bem |
@! |
Vazio().OR.ExistCpo('SN0','12'+M->N1_UTIPATR) |
SN012 |
R |
|
|
S |
N1_DLOCAL |
C |
80 |
0 |
Desc. Local |
@! |
|
|
V |
|
|
S |
N1_NATBEM |
C |
1 |
0 |
Natureza Bem |
@! |
|
|
R |
|
|
S |
N1_TPDEPR |
C |
1 |
0 |
Tipo Deprec |
@! |
Vazio() .Or. Pertence(' 15') |
|
|
1=Cotas constantes;5=Cotas degressivas |
|
S |
N1_ORIGEM |
C |
15 |
0 |
Rot Origem |
@! |
|
|
|
|
|
S |
N1_TAXAVP |
N |
14 |
8 |
Taxa Indice |
@E 99,999.99999999 |
Positivo() |
|
R |
|
|
S |
N1_PRODUTO |
C |
15 |
0 |
Cod. Produto |
@! |
ExistCpo( "SB1", M->N1_PRODUTO ) |
SB1 |
|
|
|
S |
N1_OK |
C |
2 |
0 |
Flag Marca |
|
|
|
|
|
|
S |
N1_TPCTRAT |
C |
1 |
0 |
Tp Controle |
@! |
Pertence('123') |
|
R |
1=Proprio;2=Terceiro;3=Em Terceiro |
ATF012WHEN() |
S |
N1_NFESPEC |
C |
5 |
0 |
Especie |
@! |
|
|
|
|
|
S |
N1_NFITEM |
C |
4 |
0 |
Item |
@! |
|
|
|
|
|
S |
N1_PROJREV |
C |
4 |
0 |
Rev. Projeto |
@! |
|
|
R |
|
|
S |
N1_PROJETP |
C |
3 |
0 |
Etapa Prj |
@! |
|
|
R |
|
|
S |
N1_PROJITE |
C |
3 |
0 |
Item projeto |
@! |
|
|
R |
|
|
S |
N1_INIAVP |
D |
8 |
0 |
Dt. Ini AVP |
|
A012VInAVP() |
|
R |
|
|
S |
N1_DTAVP |
D |
8 |
0 |
Dt. Execucao |
|
FA012VldAvp(M->N1_DTAVP, M->N1_INDAVP) |
|
R |
|
|
S |
N1_ORIGCRD |
C |
1 |
0 |
Orig. Cred. |
@! |
Pertence(' 01') |
|
R |
0=Aq.Mercado Interno;1=Aq.Mercado externo |
|
S |
N1_CSTPIS |
C |
2 |
0 |
Sit.Trib.PIS |
@! |
Vazio().Or.ExistCpo('SX5','SX'+M->N1_CSTPIS) |
SX |
R |
|
|
S |
N1_ALIQPIS |
N |
5 |
2 |
Aliq. PIS |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
N1_CSTCOFI |
C |
2 |
0 |
Sit.Trib.Cof |
@! |
Vazio().Or.ExistCpo('SX5','SX'+M->N1_CSTCOFI) |
SX |
R |
|
|
S |
N1_ALIQCOF |
N |
5 |
2 |
Aliq. Cofins |
@E 99.99 |
Positivo() |
|
R |
|
|
S |
N1_CODBCC |
C |
2 |
0 |
Cod.BC Cred. |
@! |
Vazio().Or.ExistCpo('SX5','MZ'+M->N1_CODBCC) |
MZ |
R |
|
|
S |
N1_TPAVP |
C |
1 |
0 |
Tipo AVP |
@! |
Pertence("12") .And. AF012TPAVP() |
|
R |
1=Total;2=Parcela |
|
S |
N1_MARGEM |
C |
6 |
0 |
Cod. Margem |
@! |
FA012MrgVld(M->N1_MARGEM, M->N1_REVMRG) |
FNQ |
R |
|
AF012MrgWhen() |
S |
N1_REVMRG |
C |
4 |
0 |
Rev. Margem |
@! |
FA012MrgVld(M->N1_MARGEM, M->N1_REVMRG) |
|
R |
|
|
S |
N1_PROVIS |
C |
10 |
0 |
Provisao |
@! |
Vazio() .Or. FA012PrvVld(M->N1_PROVIS) |
FNU |
R |
|
AF012PrvWhen() |
S |
N1_CBCPIS |
C |
1 |
0 |
Base PIS/COF |
@! |
|
|
R |
1=Normal;2=Cadastro do Bem |
|
S |
N1_INDPRO |
C |
1 |
0 |
Tp. processo |
@! |
Pertence(" 01239") |
|
R |
0=Sefaz;1=Justica Federal;2=Justica Estadual;3=Secex/SRF;9=Outros |
|
S |
N1_NUMPRO |
C |
10 |
0 |
Proc. Refer |
@! |
Vazio().Or.ExistCpo('CCF') |
|
R |
|
|
S |
N1_VLAQUIS |
N |
16 |
2 |
Vl Aquisicao |
@E 9,999,999,999,999.99 |
Positivo() |
|
|
|
|
S |
N1_NUMSEQ |
C |
6 |
0 |
Num. Movimen |
@! |
|
|
R |
|
|
S |
N1_SDOC |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |
N1_LNG |
N |
10 |
6 |
Longitude |
@E 999.999999 |
|
|
R |
|
|
S |
N1_LAT |
N |
10 |
6 |
Latitude |
@E 999.999999 |
|
|
R |
|
|
S |