Payment Management Tool Manual [Attachment]

How do I use email Link Type?

Click [E-mail Link Type] from the side menu to display the e-mail Link Type processing selection screen.
* When logging in with a representative account, the email Link Type link in the side menu will be hidden. When using it, please specify the service on the service selection screen when logging in.
This function is also available in the light version.

Email Link Type Action Selection

Mail Link Type Action Selection Screen

You can create email Link Type billing requests, create Full payment by uploading files, and search history.
Click [E-mail Link Type] from the side menu to display the e-mail Link Type processing selection screen.

Email Link Type Sign up

You can register an invoice request and the invoice will be sent or issued depending on the delivery method you selected.

Email Link Type Billing Request Registration Screen

This screen is for entering billing request sending settings and billing information.

Registration item list/transmission settings

Field name		Type and length	Meaning
Customer's first name		64 byte Character string (For SMS: 8 characters)	This is a customer name that can be set by merchants. (For SMS, it must be 8 characters or less.) *This is a required field.
Customer ID		Half-width alphanumeric characters 64 bytes	This is a customer managed number that can be set up by merchants. (Only _ and - symbols can be used) *This is a required field.
Date selection	Date sent	–	The date on which the invoice information should be sent. Currently, there is only "Send now" option.
	Due date of payment	Single-byte numbers 8 bytes	The due date for payment of the invoice. Payment can be made up until 23:59:59 on the specified date. Dates within 90 days of registration are accepted, but dates in the past are not accepted. *This is a required field. *Please enter in yyyymmdd format.
How to send		–	You can specify the sending method. You can choose between Email, SMS and QR bill. *This is a required field.
Email	Destination e-mail address	Half-width alphanumeric characters 256 digits	The destination email address. (Symbols other than "@", ".", "_", and "-" and spaces cannot be used.) *This is a required field if you select email as the sending method.
	Source e-mail address	Half-width alphanumeric characters 256 digits	The sender's email address. (Symbols other than "@", ".", "_", and "-" and spaces cannot be used.) *This is a required field if you select email as the sending method.
SMS	Destination telephone number	Single-byte numbers 10 to 12 digits	The phone number to send the SMS to. (Please enter without the hyphen "-") *This is a required field if you select SMS as the sending method.
	SMS Display Service Name	Character string 12 characters	The name of the service that will be displayed in the SMS sent. (By default, the first 12 characters of the service name of the Admin portal / Payment management tool account you are logged in to are displayed.) *This is a required field if you select SMS as the sending method.

Registration item list and billing information

Field name		Type and length	Meaning
Payment method		–	You can specify payment methods. Currently, only "Credit Card Payment" is available.
Invoice number		Half-width alphanumeric characters 36 bytes	This is an invoice number that can be set by merchants. You can also set an automatically calculated number (36 bytes) by pressing the "Automatic numbering" button. (Only _ and - symbols can be used) Please set a Unique invoice number. You cannot set an invoice number that has been registered in the past. *This is a required field.
Product ID		Half-width alphanumeric characters 32 bytes	This is a Item number that can be set by merchants. (Only _ and - symbols can be used) *This is a required field.
Item name		Character string 40 bytes	product name that can be configured in merchants.
Charge amount (tax included)		Single-byte numbers 8 digits	This is the billing amount (including tax) that can be set by merchants. *This is a required field.
Tax amount charged		Single-byte numbers 8 digits	The amount of tax that can be charged in merchants.
Display details		–	You can set up billing details. If unchecked, no details will be set.
Item and item amount (*)	Item	40 byte Character string	product name that can be configured in merchants.
	quantity	Half-width 3-digit number	The Item quantity that can be set by merchants.
	Itemized amount (including tax)	Half-width 8-digit number	This is the billing amount (including tax) that can be set by merchants.
	Amount of tax for detailed description	Half-width 8-digit number	This is the amount of tax that can be set by merchants.

* Up to five Item and detailed amounts can be registered.

Email Link Type Message Editing Screen (Email)

This is the screen where you can add any message to the billing request email. The message entered here will also be displayed on the "billing details confirmation screen" that is displayed at the time of payment.

Message editing items list

Field name	Type and length	Meaning
Free column	Character string 150 columns	You can add an additional message.

Email Link Type confirmation screen (email)

This is the screen to confirm the billing request to be sent. Press the "Send" button to send the billing request to the destination email address.

Email Link Type Message Editing Screen (SMS)

This screen allows you to add an arbitrary message to the "Billing Details Confirmation Screen" that is displayed when making a payment.

Message editing items list

Field name	Type and length	Meaning
Free column	Character string 150 columns	You can add an additional message.

Email Link Type Confirmation Screen (SMS)

This is the screen where you can confirm the billing request you are sending.
Click the "Send" button to send the billing request to the destination phone number.

Email Link Type completion screen (email, SMS)

This screen confirms that the billing request has been sent. The automatically generated sending number is displayed.

Email Link Type Message Edit Screen (QR Invoice)

This is the screen where you can add any message to the QR bill. The message entered here will also be displayed on the "Billing Details Confirmation Screen" that is displayed when making payment.

Message editing items list

Field name	Type and length	Meaning
Free column	Character string 150 columns	You can add an additional message.

Email Link Type confirmation screen (QR invoice)

This is the screen where you can confirm the QR bill to be issued.
Click the "Proceed to view QR bill" button to register the billing request.

Email Link Type completion screen (QR invoice)

This screen confirms that your billing request has been registered. The automatically generated sending number is displayed.
You can display the QR bill screen by pressing the "Display QR bill" button.

Email Link Type QR invoice screen (QR invoice)

This is the screen where the QR bill is displayed. End users can accept payments by scanning the displayed QR code.

Mail Link Type File Full payment Processing

You can send Full payment billing requests via a CSV file.

Email Link Type Submit Billing Request (File Upload)

This is the screen for selecting the CSV file to upload.
*A maximum of 1,000 billing requests can be registered in one file.

Email Link Type File Upload Confirmation

This is the screen to confirm the CSV file to be uploaded. Please check the number of registered items from the history search.

[Please note] If there are duplicate invoice numbers for multiple invoice requests within the same file, the first invoice request with that invoice number will be registered, and the second and subsequent invoice request registrations will be skipped.
Skipped billing requests are not reflected in the email Link Type history because the billing request has not been created. Please create a file so that the invoice number is not duplicated.

When a format error occurs

Email Link Type File upload completed

This screen will confirm that your invoice has been sent.
For QR bills, this indicates that the billing request registration has been completed. The QR bills for registered billing requests can be viewed from the history confirmation results.

Email Link Type history search

Email Link Type history search screen

This screen allows you to search and view registered billing requests, and cancel (void) Payment billing requests.
For Payment requests that have been settled, you can check the status of Payment associated with the billing request by clicking the transmission number link.
You can also download the history search results in a CSV file.

Search item list

Field name	Meaning
Payment method	You can narrow down your search by payment method. You can choose from email, SMS and QR bill.
Payment method	You can filter by payment methods. Currently, only Credit Card Payment can be selected.
How to register a billing request	You can narrow down your search by the method of registration of the billing request. You can choose from Admin portal / Payment management tool, file upload and API.
Billing request registration date	You can narrow down your search by the registration date of the billing request. The input format is yyyymmdd.
Date sent	You can narrow down the results by the date the billing request was sent. *For QR bills, please enter the date of billing request registration. The input format is yyyymmdd.
Due date of payment	You can filter by the payment due date of the billing request. The input format is yyyymmdd.
Sending number	You can narrow down your search by sending number.
Customer ID	You can filter by customer ID.
Destination e-mail address	You can narrow down the search by recipient email address.
Destination telephone number	You can narrow down your search by recipient phone number.
Invoice number	You can narrow down your search by invoice number.
Product ID	You can narrow down your search by Item ID.

E-mail Link Type History search results list screen

The registered billing requests that meet the specified criteria are listed by transmission number.
The displayed items vary depending on the sending method.

Display Item List

Send via: Email

