GPJP_IH_TAX_HDR

(SQL Table)
Index Back

IH Tax Load data record

Header data record used in the Inhabitant Tax File creation process.

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