LM_PYMT_IDLM_ENRLMT_IDLM_LDGR_CRIT_VW(SQL View) |
Index Back |
|---|---|
Credit Detail ViewSub-Ledger Credit Detail page |
| SELECT DISTINCT B.LM_PYMT_ID , B.LM_ENRLMT_ID , B.LM_ACCOUNT , B.LM_ALTACCT , B.LM_OPERATING_UNIT , B.LM_FUND_CODE , B.LM_CLASS_FLD , B.LM_PROGRAM_CODE , B.LM_BUDGET_REF , B.LM_PRODUCT , B.LM_PROJECT_ID , B.LM_CHARTFIELD1 , B.LM_CHARTFIELD2 , B.LM_CHARTFIELD3 , B.LM_HR_DEPTID FROM PS_LM_SUBLEDGER B WHERE B.LM_DEBIT_CREDIT='CRD' |
| # | 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_ACCOUNT | Character(20) | VARCHAR2(20) NOT NULL | Account Chart Field |
| 4 | LM_ALTACCT | Character(20) | VARCHAR2(20) NOT NULL | Alternate Account Chartfield |
| 5 | LM_OPERATING_UNIT | Character(20) | VARCHAR2(20) NOT NULL | Operating Unit ChartField |
| 6 | LM_FUND_CODE | Character(20) | VARCHAR2(20) NOT NULL | Fund Code |
| 7 | LM_CLASS_FLD | Character(20) | VARCHAR2(20) NOT NULL | Class Chart Field |
| 8 | LM_PROGRAM_CODE | Character(20) | VARCHAR2(20) NOT NULL | Program Chart Field |
| 9 | LM_BUDGET_REF | Character(20) | VARCHAR2(20) NOT NULL | Budget Reference Chartfield |
| 10 | LM_PRODUCT | Character(20) | VARCHAR2(20) NOT NULL | Product Chartfield |
| 11 | LM_PROJECT_ID | Character(20) | VARCHAR2(20) NOT NULL | Project Chart Field |
| 12 | LM_CHARTFIELD1 | Character(20) | VARCHAR2(20) NOT NULL | Chartfield 1 |
| 13 | LM_CHARTFIELD2 | Character(20) | VARCHAR2(20) NOT NULL | Chartfield 2 |
| 14 | LM_CHARTFIELD3 | Character(20) | VARCHAR2(20) NOT NULL | Chartfield 3 |
| 15 | LM_HR_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |