Defining Electronic Funds Transfer Formats
Page Name |
Definition Name |
Usage |
---|---|---|
EFT_NAME |
Define the EFT file that complies with the file format used by China Construction Bank, Shanghai branch to transfer funds to other banks. |
Use the Electronic Transfer Formats page (EFT_NAME) to define the EFT file that complies with the file format used by China Construction Bank, Shanghai branch to transfer funds to other banks.
Navigation:
Because Chinese banks don't have a standardized banking format, Global Payroll for China delivers only one banking format used by China Construction Bank, Shanghai branch as an example. You need to create a File Layout and update Create Payment EFT File Application Engine program (GPCN_EFT) appropriately so that they will meet your bank's requirements.
Electronic File Format
The EFT file format defined by China Construction Bank, Shanghai branch is made up of a header section and a body section. The EFT file is created as an ASCII file with the fixed name gpcn_bank.txt.
This table illustrates the four rows of the header section of the banking file.
Row |
Description |
Data Source |
Example |
---|---|---|---|
1 |
Company Name |
Account name on Source Bank page. If the length is less than 31, the rest is filled with "=". The data has to be alphanumeric. |
ABCD (China) COMPANY LIMITED=== |
2 |
Total Lines |
Total number of lines in the body section of the banking file in six digits plus "=" repeated 25 times. |
000004========================= |
3 |
Total Payment Amount |
Total amount of the payment in the body section of the banking file in 12 digits, plus "=" repeated 19 times. |
000000014373=================== |
4 |
Separator Line |
Fixed value. |
================*************** |
The following table illustrates the body section of the banking file. The body section comprises three items.
Item |
Description |
Data Source |
Digit |
Example |
---|---|---|---|---|
1 |
Account Number |
Account ID on Payee Net Distribution page. |
19 |
1218419980110047698 |
2 |
Payment Amount |
Sum of Net Result Values stored in the Global Payroll Core result table by each payee. |
9 |
000006545 (meaning 65.45 CNY) |
3 |
Transaction Type Code |
Fixed value. |
10 |
0000000003 |
The following is an example of the EFT file:
ABCD (China) COMPANY LIMITED===
000004=========================
000000014373===================
================***************
12184199801100476980000065450000000003
12184199801100512780000000080000000003
12184199801100766220000009350000000003
12184199801100874700000068850000000003