| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SNG | Grupos de Bens | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| NG_FILIAL | C | 2 | 0 | Filial | S | ||||||
| NG_GRUPO | C | 4 | 0 | Grupo | ExistChav("SNG") .And. FreeForUse("SNG",M->NG_GRUPO) | S | |||||
| NG_DESCRIC | C | 80 | 0 | Descricao | @! | S | |||||
| NG_TXDEPR1 | N | 8 | 4 | Tx.An.Depr.1 | @E 999.9999 | Positivo() .and. IiF(FindFunction("AFA271TX"),AFA271TX("FNG_TXDEP1"),.T.) | EMPTY(M->NG_TAXAPAD).or.IsInCallStack("RUNTRIGGER") | S | |||
| NG_TXDEPR2 | N | 8 | 4 | Tx.An.Depr.2 | @E 999.9999 | Positivo() .and. IiF(FindFunction("AFA271TX"),AFA271TX("FNG_TXDEP2"),.T.) | EMPTY(M->NG_TAXAPAD).or.IsInCallStack("RUNTRIGGER") | S | |||
| NG_TXDEPR3 | N | 8 | 4 | Tx.An.Depr.3 | @E 999.9999 | Positivo() .and. IiF(FindFunction("AFA271TX"),AFA271TX("FNG_TXDEP3"),.T.) | EMPTY(M->NG_TAXAPAD).or.IsInCallStack("RUNTRIGGER") | S | |||
| NG_TXDEPR4 | N | 8 | 4 | Tx.An.Depr.4 | @E 999.9999 | Positivo() .and. IiF(FindFunction("AFA271TX"),AFA271TX("FNG_TXDEP4"),.T.) | EMPTY(M->NG_TAXAPAD).or.IsInCallStack("RUNTRIGGER") | S | |||
| NG_TXDEPR5 | N | 8 | 4 | Tx.An.Depr.5 | @E 999.9999 | Positivo() .and. IiF(FindFunction("AFA271TX"),AFA271TX("FNG_TXDEP5"),.T.) | EMPTY(M->NG_TAXAPAD).or.IsInCallStack("RUNTRIGGER") | S | |||
| NG_CCUSTO | C | 9 | 0 | Cc Despesa | @! | Vazio() .or. Ctb105CC() | CTT | CtbMovSaldo("CTT") | S | ||
| NG_SUBCTA | C | 9 | 0 | Item Despesa | @! | (Vazio() .Or. Ctb105Item()) | CTD | CtbMovSaldo("CTD") | S | ||
| NG_CLVL | C | 9 | 0 | ClVl Despesa | @! | (Vazio() .Or. Ctb105ClVl()) | CTH | CtbInUse() | S | ||
| NG_DTBLOQ | D | 8 | 0 | Data bloquei | S | ||||||
| NG_CCONTAB | C | 20 | 0 | Conta | @! | Vazio() .Or. Ctb105Cta() | CT1 | S | |||
| NG_CDEPREC | C | 20 | 0 | Cta Desp Dep | @! | Vazio() .Or. Ctb105Cta() | CT1 | S | |||
| NG_CCDEPR | C | 20 | 0 | Cta Dep Acum | @! | Vazio() .Or. Ctb105Cta() | CT1 | S | |||
| NG_CDESP | C | 20 | 0 | Cta Cor Depr | @! | Vazio() .Or. Ctb105Cta() | CT1 | S | |||
| NG_CCORREC | C | 20 | 0 | Conta Correc | @! | Vazio() .Or. Ctb105Cta() | CT1 | S | |||
| NG_CUSTBEM | C | 9 | 0 | C Custo Bem | @! | Vazio() .or. Ctb105CC() | CTT | CtbMovSaldo("CTT") | S | ||
| NG_CCDESP | C | 9 | 0 | Cc Desp. Dep | @! | (Vazio() .Or. Ctb105Cc()) | CTT | CtbMovSaldo("CTT") | S | ||
| NG_CCCDEP | C | 9 | 0 | CC Depr Acum | @! | vazio() .or. (CTB105CC()) | CTT | S | |||
| NG_CCCDES | C | 9 | 0 | Cc Cor. Dep. | @! | (Vazio() .Or. Ctb105Cc()) | CTT | CtbMovSaldo("CTT") | S | ||
| NG_CCCORR | C | 9 | 0 | Cc Correcao | @! | (Vazio() .Or. Ctb105Cc()) | CTT | CtbMovSaldo("CTT") | S | ||
| NG_SUBCCON | C | 9 | 0 | Item do Bem | @! | (Vazio() .Or. Ctb105Item()) | CTD | CtbMovSaldo("CTD") | S | ||
| NG_SUBCDEP | C | 9 | 0 | Item Ds.Dep. | @! | (Vazio() .Or. Ctb105Item()) | CTD | CtbMovSaldo("CTD") | S | ||
| NG_SUBCCDE | C | 9 | 0 | Item Dep.Ac. | @! | (Vazio() .Or. Ctb105Item()) | CTD | CtbMovSaldo("CTD") | S | ||
| NG_SUBCDES | C | 9 | 0 | Item Cor.Dep | @! | (Vazio() .Or. Ctb105Item()) | CTD | CtbMovSaldo("CTD") | S | ||
| NG_SUBCCOR | C | 9 | 0 | Item Correc. | @! | (Vazio() .Or. Ctb105Item()) | CTD | CtbMovSaldo("CTD") | S | ||
| NG_CLVLCON | C | 9 | 0 | Cl Vlr Bem | @! | (Vazio() .Or. Ctb105ClVl()) | CTH | CtbInUse() | S | ||
| NG_CLVLDEP | C | 9 | 0 | Clvl Ds.Dep. | @! | (Vazio() .Or. Ctb105ClVl()) | CTH | CtbInUse() | S | ||
| NG_CLVLCDE | C | 9 | 0 | Clvl Dep.Ac. | @! | (Vazio() .Or. Ctb105ClVl()) | CTH | CtbInUse() | S | ||
| NG_CLVLDES | C | 9 | 0 | Clvl Cor.Dep | @! | (Vazio() .Or. Ctb105ClVl()) | CTH | CtbInUse() | S | ||
| NG_CLVLCOR | C | 9 | 0 | ClVl Correc. | @! | (Vazio() .Or. Ctb105ClVl()) | CTH | CtbInUse() | S | ||
| NG_TAXAPAD | C | 6 | 0 | Cod.Tx.Pad. | @! | Vazio() .Or. ExistCpo('SNH',M->NG_TAXAPAD) | SNH | S | |||
| NG_DETPATR | C | 2 | 0 | Identif.Bem | @! | Vazio().OR.ExistCpo('SN0','11'+M->NG_DETPATR) | SN011 | R | S | ||
| NG_UTIPATR | C | 2 | 0 | Utiliz.Bem | @! | Vazio().OR.ExistCpo('SN0','12'+M->NG_UTIPATR) | SN012 | R | S | ||
| NG_TPSALDO | C | 1 | 0 | Tipo Saldo | @9 | Iif(FindFunction("VldTpSald"),VldTpSald(M->NG_TPSALDO),.T.) .and. IiF(FindFunction("AFA271TX"),AFA271TX("FNG_TPSALD"),.T.) | R | #AdmCBGener(xFilial("SX5"),"SX5","SL","01") | S | ||
| NG_TPDEPR | C | 1 | 0 | Tipo Deprec | @! | IiF(FindFunction('AFA271TX'),AFA271TX('FNG_TPDEPR'),.T.) | R | #AdmCBGener(xFilial("SN0"),"SN0","04","01") | S | ||
| NG_CRIDEPR | C | 15 | 0 | Crit. Deprec | @! | ExistCpo('SN0','05'+M->NG_CRIDEPR) .and. IiF(FindFunction('AFA271TX'),AFA271TX('FNG_CRIDEP'),.T.) | SN005 | R | VldTipDepr("NG_CRIDEPR") | S | |
| NG_CALDEPR | C | 15 | 0 | Cal.Criterio | @! | ExistCpo('SN0','06'+M->NG_CALDEPR).and. IiF(FindFunction('AFA271TX'),AFA271TX('FNG_CALDEP'),.T.) | SN006 | R | VldTipDepr("NG_CRIDEPR","NG_CALDEPR") | S | |
| NG_VMXDEPR | N | 16 | 2 | Vl Max Depr | @E 9,999,999,999,999.99 | R | S | ||||
| NG_ORIGCRD | C | 1 | 0 | Orig. Cred. | @! | Pertence(' 01') | R | 0=Aq.Mercado Interno; 1=Aq.Mercado externo | S | ||
| NG_CSTPIS | C | 2 | 0 | Sit.Trib.PIS | @! | Vazio() .OR. ExistCpo('SX5', 'SX' + M->NG_CSTPIS) | SX | R | S | ||
| NG_ALIQPIS | N | 5 | 2 | Aliq. PIS | @E 99.99 | Positivo() | R | S | |||
| NG_CSTCOFI | C | 2 | 0 | Sit.Trib.Cof | @! | Vazio() .OR. ExistCpo('SX5', 'SX' + M->NG_CSTCOFI) | SX | R | S | ||
| NG_ALIQCOF | N | 5 | 2 | Aliq. Cofins | @E 99.99 | Positivo() | R | S | |||
| NG_CODBCC | C | 2 | 0 | Cod.BC Cred. | @! | Vazio() .OR. ExistCpo('SX5', 'MZ' + M->NG_CODBCC) | MZ | R | S | ||
| NG_INDPRO | C | 1 | 0 | Tp. processo | @! | Pertence(" 01239") | R | 0=Sefaz; 1=Justica Federal; 2=Justica Estadual; 3=Secex/SRF; 9=Outros | S | ||
| NG_CBCPIS | C | 1 | 0 | Base PIS/COF | @! | R | 1=Normal; 2=Cadastro do Bem | S | |||