| 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 | |||