LM_BO002_LG6_VW (SQL View)	Index Back
Payment Update Report view 6

LM_BO002_LG6_VW

(SQL View)

Payment Update Report view 6

SELECT A.OPRID , A.RUN_CNTL_ID , A.NAME , B.LM_ORG_DESCR , C.LM_PRG_LONG_NM , A.LM_PRG_REG_ID , A.LM_PYMT_ID , A.LM_SUBLEDGER_ID , A.LM_SUBLEDGR_LN_NUM , A.LM_SUBLEDG_GL_STAT , A.LM_SUBLEDGER , A.LM_PO_ID , ' ' , A.LM_PYMT_MTHD , A.LM_TU_POOL_ID , A.LM_TU_POOL_NAME , A.EOEC_CCI_NUMBER , A.CURRENCY_CD , A.LM_CHECK_NO , A.LM_GL_AMOUNT , A.LM_DEBIT_CREDIT , A.XLATLONGNAME FROM PS_LM_BO002_6_VW A , PS_LM_ORG_LANG_VW B , PS_LM_PRG_LANG C , PSXLATITEMLANG D WHERE A.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID AND A.LANGUAGE_CD=B.LANGUAGE_CD AND A.LM_PRG_ID=C.LM_PRG_ID AND A.LANGUAGE_CD=C.LANGUAGE_CD AND A.LANGUAGE_CD=D.LANGUAGE_CD AND D.FIELDNAME='LM_SUBLEDG_GL_STAT' AND D.FIELDVALUE=A.LM_SUBLEDG_GL_STAT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description

5 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name

6 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

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

8 LM_SUBLEDGER_ID Number(15,0) DECIMAL(15) NOT NULL Sub-Ledger ID. System Generated.

9 LM_SUBLEDGR_LN_NUM Number(20,0) DECIMAL(20) NOT NULL Subledger Line Number

10 LM_SUBLEDG_GL_STAT Character(3) VARCHAR2(3) NOT NULL Subledger Flag is used on the ELM Subledger. It indicates if a row on the Subledger has already been sent to GL.
ERR=Error
OLD=History Item Not Posted
PEN=Pending
POS=Posted
UPD=Updated Since Posting

11 LM_SUBLEDGER Character(15) VARCHAR2(15) NOT NULL The name of the Sub-Ledger.

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

13 LM_PO_NAME Character(20) VARCHAR2(20) NOT NULL PO Number field in the PO table.

14 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

15 LM_TU_POOL_ID Number(10,0) DECIMAL(10) NOT NULL Training Unit Pool No. Unique key for Training Unit Pool Record.

16 LM_TU_POOL_NAME Character(20) VARCHAR2(20) NOT NULL Training Unit Pool

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

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

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

20 LM_GL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL GL Amount

21 LM_DEBIT_CREDIT Character(3) VARCHAR2(3) NOT NULL Debit or Credit Indicator
CRD=Credit
DEB=Debit

22 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	LM_ORG_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Customer Description
5	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
6	LM_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
7	LM_PYMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Payment ID
8	LM_SUBLEDGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Sub-Ledger ID. System Generated.
9	LM_SUBLEDGR_LN_NUM	Number(20,0)	DECIMAL(20) NOT NULL	Subledger Line Number
10	LM_SUBLEDG_GL_STAT	Character(3)	VARCHAR2(3) NOT NULL	Subledger Flag is used on the ELM Subledger. It indicates if a row on the Subledger has already been sent to GL. ERR=Error OLD=History Item Not Posted PEN=Pending POS=Posted UPD=Updated Since Posting
11	LM_SUBLEDGER	Character(15)	VARCHAR2(15) NOT NULL	The name of the Sub-Ledger.
12	LM_PO_ID	Number(10,0)	DECIMAL(10) NOT NULL	Purchase Order Id. Unique key for purchase orders.
13	LM_PO_NAME	Character(20)	VARCHAR2(20) NOT NULL	PO Number field in the PO table.
14	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
15	LM_TU_POOL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Training Unit Pool No. Unique key for Training Unit Pool Record.
16	LM_TU_POOL_NAME	Character(20)	VARCHAR2(20) NOT NULL	Training Unit Pool
17	EOEC_CCI_NUMBER	Character(200)	VARCHAR2(200) NOT NULL	Use in the Credit Card Number Capture Process
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	LM_CHECK_NO	Character(15)	VARCHAR2(15) NOT NULL	Check No used for payment
20	LM_GL_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	GL Amount
21	LM_DEBIT_CREDIT	Character(3)	VARCHAR2(3) NOT NULL	Debit or Credit Indicator CRD=Credit DEB=Debit
22	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name