QCK_POST_OERVW2

(SQL View)
 Index Back

Quick Posting Org Error View 2


SELECT a.business_unit , a.oprid , a.grp_timestamp , a.line_seq_nbr , b.message_nbr , b.message_set_nbr , a.account_nbr , a.account_term , b.ssf_error_warn FROM PS_QUICK_POST_TBL a , ps_quick_post_err b , ps_account_org_sf c WHERE a.business_unit = b.business_unit AND a.oprid = b.oprid AND a.grp_timestamp = b.grp_timestamp AND a.line_seq_nbr = b.line_seq_nbr AND a.business_unit = c.business_unit AND a.ext_org_id = c.ext_org_id AND a.account_nbr = c.account_nbr AND a.account_term = c.account_term

  • Parent record: GROUP_LINE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPR_DEF_TBL_CS

    3 GRP_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Group Line Time Stamp
    4 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    5 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    7 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    8 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    9 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
    E=Error
    M=Message
    W=Warning