SUT_USETRN_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.DESCR FROM PS_SUT_DFLT_TBL A , PS_SUT_USE_CD B WHERE A.SETID = B.SETID AND A.ULTIMATE_USE_CD = B.ULTIMATE_USE_CD

  • Related Language Record: SUT_USECD_LG_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description