ORDENT_HOLD_VW (SQL View)	Index Back
Order Header Hold

ORDENT_HOLD_VW

(SQL View)

Order Header Hold

SELECT A.BUSINESS_UNIT ,A.ORDER_NO ,A.ORDER_INT_LINE_NO ,A.SCHED_LINE_NBR ,A.SEQ_NUM ,A.HOLD_CD ,A.EFF_STATUS ,A.STATUS_DT ,A.SYSTEM_MAINTAINED ,A.HOLD_LEVEL ,A.PASS_HOLD_LEVEL ,A.PASS_HOLD_CD ,A.MESSAGE_CD ,A.LASTUPDDTTM ,A.LAST_MAINT_OPRID FROM PS_ORD_HOLD A

# 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

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

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

8 STATUS_DT Date(10) DATE Status Date

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

10 HOLD_LEVEL Character(1) VARCHAR2(1) NOT NULL Hold Level
A=Arrival Date (sch)
B=Bill To (hdr)
C=Customer (hdr)
D=No VAT Country Ship From
F=Configurator Hold
G=Freight
H=Ship To (sch)
K=No Prod Kit Comps (line)
M=Min/Max Margin (sch)
N=Min Selling Price (sch)
O=SCN Line Max Amt (line)
P=Product (line)
Q=Min/Max Quantity (line)
R=Credit Check (all)
S=Sold To (hdr)
T=Price Discrepancy (Sch)
U=Cancel Hold
V=VMI Order
W=Customer Pick-up
X=SCN Min/Max Qty (line)
Y=FSS Customer
Z=FSS Order

11 PASS_HOLD_LEVEL Character(4) VARCHAR2(4) NOT NULL Hold Code Level
CUST=Customer Hold
HDR=Header Hold
LINE=Line Hold
PROD=Product Hold
SCH=Schedule Hold
SYS=System Holds

12 PASS_HOLD_CD Character(6) VARCHAR2(6) NOT NULL System Hold Code

13 MESSAGE_CD Character(6) VARCHAR2(6) NOT NULL Message Code

14 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.

15 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
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	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	Hold Code
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
8	STATUS_DT	Date(10)	DATE	Status Date
9	SYSTEM_MAINTAINED	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit
10	HOLD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Hold Level A=Arrival Date (sch) B=Bill To (hdr) C=Customer (hdr) D=No VAT Country Ship From F=Configurator Hold G=Freight H=Ship To (sch) K=No Prod Kit Comps (line) M=Min/Max Margin (sch) N=Min Selling Price (sch) O=SCN Line Max Amt (line) P=Product (line) Q=Min/Max Quantity (line) R=Credit Check (all) S=Sold To (hdr) T=Price Discrepancy (Sch) U=Cancel Hold V=VMI Order W=Customer Pick-up X=SCN Min/Max Qty (line) Y=FSS Customer Z=FSS Order
11	PASS_HOLD_LEVEL	Character(4)	VARCHAR2(4) NOT NULL	Hold Code Level CUST=Customer Hold HDR=Header Hold LINE=Line Hold PROD=Product Hold SCH=Schedule Hold SYS=System Holds
12	PASS_HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	System Hold Code
13	MESSAGE_CD	Character(6)	VARCHAR2(6) NOT NULL	Message Code
14	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.
15	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID