AR_REMIT_CU_VW (SQL View)	Index Back
AR Payload IDCust Payload customer remittence data

AR_REMIT_CU_VW

(SQL View)

AR Payload IDCust

Payload customer remittence data

SELECT C.AR_REMIT_STATUS , C.EIP_CTL_ID , C.LB_BANK_TRANS_ID , C.LOCKBOX_ID , C.LOCKBOX_BATCH_ID , C.PAYMENT_SEQ_NUM , C.ID_SEQ_NUM , C.BUSINESS_UNIT , C.CUST_ID , C.NAME1 , C.CITY , C.POSTAL , C.REMIT_FROM_SETID , C.REMIT_FROM_CUST_ID , C.CORPORATE_SETID , C.CORPORATE_CUST_ID , C.MICR_ID , C.DB_NUMBER , C.PROCESS_INSTANCE , C.DFI_ID_QUAL , C.DFI_ID_NUM , C.BNK_ID_NBR , C.BANK_ACCOUNT_NUM , C.EDI_TRACE_NBR , C.PAYMENT_AMT , C.ACCOUNTING_DT , C.PAYMENT_ID , C.DUPLICATE_CNT , P.PAYMENT_CURRENCY FROM PS_AR_IDCUST_EC C , PS_AR_PAYMENT_EC P WHERE C.PROCESS_INSTANCE = 0 AND %Join(COMMON_KEYS, AR_PAYMENT_EC P, AR_IDCUST_EC C)

# 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
Default Value: AR_REMIT_CU_VW1.AR_REMIT_STATUS
Prompt Table: AR_REMIT_CU_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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

11 CITY Character(30) VARCHAR2(30) NOT NULL City

12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

13 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

15 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID

16 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer

17 MICR_ID Character(30) VARCHAR2(30) NOT NULL MICR ID

18 DB_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number

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

20 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined

21 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun

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

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

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

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

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

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

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

29 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 Default Value: AR_REMIT_CU_VW1.AR_REMIT_STATUS Prompt Table: AR_REMIT_CU_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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	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.
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
11	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
12	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
13	REMIT_FROM_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
14	REMIT_FROM_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Remit From Customer
15	CORPORATE_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
16	CORPORATE_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Corporate Customer
17	MICR_ID	Character(30)	VARCHAR2(30) NOT NULL	MICR ID
18	DB_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
19	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
20	DFI_ID_QUAL	Character(2)	VARCHAR2(2) NOT NULL	A banking industry convention identifier utilized to drive data validation for a given bank/counterparty. 01=Transit Number 02=Swift ID/BIC 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined
21	DFI_ID_NUM	Character(12)	VARCHAR2(12) NOT NULL	A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
22	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
23	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
24	EDI_TRACE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	EDI Trace Number
25	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
26	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
27	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.
28	DUPLICATE_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Duplicate count
29	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.