PASTD_OPER_VW

(SQL View)
 Index Back

Past Due Itens - By User Pref

Past Due Itens By User Preference

SELECT S.OPRID , I.BUSINESS_UNIT , I.CUST_ID , I.SUBCUST_QUAL1 , I.SUBCUST_QUAL2 , CASE WHEN S.RESP_PART_OPT = 'A' THEN ( SELECT SR1.SETID FROM PS_SET_CNTRL_REC SR1 WHERE SR1.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR1.RECNAME = 'AR_SPECIALIST') WHEN S.RESP_PART_OPT = 'B' THEN ( SELECT SR5.SETID FROM PS_SET_CNTRL_REC SR5 WHERE SR5.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR5.RECNAME = 'CUSTOMER') WHEN S.RESP_PART_OPT = 'R' THEN ( SELECT SR2.SETID FROM PS_SET_CNTRL_REC SR2 WHERE SR2.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR2.RECNAME = 'CR_ANALYST_TBL') WHEN S.RESP_PART_OPT = 'S' THEN ( SELECT SR3.SETID FROM PS_SET_CNTRL_REC SR3 WHERE SR3.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR3.RECNAME = 'TEAM_MEMBER_VW') ELSE ( SELECT SR4.SETID FROM PS_SET_CNTRL_REC SR4 WHERE SR4.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR4.RECNAME = 'COLLECTOR_TBL') END , CASE WHEN S.RESP_PART_OPT = 'A' THEN I.AR_SPECIALIST WHEN S.RESP_PART_OPT = 'B' THEN I.BROKER_ID WHEN S.RESP_PART_OPT = 'R' THEN I.CR_ANALYST WHEN S.RESP_PART_OPT = 'S' THEN I.SALES_PERSON ELSE I.COLLECTOR END , I.BAL_CURRENCY , I.COUNT_LINES , I.BAL_AMT FROM PS_PASTD_IT_MVW I , PS_ARFO_PRF_PSTDUE S WHERE S.BU_SELECT_FLG = 'A' OR EXISTS ( SELECT 'x' FROM PS_ARFO_PRFPSTD_BU BU WHERE BU.OPRID = S.OPRID AND BU.BUSINESS_UNIT = I.BUSINESS_UNIT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUARDS_NONVW

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
5 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 RESP_PART Character(15) VARCHAR2(15) NOT NULL Responsible Party
8 BAL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code - Bal Amount
9 COUNT_LINES Number(15,0) DECIMAL(15) NOT NULL Count of Lines
10 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance