RTV_RECV_SHP_VW

(SQL View)
 Index Back

Recv Line Ship View for RTV


SELECT S.BUSINESS_UNIT , S.RECEIVER_ID , S.RECV_LN_NBR , S.RECV_SHIP_SEQ_NBR , S.BUSINESS_UNIT_IN , S.BUSINESS_UNIT_PO , S.COUNTRY_IST_ORIGIN , 'N' , S.CURRENCY_CD , S.CURRENCY_CD_BASE , S.DESCR254_MIXED , S.DISTRIB_MTHD_FLG , S.INV_ITEM_ID , S.IST_DISTRIB_STATUS , S.ITM_SETID , S.LINE_NBR , S.LOT_CONTROL , S.MATCH_STATUS_LC , S.MERCHANDISE_AMT , S.MFG_ID , S.MOVE_STAT_AM , S.MOVE_STAT_INV , S.MOVE_STAT_MFG , S.PO_ID , S.PRICE_PO , S.PRICE_PO_BSE , S.QTY_SH_ACCPT_SUOM , S.QTY_SH_ACCPT_VUOM , S.QTY_SH_RECVD_SUOM , S.QTY_SH_RECVD_VUOM , S.QTY_SH_REJCT_SUOM , S.QTY_SH_REJCT_VUOM , QTY_SH_RTN_SUOM , QTY_SH_RTN_VUOM , H.RECEIPT_DT , S.RECEIPT_UM , S.REJECT_ACTION , S.REJECT_REASON , S.REPLACEMENT_FLG , S.REVISION , S.SCHED_NBR , S.SERIAL_CONTROL , S.UNIT_MEASURE_STD , S.PRODUCTION_ID , S.OP_SEQUENCE , H.VENDOR_ID , H.VENDOR_SETID , H.VNDR_LOC , %subrec(PUR_USR_SHP_SBR,S) FROM PS_RECV_HDR H , PS_RECV_LN_SHIP S WHERE H.BUSINESS_UNIT = S.BUSINESS_UNIT AND H.RECEIVER_ID = S.RECEIVER_ID AND S.AMT_ONLY_FLG = 'N' AND S.MOVE_STAT_INV <> 'P' AND S.MOVE_STAT_AM <> 'P' AND S.MOVE_STAT_MFG <> 'P' AND S.RECV_SHIP_STATUS <> 'X' AND S.QTY_SH_NETRCV_VUOM <> 0

# 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 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
6 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
7 COUNTRY_IST_ORIGIN Character(3) VARCHAR2(3) NOT NULL Intrastat Country of Origin
8 CB_SELECT_PO Character(1) VARCHAR2(1) NOT NULL Select PO Schedule Checkbox

Y/N Table Edit

Default Value: N

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 IST_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Intrastat Distribution Status
A=Awaiting Arrival Processing
D=Distributed
I=Ignored
M=Archival Entry
N=Not Distributed
R=Reversal Entry
S=Awaiting Dispatch Processing
U=Undefined
15 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
16 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
17 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y

Default Value: N

18 MATCH_STATUS_LC Number(1,0) SMALLINT NOT NULL 03/14/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

Default Value: 2

19 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
20 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
21 MOVE_STAT_AM Character(1) VARCHAR2(1) NOT NULL AM Move Status
M=Moved
N=N/A
P=Pending
22 MOVE_STAT_INV Character(1) VARCHAR2(1) NOT NULL MOVE_STAT_INV
M=Moved
N=N/A
P=Pending
23 MOVE_STAT_MFG Character(1) VARCHAR2(1) NOT NULL Mfg Move Status
M=Moved
N=N/A
P=Pending
24 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
25 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
26 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base
27 QTY_SH_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Accepted Quantity
28 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
29 QTY_SH_RECVD_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt Quantity
30 QTY_SH_RECVD_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt QTY in Supplier UOM
31 QTY_SH_REJCT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Rejected Quantity
32 QTY_SH_REJCT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Reject QTY in Supplier UOM
33 QTY_SH_RTN_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in Std UOM
34 QTY_SH_RTN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in PO UOM
35 RECEIPT_DT Date(10) DATE Received Date
36 RECEIPT_UM Character(3) VARCHAR2(3) NOT NULL Receiving UOM
37 REJECT_ACTION Character(1) VARCHAR2(1) NOT NULL Action On Rejection
C=Return for Credit
R=Return For Replacement
38 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

39 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
40 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
41 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
42 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y

Default Value: N

43 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
44 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
45 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
46 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
47 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
48 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
49 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
50 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
51 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
52 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
53 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
54 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
55 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2