Field name		Meaning
Service Name		This is the name of the merchants registered to SBPS.
How to send		The method for sending the billing request.
Payment method		This is Payment method you specified when requesting payment.
Sending number		This is the transmission number assigned by SBPS.
詳 ​	Merchant ID	This is the base control number of the merchants numbered by SBPS.
	Service ID	This is the extended control number of the merchants that is numbered by SBPS.
	Invoice number	This is an invoice number that can be set by merchants.
	Billing amount	Charges that can be set by merchants.
	Customer ID	This is a customer managed number that can be set up by merchants.
	Product ID	This is a Item number that can be set by merchants.
	Item name	This is a product name that can be set by merchants.
	Destination e-mail address	The destination email address.
	Date and time of sending	The date and time when the billing request was sent.
	How to register a billing request	The method by which the billing request was registered.
	Billing request registration date	The date and time when the billing request was registered.
ス テ ー タ ス	Send	The status of the billing request. Unsent: Not sent Sent: Sent status Transmission error: Transmission failed *When you request a URL via API connection, "Not sent, sending error: not issued" The status will be "Sent: Issued".
	Payment	The status of Payment. Payment: Payment has not been settled. Payment: Payment status Payment error: Payment has failed. Cancellation: The claim has been cancelled

Sending method: SMS

Field name		Meaning
Service Name		This is the name of the merchants registered to SBPS.
How to send		The method for sending the billing request.
Payment method		This is Payment method you specified when requesting payment.
Sending number		This is the transmission number assigned by SBPS.
詳 ​	Merchant ID	This is the base control number of the merchants numbered by SBPS.
	Service ID	This is the extended control number of the merchants that is numbered by SBPS.
	Invoice number	This is an invoice number that can be set by merchants.
	Billing amount	Charges that can be set by merchants.
	Customer ID	This is a customer managed number that can be set up by merchants.
	Product ID	This is a Item number that can be set by merchants.
	Item name	This is a product name that can be set by merchants.
	Destination telephone number	The recipient's phone number.
	Date and time of sending	The date and time when the billing request was sent.
	How to register a billing request	The method by which the billing request was registered.
	Billing request registration date	The date and time when the billing request was registered.
ス テ ー タ ス	Send	The status of the billing request. Unsent: Not sent Sent: Sent status Transmission error: Transmission failed *When you request a URL via API connection, "Not sent, sending error: not issued" The status will be "Sent: Issued".
	Payment	The status of Payment. Payment: Payment has not been settled. Payment: Payment status Payment error: Payment has failed. Cancellation: The claim has been cancelled

Sending method: QR bill

Field name		Meaning
Service Name		This is the name of the merchants registered to SBPS.
How to send		The method for sending the billing request.
Payment method		This is Payment method you specified when requesting payment.
Sending number		This is the transmission number assigned by SBPS.
詳 ​	Merchant ID	This is the base control number of the merchants numbered by SBPS.
	Service ID	This is the extended control number of the merchants that is numbered by SBPS.
	Invoice number	This is an invoice number that can be set by merchants.
	Billing amount	Charges that can be set by merchants.
	Customer ID	This is a customer managed number that can be set up by merchants.
	Product ID	This is a Item number that can be set by merchants.
	Item name	This is a product name that can be set by merchants.
	Issue date	The date and time when the billing request was issued.
	How to register a billing request	The method by which the billing request was registered.
	Billing request registration date	The date and time when the billing request was registered.
ス テ ー タ ス	Send	The status of the billing request. Unissued: Not issued Issued: Issued state
	Payment	The status of Payment. Payment: Payment has not been settled. Payment: Payment status Payment error: Payment has failed. Cancellation: The claim has been cancelled

Email Link Type URL Disable Full payment Processing Completion Screen

This screen allows you to check the results of Full payment process of invalidating URLs.
The number of processes, the number of successful completions, and the number of error completions are displayed as Processed result.

CSV format details

The detailed format of the CSV file used to submit a claim request via file upload is given below.

Email Link Type Submit Billing Request

Describe the format and items of the CSV file to be uploaded.

CSV Input

The individual formats are listed in the table below.

format	Description
file name	Not specified
Character Codes	Shift-JIS
Line feed code	CR+LF
Extension	csv, CSV
Header row presence/absence	None
EOF position	End of data line, beginning of next data line
Blank lines	None
Spaces around commas	None
Presence of line breaks other than data line separators	None
Enclose in double quotes	Yes
Delimiter	comma

The input items are listed in the table below.

Field name	Example Values	Type and length	Remarks
Merchant ID	12345	Half-width numbers Fixed length (5 digits)	Basic control number for merchants. *This is a required field.
Service ID	123	Half-width numbers Fixed length (3 digits)	Extended control number for merchants. *This is a required field.
Customer's first name	Taro Tanaka	Character string 64 bytes 8 characters (SMS)	This is a customer name that can be set by merchants. (For SMS, it must be 8 characters or less.) *This is a required field.
Customer ID	CUSTCODE123456	Half-width alphanumeric characters 64 bytes	This is a customer managed number that can be set up by merchants. (Only _ and - symbols can be used) *This is a required field.
Due date of payment	20180131	Single-byte numbers Fixed length (8 digits)	The due date for payment of the invoice. Payment can be made up until 23:59:59 on the specified date. It must be within 90 days of the registration date, but it cannot be a date in the past. *This is a required field. *Please enter in yyyymmdd format.
How to send	1	Single-byte numbers Fixed length (1 digit)	You can specify the sending method. 1: Email 2. SMS 3: QR bill *This is a required field.
Destination email address Email	sample1@sample.co.jp	Single-byte characters 256 digits	The destination email address. (Symbols other than "@", ".", "_", and "-" and spaces cannot be used.) *This is a required field if you select email as the sending method.
Sender email address Email	sample1@sample.co.jp	Single-byte characters 256 digits	The sender's email address. (Symbols other than "@", ".", "_", and "-" and spaces cannot be used.) *This is a required field if you select email as the sending method.
Destination telephone number (SMS)	07011112222	Single-byte numbers 10~12 digits	The phone number to send the SMS to. *This is a required field if you select SMS as the sending method.
Payment method	credit	Single-byte characters	You can specify payment methods. "credit" is Credit Card Payment. *This is a required field.
Invoice number	ORDER00001	Half-width alphanumeric characters 36 bytes	This is an invoice number that can be set by merchants. (Only _ and - symbols can be used) Please set a Unique invoice number. You cannot set an invoice number that has been registered in the past. *This is a required field.
Product ID	ITM0001	Half-width alphanumeric characters 32 bytes	This is a Item number that can be set by merchants. (Only _ and - symbols can be used) *This is a required field.
Item name	Item 0001	Character string 40 bytes	product name that can be configured in merchants.
Billing amount	999999	Single-byte numbers 8 digits	This is the billing amount (including tax) that can be set by merchants. *This is a required field.
Amount of tax	9999	Single-byte numbers 8 digits	The amount of tax that can be charged in merchants.
Display service name (SMS)	SERVICENAME	Character string 1 to 12 characters	The name of the service that will be displayed in the SMS sent. *This is a required field if you select SMS as the sending method.
Reply Address	reply@test.jp	Single-byte characters 1 to 256 digits	The email address to reply to.
product name A	Item A0001	Character string 40 bytes	・If you enter any of product name, quantities, detailed amounts, or detailed tax amounts (A to E), product name, quantity, and detailed amount using the same alphabet are required fields. ・If you enter any of the detailed tax amounts A to E, All detailed tax amounts A to E are required fields. (Excluding items where no values are entered for product name, quantity, itemized amount, or tax amount)	product name that can be configured in merchants.
Quantity A	100	Single-byte numbers 3 digits		The Item quantity that can be set by merchants.
Detail Amount A	100000	Single-byte numbers 8 digits		This is the billing amount (including tax) that can be set by merchants.
Detail tax amount A	1000	Single-byte numbers 8 digits		This is the item tax amount that can be set in merchants.
product name B	Item B0002	Character string 40 bytes		product name that can be configured in merchants.
Quantity B	200	Single-byte numbers 3 digits		The Item quantity that can be set by merchants.
Detail amount B	200000	Single-byte numbers 8 digits		This is the billing amount (including tax) that can be set by merchants.
Detail tax amount B	2000	Single-byte numbers 8 digits		This is the item tax amount that can be set in merchants.
product name C	Item C0003	Character string 40 bytes		This is the item tax amount that can be set in merchants.
Quantity C	300	Single-byte numbers 3 digits		The Item quantity that can be set by merchants.
Detail amount C	300000	Single-byte numbers 8 digits		Charges that can be set by merchants (tax included) (Mi).
Detail tax amount C	3000	Single-byte numbers 8 digits		This is the item tax amount that can be set in merchants.
product name D	Item D0004	Character string 40 bytes		product name that can be configured in merchants.
Quantity D	400	Single-byte numbers 3 digits		The Item quantity that can be set by merchants.
Detail amount D	400000	Single-byte numbers 8 digits		This is the billing amount (including tax) that can be set by merchants.
Detail tax amount D	4000	Single-byte numbers 8 digits		This is the item tax amount that can be set in merchants.
product name E	Item E0005	Character string 40 bytes		product name that can be configured in merchants.
Quantity E	500	Single-byte numbers 3 digits		The Item quantity that can be set by merchants.
Detail amount E	500000	Single-byte numbers 8 digits		This is the billing amount (including tax) that can be set by merchants.
Detail tax amount E	5000	Single-byte numbers 8 digits		This is the item tax amount that can be set in merchants.
Free column	Free Message	Character string 150 characters	You can add an additional message.

