IN_ORLS_LOC_VW

(SQL View)

SELECT A.BUSINESS_UNIT , A.PICK_BATCH_ID , A.EXT_REF_NBR , A.EXT_REF_LN_NBR , A.SEQ_NBR , A.PICKLIST_LINE_NO , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NO , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.CONFIG_CODE , A.CONTAINER_ID , A.EXTRACT_SRC_FLG , A.HARD_ALLOC_FLAG , A.INV_LOT_ID , A.ITEM_DESCR , A.LOCATION_UOM , A.LOCUOM_RATE , A.LOT_ALLOC_FLG , A.LOT_CONTROL , A.ORDER_UOM_RATE , A.PARENT_PROD_ID , A.PARTIAL_QTY_FLAG , A.PCK_QTY_ORDUOM , A.PCK_QTY_STD , A.RES_QTY_LOCUOM , A.SERIAL_CONTROL , A.SERIAL_ID , A.SHIP_SERIAL_CNTRL , A.STAGED_DATE , A.STAGED_DATE_FLAG , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.UNIT_OF_MEASURE , A.UNIT_MEASURE_STD , A.QTY_PREC_STD , A.ROUND_RULE_STD , A.QTY_PREC_ORDR , A.ROUND_RULE_ORDR , A.ALLOW_OVERPICK_FLG , A.MAX_PICK_TOLERANCE , A.ROUTE_CD , A.ROUTE_STOP_NBR , A.ASRS_ID , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG , A.ORD_REL_REC_TYPE FROM PS_ORDER_REL_INV A WHERE ORD_REL_REC_TYPE ='5'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

3 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number

4 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number

5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

6 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number

7 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

8 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

9 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

10 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

11 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO

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

13 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

14 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

15 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

16 EXTRACT_SRC_FLG Character(1) VARCHAR2(1) NOT NULL Extract Source
0=Inventory Pick Plan
1=Manufacturing Pick Plan
Y/N Table Edit

17 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate
Y/N Table Edit

18 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

19 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description

20 LOCATION_UOM Character(3) VARCHAR2(3) NOT NULL Location Unit Of Measure

21 LOCUOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Location UOM Conversion Rate

22 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
Y/N Table Edit

23 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
Y/N Table Edit

24 ORDER_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate

25 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id

26 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship
Y/N Table Edit

27 PCK_QTY_ORDUOM Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Ordered In Order UOM

28 PCK_QTY_STD Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Ordered In Std UOM

29 RES_QTY_LOCUOM Signed Number(17,4) DECIMAL(15,4) NOT NULL Resereved Quantity In Loc UOM

30 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y

31 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

32 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
Y/N Table Edit

33 STAGED_DATE Date(10) DATE Staged Date

34 STAGED_DATE_FLAG Character(1) VARCHAR2(1) NOT NULL Staged Date Control
N=Staged Date Tracking OFF
Y=Staged Date Tracking ON

35 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

36 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

37 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

38 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

39 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

40 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

41 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

42 QTY_PREC_STD Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number

43 ROUND_RULE_STD Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up

44 QTY_PREC_ORDR Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number

45 ROUND_RULE_ORDR Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up

46 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
Y/N Table Edit

47 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.

48 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

49 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.

50 ASRS_ID Number(15,0) DECIMAL(15) NOT NULL ASRS Identifier

51 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

52 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

53 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

54 ORD_REL_REC_TYPE Character(1) VARCHAR2(1) NOT NULL Order Release Record Type
1=Order Header
2=Ord Header Comments
3=Order Line
4=Ord Line Comments
5=Location Detail

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID
3	EXT_REF_NBR	Number(10,0)	DECIMAL(10) NOT NULL	External Reference Number
4	EXT_REF_LN_NBR	Number(5,0)	INTEGER NOT NULL	External Reference Line Number
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	PICKLIST_LINE_NO	Number(7,0)	INTEGER NOT NULL	Pick List Sorting Line Number
7	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
8	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
9	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
10	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
11	SCHED_LINE_NO	Number(7,2)	DECIMAL(6,2) NOT NULL	Sched Line NO
12	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
13	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
14	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
15	CONTAINER_ID	Character(10)	VARCHAR2(10) NOT NULL	Container ID
16	EXTRACT_SRC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Extract Source 0=Inventory Pick Plan 1=Manufacturing Pick Plan Y/N Table Edit
17	HARD_ALLOC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hard Allocate Y/N Table Edit
18	INV_LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
19	ITEM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Item Description
20	LOCATION_UOM	Character(3)	VARCHAR2(3) NOT NULL	Location Unit Of Measure
21	LOCUOM_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Location UOM Conversion Rate
22	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation Y/N Table Edit
23	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y Y/N Table Edit
24	ORDER_UOM_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Order UOM Conversion Rate
25	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
26	PARTIAL_QTY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qtys Can Ship Y/N Table Edit
27	PCK_QTY_ORDUOM	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Ordered In Order UOM
28	PCK_QTY_STD	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Ordered In Std UOM
29	RES_QTY_LOCUOM	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Resereved Quantity In Loc UOM
30	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y
31	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
32	SHIP_SERIAL_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	Shipping Serial Control Y/N Table Edit
33	STAGED_DATE	Date(10)	DATE	Staged Date
34	STAGED_DATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Staged Date Control N=Staged Date Tracking OFF Y=Staged Date Tracking ON
35	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
36	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 1
37	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 2
38	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 3
39	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 4
40	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
41	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
42	QTY_PREC_STD	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal Number W=Whole Number
43	ROUND_RULE_STD	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule N=Natural Round U=Round Up
44	QTY_PREC_ORDR	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal Number W=Whole Number
45	ROUND_RULE_ORDR	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule N=Natural Round U=Round Up
46	ALLOW_OVERPICK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether or not overpicking is allowed for a customer or business unit. Y/N Table Edit
47	MAX_PICK_TOLERANCE	Number(6,2)	DECIMAL(5,2) NOT NULL	Used to indicate the allowable percentage of overshipment for a customer or business unit.
48	ROUTE_CD	Character(6)	VARCHAR2(6) NOT NULL	A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
49	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
50	ASRS_ID	Number(15,0)	DECIMAL(15) NOT NULL	ASRS Identifier
51	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
52	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
53	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
54	ORD_REL_REC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Order Release Record Type 1=Order Header 2=Ord Header Comments 3=Order Line 4=Ord Line Comments 5=Location Detail