Tabelas alteradas - CNPJ ALFANUMERICO (Reorg9.96) – ABC71

		COMO É NA BASE 9.95				COMO FICOU NA BASE 9.96
TABLE	COLUMN	TYPE	LEN	PREC	SCALE	TYPE	LEN	PREC	SCALE
AICC	CNPJ	numeric		14	0	char	12
AICLD	CGC_CPF	numeric		14	0	varchar	12
AICLIPN	CNPJ	numeric		14	0	varchar	12
AICP	CNPJ	numeric		14	0	varchar	12
AIEM	CNPJ	numeric		14	0	char	12
AIHU	CGC_EMPRESA	numeric		14	0	char	12
AILO	CNPJ	numeric		14	0	char	12
AION	CNPJ	numeric		14	0	char	12
AIONP	CNPJ	numeric		14	0	char	12
AIPN	CGC_CPF	numeric		14	0	char	12
AIQO	CNPJ	numeric		14	0	char	12
AIRQ	CNPJ_CPF	numeric		14	0	varchar	12
AITV	CNPJ	numeric		14	0	char	12
AITVA	CNPJ	numeric		14	0	char	12
AIVP	CGC_CPF_PARC	numeric		14	0	char	12
AIVP	CNPJ_OPORT	numeric		14	0	char	12
AIZNOP	ID_ORGANIZACAO	numeric		14	0	varchar	12
CFCC	CGC_CPF	numeric		14	0	varchar	12
CFOR	CGC_CPF	numeric		14	0	varchar	12
CGDE	CGC	numeric		14	0	varchar	12
CGEX	CGC	numeric		14	0	varchar	12
CGFF	CGC	numeric		14	0	varchar	12
CGFI	CGC	numeric		14	0	varchar	12
CLIFORNFE	CGC_CPF	numeric		14	0	char	12
COGPCN	CGC_CPF	numeric		14	0	char	12
CPCA	CGC_CPF	numeric		14	0	varchar	12
CPMVCB	CPF_CNPJ_HEADER	numeric		14	0	varchar	12
CPMVJ	INSCR_AVALISTA	numeric		14	0	varchar	12
CPMVJ	INSCR_CEDENTE	numeric		14	0	varchar	12
CPMVJ	INSCR_SACADO	numeric		14	0	varchar	12
CRCA	CGC_CPF	numeric		14	0	varchar	12
CRCL	CGC_CPF	numeric		14	0	varchar	12
CRDP	RESERVADO_1	numeric		14	0	varchar	12
CRDPRC	CNPJ_BENEFIC	numeric		14	0	varchar	12
CRGRT	CGC_CPF	numeric		14	0	varchar	12
CRPROS	CNPJ_CPF	numeric		14	0	varchar	12
CRVN	CGC_CPF	numeric		14	0	varchar	14
CTEDEST	CNPJ_EMIT	numeric		14	0	varchar	14
CTENSUCTL	CNPJ	numeric		14	0	varchar	14
EA_CRCL_ENT	CGC_CPF	numeric		14	0	varchar	12
EDCFXAI	CNPJ_INCENTIVO	numeric		14	0	varchar	12
EDCFXPE	CNPJ_INVESTIDA	numeric		14	0	varchar	12
EDCFYDE	CNPJ	numeric		14	0	varchar	12
EDCFYDO	CNPJ_BENEF	numeric		14	0	varchar	12
EDCFYDS	CNPJ	numeric		14	0	varchar	12
EDCFYEP	CNPJ_COL_CON	numeric		14	0	varchar	12
EDCFYFI	CNPJ	numeric		14	0	varchar	12
EDCFYPC	CNPJ_CONS	numeric		14	0	varchar	12
EDCFYPC	CNPJ_EMP_LIDER	numeric		14	0	varchar	12
EDCFYPC_650	CNPJ_EMP_CONS	numeric		14	0	varchar	12
EDCFYREND	CPF_CNPJ_SOCIO	numeric		14	0	varchar	12
EDCFYRF	CNPJ_FP	numeric		14	0	varchar	12
EDCFYVE	CNPJ	numeric		14	0	varchar	12
EDCP	CNPJ_CPF	numeric		14	0	varchar	12
EDRECE	CNPJ_SOFT_HOUSE	numeric		14	0	char	12
EDRECONT	CNPJ_EFR	numeric		14	0	varchar	12
EDVLCS	CNPJ_INVTD	numeric		14	0	varchar	12
EPAX	RESERVADO_14	numeric		14	0	varchar	14
EPMV	CGC	numeric		14	0	varchar	14
EPMVEXCX	CGC	numeric		14	0	varchar	14
EPMW	CGC	numeric		14	0	varchar	14
FCBC	CGC	numeric		14	0	varchar	12
FILI	CGC	varchar	14	0	0	varchar	14
FLBC	AGENCIA_CGC	numeric		14	0	varchar	12
FLBC	BANCO_CGC	numeric		14	0	varchar	12
INT_CFOR	CGC_CPF	numeric		14	0	varchar	12
INT_CRCA	CGC_CPF	numeric		14	0	varchar	12
INT_CRCE_ENV	PAG_NRO_INSCR	numeric		14	0	varchar	14
INT_CRCL	CGC_CPF	numeric		14	0	varchar	12
INT_CRDP	RESERVADO_1	numeric		14	0	varchar	12
INT_CRPROS	CNPJ_CPF	numeric		14	0	varchar	12
INT_CRVN	CGC_CPF	numeric		14	0	varchar	14
INT_CTEEVENTO	CNPJ	numeric		14	0	varchar	12
INT_DPECME	CNPJ	numeric		14	0	varchar	12
INT_DPECME	EMIT_CNPJ	numeric		14	0	varchar	12
INT_EPEC	CNPJ	numeric		14	0	varchar	14
INT_EPEC	DEST_CNPJ	numeric		14	0	varchar	14
INT_EPMV	CGC	numeric		14	0	varchar	14
INT_ESTQ	EPAX_RESERVADO_14	numeric		14	0	varchar	12
INT_NFEDE	IPI_CNPJPROD	numeric		14	0	varchar	14
INT_NFEDE	PROD_CNPJFAB	numeric		14	0	varchar	14
INT_NFEDE_TERC	IPI_CNPJPROD	numeric		14	0	varchar	14
INT_NFEDE_TERC	PROD_CNPJFAB	numeric		14	0	varchar	14
INT_NFEDI	DI_CNPJ	numeric		14	0	varchar	14
INT_NFEDX	AUTXML_CNPJ	numeric		14	0	varchar	14
INT_NFEDX	AUTXML_CPF	numeric		14	0	varchar	14
INT_NFEEVENTO	CNPJ	numeric		14	0	varchar	14
INT_NFEEVENTO	CPF	numeric		14	0	varchar	14
INT_NFEEVENTO_RT	CNPJ	numeric		14	0	varchar	14
INT_NFEFP	CARD_CNPJ	numeric		14	0	varchar	14
INT_NFEFP	CARD_CNPJRECEB	numeric		14	0	varchar	14
INT_NFEFP	PAG_CNPJPAG	numeric		14	0	varchar	14
INT_NFEME	AVULSA_CNPJ	numeric		14	0	varchar	14
INT_NFEME	DEST_CNPJ	numeric		14	0	varchar	14
INT_NFEME	EMIT_CNPJ	numeric		14	0	varchar	14
INT_NFEME	ENTREGA_CNPJ	numeric		14	0	varchar	14
INT_NFEME	INTTRAN_CNPJ	numeric		14	0	varchar	14
INT_NFEME	RETIRADA_CNPJ	numeric		14	0	varchar	14
INT_NFEME	TRANSPORTA_CNPJ	numeric		14	0	varchar	14
INT_NFEME_TERC	AVULSA_CNPJ	numeric		14	0	varchar	14
INT_NFEME_TERC	DEST_CNPJ	numeric		14	0	varchar	14
INT_NFEME_TERC	EMIT_CNPJ	numeric		14	0	varchar	14
INT_NFEME_TERC	ENTREGA_CNPJ	numeric		14	0	varchar	14
INT_NFEME_TERC	INTTRAN_CNPJ	numeric		14	0	varchar	14
INT_NFEME_TERC	RETIRADA_CNPJ	numeric		14	0	varchar	14
INT_NFEME_TERC	TRANSPORTA_CNPJ	numeric		14	0	varchar	14
INT_NFERESPTEC	INFRESPTEC_CNPJ	numeric		14	0	varchar	14
INT_NFERF	REFNF_CNPJ	numeric		14	0	varchar	14
INT_NFERFP	REFNFP_CNPJ	numeric		14	0	varchar	14
INT_NFERF_TERC	REFNF_CNPJ	numeric		14	0	varchar	14
INT_NFME	CGC	numeric		14	0	varchar	12
INT_NFTM	CNPJ_PROP	numeric		14	0	varchar	12
INT_R1000	INFOEFR_CNPJEFR	numeric		14	0	varchar	14
INT_R1000_SHOUS	CNPJSOFTHOUSE	numeric		14	0	char	14
INT_R1050	IDEENTLIG_CNPJLIG	numeric		14	0	varchar	14
INT_R2010	IDEPRESTSERV_CNPJPRESTADOR	numeric		14	0	varchar	14
INT_R2010_IPRES	CNPJPRESTADOR	decimal		14	0	varchar	14
INT_R2020	IDEESTABPREST_NRINSCESTABPREST	numeric		14	0	varchar	14
INT_R2020	IDETOMADOR_NRINSCTOMADOR	numeric		14	0	varchar	14
INT_R2020_ITOMA	NRINSCTOMADOR	decimal		14	0	varchar	14
INT_R2040	IDEESTAB_NRINSCESTAB	numeric		14	0	varchar	14
INT_R2040_IPROC	CNPJASSOCDESP	numeric		14	0	char	14
INT_R2040_IREC	CNPJASSOCDESP	numeric		14	0	char	14
INT_R2040_RREP	CNPJASSOCDESP	numeric		14	0	char	14
INT_R2050	IDEESTAB_NRINSCESTAB	numeric		14	0	varchar	14
INT_R2060	IDEESTAB_NRINSCESTAB	numeric		14	0	varchar	14
INT_R4010	IDEESTAB_NRINSCESTAB	numeric		14	0	varchar	14
INT_R4010_DDED	NRINSCPREVCOMP	varchar	14	0	0	varchar	14
INT_R4010_IADV	NRINSCADV	char	14	0	0	char	14
INT_R4010_IDEPE	IOPSA_NRINSC	numeric		14	0	char	14
INT_R4010_INFPGO	INFOPJUD_CNPJORIGRECURSO	numeric		14	0	varchar	14
INT_R4010_INFPGO	INFORRA_CNPJORIGRECURSO	numeric		14	0	varchar	14
INT_R4010_INFPGO	NRINSCFCISCP	numeric		14	0	varchar	14
INT_R4010_IOPSA	NRINSC	numeric		14	0	char	14
INT_R4010_IREEDP	IOPSA_NRINSC	numeric		14	0	char	14
INT_R4010_IREEDP	NRINSC	numeric		14	0	varchar	14
INT_R4010_IREEMB	IOPSA_NRINSC	numeric		14	0	char	14
INT_R4010_IREEMB	NRINSC	numeric		14	0	char	14
INT_R4020	IDEBENEF_CNPJBENEF	numeric		14	0	varchar	14
INT_R4020	IDEESTAB_NRINSCESTAB	numeric		14	0	varchar	14
INT_R4020_IADV	NRINSCADV	char	14	0	0	char	14
INT_R4020_INFPGO	IPROCJUD_CNPJORIGRECURSO	numeric		14	0	varchar	14
INT_R4020_INFPGO	NRINSCFCISCP	numeric		14	0	varchar	14
INT_R4040	IDEESTAB_NRINSCESTAB	numeric		14	0	varchar	14
INT_R4080	IDEESTAB_NRINSCESTAB	numeric		14	0	varchar	14
INT_R4080	IDEFONT_CNPJFONT	numeric		14	0	varchar	14
INT_R5011_IRTOM	CNPJPRESTADOR	numeric		14	0	char	14
INT_R5011_REPAD	CNPJASSOCDESP	numeric		14	0	char	14
INT_R5011_RPRES	NRINSCTOMADOR	numeric		14	0	char	14
INT_R5011_RTOM	CNPJPRESTADOR	numeric		14	0	char	14
INT_RMAC	EMBARC_CNPJ	numeric		14	0	varchar	14
INT_RMAC	REDESP_CNPJ	numeric		14	0	varchar	14
INT_RMAC	TRANSP_CNPJ	numeric		14	0	varchar	14
LFIM	CGC_IMP	numeric		14	0	varchar	12
LFIP	CGC	numeric		14	0	varchar	12
LFIPLG	CGC	numeric		14	0	varchar	12
LFPA	CAMPO_CODIGO	numeric		14	0	varchar	14
NFCR	CNPJ_CPF	numeric		14	0	varchar	12
NFDPRC	CNPJ_BENEFIC	numeric		14	0	varchar	12
NFEDEST	CNPJ_EMIT	numeric		14	0	varchar	14
NFEEVENTO_RT	CNPJ	numeric		14	0	varchar	14
NFENSUCTL	CNPJ	numeric		14	0	varchar	14
NFEPAR	RESERVADO_12	varchar	100	0	0	varchar	100
NFERESPTEC	CNPJ	numeric		14	0	varchar	14
NFME	CGC	numeric		14	0	varchar	12
NFMERC	CNPJ_BENEFIC	numeric		14	0	varchar	12
NFNR	CNPJ_REF	numeric		14	0	varchar	14
NFSOLIC	CGC_CPF	numeric		14	0	varchar	12
NFTM	CNPJ_PROP	numeric		14	0	varchar	12
TGPP	CPF_CNPJ_PROPR	numeric		14	0	varchar	12
THHH	CNPJ	numeric		14	0	char	12
TPBC	CGC	numeric		14	0	varchar	12
TPCS	CGC_CPF	numeric		14	0	varchar	12
TPPA	CAMPO_CODIGO	numeric		14	0	varchar	14
TPPL	CGC_CPF_PROP	numeric		14	0	varchar	12
TPPU	RESERVADO_04	smallint		5	0	varchar	4
TPPU	RESERVADO_05	int		10	0	varchar	9
TPVESAAS	CGC_CPF	numeric		14	0	varchar	12
USUA	CGC	numeric		14	0	varchar	12
USUA	CGC_BASE	int		10	0	varchar	8
USUA	CGC_SEQ	smallint		5	0	varchar	4
WKCL	CGC_CPF	numeric		14	0	varchar	12
WKFO	CGC_CPF	numeric		14	0	varchar	12
WTCABEC	CGC_CPF	numeric		14	0	varchar	12
WTCABEC	CGC_CPF_FILI	numeric		14	0	varchar	14
WTDACTE_ME	EMIT_CNPJ	numeric		14	0	varchar	14
WTDANFE_ME	EMIT_CNPJ	numeric		14	0	varchar	14
WTEPMV1	CGC	numeric		14	0	varchar	12
WTEPMV2	CGC	numeric		14	0	varchar	12
WTRODPE	CNPJ_TRANSP	numeric		14	0	varchar	12
WT_CRCTCB_CONS	CGC_CPF	numeric		14	0	char	12
WT_R2020_ANAL	NRINSCTOMADOR	numeric		14	0	varchar	12
WT_R2040_ANAL	CNPJ_ASSOC_DESP	numeric		14	0	char	12
WT_R2055_ANAL	NRINSCPROD	numeric		14	0	varchar	12

Artigos relacionados