ap
文章平均质量分 70
李逍遥L11
坑在人在
展开
-
供应商地点导入(API)Demo
--供应商:3G Communications, Inc.-- API to Create Supplier SiteDECLARE l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type; lc_return_status VARCHAR2(10); ln_msg_count NUMBER; lc_m原创 2014-05-15 16:18:16 · 1577 阅读 · 0 评论 -
供应商导入API Demo
-- API to Create Supplier --segment1:设置路径:AP超级用户->设置->选项->应付款系统设置:选择供应商编号为自动或者是手动--若为自动,则segment1由系统给出,若为手动,则以手动给字段为准。DECLARE l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type; l_return_statu原创 2014-06-12 16:41:22 · 811 阅读 · 0 评论 -
使用API失效供应商地址Demo
DECLARE lv_return_status VARCHAR2(1) := NULL; ln_msg_count NUMBER; lv_errmsg VARCHAR2(5000); lt_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_typ原创 2014-07-18 16:05:24 · 900 阅读 · 0 评论 -
供应商信息一览
SELECT s.org_id,a.vendor_name SUPPLIER_NAME, a.segment1 SUPPLIER_NUMBER, a.vendor_type_lookup_code SUPPLIER_TYPE, s.invoice_currency_code CURRENCY_CODE, s.vat_code TAX_RATE原创 2015-08-14 23:10:15 · 1138 阅读 · 0 评论 -
API创建银行-支行
DECLARE p_init_msg_list VARCHAR2(200); p_country_code VARCHAR2(200); p_bank_name VARCHAR2(200); p_bank_number VARCHAR2(200); p_alternate_bank_n原创 2015-03-26 14:00:41 · 987 阅读 · 0 评论 -
How To Configure Expense Report Numbers? 客户化费用报表编号
参考文档:文档 ID 365238.1根据文档显示,只需要在程序AP_WEB_OA_CUSTOM_PKG.GetNewExpenseReportInvoice 添加生成逻辑即可程序举例:FUNCTION GetNewExpenseReportInvoice(p_employeeId IN ap_expense_report_headers.employee_id%TYPE,原创 2015-08-20 16:17:45 · 845 阅读 · 0 评论 -
AP未结应付发票一览
--未结应付发票select hou.name as "业务实体", aia.cust_registration_number as "客户纳税人标识", cux_bq_common.get_lookup_meaning('INVOICE TYPE', aia.invoice_type_l原创 2016-11-29 11:58:13 · 1928 阅读 · 0 评论 -
AP应付票据信息一览
select cux_bq_common.get_lookup_meaning('PAYMENT TYPE', aca.payment_type_flag) as "类型", hou.name as "业务实体", decode(aca.party_id, '',原创 2016-11-29 11:59:49 · 1607 阅读 · 0 评论 -
AP收款导入相关步骤
1.ap_checks_pkg.insert_row2.ap_reconciliation_pkg.insert_payment_history3.ap_pay_invoice_pkg.ap_pay_invoice原创 2016-11-30 10:24:21 · 1476 阅读 · 0 评论