AP IExpense 杂记随笔



最近一直在做IExpense Support,顺便去整理一下标准的业务

1.Standard Business Process

      A) Credit Card Process

--Credit Card Form
   select * from ap_card_programs_all;
   select * from ap_cards_all;

   B) IEpense Report Process

--

  --Credit Card transaction (信用卡事务处理表)

   select * from ap_credit_card_trxns_all;

 (一般通过客制化程序将银行业务导入此表)

 --IExpense Report常用表
   select * from ap_expense_report_headers_all;
   select * from ap_expense_report_lines_all;
   select * from ap_exp_report_dists_all;--Submit之后会产生分配表

--Expense Item type and report template

   select * from ap_expense_report_params_all;（Item类别）

   select * from ap_expense_reports_all;(模板)

--import to invoice(export invocie to ap)
select * from ap_invoices_interface;
select * from ap_invoice_lines_interface;

--Concurrent Program:

Name:Expense Report Export

Package:AP_WEB_EXPORT_ER

 --Workflow

     Expense->apwxwkfl.wft



2） Function Business Process

Expense Report->|T&E Expense- > Audit->Import

                             |Amex Expense->Credit Credit Credit  Transaction->Audit->Import to AP 

Amex Expense(这部分标准功能是不存在的，但是用户可以手工计算录入不同类别的Line)

看到有部分客户在这里做了客户化，自动计算生存Personal and Exchange Rounding

1.Personal (客户化)

   A)Credit Card Transaction Type=Persona ,在ap_expense_report_line产生-amount行记录

   B)Credit Card Transaction total amount用户没有 Itemzite拆分完的部分，再report上会显示Business Personal,实际未产生任何记录。在导入AP Invoice时候会产生负数clear Account Line.

2.Exchange Rounding（客户化）

   A)对于外汇部分产生的小数差异，自动产生一行Exchange Rounding 行。