GPDE_ER_TRFAREA

(SQL Table)
 Index Back

Tariff Area Table

Prompt table for Tariff Area. This table created for German payroll system.

  • Related Language Record: GPDE_ER_TRF_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPDE_TX_TARIF Character(2) VARCHAR2(2) NOT NULL Tariff
    01=Metal
    02=Banks
    03=Construction
    04=Clothing
    05=Chemicals
    06=Printing
    07=Retail
    08=Crude Oil and Natural Gas
    09=Glass
    10=Wholesale and Export
    11=Timber
    12=Rubber
    13=Ceramics
    14=Agriculture
    15=Leather
    16=Civil Service
    17=Paper
    18=Paper Processing
    19=Sawmills
    20=German Harbours
    21=Hard Coal Mining
    22=Textiles
    23=Insurance
    24=Housing
    25=Periodicals
    26=Newspapers
    27=Cigarettes
    2 GPDE_ER_TRF_AREA Character(3) VARCHAR2(3) NOT NULL Tariff Area
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A