BUSINESS_UNIT_RECVDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
RECEIVER_IDPrompt Table: VENDOR_POVW1
RECV_AM_VW(SQL View) |
Index Back |
|---|---|
Receipt Line AM View |
| SELECT DISTINCT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECEIPT_DT , A.VENDOR_ID FROM PS_RECV_HDR A , PS_VENDOR B , PS_RECV_LN_ASSET 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 AND C.BUSINESS_UNIT_AM <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RECV |
Character(5) | VARCHAR2(5) NOT NULL |
Receiving Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_POVW1 |