从GL总帐钻取到分类帐

Oracle R12中,GL与子ledger通过XLA链接。GL表不再存储子ledger特定信息,如发票ID/日期等,仅通过Doc Sequence Number进行部分数据交换。XLA-GL对账依赖于GL_SL_LINK_ID和GL_SL_LINK_TABLE。详细对账路径包括:1) GL_JE_LINES & GL_IMPORT_REFERENCES;2) GL_IMPORT_REFERENCES & XLA_AE_LINES;3) XLA_AE_LINES/XLA_DISTRIBUTION_LINKS & 子ledger分布表,或XLA_AE_LINES/XLA_AE_HEADERS/XLA_EVENTS & 子ledger事件表。
摘要由CSDN通过智能技术生成

a) In R12, the link between GL and any subledger is via XLA.
b) GL tables WILL NO longer be storing any subledger specific information
like invoice_id/date etc onto the GL_JE_LINES/GL_JE_HEADERS etc. Max
information transfered between subledger to GL is the Doc Sequence Number
(that also in specific cases only.)
c) Any reconciliation between XLA-GL is via GL_SL_LINK_ID and
GL_SL_LINK_TABLE. these 2 columns together form a unique pair to join any row
of GL to XLA_AE_LINES.
XLA_AE_LINES.GL_SL_LINK_ID = GL_IMPORT_REFERENCES.GL_SL_LINK_ID and
XLA_AE_LINES.GL_SL_LINK_TABLE= GL_IMPORT_REFERENCES.GL_SL_LINK_TABLE
.
Now if the posting is in summary, the GL_SL_LINK_ID is available in
GL_IMPORT_REFERENCES only. If its detailed mode transfer then its available
in BOTH GL_IMPORT_REFERENCES and GL_JE_LINES. In any case, if the data is
coming via XLA, then GL_IMPORT_REFERENCES will always have these rows <

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值