RTV_LN_FS

(SQL View)
 Index Back

RTV (Supplier) Line View

Return To Vendor (Supplier) Line View

SELECT A.BUSINESS_UNIT , A.RTV_ID , A.RTV_LN_NBR , A.ACTUAL_COST , A.ASSET_FLG , A.BILL_OF_LADING , A.BUSINESS_UNIT_IN , A.BUSINESS_UNIT_PO , A.BUSINESS_UNIT_RECV , A.CARRIER_ID , A.CONVERSION_RATE , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.DESCR254_MIXED , A.DISPOSITION_TYPE , A.DISTRIB_MTHD_FLG , A.INV_FLG , A.INV_ITEM_ID , A.IST_TXN_FLG , A.ITM_SETID , A.LINE_NBR , A.LOT_CONTROL , A.MATCH_STATUS , A.OP_SEQUENCE , A.PO_ID , A.PO_STATUS , A.PRICE_PO , A.PRICE_PO_BSE , A.PRODUCTION_ID , A.QTY_LN_RETRN_SUOM , A.QTY_LN_RETRN_VUOM , A.QTY_LN_SHIP_SUOM , A.QTY_LN_SHIP_VUOM , A.QTY_PO_INTFC , A.QTY_RECV_INTFC , A.RATE_DATE , A.RATE_DIV , A.RATE_MULT , A.RT_TYPE , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.RECV_REQ , A.RETURN_ACTION , A.RETURN_REASON , A.REVISION , A.RMA_ID , A.RMA_LINE_NBR , A.RTV_LN_STATUS , A.RTV_INV_OPTION , A.RTV_INV_STAT , A.SCHED_NBR , A.SERIAL_CONTROL , A.SHIP_TYPE_ID , A.SOURCE_MATCH_FLAG , A.SUBCONTRACT_COMP , A.UNIT_MEASURE_STD , A.UNIT_MEASURE_VNDR , A.VNDR_RTV_ACTION , %subrec(PUR_USR_LIN_SBR, A) , %subrec(PUR_USR_SHP_SBR, A) FROM PS_RTV_LN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
3 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
4 ACTUAL_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 10/09/02 lee: added label "Total Unit Cost"
5 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
6 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
7 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
8 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
9 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
10 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
11 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
14 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
15 DISPOSITION_TYPE Character(1) VARCHAR2(1) NOT NULL Disposition Type
0=Ship
1=Destroy
16 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
17 INV_FLG Character(1) VARCHAR2(1) NOT NULL Inventory Applicable
N=No
Y=Yes
18 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
19 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

Y/N Table Edit

20 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
21 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
22 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y

Default Value: N

23 MATCH_STATUS Character(1) VARCHAR2(1) NOT NULL PI Match Status
0=None
1=Special Depr
2=Accelerated Depr
3=Initial Depr
A=All (I,O,U)
D=Discard
I=Inventory
O=Over
R=Retire
U=Under
24 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
25 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
26 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
27 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
28 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base
29 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
30 QTY_LN_RETRN_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Std Returned Qty
31 QTY_LN_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vndr Returned Qty
32 QTY_LN_SHIP_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Std Shipped Qty
33 QTY_LN_SHIP_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Supp Shipped Qty
34 QTY_PO_INTFC Number(16,4) DECIMAL(15,4) NOT NULL Qty Interfaced to PO
35 QTY_RECV_INTFC Number(16,4) DECIMAL(15,4) NOT NULL Qty Interfaced - Supp UOM
36 RATE_DATE Date(10) DATE Exchange Rate Date
37 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
38 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
39 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
40 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
41 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
42 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
43 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required
44 RETURN_ACTION Character(1) VARCHAR2(1) NOT NULL Return Action
C=Credit
E=Exchange
R=Replace
45 RETURN_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: RETURN_REASONS

46 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
47 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
48 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
49 RTV_LN_STATUS Character(1) VARCHAR2(1) NOT NULL RTV Line Status
C=Closed
O=Open
S=Shipped
X=Cancelled

Default Value: O

50 RTV_INV_OPTION Character(1) VARCHAR2(1) NOT NULL RTV Inventory Option
1=Manual
2=Express
3=Fulfill
4=Re-Send
51 RTV_INV_STAT Character(1) VARCHAR2(1) NOT NULL Inventory Process Status
1=N/A
2=Pending
3=Processing
9=Complete
52 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
53 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y

Default Value: N

54 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD_VW

55 SOURCE_MATCH_FLAG Character(1) VARCHAR2(1) NOT NULL Source Match Flag
56 SUBCONTRACT_COMP Character(1) VARCHAR2(1) NOT NULL Production Complete indicator for streamline processing

Y/N Table Edit

Default Value: OPR_DEF_TBL_PM.SUBCONTRACT_COMP

57 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
58 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
59 VNDR_RTV_ACTION Character(1) VARCHAR2(1) NOT NULL Supplier RTV Action
E=Exchange
P=Replacement
R=Return Only
60 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
61 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
62 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
63 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
64 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
65 CUSTOM_DATE_B Date(10) DATE Custom Date
66 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
67 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
68 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
69 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
70 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
71 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
72 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
73 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2