ORD_LN_HOLD_VW (SQL View)	Index Back
Order Line Hold

ORD_LN_HOLD_VW

(SQL View)

Order Line 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 WHERE A.ORDER_INT_LINE_NO <> 0 AND A.SCHED_LINE_NBR = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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
Prompt Table: ORD_HEADER

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
Prompt Table: ORD_LINE

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
Prompt Table: ORD_SCHEDULE

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 1

6 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
Prompt Table: HOLD_CD

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

8 STATUS_DT Date(10) DATE NOT NULL Status Date
Default Value: %date

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

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
Default Value: LINE

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 Prompt Table: BUS_UNIT_TBL_OM
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 Prompt Table: ORD_HEADER
3	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line Prompt Table: ORD_LINE
4	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number Prompt Table: ORD_SCHEDULE
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
6	HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	Hold Code Prompt Table: HOLD_CD
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
8	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: %date
9	SYSTEM_MAINTAINED	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit Default Value: N
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 Default Value: LINE
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