CM_APRECN3_VW

(SQL View)
 Index Back

CM/AP Reconciliation Table Vw


SELECT DISTINCT a.run_cntl_id , a.request_id , b.descr , a.business_unit_recv , a.receiver_id FROM PS_CM_APRECN_HDR a , ps_cm_aprecn_rqst b WHERE a.run_cntl_id = b.run_cntl_id AND a.request_id = b.request_id AND a.cm_ap_error_ok = 'N'

  • Related Language Record: CM_APRECN3_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    2 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

    Prompt Table: CM_APRQSTID_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    5 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number