随笔分类 -  AR

应收账款模组
取客户的银行帐号SQL
摘要：SELECT ibybanks.bank_name, --银行 ibybanks.bank_branch_name, --分行 ibybanks.bank_account_num_electronic--银行帐号 FROM ... 阅读全文
posted @ 2014-06-03 11:17 我不卖豆腐 阅读(788) 评论(0) 推荐(0)
Oracle EBS订单的流程(Order->AR)
摘要：转自：http://blog.csdn.net/pan_tian/article/details/7693447 阅读全文
posted @ 2014-04-15 09:55 我不卖豆腐 阅读(430) 评论(0) 推荐(0)
客户信息表 自我汇总 待确认
摘要：--BILL TO 和SHIP TOselect * from hz_parties hz, hz_cust_accounts hca, hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site_uses where hz.party_id = hca.party_id and hca.cust_account_id = acct_site.cust_account_id and acct_site.cust_acct_site_id = site... 阅读全文
posted @ 2014-03-21 14:09 我不卖豆腐 阅读(416) 评论(0) 推荐(0)
AR 应收 表
摘要：AR 应收应收事务处理相关表SELECT*FROMar.ar_batches_all; --事务处理批SELECT*FROMar.ra_customer_trx_all; --应收事务头/发票头 SELECT*FROMra.ra_customer_trx_lines_all; --应收事务行项目/发票行 SELECT*FROMra.ra_cust_trx_line_gl_dist_all;--应收事务分配行/发票分配 SELECT*FROMar.ar_payment_schedules_all; --收款计划/发票调整 收款相关表SELECT*FROMa... 阅读全文
posted @ 2013-11-18 17:18 我不卖豆腐 阅读(6396) 评论(0) 推荐(0)
AR 发票号码 sequence
摘要：the categor in the GL is related to thetransacation type in ARassign the sequence to the relate AR transaction type in GLbeginDbms_application_info.set_client_info(84);end;Select * from RA_CUST_TRX_TYPES where CUST_TRX_TYPE_ID=1101SELECT * FROM apps.fnd_doc_sequence_assignments WHERE category_cod... 阅读全文
posted @ 2013-02-27 21:47 我不卖豆腐 阅读(371) 评论(0) 推荐(0)
AR 金额计算
摘要：应收开票金额： SELECT SUM(RCL.EXTENDED_AMOUNT * NVL(RCT.EXCHANGE_RATE, 1)) FROM RA_CUSTOMER_TRX_ALL RCT, RA_CUSTOMER_TRX_LINES_ALL RCL, RA_CUST_TRX_LINE_GL_DIST_ALL GD, RA_CUST_TRX_TYPES_ALL CTT WHERE 1 = 1 AND RCT.CUSTOMER_TRX_ID = GD.CUSTOMER_TRX_ID AND 'RE... 阅读全文
posted @ 2012-12-14 21:10 我不卖豆腐 阅读(1979) 评论(0) 推荐(0)
AR/AP - 借项通知单和贷项通知单的区别
摘要：ARCredit Memo 贷项通知单，减应收，冲原始发票 实际使用情况：客户退货，自己公司就需要开Credit Memo减小应收Debit Memo 借项通知单，独立的发票，加应收APCredit Memo 贷项通知单，指供应商开给我们的表示应付减少的通知，负数，冲原始发票，可用0支付结清 实际使用情况：由于货物质量问题，供应商主动折扣，而开出给你的红字发票，减小应付金额Debit Memo 借项通知单，指我们自己开出的表示应付减少的通知，同样是负数，冲原始发票，可用0支付结清 实际使用情况：由于货物质量问题，我司要求供应商折扣，开给供应商的红字发票，减小应付金额例子：Debit (借记，借 阅读全文
posted @ 2012-12-14 20:31 我不卖豆腐 阅读(3070) 评论(0) 推荐(0)
AR Adjustment
摘要：1.设置对应的Activity Name 路径:AR SETUP USER->Setup->RECEIPT->Receivable Activities2.设置对对应的approve limits 路径:AR SETUP USER->setup->transactions->Accounting Rules具体参考Oracle ReceivablesImplementation Guide (4-1)Select * from AR_RECEIVABLES_TRX WHERETYPE='ADJUST'AND SET_OF_BOOKS_ID=& 阅读全文
posted @ 2012-10-29 17:41 我不卖豆腐 阅读(1007) 评论(0) 推荐(0)
收款 借贷
摘要：SELECT (SELECT NAME FROM hr_operating_units WHERE organization_id = rc.org_id) OU_NAME, rc.trx_number invoice_number, cr.receipt_number, cr.receipt_date, (SELECT NAME FROM apps.RA_CUST_TRX_TYPES_ALL WHERE CUST_TRX_TYPE_ID = rc.CUST_TRX_TYPE_I... 阅读全文
posted @ 2012-05-29 18:09 我不卖豆腐 阅读(417) 评论(0) 推荐(0)
应收发票相关脚本
摘要：--应收发票主表SELECT * FROM RA_CUSTOMER_TRX_ALL A WHERE A.TRX_NUMBER = '156640' AND A.ORG_ID = 236;--应收发票行表SELECT B.EXTENDED_AMOUNT --不含税原币金额 ,B.EXTENDED_ACCTD_AMOUNT --不含税本币金额 ,B.GROSS_UNIT_SELLING_PRICE -- 含税单价 ,B.GROSS_EXTENDED_AMOUNT --含税金额 ,B.REVENUE_AMOUNT --收入金额 ,B.UNIT_... 阅读全文
posted @ 2012-05-29 17:58 我不卖豆腐 阅读(1168) 评论(0) 推荐(0)
关于ra_customer_trx_lines_all 应收发票行
摘要：AR中发票资料中看科目组合信息：SELECT * FROM ar.ra_customer_trx_all rct, ar.ra_customer_trx_lines_all rctl, ar.ra_cust_trx_line_gl_dist_all rctgl, apps.gl_code_combinations gcc -- 账户组合 WHERE rct.customer_trx_id = rctl.customer_trx_id AND rctl.customer_trx_line_id ... 阅读全文
posted @ 2012-04-10 18:02 我不卖豆腐 阅读(2324) 评论(0) 推荐(0)
应收帐款汇总
摘要：select customer_name, customer_number, extended_amount, description, price, quantity, salename, startdate, enddate from (select hpt.party_name customer_name, hca.account_number customer_number, decode(ctl.gross_extended_amo... 阅读全文
posted @ 2012-04-10 17:54 我不卖豆腐 阅读(491) 评论(0) 推荐(1)