LM_LDGR_PYMT_VW (SQL View)	Index Back
Payment Detail View Sub-Ledger Payment Detail page

LM_LDGR_PYMT_VW

(SQL View)

Payment Detail View

Sub-Ledger Payment Detail page

SELECT A.LM_PYMT_ID , A.LM_ENRLMT_ID , A.LM_PYMT_MTHD , A.LM_PO_ID , A.EOEC_CCI_NUMBER , A.LM_CHECK_NO , A.CURRENCY_CD FROM PS_LM_ENPYMT_VW A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PYMT_ID Number(10,0) DECIMAL(10) NOT NULL Payment ID

2 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

3 LM_PYMT_MTHD Character(4) VARCHAR2(4) NOT NULL Payment Method. The payment method can be ChargeBack, Training Units
CASH=Cash
CHCK=Check
CHGB=ChargeBack
CRCD=Credit Card
NOAP=Not Applicable
PO=Purchase Order
SEL=Select...
TU=Training Units

4 LM_PO_ID Number(10,0) DECIMAL(10) NOT NULL Purchase Order Id. Unique key for purchase orders.

5 EOEC_CCI_NUMBER Character(200) VARCHAR2(200) NOT NULL Use in the Credit Card Number Capture Process

6 LM_CHECK_NO Character(15) VARCHAR2(15) NOT NULL Check No used for payment

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PYMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Payment ID
2	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
3	LM_PYMT_MTHD	Character(4)	VARCHAR2(4) NOT NULL	Payment Method. The payment method can be ChargeBack, Training Units CASH=Cash CHCK=Check CHGB=ChargeBack CRCD=Credit Card NOAP=Not Applicable PO=Purchase Order SEL=Select... TU=Training Units
4	LM_PO_ID	Number(10,0)	DECIMAL(10) NOT NULL	Purchase Order Id. Unique key for purchase orders.
5	EOEC_CCI_NUMBER	Character(200)	VARCHAR2(200) NOT NULL	Use in the Credit Card Number Capture Process
6	LM_CHECK_NO	Character(15)	VARCHAR2(15) NOT NULL	Check No used for payment
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code