IN_ORLS_LOC_EVW

(SQL View)
 Index Back

Order Release Location

Order Release Location

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_NBR , A.SCHED_LINE_NBR , 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 FROM PS_IN_ORLS_LOC_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 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 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
15 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
16 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
17 EXTRACT_SRC_FLG Character(1) VARCHAR2(1) NOT NULL Extract Source
0=Inventory Pick Plan
1=Manufacturing Pick Plan
18 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate
19 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
20 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
21 LOCATION_UOM Character(3) VARCHAR2(3) NOT NULL Location Unit Of Measure
22 LOCUOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Location UOM Conversion Rate
23 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
24 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
25 ORDER_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate
26 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
27 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship
28 PCK_QTY_ORDUOM Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Ordered In Order UOM
29 PCK_QTY_STD Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Ordered In Std UOM
30 RES_QTY_LOCUOM Signed Number(17,4) DECIMAL(15,4) NOT NULL Resereved Quantity In Loc UOM
31 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
32 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
33 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
34 STAGED_DATE Date(10) DATE Staged Date
35 STAGED_DATE_FLAG Character(1) VARCHAR2(1) NOT NULL Staged Date Control
N=Staged Date Tracking OFF
Y=Staged Date Tracking ON
36 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
37 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
38 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
39 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
40 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
41 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
42 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
43 QTY_PREC_STD Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
44 ROUND_RULE_STD Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
45 QTY_PREC_ORDR Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
46 ROUND_RULE_ORDR Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
47 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
48 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.
49 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.
50 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
51 ASRS_ID Number(15,0) DECIMAL(15) NOT NULL ASRS Identifier
52 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
53 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
54 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag