Borrowings list - Borrowing tab

You can output a borrowings list in a Microsoft Excel file.  When you click the "Start" button after entering the condition, a confirm dialog will appear, allowing you to output the data in either an Excel file or a CSV file.
 → To Operation Procedure

Screen Transition

[Borrowings control module]
  ↓
[Forms]
  ↓
[Borrowings list]
  ↓
[Borrowings list] screen - [Borrowing] tab
[Borrowings list] screen - [Details] tab

Item Setup

[Main]

[Borrowings type]

• Borrowing type
  Select "Indenture," "Notes," "CP" or "Others."  The entry is optional. 
• Output option
  Select "Borrowings data" or "Repayment data." 

[Others]

• Short/Long-term
  Select "Short-term" borrowings or "Long-term" borrowings.  This item is optional. 
• Coupon payment
  Select the coupon payment method from "Prepaid" or "Pay after."  The default displays "Pay after."
• Currency
• Internal No.
• Borrowings No.
• Borrow from
  Set up the range of borrowing source.  Select the source from [Register correspondent] for "Actual correspondent" or "Financial Institution." 
• Borrowings Dept
  Enter the borrowing department.  You can make a reference from actual Dept and summary Dept. 
• Deposit Dept
• In charge
  Enter the person in charge of the borrowings. 
• Payer Financial Institution
  Enter the financial institution as recipient of the borrowings.
• Credit bank account
  Enter the bank account of the financial institution in which the borrowings are deposited. 
  You can make a reference from [Register bank account] containing the information about your own bank account. 
• Borrowings date
  Set up the range of borrowings date.  If you click the item without any data displayed, the system date is entered. 
• Receipt date
  Set up the range of receipt date.  If you click the item without any data displayed, the system date is entered. 
• Expiration date
  Set up the range of expiration date.  If you click the item without any data displayed, the system date is entered. 
• Contract date
  Set up the range of contract date.  If you click the item without any data displayed, the system date is entered. 

[Settle method]

• Settle method
  Enter the settlement method of the data as searching objects. 
• Own financial Inst
• Bank account

[Footer]

• Macro file, Macro
  When applying a macro in Microsoft Excel for output, specify the macro file and macro name.

[Buttons]

• Refer
• Clear
• Start
• Exit