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 |