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 |