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