| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SNM | Documentos de movimentacoes | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| NM_FILIAL | C | 2 | 0 | Filial | S | ||||||
| NM_CODIGO | C | 6 | 0 | Cod. Solic. | @! | ExistChav( "SNM" ) | INCLUI | S | |||
| NM_DATSOL | D | 8 | 0 | Data Solic. | S | ||||||
| NM_HORSOL | C | 4 | 0 | Hora Solic. | @R 99:99 | S | |||||
| NM_CBASE | C | 10 | 0 | Cod. do Bem | @! | ExistCpo( "SN1", M->NM_CBASE,,,, !Empty( M->NM_ITEM ) ) | SN1 | S | |||
| NM_ITEM | C | 4 | 0 | Codigo Item | @! | ExistCpo( "SN1", M->NM_CBASE + M->NM_ITEM ) | S | ||||
| NM_TIPO | C | 2 | 0 | Tipo Ativo | @9 | ExistCpo("SN3", M->NM_CBASE + M->NM_ITEM + M->NM_TIPO) .And. ExistChav("SNM", M->NM_CBASE + M->NM_ITEM + M->NM_TIPO + "1", 2) | S | ||||
| NM_DESCBEM | C | 40 | 0 | Descr. Bem | @! | V | S | ||||
| NM_CDHSOL | C | 6 | 0 | Cd. Hist Sol | @! | S | |||||
| NM_HISTSOL | M | 80 | 0 | Hist. Solic. | @! | V | S | ||||
| NM_CDHREJ | C | 6 | 0 | Cd. Hist Rej | @! | S | |||||
| NM_HISTREJ | M | 80 | 0 | Hist. Rejeic | @! | V | S | ||||
| NM_SITSOL | C | 1 | 0 | Situacao | 1=Pendente;2=Aprovada;3=Rejeitada | S | |||||
| NM_USRSOL | C | 6 | 0 | Solicitante | S | ||||||
| NM_NMUSSOL | C | 30 | 0 | Nome solic. | V | S | |||||
| NM_USRAPV | C | 6 | 0 | Apr/Rej. Por | S | ||||||
| NM_NMUSAPV | C | 30 | 0 | Nome aprov. | V | S | |||||
| NM_TIPOSOL | C | 1 | 0 | Tipo | 1=Baixa;2=Transferencia | S | |||||
| NM_DTAPVRE | D | 8 | 0 | Dt. Apv/Rej. | S | ||||||
| NM_HRAPVRE | C | 4 | 0 | Hr. Apv/Rej. | @R 99:99 | S | |||||
| NM_DTBAIXA | D | 8 | 0 | Dt. Baixa | AF030DtBx( dBaixa030 ) | S | |||||
| NM_FILDEST | C | 2 | 0 | Filial Dest. | ExistCpo( "SM0", cEmpAnt + M->NM_FILDEST ) | SM0_01 | S | ||||
| NM_GRUPO | C | 4 | 0 | Grupo | Vazio() .Or. ExistCpo( "SNG", M->NM_GRUPO ) | SNG | S | ||||
| NM_MOTBX | C | 2 | 0 | Mot. Baixa | ExistCpo( "SX5", "16" + M->NM_MOTBX ) | 16 | NM_TIPOSOL == "1" | S | |||
| NM_QTDBX | N | 11 | 3 | Qtd. Baixada | @E 9,999,999.999 | AF030Quant( M->NM_QTDBX, @M->NM_PERCBX, SN->N1_QUANTD ) | NM_TIPOSOL == "1" | S | |||
| NM_PERCBX | N | 12 | 8 | Perc Baixado | @E 999.99999999 | AF030Perc( M->NM_PERCBX, @M->NM_QTDBX, SN1->N1_QUANTD ) | S | ||||
| NM_VLRBAIX | N | 16 | 2 | Vlr. Baixa | @E 9,999,999,999,999.99 | Positivo() .And. AF030Valor( M->NM_VLRBAIX, 1, M->N1_QUANTD, M->NM_QTDBX ) | NM_TIPOSOL == "1" | S | |||
| NM_VLVENDA | N | 16 | 2 | Vlr. Venda | @E 9,999,999,999,999.99 | Positivo() .And. NM_VLVENDA > 0 | NM_TIPOSOL == "1" | S | |||
| NM_CCUSTO | C | 9 | 0 | CC Despesa | @! | Vazio() .Or. CTB105CC() | CTT | NM_TIPOSOL == "2" .And. CTBMovSaldo( "CTT" ) | S | ||
| NM_LOCAL | C | 6 | 0 | Local do bem | @! | ExistCpo( "SNL", M->NM_LOCAL ) | SNL | NM_TIPOSOL == "2" | S | ||
| NM_CCONTAB | C | 20 | 0 | Conta | @! | Vazio() .Or. CTB105Cta() | CT1 | NM_TIPOSOL == "2" | S | ||
| NM_CCORREC | C | 20 | 0 | Conta Correc | @! | Vazio() .Or. CTB105Cta() | CT1 | NM_TIPOSOL == "2" | S | ||
| NM_CDEPREC | C | 20 | 0 | Cta Desp Dep | @! | Vazio() .Or. CTB105Cta() | CT1 | NM_TIPOSOL == "2" | S | ||
| NM_CDDEPR | C | 20 | 0 | Cta Dep Acum | @! | Vazio() .Or. CTB105Cta() | CT1 | NM_TIPOSOL == "2" | S | ||
| NM_CDESP | C | 20 | 0 | Cta Cor Depr | @! | Vazio() .Or. CTB105Cta() | CT1 | NM_TIPOSOL == "2" | S | ||
| NM_CUSTBEM | C | 9 | 0 | CC do Bem | @! | Vazio() .Or. CTB105Cc() | CTT | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTT" ) | S | ||
| NM_CCCORR | C | 9 | 0 | CC correcao | @! | Vazio() .Or. CTB105Cc() | CTT | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTT" ) | S | ||
| NM_CCDESP | C | 9 | 0 | CC Desp Depr | @! | Vazio() .Or. CTB105Cc() | CTT | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTT" ) | S | ||
| NM_CCCDEP | C | 9 | 0 | CC Depr Acum | @! | Vazio() .Or. CTB105Cc() | CTT | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTT" ) | S | ||
| NM_CCCDES | C | 9 | 0 | CC Corr Depr | @! | Vazio() .Or. CTB105Cc() | CTT | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTT" ) | S | ||
| NM_ITBEM | C | 9 | 0 | Item do bem | @! | Vazio() .Or. CTB105Item() | CTD | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTD" ) | S | ||
| NM_ITCORR | C | 9 | 0 | Item correc. | @! | Vazio() .Or. CTB105Item() | CTD | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTD" ) | S | ||
| NM_ITDESP | C | 9 | 0 | It Desp Depr | @! | Vazio() .Or. CTB105Item() | CTD | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTD" ) | S | ||
| NM_ITCDEP | C | 9 | 0 | It Depr Acum | @! | Vazio() .Or. CTB105Item() | CTD | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTD" ) | S | ||
| NM_ITCDES | C | 9 | 0 | It Corr Depr | @! | Vazio() .Or. CTB105Item() | CTD | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTD" ) | S | ||
| NM_CLVLBEM | C | 9 | 0 | Cl. Vlr. Bem | @! | Vazio() .Or. CTB105ClVl() | CTH | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTH" ) | S | ||
| NM_CLVLCOR | C | 9 | 0 | Cl Vlr Corr. | @! | Vazio() .Or. CTB105ClVl() | CTH | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTH" ) | S | ||
| NM_CLVLDEP | C | 9 | 0 | ClVl Des Dep | @! | Vazio() .Or. CTB105ClVl() | CTH | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTH" ) | S | ||
| NM_CLVLCDE | C | 9 | 0 | ClVl Dep Acu | @! | Vazio() .Or. CTB105ClVl() | CTH | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTH" ) | S | ||
| NM_CLVLDES | C | 9 | 0 | ClVl Cor Dep | @! | Vazio() .Or. CTB105ClVl() | CTH | NM_TIPOSOL == "2" .And. CtbMovSaldo( "CTH" ) | S | ||
| NM_GERANF | C | 1 | 0 | Gera NFS | Pertence( "12" ) | 1=Sim;2=Nao | S | ||||
| NM_NOTA | C | 9 | 0 | Num. NF | @! | ExistCpo( "SF2", M->NM_NOTA ) | SF2 | NM_GERANF == "1" | S | ||
| NM_SERIE | C | 3 | 0 | Serie | !!! | ExistCpo( "SF2", M->NM_NOTA + M->NM_SERIE ) | NM_GERANF == "1" | S | |||
| NM_TESNFS | C | 3 | 0 | TES Saida | ExistCpo( "SF4", M->NMTESNFS ) | SF4 | NM_GERANF == "1" | S | |||
| NM_CLASNFE | C | 1 | 0 | Tip Clas NFE | Pertence( "12" ) | 1=A Classificar;2=Classificada | NM_GERANF == "1" | S | |||
| NM_TESNFE | C | 3 | 0 | TES Entrada | ExistCpo( "SF4", M->NM_TESNFE ) | SF4 | NM_GERANF == "1" .And. NM_TIPOSOL == "2" | S | |||
| NM_CONDPG | C | 3 | 0 | Cond. Pgto. | ExistCpo( "SE4", M->NM_CONDPG ) | SE4 | NM_GERANF == "1" .And. NM_TIPOSOL == "1" | S | |||
| NM_CLIENTE | C | 6 | 0 | Cliente | @! | ExistCpo( "SA1", M->NM_CLIENTE,,,,.F. ) | SA1 | NM_GERANF == "1" .And. NM_TIPOSOL == "1" | S | ||
| NM_LOJA | C | 2 | 0 | Loja | @! | ExistCpo( "SA1", M->NM_CLIENTE + M->NM_LOJA ) | NM_GERANF == "1" .And. NM_TIPOSOL == "1" | S | |||
| NM_WFID | C | 100 | 0 | Workflow ID | @! | R | S | ||||
| NM_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||
| NM_ARMAZEM | C | 2 | 0 | Armazem | @! | EXITCPO("NNR") | R | S | |||