VENDOR_CONVER

(SQL Table)
Index Back

Conversations with a Supplier

  • Parent record: VENDOR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 CONVER_DT Date(10) DATE NOT NULL Conversation Date

    Default Value: %date

    4 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number
    5 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: VNDR_CNTCT_VW

    6 CONVER_TOPIC Character(30) VARCHAR2(30) NOT NULL Conversation Topic
    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 REVIEW_DAYS Number(3,0) SMALLINT NOT NULL Review Days
    9 REVIEW_DATE Date(10) DATE Review Date
    10 REVIEW_NEXT_DATE Date(10) DATE Next Review Date
    11 KEYWORD1 Character(10) VARCHAR2(10) NOT NULL Keyword

    Prompt Table: KEYWORD_AP

    12 KEYWORD2 Character(10) VARCHAR2(10) NOT NULL Keyword

    Prompt Table: KEYWORD_AP

    13 KEYWORD3 Character(10) VARCHAR2(10) NOT NULL Keyword

    Prompt Table: KEYWORD_AP

    14 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

    Default Value: %DATETIME

    15 DESCRLONG Long Character CLOB Long Description