LM_ACT_VNDPR_VW

(SQL View)
 Index Back

Vendor Products definition


SELECT B.LM_ACT_ID , A.LM_VENDOR_ID , A.LM_VENDOR_PROD_ID , A.LM_VPROD_DESCR , A.LM_VPROD_SDESCR , A.LM_PROD_TYPE , A.LM_PRICE_MODEL , A.LM_QUANTITY , A.LM_UNIT , A.LM_AMOUNT , A.LM_PER_UNIT_AMOUNT , A.LM_CURRENCY , A.LM_PAYMENT_TERMS , A.LM_CONTRACT_DESCR , A.LM_VNDR_CONTRCT_ID ,%subrec(LM_ROWAUDIT_SBR, A) FROM PS_LM_VENDOR_PROD A , PS_LM_ACT B , PS_LM_CI_TBL C WHERE B.LM_CI_ID = C.LM_CI_ID AND C.LM_VENDOR_ID = A.LM_VENDOR_ID AND C.LM_VENDOR_PROD_ID = A.LM_VENDOR_PROD_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.LM_EXTRNL_OFRNG = '20'

  • Related Language Record: LM_ACT_VNDPRLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    2 LM_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID
    3 LM_VENDOR_PROD_ID Number(15,0) DECIMAL(15) NOT NULL Vendor Product ID
    4 LM_VPROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    5 LM_VPROD_SDESCR Character(10) VARCHAR2(10) NOT NULL Short Description
    6 LM_PROD_TYPE Character(30) VARCHAR2(30) NOT NULL Product Type

    Prompt Table: LM_PROD_TYPE

    7 LM_PRICE_MODEL Character(3) VARCHAR2(3) NOT NULL Price Model

    Prompt Table: LM_PRICING_TYPE

    8 LM_QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    9 LM_UNIT Character(3) VARCHAR2(3) NOT NULL Unit

    Prompt Table: LM_UNITS

    10 LM_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    11 LM_PER_UNIT_AMOUNT Number(15,0) DECIMAL(15) NOT NULL Per Unit amount
    12 LM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency

    Prompt Table: CURRENCY_CD_TBL

    13 LM_PAYMENT_TERMS Character(1) VARCHAR2(1) NOT NULL Payment Terms
    M=Monthly
    Q=Quarterly
    S=Semi-yearly
    W=Weekly
    Y=Yearly
    14 LM_CONTRACT_DESCR Character(50) VARCHAR2(50) NOT NULL Contract description
    15 LM_VNDR_CONTRCT_ID Character(10) VARCHAR2(10) NOT NULL Vendor Contract ID
    16 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    17 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    18 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    19 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid