Histórico da Página

NS7_CODNS7_NOMENS7_ENDNS7_ESTADONS7_TELNS7_ESTADONS7_CEPNS7_CTNACNS7_CTNACNXA_CPARTNS7_TELNS7_CTNACNão encontradoNXA_RAZSOCNXA_ENDENTCC2_MUNNS7_ESTADONS7_TELU5_CONTATNXA_CCLIEN + NXA_CLOJANXA_CODCTO_DESCNXA_TXTFATNXA_IRRF + NXA_PIS + NXA_COFINS + NXA_CSLL + NXA_INSS + NXA_ISSNVE_CPGEBINVE_MATTERRD0_NOMERD0_NOMENS7_CTNACNS7_CTNACNS7_TELNS7_EMAILNXC_VLHFAT - NXC_VLTAB*NXC_VLDESP + NXC_VLTAB*matter_net_fees+matter_net_expRD0_NOME(NXD_HFREV + NXD_HFCLI)*(NXA_PERFAT / 100)tk_rate*tk_hours

Segmento	Nome do Campo	Estrutura de Dados		Campo Protheus - Timesheet / Despesa	Campo Protheus - Tabelado
Segmento	Nome do Campo	Tipo	Tag-pai	Campo Protheus - Timesheet / Despesa	Campo Protheus - Tabelado
FIRM	lf_tax_id			NS7_COD		NS7_COD
	lf_id				NS7_COD
	lf_name				NS7_NOME
	If_address	@ADDRESS_INFO
	address_1	@ADDRESS_INFO	If_address		NS7_END
	city	@ADDRESS_INFO	If_address	CC2_MUN		CC2_MUN
	state_province	@ADDRESS_INFO	If_address		NS7_ESTADO
	zip_postal_code	@ADDRESS_INFO	If_address	NS7_CEP		NS7_CEP
	phone	@ADDRESS_INFO	If_address	NS7_TEL		NS7_TEL
	fax	@ADDRESS_INFO	If_address		NS7_TEL
	lf_remit_address	@ADDRESS_INFO	@ADDRESS_INFO
	address_1	@ADDRESS_INFO	lf_remit_address	NS7_END		NS7_END
	city	@ADDRESS_INFO	lf_remit_address	CC2_MUN		CC2_MUN
	state_province	@ADDRESS_INFO	lf_remit_address		NS7_ESTADO
	zip_postal_code	@ADDRESS_INFO	lf_remit_address		NS7_CEP
	phone	@ADDRESS_INFO	lf_remit_address	NS7_TEL		NS7_TEL
	fax	@ADDRESS_INFO	lf_remit_address	NS7_TEL		RD0_NOME
	lf_billing_contact_lname				NS7_CTNAC
	lf_billing_contact_fname				NS7_CTNAC
	lf_billing_contact_id				NXA_CPART
	lf_billing_contact_phone				NS7_TEL
	lf_billing_contact_fax			NS7_CTNAC		NS7_CTNAC
	lf_billing_contact_email				NS7_CTNAC
	source_app			"SIGAPFS"		"SIGAPFS"
	app_version			Release do Protheus		Release do Protheus
CLIENT	cl_id			Se NUH_CLIEBI preenchido, utiliza o NUH_CLIEBI. Se NUH_CLIEBI estiver em branco NXA_CCLIEN+NXA_CLOJA		Se NUH_CLIEBI preenchido, utiliza o NUH_CLIEBI. Se NUH_CLIEBI estiver em branco NXA_CCLIEN+NXA_CLOJA
	cl_lf_id				Não encontrado
	cl_name				NXA_RAZSOC
	cl_address	@ADDRESS_INFO
	address_1	@ADDRESS_INFO	cl_address		NXA_ENDENT
	city	@ADDRESS_INFO	cl_address		CC2_MUN
	state_province	@ADDRESS_INFO	cl_address		NS7_ESTADO
	zip_postal_code	@ADDRESS_INFO	cl_address	NS7_CEP		NS7_CEP
	phone	@ADDRESS_INFO	cl_address		NS7_TEL
	fax	@ADDRESS_INFO	cl_address	NS7_TEL		NS7_TEL
	cl_email			NXA_EMAIL		NXA_EMAIL
	cl_contact_lname				U5_CONTAT
	cl_contact_fname			U5_CONTAT		U5_CONTAT
	cl_tax_id				NXA_CCLIEN + NXA_CLOJA
INVOICE	inv_id				NXA_COD
	inv_date			NXA_DTEMI		NXA_DTEMI
	inv_due_date			NXA_DTEMI		NXA_DTEMI
	inv_currency				CTO_DESC
	inv_start_date			Pega a menor data dentre os campos NUE_DATATS / NVY_DATA / NV4_DTCONC / NT1_DATAIN		Pega a menor data dentre os campos NUE_DATATS / NVY_DATA / NV4_DTCONC / NT1_DATAIN
	inv_end_date			Pega a maior data dentre os campos NUE_DATATS / NVY_DATA / NV4_DTCONC / NT1_DATAIN		Pega a maior data dentre os campos NUE_DATATS / NVY_DATA / NV4_DTCONC / NT1_DATAIN
	inv_desc				NXA_TXTFAT
	inv_payment_terms			NXA_VLDESC*		NXA_VLDESC*
	inv_generic_discount			NXA_IRRF + NXA_PIS + NXA_COFINS + NXA_CSLL + NXA_INSS + NXA_ISS*
	inv_total_net_due			NXA_VLFATH - NXA_VLDESC - NXA_IRRF - NXA_PIS - NXA_COFINS - NXA_CSLL - NXA_INSS - NXA_ISS + NXA.NXA_VLFATD *		NXA_VLFATH - NXA_VLDESC - NXA_IRRF - NXA_PIS - NXA_COFINS - NXA_CSLL - NXA_INSS - NXA_ISS+ NXA.NXA_VLFATD *
MATTER	cl_matter_id				NVE_CPGEBI
	lf_matter_id				NVE_MATTER
	matter_name			NVE_TITEBI se estiver preenchido senão, NT7_TITULO, caso contrário NVE_TITULO		NVE_TITEBI se estiver preenchido senão, NT7_TITULO, caso contrário NVE_TITULO
	matter_desc			NVE_TITEBI se estiver preenchido senão, NT7_TITULO, caso contrário NVE_TITULO		NVE_TITEBI se estiver preenchido senão, NT7_TITULO, caso contrário NVE_TITULO
	lf_managing_contact_lname				RD0_NOME
	lf_managing_contact_fname				RD0_NOME
	lf_contact_phone			NS7_TEL		NS7_TEL
	lf_contact_email			NS7_EMAIL		NS7_EMAIL
	cl_contact_lname				NS7_CTNAC
	cl_contact_fname				NS7_CTNAC
	cl_contact_phone				NS7_TEL
	cl_contact_email				NS7_EMAIL
	matter_final_bill			"N"		"N"
	matter_total_detail_fees			NXC_VLHFAT - NXC_VLTAB*		NXC_VLHFAT - NXC_VLTAB*
	matter_total_detail_exp			NXC_VLDESP + NXC_VLTAB*		NXC_VLDESP + NXC_VLTAB*
	matter_adj_on_fees			NXC_DRATF*		NXC_DRATF*
	matter_adj_on_exp			0.00		0.00
	matter_net_fees				NXC_VLHFAT - NXC_VLTAB*
	matter_net_exp				NXC_VLDESP + NXC_VLTAB*
	matter_total_due				matter_net_fees+matter_net_exp
TKSUM	tk_id			NXD_CPART		NXD_CPART
	tk_lname				RD0_NOME
	tk_fname			RD0_NOME		RD0_NOME
	tk_level			NRV_CCATE		NRV_CCATE
	tk_rate			NXD_VLHORA*		NXD_VLHORA*
	tk_hours				(NXD_HFREV + NXD_HFCLI)*(NXA_PERFAT / 100)
	tk_cost				tk_rate*tk_hours
FEE	charge_date			NUE_DATATS
	tk_id			NUE_CPART2
	charge_desc			NUE_DESC
	acca_task			NRZ_CTAREF
	acca_activity			NS0_CATIV
	cl_code_1			NUE_CCLIEN+NUE_CLOJA
	cl_code_2			NUE_CCLIEN+NUE_CLOJA
	charge_type			"U"
	units			NUE_TEMPOR * NXA_PERFAT/100
	rate			NUE_VALORH * NXA_PERFAT/100
	base_amount			NUE_VALOR1 * NXA_PERFAT/100
	total_amount			NUE_VALOR1 * NXA_PERFAT/100
EXPENSE	charge_date			NVY_DATA	NV4_DTLANC
	tk_id			NVY_CPART	NV4_CPART
	charge_desc			NVY_DESCRI	NV4_DESCRI
	acca_expense			NS3_CDESP	NXN_CSRVTB
	cl_code_1			NVY_CCLIEN+NVY_CLOJA	NV4_CCLIEN+NV4_CLOJA
	cl_code_2			NVY_CCLIEN+NVY_CLOJA	NV4_CCLIEN+NV4_CLOJA
	charge_type			"U"	"U"
	units			NVY_QTD	NV4_QUANT
	total_amount			NVY_VALOR * NXA_PERFAT/100*	NV4_VLHFAT * NXA_PERFAT/100*
	rate			total_amount/units	total_amount/units

...

Árvore de páginas

Versões comparadas

Versão antiga 8

Nova versão 9

Chave