GL_JE_HEADERS contains journal entries. There is a one-to-many relationship between journal entry batches and journal entries. Each row in this table includes the associated batch ID, the journal entry name and description, and other information about th
GL_JE_BATCHES_ GL_JE_BATCHES_GT GL_JE_BSV_REPLICATION_RULES GL_JE_BSV_REPLICATION_RULES_ GL_JE_CATEGORIES_B GL_JE_CATEGORIES_B_ GL_JE_CATEGORIES_TL GL_JE_ERROR_CODES GL_JE_HEADERS GL_JE_HEADERS_ GL_JE_HEADERS_GT GL_JE_INCLUSION_RULES ...
FROM gl_je_batches gjb, gl_je_headers gjh, gl_je_lines gjl, gl_je_categories_vl gjcv, gl_je_sources_vl gjsv, gl_code_combinations gcc WHERE gjb.je_batch_id=gjh.je_batch_id AND gjh.JE_HEADER_ID=gjl.JE_HEADER_ID AND gjh.JE_CATEGORY =gjcv.je_category_name AND gjh.JE_SOURCE=g...
gl_code_combinations:科目组合 gl_je_batches:总帐批 gl_je_headers:凭证头 字段名 含义 备注 Je_header_id 主键,凭证头ID,系统自动编 Ledger_id 帐套ID,gl_ledgers表外键 Je_category 类别,1表示手工凭证 gl_je_categories_v外键 Je_source 来源 Period_name 会计期 NAME 日记帐名称 CURRENCY_CODE 币种 STA...
gl_je_batches:总帐批 gl_je_headers:凭证头 字段名 含义 备注 Je_header_id 主键,凭证头ID,系统自动编 Ledger_id 帐套ID,gl_ledgers表外键 Je_category 类别,1表示手工凭证 gl_je_categories_v外键 Je_source 来源 Period_name 会计期 NAME 日记帐名称 ...
其中GL_JE_HEADERS和GL_JE_LINES通过JE_HEADER_ID相关联,并且是一对多的关系 GL_SETS_OF_BOOKS 账套信息,每套账有一行记录 GL_PERIODS 会计期信息 GL_CODE_COMBINATIONS 代码组合信息 GL_BALANCE 总账余额表 GL_DAILY_RATES 每天汇率 GL_TRANSLATION_RATES_V 每月汇率——期间的平均汇率 ...
VIEW - APPS.GL_JE_BATCHES_POST_V VIEW - APPS.GL_JE_BATCHES_V VIEW - APPS.GL_JE_CATEGORIES_V VIEW - APPS.GL_JE_CATEGORIES_VL VIEW - APPS.GL_JE_CATEGORY_NAMES_V VIEW - APPS.GL_JE_CONS_BALANCES_V VIEW - APPS.GL_JE_HEADERS_REVERSE_V ...
gl_je_headersjh, gl_import_referencesgir, xla_ae_linesael, xla_ae_headersaeh, xla.xla_transaction_entitiesxte, ap_invoices_allaia WHEREjl.je_header_id=jh.je_header_id ANDjl.ledger_id=jh.ledger_id ANDjl.je_header_id=gir.je_header_id ANDjl.je_line_num=gir.je_line_num ANDjl.je_...
XE.REQUEST_ID AS 创建会计科目REQUEST_ID, XE.LAST_UPDATE_DATE, AIA.INVOICE_NUM AS 发票号码 FROM APPS.GL_JE_HEADERS T, APPS.GL_JE_LINES S, APPS.gl_import_references GIR, APPS.GL_JE_BATCHES GJB, APPS.xla_ae_lines XAL, --APPS.xla_distribution_links XDL, APPS.xla_ae_headers xah, ...
select * from gl_je_batches凭证批 select * from gl_je_headers凭证头 select * from gl_je_lines凭证行 select * from gl_je_categories凭证分类 select * from gl_je_sources凭证来源 select * from gl_summary_templates科目汇总模板 select * from gl_account_hierarchies科目汇总模板层次...