PO_RCVWB_UPN_VW(SQL View) |
Index Back |
|---|---|
Receiver Workbench Search ViewReceiver Workbench Data Search View |
| SELECT A.BUSINESS_UNIT ,A.RECEIVER_ID ,B.RECV_LN_NBR ,B.BUSINESS_UNIT_PO ,A.RECV_STATUS ,A.PO_RECEIPT_FLG ,B.PO_ID ,B.INV_ITEM_ID ,B.DESCR254_MIXED ,B.MFG_ITM_ID ,B.UPN_ID FROM PS_RECV_HDR A , PS_RECV_LN_SHIP B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.RECEIVER_ID=B.RECEIVER_ID AND B.UPN_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_PM |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 5 | RECV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled |
| 6 | PO_RECEIPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
PO Receipt Flag - identifies if the receipt is related to a purchase order
Y/N Table Edit Default Value: Y |
| 7 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table: PO_HDR_RC_WB_VW |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: ITM_PURCH_VW |
| 9 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 10 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
Prompt Table: ITM_MFG_ID_VW |
| 11 | UPN_ID |
Character(20) | VARCHAR2(20) NOT NULL | Universal Product Number |