北京建设信源咨询有限公司网站,安徽工建设信息网站,好用的wordpress模板下载地址,建立网站原则(一)应收款常用标准表简介1.1常用标准表如下表中列出了与应收款处理相关的表和说明#xff1a;表名说明其他信息AR_BATCHES_ALLAR收款批表AR_BATCH_SOURCES_ALLAR收款类型表对应视图AR_CASH_RECEIPTS_ALLAR收款表对应视图AR_CASH_RECEIPT_HISTORY_ALLAR收款历史表对应视图AR_M…(一)应收款常用标准表简介1.1常用标准表如下表中列出了与应收款处理相关的表和说明表名说明其他信息AR_BATCHES_ALLAR收款批表AR_BATCH_SOURCES_ALLAR收款类型表对应视图AR_CASH_RECEIPTS_ALLAR收款表对应视图AR_CASH_RECEIPT_HISTORY_ALLAR收款历史表对应视图AR_MISC_CASH_DISTRIBUTIONS_ALLAR杂项收款分配表对应视图AP_BANK_ACCOUNTS_ALLAR汇款银行对应视图AR_RECEIPT_METHODSAR收款分类对应视图1.3表中字段的大体介绍1.3说明这里只列出了应收款处理相关的大多数常用表。还有一些不经常用到的没有涉及具体可以参考oracle网站上的二)应收款处理API2.1简介创建收款AR_RECEIPT_API_PUB.CREATE_CASH核销应收INVOICEAR_RECEIPT_API_PUB.APPLY创建并同时核销INVOICEAR_RECEIPT_API_PUB.CREATE_AND_APPLY取消核销INVOICEAR_RECEIPT_API_PUB. UNAPPLY冲销收款AR_RECEIPT_API_PUB. REVERSE核销账户AR_RECEIPT_API_PUB. APPLY_ON_ACCOUNT撤销核销账户AR_RECEIPT_API_PUB. UNAPPLY_ON_ACCOUNT核销活动AR_RECEIPT_API_PUB. ACTIVITY_APPLICATION创建杂项收款AR_RECEIPT_API_PUB. CREATE_MISC核销其他账户活动AR_RECEIPT_API_PUB. APPLY_OTHER_ACCOUNT撤销核销其他账户AR_RECEIPT_API_PUB. UNAPPLY_OTHER_ACCOUNT核销现金收款冲销其他收款AR_RECEIPT_API_PUB. APPLY_OPEN_RECEIPT取消核销现金收款冲销其他收款AR_RECEIPT_API_PUB. UNAPPLY_OPEN_RECEIPTAR_RECEIPT_API_PUB. CREATE_APPLY_ON_ACC核销到INVOICE行明细AR_RECEIPT_API_PUB. APPLY_IN_DETAIL(三)应收款处理API3.1AR_RECEIPT_API_PUB.Create_cash这个API一次可以创建一个收款创建成功后状态为未核销。此API一次只能创建一个收款无法创建收款批。AR_RECEIPT_API_PUB. PROCEDURE Create_cash(-- Standard API parameters.p_api_version IN NUMBER,p_init_msg_list IN VARCHAR2 : FND_API.G_FALSE,p_commit IN VARCHAR2 : FND_API.G_FALSE,x_return_status OUT NOCOPY VARCHAR2,x_msg_count OUT NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2,-- Receipt info. parametersp_currency_code IN VARCHAR2 DEFAULT NULL,p_amount IN NUMBER DEFAULT NULL,p_receipt_number IN VARCHAR2 DEFAULT NULL,p_receipt_date IN DATE DEFAULT NULL,p_gl_date IN DATE DEFAULT NULL,p_customer_number IN VARCHAR2 DEFAULT NULL,p_receipt_method_id IN NUMBER DEFAULT NULL,p_cr_id OUT NOCOPY NUMBER)仅包含主要参数x_return_status API返回状态x_msg_count API返回信息数量x_msg_data API返回消息内容p_currency_code 币种值来源select currency_code from fnd_currencies;p_receipt_number 收款编号p_receipt_date 收款日期p_gl_date 入账日期p_customer_number 客户编号值来源select b.account_numberfrom hz_parties a,hz_cust_accounts bwhere a.party_name Customer_nameand a.party_id b.party_idp_receipt_method_id 收款方法值来源select receipt_method_id from ar_receipt_methods;p_cr_id 返回的收款IDAPI成功后将会把数据提交到AR_RECEIVABLE_APPLICATIONS_ALL中API代码实例DECLAREl_return_status VARCHAR2(1);l_msg_count NUMBER;l_msg_data VARCHAR2(240);l_cash_receipt_id NUMBER;p_count number : 0;BEGIN-- 1) Set the applications contextmo_global.init(AR);--初始化MOACmo_global.set_policy_context(S, 261);--261是OU的IDfnd_global.apps_initialize(2125, 51260, 280, 0);--2125是USER_ID,51260是responsibility_id,280是application_id-- 2) Call the APIAR_RECEIPT_API_PUB.CREATE_CASH( p_api_version 1.0,p_init_msg_list FND_API.G_TRUE,p_commit FND_API.G_TRUE,p_validation_level FND_API.G_VALID_LEVEL_FULL,x_return_status l_return_status,x_msg_count l_msg_count,x_msg_data l_msg_data,p_currency_code CNY,p_amount 10000,p_receipt_number TEST20120120,p_receipt_date 20-01-2012,p_gl_date 20-01-2012,p_customer_number 1945,p_receipt_method_id 2004,p_cr_id l_cash_receipt_id );-- 3) Review the API outputdbms_output.put_line(Status || l_return_status);dbms_output.put_line(Cash Receipt id || l_cash_receipt_id );dbms_output.put_line(Message count || l_msg_count);if l_msg_count 1 Thendbms_output.put_line(l_msg_data ||l_msg_data);elsif l_msg_count 1 Thenloopp_count : p_count 1;l_msg_data : FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);if l_msg_data is NULL thenexit;end if;dbms_output.put_line(Message || p_count ||. ||l_msg_data);end loop;end if;END;3.2AR_RECEIPT_API_PUB.APPLYAPI描述改API一次可以核销一张INVOICE如果需要核销多张INVOICE可以循环调用。API代码详解AR_RECEIPT_API_PUB.APPLY( p_api_version IN NUMBER,,p_init_msg_list IN VARCHAR2 : FND_API.G_FALSE,p_commit IN VARCHAR2 : FND_API.G_FALSE,p_validation_level IN NUMBER : FND_API.G_VALID_LEVEL_FULL,p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPEDEFAULT NULL,,p_customer_trx_id INra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,p_amount_applied INar_receivable_applications.amount_applied%TYPE DEFAULT NULL,x_return_status OUT NOCOPY VARCHAR2,x_msg_count OUT NOCOPY NUMBER,x_msg_data OUTNOCOPY VARCHAR2);
