| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| C99 | Tabela de Lotacoes | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| C99_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| C99_ID | C | 6 | 0 | ID | @! | R | S | ||||
| C99_VERSAO | C | 14 | 0 | Id. Ver. Reg | R | S | |||||
| C99_DTINI | C | 6 | 0 | Per. Ini Vld | @R 99/9999 | XFUNVldDt(,"C99_DTFIN") .and. VLDEVTAB("C99",5,FWFLDGET("C99_CODIGO"),M->C99_DTINI,FWFLDGET("C99_DTFIN"),,1) | R | S | |||
| C99_DTFIN | C | 6 | 0 | Per. Fim Vld | @R 99/9999 | XFUNVldDt("C99_DTINI") .and. VLDEVTAB("C99",5,FWFLDGET("C99_CODIGO"),FWFLDGET("C99_DTINI"),M->C99_DTFIN,,1) | R | S | |||
| C99_CODIGO | C | 30 | 0 | Cod.Lotacao | @! | VldEvTab("C99",5,M->C99_CODIGO,FWFLDGET("C99_DTINI"),FWFLDGET("C99_DTFIN"),,1) | R | S | |||
| C99_DESCRI | C | 220 | 0 | Desc.Lotacao | @! | R | S | ||||
| C99_TPLOT | C | 6 | 0 | Id.TpLotacao | @! | XFUNVldCmp("C8F",,,,2,.T.) | C8F | R | S | ||
| C99_DTPLO | C | 220 | 0 | Des.Tp.Lot. | @! | V | S | ||||
| C99_TPINES | C | 1 | 0 | Tp.Ins.Es | @! | Pertence(" 1234") .and. XVldTNrIns(M->C99_TPINES , FWFLDGET("C99_NRINES")) | R | 1=CNPJ;2=CPF;3=CAEPF;4=CNO | S | ||
| C99_NRINES | C | 15 | 0 | Num.Insc.Est | @! | XVldTNrIns(FWFLDGET("C99_TPINES") ,M->C99_NRINES) | R | S | |||
| C99_TPLOGR | C | 6 | 0 | Id.Tp.Logr. | @! | XFUNVldCmp( "C06", 3 ,,,4) | C06 | R | S | ||
| C99_DTPLOG | C | 220 | 0 | Des.Tp.Logr. | @! | V | S | ||||
| C99_DESLOG | C | 220 | 0 | Des.Lograd. | @! | R | S | ||||
| C99_NUMLOG | C | 10 | 0 | Num.Lograd. | @! | R | S | ||||
| C99_COMLOG | C | 30 | 0 | Comp.Lograd. | @! | R | S | ||||
| C99_BAIRRO | C | 60 | 0 | Bairro | @! | R | S | ||||
| C99_CEP | C | 8 | 0 | CEP | @! | R | S | ||||
| C99_UF | C | 6 | 0 | Id.UF | @! | xFunVldCmp("C09",3) | C09 | R | S | ||
| C99_DUF | C | 220 | 0 | Des. UF | @! | V | S | ||||
| C99_CODMUN | C | 6 | 0 | Id.Cod.Mun | @! | XFUNVldCmp("C07",4,FWFLDGET("C99_UF")+M->C99_CODMUN) | C07 | R | S | ||
| C99_DCODMU | C | 220 | 0 | Des.Mun | @! | V | S | ||||
| C99_FPAS | C | 6 | 0 | Id.Cod.FPAS | @! | XFUNVldCmp("C8A",,,,2,.T.) | C8A | R | S | ||
| C99_DFPAS | C | 220 | 0 | Des.FPAS | @! | V | S | ||||
| C99_CODTER | C | 6 | 0 | Id Cod Terc | @! | XFUNVldCmp("C8A",,,,4,.T.) | C8A | R | S | ||
| C99_TPINCT | C | 1 | 0 | Tp.Insc.Cont | @! | Pertence(" 12") .AND. XVldTNrIns(M->C99_TPINCT , FWFLDGET("C99_NRINCT")) | R | 1=CNPJ;2=CPF | S | ||
| C99_NRINCT | C | 14 | 0 | Num.Insc.Con | @! | XVldTNrIns(FWFLDGET("C99_TPINCT") ,M->C99_NRINCT) | R | S | |||
| C99_TPINPR | C | 1 | 0 | Tp.Insc.Prop | @! | Pertence(" 12") .AND. XVldTNrIns(FWFLDGET("C99_TPINPR") ,M->C99_NRINPR) | R | 1=CNPJ;2=CPF | S | ||
| C99_VERANT | C | 14 | 0 | Id. Ver. Ant | @! | R | S | ||||
| C99_NRINPR | C | 14 | 0 | Num.Insc.Pro | @! | XVldTNrIns(FWFLDGET("C99_TPINPR") ,M->C99_NRINPR) | R | S | |||
| C99_STATUS | C | 1 | 0 | Status Reg. | @! | Pertence(" 012349") | R | 0=Reg.Valido;1=Reg.Invalido;2=Reg.Transmitido;3=Reg.Transmitido com inconsistencias;4=Reg.Transmitido valido;9=Em Processamento | S | ||
| C99_PROTUL | C | 44 | 0 | Ult.Prot.Tr. | @! | R | S | ||||
| C99_PROTPN | C | 44 | 0 | Pnlt.Prot.Tr | @! | R | S | ||||
| C99_EVENTO | C | 1 | 0 | Id. Evento | @! | Pertence("IAE") | R | I=Inclusao;A=Alteracao;E=Exclusao | S | ||
| C99_ATIVO | C | 1 | 0 | Reg. Ativo? | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||
| C99_DCODTE | C | 220 | 0 | Desc Terceir | @! | V | S | ||||
| C99_TERSUS | C | 4 | 0 | Cod Ter Susp | @ | R | S | ||||
| C99_XMLID | C | 36 | 0 | Id do XML. | R | S | |||||
| C99_LOGOPE | C | 1 | 0 | Log Operacao | @! | R | 1=Incl.Integr;2=Incl.Manual;3=Incl.Integr+Alt.Integr;4=Incl.Integr+Alt.Manual;5=Incl.Manual+Alt.Integr;6=Incl.Manual+Alt.Manual | S | |||