SSF_PMTCHNAL_VW (SQL View)	Index Back
Non-restricted Payments A view of all payments non-restricted paying for a charge.

SSF_PMTCHNAL_VW

(SQL View)

Non-restricted Payments

A view of all payments non-restricted paying for a charge.

SELECT A.BUSINESS_UNIT , A.COMMON_ID , A.SA_ID_TYPE , A.ITEM_NBR_CHARGE , A.PAYMENT_ID_NBR , 0 , B.CURRENCY_CD FROM PS_ITEM_XREF A , PS_PAYMENT_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND A.PAYMENT_ID_NBR = B.PAYMENT_ID_NBR AND B.SSF_PMT_CHG_ALLOC <> 'Y' AND A.XREF_AMT <> 0 AND %EffdtCheck(ITEM_XREF A1, A, %CURRENTDATEIN)

# 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_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW

2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person

4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
Prompt Table: SSF_ITCHRG_VW

5 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr

6 PAYOUT_AMT Number(17,2) DECIMAL(16,2) NOT NULL New Allocation

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW
2	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
3	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person
4	ITEM_NBR	Character(15)	VARCHAR2(15) NOT NULL	Item Nbr Prompt Table: SSF_ITCHRG_VW
5	PAYMENT_ID_NBR	Number(12,0)	DECIMAL(12) NOT NULL	Payment ID Nbr
6	PAYOUT_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	New Allocation
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code