IN_ORLS_L_EVW

(SQL View)
 Index Back

Order Release Line

Order Release Line

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_NBR , A.SCHED_LINE_NBR , 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 , %DatePart(A.SCHED_DTTM) , A.SCHED_SHIP_DTTM , %TimePart(A.SCHED_DTTM) , A.SCHED_DTTM , A.SED_REQ_EXP , A.SERIAL_CONTROL , %DatePart(A.SHIP_EARLY_DTTM) , %TimePart(A.SHIP_EARLY_DTTM) , A.SHIP_EARLY_DTTM , %DatePart(A.SHIP_LATE_DTTM) , %TimePart(A.SHIP_LATE_DTTM) , A.SHIP_LATE_DTTM , A.SHIP_PRIOR_FLG , A.SHIP_PRIORITY_EXP , A.SHIP_SERIAL_CNTRL , 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.TMS_EXT_REF_LN_NBR , A.TMS_LOAD_STP_NBR , A.QTY_REQUESTED , A.QTY_REQUESTED_BASE , A.QTY_BACKORDER , A.QTY_BACKORDER_BASE , A.QTY_PROMISED , A.QTY_PROMISED_BASE , A.QTY_ALLOCATED , A.QTY_ALLOC_BASE , A.QTY_PICK_OVRIDE , A.QTY_PICK_OVR_BASE , A.QTY_PER , A.QTY_CODE , A.OPTIONAL_SHIP , A.STORE_LOC , A.MFG_ID , A.UPN_ID , A.UPN_UOM , A.NUM_OF_PIECES , A.BUSINESS_UNIT_PO , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_IN_ORLS_L_TAO A

# 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 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
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 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
15 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
16 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes
17 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
18 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
19 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number
22 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
23 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
24 CUSTOMER_PO_SCHED Character(11) VARCHAR2(11) NOT NULL Customer PO Schedule
25 DEMAND_DATE Date(10) DATE Demand Date
26 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
27 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date
28 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr
29 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes
30 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific
31 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
32 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
33 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate
34 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr
35 IMPORT_LIC_EXP Date(10) DATE Expiration Date
36 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes
37 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
38 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
39 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
40 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
41 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes
42 ORDER_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate
43 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
44 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes
45 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship
46 PCK_QTY_ORDUOM Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Ordered In Order UOM
47 PCK_QTY_STD Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Ordered In Std UOM
48 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
49 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
50 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
51 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
52 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
53 SCHED_DATE Date(10) DATE Schedule Date
54 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
55 SCHED_TIME Time(15) TIMESTAMP Schedule Time
56 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
57 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes
58 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
59 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date
60 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time
61 SHIP_EARLY_DTTM DateTime(26) TIMESTAMP Earliest Ship Date/Time
62 SHIP_LATE_DATE Date(10) DATE Latest Ship Date
63 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time
64 SHIP_LATE_DTTM DateTime(26) TIMESTAMP Latest Ship Date/Time
65 SHIP_PRIOR_FLG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Sched Date
66 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
67 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
68 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
69 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
70 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
71 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
72 QTY_PREC_STD Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
73 ROUND_RULE_STD Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
74 QTY_PREC_ORDR Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
75 ROUND_RULE_ORDR Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
76 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
77 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.
78 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.
79 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
80 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
81 TMS_LOAD_STP_NBR Number(5,0) INTEGER NOT NULL Load Stop Number
82 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
83 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
84 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
85 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
86 QTY_PROMISED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Promised
87 QTY_PROMISED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Promised Base
88 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
89 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
90 QTY_PICK_OVRIDE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
91 QTY_PICK_OVR_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.
92 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
93 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
94 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without
95 STORE_LOC Character(10) VARCHAR2(10) NOT NULL Store Location
96 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
97 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
98 UPN_UOM Character(3) VARCHAR2(3) NOT NULL Universal Part Number UOM
99 NUM_OF_PIECES Signed Number(17,4) DECIMAL(15,4) NOT NULL Number of Pieces
100 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
101 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
102 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
103 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
104 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
105 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
106 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag