OPRIDRUN_CNTL_IDLM_BO008_B2_VW(SQL View) |
Index Back |
|---|---|
For PO Balance ReportFor PO Balance Report |
| SELECT D.OPRID , D.RUN_CNTL_ID , C.LM_ORG_DESCR , C.LM_ORGANIZATION_ID , C.LM_PO_ID , C.LM_PO_PURCHASE_DT , C.LM_AMT , C.CURRENCY_CD , C.LM_EXP_DT , C.LM_BALANCE_AMT , ' ' , C.LM_PO_NAME , R.LANGUAGE_CD FROM PS_LM_PO_ORG_SR_VW C , PS_LM_RUNCTL_FI D , PS_PRCSRUNCNTL R WHERE D.OPRID=R.OPRID AND D.RUN_CNTL_ID =R.RUN_CNTL_ID AND C.LM_OWNER_ID = 0 AND D.LM_PERSON_ID = 0 AND ( C.LM_ORG_TYPE = D.LM_ORG_TYPE_RPT OR D.LM_ORG_TYPE_RPT = 'ALL') AND ( C.LM_ORGANIZATION_ID = D.LM_ORGANIZATION_ID OR D.LM_ORGANIZATION_ID = 0) AND ( C.LM_PO_NAME = D.LM_PO_NAME OR D.LM_PO_NAME IS NULL OR D.LM_PO_NAME = ' ') AND ( C.LM_PO_PURCHASE_DT >= D.LM_PO_PURCHASE_DT OR D.LM_PO_PURCHASE_DT IS NULL) AND ( C.LM_EXP_DT >= D.LM_EXP_DT OR D.LM_EXP_DT IS NULL) |
| # | 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. |
| 13 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |