LM_PO_OWNER_VW (SQL View)	Index Back
Purchase Order(Method of Pymt) Purchase Order is a method of payment. It can be used for payments during enrollment of activities.

LM_PO_OWNER_VW

(SQL View)

Purchase Order(Method of Pymt)

Purchase Order is a method of payment. It can be used for payments during enrollment of activities.

SELECT A.LM_PO_ID , B.LM_MOP_OWNER_ID , B.LM_MOP_OWNER_TYPE , A.LM_PO_NAME , A.LM_PO_PURCHASE_DT , A.LM_EXP_DT , A.LM_AMT , A.LM_BALANCE_AMT , A.CURRENCY_CD , A.LM_CHARTFLD_TYPE , A.LM_CHARTFLD_VAL , A.LM_PO_USED ,A.LM_OWNER_ID , %subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_ENRMT_PO_TBL A , PS_LM_MOP_OWNR_TBL B WHERE A.LM_PO_ID = B.LM_MOP_ID AND B.LM_MOP_TYPE = 'PO'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PO_ID Number(10,0) DECIMAL(10) NOT NULL Purchase Order Id. Unique key for purchase orders.

2 LM_MOP_OWNER_ID Number(10,0) DECIMAL(10) NOT NULL Method of Payment Owner. Owner could be Organization, Person, Learning Environment etc.

3 LM_MOP_OWNER_TYPE Character(3) VARCHAR2(3) NOT NULL Method of Payment Owner Type. In 8.9, it could be organization, LE, Person etc.
LEV=Learning Environment
ORG=Organization
PER=Person

4 LM_PO_NAME Character(20) VARCHAR2(20) NOT NULL PO Number field in the PO table.

5 LM_PO_PURCHASE_DT Date(10) DATE PO Purchase Date

6 LM_EXP_DT Date(10) DATE Expiry Date for PO, TUs.

7 LM_AMT Number(23,3) DECIMAL(22,3) NOT NULL Amount available

8 LM_BALANCE_AMT Number(22,2) DECIMAL(21,2) NOT NULL Balance Amount available for payment.

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 LM_CHARTFLD_TYPE Character(18) VARCHAR2(18) NOT NULL ChartField Type...One of 16 ChartFields.

11 LM_CHARTFLD_VAL Character(20) VARCHAR2(20) NOT NULL ChartField Value...Depending on ChartField Type, it would store one of the 16 Chartfield values supported.

12 LM_PO_USED Character(1) VARCHAR2(1) NOT NULL Y/N value if a PO has been used

13 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID

14 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

15 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By

16 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

17 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PO_ID	Number(10,0)	DECIMAL(10) NOT NULL	Purchase Order Id. Unique key for purchase orders.
2	LM_MOP_OWNER_ID	Number(10,0)	DECIMAL(10) NOT NULL	Method of Payment Owner. Owner could be Organization, Person, Learning Environment etc.
3	LM_MOP_OWNER_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Method of Payment Owner Type. In 8.9, it could be organization, LE, Person etc. LEV=Learning Environment ORG=Organization PER=Person
4	LM_PO_NAME	Character(20)	VARCHAR2(20) NOT NULL	PO Number field in the PO table.
5	LM_PO_PURCHASE_DT	Date(10)	DATE	PO Purchase Date
6	LM_EXP_DT	Date(10)	DATE	Expiry Date for PO, TUs.
7	LM_AMT	Number(23,3)	DECIMAL(22,3) NOT NULL	Amount available
8	LM_BALANCE_AMT	Number(22,2)	DECIMAL(21,2) NOT NULL	Balance Amount available for payment.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	LM_CHARTFLD_TYPE	Character(18)	VARCHAR2(18) NOT NULL	ChartField Type...One of 16 ChartFields.
11	LM_CHARTFLD_VAL	Character(20)	VARCHAR2(20) NOT NULL	ChartField Value...Depending on ChartField Type, it would store one of the 16 Chartfield values supported.
12	LM_PO_USED	Character(1)	VARCHAR2(1) NOT NULL	Y/N value if a PO has been used
13	LM_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Owner ID
14	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
15	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
16	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
17	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid