| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SN3 | Saldos e Valores | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| N3_FILIAL | C | 2 | 0 | Filial | S | ||||||
| N3_CBASE | C | 10 | 0 | Cod Base Bem | @! | SN1 | S | ||||
| N3_ITEM | C | 4 | 0 | Codigo Item | @! | S | |||||
| N3_TIPO | C | 2 | 0 | Tipo Ativo | @9 | ExistCpo("SX5","G1"+M->N3_TIPO) .And. AF012ATIPO() .And. AF012AAQUI() | G1 | S | |||
| N3_TIPREAV | C | 15 | 0 | Tipo de Reav | @! | Vazio().OR.ExistCpo('SN0','10'+M->N3_TIPREAV) | SN010 | S | |||
| N3_BAIXA | C | 1 | 0 | Ocor Baixa | 9 | S | |||||
| N3_HISTOR | C | 40 | 0 | Historico | @! | S | |||||
| N3_TPSALDO | C | 1 | 0 | Tipo Saldo | @! | VldTpSald( M->N3_TPSALDO ) | R | #AdmCBGener(xFilial("SX5"),"SX5","SL","01") | AF012ATPSAL() | S | |
| N3_TPDEPR | C | 1 | 0 | Tipo deprec. | @! | Vazio() .Or. AF012AVTIP(M->N3_TPDEPR) | R | #AdmCBGener(xFilial("SN0"),"SN0","04","01") | S | ||
| N3_CCONTAB | C | 20 | 0 | Conta | @! | AF012ACTA() | CT1 | S | |||
| N3_CUSTBEM | C | 9 | 0 | C Custo Bem | @! | AF012ACC() | CTT | CtbMovSaldo("CTT") | S | ||
| N3_CDEPREC | C | 20 | 0 | Cta Desp Dep | @! | AF012ACTA() | CT1 | S | |||
| N3_CCUSTO | C | 9 | 0 | CC Despesa | @! | AF012ACC() .AND. (Vazio() .or. Ctb105CC()) .AND. AF012ACHCC(.F.) | CTT | CtbMovSaldo("CTT") | S | ||
| N3_CCDEPR | C | 20 | 0 | Cta Dep Acum | @! | AF012ACTA() | CT1 | S | |||
| N3_CDESP | C | 20 | 0 | Cta Cor Depr | @! | AF012ACTA() | CT1 | S | |||
| N3_CCORREC | C | 20 | 0 | Conta Correc | @! | AF012ACTA() | CT1 | S | |||
| N3_NLANCTO | C | 9 | 0 | Num. Lancto | @! | S | |||||
| N3_DLANCTO | D | 8 | 0 | Data Lancto | S | ||||||
| N3_DINDEPR | D | 8 | 0 | Dt In Deprec | !GetMv("MV_TIPDEPR")$"2|5" | S | |||||
| N3_FIMDEPR | D | 8 | 0 | Fim Deprec | S | ||||||
| N3_DEXAUST | D | 8 | 0 | Dt Exaustao | AF012AEXST() | S | |||||
| N3_VORIG1 | N | 16 | 2 | Val Orig M1 | @E 9,999,999,999,999.99 | AF012AVLR() | S | ||||
| N3_TXDEPR1 | N | 9 | 4 | Tx.An.Depr.1 | @E 9999.9999 | AF012ATAXA() | AF012ATXDP() | S | |||
| N3_VORIG2 | N | 16 | 4 | Val Orig M2 | @E 99,999,999,999.9999 | AF12VLRM() | S | ||||
| N3_TXDEPR2 | N | 9 | 4 | Tx.An.Depr.2 | @E 9999.9999 | AF012ATXDP() | S | ||||
| N3_VORIG3 | N | 16 | 4 | Val Orig M3 | @E 99,999,999,999.9999 | AF12VLRM() | S | ||||
| N3_TXDEPR3 | N | 9 | 4 | Tx.An.Depr.3 | @E 9999.9999 | AF012ATXDP() | S | ||||
| N3_VORIG4 | N | 16 | 4 | Val Orig M4 | @E 99,999,999,999.9999 | AF12VLRM() | S | ||||
| N3_TXDEPR4 | N | 9 | 4 | Tx.An.Depr.4 | @E 9999.9999 | AF012ATXDP() | S | ||||
| N3_VORIG5 | N | 16 | 4 | Val Orig M5 | @E 99,999,999,999.9999 | AF12VLRM() | S | ||||
| N3_TXDEPR5 | N | 9 | 4 | Tx.An.Depr.5 | @E 9999.9999 | AF012ATXDP() | S | ||||
| N3_VRCBAL1 | N | 16 | 2 | Corre Bal M1 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRDBAL1 | N | 16 | 2 | Depre Bal M1 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRCMES1 | N | 16 | 2 | Corre Mes M1 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRDMES1 | N | 16 | 2 | Depr Mes M1 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRCACM1 | N | 16 | 2 | Corr Acum M1 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRDACM1 | N | 16 | 2 | Depr.Acum M1 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRDBAL2 | N | 16 | 4 | Depr Bal M2 | @E 99,999,999,999.9999 | POSITIVO() | S | ||||
| N3_VRDMES2 | N | 16 | 4 | Depr Mes M2 | @E 99,999,999,999.9999 | S | |||||
| N3_VRCACM2 | N | 16 | 2 | Cor.Acm.M2 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRDACM2 | N | 16 | 4 | Depr Acum M2 | @E 99,999,999,999.9999 | S | |||||
| N3_VRDBAL3 | N | 16 | 4 | Depr.Bal M3 | @E 99,999,999,999.9999 | S | |||||
| N3_VRDMES3 | N | 16 | 4 | Depr Mes M3 | @E 99,999,999,999.9999 | S | |||||
| N3_VRCACM3 | N | 16 | 2 | Cor. Acm.M3 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRDACM3 | N | 16 | 4 | Depr Acum M3 | @E 99,999,999,999.9999 | S | |||||
| N3_VRDBAL4 | N | 16 | 4 | Depr.Bal M4 | @E 99,999,999,999.9999 | S | |||||
| N3_VRDMES4 | N | 16 | 4 | Depr Mes M4 | @E 99,999,999,999.9999 | S | |||||
| N3_VRCACM4 | N | 16 | 2 | Cor.Acm.M4 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRDACM4 | N | 16 | 4 | Depr Acum M4 | @E 99,999,999,999.9999 | S | |||||
| N3_VRDBAL5 | N | 16 | 4 | Depr.Bal M5 | @E 99,999,999,999.9999 | S | |||||
| N3_VRDMES5 | N | 16 | 4 | Depr Mes M5 | @E 99,999,999,999.9999 | S | |||||
| N3_VRCACM5 | N | 16 | 2 | Cor.Acm.M5 | @E 9,999,999,999,999.99 | POSITIVO() | S | ||||
| N3_VRDACM5 | N | 16 | 4 | Depr Acum M5 | @E 99,999,999,999.9999 | S | |||||
| N3_INDICE1 | N | 8 | 4 | Indice 1 | @E 999.9999 | S | |||||
| N3_INDICE2 | N | 8 | 4 | Indice 2 | @E 999.9999 | S | |||||
| N3_INDICE3 | N | 8 | 4 | Indice 3 | @E 999.9999 | S | |||||
| N3_INDICE4 | N | 8 | 4 | Indice 4 | @E 999.9999 | S | |||||
| N3_INDICE5 | N | 8 | 4 | Indice 5 | @E 999.9999 | S | |||||
| N3_AQUISIC | D | 8 | 0 | Dt.Aquis Ori | S | ||||||
| N3_DTBAIXA | D | 8 | 0 | Data Baixa | S | ||||||
| N3_VRCDM1 | N | 16 | 2 | Cor Dep Mes | @E 9,999,999,999,999.99 | S | |||||
| N3_VRCDB1 | N | 16 | 2 | Cor Dep Exer | @E 9,999,999,999,999.99 | S | |||||
| N3_VRCDA1 | N | 16 | 2 | Cor Dep Acum | @E 9,999,999,999,999.99 | S | |||||
| N3_VRCDA2 | N | 14 | 2 | C. Dep Ac M2 | @E 99,999,999,999.99 | S | |||||
| N3_VRCDA3 | N | 14 | 2 | C. Dep.Ac M3 | @E 99,999,999,999.99 | S | |||||
| N3_VRCDA4 | N | 14 | 2 | C Dep. Ac M4 | @E 99,999,999,999.99 | S | |||||
| N3_VRCDA5 | N | 14 | 2 | C Dep Ac M5 | @E 99,999,999,999.99 | S | |||||
| N3_PERDEPR | N | 4 | 0 | Per Deprec | @E 9999 | Positivo() .And. AF012AVlGr() | R | S | |||
| N3_CRIDEPR | C | 15 | 0 | Crit. Deprec | @! | ExistCpo('SN0','05'+M->N3_CRIDEPR).and. IiF(FindFunction('VldCriDepr'),VldCriDepr(),.T.) | SN005 | R | VldTipDepr("N3_CRIDEPR") | S | |
| N3_CALDEPR | C | 15 | 0 | Cal.Criterio | @! | ExistCpo('SN0','06'+M->N3_CALDEPR) .And. AF012VLAEC() | SN006 | R | VldTipDepr("N3_CRIDEPR","N3_CALDEPR") | S | |
| N3_VMXDEPR | N | 16 | 2 | Vl Max Depre | @E 9,999,999,999,999.99 | Positivo() .And. AF012AVlGr() .And. AF012VlMax() | R | A012VLZERO('N3_VMXDEPR') | S | ||
| N3_VLSALV1 | N | 16 | 2 | Vlr Salv | @E 9,999,999,999,999.99 | Positivo() .And. AF012AVlGr() | S | ||||
| N3_DEPREC | C | 40 | 0 | Depr.Variav. | @! | S | |||||
| N3_CALCDEP | C | 1 | 0 | Forma Calc. | @! | Pertence("01") | R | S | |||
| N3_PRODANO | N | 15 | 3 | Prod. Estim. | @E 99,999,999,999.999 | Positivo() .And. AF012AVlGr() | R | S | |||
| N3_PRODMES | N | 15 | 3 | Prod. period | @E 99,999,999,999.999 | Positivo() .And. AF012AVlGr() | R | S | |||
| N3_PRODACM | N | 16 | 3 | Prod. acum. | @E 999,999,999,999.999 | AF012VLAEC() | R | S | |||
| N3_OK | C | 2 | 0 | Flag Marca | S | ||||||
| N3_SEQ | C | 3 | 0 | Seq Aquisic | 999 | S | |||||
| N3_CCDESP | C | 9 | 0 | Cc Des Depr | @! | AF012ACC() | CTT | CtbMovSaldo("CTT") | S | ||
| N3_CCCDEP | C | 9 | 0 | Cc Depr Ac | @! | AF012ACC() | CTT | CtbMovSaldo("CTT") | S | ||
| N3_CCCDES | C | 9 | 0 | Cc Cor Dep | @! | AF012ACC() | CTT | CtbMovSaldo("CTT") | S | ||
| N3_CCCORR | C | 9 | 0 | Cc Correcao | @! | AF012ACC() | CTT | CtbMovSaldo("CTT") | S | ||
| N3_SUBCTA | C | 9 | 0 | Item Despesa | @! | AF012AITC() | CTD | CtbMovSaldo("CTD") | S | ||
| N3_SUBCCON | C | 9 | 0 | Item do Bem | @! | AF012AITC() | CTD | CtbMovSaldo("CTD") | S | ||
| N3_SUBCDEP | C | 9 | 0 | Item Ds.Dep. | @! | AF012AITC() | CTD | CtbMovSaldo("CTD") | S | ||
| N3_SUBCCDE | C | 9 | 0 | Item Dep.Ac. | @! | AF012AITC() | CTD | CtbMovSaldo("CTD") | S | ||
| N3_SUBCDES | C | 9 | 0 | Item C.Dep. | @! | AF012AITC() | CTD | CtbMovSaldo("CTD") | S | ||
| N3_SUBCCOR | C | 9 | 0 | Item Cor.Bem | @! | AF012AITC() | CTD | CtbMovSaldo("CTD") | S | ||
| N3_BXICMS | N | 16 | 2 | Valor do ICM | @E 9,999,999,999,999.99 | .F. | .F. | S | |||
| N3_SEQREAV | C | 2 | 0 | Seq Reaval. | 99 | S | |||||
| N3_AMPLIA1 | N | 16 | 2 | Vl Ampliac.1 | @E 9,999,999,999,999.99 | S | |||||
| N3_AMPLIA2 | N | 16 | 4 | Vl Ampliac.2 | @E 99,999,999,999.9999 | S | |||||
| N3_AMPLIA3 | N | 16 | 4 | Vl Ampliac.3 | @E 99,999,999,999.9999 | S | |||||
| N3_AMPLIA4 | N | 16 | 4 | Vl Ampliac.4 | @E 99,999,999,999.9999 | S | |||||
| N3_AMPLIA5 | N | 16 | 4 | Vl Ampliac.5 | @E 99,999,999,999.9999 | S | |||||
| N3_CODBAIX | C | 6 | 0 | Cd Bx Transf | @! | S | |||||
| N3_FILORIG | C | 2 | 0 | Filial Orig | S | ||||||
| N3_CLVL | C | 9 | 0 | ClVl Despesa | @! | AF012ACVL() | CTH | CtbInUse() | S | ||
| N3_CLVLCON | C | 9 | 0 | Cl Vlr Bem | @! | AF012ACVL() | CTH | CtbInUse() | S | ||
| N3_CLVLDEP | C | 9 | 0 | Clvl Des.Dep | @! | AF012ACVL() | CTH | CtbInUse() | S | ||
| N3_CLVLCDE | C | 9 | 0 | Clvl Dep.Acu | @! | AF012ACVL() | CTH | CtbInUse() | S | ||
| N3_CLVLDES | C | 9 | 0 | Clvl Cor.Dep | @! | AF012ACVL() | CTH | CtbInUse() | S | ||
| N3_CLVLCOR | C | 9 | 0 | Clvl Correc. | @! | AF012ACVL() | CTH | CtbInUse() | S | ||
| N3_IDBAIXA | C | 1 | 0 | Ident Baixa | 9 | =Item sem baixa;1=Normal;2=Adiantamento;3=Aquisicao Transferencia | S | ||||
| N3_LOCAL | C | 6 | 0 | Endereco | S | ||||||
| N3_NOVO | C | 1 | 0 | Reg Novo? | S | ||||||
| N3_QUANTD | N | 11 | 3 | Qtde. Orig. | @E 9,999,999.999 | S | |||||
| N3_PERCBAI | N | 12 | 7 | Perc Baixado | @E 9,999.9999999 | S | |||||
| N3_NODIA | C | 10 | 0 | Seq. DIario | @! | R | S | ||||
| N3_DIACTB | C | 2 | 0 | Cod. Diario | @! | VldCodSeq() | CVL | CtbWDia() | S | ||
| N3_DTACELE | D | 8 | 0 | Dt. Aceler. | S | ||||||
| N3_VLACEL1 | N | 16 | 2 | Vl Dep acel. | @E 9,999,999,999,999.99 | S | |||||
| N3_VLACEL2 | N | 16 | 4 | Dp. Acel. M2 | @E 99,999,999,999.9999 | S | |||||
| N3_VLACEL3 | N | 16 | 4 | Dep. Acel M3 | @E 99,999,999,999.9999 | S | |||||
| N3_VLACEL4 | N | 16 | 4 | Dep. Acel M4 | @E 99,999,999,999.9999 | S | |||||
| N3_VLACEL5 | N | 16 | 4 | Dep. Acel M5 | @E 99,999,999,999.9999 | S | |||||
| N3_RATEIO | C | 1 | 0 | Rateio | @! | R | 1=Sim;2=Nao | S | |||
| N3_CODRAT | C | 12 | 0 | Cod. Rateio | @! | R | S | ||||
| N3_PERCDEP | N | 6 | 2 | Perc Deprec | @E 999.99 | Positivo() .and. (M->N3_PERCDEP <= 100) | R | AllTrim(FWFldGet("N3_TIPO")) $ AtfXTpBem(1) | S | ||
| N3_CODPOOL | C | 15 | 0 | Cod. do Pool | @! | Vazio() .Or. ExistCpo('SN0','15'+M->N3_CODPOOL) | R | Iif(SuperGetMv("MV_ATFDPSI",.F.,.F.),.F.,.T.) | S | ||
| N3_VLIMPER | N | 16 | 2 | Val Lim Per | @E 9,999,999,999,999.99 | Positivo() | R | SuperGetMv("MV_ATFLIPE",,.F.) | S | ||
| N3_CODIND | C | 2 | 0 | Ind.calculo | @! | ( Vazio() .Or. ExistCPO("FNI") ) | FNI | R | AF12Tpdepr() | S | |
| N3_ATFCPR | C | 1 | 0 | Atf.Custo/Pr | @! | Pertence(' |1|2') | R | 1=Sim;2=Nao | If(FindFunction("AFXAtCsPrv"),AFXAtCsPrv(),.F.) | S | |
| N3_DESCEST | M | 80 | 0 | Desc.Estend. | V | S | |||||
| N3_ATVORIG | C | 15 | 0 | Ativo Origem | @! | R | S | ||||
| N3_INTP | C | 1 | 0 | Int. PIMS | @! | Pertence('12') | R | 1=Sim;2=Nao | AllTrim(FWFldGet("N3_TIPO")) $ AtfXTpBem(1) | S | |