| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| C40 | Oper da atividade imobiliaria | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| C40_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| C40_ID | C | 6 | 0 | ID | @! | R | S | ||||
| C40_DTO | D | 8 | 0 | Dt Operacao | XFUNVld() | R | S | ||||
| C40_IO | C | 6 | 0 | Ind Operacao | @! | XFUNVldCmp("C41",3).AND.XFUNVld() | C41 | R | S | ||
| C40_DIO | C | 220 | 0 | Des Operacao | @! | V | S | ||||
| C40_UI | C | 6 | 0 | Uni Imobi | @! | XFUNVldCmp("C42",3) .AND.XFUNVld() | C42 | R | S | ||
| C40_DUI | C | 220 | 0 | Des Indi Imo | @! | V | S | ||||
| C40_IEMP | C | 100 | 0 | Id.Atividade | @! | XFUNVld() | R | S | |||
| C40_DESUNI | C | 90 | 0 | Des Imobi. | @! | R | S | ||||
| C40_NUMCON | C | 100 | 0 | Num Contrato | @! | R | S | ||||
| C40_CPF | C | 11 | 0 | CPF | @R 999.999.999-99 | XFUNVld() | R | S | |||
| C40_CNPJ | C | 14 | 0 | CNPJ | @R 99.999.999/9999-99 | XFUNVld().AND.CGC(M->C40_CNPJ) | R | S | |||
| C40_VTOTVE | N | 16 | 2 | V Total UI | @E 9,999,999,999,999.99 | R | S | ||||
| C40_VRECAC | N | 16 | 2 | Val Acumulad | @E 9,999,999,999,999.99 | R | S | ||||
| C40_VTOTRE | N | 16 | 2 | Val Recebido | @E 9,999,999,999,999.99 | R | S | ||||
| C40_CSTP | C | 6 | 0 | CST PIS | @! | XFUNVldCmp("C17",3) .AND.XFUNVld() | C17 | R | S | ||
| C40_DCSTPI | C | 220 | 0 | Des CST PIS | @! | V | S | ||||
| C40_VBCPIS | N | 16 | 2 | BC de PIS | @E 9,999,999,999,999.99 | R | S | ||||
| C40_ALQPIS | N | 8 | 4 | Alq de PIS | @E 999.9999 | R | S | ||||
| C40_VPIS | N | 16 | 2 | Valor de PIS | @E 9,999,999,999,999.99 | XFUNVldVal() | R | S | |||
| C40_CSTC | C | 6 | 0 | CST COFINS | @! | XFUNVldCmp("C17",3).AND.XFUNVld() | C17 | R | S | ||
| C40_DCSTCO | C | 220 | 0 | Des CST COF | @! | V | S | ||||
| C40_VBCCOF | N | 16 | 2 | BC de COFINS | @E 9,999,999,999,999.99 | R | S | ||||
| C40_ALQCOF | N | 8 | 4 | Alq COFINS | @E 999.9999 | R | S | ||||
| C40_VCOFIN | N | 16 | 2 | Val COFINS | @E 9,999,999,999,999.99 | XFUNVldVal() | R | S | |||
| C40_PERREC | N | 8 | 4 | Per Receita | @E 999.9999 | XFUNVldVal() | R | S | |||
| C40_INDNAT | C | 1 | 0 | Ind Natureza | @! | Pertence(" 1234") | R | 1=Consorcio;2=SCP;3=Incorporacao em Condominio;4=Outras. | S | ||
| C40_INFCOM | C | 220 | 0 | Inf Comp | @! | R | S | ||||
| C40_STATUS | C | 1 | 0 | Status Reg. | @! | Pertence(" 012349") | R | 0=Reg.Valido;1=Reg.Invalido;2=Reg.Transmitido;3=Reg.Transmitido com inconsistencia;4=Reg.Transmitido valido;9=Em Processamento | S | ||