BUSINESS_UNITDefault Value: RF_MATERIAL_HDR.BUSINESS_UNIT
Prompt Table: SP_BU_RF_NONVW
SO_IDINV_ITEM_IDPrompt Table: MASTER_ITM_VW3
RF_MAT_DTL_VW1(SQL View) |
Index Back |
|---|---|
Material DetailStores material line information when managing material. |
| SELECT A.BUSINESS_UNIT , A.MATERIAL_LINE , A.SO_ID , A.INV_ITEM_ID , A.REQUIRED_QTY , A.ORDERED_QTY , A.REQ_ID , A.MATERIAL_HDR , A.SYNCID , A.SYNCDTTM FROM PS_RF_MATERIAL_DTL A WHERE A.INV_ITEM_ID <> ' ' AND (A.REQUIRED_QTY <> 0 OR A.ORDERED_QTY <> 0) |
| # | 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 | MATERIAL_LINE | Number(5,0) | INTEGER NOT NULL | Material Line number when recording item usage on a service order. |
| 3 | SO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MASTER_ITM_VW3 |
| 5 | REQUIRED_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity required when performing a service. |
| 6 | ORDERED_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Item quantity ordered when recording item usage on a service order. |
| 7 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 8 | MATERIAL_HDR | Character(8) | VARCHAR2(8) NOT NULL | Header ID used when recording item usage on a service order. |
| 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 |