IN_SDWCPA1_CLSV

(SQL View)
 Index Back

Overdue PAR view

Oprclass security - realtimE

SELECT P.EOEN_PRCS_NAME , P.EOEN_CATEGORY , 0 , P.IN_SDWC_DOC_TYPE , %subrec(IN_DMD_NKEY_SBR, P) , %subrec(IN_SDWC_PAR_SBR, P) , P.ORDER_NO , P.BUSINESS_UNIT %Concat '~' %Concat P.DEMAND_SOURCE %Concat '~' %Concat P.SOURCE_BUS_UNIT %Concat '~' %Concat P.ORDER_NO %Concat '~' %Concat %NumToChar(P.ORDER_INT_LINE_NO) %Concat '~' %Concat %NumToChar(P.SCHED_LINE_NBR) %Concat '~' %Concat %NumToChar(P.DEMAND_LINE_NO) , '0' , P.ROWNBR , S.OPRCLASS FROM PS_IN_SDWC_MPA1_VW P , PS_SEC_BU_CLS S , PS_SEC_BU_CLS S1 WHERE S.BUSINESS_UNIT = P.BUSINESS_UNIT AND S1.OPRCLASS = S.OPRCLASS AND S1.BUSINESS_UNIT = P.SOURCE_BUS_UNIT UNION ALL SELECT P.EOEN_PRCS_NAME , P.EOEN_CATEGORY , 0 , P.IN_SDWC_DOC_TYPE , %subrec(IN_DMD_NKEY_SBR, P) , %subrec(IN_SDWC_PAR_SBR, P) , P.ORDER_NO , P.BUSINESS_UNIT %Concat '~' %Concat P.DEMAND_SOURCE %Concat '~' %Concat P.SOURCE_BUS_UNIT %Concat '~' %Concat P.ORDER_NO %Concat '~' %Concat %NumToChar(P.ORDER_INT_LINE_NO) %Concat '~' %Concat %NumToChar(P.SCHED_LINE_NBR) %Concat '~' %Concat %NumToChar(P.DEMAND_LINE_NO) , '0' , P.ROWNBR , S.OPRCLASS FROM PS_IN_SDWC_RPA1_VW P , PS_SEC_BU_CLS S , PS_SEC_BU_CLS S1 WHERE S.BUSINESS_UNIT = P.BUSINESS_UNIT AND S1.OPRCLASS = S.OPRCLASS AND S1.BUSINESS_UNIT = P.SOURCE_BUS_UNIT UNION ALL SELECT P.EOEN_PRCS_NAME , P.EOEN_CATEGORY , 0 , P.IN_SDWC_DOC_TYPE , %subrec(IN_DMD_NKEY_SBR, P) , %subrec(IN_SDWC_PAR_SBR, P) , P.ORDER_NO , P.BUSINESS_UNIT %Concat '~' %Concat P.DEMAND_SOURCE %Concat '~' %Concat P.SOURCE_BUS_UNIT %Concat '~' %Concat P.ORDER_NO %Concat '~' %Concat %NumToChar(P.ORDER_INT_LINE_NO) %Concat '~' %Concat %NumToChar(P.SCHED_LINE_NBR) %Concat '~' %Concat %NumToChar(P.DEMAND_LINE_NO) , '0' , P.ROWNBR , S.OPRCLASS FROM PS_IN_SDWC_PPA1_VW P , PS_SEC_BU_CLS S , PS_SEC_BU_CLS S1 WHERE S.BUSINESS_UNIT = P.BUSINESS_UNIT AND S1.OPRCLASS = S.OPRCLASS AND S1.BUSINESS_UNIT = P.SOURCE_BUS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 IN_SDWC_DOC_TYPE Character(2) VARCHAR2(2) NOT NULL Document Type
00=MSR
10=Requisition
20=Purchase Order
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

6 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
7 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BU_FS_NONVW

8 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
9 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
10 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
12 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
13 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
14 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
15 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
16 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
17 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
18 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
19 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
20 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
21 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date
22 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
23 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
24 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
25 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
26 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
27 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.
28 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
29 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
30 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
31 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
32 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
33 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
34 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
35 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
36 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
37 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
39 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
40 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes
41 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
42 CART_GROUP Character(5) VARCHAR2(5) NOT NULL Par Location Group
43 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
44 DISTRIB_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Line Status
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled
45 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
46 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
47 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
48 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
49 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
50 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.
51 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled
52 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
53 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
54 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
55 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
56 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
57 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID
58 ORDER_BU Character(5) VARCHAR2(5) NOT NULL Par Loc Order Business Unit
59 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
60 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document
61 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash
62 EOEN_STATUS Character(1) VARCHAR2(1) NOT NULL EOEN Status
0=Open
1=Closed
63 ROWNBR Number(7,0) INTEGER NOT NULL Row number
64 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class