LM_LDGR_PYCB_VW

(SQL View)
Index Back

Payment Detail View

Sub-Ledger Payment Detail page

SELECT A.LM_PYMT_ID , A.LM_ENRLMT_ID , A.LM_PYMT_MTHD , A.LM_ACCOUNT , A.LM_ALTACCT , A.LM_OPERATING_UNIT , A.LM_FUND_CODE , A.LM_CLASS_FLD , A.LM_PROGRAM_CODE , A.LM_BUDGET_REF , A.LM_PRODUCT , A.LM_PROJECT_ID , A.LM_CHARTFIELD1 , A.LM_CHARTFIELD2 , A.LM_CHARTFIELD3 , A.LM_HR_DEPTID , A.CURRENCY_CD FROM PS_LM_SUBLEDGER A WHERE A.LM_DEBIT_CREDIT='DEB'

# 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_ACCOUNT Character(20) VARCHAR2(20) NOT NULL Account Chart Field
5 LM_ALTACCT Character(20) VARCHAR2(20) NOT NULL Alternate Account Chartfield
6 LM_OPERATING_UNIT Character(20) VARCHAR2(20) NOT NULL Operating Unit ChartField
7 LM_FUND_CODE Character(20) VARCHAR2(20) NOT NULL Fund Code
8 LM_CLASS_FLD Character(20) VARCHAR2(20) NOT NULL Class Chart Field
9 LM_PROGRAM_CODE Character(20) VARCHAR2(20) NOT NULL Program Chart Field
10 LM_BUDGET_REF Character(20) VARCHAR2(20) NOT NULL Budget Reference Chartfield
11 LM_PRODUCT Character(20) VARCHAR2(20) NOT NULL Product Chartfield
12 LM_PROJECT_ID Character(20) VARCHAR2(20) NOT NULL Project Chart Field
13 LM_CHARTFIELD1 Character(20) VARCHAR2(20) NOT NULL Chartfield 1
14 LM_CHARTFIELD2 Character(20) VARCHAR2(20) NOT NULL Chartfield 2
15 LM_CHARTFIELD3 Character(20) VARCHAR2(20) NOT NULL Chartfield 3
16 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code