RECV_UPD_SRCH(SQL View) |
Index Back |
|---|---|
Receipt Update Search |
| SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.BILL_OF_LADING , C.BUSINESS_UNIT_PO , C.DESCR254_MIXED , C.INV_ITEM_ID , A.ORIGIN , C.PO_ID , A.PO_RECEIPT_FLG , A.VENDOR_SETID , A.SHIPTO_ID , A.SHIPMENT_NO , A.VENDOR_ID , B.NAME1 , A.RECEIPT_DT , A.RECV_STATUS , C.REVISION FROM PS_RECV_HDR A , PS_VENDOR B , PS_RECV_LN_SHIP C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RECEIVER_ID = C.RECEIVER_ID AND A.RECV_STATUS NOT IN ('C','X') AND A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_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_PM.BUSINESS_UNIT_RECV Prompt Table: SP_BU_PM_NONVW |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Receiver number
Default Value: NEXT |
| 3 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 4 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 5 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: ITM_PURCH_VW |
| 7 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
| 8 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table: RECV_PO_HDR_VW |
| 9 | PO_RECEIPT_FLG | Character(1) | VARCHAR2(1) NOT NULL | PO Receipt Flag - identifies if the receipt is related to a purchase order |
| 10 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 11 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIPTO_TBL |
| 12 | SHIPMENT_NO | Character(30) | VARCHAR2(30) NOT NULL | Shipment Number |
| 13 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_VW |
| 14 | VENDOR_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Vendor Name1 |
| 15 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 16 | 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 |
| 17 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |