PO_POD_SHP_EVW1

(SQL View)
 Index Back

Outbound PO Line Ship STG View

SELECT C.BUSINESS_UNIT , C.PO_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , C.LINE_NBR , C.SCHED_NBR , C.DUE_DT , C.SHIPTO_ID , C.DESCR_SHIPTO , C.ADDRESS1_SHIPTO , C.ADDRESS2_SHIPTO , C.ADDRESS3_SHIPTO , C.ADDRESS4_SHIPTO , C.CITY_SHIPTO , C.STATE_SHIPTO , C.POSTAL_SHIPTO , C.COUNTRY_SHIPTO , C.PRICE_PO , C.FREIGHT_TERMS , C.QTY_PO , C.SHIP_TYPE_ID , C.PROCESS_INSTANCE , C.AUDIT_ACTN , C.IN_PROCESS_FLG FROM PS_PO_HDR_OUT_EC A , PS_PO_LINE_OUT_EC B , PS_PO_SHIP_OUT_EC C WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND B.EIP_CTL_ID = C.EIP_CTL_ID AND A.PO_ID = B.PO_ID AND B.PO_ID = C.PO_ID AND B.LINE_NBR = C.LINE_NBR

SELECT C.BUSINESS_UNIT , C.PO_ID , C.VENDOR_SETID , C.VENDOR_ID , C.VNDR_LOC , C.LINE_NBR , C.SCHED_NBR , C.DUE_DT , C.SHIPTO_ID , C.DESCR_SHIPTO , C.ADDRESS1_SHIPTO , C.ADDRESS2_SHIPTO , C.ADDRESS3_SHIPTO , C.ADDRESS4_SHIPTO , C.CITY_SHIPTO , C.STATE_SHIPTO , C.POSTAL_SHIPTO , C.COUNTRY_SHIPTO , C.PRICE_PO , C.FREIGHT_TERMS , C.QTY_PO , C.SHIP_TYPE_ID , C.PROCESS_INSTANCE , C.AUDIT_ACTN , C.IN_PROCESS_FLG , C.CANCEL_STATUS , C.ATTN_TO ,C.STD_ID_NUM_SHIPTO FROM PS_PO_SHIP_OUT_EC C

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
9 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
10 DESCR_SHIPTO Character(30) VARCHAR2(30) NOT NULL (Shipping Location)
11 ADDRESS1_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship to Address Line 1
12 ADDRESS2_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 2
13 ADDRESS3_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 3
14 ADDRESS4_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 4
15 CITY_SHIPTO Character(30) VARCHAR2(30) NOT NULL Ship To City
16 STATE_SHIPTO Character(6) VARCHAR2(6) NOT NULL Ship to State
17 POSTAL_SHIPTO Character(12) VARCHAR2(12) NOT NULL Ship to Postal Code
18 COUNTRY_SHIPTO Character(3) VARCHAR2(3) NOT NULL Ship to Country
19 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
20 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
21 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
22 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
23 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
24 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
25 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
26 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
27 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention
28 STD_ID_NUM_SHIPTO Character(20) VARCHAR2(20) NOT NULL Ship To GLN