AUC_NOIA_HDR

(SQL Table)
 Index Back

NOIA Header

NOIA Header

  • Parent Record Of AUC_NOA_CNTACT AUC_NOIA_ADHC_E AUC_NOIA_ATTCH AUC_NOIA_BIDDER AUC_NOIA_CNTACT AUC_NOIA_RS_BDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    5 AUC_BIDDER_FLG Character(4) VARCHAR2(4) NOT NULL Notification To be Sent
    A=All Bidders
    ORB=Only Responded Bidders
    SB=Specific Bidders

    Default Value: AUC_HDR.AUC_BIDDER_FLG

    6 AUC_NOIA_SENT Character(1) VARCHAR2(1) NOT NULL NOIA Status
    N=Not Sent
    Y=Sent

    Default Value: N

    7 AUC_NOIA_PROTEST Date(10) DATE Notice End Date
    8 AUC_STD_COMM_TYPE1 Character(4) VARCHAR2(4) NOT NULL Standard Comment Type

    Prompt Table: AUC_STD_COM_TP1

    9 AUC_STD_COMM_ID1 Character(10) VARCHAR2(10) NOT NULL Standard Comment ID

    Prompt Table: AUC_STD_COM_1

    10 AUC_STD_OPEN_COMM Long Character CLOB Opening Text
    11 AUC_STD_COMM_TYPE3 Character(4) VARCHAR2(4) NOT NULL Standard Comment Type

    Prompt Table: AUC_STD_COM_TP3

    12 AUC_STD_COMM_ID3 Character(10) VARCHAR2(10) NOT NULL Standard Comment ID

    Prompt Table: AUC_STD_COM_3

    13 AUC_STD_CLOSE_COMM Long Character CLOB Closing Text
    14 DESCRLONG Long Character CLOB Long Description
    15 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

    Default Value: AUC_HDR.TMPLDEFN_ID

    Prompt Table: AUCNOIA_TMPL_VW

    16 WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name

    Default Value: AUC_HDR.WL_TEMPLATE_ID

    Prompt Table: AUC_NOIA_GEN_VW

    17 AUC_NOIA_HDR_LN Character(1) VARCHAR2(1) NOT NULL View Summary By
    H=Header
    L=Line

    Default Value: H