IN_SDWC_CHWK_VW

(SQL View)
 Index Back

Demand past ship date chart

Data for charting

SELECT 0 , ' ' , ' ' , 0 , 0 , ' ' , 0 , ' ' , ' ' , ' ' , ' ' , 0 , 0 , ' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
2 EXT_NET_PRC_TEXT Character(30) VARCHAR2(30) NOT NULL Extended Net Price
3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
4 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
5 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
6 TEXT80 Character(80) VARCHAR2(80) NOT NULL 80 Char text field
7 WM_DATACOLOR Signed Number(4,0) DECIMAL(3) NOT NULL Data Color
8 BILLING_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Status
A=Available
B=In Billing
C=Contract
I=Invoiced
N=Not Avail
P=In Process
S=Staged
9 IN_SDWC_DOC_TYPE Character(2) VARCHAR2(2) NOT NULL Document Type
00=MSR
10=Requisition
20=Purchase Order
10 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
11 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled
12 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
13 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
14 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled