| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| NJM | Dados Fiscais do Romaneio | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| NJM_FILIAL | C | 2 | 0 | Filial | S | ||||||
| NJM_CODROM | C | 10 | 0 | Cod.Romaneio | @! | R | S | ||||
| NJM_ITEROM | C | 2 | 0 | Item Rom. | @! | R | S | ||||
| NJM_CODENT | C | 6 | 0 | Cod.Entidade | @! | NJ0 | S | ||||
| NJM_LOJENT | C | 2 | 0 | Loj.Entidade | @! | ExistCpo('NJ0',FwFldGet('NJM_CODENT')+FwFldGet('NJM_LOJENT')) | S | ||||
| NJM_NOMENT | C | 40 | 0 | Nom.Entidade | @! | V | S | ||||
| NJM_NLJENT | C | 20 | 0 | Nom.Loj.Ent. | @! | V | S | ||||
| NJM_CODSAF | C | 15 | 0 | Cod. Safra | @! | ExistCpo('NJU', M->NJM_CODSAF).And.OGA250ACTR() | NJU | S | |||
| NJM_TALHAO | C | 16 | 0 | Talhao | @! | S | |||||
| NJM_CODPRO | C | 15 | 0 | Cod. Produto | @! | Vazio().Or.ExistCpo('SB1', M->NJM_CODPRO) | SB1 | S | |||
| NJM_DESPRO | C | 30 | 0 | Des. Produto | @! | V | S | ||||
| NJM_UM1PRO | C | 2 | 0 | Unid.Med. | @! | Vazio().Or.ExistCpo('SAH') | SAH | R | S | ||
| NJM_LOCAL | C | 2 | 0 | Local | @! | Vazio().Or.ExistCpo('NNR', M->NJM_LOCAL) | NNR | S | |||
| NJM_CODCTR | C | 6 | 0 | Contrato | @! | OGA330VLD(FwFldGet('NJM_CODCTR'),FwFldGet('NJJ_TIPO')).And.OGA250VCTR() | NJRNJJ | S | |||
| NJM_DESCTR | C | 40 | 0 | Desc.Contr. | @! | V | S | ||||
| NJM_OPEFIS | C | 3 | 0 | Oper.Fis. | Vazio().Or.ExistCpo('SX5','DJ'+M->NJM_OPEFIS) | DJ | S | ||||
| NJM_TES | C | 3 | 0 | TES | @! | Vazio().Or.ExistCpo('SF4') | SF4 | S | |||
| NJM_PERDIV | N | 9 | 5 | Perc.Div. | @E 999.99999 | Positivo() .And. FwFldGet('NJM_PERDIV') <= 100 | S | ||||
| NJM_QTDFCO | N | 12 | 2 | Qtd. Fisica | @E 999,999,999.99 | S | |||||
| NJM_LOTCTL | C | 10 | 0 | Lote | R | S | |||||
| NJM_TPFORM | C | 1 | 0 | Form.Prop. | @! | Pertence('12') | 1=SIM;2=NAO | S | |||
| NJM_DOCSER | C | 3 | 0 | Serie NF | @! | FwFldGet('NJM_TPFORM')='2'.Or.FwFldGet('NJJ_TIPENT')='2' | S | ||||
| NJM_DOCNUM | C | 9 | 0 | Numero NF | @! | FwFldGet('NJM_TPFORM')='2'.Or.FwFldGet('NJJ_TIPENT')='2' | S | ||||
| NJM_DOCITE | C | 2 | 0 | Item DocFis | S | ||||||
| NJM_DOCEMI | D | 8 | 0 | Emissao NF | FwFldGet('NJM_TPFORM')='2'.Or.FwFldGet('NJJ_TIPENT')='2' | S | |||||
| NJM_DOCESP | C | 5 | 0 | Especie NF | @! | Vazio().Or.ExistCpo('SX5','42'+FwFldGet('NJM_DOCESP')) | 42 | FwFldGet('NJM_TPFORM')='2'.Or.FwFldGet('NJJ_TIPENT')='2' | S | ||
| NJM_CHVNFE | C | 44 | 0 | Chave NFe | @! | FwFldGet('NJM_DOCESP')='SPED' | S | ||||
| NJM_MSGNFS | C | 60 | 0 | Mens.p/ Nota | @! | S | |||||
| NJM_QTDFIS | N | 12 | 2 | Qtd. Fiscal | @E 999,999,999.99 | FwFldGet('NJM_TPFORM')='2'.Or.FwFldGet('NJJ_TIPENT')='2' | S | ||||
| NJM_VLRUNI | N | 14 | 2 | Vlr. Unit. | @E 99,999,999,999.99 | FwFldGet('NJM_TPFORM')='2'.Or.FwFldGet('NJJ_TIPENT')='2' | S | ||||
| NJM_VLRTOT | N | 14 | 2 | Valor Total | @E 99,999,999,999.99 | FwFldGet('NJM_TPFORM')='2'.Or.FwFldGet('NJJ_TIPENT')='2' | S | ||||
| NJM_FRETE | N | 14 | 2 | Valor Frete | @E 99,999,999,999.99 | S | |||||
| NJM_SEGURO | N | 14 | 2 | Valor Seguro | @E 99,999,999,999.99 | S | |||||
| NJM_DESPES | N | 14 | 2 | Valor Despes | @E 99,999,999,999.99 | S | |||||
| NJM_NFPSER | C | 3 | 0 | Ser. NFP | @! | S | |||||
| NJM_NFPNUM | C | 9 | 0 | Num. NFP | @! | S | |||||
| NJM_TIPO | C | 1 | 0 | Tipo | ExistCpo('SX5','K5'+M->NJM_TIPO) | S | |||||
| NJM_TRANS | C | 1 | 0 | Transacao | Pertence('12') | 1=Entrega;2=Devolucao | S | ||||
| NJM_TIPMOV | C | 1 | 0 | TIP MOV | Pertence('12') | R | 1=Fisica;2=Financeira | S | |||
| NJM_CONDPG | C | 3 | 0 | Cond. Pg. | @! | ExistCpo('SE4') | SE4 | S | |||
| NJM_PEDIDO | C | 6 | 0 | Pedido | @! | R | S | ||||
| NJM_STAFIS | C | 1 | 0 | Sts. Fiscal | Pertence('123') | R | 1=Sem Fiscal;2=Com Fiscal;3=Gerencial | S | |||
| NJM_DTRANS | D | 8 | 0 | Data Transac | S | ||||||
| NJM_ITVDAP | C | 1 | 0 | Incent.DAP? | @! | Pertence('12') | 1=Sim;2=Nao | S | |||
| NJM_TRSERV | C | 1 | 0 | Transf.Serv. | @! | Pertence('012') | 0=Nao;1=Tarifa Origem;2=Tarifa Destino | S | |||
| NJM_CODAUT | C | 3 | 0 | Num.Aut. | Vazio().Or.ExistCpo('NJP',FwFldGet('NJM_CODCTR')+FwFldGet('NJM_CODAUT')) | NJM001 | S | ||||
| NJM_IDMOV | C | 10 | 0 | ID Moviment. | @! | NKM | S | ||||
| NJM_CODINE | C | 30 | 0 | Cod. Instr. | @! | Vazio().Or. ExistCpo("N7Q") | NJJN7Q | R | S | ||
| NJM_DESINE | C | 30 | 0 | Instr. Emb. | @! | V | S | ||||
| NJM_ITEM | C | 3 | 0 | Intervalo | @! | R | S | ||||
| NJM_SEQPRI | C | 3 | 0 | Id Regra | @! | R | S | ||||
| NJM_NMLOT | C | 6 | 0 | Sub-Lote | @! | R | S | ||||
| NJM_LOCLIZ | C | 15 | 0 | Endereco | @! | R | S | ||||
| NJM_CLVL | C | 9 | 0 | Classe Valor | @! | Vazio() .Or. CTB105CLVL() | CTH | R | S | ||
| NJM_NUMCOM | C | 9 | 0 | NF Complemen | @! | R | S | ||||
| NJM_SERCOM | C | 3 | 0 | Serie NF Com | @! | R | S | ||||
| NJM_SUBTIP | C | 2 | 0 | SubTipo Ctrl | ExistCpo('SX5','K0'+M->NJM_SUBTIP) | R | S | ||||
| NJM_DSUBTI | C | 50 | 0 | Desc Subtipo | @! | V | S | ||||
| NJM_FILORG | C | 2 | 0 | Fil. Origem | R | S | |||||
| NJM_CONDCO | C | 1 | 0 | Devol. DCO? | @! | Vazio().Or.Pertence('12') | R | 1=Sim;2=Nao | S | ||
| NJM_GENMOD | C | 1 | 0 | Gen. Modific | R | 1=Nao;2=Sim | S | ||||
| NJM_NUMAVI | C | 15 | 0 | Nr Aviso | @! | R | S | ||||
| NJM_NUMDCO | C | 20 | 0 | DCO | @! | R | S | ||||
| NJM_SEQDCO | C | 10 | 0 | Seq. DCO | R | S | |||||
| NJM_SEQNLN | C | 10 | 0 | Seq. NLN | @! | R | S | ||||