AR_SRCH_PMT_VW (SQL View)	Index Back
Payment view for Search Payment view used for search query (Payment Inquiry)

AR_SRCH_PMT_VW

(SQL View)

Payment view for Search

Payment view used for search query (Payment Inquiry)

SELECT a.deposit_bu , a.deposit_id , a.payment_seq_num , a.payment_id , b.oprid , b.assn_oprid , a.payment_status , a.accounting_dt , a.entry_dt , b.pay_ws_type , a.pp_sw , b.bank_setid , b.bank_cd , b.bnk_id_nbr , b.bank_acct_key , b.bank_account_num , b.deposit_status , a.payment_method , a.remit_from_cust_id , a.entry_event , a.oprid , a.last_update_dttm , a.oprid_last_updt FROM PS_PAYMENT a , ps_deposit_control b WHERE a.deposit_bu=b.deposit_bu AND a.deposit_id=b.deposit_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDE_NONVW

2 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.
Prompt Table: DEPOSIT_CONTROL

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

4 PAYMENT_ID Character(15) VARCHAR2(15) NOT NULL Identifies a customer payment. This is usually a check number but may be some other identifying number.

5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

6 ASSN_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.

7 PAYMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Applied
B=Bounced
C=Complete
E=Identified - Express
I=Identified
J=Directly Journalled
R=Unposted Direct Journal
U=Unidentified
W=Worksheet

8 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

9 ENTRY_DT Date(10) DATE Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).

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

11 PP_SW Character(1) VARCHAR2(1) NOT NULL Payment Predictor
Y/N Table Edit

12 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

13 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

14 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

15 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

16 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

17 DEPOSIT_STATUS Character(1) VARCHAR2(1) NOT NULL Deposit Status
A=Fully Applied
C=Complete
N=None Applied
P=Partially Applied

18 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

19 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer

20 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event

21 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID

22 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

23 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDE_NONVW
2	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. Prompt Table: DEPOSIT_CONTROL
3	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.
4	PAYMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifies a customer payment. This is usually a check number but may be some other identifying number.
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	ASSN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
7	PAYMENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Applied B=Bounced C=Complete E=Identified - Express I=Identified J=Directly Journalled R=Unposted Direct Journal U=Unidentified W=Worksheet
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
9	ENTRY_DT	Date(10)	DATE	Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
10	PAY_WS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payment Type C=Credit Card Worksheet E=ePayment Worksheet P=Payment Worksheet
11	PP_SW	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Y/N Table Edit
12	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
13	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
14	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
15	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
16	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
17	DEPOSIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Deposit Status A=Fully Applied C=Complete N=None Applied P=Partially Applied
18	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
19	REMIT_FROM_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Remit From Customer
20	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
21	OPRID2	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
22	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
23	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update