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
Image: Electronic Transfer Formats page
This example illustrates the fields and controls on the Electronic Transfer Formats page.
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===================================***************12184199801100476980000065450000000003121841998011005127800000000800000000031218419980110076622000000935000000000312184199801100874700000068850000000003