# |
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.
|