| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| C7Z | Registro analitico dos Bilhete | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| C7Z_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| C7Z_ID | C | 6 | 0 | ID | @! | R | S | ||||
| C7Z_DTMOV | D | 8 | 0 | Data Movim. | XFUNVldUni("C7Z",2,DTOS(M->C7Z_DTMOV)+FWFLDGET("C7Z_IDMOD")+FWFLDGET("C7Z_NSER")) | R | S | ||||
| C7Z_IDMOD | C | 6 | 0 | ID Modelo | @! | XFUNVldCMP("C01",3) .And. XFUNVldUni("C7Z",2,DTOS(FWFLDGET("C7Z_DTMOV"))+M->C7Z_IDMOD+FWFLDGET("C7Z_NSER")) | C01 | R | S | ||
| C7Z_DIDMOD | C | 220 | 0 | Des.Modelo | @! | V | S | ||||
| C7Z_NSER | C | 4 | 0 | Serie | @! | XFUNVldUni("C7Z",2,DTOS(FWFLDGET("C7Z_DTMOV"))+FWFLDGET("C7Z_IDMOD")+M->C7Z_NSER) | R | S | |||
| C7Z_NSSER | C | 3 | 0 | Subserie | @! | R | S | ||||
| C7Z_NDCINI | C | 6 | 0 | NēDoc. Inic. | @! | XFUNVldCod("C7Z_NDCINI ","C7Z_NDCFIM") | R | S | |||
| C7Z_NDCFIM | C | 6 | 0 | NēDoc. Final | @! | XFUNVldCod("C7Z_NDCINI ","C7Z_NDCFIM") | R | S | |||
| C7Z_CFOP | C | 6 | 0 | Id. CFOP | @! | XFUNVldCmp("C0Y",3) | C0Y | R | S | ||
| C7Z_DCFOP | C | 220 | 0 | Des. CFOP | @! | V | S | ||||
| C7Z_DTREF | D | 8 | 0 | Data Refer. | R | S | |||||
| C7Z_VLDOC | N | 16 | 2 | Vlr. Total | @E 9,999,999,999,999.99 | S | |||||
| C7Z_VLDESC | N | 16 | 2 | Vlr.Desconto | @E 9,999,999,999,999.99 | R | S | ||||
| C7Z_CSTPIS | C | 6 | 0 | Id. CST PIS | @! | XFUNVldMem(,,3,'000006') | C17 | R | S | ||
| C7Z_DCSTPI | C | 220 | 0 | Des. CST PIS | @! | V | S | ||||
| C7Z_VLBCPI | N | 16 | 2 | Vlr. BC. PIS | @E 9,999,999,999,999.99 | R | S | ||||
| C7Z_ALQPIS | N | 5 | 2 | Aliq. PIS | @E 99.99 | R | S | ||||
| C7Z_VLPIS | N | 16 | 2 | Vlr. PIS | @E 9,999,999,999,999.99 | R | S | ||||
| C7Z_CSTCFS | C | 6 | 0 | Id.CST COFIS | @! | XFUNVldMem(,,3,'000007') | C17 | R | S | ||
| C7Z_DCSTCF | C | 220 | 0 | D.CST COFINS | @! | V | S | ||||
| C7Z_VLBCCF | N | 16 | 2 | Vlr.BC.COFIN | @E 9,999,999,999,999.99 | R | S | ||||
| C7Z_ALQCFS | N | 5 | 2 | Aliq. COFINS | @E 99.99 | R | S | ||||
| C7Z_VLCOFI | N | 16 | 2 | Vlr. COFINS | @E 9,999,999,999,999.99 | R | S | ||||
| C7Z_CTA | C | 36 | 0 | CContabil | @! | R | S | ||||
| C7Z_DCTA | C | 220 | 0 | Des.CContab | @! | V | S | ||||
| C7Z_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 | ||
| C7Z_CTACTB | C | 60 | 0 | Cod Cta Ctb | @! | XFUNVldCmp("C1O",1) | C1OB | V | S | ||