SUT_USECD_LG_VW

(SQL View)
 Index Back

Ultimate Use Code Prompt Table

Prompt Table for Ultimate Use Codes.

SELECT DISTINCT A.SETID , A.SHIPTO_ID , A.ULTIMATE_USE_CD , B.LANGUAGE_CD , B.DESCR FROM PS_SUT_DFLT_TBL A , PS_SUT_USE_CD_LANG B WHERE A.SETID = B.SETID AND A.ULTIMATE_USE_CD = B.ULTIMATE_USE_CD

  • Related Language Record for C_SUT_USETRN_VW SUT_USETRN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
    3 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description