AR_REMIT_VW (SQL View)	Index Back
AR Unmatched/Duplicate Remits

AR_REMIT_VW

(SQL View)

AR Unmatched/Duplicate Remits

SELECT I.AR_REMIT_STATUS , I.EIP_CTL_ID , I.LB_BANK_TRANS_ID , I.LOCKBOX_ID , I.LOCKBOX_BATCH_ID , I.PAYMENT_SEQ_NUM , I.ID_SEQ_NUM , I.PAY_AMT , I.ITEM_AMT , I.ITEM_DT , I.BUSINESS_UNIT , I.CUST_ID , I.DISC_TAKEN , I.ADJUSTMENT_AMT , I.ADJUSTMENT_REASON , I.REF_QUALIFIER_CODE , I.REF_VALUE , I.PROCESS_INSTANCE , I.EDI_TRACE_NBR , I.PAYMENT_AMT , I.ACCOUNTING_DT , I.PAYMENT_ID , I.DUPLICATE_CNT , P.PAYMENT_CURRENCY FROM PS_AR_IDITEM_EC I , PS_AR_PAYMENT_EC P WHERE I.PROCESS_INSTANCE=0 AND %Join(COMMON_KEYS, AR_PAYMENT_EC P, AR_IDITEM_EC I)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AR_REMIT_STATUS Character(1) VARCHAR2(1) NOT NULL Remittance process status
B=Duplicate Pay and Remit
D=Duplicate Match
N=Not Processed
P=Duplicate Payments
R=Duplicate Remittances
U=Unmatched
Prompt Table: AR_REMIT_VW1

2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

3 LB_BANK_TRANS_ID Character(20) VARCHAR2(20) NOT NULL Bank Transmission ID

4 LOCKBOX_ID Character(15) VARCHAR2(15) NOT NULL Lockbox ID

5 LOCKBOX_BATCH_ID Character(5) VARCHAR2(5) NOT NULL Lockbox Batch Id

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

7 ID_SEQ_NUM Number(5,0) INTEGER NOT NULL Identification Sequence number

8 PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount

9 ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

10 ITEM_DT Date(10) DATE Item Date

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

13 DISC_TAKEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Taken

14 ADJUSTMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Amount

15 ADJUSTMENT_REASON Character(2) VARCHAR2(2) NOT NULL Adjustment Reason

16 REF_QUALIFIER_CODE Character(2) VARCHAR2(2) NOT NULL Reference Qualifier Code

17 REF_VALUE Character(30) VARCHAR2(30) NOT NULL Reference

18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

19 EDI_TRACE_NBR Number(10,0) DECIMAL(10) NOT NULL EDI Trace Number

20 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.

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

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

23 DUPLICATE_CNT Number(10,0) DECIMAL(10) NOT NULL Duplicate count

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AR_REMIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Remittance process status B=Duplicate Pay and Remit D=Duplicate Match N=Not Processed P=Duplicate Payments R=Duplicate Remittances U=Unmatched Prompt Table: AR_REMIT_VW1
2	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
3	LB_BANK_TRANS_ID	Character(20)	VARCHAR2(20) NOT NULL	Bank Transmission ID
4	LOCKBOX_ID	Character(15)	VARCHAR2(15) NOT NULL	Lockbox ID
5	LOCKBOX_BATCH_ID	Character(5)	VARCHAR2(5) NOT NULL	Lockbox Batch Id
6	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.
7	ID_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Identification Sequence number
8	PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
9	ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
10	ITEM_DT	Date(10)	DATE	Item Date
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	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.
13	DISC_TAKEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Taken
14	ADJUSTMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Amount
15	ADJUSTMENT_REASON	Character(2)	VARCHAR2(2) NOT NULL	Adjustment Reason
16	REF_QUALIFIER_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reference Qualifier Code
17	REF_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Reference
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	EDI_TRACE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	EDI Trace Number
20	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
21	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
22	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.
23	DUPLICATE_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Duplicate count
24	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.