Tabela |
CMQ |
Notas Fiscais |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
CMQ_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
CMQ_ID |
C |
6 |
0 |
ID |
@! |
|
|
R |
|
|
S |
CMQ_VERSAO |
C |
14 |
0 |
Id. Ver. Reg |
@! |
|
|
R |
|
|
S |
CMQ_INSCES |
C |
14 |
0 |
Nr. Inscr. |
@! |
|
|
R |
|
|
S |
CMQ_INSCCO |
C |
14 |
0 |
Nr. Inscr. |
@! |
|
|
R |
|
|
S |
CMQ_CNPJCO |
C |
14 |
0 |
CNPJ Coop. |
@R 99.999.999/9999-99 |
XFUNVldPJF(,2,.F.) |
|
R |
|
|
S |
CMQ_SERIE |
C |
5 |
0 |
Serie |
@! |
|
|
R |
|
|
S |
CMQ_NUMDOC |
C |
10 |
0 |
Num. Documen |
@! |
|
|
R |
|
|
S |
CMQ_DTEMIS |
D |
8 |
0 |
Dt. Emissao |
|
|
|
R |
|
|
S |
CMQ_DTPGTO |
D |
8 |
0 |
Dt. Pagto. |
|
|
|
R |
|
|
S |
CMQ_TPSERV |
C |
6 |
0 |
Tp. Servico |
|
XFUNVldCmp("C8C",,,,1,.T.) |
C8C |
R |
|
|
S |
CMQ_DTPSER |
C |
220 |
0 |
Des. Serv. |
@! |
|
|
V |
|
|
S |
CMQ_INDOBR |
C |
1 |
0 |
Ind. Obra |
@! |
Pertence(" 0123") |
|
R |
0=Nao e obra/Nao esta sujeita a matricula;1=Empreitada Total;2=Empreitada Parcial;3=Subempreitada; |
|
S |
CMQ_NRCNO |
C |
12 |
0 |
Numero CNO |
@! |
|
|
R |
|
|
S |
CMQ_BCRETE |
N |
16 |
2 |
BC Retencao |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLBRUT |
N |
16 |
2 |
Val. Bruto |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLMATE |
N |
16 |
2 |
Val Mat. Ter |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLSERV |
N |
16 |
2 |
Val. Servico |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLDEDU |
N |
16 |
2 |
Val Deducoes |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_BCCOOP |
N |
16 |
2 |
BC Coop. |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_BCCONC |
N |
16 |
2 |
BC Concom. |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_BCCO15 |
N |
16 |
2 |
BC 15 Anos |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_BCCO20 |
N |
16 |
2 |
BC 20 Anos |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_BCCO25 |
N |
16 |
2 |
BC 25 Anos |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLSV15 |
N |
16 |
2 |
Val Srv 15 |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLSV20 |
N |
16 |
2 |
Val Srv 20 |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLSV25 |
N |
16 |
2 |
Val Srv 25 |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLAPUR |
N |
16 |
2 |
Val Ret Apur |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLSUBE |
N |
16 |
2 |
Val. SubEmp. |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLRETE |
N |
16 |
2 |
Val. Reten. |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_VLADIC |
N |
16 |
2 |
Val. Adic. |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_NRPROC |
C |
6 |
0 |
Nr Proc Jud |
@! |
XFUNVldCmp("C1G",,,,3,,.T.) |
C1G |
R |
|
|
S |
CMQ_DNRPRO |
C |
220 |
0 |
Des Proc Jud |
@! |
|
|
V |
|
|
S |
CMQ_VLNRET |
N |
16 |
2 |
Val. Nao Ret |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_CNPJSU |
C |
14 |
0 |
CNPJ Sub Emp |
@R 99.999.999/9999-99 |
XFUNVldPJF(,2,.F.) |
|
R |
|
|
S |
CMQ_VLRSUB |
N |
16 |
2 |
Val. Sub Emp |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
CMQ_TPINSC |
C |
1 |
0 |
Tp Insc Prop |
@! |
Pertence(" 12") |
|
R |
1=CNPJ;2=CPF |
|
S |
CMQ_INSCPR |
C |
14 |
0 |
Nr Insc Prop |
@! |
XFUNVldPJF(,2,.F.) |
|
R |
|
|
S |