LM_ENPYMT_VW

#	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_ENRLMT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Type could be activity, curriculum or adhoc learning ACT=Activity Enrollment ADH=Adhoc Enrollment CUR=Curriculum Enrollment
4	LM_PO_ID	Number(10,0)	DECIMAL(10) NOT NULL	Purchase Order Id. Unique key for purchase orders.
5	LM_DT_PYMT_RECV	DateTime(26)	TIMESTAMP	Date on which the payment was received
6	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
7	LM_TU_POOL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Training Unit Pool No. Unique key for Training Unit Pool Record.
8	LM_PYMT_STTS	Character(4)	VARCHAR2(4) NOT NULL	Payment Status. Can be Paid, Unpaid, Await Authorization, Refund Due, Refunded AWAT=Await Authorization NOAP=Not Applicable PAID=Paid RFDD=Refunded RFDE=Refund Due UNPD=Unpaid
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
11	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
12	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
13	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
14	LM_SUBLEDGER_STAT	Character(3)	VARCHAR2(3) NOT NULL	Sub Ledger Flag is used in payment table(LM_ENRLMT_PYMT). Its used by Financial Integration team for posting items to the Sub Ledger. PEN=Pending POS=Posted UPD=Updated
15	EOEC_CCI_NUMBER	Character(200)	VARCHAR2(200) NOT NULL	Use in the Credit Card Number Capture Process
16	EOEC_CCI_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Credit Card Name Prompt Table: EOEC_CCI_TP_VW
17	EOEC_CCI_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold Credit Card Status. Valid Values 1. Active 2. Inactive A=Active I=Inactive Default Value: A
18	EOEC_CCI_FNAME	Character(60)	VARCHAR2(60) NOT NULL	Use in the Credit Card Number Capture Process
19	EOEC_CCI_LNAME	Character(60)	VARCHAR2(60) NOT NULL	Use in the Credit Card Number Capture Process
20	EOEC_CCI_APPEARS	Character(80)	VARCHAR2(80) NOT NULL	Hold Credit Card Name as it appears in the Card
21	EOEC_CCI_EXPMO	Character(2)	VARCHAR2(2) NOT NULL	Credit Card Expiry Month 01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December
22	EOEC_CCI_EXPYR	Character(4)	VARCHAR2(4) NOT NULL	Use in the Credit Card Number Capture Process 2008=2008 2009=2009 2010=2010 2011=2011 2012=2012 2013=2013 2014=2014 2015=2015 2016=2016 2017=2017 2018=2018 2019=2019
23	EOEC_CCI_4DIGITS	Character(4)	VARCHAR2(4) NOT NULL	Use in the Credit Card Number Capture Process
24	EOEC_CCI_AUTH	Number(5,0)	INTEGER NOT NULL	Holds Credit Card Authorization Number. Few credit cards have some extra numbers, which is required for authoization.
25	EOEC_CCI_CVNUM	Character(4)	VARCHAR2(4) NOT NULL	Card Verification Number
26	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Business Unit
27	LM_ACCOUNT	Character(20)	VARCHAR2(20) NOT NULL	Account Chart Field Prompt Table: %EDITTABLE9
28	LM_ALTACCT	Character(20)	VARCHAR2(20) NOT NULL	Alternate Account Chartfield Prompt Table: %EDITTABLE11
29	LM_BUDGET_REF	Character(20)	VARCHAR2(20) NOT NULL	Budget Reference Chartfield Prompt Table: %EDITTABLE13
30	LM_CHARTFIELD1	Character(20)	VARCHAR2(20) NOT NULL	Chartfield 1 Prompt Table: %EDITTABLE15
31	LM_CHARTFIELD2	Character(20)	VARCHAR2(20) NOT NULL	Chartfield 2 Prompt Table: %EDITTABLE16
32	LM_CHARTFIELD3	Character(20)	VARCHAR2(20) NOT NULL	Chartfield 3 Prompt Table: %EDITTABLE17
33	LM_CLASS_FLD	Character(20)	VARCHAR2(20) NOT NULL	Class Chart Field Prompt Table: %EDITTABLE7
34	LM_FUND_CODE	Character(20)	VARCHAR2(20) NOT NULL	Fund Code Prompt Table: %EDITTABLE6
35	LM_HR_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: LM_DEPT_CF_VW
36	LM_OPERATING_UNIT	Character(20)	VARCHAR2(20) NOT NULL	Operating Unit ChartField Prompt Table: %EDITTABLE12
37	LM_PRODUCT	Character(20)	VARCHAR2(20) NOT NULL	Product Chartfield Prompt Table: %EDITTABLE14
38	LM_PROGRAM_CODE	Character(20)	VARCHAR2(20) NOT NULL	Program Chart Field Prompt Table: %EDITTABLE8
39	LM_PROJECT_ID	Character(20)	VARCHAR2(20) NOT NULL	Project Chart Field Prompt Table: %EDITTABLE10
40	LM_SPLIT	Number(3,0)	SMALLINT NOT NULL	Split Percentage. The user can split theFee across various Department / Account Codes
41	LM_CHECK_NO	Character(15)	VARCHAR2(15) NOT NULL	Check No used for payment
42	LM_ROUTING_NO	Character(15)	VARCHAR2(15) NOT NULL	Routing No of the check
43	LM_BANK_NAME	Character(80)	VARCHAR2(80) NOT NULL	Bank Name of the check used.
44	LM_CHECK_DATE	Date(10)	DATE	Check Issue Date
45	LM_CHECK_EXP_DATE	Date(10)	DATE	Check Expiry Date.
46	LM_CURR_PYMT	Character(1)	VARCHAR2(1) NOT NULL	Current Payment Flag. Only the Current Payment Flag that is true will be retrieved for diaply on payment details page.
47	LM_AMT_PAID	Number(23,3)	DECIMAL(22,3) NOT NULL	Amount Paid so far towards the Enrollment Fee
48	LM_PAID_DP_CHGES	Number(23,3)	DECIMAL(22,3) NOT NULL	Drop Charges
49	LM_PAID_TUS	Number(14,3)	DECIMAL(13,3) NOT NULL	No of Training Units available/used.
50	LM_PAID_DP_TUS	Number(14,3)	DECIMAL(13,3) NOT NULL	No of Training Units available/used.
51	LM_AUTH_CODE	Character(30)	VARCHAR2(30) NOT NULL	Authorization Code to store credit card auth codes.