| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| LEM | Cadastro de Recibo/Fatura | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| LEM_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| LEM_ID | C | 36 | 0 | ID | R | S | |||||
| LEM_NUMERO | C | 15 | 0 | Num Fat/Rec | XFUNVldUni("LEM",2,FWFLDGET("LEM_PREFIX")+M->LEM_NUMERO+FWFLDGET("LEM_IDPART")) | R | S | ||||
| LEM_NATTIT | C | 1 | 0 | Natureza | @! | Pertence(" 01") | R | 0=A Pagar;1=A Receber | S | ||
| LEM_PREFIX | C | 5 | 0 | Prefixo Tit. | XFUNVldUni("LEM",2,M->LEM_PREFIX+FWFLDGET("LEM_NUMERO")+FWFLDGET("LEM_IDPART")) | R | S | ||||
| LEM_DTEMIS | D | 8 | 0 | Dt Emissao | R | S | |||||
| LEM_IDPART | C | 36 | 0 | Id. Particip | R | S | |||||
| LEM_DPARTC | C | 220 | 0 | Desc. Part. | @! | V | S | ||||
| LEM_VLBRUT | N | 16 | 2 | Valor Bruto | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_IDPCRP | C | 6 | 0 | Id Proces RP | XFUNVldCmp("C1G",3) | C1G | R | S | |||
| LEM_DRETPC | C | 220 | 0 | D Proc Ret P | V | S | |||||
| LEM_IDPCRA | C | 6 | 0 | Id Proces RA | XFUNVldCmp("C1G",3) | C1G | R | S | |||
| LEM_DRETRA | C | 220 | 0 | D Proc INSS | V | S | |||||
| LEM_IDCNTA | C | 36 | 0 | ID. Cnt. Ana | C1O | R | S | ||||
| LEM_DCNTAA | C | 220 | 0 | Des Cnt. Ana | V | S | |||||
| LEM_OBSERV | C | 20 | 0 | Observacao | R | S | |||||
| LEM_DOCORI | C | 15 | 0 | Doc Original | @! | XFUNVldCmp("C20",4) | C20 | R | S | ||
| LEM_TPREPA | C | 1 | 0 | Tipo Repasse | Pertence(" 12345") | R | 1=Patrocinio;2=Licenciamento de Marcas e Simbolos;3=Publicidade;4=Propaganda;5=Transmissao de Espetaulos | S | |||
| LEM_IDPRUR | C | 6 | 0 | Id Prc Rural | XFUNVldCmp("C1G",3) | C1G | R | S | |||
| LEM_DPRORU | C | 220 | 0 | D Proc Rural | V | S | |||||
| LEM_VLRCP | N | 16 | 2 | Vlr Contr Pr | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_VLRGIL | N | 16 | 2 | Vlr GILRAT | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_VLRSEN | N | 16 | 2 | Vlr Senar | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_VLCPSU | N | 16 | 2 | Vlr CP Susp. | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_VLGILS | N | 16 | 2 | Vlr GILRAT S | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_VLSENS | N | 16 | 2 | Vl SENAR Sus | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_PREVPR | N | 16 | 2 | Vlr Prev Pri | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_VLFAPI | N | 16 | 2 | Vlr FAPI | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_VLFUNP | N | 16 | 2 | Vlr FUNPRESP | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_VLPALI | N | 16 | 2 | Vlr Pensao A | @E 9,999,999,999,999.99 | R | S | ||||
| LEM_IDPRRA | C | 6 | 0 | ID Proc. RRA | XFUNVldCmp("C1G",3) | C1G | R | S | |||
| LEM_DPCRRA | C | 220 | 0 | Des Proc RRA | V | S | |||||
| LEM_NATRRA | C | 50 | 0 | Natureza RRA | R | S | |||||
| LEM_QTDRRA | N | 5 | 1 | Qt Meses RRA | @E 999.9 | S | |||||
| LEM_IDPCDM | C | 6 | 0 | Id Proc. DR | XFUNVldCmp("C1G",3) | C1G | R | S | |||
| LEM_DPRODM | C | 220 | 0 | ID. Proc. DR | V | S | |||||
| LEM_IORIRE | C | 1 | 0 | Ind. Ori Rec | R | 1=Recursos do Proprio Declarante;2=Recursos de Terceiros | S | ||||
| LEM_CNPJDM | C | 14 | 0 | Cnpj Orig DR | XFUNVldPJF("LEM_CNPJDM",2) | R | S | ||||
| LEM_STATUS | C | 1 | 0 | Status Reg. | @! | R | S | ||||
| LEM_TPRECF | C | 1 | 0 | Tipo Rec/Fat | @! | Pertence(" 123") | R | 1=Nota Fiscal;2=Desdobramento;3=Avulso | S | ||
| LEM_SRVMUN | C | 20 | 0 | Cod. Servico | @! | R | S | ||||
| LEM_CODLOC | C | 6 | 0 | Loc Pre Serv | @! | C07 | R | S | |||
| LEM_DESLOC | C | 30 | 0 | Des. Local | @! | V | S | ||||
| LEM_PARTIC | C | 60 | 0 | Participante | @! | XFUNVldCmp("C1H",1) | C1HA | V | S | ||
| LEM_CTACTB | C | 62 | 0 | Cta Contabil | @! | XFUNVldCmp("C1O",1) | C1OB | V | S | ||
| LEM_TIPDOC | C | 1 | 0 | Tip. Docum. | @! | R | 0=RPA | S | |||
| LEM_IDOBRA | C | 36 | 0 | Id Obra | R | S | |||||
| LEM_TPINOB | C | 1 | 0 | Tp Inscr Obr | iif(!Empty(M->LEM_NRINOB), XFUNVldCmp("T9C",3,M->LEM_TPINOB+M->LEM_NRINOB), .T.) | V | 1=CNPJ;4=CNO | S | |||
| LEM_NRINOB | C | 14 | 0 | Nr Inscr Obr | iif(!Empty(M->LEM_TPINOB), XFUNVldCmp("T9C",3,M->LEM_TPINOB+M->LEM_NRINOB), .T.) | T9C | V | S | |||
| LEM_DSCOBR | C | 220 | 0 | Descr Obra | V | S | |||||
| LEM_PROCID | C | 6 | 0 | Proc ID | @! | R | S | ||||