AV_INVLV_G_DES

(SQL Table)
Index Back

Involvement Designations

  • Parent record: AV_INVLV_G_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AV_RECEIPT_NBR Character(12) VARCHAR2(12) NOT NULL Receipt Number
    2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

    Prompt Table: %EDITTABLE2

    3 AV_DES_BU Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: AV_WEB_ACCT.AV_DES_BU

    4 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation

    Default Value: AV_WEB_ACCT.DESIGNATION

    5 DES_PCT_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount