LM_VNDR_PROD_VW

(SQL View)
 Index Back

Vendor Products definition


SELECT LM_VENDOR_ID , LM_VENDOR_PROD_ID , LM_VPROD_DESCR , LM_VPROD_SDESCR , LM_PROD_TYPE , LM_PRICE_MODEL , LM_QUANTITY , LM_UNIT , LM_AMOUNT , LM_PER_UNIT_AMOUNT , LM_CURRENCY , LM_PAYMENT_TERMS , LM_CONTRACT_DESCR , LM_VNDR_CONTRCT_ID , LM_ROW_ADDED_DTTM , LM_ROW_ADDED_OPRID , LM_ROW_MAINT_DTTM , LM_ROW_MAINT_OPRID FROM PS_LM_VENDOR_PROD

  • Related Language Record: LM_VPROD_LANG

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

    Prompt Table: LM_PROD_TYPE

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

    Prompt Table: LM_PRICING_TYPE

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

    Prompt Table: LM_UNITS

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

    Prompt Table: CURRENCY_CD_TBL

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