LM_ENRMT_PO_VW

(SQL View)
Index Back

SELECT LM_PO_ID , LM_PO_NAME , LM_PO_PURCHASE_DT , LM_EXP_DT , LM_AMT , LM_BALANCE_AMT , CURRENCY_CD , LM_CHARTFLD_TYPE , LM_CHARTFLD_VAL , LM_PO_USED , LM_OWNER_ID FROM PS_LM_ENRMT_PO_TBL

# 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_PO_NAME Character(20) VARCHAR2(20) NOT NULL PO Number field in the PO table.
3 LM_PO_PURCHASE_DT Date(10) DATE PO Purchase Date
4 LM_EXP_DT Date(10) DATE Expiry Date for PO, TUs.
5 LM_AMT Number(23,3) DECIMAL(22,3) NOT NULL Amount available
6 LM_BALANCE_AMT Number(22,2) DECIMAL(21,2) NOT NULL Balance Amount available for payment.
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 LM_CHARTFLD_TYPE Character(18) VARCHAR2(18) NOT NULL ChartField Type...One of 16 ChartFields.
9 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.
10 LM_PO_USED Character(1) VARCHAR2(1) NOT NULL Y/N value if a PO has been used
11 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID