OM_HOLDRPT_VW (SQL View)	Index Back
Order Hold View for OMC5210

OM_HOLDRPT_VW

(SQL View)

Order Hold

View for OMC5210

SELECT A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , B.SOLD_TO_CUST_ID , C.NAME1 , A.SEQ_NUM , A.HOLD_CD , A.EFF_STATUS , A.STATUS_DT , A.SYSTEM_MAINTAINED , A.LASTUPDDTTM , A.LAST_MAINT_OPRID FROM PS_ORD_HOLD A , PS_ORD_HEADER B , PS_CUSTOMER C , PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.SETCNTRLVALUE AND C.SETID = D.SETID AND A.ORDER_NO = B.ORDER_NO AND B.SOLD_TO_CUST_ID = C.CUST_ID AND D.RECNAME = 'CUSTOMER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_OM_NONVW

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 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

7 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

8 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

10 STATUS_DT Date(10) DATE Status Date

11 SYSTEM_MAINTAINED Character(1) VARCHAR2(1) NOT NULL System Maintained
Y/N Table Edit

12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

13 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_OM_NONVW
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	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
6	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
7	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
8	HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	Hold Code
9	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
10	STATUS_DT	Date(10)	DATE	Status Date
11	SYSTEM_MAINTAINED	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID