OPRIDBUSINESS_UNITPrompt Table: SP_BUARDS_NONVW
CUSTOMER_SETIDCUST_IDA=All
S=Specific
T=Top Five
Default Value: T
A=All
G=Customer Groups
S=Specific
Default Value: A
N=NO
Y=YES
Default Value: N
A=All
S=Specific
Default Value: A
AR_ONACT_PYMTS0(SQL View) |
Index Back |
|---|---|
On-accounts Payments TileOn-accounts Payments Tile |
| SELECT S.OPRID , I.BUSINESS_UNIT ,E.SETID , I.CUST_ID , S.RESP_TOP5_FLG , S.CUST_SELECT_FLG , S.BLK_CUST_GRP , S.BU_SELECT_FLG , CASE S.RESP_PART_OPT WHEN 'A' THEN ( SELECT SETID FROM PS_AR_BUSET_MVW SR1 WHERE SR1.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR1.RECNAME = 'AR_SPECIALIST') WHEN 'B' THEN ' ' WHEN 'R' THEN ( SELECT SETID FROM PS_AR_BUSET_MVW SR1 WHERE SR1.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR1.RECNAME = 'CR_ANALYST_TBL') WHEN 'S' THEN ( SELECT SETID FROM PS_AR_BUSET_MVW SR1 WHERE SR1.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR1.RECNAME = 'TEAM_MEMBER_VW') ELSE ( SELECT SETID FROM PS_AR_BUSET_MVW SR1 WHERE SR1.SETCNTRLVALUE = I.BUSINESS_UNIT AND SR1.RECNAME = 'COLLECTOR_TBL') END, CASE S.RESP_PART_OPT WHEN 'A' THEN I.AR_SPECIALIST WHEN 'B' THEN I.BROKER_ID WHEN 'R' THEN I.CR_ANALYST WHEN 'S' THEN I.SALES_PERSON ELSE I.COLLECTOR END ,I.ENTRY_TYPE ,I.BAL_CURRENCY ,S.DISPLAY_CURRENCY ,I.ITEM_count ,I.BAL_AMT ,%Round(%DecMult(%DecDiv(I.BAL_AMT, R.RATE_DIV), R.RATE_MULT), CUR.DECIMAL_POSITIONS) FROM PS_AR_ONACT_PYT_MV I ,PS_ARFO_PRF_ONACCT S ,PS_AR_BUSET_MVW E ,PS_RT_RATE_TBL R ,PS_OPI_CURR_EFF_MV CUR WHERE E.SETCNTRLVALUE = I.BUSINESS_UNIT AND E.RECNAME = 'CUSTOMER' AND R.FROM_CUR=I.BAL_CURRENCY AND R.TO_CUR=S.DISPLAY_CURRENCY AND R.RT_TYPE=S.DSP_RT_TYPE AND R.RT_RATE_INDEX=S.RATE_INDEX AND R.EFFDT=( SELECT MAX(C2.EFFDT) FROM PS_RT_RATE_TBL C2 WHERE R.FROM_CUR=C2.FROM_CUR AND R.TO_CUR=C2.TO_CUR AND R.RT_TYPE=C2.RT_TYPE AND R.RT_RATE_INDEX=C2.RT_RATE_INDEX AND C2.EFFDT <= %CurrentDateIn) AND CUR.CURRENCY_CD = S.DISPLAY_CURRENCY AND %CurrentDateIn BETWEEN CUR.EFFDT_FROM AND CUR.EFFDT_TO |
| # | 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 | CUSTOMER_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 4 | 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. |
| 5 | RESP_TOP5_FLG | Character(1) | VARCHAR2(1) NOT NULL |
RESP_TOP5_FLG
A=All S=Specific T=Top Five Default Value: T |
| 6 | CUST_SELECT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Customer Select Flag
A=All G=Customer Groups S=Specific Default Value: A |
| 7 | BLK_CUST_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Include Blank Customer Group
N=NO Y=YES Default Value: N |
| 8 | BU_SELECT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Business Units
A=All S=Specific Default Value: A |
| 9 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 10 | RESP_PART | Character(15) | VARCHAR2(15) NOT NULL | Responsible Party |
| 11 | ENTRY_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction. |
| 12 | BAL_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code - Bal Amount |
| 13 | DISPLAY_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Display Currency |
| 14 | ITEM_COUNT | Number(5,0) | INTEGER NOT NULL | Item Count |
| 15 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
| 16 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |