Segmento | Nome do Campo | Estrutura de Dados | Campo Protheus - Timesheet / Despesa | Campo Protheus - Tabelado |
Tipo |
Tag-paiLocalização |
FIRM | lf_tax_id |
|
| NS7_COD |
NS7_COD | NS7_CODNS7_NOME | @ADDRESS_INFO |
|
|
address_1 | @ADDRESS_INFO | If_address | NS7_END |
NS7_END | city | @ADDRESS_INFO | If_address | CC2_MUN |
CC2_MUN | state_province | @ADDRESS_INFO | If_address |
NS7_ESTADO | 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 | 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 |
NS7_ESTADO | zip_postal_code | @ADDRESS_INFO | lf_remit_address | NS7_CEP |
NS7_CEP | phone | @ADDRESS_INFO | lf_remit_address | NS7_TEL |
NS7_TEL | fax | @ADDRESS_INFO | lf_remit_address | NS7_TEL |
RD0_NOMENS7_CTNAC |
|
| NS7_CTNAC |
lf_billing_contact_fname |
|
| NS7_CTNAC |
NS7_CTNAC | NXA_CPART |
|
| NXA_CPART |
lf_billing_contact_phone |
|
| NS7_TEL |
NS7_TEL | lf_billing_contact_fax |
|
| NS7_CTNAC |
NS7_CTNAC | lf_billing_contact_email |
|
| NS7_CTNAC |
NS7_CTNAC | "SIGAPFS" | app_version |
|
| Release do Protheus |
Release do Protheus | 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 |
Não encontrado | NXA_RAZSOC | cl_address | @ADDRESS_INFO |
|
|
address_1 | @ADDRESS_INFO | cl_ |
address/_1NXA_ENDENT | city/cityCC2MUNstateprovince/state_provinceNS7_ESTADO | zip_postal_code | @ADDRESS_INFO | cl_address |
/zip_postal_codeNS7_CEP | phone/phoneNS7TELfax | /faxNS7_TEL | NXA_EMAIL | U5_CONTAT |
|
| U5_CONTAT |
cl_contact_fname |
|
| U5_CONTAT |
U5_CONTAT | NXA_CCLIEN + NXA_CLOJA |
|
| NXA_CCLIEN + NXA_CLOJA |
INVOICE | inv_id |
|
| NXA_COD |
NXA_COD | NXA_DTEMI | NXA_DTEMI | 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 | 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 |
|
| NXA_TXTFAT |
inv_payment_terms |
|
| NXA_VLDESC* |
NXA_VLDESC* |
inv_generic_discount |
|
| NXA_IRRF + NXA_PIS + NXA_COFINS + NXA_CSLL + NXA_INSS + NXA_ISS* |
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 NVE_CPGEBI |
|
| NVE_CPGEBI |
lf_matter_id |
|
| NVE_MATTER |
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 | 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 |
RD0_NOME | lf_managing_contact_fname |
|
| RD0_NOME |
RD0_NOME | NS7_TEL | lf_contact_email |
|
| NS7_EMAIL |
NS7_EMAIL | NS7_CTNAC |
|
| NS7_CTNAC |
cl_contact_fname |
|
| NS7_CTNAC |
NS7_CTNAC | NS7_TEL | NS7_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_DRATF0.00 | matter_net_fees |
|
| NXC_VLHFAT - NXC_VLTAB* |
NXC_VLHFAT - NXC_VLTAB* |
matter_net_exp |
|
| NXC_VLDESP + NXC_VLTAB* |
NXC_VLDESP + NXC_VLTAB* | matter_total_due |
|
| matter_net_fees+matter_net_exp |
matter_net_fees+matter_net_exp | NXD_CPART | RD0_NOME | RD0_NOME |
|
| RD0_NOME |
tk_level |
|
| NRV_CCATE |
NRV_CCATE | NXD_VLHORA* |
tk_hours |
|
| (NXD_HFREV + NXD_HFCLI)*(NXA_PERFAT / 100) |
(NXD_HFREV + NXD_HFCLI)*(NXA_PERFAT / 100)** |
tk_cost |
|
| tk_rate*tk_hours |
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 |
*Valor covertido * Campos convertidos para a cotação da moeda informada no e-billing na cotação da emissção data emissão da fatura.