ORD_TRK_PO_VW

(SQL View)
Index Back

Order Track Vw - Purchased

Order Track View - Purchased Date Initials Issue Description 052704 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND

SELECT H.BUSINESS_UNIT , H.ORDER_NO , L.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , %subrec(ORD_TRK_HDR_SBR, H) , %subrec(ORD_TRK_LIN_SBR, L) , %subrec(ORD_TRK_SCH_SBR, S) , ' ' , ' ' , 0 , 0 , ' ' , 0 , 0 , P.PO_DT , ' ' FROM PS_ORD_HEADER H , PS_ORD_LINE L , PS_ORD_SCHEDULE S , PS_IN_PEG_DMD_POVW D , PS_PO_HDR P WHERE %Sql(OM_ORDTRK_PO_VW_SQL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 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
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
6 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code
7 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
8 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled
9 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
10 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
11 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
12 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
13 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
14 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
15 LIST_PRICE_ORIG Signed Number(17,4) DECIMAL(15,4) NOT NULL Original List Price
16 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
17 ORD_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
C=Closed
O=Open
P=Pending
X=Canceled
18 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
19 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
20 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
21 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
22 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
23 CANCEL_DATE Date(10) DATE Cancel Date
24 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
25 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
26 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
27 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
28 INVOICE_DT Date(10) DATE Invoice Date
29 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
30 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
31 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
32 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
33 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
34 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
35 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
36 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
37 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
38 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
39 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
40 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
41 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
42 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
43 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
44 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
45 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
46 SHIP_DATE Date(10) DATE Item Shipping Date
47 LATEST_INVOICE Character(22) VARCHAR2(22) NOT NULL Latest Invoice