RF_MAT_DTL_VW

(SQL View)
 Index Back

Material Detail

Stores material line information when managing material.

SELECT A.BUSINESS_UNIT , A.SO_ID , A.INV_ITEM_ID , A.REQUIRED_QTY , A.ORDERED_QTY , A.REQ_ID , A.MATERIAL_HDR , SUM(B.QTY_SERLOT) , A.SYNCID , A.SYNCDTTM FROM PS_RF_MAT_DTL_VW1 A , PS_RF_MATRECSER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT(+) AND A.MATERIAL_HDR = B.MATERIAL_HDR(+) AND A.MATERIAL_LINE = B.MATERIAL_LINE(+) AND A.INV_ITEM_ID = B.INV_ITEM_ID(+) GROUP BY A.BUSINESS_UNIT , A.SO_ID , A.INV_ITEM_ID , A.REQUIRED_QTY , A.ORDERED_QTY , A.REQ_ID , A.MATERIAL_HDR , A.SYNCID , A.SYNCDTTM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: RF_MATERIAL_HDR.BUSINESS_UNIT

Prompt Table: SP_BU_RF_NONVW

2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MASTER_ITM_VW3

4 REQUIRED_QTY Number(16,4) DECIMAL(15,4) NOT NULL Quantity required when performing a service.
5 ORDERED_QTY Number(16,4) DECIMAL(15,4) NOT NULL Item quantity ordered when recording item usage on a service order.
6 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
7 MATERIAL_HDR Character(8) VARCHAR2(8) NOT NULL Header ID used when recording item usage on a service order.
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 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time