{"id":6169,"date":"2015-06-19T16:29:57","date_gmt":"2015-06-19T17:29:57","guid":{"rendered":"http:\/\/www.orabr.com\/?p=6169"},"modified":"2015-06-19T14:40:06","modified_gmt":"2015-06-19T17:40:06","slug":"-RECEBIMENTO-INTEGRADO-2","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=6169","title":{"rendered":"RECEBIMENTO INTEGRADO"},"content":{"rendered":"

<\/p>\n

 <\/span> <\/p>\n
\n
<\/p>\n
\n

eu tenho uma query que mostra colunas da tabela x campos do forms, nao sei se ajuda:<\/p>\n
<\/div>\n
\n
select OOD.ORGANIZATION_CODE<\/div>\n
\u00a0 \u00a0 \u00a0 ,RIT.INVOICE_TYPE_CODE<\/div>\n
\u00a0 \u00a0 \u00a0 ,RIT.DESCRIPTION<\/div>\n
\u00a0 \u00a0 \u00a0 — contas credoras:<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.CR_CODE_COMBINATION_ID) "Passivo \/ Transit\u00f3ria"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.DIFF_ICMS_CODE_COMBINATION_ID) "ICMS a Recolher" \u00a0 \u00a0 \u00a0<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IPI_LIABILITY_CCID) "IPI a Recolher" \u00a0 \u00a0 \u00a0<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.ISS_CODE_COMBINATION_ID) "ISS a Recolher" \u00a0 \u00a0 \u00a0<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IR_CODE_COMBINATION_ID) "IR a Recolher"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.INSS_EXPENSE_CCID) "INSS Despesa"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IMPORT_TAX_CCID) "Tributos Importa\u00e7\u00e3o"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IMPORT_INSURANCE_CCID) "Seguros Importa\u00e7\u00e3o"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IMPORT_FREIGHT_CCID) "Fretes Importa\u00e7\u00e3o"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IMPORT_EXPENSE_CCID) "Outras Despesas Importa\u00e7\u00e3o"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.SYMBOLIC_RETURN_CCID) "Retorno Simb\u00f3lico"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.CUSTOMER_CCID) "Devol. Clientes (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_IPI_LIABILITY_CCID) "IPI a recolher (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_ICMS_LIABILITY_CCID) "ICMS a recolher (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_ICMS_ST_LIABILITY_CCID) \u00a0"ICMS ST a recolher (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.INSS_CODE_COMBINATION_ID) "INSS Substituto"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.SISCOMEX_CCID) "SISCOMEX"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IMPORT_PIS_CCID) "PIS Importa\u00e7\u00e3o" \u00a0 \u00a0\u00a0<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.FUNRURAL_CCID) "Contribui\u00e7\u00e3o Rural"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IMPORT_COFINS_CCID) "COFINS Importa\u00e7\u00e3o"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.SEST_SENAT_CCID) "SEST\/SENAT"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.CUSTOMS_EXPENSE_CCID) "Despesas Alfandeg\u00e1rias" \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.ICMS_ST_ANT_CCID) "ICMS ST Ant a Recolher"<\/div>\n
\u00a0 \u00a0 \u00a0 — contas devedoras<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.ICMS_CODE_COMBINATION_ID) "Recupera\u00e7\u00e3o ICMS"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.ICMS_ST_CCID) "ICMS Subst Tributaria"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.IPI_CODE_COMBINATION_ID) "Recuperacao IPI"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.ACCOUNT_RECEIVABLE_CCID) "Ctas a Receber (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_IPI_REDUCTION_CCID) "Redutora IPI (RMA)" \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_ICMS_REDUCTION_CCID) "Redutora Recolher (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_ICMS_ST_REDUCTION_CCID) "Redutora ICMS ST (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.PIS_CODE_COMBINATION_ID) "Recupera\u00e7\u00e3o PIS"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.VARIATION_COST_DEVOLUTION_CCID) "Varia\u00e7\u00e3o Custo Devolu\u00e7\u00e3o"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_PIS_REDUCTION_CCID) "Redutora PIS ST (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_COFINS_REDUCTION_CCID) "Redutora COFINS ST (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.COFINS_CODE_COMBINATION_ID) "Recuperacao de COFINS"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_PIS_RED_CCID) "Redutora PIS (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.RMA_COFINS_RED_CCID) "Redutora COFINS (RMA)"<\/div>\n
\u00a0 \u00a0 \u00a0 ,(select concatenated_segments from apps.gl_code_combinations_kfv where code_combination_id = RIT.ICMS_ST_ANT_CCID_RECUP) "Recup ICMS ST Ant"<\/div>\n
FROM \u00a0 apps.rec_invoice_types RIT<\/div>\n
\u00a0 \u00a0 \u00a0 ,apps.org_organization_definitions \u00a0OOD<\/div>\n
where RIT.ORGANIZATION_ID = OOD.ORGANIZATION_ID<\/div>\n
ORDER BY OOD.ORGANIZATION_CODE, RIT.INVOICE_TYPE_CODE<\/div>\n<\/div>\n
<\/div>\n
<\/div>\n<\/div>\n
<\/p>\n
2015-06-19 14:16 GMT-03:00 Luiz Henrique Canello <\/a>lhcanello@yahoo.com<\/a> <<\/a><\/a>><\/span>:<\/p>\n

<\/u> <\/p>\n

\u00a0<\/span> <\/p>\n
\n
\n
\n
\n
Ol\u00e1 grupo,<\/div>\n
<\/div>\n
Estou precisando mapear as contas cont\u00e1beis da tabela rec_invoice_types do RI.<\/div>\n
<\/div>\n
Algu\u00e9m teria um arquivo com a correspond\u00eancia entre as contas \u00a0da tabela REC_INVOICE_TYPES e suas descri\u00e7\u00f5es\u00a0KF##_CONTA_CONTABIL?<\/div>\n
<\/div>\n
Ex.<\/div>\n
KF02_CONTA_CONTABIL = ICMS_CODE_COMBINATION_ID<\/div>\n
<\/div>\n
Obrigado<\/div>\n
<\/div>\n
Luiz Canello<\/div>\n
\u00a0<\/div>\n<\/div>\n<\/p><\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/blockquote>\n<\/div>\n

<\/div>\n<\/p><\/div>\n

<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"

  eu tenho uma query que mostra colunas da tabela x campos do forms, nao sei se ajuda: select OOD.ORGANIZATION_CODE \u00a0 \u00a0 \u00a0 ,RIT.INVOICE_TYPE_CODE \u00a0… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[77,99,105,76,103,104,97,98,107,102,108,72,100,85,87,59,89,101,106,46,84],"class_list":["post-6169","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-adf","tag-applications","tag-atg-financials","tag-banco-de-dados","tag-dadabase","tag-dba","tag-duvidas-e-repostas-oracle-vagas","tag-ebs","tag-etl","tag-fusion","tag-hyperion","tag-java","tag-odi","tag-oracle-apex","tag-oracle-forms","tag-oracle-oportunidades","tag-oracle-reports","tag-people-soft","tag-plsql-bi","tag-soa","tag-supply-chain"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6169"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/6169\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}