ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725A51A9E05362FB09050512Y SELECT &P_HINT_CLAUSE LGR.NAME LEDGER_NAME, LGR.CURRENCY_CODE LEDGER_CURRENCY, LGR.LEDGER_ID LEDGER_ID, GLB.JE_BATCH_ID BATCH_ID, GLB.NAME BATCH_NAME, GLB.DESCRIPTION BATCH_DESC, GLB.STATUS BATCH_STATUS_CODE, GLB.POSTED_DATE BATCH_POSTED_DATE, GLB.DEFAULT_PERIOD_NAME BATCH_PERIOD_NAME, GLB.DEFAULT_EFFECTIVE_DATE BATCH_EFFECTIVE_DATE, GLB.ACTUAL_FLAG ACTUAL_FLAG, GLB.AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG, GLB.APPROVAL_STATUS_CODE APPROVAL_STATUS_CODE, GLB.BUDGETARY_CONTROL_STATUS BUD_CONTROL_STATUS, GLB.RUNNING_TOTAL_DR BATCH_TOT_DR, GLB.RUNNING_TOTAL_CR BATCH_TOT_CR, GLB.RUNNING_TOTAL_ACCOUNTED_DR BATCH_TOT_ACC_DR, GLB.RUNNING_TOTAL_ACCOUNTED_CR BATCH_TOT_ACC_CR, GLB.DATE_CREATED BATCH_DATE_CREATED, GLH.JE_HEADER_ID HDR_ID, GLH.NAME HDR_NAME, GLH.DESCRIPTION HDR_DESC, GLH.TAX_STATUS_CODE TAX_STATUS_CODE, GLH.RUNNING_TOTAL_DR HDR_TOT_DR, GLH.RUNNING_TOTAL_CR HDR_TOT_CR, GLH.RUNNING_TOTAL_ACCOUNTED_DR HDR_TOT_ACC_DR, GLH.RUNNING_TOTAL_ACCOUNTED_CR HDR_TOT_ACC_CR, GLH.CURRENCY_CODE HDR_CURR_CODE, GLH.CURRENCY_CONVERSION_DATE CONVERSION_DATE, GLH.CURRENCY_CONVERSION_RATE CONVERSION_RATE, DCT.USER_CONVERSION_TYPE CONVERSION_TYPE, GLH.BUDGET_VERSION_ID BUDGET_VERSION_ID, GLH.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, GLH.EXTERNAL_REFERENCE HDR_EXTREFERENCE, GLH.LAST_UPDATE_DATE HDR_LAST_UPDATE_DATE, GLH.DEFAULT_EFFECTIVE_DATE HDR_EFF_DATE, GLH.DOC_SEQUENCE_ID DOC_SEQ_ID, DOCSEQ.NAME DOC_SEQ_NAME, GLH.DOC_SEQUENCE_VALUE DOC_SEQ_VALUE, FU.USER_NAME HDR_LAST_UPDATED_BY, GJS.USER_JE_SOURCE_NAME HDR_SOURCE, GJC.USER_JE_CATEGORY_NAME HDR_CATEGORY, GLL.JE_LINE_NUM JE_LINE_NUM, GLL.TAX_CODE_ID TAX_CODE_ID, GLL.TAX_TYPE_CODE TAX_TYPE_CODE, GLL.DESCRIPTION LINE_DESC, GLL.ENTERED_DR ENTERED_DR, GLL.ENTERED_CR ENTERED_CR, GLL.ACCOUNTED_DR ACCOUNTED_DR, GLL.ACCOUNTED_CR ACCOUNTED_CR, GLL.STAT_AMOUNT STAT_AMOUNT, GLL.EFFECTIVE_DATE EFFECTIVE_DATE, GLL.REFERENCE_1 REFERENCE1, GLL.REFERENCE_2 REFERENCE2, GLL.REFERENCE_3 REFERENCE3, GLL.REFERENCE_4 REFERENCE4, GLL.REFERENCE_5 REFERENCE5, GLL.REFERENCE_6 REFERENCE6, GLL.REFERENCE_7 REFERENCE7, GLL.REFERENCE_8 REFERENCE8, GLL.REFERENCE_9 REFERENCE9, GLL.REFERENCE_10 REFERENCE10, SUBDOCSEQ.NAME SUB_DOC_SEQ_NAME, GLL.SUBLEDGER_DOC_SEQUENCE_ID SUB_DOC_SEQ_ID, GLL.SUBLEDGER_DOC_SEQUENCE_VALUE SUB_DOC_SEQ_VAL, &SELECT_ACCOUNT ACCOUNT, &SELECT_BAL_SEGMENT BAL_SEG_VAL, &SELECT_ACCT_SEGMENT ACCT_SEG_VAL, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_seg_val', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') COST_CTR_SEG_VAL, &SELECT_SECONDARY_SEGMENT ADDITIONAL_SEGMENT_VALUE, GL_GLWACCTR_XMLP_PKG.batch_typeformula(GLB.ACTUAL_FLAG) BATCH_TYPE, GL_GLWACCTR_XMLP_PKG.batch_statusformula(GLB.STATUS) BATCH_STATUS, GL_GLWACCTR_XMLP_PKG.approval_statusformula(GLB.APPROVAL_STATUS_CODE) APPROVAL_STATUS, GL_GLWACCTR_XMLP_PKG.budget_ctrl_statusformula(GLB.BUDGETARY_CONTROL_STATUS) BUDGET_CTRL_STATUS, GL_GLWACCTR_XMLP_PKG.jrnl_typeformula(GLB.AVERAGE_JOURNAL_FLAG) JRNL_TYPE, GL_GLWACCTR_XMLP_PKG.budget_nameformula(GLH.BUDGET_VERSION_ID) BUDGET_NAME, GL_GLWACCTR_XMLP_PKG.encumbrance_typeformula(GLH.ENCUMBRANCE_TYPE_ID) ENCUMBRANCE_TYPE, GL_GLWACCTR_XMLP_PKG.tax_statusformula(GLH.TAX_STATUS_CODE) TAX_STATUS, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_dsp', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ACCOUNT_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') ACCOUNT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_seg_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION') BAL_SEG_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_seg_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') ACCT_SEG_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_seg_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'DESCRIPTION') COST_CTR_SEG_DESC, &ADDITIONAL_SEGMENT_DESC ADDITIONAL_SEGMENT_DESC, GL_GLWACCTR_XMLP_PKG.tax_typeformula(GLL.TAX_TYPE_CODE) TAX_TYPE, GL_GLWACCTR_XMLP_PKG.tax_codeformula(GLL.TAX_CODE_ID, GLL.TAX_TYPE_CODE) TAX_CODE, GL_GLWACCTR_XMLP_PKG.contra_acct_valueformula(GLH.JE_HEADER_ID, GLL.SUBLEDGER_DOC_SEQUENCE_ID, GLL.SUBLEDGER_DOC_SEQUENCE_VALUE, GLL.ACCOUNTED_DR, GLL.ACCOUNTED_CR) CONTRA_ACCT_VALUE, fnd_flex_xml_publisher_apis.process_kff_combination_1('contra_acct_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') CONTRA_ACCT_DESC, GL_GLWACCTR_XMLP_PKG.cf_line_balanceformula(cc.segment1, cc.segment3, cc.segment4, LGR.LEDGER_ID, GLB.STATUS) CF_LINE_BALANCE, GL_GLWACCTR_XMLP_PKG.cf_gl_balanceformula(cc.segment1, cc.segment3, cc.segment4, LGR.LEDGER_ID, GLB.STATUS) CF_GL_BALANCE -- GL_GLWACCTR_XMLP_PKG.begin_balanceformula(:CF_LINE_BALANCE, :CF_GL_BALANCE) BEGIN_BALANCE FROM &P_PERF_FROM &P_JOURNAL_FROM_CLAUSE &P_LEDGER_FROM WHERE GLH.LEDGER_ID = LGR.LEDGER_ID &P_LEDGER_WHERE AND GLH.JE_SOURCE = GJS.JE_SOURCE_NAME AND GLH.JE_CATEGORY = GJC.JE_CATEGORY_NAME AND GLH.LAST_UPDATED_BY = FU.USER_ID AND GLB.JE_BATCH_ID = GLH.JE_BATCH_ID AND GLH.DOC_SEQUENCE_ID = DOCSEQ.DOC_SEQUENCE_ID(+) AND GLL.SUBLEDGER_DOC_SEQUENCE_ID = SUBDOCSEQ.DOC_SEQUENCE_ID(+) AND DCT.CONVERSION_TYPE (+) = GLH.CURRENCY_CONVERSION_TYPE &P_POSTING_STATUS &P_HEADER_POSTING_STATUS &P_DAS_WHERE &P_CURRENCY_WHERE &P_ACTUAL_TYPE_WHERE &P_BATCH_WHERE &P_SOURCE_WHERE &P_CATEGORY_WHERE and &P_BAL_WHERE &P_DOC_ID_WHERE &P_DOC_VAL_WHERE &P_SUB_DOC_ID_WHERE &P_SUB_DOC_VAL_WHERE &P_NOT_ZERO_LINE_WHERE &P_PERIOD_WHERE &P_CONTRA_ACCOUNT_WHERE &P_JOURNAL_DATE_WHERE &P_JOURNAL_UPD_DATE_WHERE &P_JOURNAL_LAST_UPD_WHERE and &P_AFF_WHERE &P_AMOUNT_WHERE &P_JOURNAL_WHERE_CLAUSE SQLGL GLRXDBJ_XML AR GL اليوميات - دفتر اليومية (بتنسيق XML) Imported from BI Publisher Description: اليوميات - دفتر اليومية Application: الأستاذ العام Source: اليوميات - دفتر اليومية (بتنسيق XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG D GL Buchungsjournal Imported from BI Publisher Description: Buchungsjournal Application: Rechnungswesen Source: Buchungsjournal (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG E GL Asientos - Diario Imported from BI Publisher Description: Asientos - Diario Application: General Ledger Source: Asientos - Diario (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG F GL Pièces - Livre comptable journalier Imported from BI Publisher Description: Pièces - Livre comptable journalier Application: General Ledger Source: Pièces - Livre comptable journalier (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG I GL Scritture contabili - Registro giornaliero Imported from BI Publisher Description: Scritture contabili - registro giornaliero Application: General Ledger Source: Scritture contabili - Registro giornaliero (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG JA GL 仕訳 - 日計帳 Imported from BI Publisher Description: 仕訳 - 日計帳 Application: General Ledger Source: 仕訳 - 日計帳 (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG KO GL 분개 - 일자 기준 Imported from BI Publisher Description: 분개 - 일자 기준 Application: General Ledger Source: 분개 - 일자 기준(XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG PTB GL Lançamentos - Livro Diário Imported from BI Publisher Description: Lançamentos - Livro Diário Application: General Ledger Source: Lançamentos - Livro Diário (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG RU GL Журналы - регистрация операций Imported from BI Publisher Description: Журналы - регистрация операций Application: Главная книга Source: Журналы - регистрация операций (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG S GL Verifikationer - Dagbok Imported from BI Publisher Description: Verifikationer - dagbok Application: General Ledger Source: Verifikationer - Dagbok (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG TR GL Fişler - Yevmiye Defteri Imported from BI Publisher Description: Fişler - Günlük Defter Application: Genel Muhasebe Source: Fişler - Yevmiye Defteri (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG US GL Journals - Day Book Imported from BI Publisher Description: Journals - Day Book Application: General Ledger Source: Journals - Day Book (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG ZHS GL 日记账 - 日记账 Imported from BI Publisher Description: 日记账 - 日记账 Application: 总帐管理系统 Source: 日记账 - 日记账 (XML) Short Name: GLRXDBJ_XML DB package: GL_GLWACCTR_XMLP_PKG BI Publisher &additional_segment_desc &p_actual_type_where &p_aff_where &p_amount_where &p_bal_where &p_batch_where &p_category_where &p_contra_account_where &p_currency_where &p_das_where &p_doc_id_where &p_doc_val_where &p_header_posting_status &p_hint_clause &p_journal_date_where &p_journal_from_clause &p_journal_last_upd_where &p_journal_upd_date_where &p_journal_where_clause &p_ledger_from &p_ledger_where &p_not_zero_line_where &p_perf_from &p_period_where &p_posting_status &p_source_where &p_sub_doc_id_where &p_sub_doc_val_where &select_account &select_acct_segment &select_bal_segment &select_secondary_segment :access_set_name :acct_seg_name_dsp :bal_seg_name_dsp :c_date_format :c_param_end_date :c_param_start_date :chart_of_accounts_id :h_end_date :h_end_update_date :h_set_of_books_id :h_start_date :h_start_update_date :no_contra_account :p_acc_segment_select :p_acc_segment_where :p_access_set_id :p_actual_flag :p_actual_type_where :p_aff_from :p_aff_to :p_aff_where :p_aff_where_jrl :p_amount_from :p_amount_to :p_amount_where :p_amt_flag :p_bal_seg_val :p_bal_where :p_batch_name :p_batch_where :p_category :p_category_where :p_coa :p_conc_request_id :p_contra_account :p_contra_account_where :p_contra_acct :p_contra_flag :p_currency :p_currency_where :p_das_where :p_debug :p_doc_id :p_doc_id_where :p_doc_val_where :p_doc_value :p_end_date :p_end_doc_value :p_end_update_date :p_header_posting_status :p_hint_clause :p_journal_date_where :p_journal_date_where_2 :p_journal_date_where_3 :p_journal_from_clause :p_journal_last_upd_where :p_journal_upd_date_where :p_journal_where_clause :p_journals_line_flag :p_last_update_date :p_last_updated_by :p_ledger_from :p_ledger_id :p_ledger_where :p_not_zero_line_where :p_pagebreak :p_perf_from :p_perf_from_cluase :p_period_name :p_period_where :p_posting_status :p_report_name :p_sec_seg_num :p_sec_segment_where :p_source :p_source_where :p_start_date :p_start_doc_value :p_start_update_date :p_status :p_sub_doc_id :p_sub_doc_id_where :p_sub_doc_val_where :p_sub_doc_value :p_use_date_col :param_acct_from :param_acct_to :param_amount_high :param_amount_low :param_amt_flag :param_balancing_segment :param_basis :param_batch_name :param_category :param_contra_acct :param_currency_code :param_doc_seq_name :param_doc_seq_value :param_end_date :param_end_doc_seq_value :param_last_updated_by :param_ledger_name :param_period_name :param_posting_status :param_sec_seg_name :param_source :param_start_date :param_start_doc_seq_value :param_sub_doc_seq_name :param_sub_doc_seq_value :prev_acct_seg_val :prev_bal_seg_val :prev_gl_bal :prev_led_id :prev_line_bal :prev_sec_seg_val :select_account :select_acct_segment :select_bal_segment :select_cost_ctr_segment :select_secondary_segment 1 -50 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة صلاحيات الوصول معرف مجموعة صلاحيات الوصول D ZugriffsSet-Kennung ZugriffsSet-Kennung E Id Juego de Accesos Id Juego de Accesos F ID jeu d'accès ID jeu d'accès I Id serie di accesso Id serie di accesso JA アクセス・セットID アクセス・セットID KO 액세스 세트 ID 액세스 세트 ID PTB Id do Conjunto de Acesso Id do Conjunto de Acesso RU Идент. набора доступа Идент. набора доступа S Åtkomstuppsättnings-id Åtkomstuppsättnings-id TR Erişim Kümesi No Erişim Kümesi No US Access Set Id Access Set Id ZHS 访问权限集标识 访问权限集标识 2 -40 :p_actual_flag LOV Oracle GL_SRS_BALANCE_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='BATCH_TYPE' order by upper(meaning) select meaning from gl_lookups where lookup_type='BATCH_TYPE' and lookup_code='A' Y AR علامة الفعلي علامة الفعلي D Betragsart Betragsart E Tipo de Saldo Tipo de Saldo F Indicateur Réel Indicateur Réel I Flag Consuntivo Flag Consuntivo JA 実績フラグ 実績フラグ KO 실적 플래그 실적 플래그 PTB Indicador Real Indicador Real RU Фактический флаг Фактический флаг S Faktisk-flagga Faktisk-flagga TR Fiili İşareti Fiili İşareti US Actual Flag Actual Flag ZHS 实际标志 实际标志 3 -30 :p_coa Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR GL_SRS_COA_UNVALIDATED معرف جدول تصنيف الحسابات D GL_SRS_COA_UNVALIDATED Kontenplankennung E GL_SRS_COA_UNVALIDATED Id Plan de Cuentas F GL_SRS_COA_UNVALIDATED ID plan de comptes I GL_SRS_COA_UNVALIDATED Id del piano dei conti JA GL_SRS_COA_UNVALIDATED 勘定体系ID KO GL_SRS_COA_UNVALIDATED 계정 코드집 ID PTB GL_SRS_COA_UNVALIDATED ID do Plano de Contas RU GL_SRS_COA_UNVALIDATED Идент. плана счетов S GL_SRS_COA_UNVALIDATED Kontoplans-id TR GL_SRS_COA_UNVALIDATED Hesap Planı No US GL_SRS_COA_UNVALIDATED Chart of Accounts ID ZHS GL_SRS_COA_UNVALIDATED 科目表标识 4 -20 :p_pagebreak LOV Oracle GL_SRS_PAGEBREAK_SEGS Y select segment_num id, segment_name value, s.description description from fnd_id_flex_segments_vl s,fnd_segment_attribute_values v where s.id_flex_code='GL#' and v.id_flex_code='GL#' and s.id_flex_num=:$flex$.gl_srs_coa_unvalidated and v.id_flex_num=:$flex$.gl_srs_coa_unvalidated and s.enabled_flag='Y' and s.application_column_name=v.application_column_name and s.application_id=101 and v.application_id=101 and v.segment_attribute_type='GL_ACCOUNT' and v.attribute_value='N' order by segment_num Select segment_name from FND_ID_FLEX_SEGMENTS_VL S, FND_SEGMENT_ATTRIBUTE_VALUES AT Where S.ID_FLEX_CODE = 'GL#' and AT.ID_FLEX_CODE = 'GL#' and S.id_flex_num = :$FLEX$.GL_SRS_COA_UNVALIDATED and AT.id_flex_num = :$FLEX$.GL_SRS_COA_UNVALIDATED and S.enabled_flag = 'Y' and S.application_column_name = AT.application_column_name and S.application_id = 101 and AT.application_id = 101 and AT.segment_attribute_type = 'GL_BALANCING' and AT.attribute_value = 'Y' AR GL_SRS_PAGEBREAK_SEGS مقطع فاصل الصفحات D GL_SRS_PAGEBREAK_SEGS Seitenumbruch-Segment E GL_SRS_PAGEBREAK_SEGS Segmento de Salto de Página F GL_SRS_PAGEBREAK_SEGS Segment de saut de page I GL_SRS_PAGEBREAK_SEGS Segmento di interruzione di pagina JA GL_SRS_PAGEBREAK_SEGS 改ページ・セグメント KO GL_SRS_PAGEBREAK_SEGS 페이지 구분 세그먼트 PTB GL_SRS_PAGEBREAK_SEGS Segmento para Quebra de Página RU GL_SRS_PAGEBREAK_SEGS Сегмент разрыва страницы S GL_SRS_PAGEBREAK_SEGS Sidbrytningssegment TR GL_SRS_PAGEBREAK_SEGS Sayfa Sonu Segmenti US GL_SRS_PAGEBREAK_SEGS Pagebreak Segment ZHS GL_SRS_PAGEBREAK_SEGS 分页段 5 10 :p_ledger_id LOV Oracle GL_SRS_LEDGER_WITH_SETS_STORE_ID Y select led.ledger_id id, led.name value, led.description description from gl_access_set_ledgers ac,gl_ledgers led where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id order by name AR دفتر الأستاذ/مجموعة دفاتر الأستاذ دفتر الأستاذ/مجموعة دفاتر الأستاذ D Buch/BuchSet Buch/BuchSet E Libro Mayor/Juego de Libros Mayores Libro Mayor/Juego de Libros Mayores F Livre/jeu de livres Livre/jeu de livres I Libro contabile/serie libri contabili Libro contabile/serie libri contabili JA 元帳/元帳セット 元帳/元帳セット KO 원장/원장 세트 원장/원장 세트 PTB Razão/Conjunto de Razões Razão/Conjunto de Razões RU Книга/набор книг Книга/набор книг S Huvudbok/huvudboksgrupp Huvudbok/huvudboksgrupp TR Defter / Defter Kümesi Defter / Defter Kümesi US Ledger/Ledger Set Ledger/Ledger Set ZHS 分类账/分类账集 分类账/分类账集 6 20 :p_currency LOV Oracle GL_SRS_DAS_LEDGER_CURRENCIES_AND_STAT Y select curr.currency_code id, curr.currency_code value, null description from fnd_currencies curr where curr.currency_code='STAT' or curr.currency_code in (select l.currency_code from gl_access_set_ledgers acc,gl_ledgers l where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=acc.ledger_id and l.object_type_code='L') order by value,description Y AR العملة رمز أو موقف العملة الأساسية D Währung Bilanzwährung oder STAT E Divisa Código de Divisa Funcional o ESTADÍSTICA F Devise Code devise comptable ou STAT I Divisa Codice della moneta di conto o STAT JA 通貨 機能通貨コードまたは統計 KO 통화 기준 통화 코드 또는 통계 PTB Moeda Código de Moeda Funcional ou STAT RU Валюта Код функциональной валюты или СТАТ S Valuta Funktionell valutakod eller STAT TR Para Birimi Fonksiyonel Para Birimi Codu veya STAT US Currency Functional Currency Code or STAT ZHS 币种 本位币代码或 STAT 7 30 :p_start_date Date Y AR GL_SRS_STANDARD_DATE_LOW تاريخ البداية D GL_SRS_STANDARD_DATE_LOW Startdatum E GL_SRS_STANDARD_DATE_LOW Fecha de Inicio F GL_SRS_STANDARD_DATE_LOW Date de début I GL_SRS_STANDARD_DATE_LOW Data avvio JA GL_SRS_STANDARD_DATE_LOW 開始日 KO GL_SRS_STANDARD_DATE_LOW 시작 일자 PTB GL_SRS_STANDARD_DATE_LOW Data Inicial RU GL_SRS_STANDARD_DATE_LOW Начальная дата S GL_SRS_STANDARD_DATE_LOW Startdatum TR GL_SRS_STANDARD_DATE_LOW Başlangıç Tarihi US GL_SRS_STANDARD_DATE_LOW Start Date ZHS GL_SRS_STANDARD_DATE_LOW 起始日期 8 40 :p_end_date Date Y AR GL_SRS_STANDARD_DATE_HIGH تاريخ النهاية D GL_SRS_STANDARD_DATE_HIGH Enddatum E GL_SRS_STANDARD_DATE_HIGH Fecha de Finalización F GL_SRS_STANDARD_DATE_HIGH Date de fin I GL_SRS_STANDARD_DATE_HIGH Data fine JA GL_SRS_STANDARD_DATE_HIGH 日付:至 KO GL_SRS_STANDARD_DATE_HIGH 종료 일자 PTB GL_SRS_STANDARD_DATE_HIGH Data Final RU GL_SRS_STANDARD_DATE_HIGH Конечная дата S GL_SRS_STANDARD_DATE_HIGH Slutdatum TR GL_SRS_STANDARD_DATE_HIGH Bitiş Tarihi US GL_SRS_STANDARD_DATE_HIGH End Date ZHS GL_SRS_STANDARD_DATE_HIGH 终止日期 9 50 :p_source LOV Oracle GL_SRS_JOURNAL_SOURCE Y select je_source_name id, user_je_source_name value, description description from gl_je_sources order by user_je_source_name AR مصدر اليومية مصدر اليومية D Belegherkunft Belegherkunft E Origen Origen F Origine de pièce Origine de pièce I Origine scrittura contabile Origine della scrittura contabile JA 仕訳ソース 仕訳ソース KO 분개 출처 분개 출처 PTB Origem do Lançamento Origem do Lançamento RU Источник журнала Источник журнала S Verifikationskälla Verifikationskälla TR Fiş Kaynağı Fiş Kaynağı US Journal Source Journal Source ZHS 日记账来源 日记账来源 10 60 :p_bal_seg_val Char Y AR مقطع الترصيد مقطع الترصيد D Buchungskreis Buchungskreis E Segmento de Balance Segmento de Balance F Segment d'équilibrage Segment d'équilibrage I Segmento di quadratura Segmento di quadratura JA 貸借一致セグメント 貸借一致セグメント KO 잔액 조정 세그먼트 잔액 조정 세그먼트 PTB Segmento Balanceador Segmento Balanceador RU Балансирующий сегмент Балансирующий сегмент S Balanssegment Balanssegment TR Dengeleme Segmenti Dengeleme Segmenti US Balancing Segment Balancing Segment ZHS 平衡段 平衡段 11 70 :p_category LOV Oracle GL_SRS_JOURNAL_CATEGORY_2 Y select je_category_name id, user_je_category_name value, description description from gl_je_categories order by user_je_category_name AR الفئة الفئة D Kategorie Kategorie E Categoría Categoría F Catégorie Catégorie I Categoria Categoria JA カテゴリ カテゴリ KO 범주 범주 PTB Categoria Categoria RU Категория Категория S Kategori Kategori TR Kategori Kategori US Category Category ZHS 类别 类别