REGNCD_TRFTLNG

(SQL View)
 Index Back

Region Cd freight RL View

This is a Related Language view on the Region Code table for all the REGNCD% TRN type views.

SELECT a.setid , a.region_cd_type , a.region_cd , a.effdt , a.language_cd , a.descr FROM PS_REGION_CD_LNG a WHERE a.region_cd_type IN ('FRT','TRPT')

  • Related Language Record for REGNCD_TRFT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 REGION_CD_TYPE Character(4) VARCHAR2(4) NOT NULL Region Code Type
    ACCT=Accounting
    BO=Backorder/Reservation
    CDOM=Contract Domain
    CNTR=Contracts
    FRT=Freight
    MBR=Team Member
    PRC=Pricing
    RPT=Reporting
    RS=Resource Management
    SPRS=Procurement
    SSRC=Alternate Sources Of Supply
    TRPT=Transportation
    3 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: REGION_CD

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description