IN_ORLS_L_N_VW

(SQL View)
 Index Back

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.TEXT254 , A.ORD_NOTE_TYPE , A.DOCUMENT_CD , 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 ='4'

# 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 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
15 ORD_NOTE_TYPE Character(1) VARCHAR2(1) NOT NULL Order Note Flag
16 DOCUMENT_CD Character(4) VARCHAR2(4) NOT NULL Document Code
ACKN=Order Acknowledgment
ASN=Advance Shipping Notification
BOL=Bill of Lading
CACK=Order Change Acknowledgement
CREN=Buying Agreement Renewal
CSTS=Buying Agreement Status
INCC=Invoice Courtesy Copy
INVC=Invoice
INVN=Invoice Notification
PACK=Packing List
PICK=Picking Plan
PPRC=Product Price List
PRAD=Payment Remittance Advice
QUOT=Quotation
RMA=Return Material Authorization
17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
18 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
19 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
20 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