ROW_NUMBER NUMBER 18 Yes Chart of accounts mapping interface row number. MAPPING_NAME VARCHAR2 33 Yes User-defined chart of accounts definition name. FROM_CHART_OF_ACCOUNTS_CODE VARCHAR2 30 Yes The source chart of accounts structure instance code for which mappings are being imported. TO_CHART...
• CHART_OF_ACCOUNTS_ID • ACCOUNT_TYPE • ENABLED_FLAG • SEGMENT1…SEGMENT30 FND_ID_FLEX_SEGMENTS 表存储了 GL_CODE_COMBINATIONS 表中列的信息。 GL_CODE_COMBINATIONS 表存储了会计科目弹性域结构的各个段。 外键 主键表 主键列 外键列 FND_ID_FLEX_STRUCTURES ID_FLEX_NUM CHART_OF_ACCOUNTS_...
This table contains general ledger options for a chart of accounts. Details Schema: FUSION Object owner: GL Object type: TABLE Tablespace: FUSION_TS_TX_DATA Primary Key Name Columns GL_CHART_OF_ACCOUNT_OPTIONS_PK CHART_OF_ACCOUNTS_OPTIONS_ID Columns NameDatatypeLengthPrecisionNot-nullComment...
3. Assign the accounting sequence to the predefined context. Result P.S. the main purpose of document sequence is to generate an audit trail that identifies the application that created the transaction. basically, it produces sequence number when transaction is saved and records insert into tables....
Accounts 科目 Auto Post 自动过账 Aliases 别名 Books 账册 Batch Name 传票编号Combinations 汇总 Categories 种类 Carryforward 结转 Currency 货币 Consolidation 合并 Column Set 栏目集 Content Set 内容集 CENTRA 集中交易核准系统Chart of Account 会计科目架构Consolidation 合并报表 Cross Validation Rule 合理的会计...
中文翻译analyzer分析程序accountingcalendar会计历allocation分摊analyzer分析程序accounts科目autopost自动过账aliases别名books账册batchname传票编号combinations汇总categories种类carryforward结转currency货币consolidation合并columnset栏目集contentset内容集centra集中交易核准系统chartofaccount会计科目架构consolidation合并报表crossvalidation...
As Controlling is now part of the Universal Journal as well, now all CO internal actual postings are visible in General Ledger as well. The secondary cost elements are part of the chart of accounts. 成本控制成为统一日记账的组成部分,所有实际成本数据在总账中是可见的,次级成本要素也变成了总账科目...
structure_number =>50368, -- IN NUMBER, -- CHART_OF_ACCOUNT_IDcombination_id =>rctLD.CODE_COMBINATION_ID -- IN NUMBER -- code_Combination_id ) AS "GL帐户",xla_oa_functions_pkg.get_ccid_description(p_coa_id =>50368, -- CHART_OF_ACCOUNT_ID...
47 – Amortization Of Intangible Assets 48 – Non-Financial Accounts [Note: Many installations that we have seen have changed the account category names to better fit their chart of accounts. Any categories created in addition to these defaults are marked with a * in GP, even thought they hav...
You specify the system-level, default format of GL account codes using the GL Account Configuration window in the Database Configuration application. You specify organization-specific GL account codes using the Add/Modify Account Structure option in the Chart of Accounts application. Procedure In the...