PROD_NOTE_MD

(SQL Table)
 Index Back

Product Notes Staging

Staging table for product notes. Date Initials Issue Description 032601 dms SP2 (DI-EDWONG-14)

  • Related Language Record: PROD_NOTE_MD_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
    601=Consumer Sync
    701=BOM Sync
    801=Item Revision
    901=Item Bus Unit Sync
    902=Item Sync
    2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    6 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type

    Prompt Table: NOTE_TYPE

    7 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code

    Prompt Table: STD_NOTE

    8 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    9 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    11 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    12 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values