RECV_INSPDTL_VW

(SQL View)
 Index Back

Receipt Inspect Selection View


SELECT s.shipto_id , s.business_unit , s.receiver_id , s.recv_ln_nbr , s.recv_ship_seq_nbr , s.business_unit_in , s.business_unit_po , s.convert_to_po , s.convert_to_stk , s.convert_stk_to_std , s.currency_cd , s.currency_cd_base , s.descr254_mixed , s.distrib_mthd_flg , s.due_dt , s.ers_inv_seq , s.ers_status , s.inspect_cd , s.inspect_dttm , s.inspect_status , s.inv_item_id , s.ITM_ID_VNDR , s.itm_setid , s.line_nbr , s.mfg_id , s.MFG_ITM_ID , s.move_stat_am , s.move_stat_am , s.move_stat_inv , s.move_stat_mfg , v.name1 , s.po_id , s.op_sequence , s.oprid , h.po_receipt_flg , s.price_po , s.price_po_bse , s.process_complete , s.production_id , s.qty_ln_inv_suom , s.qty_sh_accpt , s.qty_sh_accpt_suom , s.qty_sh_accpt_vuom , s.qty_sh_inspd , s.qty_sh_inspd_suom , s.qty_sh_inspd_vuom , s.qty_sh_netrcv_vuom , s.qty_sh_recvd , s.qty_sh_recvd_suom , s.qty_sh_recvd_vuom , s.qty_sh_rejct , s.qty_sh_rejct_suom , s.qty_sh_rejct_vuom , s.qty_sh_rtn , s.qty_sh_rtn_suom , s.qty_sh_rtn_vuom , s.recv_ship_status , h.receipt_dt , s.receipt_dttm , s.receipt_um , s.receive_uom , s.recv_ln_match_opt , s.reject_action , s.reject_reason , s.REVISION , s.rma_id , s.rma_line_nbr , s.sched_nbr , s.serial_control , s.serial_status , s.unit_measure_std , h.vendor_id , v.vendor_name_short , h.vendor_setid , h.vndr_loc FROM PS_RECV_LN_SHIP s , ps_recv_hdr h , ps_vendor v WHERE h.business_unit = s.business_unit AND h.receiver_id = s.receiver_id AND s.amt_only_flg = 'N' AND h.vendor_setid = v.setid AND h.vendor_id = v.vendor_id

# 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 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
7 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
8 CONVERT_TO_PO Signed Number(17,8) DECIMAL(15,8) NOT NULL Convert to PO

Default Value: 1

9 CONVERT_TO_STK Signed Number(17,8) DECIMAL(15,8) NOT NULL Convert to Stock

Default Value: 1

10 CONVERT_STK_TO_STD Signed Number(17,8) DECIMAL(15,8) NOT NULL Convert Stock To Standard
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
13 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
14 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

Default Value: Q

15 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
16 ERS_INV_SEQ Number(5,0) INTEGER NOT NULL ERS Invoice Sequence
17 ERS_STATUS Character(1) VARCHAR2(1) NOT NULL ERS Status
I=Invoiced
N=Not Invoiced
18 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
19 INSPECT_DTTM DateTime(26) TIMESTAMP Inspect DateTime
20 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete

Default Value: I

21 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

22 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
23 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
24 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
25 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
26 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
27 MOVE_STAT_AM Character(1) VARCHAR2(1) NOT NULL AM Move Status
M=Moved
N=N/A
P=Pending
28 INSP_AM_STATUS Character(1) VARCHAR2(1) NOT NULL AM Move Status
29 MOVE_STAT_INV Character(1) VARCHAR2(1) NOT NULL MOVE_STAT_INV
M=Moved
N=N/A
P=Pending
30 MOVE_STAT_MFG Character(1) VARCHAR2(1) NOT NULL Mfg Move Status
M=Moved
N=N/A
P=Pending
31 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
32 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
33 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
34 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
35 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

36 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
37 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base
38 PROCESS_COMPLETE Character(1) VARCHAR2(1) NOT NULL Process Complete

Y/N Table Edit

Default Value: N

39 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
40 QTY_LN_INV_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Line Inv Qty
41 QTY_SH_ACCPT Number(16,4) DECIMAL(15,4) NOT NULL Qty Accepted in Receipt UOM
42 QTY_SH_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Accepted Quantity
43 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
44 QTY_SH_INSPD Number(16,4) DECIMAL(15,4) NOT NULL Qty Inspected in Receipt UOM
45 QTY_SH_INSPD_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Inspected Quantity
46 QTY_SH_INSPD_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Inspected Qty in Supplier UOM
47 QTY_SH_NETRCV_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Net Receipt Quantity
48 QTY_SH_RECVD Number(16,4) DECIMAL(15,4) NOT NULL F_KDHIL_R87H8 062804 MLM: Added new Line Quantity Received Label
49 QTY_SH_RECVD_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt Quantity
50 QTY_SH_RECVD_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt QTY in Supplier UOM
51 QTY_SH_REJCT Number(16,4) DECIMAL(15,4) NOT NULL Qty Rejected in Receipt UOM
52 QTY_SH_REJCT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Rejected Quantity
53 QTY_SH_REJCT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Reject QTY in Supplier UOM
54 QTY_SH_RTN Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in Receipt UOM
55 QTY_SH_RTN_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in Std UOM
56 QTY_SH_RTN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in PO UOM
57 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

58 RECEIPT_DT Date(10) DATE NOT NULL Received Date

Default Value: %date

59 RECEIPT_DTTM DateTime(26) TIMESTAMP Receipt Datetime
60 RECEIPT_UM Character(3) VARCHAR2(3) NOT NULL Receiving UOM
61 RECEIVE_UOM Character(3) VARCHAR2(3) NOT NULL Receipt Unit of Measure

Prompt Table: UNITS_TBL

62 RECV_LN_MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Receipt Match Status
F=Matched
N=No Match
P=Partial
63 REJECT_ACTION Character(1) VARCHAR2(1) NOT NULL Action On Rejection
C=Return for Credit
R=Return For Replacement
64 REJECT_REASON Character(10) VARCHAR2(10) NOT NULL Reject Reason Code
DAM=Damaged Goods
FAL=Failed Inspection
INC=Incomplete Shipment
LAT=Late Shipment
RLY=Early Shipment
WRG=Wrong Goods or Service

Prompt Table: REJECT_REASONS

65 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_PO_VW

66 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
67 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
68 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
69 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y

Y/N Table Edit

Default Value: N

70 SERIAL_STATUS Character(1) VARCHAR2(1) NOT NULL Serial Status
C=Complete
I=Incomplete

Default Value: I

71 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
72 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
73 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
74 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
75 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location