LM_CI_NOTES_LNG

(SQL Table)
Index Back

Catalog Item - Notes LNG

This table stores all the notes that are delivered at the Catalog Item level - This is a Related Language Table

  • Related Language Record for LM_CI_NOTES_TBL
  • Parent record: LM_CI_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

    Default Value: 0

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LM_NOTES_ID Number(10,0) DECIMAL(10) NOT NULL Notes ID - System generated unique ID for each new note entered.

    Default Value: 0

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_NOTES Long Character CLOB Notes - This field holds notes that are entered at the Catalog Item level.