AHLD_HOLD_TMP (SQL Table)	Index Back
OM Auto Hold Holds This is a temporary table used by the background processing of credit re-evaluation and hold code re-evaluation.

AHLD_HOLD_TMP

(SQL Table)

OM Auto Hold Holds

This is a temporary table used by the background processing of credit re-evaluation and hold code re-evaluation.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 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

4 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

5 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

6 STATUS_DT Date(10) DATE Status Date

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

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

9 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

10 HOLD_COUNT Number(4,0) SMALLINT NOT NULL Number of Holds

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

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

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

14 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	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
4	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
5	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
6	STATUS_DT	Date(10)	DATE	Status Date
7	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.
8	HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	Hold Code
9	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
10	HOLD_COUNT	Number(4,0)	SMALLINT NOT NULL	Number of Holds
11	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
12	MESSAGE_CD	Character(6)	VARCHAR2(6) NOT NULL	Message Code
13	PASS_HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	System Hold Code
14	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