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 to Import Excel Data into MATLAB.zip
Interfaces implementation
How to Import a PST file into Outlook 2013
「企业安全」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
1.Thinking With Data How To Turn Information Into Insights 2014; 2.英文原版,PDF格式;
How Safety Fits into the "Five Golden Rules" of Electrification 如何将电气化的五大黄金法则用于安全领域
How_to_do_Research_At_the_MIT_AI_Lab How_to_do_Research_At_the_MIT_AI_Lab
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 ...
介绍如何将Gerber,ODB++ 以及allegro ADFI文件导入ADS
This document describes how to add a file into WinCE 6.0 Emulator OS image using PB 6.0.
How to get SQL Database Size
Further into how to use the easy to understand masterX Objects理解masterX对象
This document will tell you how to design CEC in HDMI product.
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 ...
introduce what is libgpiod and how to use them in c/c++/python
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)