Overview
The Payment Session JBF Export records will carry the detailed information needed to support the Japanese Bank Format (JBF) in individual fields, including a 120-character text field properly formatted and sequenced to facilitate the export process.
Navigation
Payment Session JBF Export
Prerequisites
The checkbox Create JBF Export from Payment Session must be checked in the AP Control record for the Financial company associated with the Payment Selection Session.
Processing
On clicking the Create JBF Export button on the Payment Selection Session, any existing Payment Session JBF Export data for the Payment Selection Session will be cleared first. The process will then create the Payment Session JBF Export records, which carry the Payment Session information in the following four formats:
- A single Header Record per session.
- Multiple Data Records containing individual payment details. A single Detail Record will be created for each vendor in the payment session.
- A single Trailer Record.
- A single 'END' Record.
The process also creates a text file containing the formatted output with a row for each Payment Session JBF Export record for the Payment Selection Session. It attaches it in the Notes & Attachments section on the Payment Selection Session page. The text file name is the Payment Session Id.
Note The Create JBF Export button will appear only for Payment Sessions that are closed and posted (Session Status - Completed)
Fields
Payment Selection Session: This field provides the linkage up to the Payment Selection Session from which this export was created.
JBF Sequence: The sequence to be used when transmitting the export data to the bank.
JBF Export Record: This field contains the fully formatted 120-character export record. This is the only field on this record that is actually transmitted to the bank.
JBF Export Record (121 chars): This field contains the fully formatted 120-character export record – with one extra trailing character to preserve the spacing.
Record Type: User-friendly description of the record type (Header, Data, Trailer, or End).
Header:
Record Identifier: Numeric representation of the record type (used in the export): 1=Header, 2=Data, 8=Trailer, 9=End.
Classification: Currently this is a hard-coded value set to '21'.
Code Type: Used in the Header Record, this field carries the character set used (derived from the AP Control setting): 0 = JIS (same as ASCII), 1 = EBCDIC.
EFT Requestor ID: Used in the Header Record, this field carries the EFT Requestor ID for this bank (sourced from the Bank Account).
Account Holder's Name: Used in the Header Record, this field contains the Bank Account holder's name, sourced from the Rootstock ERP Company Master, Company Name.
Transfer Date (MMDD): Used in the Header Record, this field contains the Bank Transfer Date, sourced from the Payment Selection Session Check Date.
Remitting Bank Number: Used in the Header Record, this field carries the Remitting Bank Number for this bank account (sourced from a field of the same name on the Bank Account).
Remitting Branch Number: Used in the Header Record, this field carries the Remitting Branch Number for this bank account (sourced from a field of the same name on the Bank Account).
Account Number: Used in the Header Record, this field contains the Bank Account Number from where the funds are to be drawn. It is sourced using the first 7 characters of the Rootstock GL Bank Account Number.
Detail:
Record Identifier: Numeric representation of the record type (used in the export): 1=Header, 2=Data, 8=Trailer, 9=End.
Receiving Bank Number: Used in the Detail Record, this field carries the first 4 characters of the Vendor's Business Identifier Code (BIC) associated with this payment.
Receiving Branch Number: Used in the Detail Record, this field carries the first 3 characters of the Vendor's Bank Account Reference Number associated with this payment.
Account Number (Vendor): Used in the Detail Record, this field carries the first 7 characters of the Vendor's International Bank Account Number (IBAN) associated with this payment.
Account Holder Name (Vendor): Used in the Detail Record, this field carries the Vendor Name associated with this payment.
Account Type (Vendor): Used in the Detail Record, currently this is a hard-coded value set to '1'.
Transfer Amount: Used in the Detail Record, this field carries the amount of the payment (same as the EFT or Check Amount).
Status: Used in the Detail Record, currently this is a hard-coded value set to '0'.
Transfer Priority: Used in the Detail Record, currently this is a hard-coded value set to '8'.
Trailer:
Record Identifier: Numeric representation of the record type (used in the export): 1=Header, 2=Data, 8=Trailer, 9=End.
Total Count: Used in the Trailer Record, this field carries the total number of Detail Records (payments) in the export.
Total Amount: Used in the Trailer Record, this field carries the total amount (sum of all Detail Record amounts) in the export.
End:
Record Identifier: Numeric representation of the record type (used in the export): 1=Header, 2=Data, 8=Trailer, 9=End.
SEE ALSO
Payment Selection
AP Control
