IN_ORLS_L_VW

(SQL View)

SELECT A.BUSINESS_UNIT , A.PICK_BATCH_ID , A.EXT_REF_NBR , A.EXT_REF_LN_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.ITEM_DESCR , A.CARRIER_ID_EXP , A.CCI_REQ_EXP , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , A.COO_REQ_EXP , A.CURRENCY_CD , A.CUSTOMER_ITEM_NBR , A.CUSTOMER_PO , A.CUSTOMER_PO_LINE , A.CUSTOMER_PO_SCHED , A.DEMAND_DATE , A.EXPORT , A.EXPORT_LIC_EXPIRE , A.EXPORT_LIC_NBR , A.EXPORT_LIC_REQ , A.EXPORT_LIC_TYPE , A.FREIGHT_TERMS , A.FREIGHT_TERMS_EXP , A.HARD_ALLOC_FLAG , A.IMPORT_CERT_NBR , A.IMPORT_LIC_EXP , A.IMPORT_LIC_REQ , A.KIT_LINE_NBR , A.LOAD_ID , A.LOT_ALLOC_FLG , A.LOT_CONTROL , A.NAFTA_REQ_EXP , A.ORDER_UOM_RATE , A.PARENT_PROD_ID , A.PARTIAL_ORDER_FLAG , A.PARTIAL_QTY_FLAG , A.PCK_QTY_ORDUOM , A.PCK_QTY_STD , A.PRIORITY_NBR , A.PRODUCT_ID , A.REQ_ARRIVAL_DTTM , A.REQ_SHIP_DTTM , A.SCHED_ARRV_DTTM , A.SCHED_DATE , A.SCHED_SHIP_DTTM , A.SCHED_TIME , A.SED_REQ_EXP , A.SERIAL_CONTROL , A.SHIP_EARLY_DATE , A.SHIP_EARLY_TIME , A.SHIP_LATE_DATE , A.SHIP_LATE_TIME , A.SHIP_PRIOR_FLG , A.SHIP_PRIORITY_EXP , A.SHIP_SERIAL_CNTRL , A.SHIP_TYPE_ID , A.SHIP_TYPE_ID_EXP , A.STORE_NUMBER , 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.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='3'

# 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 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number

6 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

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

8 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

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

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

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

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

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

14 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

15 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes

16 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

17 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

18 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes

19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

20 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number

21 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

22 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line

23 CUSTOMER_PO_SCHED Character(11) VARCHAR2(11) NOT NULL Customer PO Schedule

24 DEMAND_DATE Date(10) DATE Demand Date

25 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

26 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

27 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr

28 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes

29 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific

30 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

31 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

32 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate

33 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr

34 IMPORT_LIC_EXP Date(10) DATE Expiration Date

35 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes

36 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number

37 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

38 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation

39 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y

40 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes

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

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

43 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes

44 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship

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

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

47 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

48 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

49 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival

50 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship

51 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm

52 SCHED_DATE Date(10) DATE Schedule Date

53 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

54 SCHED_TIME Time(15) TIMESTAMP Schedule Time

55 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes

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

57 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date

58 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time

59 SHIP_LATE_DATE Date(10) DATE Latest Ship Date

60 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time

61 SHIP_PRIOR_FLG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Sched Date

62 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority

63 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control

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

65 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

66 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number

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

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

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

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

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

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

73 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.

74 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.

75 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.

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

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

78 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

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

80 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	PICKLIST_LINE_NO	Number(7,0)	INTEGER NOT NULL	Pick List Sorting Line Number
6	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
7	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
8	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
9	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
10	SCHED_LINE_NO	Number(7,2)	DECIMAL(6,2) NOT NULL	Sched Line NO
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
12	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
13	ITEM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Item Description
14	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID
15	CCI_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Canadian Customs Invoice N=No Y=Yes
16	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
17	CNTRCT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Buying Agreement Line Nbr
18	COO_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Certificate of Origin N=No Y=Yes
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
20	CUSTOMER_ITEM_NBR	Character(18)	VARCHAR2(18) NOT NULL	Customer Item Number
21	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
22	CUSTOMER_PO_LINE	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Line
23	CUSTOMER_PO_SCHED	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Schedule
24	DEMAND_DATE	Date(10)	DATE	Demand Date
25	EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Analytic Instance N=No Y=Yes
26	EXPORT_LIC_EXPIRE	Date(10)	DATE	Expiration Date
27	EXPORT_LIC_NBR	Character(18)	VARCHAR2(18) NOT NULL	Export License Nbr
28	EXPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Export License Required NO=No YES=Yes
29	EXPORT_LIC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	License Type GDST=General SPEC=Specific
30	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
31	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code
32	HARD_ALLOC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hard Allocate
33	IMPORT_CERT_NBR	Character(18)	VARCHAR2(18) NOT NULL	Import License Nbr
34	IMPORT_LIC_EXP	Date(10)	DATE	Expiration Date
35	IMPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Import License Required NO=No YES=Yes
36	KIT_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Kit Line Number
37	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
38	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation
39	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y
40	NAFTA_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	North American Free Trade Agmt N=No Y=Yes
41	ORDER_UOM_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Order UOM Conversion Rate
42	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
43	PARTIAL_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Orders Can Ship N=No Y=Yes
44	PARTIAL_QTY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qtys Can Ship
45	PCK_QTY_ORDUOM	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Ordered In Order UOM
46	PCK_QTY_STD	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Ordered In Std UOM
47	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
48	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
49	REQ_ARRIVAL_DTTM	DateTime(26)	TIMESTAMP	Requested Arrival
50	REQ_SHIP_DTTM	DateTime(26)	TIMESTAMP	Requested Ship
51	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
52	SCHED_DATE	Date(10)	DATE	Schedule Date
53	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime
54	SCHED_TIME	Time(15)	TIMESTAMP	Schedule Time
55	SED_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Shippers Export Declaration N=No Y=Yes
56	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y
57	SHIP_EARLY_DATE	Date(10)	DATE	Earliest Ship Date
58	SHIP_EARLY_TIME	Time(15)	TIMESTAMP	Earliest Ship Time
59	SHIP_LATE_DATE	Date(10)	DATE	Latest Ship Date
60	SHIP_LATE_TIME	Time(15)	TIMESTAMP	Latest Ship Time
61	SHIP_PRIOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Ship Prior to Sched Date
62	SHIP_PRIORITY_EXP	Character(6)	VARCHAR2(6) NOT NULL	Export Shipping Priority
63	SHIP_SERIAL_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	Shipping Serial Control
64	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
65	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method
66	STORE_NUMBER	Character(17)	VARCHAR2(17) NOT NULL	Store Number
67	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
68	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
69	QTY_PREC_STD	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal Number W=Whole Number
70	ROUND_RULE_STD	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule N=Natural Round U=Round Up
71	QTY_PREC_ORDR	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal Number W=Whole Number
72	ROUND_RULE_ORDR	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule N=Natural Round U=Round Up
73	ALLOW_OVERPICK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether or not overpicking is allowed for a customer or business unit.
74	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.
75	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.
76	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
77	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
78	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
79	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
80	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