OPRIDRUN_CNTL_IDERR=Error
OLD=History Item Not Posted
PEN=Pending
POS=Posted
UPD=Updated Since Posting
CASH=Cash
CHCK=Check
CHGB=ChargeBack
CRCD=Credit Card
NOAP=Not Applicable
PO=Purchase Order
SEL=Select...
TU=Training Units
CRD=Credit
DEB=Debit
LM_BO002_LG1_VW(SQL View) |
Index Back |
|---|---|
Payment Update Report view 1 |
| SELECT B0002.OPRID , B0002.RUN_CNTL_ID , B0002.NAME , ORGLNG.LM_ORG_DESCR , ACTCI.LM_CS_LONG_NM , B0002.LM_ENRLMT_ID , B0002.LM_PYMT_ID , B0002.LM_SUBLEDGER_ID , B0002.LM_SUBLEDGR_LN_NUM , B0002.LM_SUBLEDG_GL_STAT , B0002.LM_SUBLEDGER , B0002.LM_PO_ID , ' ' , B0002.LM_PYMT_MTHD , B0002.LM_TU_POOL_ID , ' ' , B0002.EOEC_CCI_NUMBER , B0002.CURRENCY_CD , B0002.LM_CHECK_NO , B0002.LM_GL_AMOUNT , B0002.LM_DEBIT_CREDIT , XLAT.XLATLONGNAME FROM PS_LM_BO002_1_VW B0002 , PS_LM_ORG_LANG_VW ORGLNG , PS_LM_ACT_CI_LVW ACTCI , PSXLATITEMLANG XLAT WHERE B0002.LM_ORGANIZATION_ID = ORGLNG.LM_ORGANIZATION_ID AND B0002.LANGUAGE_CD = ORGLNG.LANGUAGE_CD AND B0002.LM_ACT_ID = ACTCI.LM_ACT_ID AND B0002.LANGUAGE_CD = ACTCI.LANGUAGE_CD AND B0002.LANGUAGE_CD = XLAT.LANGUAGE_CD AND XLAT.FIELDNAME = 'LM_SUBLEDG_GL_STAT' AND XLAT.FIELDVALUE = B0002.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_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 6 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 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 |