首页 > 数据库 >【Oracle EBS R12】第三章 Primary Ledger Overview(英文版)

【Oracle EBS R12】第三章 Primary Ledger Overview(英文版)

时间:2024-08-07 11:28:34浏览次数:9  
标签:Transaction Currency Overview Ledger Primary record set

Primary Ledger Overview

1. Transaction Components

To record an transaction Activities, below components are maditory.

  • Transaction date

  • Transaction Details

  • Transaction Amount

2. Transaction date

To record the transaction date, we need to set up the accounting calender in Oracle EBS.
before we set up the calendar, we must first consider what year type and period type we need to choose.

Year Type:

  • Fiscal Year (the start date and end date not in the same year,like:2024/4/1~2025/3/31)
  • Calendar Year (Like:2024/1/1~2024/12/12)

Period Type:

  • Monthly(Recommend)
  • Daily
  • Adjusting Period(Additional adjustment periods can be added by needs, so a year can be set to 13 or more periods.)

3. Transaction Details

we can record the transaction details by using the COA (Chart of Account.
Please refer to below picture for more details for COA structure.

在这里插入图片描述

4. Transaction Amount

To record the Transaction amount we need to enable the Oracle EBS currency.
All the currency are seeded in the application, So we can just enable it instead of creating a new currency.

Oracle EBS provided 3 types of Currency:

  • Functional/Local Currency (Like: RMB)
  • Foreign Currency (Like: USD, JPY)
  • STAT Currency (Like:EA,M3,Marks)

5. Summry

Before recording a transaction, we need to configure the system in advance.
If we want to record the transaction in GL(General Ledger) application, the set up for below 3Cs are manditory

3Cs

Calendar
Chart of Account (COA)
Currency

If we want to record the transaction in SubLedger applications (AP, AR, CM, FA, PO, OM, INV), one more extra set up is required Accounting Method. So we need to set up 4Cs in advance.

4Cs

Calendar
Chart of Account (COA)
Currency
ACcounting Method (to define the accounting related rules, like how to debit/credit)

6. Primary Ledger (PL)

To grouping these 4Cs, we are using Primary Ledger.
Primary Ledger can be set up in General Ledger applications.

标签:Transaction,Currency,Overview,Ledger,Primary,record,set
From: https://blog.csdn.net/Hellen_201903/article/details/140977139

相关文章

  • CMPSC Application overview
    Name:Course:CMPSCDueDate:Thursday,August8thby11:59pmTopic:FinalProjectApplicationoverviewYouaregoingtocreateanapplicationthatwillrun4differentprograms.Thisprogramwillbedrivenbyamenuscreen.Theuserwillbeable......
  • Raft协议深度解析:RocketMQ中基于DLedger的日志主从复制
    本文所涉及的注释源码:bigcoder84/dledgerRaft协议主要包含两个部分:Leader选举和日志复制。前面我们在Raft协议深度解析:RocketMQ中的自动Leader选举与故障转移一文中已经详细介绍了DLedger如何实现Leader选举的,而本文主要聚焦于Leader选举完成后的日志复制的过程。一.Rock......
  • Oracle(12)什么是主键(Primary Key)?
    主键(PrimaryKey)是数据库表中的一个或多个列,它们的值唯一地标识表中的每一行。主键具有以下特点:唯一性(Uniqueness):主键的每个值在表中必须是唯一的,不能重复。非空性(NotNull):主键列的值不能为空(NULL)。单一性(SingleColumnorCompositeKey):主键可以是单个列,也可以是由多个列......
  • Overview and Stream Cipher
    CryptographyCourseNotesCourseOverviewThegoalofthiscourseistoteachyouhowcryptoprimitivesworkhowtousethemcorrectlyandreasonaboutthesecurityofyourconstructions.Inthiscourse,youwilllearnsomeabstractsofsomecryptography......
  • 部署hyperledger fabric的简单生产网络
    步骤一:搭建TLS-CA服务器证书颁发机构配置。作为整体决策的一部分,你必须决定你的peer节点(有多少,每个通道有多少等等)和你的排序服务(有多少节点,谁将拥有它们),你还必须决定你的组织的CA(译者注:证书颁发机构,下同)节点如何被部署。生产网络应该使用传输层安全性(TLS),这将需要设置......
  • C# 12 new feature Collection Expression,Primary Consctructor,Generic type alias,
    usinglistOfInt=System.Collections.Generic.List<int>;namespaceConsoleApp36{internalclassProgram{staticvoidMain(string[]args){GenericTypeAlias();}staticvoidGenericTypeAlias()......
  • mysql中key 、primary key 、unique key 与index区别
    索引被用来快速找出在一个列上用一特定值的行。没有索引,MySQL不得不首先以第一条记录开始并然后读完整个表直到它找出相关的行。表越大,花费时间越多。如果表对于查询的列有一个索引,MySQL能快速到达一个位置去搜寻到数据文件的中间,没有必要考虑所有数据。如果一个表有1000行,这比......
  • MySQL约束条件,非空空约束(not nullnull),主键约束PK(primary key),外键约束FK(foreign key
    ⅠMySQL约束条件【一】什么是约束条件约束条件:限制表中的数据,保证添加到数据表中的数据准确和可靠性!凡是不符合约束的数据,插入时就会失败!约束条件在创建表时可以使用,也可以修改表的时候添加约束条件【二】约束条件概览null和notnull为空和不为空限制整数类型必须大......
  • antdv: Each record in table should have a unique `key` prop,or set `rowKey` to a
    在使用ant-designvue框架的时候,表格组件里面会碰到 Eachrecordintableshouldhaveaunique key prop,orset rowKey toanuniqueprimarykey这样的报错,具体见下图 原因分析:我看了一下官网,以及搜索了很多答案,最终原因是:在Table中,dataSource和columns里的数据......
  • Python-PostgreSQL主键自动填充报错:SAWarning: Column x is marked as a member of th
    importdatetimefromsqlalchemyimportColumn,String,inspect,Integerfromsqlalchemy.ext.declarativeimportdeclarative_basefromsqlalchemy.ormimportsessionmakerfromsqlalchemyimportcreate_engineengine=create_engine(DATABASE_URL)Base=decla......