Email Link Type History Search Results

The following describes each format and output item when the CSV output button is pressed.
The output items differ depending on the sending method.

File Format Specifications

The format is shown in the table below.

format	Description
Character Codes	Shift-JIS
Line feed code	CR+LF
Extension	csv

CSV Output - Email

The individual formats are listed in the table below.

Individual Format	Description
Default File Name	Email Link Type Historical Search Results (Email) _YYYYMMDDHH24miss.csv (YYYYMMDDHH24miss is set to the processing time)
Header row presence/absence	Yes
Enclose in double quotes	Yes
Delimiter	comma

The output items are listed in the table below.

Field name	Example Values	Type and length	Remarks
Merchant ID	12345	Half-width numbers Fixed length (5 digits)	SBPS numbered merchants basic control number
Service ID	123	Half-width numbers Fixed length (3 digits)	SBPS numbered merchants extended control number
Service Name	XX site	Character string variable length	Name of the service you registered with SBPS
How to send	Email	Character string variable length	Transmission method name
Payment method	credit	Character string variable length	Payment method name
Sending number	00000000000001	Single-byte characters Fixed length (14 digits)	Sending number
Invoice number	ORDER00001	Half-width alphanumeric characters variable length	Invoice numbers that can be set up by merchants
Customer's first name	Taro Tanaka	Character string variable length	Customer names that can be set by merchants
Customer ID	CUSTCODE123456	Half-width alphanumeric characters variable length	Customer managed numbers that can be set up by merchants
Destination email address Reply (Email)	sample1@sample.co.jp	Single-byte characters variable length	Destination email address
Item name	Item 0001	Character string variable length	product name that can be set by merchants
Product ID	ITM0001	Half-width alphanumeric characters variable length	Item numbers that can be set by merchants
Billing amount	￥999,999	Single-byte numbers variable length	Charges that can be set by merchants
Date and time of sending	2017/12/14 20:00:00	Character string Fixed length (19 digit)	The date and time the email was sent
Due date of payment	2018/01/31	Character string Fixed length (10 digit)	Due date of payment
Sending Status	Sent	Character string variable length	"Not sent", "Sent"
Payment status	Payment completed	Character string variable length	"Payment", "Payment completed", "Payment error", "Cancelled"
Free column	The content you enter in the free field will be displayed.	Character string variable length	Message entered in the free field of the email
Sender email address response	sample2@sample.co.jp	Single-byte characters variable length	Sender email address
How to register a claim request ​	Payment management tool	Character string variable length	The method by which the billing request was registered Admin portal / Payment management tool, File Upload, API
Billing request registration date	2017/12/14	Character string Fixed length (10 digits)	Date when the billing request was created

CSV Output - SMS

The individual formats are listed in the table below.

Individual Format	Description
Default File Name	Email Link Type Historical Search Results (SMS) _YYYYMMDDHH24miss.csv (YYYYMMDDHH24miss is set to the processing time)
Header row presence/absence	Yes
Enclose in double quotes	Yes
Delimiter	comma

