ORD_CNCLHLD_VW

(SQL View)
 Index Back

Order Schedule 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.PROD_COMPONENT_ID ,A.ACTIVE_HOLD_DTTM ,A.LASTUPDDTTM ,A.LAST_MAINT_OPRID FROM PS_ORD_HOLD A WHERE A.ORDER_INT_LINE_NO <> 0 AND A.SCHED_LINE_NBR <> 0 AND A.HOLD_LEVEL = 'U'

# 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: SCH

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 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID
15 ACTIVE_HOLD_DTTM 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.

Default Value: %datetime

16 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.
17 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID