4 Assignment Enquiry 2. Assignment Enquiry E-factoring is a financial transaction whereby a business sells its invoices to a third party called a factor at a discount in exchange for immediate money to finance business. This option allows a corporate user to make an enquiry on the assignments done in e - factoring. To Assignment Enquiry: Navigate through E-Factoring > Assignment Enquiry. Assignment Enquiry Field Entity Primary Customer Id This field displays the entity that you are using. This field displays the primary customer id mapped to you.

5 Assignment Enquiry Primary Customer Name Buyer Name Outstanding > 0 All Finance Period From Finance Period To This field displays the primary customer name. [Mandatory, Drop-Down] Select the buyer's name linked to the seller from the drop-down list. Note: The drop-down lists the buyer name linked to the primary customer ID (seller). Buyer may or may not be a bank customer. [Optional, Radio Button] Click Outstanding >0 to search the assignments having outstanding amount greater than zero. [Optional, Radio Button] Click the All to search all the assignments. Note: If Enquiry Type All is selected, Finance Period From and Finance Period To fields are enabled. [Conditional, Picklist] Select the date from the pick list. This is the date on which the seller presents the invoice to the bank for processing the loan. This field is enabled if the All radio button is selected. [Conditional, Picklist] Select the date from the Picklist. This is the date for searching the results within the specified criteria. The date selected here should be greater than the date selected in Finance Period From field. This field is enabled if the All radio button is selected. 1. Type the relevant details. 2. Click the Search button. The system displays Assignment Enquiry screen with the search results. Assignment Enquiry 6

6 Assignment Enquiry Field Assignment Date Batch Number Product Type Finance Mode Total Invoice Invoice Outstanding Outstanding Loan Available Finance Amount This field displays the date on which the batch is received by the bank from the seller. This field displays the batch number provided by the bank for the invoices presented by the seller to the bank. This field displays the E-Factoring product under which the batch is booked. This field displays the funding mode. This field displays the total invoice amount in local currency. This field displays the outstanding amount (in local currency) from the buyer. This field displays the total of all loan amounts in local currency. This field displays the outstanding loan amount and available finance amount based on the batch and product. 3. Click the Batch Number hyperlink. The system displays Assignment Inquiry Invoice Details screen. Assignment Enquiry Invoice Details 7

7 Assignment Enquiry Field Invoice Due Date Invoice Number Product Type Buyer Name Invoice Date Invoice Amount Currency Outstanding Amount Currency Outstanding Loan Currency Available Finance Amount Currency Invoice Amount Local Currency Outstanding Amount Local Currency This field displays the due date for invoice. This field displays the number on invoice. This field displays the type of the product. This filed displays the name of the buyer. This field displays the date of invoice. This field displays the invoice outstanding amount in invoice currency. This field displays the invoice amount in local currency. This field displays total outstanding loan. This field displays the total available finance amount. This field displays the invoice amount in local currency. This field displays total outstanding loan in local currency. 8

8 Assignment Enquiry Outstanding Loan Currency Available Finance Amount Local Currency This field displays total outstanding loan. This field displays the total available finance amount. 4. To download the complete statement, click the Download button. The system displays the Assignment Inquiry dialog screen. 5. Click the reorder button to reorder the columns or select the columns that appear in the list. 6. Click the Print button to print the data. 7. Click on Edit button column to edit the number of columns. Download Assignment Inquiry Field Download Type [Mandatory, Drop-Down] Select the appropriate report type from the drop-down list. The available choices are: Page Layout 9

9 Assignment Enquiry File Format Included [Conditional, Drop-Down] Select the appropriate type of file format from the drop-down list. The options available are PDF XLS HTML RTF This box lists all the fields that will be included in the report. Excluded This box lists all the fields that will be excluded from the report. 8. Select the fields that are to be excluded from the Included box and click the button. The Excluded box appears on the left-side of the dialog box. 9. Select the fields that are to be included from the Excluded box and click the button. The Included box appears on the right-side of the dialog box. All the fields are, by default, selected and included. 10. Select the appropriate report type, format, and fields from the Download Deal details and click the Download button. The system displays the File Download message box. File Download 11. Click the Save button to save the file on your file system. The system displays the Save As dialog box. 10

10 Assignment Enquiry 12. Enter the name for the file and the location and click on the Save button. Once the download is complete, the system displays the Download complete message box. Download Complete 13. Click the Open button to open the file or click the Close button to view the file later. OR Click the Open Folder button to open the folder in which the file is saved OR Click the Close button to close the Download dialog box

11 Credit Limit Inquiry 3. Credit Limit Enquiry This option allows a corporate user to make an enquiry on the credit limit. To Credit Limit Enquiry: Navigate through E-Factoring > Credit Limit Enquiry Credit Limit Enquiry Field Entity Primary Customer Id Primary Customer Name This field displays the entity that you are using. This field displays the primary customer id mapped to you. This field displays the primary customer name. 12

12 Credit Limit Inquiry Buyer Name [Mandatory, Drop-Down] Select the buyer's name linked to the seller from the drop-down list. Note: The drop-down lists the buyer name linked to the primary customer ID (seller). Buyer may or may not be a BANK customer. 1. Select the buyer's name from drop-down list. 2. Click the Search button. The system displays Credit Limit Enquiry screen with the search results. Credit Limit Enquiry Column Column Name Facility Number Buyer Name Approval Date Expiry Date Status Product Type This field displays the facility number of the limits. This field displays the name of the buyer. This field displays the approval date of the limit. This field displays the expiry date of the limit. This field displays the status of the limit. This field displays the product type. 13

13 Credit Limit Inquiry Column Name Credit Limit Currency Credit Limit Amount Assigned Amount Finance Limit Currency Finance Limit Amount Financed Amount This field displays the currency of the limit. This field displays the limit amount in credit limit currency. This field displays the amount assigned under the facility in credit limit currency. This field displays the financing limit currency. This field displays financing limit in currency. This field displays the financed amount. Note: To filter the data with particular criteria, click the column heading to sort the records in the ascending or descending order. For example: Click the Expiry Date column heading to sort the records in the ascending/descending order of the dates. 3. Click the Print button to take out the print OR Click the Download button to download the information in the desired format. Credit Limit Enquiry 14

14 Credit Limit Inquiry 4. Select file format of the document to be downloaded and click the Download button. It shows File Download screen. 5. Click the Open to open the file or click the Save to download and save. The file will get saved at the location specified

15 Financing Enquiry 4. Financing Enquiry This option allows a corporate user to make financing enquiry. To Financing Enquiry: Navigate through E-Factoring > Financing Enquiry. Financing Enquiry Field Entity Primary Customer Id This field displays the entity that you are using. This field displays the primary customer id mapped to you.

16 Financing Enquiry Primary Customer Name Outstanding Financing Date From Financing Date To This field displays the primary customer name. [Optional, Radio Button] Select the outstanding options to search the assignments. The option are as follows: 0: If this radio button is selected, the assignment having outstanding amount greater than zero are displayed. All: If this radio button is selected, all the assignment are displayed. [Conditional, Drop-Down] Select the date on which the seller presents the invoice to the bank for processing the loan from the drop-down list. This field is enabled if the All radio button is selected as search criteria. [Conditional, Drop-Down] Select the date range for searching the results within the specified criteria, from the drop-down list. The date should be greater than the date selected in Finance Period From field. This field is enabled if the All radio button is selected as search criteria. 1. Enter the relevant details. 2. Click the Search button. The system displays Financing Enquiry screen with the search results. Financing Enquiry Field 17

17 Financing Enquiry Financing Date Loan Reference Number Product Type Funding Mode Financing Currency Financing Amount Outstanding Loan This field displays the date of financing. This field displays the system-generated reference number of the loan. This field displays the E-Factoring product under which the loan is booked. This field displays one of the bank's three modes of financing. This field displays the currency of the loan. This field displays the amount of the loan. This field displays the outstanding loan amount. 3. Click the Loan Reference Number hyperlink. The system displays Financing Inquiry Loan Details screen. Financial Enquiry Loan Details Field Invoice Due Date This field displays the due date for invoice. 18

18 Financing Enquiry Invoice Number Buyer Name Invoice Date Invoice Amount currency Outstanding Amount currency Finance Amount (Loan CCY) Outstanding Loan Currency Available Finance Amount currency This field displays the number on invoice. This filed displays the name of the buyer. This field displays the date of invoice. This field displays the invoice outstanding amount in invoice currency. This field displays the outstanding invoice amount in local currency. This field displays the total outstanding loan. This field displays the outstanding loan currency. This field displays the total available finance amount. Not i2i. 4. Click the Print button to get the print output or Download button to download. It shows download screen. 5. Select file format of the document to be downloaded and click the Download button. It shows File Download screen. 19

19 Financing Enquiry 6. Click the Open button to open the file or click the Save to download and save. The file will get saved at the location specified

20 Invoice Enquiry 5. Invoice Enquiry This option allows a corporate user to make an enquiry on the invoices. To Invoice Enquiry: Navigate through E-Factoring > Invoice Enquiry. Invoice Enquiry Field Entity Primary Customer Id This field displays the entity that you are using. This field displays the primary customer id mapped to you.

21 Invoice Enquiry Primary Customer Name Buyer Name Invoice Number From Invoice Number To Finance Period From Finance Period To Overdue Period From This field displays the primary customer name. [Mandatory, Drop-Down] Select the buyer's name linked to the seller from the drop-down list. Note: The drop-down lists the buyer name linked to the primary customer ID (seller). [Optional, Alphanumeric, 30] Type the invoice number to make the search based on the invoice number. This is the invoice number range for searching the results within the specified criteria. The default value is BLANK (means ALL). [Optional, Alphanumeric, 30] Type the invoice number to make the search based on the invoice number. This is the invoice number range for searching the results within the specified criteria. The default value is BLANK (means ALL). [Optional, Picklist] Select the date from the Picklist. This is the date range for searching the results within the specified criteria. [Optional,Picklist] Select the date from the picklist. This is the date range for searching the results within the specified criteria. Note: The date selected here should be greater than the date selected in Finance Period From field. [Mandatory, Numeric, Two] Type the overdue period date to make the search based on the overdue period. E.g.: If any number (say 7) is entered, then the system displays all the invoices overdue by more than 7 days. 22

22 Invoice Enquiry Overdue Period To [Mandatory, Numeric, Two] Type the overdue period date to make the search based on the overdue period. E.g.: If any number (say 7) is entered, then the system displays all the invoices overdue by less than 7 days. If the number is 0, it means the invoice is not overdue. Note: The date entered here should be greater than the date entered in the Overdue Period From field. 1. Type the relevant details. 2. Click the Search button. The system displays Invoice Enquiry screen with the search results. Invoice Enquiry Field Invoice Date Invoice Number Buyer Name Product Type This field displays the invoice date. This field displays the invoice number. This field displays the buyer name. This field displays the product type. 23

23 Invoice Enquiry Invoice Due Date Invoice Amount Outstanding Amount Outstanding Loan Overdue Days Dispute Amount Credit Note Amount Chargeback Amount Discrepancy This field displays the invoice due date. This field displays the invoice amount in invoice currency. This field displays the outstanding invoice amount in invoice currency. This field displays the outstanding loan amount against the Invoice in loan currency. This field displays the days overdue. This field displays the dispute amount in the invoice currency. This field displays the credit note amount in invoice currency. This field displays the charge back amount in invoice currency. This field displays if there is any discrepancy - Yes/No. 3. Click the Download button to download the information in the desired format OR Click the Print button to take the print out. 24

24 Invoice Enquiry 4. Select file format of the file to be downloaded and click the Download button. The system displays File Download screen. 5. Click the Open to open the file or click the Save to download and save. The file will get saved at the location specified

25 Repayment Enquiry 6. Repayment Enquiry This option allows a corporate user to make an enquiry on the repayment. To Repayment Enquiry: Navigate through E-Factoring > Repayment Enquiry Repayment Enquiry Field Entity Primary Customer Id Primary Customer Name This field displays the entity of the application. This field displays the primary customer id mapped tp your user id. This field displays the primary customer name.

26 Repayment Enquiry Buyer Name Finance Period From Finance Period To [Mandatory, Drop-Down] Select the buyer's name linked to the seller from the drop-down list. The drop down lists the buyer name linked to the primary customer ID (seller). [Optional, Pick List] Select the start date of the finance period from the pick list. This is the date on which the seller presents the invoice to the bank for processing the loan. [Optional, Pick List] Select the end date of the finance period from the pick list. Note: This is the date range for searching the results within the specified criteria. Financed Period To should be greater than Financed Period From. 1. Type the relevant details. 2. Click the Search button. The system displays Repayment Enquiry screen with the search results. Repayment Enquiry Field Repayment Date This field displays the date on which repayment is done. 27

27 Repayment Enquiry Receipt Reference Number Product Type Receipt Amount Payout To Client Loan Reference Number Foreign Exchange Rate Financing Amount Repay of Principal Amount Interest Repayment Amount This field displays the system-generated reference number of the repayment. Link is provided to view the repayment details receipt details. This field displays the type of factoring product. This field displays the amount paid by the buyer or seller. Most would be in invoice currency. This field displays any balance amount (after deducting the loan amount) paid to the seller's CASA account in receipt currency. This field displays the financing reference number. This field displays the foreign exchange rate. This field displays the total amount financed under the displayed receipt reference number in loan currency under the financing reference number. This field displays the total amount paid as principal in loan currency. This field displays the total amount paid as interest in loan currency. 3. Click the Receipt Reference Number hyperlink or Loan Reference number hyperlink. The system displays Repayment Enquiry Receipt Details screen. Repayment Enquiry Receipt Details 28

28 Repayment Enquiry 4. Click the Back button to navigate to the previous screen. 5. To download the complete statement, click the Download button. The system displays the Repayment Inquiry dialog screen. 6. Click the reorder button to reorder the columns or select the columns that appear in the list. 7. Click the Print button to print the data. 8. Click on Edit button column to edit the number of columns. Download Repayment Inquiry Field Download Type File Format [Mandatory, Drop-Down] Select the appropriate report type from the drop-down list. The available choices are: Page Layout [Conditional, Drop-Down] Select the appropriate type of file format from the drop-down list. The options available are PDF XLS HTML RTF 29

29 Repayment Enquiry Included This box lists all the fields that will be included in the report. Excluded This box lists all the fields that will be excluded from the report. 9. Select the fields that are to be excluded from the Included box and click the button. The Excluded box appears on the left-side of the dialog box. 10. Select the fields that are to be included from the Excluded box and click the button. The Included box appears on the right-side of the dialog box. All the fields are, by default, selected and included. 11. Select the appropriate report type, format, and fields from the Download Deal details and click the Download button. The system displays the File Download message box. File Download 12. Click the Save button to save the file on your file system. The system displays the Save As dialog box. 13. Enter the name for the file and the location and click on the Save button. Once the download is complete, the system displays the Download complete message box. Download Complete 30

30 Repayment Enquiry 14. Click the Open button to open the file or click the Close button to view the file later. OR Click the Open Folder button to open the folder in which the file is saved OR Click the Close button to close the Download dialog box. 31

31 Oracle FLEXCUBE Direct Banking Corporate E-Factoring User Manual May 2012 Version Number: Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA U.S.A. Worldwide Inquiries: Phone: Fax: oracle.com Copyright 2012 Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

An Oracle White Paper July 2013 Introducing the Oracle Home User Introduction Starting with Oracle Database 12c Release 1 (12.1), Oracle Database on Microsoft Windows supports the use of an Oracle Home

An Oracle White Paper February 2013 Integration with Oracle Fusion Financials Cloud Service Executive Overview Cloud computing is a vision that is increasingly turning to reality for many companies. Enterprises,

An Oracle White Paper November 2010 Oracle Business Intelligence Standard Edition One 11g Introduction Oracle Business Intelligence Standard Edition One is a complete, integrated BI system designed for

An Oracle White Paper May 2013 Creating Custom PDF Reports with Oracle Application Express and the APEX Listener Disclaimer The following is intended to outline our general product direction. It is intended

An Oracle Communications White Paper December 2014 Serialized Asset Lifecycle Management and Property Accountability Disclaimer The following is intended to outline our general product direction. It is

An Oracle White Paper Jan 2010 Mobile Technology for Wealth Management Advisors Disclaimer The following is intended to outline our general product direction. It is intended for information purposes only,

Oracle Easy Connect Naming An Oracle White Paper October 2007 NOTE: The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated

An Oracle White Paper October 2011 BI Publisher 11g Scheduling & Apache ActiveMQ as JMS Provider Disclaimer The following is intended to outline our general product direction. It is intended for information

User Experience Direct (UX Direct) FAQ: How to create Effective Messages Disclaimer The following is intended to outline our general product direction. It is intended for information purposes only, and

An Oracle White Paper April 2013 Reporting Tools in Oracle Fusion Financials Executive Overview We are living in an Information Age, where the success of an organization depends largely on how effectively

An Oracle White Paper July 2009 Oracle Application Development Tools Statement of Direction: Oracle Forms, Oracle Reports and Oracle Designer Disclaimer The following is intended to outline our general

An Oracle White Paper June 2011 OpenLDAP Oracle Enterprise Gateway Integration Guide 1 / 29 Disclaimer The following is intended to outline our general product direction. It is intended for information

An Oracle Technical White Paper November 2014 How to Use Microsoft Active Directory as an LDAP Source with the Oracle ZFS Storage Appliance Table of Contents Introduction...3 Active Directory LDAP Services...4

An Oracle White Paper December 2013 Advanced Network Compression Disclaimer The following is intended to outline our general product direction. It is intended for information purposes only, and may not

An Oracle White Paper October 2013 Oracle Database and IPv6 Statement of Direction Disclaimer The following is intended to outline our general product direction. It is intended for information purposes

Monitoring and Diagnosing Production Applications Using Oracle Application Diagnostics for Java An Oracle White Paper December 2007 Monitoring and Diagnosing Production Applications Using Oracle Application

SIX QUESTIONS TO ASK ANY VENDOR BEFORE SIGNING A SaaS E-COMMERCE CONTRACT When evaluating software-as-aservice, particularly e-commerce SaaS solutions, companies often focus on comparing product features

PRODUCT HUB Centralize product data across heterogeneous systems to create a blended product master record that is clean, standardized, accurate, and current. Harmonize it across business processes and

Oracle Primavera Gateway Disclaimer The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is

New 11g Features in Oracle Developer Tools for Visual Studio An Oracle White Paper January 2008 New 11g Features in Oracle Developer Tools for Visual Studio Introduction... 3 Integration with Visual Studio

P6 Analytics: Weather Feed in OBIEE Disclaimer The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract.

October 2015 Oracle Application Express Statement of Direction Disclaimer This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle.

Next Generation Siebel Monitoring: A Real World Customer Experience An Oracle White Paper June 2010 Next Generation Siebel Monitoring: A Real World Customer Experience Table of Contents Introduction...

Trade Finance User Guide Westpac Banking Corporation 2008 This document is copyright protected. Apart from any fair dealing for the purpose of private study, research criticism or review as permitted under

An Oracle White Paper March 2010 Oracle Transparent Data Encryption for SAP Introduction Securing sensitive customer data has become more and more important in the last years. One possible threat is confidential

SELF SERVICE PROCUREMENT Oracle Fusion Self Service Procurement streamlines the purchase requisitioning process using a consumer centric approach and helps control the employee spending by enforcing the

March 2014 Oracle Business Intelligence Discoverer Statement of Direction Oracle Statement of Direction Oracle Business Intelligence Discoverer Disclaimer This document in any form, software or printed

An Oracle White Paper February 2014 Oracle Data Integrator 12c Introduction Oracle Data Integrator (ODI) 12c is built on several components all working together around a centralized metadata repository.