Field name	Example Values	Type and length	Remarks
Merchant ID	12345	Half-width numbers Fixed length (5 digits)	SBPS numbered merchants basic control number
Service ID	123	Half-width numbers Fixed length (3 digits)	SBPS numbered merchants extended control number
Service Name	XX site	Character string variable length	Name of the service you registered with SBPS
How to send	SMS	Character string variable length	Transmission method name
Payment method	credit	Character string variable length	Payment method name
Sending number	00000000000002	Single-byte characters Fixed length (14 digits)	Sending number
Invoice number	ORDER00002	Half-width alphanumeric characters variable length	Invoice numbers that can be set up by merchants
Customer's first name	Taro Tanaka	Character string variable length	Customer names that can be set by merchants
Customer ID	CUSTCODE123456	Half-width alphanumeric characters variable length	Customer managed numbers that can be set up by merchants
Destination telephone number	07011112222	Single-byte characters variable length	Destination phone number
Item name	Item 0002	Character string variable length	product name that can be set by merchants
Product ID	ITM0002	Half-width alphanumeric characters variable length	Item numbers that can be set by merchants
Billing amount	￥999,999	Single-byte numbers variable length	Charges that can be set by merchants
Date and time of sending	2017/12/14 20:00:00	Character string Fixed length (19 digit)	The date and time the SMS was sent
Due date of payment	2018/01/31	Character string Fixed length (10 digit)	Due date of payment
Sending Status	Sent	Character string variable length	"Not sent", "Sent"
Payment status	Payment completed	Character string variable length	"Payment", "Payment completed", "Payment error", "Cancelled"
Free column	The content you enter in the free field will be displayed.	Character string variable length	Message entered in the free SMS field
How to register a claim request ​	Payment management tool	Character string variable length	The method by which the billing request was registered Admin portal / Payment management tool, File Upload, API
Billing request registration date	2017/12/14	Character string Fixed length (10 digits)	Date when the billing request was created

CSV Output - QR Bill

The individual formats are listed in the table below.

Individual Format	Description
Default File Name	Email Link Type Historical Search Results (QR Invoice) _YYYYMMDDHH24miss.csv (YYYYMMDDHH24miss is set to the processing time)
Header row presence/absence	Yes
Enclose in double quotes	Yes
Delimiter	comma

Field name	Example Values	Type and length	Remarks
Merchant ID	12345	Half-width numbers Fixed length (5 digits)	SBPS numbered merchants basic control number
Service ID	123	Half-width numbers Fixed length (3 digits)	SBPS numbered merchants extended control number
Service Name	XX site	Character string variable length	Name of the service you registered with SBPS
How to send	QR bill	Character string variable length	Transmission method name
Payment method	credit	Character string variable length	Payment method name
Sending number	00000000000003	Single-byte characters Fixed length (14 digits)	Sending number
Invoice number	ORDER00003	Half-width alphanumeric characters variable length	Invoice numbers that can be set up by merchants
Customer's first name	Taro Tanaka	Character string variable length	Customer names that can be set by merchants
Customer ID	CUSTCODE123456	Half-width alphanumeric characters variable length	Customer managed numbers that can be set up by merchants
Item name	Item 0003	Character string variable length	product name that can be set by merchants
Product ID	ITM0003	Half-width alphanumeric characters variable length	Item numbers that can be set by merchants
Billing amount	￥999,999	Single-byte numbers variable length	Charges that can be set by merchants
Date and time of sending	2017/12/14 20:00:00	Character string Fixed length (19 digit)	Date and time the QR bill was issued
Due date of payment	2018/01/31	Character string Fixed length (10 digit)	Due date of payment
Sending Status	Sent	Character string variable length	"Not sent", "Sent"
Payment status	Payment completed	Character string variable length	"Payment", "Payment completed", "Payment error", "Cancelled"
Free column	The content you enter in the free field will be displayed.	Character string variable length	Message entered in the free field on the QR bill
How to register a claim request ​	Payment management tool	Character string variable length	The method by which the billing request was registered Admin portal / Payment management tool, File Upload, API
Billing request registration date	2017/12/14	Character string Fixed length (10 digits)	Date when the billing request was created