LM_BO002_UN3_VW

#	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