ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4709551A9E05362FB09050512Y SELECT jg_info_v1 ven_name ,jg_info_v2 ven_no ,jg_info_v3 inv_type ,jg_info_n1 tax_amt ,jg_info_n2 rec_per ,jg_info_v4 company ,jg_info_v5 acc_no ,jg_info_n3 tax_rate ,jg_info_v6 tax_id ,jg_info_v7 offset_tax_rate_code ,jg_info_v8 tax_type ,jg_info_v9 inv_no ,TO_CHAR(jg_info_d1,'DD-MON-RRRR') acc_date ,jg_info_n4 invoice_id ,TO_CHAR(jg_info_d2,'DD-MON-RRRR') cancelled_date ,jg_info_n5 item_line_cnt ,jg_info_n6 charge_dist_id ,TO_CHAR(jg_info_d3,'DD-MON-RRRR') check_void_date ,jg_info_n7 pay_amt ,jg_info_v10 line_type_lookup_code ,jg_info_v11 line_type_lookup_code_item ,jg_info_v12 line_type_lookup_code_prepay ,jg_info_v13 reversal_flag_item ,jg_info_v14 reversal_flag_pay ,jg_info_v15 reversal_flag_prepay ,jg_info_n8 parent_reversal_id ,jg_info_n9 base_amount ,jg_info_n10 invoice_amount ,TO_CHAR(jg_info_d4,'DD-MON-RRRR') void_date ,TO_CHAR(jg_info_d5,'DD-MON-RRRR') future_pay_due_date ,TO_CHAR(jg_info_d6,'DD-MON-RRRR') check_date ,jg_info_v16 payment_status_flag ,TO_CHAR(jg_info_d7,'DD-MON-RRRR') accounting_date ,jg_info_n11 reversal_inv_pmt_id ,jg_info_v17 c_company FROM JG_ZZ_VAT_TRX_GT JVGT WHERE (jg_info_v30 is null or jg_info_v30 <> 'H') --AND DECODE('''' || :P_COMPANY || '''', NULL, ' 1 ', jg_info_v10 ) = DECODE('''' || :P_COMPANY || '''', --NULL, ' 1 ', '''' || :P_COMPANY || '''') ORDER BY company ,tax_type ,tax_rate ,acc_no ,rec_per ,tax_amt JG JGZZAPAE_NTRL_XMLP AR JG ضريبة القيمة المضافة لـ EMEA: استخراج بيانات تدقيق حساب المدفوعات بدون TRL Imported from BI Publisher Description: استخراج بيانات تدقيق حساب المدفوعات بدون TRL Application: المحليات الأقليمية Source: ضريبة القيمة المضافة لـ EMEA: استخراج بيانات تدقيق حساب المدفوعات بدون TRL Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG D JG EMEA USt: KR-Prüfprotokoll - Datenauszug ohne Steuerauswertungsbuch Imported from BI Publisher Description: KR-Prüfprotokoll - Datenauszug ohne Steuerauswertungsbuch Application: Regionale Lokalisierungen Source: EMEA USt: KR-Prüfprotokoll - Datenauszug ohne Steuerauswertungsbuch Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG E JG EMEA - I.V.A.: Auditoría de Extracto de AP fuera del Libro Mayor de Información Fiscal Imported from BI Publisher Description: Auditoría de extracto de AP fuera del Libro Mayor de Información Fiscal Application: Localizaciones Regionales Source: EMEA - I.V.A.: Auditoría de Extracto de AP fuera del Libro Mayor de Información Fiscal Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG F JG EMEA - TVA : Audit - AP - Hors livre de déclaration fiscale : Extraction Imported from BI Publisher Description: Audit - AP - Hors livre de déclaration fiscale : Extraction Application: Regional Localizations Source: EMEA - TVA : Audit - AP - Hors livre de déclaration fiscale : Extraction Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG I JG IVA EMEA: estrazione audit AP non TRL Imported from BI Publisher Description: Estrazione audit AP non TRL Application: Regional Localizations Source: IVA EMEA: estrazione audit AP non TRL Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG JA JG EMEA VAT: 監査AP非TRL抽出 Imported from BI Publisher Description: 監査AP非TRL抽出 Application: Regional Localizations Source: EMEA VAT: 監査AP非TRL抽出 Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG KO JG EMEA VAT: AP 비세금 보고 원장 감사 추출 Imported from BI Publisher Description: AP 비세금 보고 원장 감사 추출 Application: Regional Localizations Source: EMEA VAT: AP 비세금 보고 원장 감사 추출 Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG PTB JG IVA do EMEA: Extração Não TRL do AP de Auditoria Imported from BI Publisher Description: Extração Não TRL do AP de Auditoria Application: Locais Regionais Source: IVA do EMEA: Extração Não TRL do AP de Auditoria Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG RU JG НДС (EMEA): извлечение "Аудит - КР без КНО" Imported from BI Publisher Description: Извлечение "Аудит - КР без КНО" Application: Местные версии Source: НДС (EMEA): извлечение "Аудит - КР без КНО" Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG S JG EMEA - moms: Extrahering för revision av leverantörsreskontra som inte är skatterapp.reskontra Imported from BI Publisher Description: Extrahering för revision av leverantörsreskontra som inte är skatterapp.reskontra Application: Regional Localizations Source: EMEA - moms: Extrahering för revision av leverantörsreskontra som inte är skatterapp.reskontra Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG TR JG EMEA KDV: Denetim AP TRL Dışı Çıkarma Imported from BI Publisher Description: Denetim AP TRL Dışı Çıkarma Application: Bölgesel Yerelleştirmeler Source: EMEA KDV: Denetim AP TRL Dışı Çıkarma Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG US JG EMEA VAT: Audit AP Non TRL Extract Imported from BI Publisher Description: Audit AP Non TRL Extract Application: Regional Localizations Source: EMEA VAT: Audit AP Non TRL Extract Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG ZHS JG EMEA 增值税：审计 AP 非 TRL 提取 Imported from BI Publisher Description: 审计 AP 非 TRL 提取 Application: 区域性本地化 Source: EMEA 增值税：审计 AP 非 TRL 提取 Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG BI Publisher :g_company_title :g_curr_name :g_data_found :g_disc_isinvlesstax_flag :g_industry_code :g_le_id :g_ledger_curr :g_ledger_name :g_precision :g_struct_num :g_tax_discount_amt :p_calling_report :p_chart_of_acc_id :p_company :p_ledger_id :p_legal_entity_id :p_period :p_rep_date :p_report_by :p_vat_reporting_entity_id 1 -10 :p_calling_report Char JGZZAPAE AR طلب التقرير فترة تقويم الضريبة D Aufrufende Auswertung Steuerkalenderperiode E Informe Que Solicita los Datos Período de calendario fiscal F Etat appelant Période du calendrier fiscal I Rapporto chiamante Periodo calendario fiscale JA コール・レポート 税金カレンダ期間 KO 보고서 호출 세금 달력 기간 PTB Relatório de Chamada Período do Calendário de Imposto RU Отчет вызова Налоговый календарный период S Anropar rapport Skattekalenderperiod TR Çağrı Raporu Vergi Takvim Dönemi US Calling Report Tax Calendar Period ZHS 调用报表 纳税日历期间 2 10 :p_vat_reporting_entity_id LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities order by value,description Y AR معرف إعداد التقرير معرف إعداد التقرير D Kennung Steuerpflichtiger Kennung Steuerpflichtiger E Identificador de Informes Identificador de informes F Identifiant de reporting Identifiant de reporting I Identificativo dichiarazione Identificativo dichiarazione JA レポート識別子 レポート識別子 KO 보고 식별자 보고 식별자 PTB Identificador de Relatório Identificador de Relatório RU Идентификатор отчета Идентификатор отчета S Rapporterings-id Rapporterings-id TR Raporlama Tanımlayıcı Raporlama Tanımlayıcı US Reporting Identifier Reporting Identifier ZHS 申报标识 申报标识 3 20 :p_rep_date Date Y AR تاريخ الإعلان تاريخ الإعلان D Meldung am Meldung am E Fecha de Declaración Fecha de declaración F Date de déclaration Date de déclaration I Data dichiarazione Data della dichiarazione JA 申告日 申告日 KO 신고 일자 신고 일자 PTB Data da Declaração Data da Declaração RU Дата декларации Дата декларации S Deklarationsdatum Deklarationsdatum TR Beyanname Tarihi Beyanname Tarihi US Declaration Date Declaration Date ZHS 公布日期 公布日期