1. GL_INTERFACE table
- ACTUAL_FLAG:输入 A 值表示实际金额,B 值表示预算金额或 E 值表示保留金额。必输项
- ENCUMBRANCE_TYPE_ID:如果在ACTUAL_FLAG 列中输入了E值,则必须输入相应的保留标识。可以在总帐应用产品的“保留类型”表单中定义新的保留类型。“保留类型”表的ENCUMBRANCE_TYPE_ID 列。可以使用以下SQL来查询:SELECT encumbrance_type_id,encumbrance_type FROM gl_encumbrance_types WHERE enabled_flag = 'Y';
- BUDGET_VERSION_ID:如果在ACTUAL_FLAG列中输入了B ,则必须输入相应的预算标识。可以在总帐应用产品的“定义预算”表单中定义新的预算版本。“预算版本”表的 BUDGET_VERSION_ID 列。可以使用以下 SQL来查询
SELECT budget_version_id
,budget_name
FROM gl_budget_versions
WHERE status IN ('C','O');
- USER_JE_CATEGORY_NAME,USER_JE_SOURCE_NAME
- ENTERED_DR:输入每行事务处理的借项金额
- ACCOUNTED_DR:输入非本位币事务转换为本位币的借方金额
- GL_SL_LINK_ID:输入来源行的ID。用于GL_IMPORT_REFERENCE表追溯
- GL_SL_LINK_TABLE:输入记录来源。用于GL_IMPORT_REFERENCE表追溯
-
2. 利用借口表和API导入数据.
- GL_JOURNAL_IMPORT_PKG.CREATE_TABLE创建新接口表
- Insert data into 新接口表;在GL_INTERFACE_CONTROL表填充数据
-
GL_JOURNAL_IMPORT_PKG.POPULATE_INTERFACE_CONTROL,导入日记帐
参数名 |
必须 |
类型 |
|
|
|
User_je_source_name |
Y |
接口表数据的日记账来源名称 |
Group_id |
Y |
接口表数据的Group_id。传入的变量必须为number型 |
Set_of_books_id |
Y |
接口表数据的帐套ID |
Interface_run_id |
Y |
创建GL_INTERFACE_CONTROL数据的Interface
run id |
Table_name |
N |
接口表名称 |
Process_data_action |
N |
标示处理成功后,接口数据如何处理。值为其中之一GL_JOURNAL_IMPORT_PKG.SAVE_DATA;GL_JOURNAL_IMPORT_PKG.DELETE_DATA |
3.AP与AR接口操作中涉及到的表
1)、系统接口表:
AR: ra_interface_lines_all;
ra_interface_distributions_all
注:AR没有接口头表
AP: ap_invoices_interface
ap_invoice_lines_interface
注:AP没有分配接口表
ra_interface_lines_all 中没有status状态标示数据是否插入正式表中
ap_invoices_interface 中有status状态标示数据是否插入正式表中
‘PROCESSED’为成功插入到正式表中‘REJECTED’没有成功插入到正式表中
后面章节有具体说明
2)、正式表
AR: ra_customer_trx_all(头)
ra_customer_trx_lines_all(行)
ra_cust_trx_line_gl_dist_all(分配)
AP: ap_invoices_all
ap_invoice_distributions_all(分配)
3)、错误接口表:
AP: ap_interface_rejections
AR: RA_INTERFACE_ERRORS_ALL
4)、从系统接口表到系统标准表:
AR:
ra_interface_lines_all中的数据 系统会根据设置的分组规则筛选头信息插入到ra_customer_trx_all,行信息插入到ra_customer_trx_line_all中,若没有插入收入和税收会根据自动会计自动生成会计科目分录到ra_cust_trx_line_gl_dist_all表中
AP: ap_invoices_interface 行中的信息
用同样的逻辑思考GL发现GL应该存在固定的分组规则把GL_INTERFACE中的数据按照改规则拆分并插入到GL_HEADER和GL_LINES中但是具体的信息还不是很了解只知道日记帐名可以区分gl的head和line
5)、注:
AR和AP的事物处理编号字段的长度也是不一样的
AR:TRX_NUMBER VARCHAR2(20)
AP:INVOICE_NUM VARCHAR2(50)
分享到:
相关推荐
「企业安全」How_Safety_Fits_into_the__Five_Golden_Rules__of_Electrification - 业务安全 安全人才 数据安全 NGFW 安全人才 web安全
This document describes how to edit File system tree and add your folders into WinCE 6.0 Emulator OS image.
对研究生很有用的,叫你怎麽写英语论文 How to write and publish a scientific paper ContentsChapter 1 What Is Scientific Writing? Chapter 2 Origins of ...Chapter 11 How to State the Acknowledgments
How Safety Fits into the "Five Golden Rules" of Electrification 如何将电气化的五大黄金法则用于安全领域
matlab导入excel代码utl_how_to_delete_every_row_and_columns_which_contains_negative_value 如何删除包含负值的每一行和所有列关键字:sas sql join合并大数据分析宏oracle teradata mysql sas社区stackoverflow ...
The iCloud Keychain is very well protected from hackers, but there are still some ways to break into it using so-called 'recovery' and 'synced' algorithms. We will show how the scilled hacker (or ...
You should ensure that the server's public keys are loaded by the client as described in How to use SFTP (with server validation - known hosts), or you may want to switch off server validation to get ...
Simple application that shows how to use the Data Control to connect to the Biblio.mdb database and display all authors in the Authors table.
this small,but effective projects describes how to interface nokia 3110 graphics LCD to avr microcontroller ( i ve used ATMEGA8)
How_To_Ask_Questions_The_Smart_Way_《提问的智慧》中文版_How-To-Ask-Questions-The-Smart-WayHow-To-Ask-Questions-The-Smart-Way.zip
Instructions how to use the GUI_interface Step 1: click the 'open test' button to input the test noisy image and click the 'open averaged'button to input the averaged image Step 2: setting the ...
Polya is one of the most frequently quoted mathematicians, and the following statements from "How to Solve It" make clear why: "My method to overcome a difficulty is to go around it." "Geometry is ...
how to fill a table in maysql via cvi
Now, Pearl and science journalist Dana Mackenzie explain causal thinking to general readers for the first time, showing how it allows us to explore the world that is and the worlds that could have ...
原版Hacking - Firewalls And Networks How To Hack Into Remote Computers.pdf
Think Java: How to Think Like a Computer Scientist by Allen B. Downey, Chris Mayfield 2016 | ISBN: 1491929561 Currently used at many colleges, universities, and high schools, this hands-on ...
how_to_break_software
Designed for use by novice computer users, this text begins with the basics, such as starting SPSS, defining variables, and entering and saving data. All major statistical techniques covered in ...
How To Break Into The ‘How To Make Money Online’ Niche By Sara Brown