INTFC_OM_CST_VW

(SQL View)
 Index Back

View of pending Cred Card Tran

View of Order Management Pending Credit Card Transactions. These can be where the transactions have not processed or if they have been denied. Date Init Issue # Description 082101 JJM F-CJORGENS-6 Added ORDER_NO, SOLD_TO_CUST_ID and CR_CARD_AUTH_STAT 040103 JJM 53855000 Added SOLD_TO_CUST_ID, NAME1 and NAME2

SELECT IC.BUSINESS_UNIT , IC.ORDER_NO , OH.SOLD_TO_CUST_ID , C1.NAME1 , OH.BILL_TO_CUST_ID , C2.NAME1 FROM PS_INTFC_CRCARD IC , PS_ORD_HEADER OH , PS_CUSTOMER C1 , PS_CUSTOMER C2 WHERE IC.BUSINESS_UNIT = OH.BUSINESS_UNIT AND IC.ORDER_NO = OH.ORDER_NO AND C1.CUST_STATUS IN ('A','I') AND C2.CUST_STATUS IN ('A','I') AND C1.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SCR.RECNAME = 'CUSTOMER') AND C1.CUST_ID = OH.SOLD_TO_CUST_ID AND C2.SETID = C1.SETID AND C2.CUST_ID = OH.BILL_TO_CUST_ID AND IC.PROCESS_INSTANCE = 0 AND IC.INVOICE = ' ' AND IC.DEPOSIT_ID = ' ' AND IC.ORDER_NO <> ' '

  • Related Language Record: INTFC_OM_CST_LN

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

    Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

    Prompt Table: SP_BU_OM_NONVW

    2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    6 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2