TARIF_ARTBL_LNG

(SQL Table)
 Index Back

GER - Tariff Area Table

Used to set up German tariff areas with a particular tariff.

  • Related Language Record for TARIFF_AREA_GER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TARIFF_GER Character(2) VARCHAR2(2) NOT NULL Tariff
    01=Metal Processing
    02=Banking
    03=Building and Civil Engineering
    04=Clothing Industry
    05=Chemical Industry
    06=Printing Industry
    07=Retail Trade
    08=Fossil Oil and Gas Extraction
    09=Glass Industry
    10=Wholesale and Foreign Trade
    11=Wood Processing
    12=Rubber Processing
    13=Ceramics
    14=Agriculture
    15=Leather Processing
    16=Public Sector
    17=Paper Industry
    18=Paper Processing
    19=Sawing Industry
    20=German Seaports
    21=Hard-Coal Mining
    22=Textile Industry
    23=Insurance
    24=Housing Industry
    25=Periodical Publishers
    26=Newspaper Publishers
    27=Tobacco Industry
    2 TARIFF_AREA_GER Character(3) VARCHAR2(3) NOT NULL Tariff Area
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description