APOP_VENDOR_LVW

(SQL View)
Index Back

Supplier Header Related Lang


SELECT A.SETID , A.VENDOR_ID , A.AP_PERIOD_NAME , A.AP_ACTION_SUPPLIER , VL.LANGUAGE_CD , VL.VENDOR_NAME_SHORT , VL.VNDR_NAME_SHRT_USR FROM %Table(APOP_VENDOR_MV) A , %Table(VENDOR_LANG) VL WHERE VL.SETID = A.SETID AND VL.VENDOR_ID = A.VENDOR_ID

  • Related Language Record for APOP_VENDOR_MV APOP_VENDOR_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SETID_TBL

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 AP_PERIOD_NAME Character(35) VARCHAR2(35) NOT NULL Period Name
    4 AP_ACTION_SUPPLIER Character(1) VARCHAR2(1) NOT NULL Action Supplier
    A=Added
    U=Updated
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    7 VNDR_NAME_SHRT_USR Character(10) VARCHAR2(10) NOT NULL Short Vendor Name