RF_MATNUSSER_VW

(SQL View)
 Index Back

Received Material View

This is a view on the received material table to be used for populating the material usage grid on the service order.

SELECT BUSINESS_UNIT , SO_ID , SO_LINE , MATERIAL_HDR , MATERIAL_LINE , RECEIVED_ITEM_ID , SEQNO , QTY_SERLOT , SERIAL_ID , LOT_ID , USAGE_ACTION , PERSON_ID , PO_ID , LINE_NBR , INTERUNIT_ID , INTERUNIT_LINE FROM PS_RF_MATNUSSER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
3 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.
4 MATERIAL_HDR Character(8) VARCHAR2(8) NOT NULL Header ID used when recording item usage on a service order.
5 MATERIAL_LINE Number(5,0) INTEGER NOT NULL Material Line number when recording item usage on a service order.
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MASTER_ITM_VW3

7 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
8 QTY_SERLOT Number(16,4) DECIMAL(15,4) NOT NULL Quantity entered on Manage Material when recording new item or item removal usage.
9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
10 LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
11 USAGE_ACTION Character(4) VARCHAR2(4) NOT NULL This field displays the actions the use can select for Material Usage on the Service Order.
1=Used
2=Removed
3=Not Used
12 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RF_SOLN_ASS_VW

13 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
14 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
15 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL This field is used to store the interunit id associated with material that was ordered.
16 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line