BUSINESS_UNITINV_CART_IDINV_ITEM_IDLOCATIONPrompt Table: UNITS_TBL
PO_RECTNTFY_EVW(SQL View) |
Index Back |
|---|---|
Receipt Push notify msg viewUsed for creating PO Receipt Notification Message Definition. |
| SELECT BUSINESS_UNIT ,INV_CART_ID ,INV_ITEM_ID ,LOCATION ,CONVERSION_RATE ,QTY_SH_ACCPT_SUOM ,RECEIVE_UOM ,UNIT_MEASURE_STD ,PROCESS_INSTANCE FROM PS_RECV_PUSH_NTFY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_CART_ID |
Character(15) | VARCHAR2(15) NOT NULL | Par Location ID |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 5 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 6 | QTY_SH_ACCPT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Accepted Quantity |
| 7 | RECEIVE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Receipt Unit of Measure
Prompt Table: UNITS_TBL |
| 8 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 9 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |