RECV_INSPSEL_VW(SQL View) |
Index Back |
|---|---|
Receipt Inspect Selection View |
| SELECT l.shipto_id , l.business_unit , l.receiver_id , l.recv_ln_nbr , l.business_unit_po , l.currency_cd , l.descr254_mixed , l.inspect_cd , l.inspect_dttm , l.inspect_status , l.inv_item_id , l.ITM_ID_VNDR , l.itm_setid , l.line_nbr , l.mfg_id , l.MFG_ITM_ID , l.move_stat_inv , v.name1 , l.po_id , l.price_po , l.process_complete , l.qty_ln_inv_suom , l.qty_sh_accpt , l.qty_sh_accpt_suom , l.qty_sh_accpt_vuom , l.qty_sh_inspd , l.qty_sh_inspd_suom , l.qty_sh_inspd_vuom , l.qty_sh_recvd , l.qty_sh_recvd_suom , l.qty_sh_recvd_vuom , l.qty_sh_rejct , l.qty_sh_rejct_suom , l.qty_sh_rejct_vuom , l.qty_sh_rtn , l.qty_sh_rtn_suom , l.qty_sh_rtn_vuom , l.receipt_dttm , l.receipt_um , l.receive_uom , l.recv_ship_status , l.recv_stock_uom , l.revision , l.sched_nbr , l.unit_measure_std , h.vendor_id , v.vendor_name_short , h.vendor_setid , s.ship_type_id FROM ps_recv_ln_ship l JOIN ps_recv_hdr h ON h.business_unit = l.business_unit AND h.receiver_id = l.receiver_id JOIN ps_vendor v ON h.vendor_setid = v.setid AND h.vendor_id = v.vendor_id LEFT OUTER JOIN PS_PO_LINE_SHIP s ON s.business_unit = l.business_unit AND S.po_id = l.po_id AND S.LINE_NBR = L.LINE_NBR AND S.SCHED_NBR = L.SCHED_NBR WHERE l.recv_ship_status IN ('O', 'R') AND l.amt_only_flg = 'N' AND l.MOVE_STAT_INV <> 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 3 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 4 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 5 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 8 | INSPECT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Required
N=No Y=Yes |
| 9 | INSPECT_DTTM | DateTime(26) | TIMESTAMP | Inspect DateTime |
| 10 | INSPECT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Status
C=Complete I=Incomplete Default Value: I |
| 11 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: ITM_PURCH_VW |
| 12 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 13 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 14 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 15 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 16 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
| 17 | MOVE_STAT_INV | Character(1) | VARCHAR2(1) NOT NULL |
MOVE_STAT_INV
M=Moved N=N/A P=Pending |
| 18 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 19 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 20 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 21 | PROCESS_COMPLETE | Character(1) | VARCHAR2(1) NOT NULL |
Process Complete
Y/N Table Edit Default Value: N |
| 22 | QTY_LN_INV_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Line Inv Qty |
| 23 | QTY_SH_ACCPT | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Accepted in Receipt UOM |
| 24 | QTY_SH_ACCPT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Accepted Quantity |
| 25 | QTY_SH_ACCPT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Accept QTY in Supplier UOM |
| 26 | QTY_SH_INSPD | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Inspected in Receipt UOM |
| 27 | QTY_SH_INSPD_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Inspected Quantity |
| 28 | QTY_SH_INSPD_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Inspected Qty in Supplier UOM |
| 29 | QTY_SH_RECVD | Number(16,4) | DECIMAL(15,4) NOT NULL | F_KDHIL_R87H8 062804 MLM: Added new Line Quantity Received Label |
| 30 | QTY_SH_RECVD_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Receipt Quantity |
| 31 | QTY_SH_RECVD_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Receipt QTY in Supplier UOM |
| 32 | QTY_SH_REJCT | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Rejected in Receipt UOM |
| 33 | QTY_SH_REJCT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Rejected Quantity |
| 34 | QTY_SH_REJCT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Reject QTY in Supplier UOM |
| 35 | QTY_SH_RTN | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned in Receipt UOM |
| 36 | QTY_SH_RTN_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned in Std UOM |
| 37 | QTY_SH_RTN_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned in PO UOM |
| 38 | RECEIPT_DTTM | DateTime(26) | TIMESTAMP | Receipt Datetime |
| 39 | RECEIPT_UM | Character(3) | VARCHAR2(3) NOT NULL | Receiving UOM |
| 40 | RECEIVE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Receipt Unit of Measure
Prompt Table: UNITS_TBL |
| 41 | RECV_SHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Schedule Status
C=Closed H=Hold O=Open R=Received X=Canceled Default Value: O |
| 42 | RECV_STOCK_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Stock UOM
Prompt Table: UNITS_TBL |
| 43 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
| 44 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 45 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 46 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 47 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 48 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 49 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |