LM_LDGR_PYCB_VW(SQL View) |
Index Back |
---|---|
Payment Detail ViewSub-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 |