LM_BO008_UN2_VW

(SQL View)
 Index Back

For PO Balance Report

For PO Balance Report

SELECT A.OPRID , A.RUN_CNTL_ID , A.LM_ORG_DESCR , A.LM_ORGANIZATION_ID , A.LM_PO_ID , A.LM_PO_PURCHASE_DT , A.LM_AMT , A.CURRENCY_CD , A.LM_EXP_DT , A.LM_BALANCE_AMT , ' ' , A.LM_PO_NAME FROM PS_LM_BO008_B2_VW A , PSOPTIONS B WHERE A.LANGUAGE_CD = B.LANGUAGE_CD

# 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 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
4 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
5 LM_PO_ID Number(10,0) DECIMAL(10) NOT NULL Purchase Order Id. Unique key for purchase orders.
6 LM_PO_PURCHASE_DT Date(10) DATE PO Purchase Date
7 LM_AMT Number(23,3) DECIMAL(22,3) NOT NULL Amount available
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 LM_EXP_DT Date(10) DATE Expiry Date for PO, TUs.
10 LM_BALANCE_AMT Number(22,2) DECIMAL(21,2) NOT NULL Balance Amount available for payment.
11 NAME Character(50) VARCHAR2(50) NOT NULL Name
12 LM_PO_NAME Character(20) VARCHAR2(20) NOT NULL PO Number field in the PO table.