Tabela | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
CLR | Movimentacoes Cat83 | ||||||||||
Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
CLR_FILIAL | C | 2 | 0 | Filial | R | S | |||||
CLR_PERIOD | D | 8 | 0 | Periodo | R | S | |||||
CLR_PROD | C | 15 | 0 | Cod. Produto | @! | existcpo('SB1') | SB1 | R | S | ||
CLR_PRDMOV | C | 15 | 0 | Prod. Mov. | @! | existcpo('SB1') | SB1 | S | |||
CLR_FICHA | C | 2 | 0 | Ficha | @! | R | S | ||||
CLR_IDNF | C | 6 | 0 | Id NF | S | ||||||
CLR_PART | C | 14 | 0 | Cod Part. | R | S | |||||
CLR_CODREM | C | 14 | 0 | Id Remetente | @! | R | S | ||||
CLR_CODDST | C | 14 | 0 | Id Dest | @! | R | S | ||||
CLR_IDDET | C | 6 | 0 | Id Detal. | @! | R | S | ||||
CLR_NRLAN | N | 9 | 0 | Num. Lancto. | @E 999,999,999 | R | S | ||||
CLR_NRORD | N | 9 | 0 | Num. Ordem | @E 999,999,999 | R | S | ||||
CLR_HIST | C | 50 | 0 | Historico | @! | R | S | ||||
CLR_FILMOV | C | 2 | 0 | Filial Orig. | R | S | |||||
CLR_ARMAZ | C | 2 | 0 | Armazem | @! | NNR | R | S | |||
CLR_NUMSEQ | C | 6 | 0 | Sequencial | @! | R | S | ||||
CLR_UFINI | C | 2 | 0 | UF Origem | @! | 12 | R | S | |||
CLR_UFDST | C | 2 | 0 | UF Destino | @! | 12 | R | S | |||
CLR_TPRD | C | 3 | 0 | Tp. Requis. | @! | SF5 | R | S | |||
CLR_NRDI | C | 12 | 0 | Numero da DI | @! | R | S | ||||
CLR_CODLAN | C | 6 | 0 | Cod. Lanc. | @! | Vazio() .Or. ExistCpo('CDZ') | CDZ | R | S | ||
CLR_TABMOV | C | 3 | 0 | Tab. Origem | @! | R | S | ||||
CLR_CODORI | C | 2 | 0 | Cod. Origem | @! | R | S | ||||
CLR_UNID | C | 2 | 0 | Unidade | @! | R | S | ||||
CLR_ENQLEG | C | 4 | 0 | Enq. Legal | @! | R | S | ||||
CLR_DESPAC | C | 12 | 0 | Nro. Desp. | @! | R | S | ||||
CLR_COMOPE | C | 1 | 0 | Comp. Oper. | @! | R | 1=Sim;2=Nao | S | |||
CLR_VEICUL | C | 15 | 0 | Cod. Veic | @! | R | S | ||||
CLR_KM | N | 14 | 2 | KM Perc. | @E 99,999,999,999.99 | R | S | ||||
CLR_INDRAT | N | 16 | 6 | Indice Rat | @E 999,999,999.999999 | R | S | ||||
CLR_FOCORR | C | 2 | 0 | Ficha Perda | @! | R | S | ||||
CLR_TPDOC | C | 3 | 0 | Tp Documento | @! | R | S | ||||
CLR_TPMOV | C | 1 | 0 | Mov.entre Fi | @! | R | S=Saida;E=Entrada;F=Dev.Compra;G=Dev.Venda;D=Estorno(Ent);H=Estorno(Sai);I=Dev.Prod(Ent);J=Dev.Prod(Sai);Z=Dev.Venda F. | S | |||
CLR_IDCAB | C | 6 | 0 | Id Cabec | R | S | |||||
CLR_ICMS | N | 14 | 6 | Vl. ICMS | @E 9,999,999.999999 | R | S | ||||
CLR_CUSTO | N | 14 | 6 | Vl. CUSTO | @E 9,999,999.999999 | R | S | ||||
CLR_UICMS | N | 14 | 6 | Unit ICMS | @E 9,999,999.999999 | R | S | ||||
CLR_UCUSTO | N | 14 | 6 | Unit CUSTO | @E 9,999,999.999999 | R | S | ||||
CLR_IPI | N | 14 | 6 | Valor IPI | @E 9,999,999.999999 | R | S | ||||
CLR_OUTROS | N | 14 | 6 | Vl Outros | @E 9,999,999.999999 | R | S | ||||
CLR_QTDE | N | 14 | 6 | Quantidade | @E 9,999,999.999999 | R | S | ||||
CLR_QTDECP | N | 14 | 6 | Coo Prod. | @E 9,999,999.999999 | R | S | ||||
CLR_PERCCJ | N | 14 | 6 | Perc. Custo | @E 9,999,999.999999 | R | S | ||||
CLR_SAIDA | N | 14 | 6 | Vl. Saida | @E 9,999,999.999999 | R | S | ||||
CLR_VCROUT | N | 14 | 6 | Cred.Out. | @E 9,999,999.999999 | R | S | ||||
CLR_VCRDSP | N | 14 | 6 | Cred Desp | @E 9,999,999.999999 | R | S | ||||
CLR_VCRCOM | N | 14 | 6 | Cred Comun | @E 9,999,999.999999 | R | S | ||||
CLR_ICMCMP | N | 14 | 6 | ICMS Comp | @E 9,999,999.999999 | R | S | ||||
CLR_ICMSDE | N | 14 | 6 | ICMS Devido | @E 9,999,999.999999 | R | S | ||||
CLR_VPRENG | N | 14 | 6 | Tot Oper NG | @E 9,999,999.999999 | R | S | ||||
CLR_ICMDEB | N | 14 | 6 | ICMS Debit | @E 9,999,999.999999 | R | S | ||||
CLR_VPREGE | N | 14 | 6 | Tot Oper | @E 9,999,999.999999 | R | S | ||||
CLR_ICMST | N | 14 | 6 | ICMS Subst | @E 9,999,999.999999 | R | S | ||||
CLR_VCROUP | N | 14 | 6 | Cred.Out Prp | @E 9,999,999.999999 | R | S | ||||
CLR_CROUST | N | 14 | 6 | Cred.Out ST | @E 9,999,999.999999 | R | S | ||||
CLR_VALBC | N | 14 | 6 | Base Calc. | @E 9,999,999.999999 | R | S | ||||
CLR_PCROUT | N | 5 | 2 | Perc. Out. | @E 99.99 | R | S | ||||
CLR_TOTICM | N | 14 | 6 | Tot. ICMS | @E 9,999,999.999999 | R | S | ||||
CLR_CREDAC | N | 14 | 6 | Cred. Acum. | @E 9,999,999.999999 | R | S | ||||
CLR_ALIQ | N | 5 | 2 | Aliquota | @E 99.99 | R | S | ||||
CLR_PERRAT | N | 6 | 2 | Perc. Rat. | @E 999.99 | R | S | ||||
CLR_ORIDES | C | 1 | 0 | Orig./Dest. | R | O=Origem;D=Destino | S | ||||
CLR_EXPIND | C | 3 | 0 | Exp.Indireta | @! | R | S |