| # | 
PeopleSoft Field Name | 
PeopleSoft Field Type | 
Database Column Type | 
Description | 
| 1 | 
 GPJP_COMPANY_CODE | 
Character(10) | 
VARCHAR2(10) NOT NULL | 
Tracks a company identifier assigned by the banking institution.
 | 
| 2 | 
 BRANCH_EC_CD | 
Character(17) | 
VARCHAR2(17) NOT NULL | 
Bank Branch ID
 | 
| 3 | 
GPJP_CHRDT_YYMMDD1 | 
Character(6) | 
VARCHAR2(6) NOT NULL | 
Character Date as YYMMDD
 | 
| 4 | 
GPJP_CHARDATE | 
Character(4) | 
VARCHAR2(4) NOT NULL | 
This field stores dates in a character format, specifically in the format of MMDD.
 | 
| 5 | 
GPJP_ESTAB_NM_AC | 
Character(40) | 
VARCHAR2(40) NOT NULL | 
Used in Inhabitant Tax File creation process.
 | 
| 6 | 
GPJP_ESTAB_LCN_AC | 
Character(50) | 
VARCHAR2(50) NOT NULL | 
Used in Inhabitant Tax File creation process.
 |