GPJP_IHTDTA_LNG

(SQL Table)
 Index Back

IH Tax Load Related Lang

Related language record for the main data record used in the Inhabitant Tax File creation process.

  • Related Language Record for GPJP_IH_TAX_DTA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number

    Prompt Table: GPJP_TAXESIT_VW

    2 YEAR_CODE Character(4) VARCHAR2(4) NOT NULL Select Calendar Year
    1994=1994
    1995=1995
    1996=1996
    1997=1997
    1998=1998
    1999=1999
    2000=2000
    2001=2001
    2002=2002
    2003=2003
    2004=2004
    2005=2005
    2006=2006
    2007=2007
    2008=2008
    2009=2009
    2010=2010
    2011=2011
    2012=2012
    2013=2013
    2014=2014
    2015=2015
    2016=2016
    2017=2017
    2018=2018
    2019=2019
    2020=2020
    3 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    4 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

    Prompt Table: SRC_BANK

    5 MUNICIPAL_CD_JPN Character(6) VARCHAR2(6) NOT NULL Japanese Municipal Code
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description