AR_PAY_HDR_VW (SQL View)	Index Back
Payment WO Header View Payment write off header

AR_PAY_HDR_VW

(SQL View)

Payment WO Header View

Payment write off header

SELECT C.PAY_WS_TYPE , A.DEPOSIT_BU , A.DEPOSIT_ID , A.PAYMENT_SEQ_NUM , B.CUST_ID , B.NAME1 , A.WO_ITEM_AMT , A.AR_WOAPPR_STATUS , A.REQ_WO_COMMENTS FROM PS_PAYMENT A , PS_PAYMENT_ID_CUST B , PS_DEPOSIT_CONTROL C WHERE A.DEPOSIT_BU = B.DEPOSIT_BU AND A.DEPOSIT_ID = B.DEPOSIT_ID AND A.AR_WOAPPR_STATUS <> 'A' AND A.DEPOSIT_BU = C.DEPOSIT_BU AND A.DEPOSIT_ID = C.DEPOSIT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_WS_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Worksheet Type
C=Credit Card Worksheet
E=ePayment Worksheet
P=Payment Worksheet

2 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

3 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

4 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.

5 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.

6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

7 WO_ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Write Off Item

8 AR_WOAPPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved Write-Off
D=Denied Write-Off
I=Initial
P=Pending Write-Off Approval

9 REQ_WO_COMMENTS Long Character CLOB Requestor Write-off Comments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_WS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payment Worksheet Type C=Credit Card Worksheet E=ePayment Worksheet P=Payment Worksheet
2	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
3	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
4	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
5	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.
6	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
7	WO_ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Write Off Item
8	AR_WOAPPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved Write-Off D=Denied Write-Off I=Initial P=Pending Write-Off Approval
9	REQ_WO_COMMENTS	Long Character	CLOB	Requestor Write-off Comments