INTFC_OM_CST_LN(SQL View) |
Index Back |
---|---|
View of pending Cred Card TranView 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 , CL1.LANGUAGE_CD , CL1.NAME1 , CL2.NAME1 FROM PS_INTFC_CRCARD IC , PS_ORD_HEADER OH , PS_CUSTOMER_LANG CL1 , PS_CUSTOMER_LANG CL2 WHERE IC.BUSINESS_UNIT = OH.BUSINESS_UNIT AND IC.ORDER_NO = OH.ORDER_NO AND CL1.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SCR.RECNAME = 'CUSTOMER') AND CL1.CUST_ID = OH.SOLD_TO_CUST_ID AND CL2.SETID = CL1.SETID AND CL2.CUST_ID = OH.BILL_TO_CUST_ID AND CL2.LANGUAGE_CD = CL1.LANGUAGE_CD AND IC.PROCESS_INSTANCE = 0 AND IC.INVOICE = ' ' AND IC.DEPOSIT_ID = ' ' AND IC.ORDER_NO <> ' ' |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
5 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |