AP_RECVASST_VW(SQL View) |
Index Back |
|---|---|
Vouchers with ReceitpsVouchers with Receipt Lines |
| SELECT A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.RECV_DIST_LINE_NUM , A.DISTRIB_SEQ_NUM , A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM FROM PS_DISTRIB_LINE B , PS_VCHR_DIST_ASSET A , PS_VOUCHER C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM AND A.DISTRIB_LINE_NUM = B.DISTRIB_LINE_NUM AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.VOUCHER_ID = B.VOUCHER_ID AND C.ENTRY_STATUS <> 'X' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 2 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 5 | RECV_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Receiver Distrib Line |
| 6 | DISTRIB_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 9 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 10 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |