PAYMENT_PSCT_VW

#	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_BUARDS_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.
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	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
6	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 Default Value: U
7	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 Default Value: CHK
8	ENTRY_DT	Date(10)	DATE NOT NULL	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). Default Value: %date
9	ACCOUNTING_DT	Date(10)	DATE NOT NULL	The accounting entry construction date for a given transaction (a generic field that crosses multiple Default Value: DEPOSIT_CONTROL.ACCOUNTING_DT
10	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
11	SEL_CUST_ID	Character(1)	VARCHAR2(1) NOT NULL	Select items via Customer ID Y/N Table Edit Default Value: N
12	SEL_PO	Character(1)	VARCHAR2(1) NOT NULL	Select items via Postal Y/N Table Edit Default Value: N
13	SEL_REMIT	Character(1)	VARCHAR2(1) NOT NULL	Select items via REMIT TO Y/N Table Edit Default Value: N
14	SEL_CORP_ACCT	Character(1)	VARCHAR2(1) NOT NULL	Select items via CORP ACCT Y/N Table Edit Default Value: N
15	SEL_MICR	Character(1)	VARCHAR2(1) NOT NULL	Select items via MICR ID Y/N Table Edit Default Value: N
16	SEL_OPEN_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Select items via OPEN ITEM Y/N Table Edit Default Value: N
17	SEL_DOCUMENT	Character(1)	VARCHAR2(1) NOT NULL	Select items via DOCUMENT Y/N Table Edit Default Value: N
18	ID_SEQ_CUST	Number(3,0)	SMALLINT NOT NULL	Sequence control for CUST ID
19	ID_SEQ_ITEM	Number(5,0)	INTEGER NOT NULL	Sequence control for ITEM
20	AMT_SEL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount selected
21	AMT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Adjusted
22	AMT_REM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Remaining
23	DISC_TAKEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Taken
24	DISC_EARNED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discounts Earned
25	DISC_UNEARNED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unearned Discounts
26	WS_COUNT	Number(5,0)	INTEGER NOT NULL	Worksheet Items
27	WS_DTTM	DateTime(26)	TIMESTAMP	Worksheet Created Date/Time
28	WS_SEQ_ITEM	Number(5,0)	INTEGER NOT NULL	Worksheet item sequence number
29	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal Default Value: N
30	DST_DT	Date(10)	DATE	Distribution Date
31	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
32	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
33	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
34	PP_SW	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Y/N Table Edit Default Value: N
35	DISC_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Discount used switch Y/N Table Edit Default Value: N
36	WO_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Write Off's Used Y/N Table Edit Default Value: N
37	WO_ADJ_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Write Off Adjustmet from WS Y/N Table Edit Default Value: N
38	WS_UPDATED_SW	Character(1)	VARCHAR2(1) NOT NULL	Worksheet updated switch Default Value: N
39	LOCKBOX_PYMNT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lockbox Payment Id
40	PP_METHOD	Character(15)	VARCHAR2(15) NOT NULL	Payment Predictor Method
41	ALGORITHM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Algorithm Group for Payment Predictor
42	WS_REF_MATCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Worksheet Reference Match Type E=Exact Match L=Like Match Default Value: E
43	ALGORITHM	Character(7)	VARCHAR2(7) NOT NULL	Algorithm Identifier
44	PAYMENT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different. Default Value: DEPOSIT_CONTROL.CONTROL_CURRENCY
45	PYMT_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate. Default Value: DEPOSIT_CONTROL.PYMT_RT_TYPE
46	PYMT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation. Default Value: DEPOSIT_CONTROL.PYMT_RATE_MULT
47	PYMT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation. Default Value: 1
48	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
49	PP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Status A=Applied N=Not Processed P=Processed W=Worksheet Generated Default Value: N
50	PP_RQ	Number(7,0)	INTEGER NOT NULL	Reference Qualifier Count
51	PP_RQ_HIT	Number(7,0)	INTEGER NOT NULL	Reference Qualifier Hits
52	APPLIED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Applied Operator
53	MISC_PAYMENT	Character(1)	VARCHAR2(1) NOT NULL	Journal Directly
54	MISC_DST_BAL	Character(1)	VARCHAR2(1) NOT NULL	Non Customer Dist Balanced C=Journal Complete I=Balanced N=No Distribution O=Out of Balance
55	CREATE_PEND_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Create Pending Items A=Do Not Post L=Batch Standard N=Batch Priority
56	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit