OM_HOLD_AET

(SQL Table)
 Index Back

State Table for OM_HOLD

Used as a state work table for the AE OM_HOLD program. Date Init. Issue # Description 080102 JJM F-CJORGENS-43 Performance Improvements 111506 dms 1576506002 Add SQL_WHERE_003

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
6 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
7 ORDER_NO_FROM Character(15) VARCHAR2(15) NOT NULL Order Number From
8 ORDER_NO_TO Character(10) VARCHAR2(10) NOT NULL To Order No
9 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
10 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
11 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes
12 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
13 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
14 CURRENT_DATE1 Date(10) DATE 12/20/01 EGS (CN#PL900-1): Added 10/07/02 JC (CN#PL880-1): Added FROM_DATE label
15 CURRENT_DTTM DateTime(26) TIMESTAMP 08/27/01 EGS (CN#PL900-1.0): Added
16 PO Character(1) VARCHAR2(1) NOT NULL Purchasing
17 SETID_CUST_MSG Character(5) VARCHAR2(5) NOT NULL Customer Message SETID
18 SETID_MSG_CUST Character(5) VARCHAR2(5) NOT NULL Message Tbl SETID for Cust
19 SETID_PROD_MSG Character(5) VARCHAR2(5) NOT NULL Product Message SETID
20 SETID_MSG_PROD Character(5) VARCHAR2(5) NOT NULL Message Tbl SETID for Product
21 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
22 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
23 SETID2 Character(5) VARCHAR2(5) NOT NULL 2nd SetId
24 SETID_CONTRACT Character(5) VARCHAR2(5) NOT NULL Contract Setid
25 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
26 HOLD_ARRV_DT Character(6) VARCHAR2(6) NOT NULL Arrival Date Window Hold
27 HOLD_NO_SOLD Character(6) VARCHAR2(6) NOT NULL No Sold To
28 HOLD_NO_SHIP Character(6) VARCHAR2(6) NOT NULL No Ship To
29 HOLD_NO_KIT_COMPS Character(6) VARCHAR2(6) NOT NULL No Product Kit Components
30 HOLD_NO_BILL Character(6) VARCHAR2(6) NOT NULL No Bill To
31 HOLD_MAX_MARGIN Character(6) VARCHAR2(6) NOT NULL Exceeds Maximum Margin
32 HOLD_MAX_ORDER_AMT Character(6) VARCHAR2(6) NOT NULL Exceeds Maximum Order Amount
33 HOLD_MAX_QTY Character(6) VARCHAR2(6) NOT NULL Exceeds Maximum Quantity
34 HOLD_MIN_MARGIN Character(6) VARCHAR2(6) NOT NULL Less Than Minimum Margin
35 HOLD_MIN_PRICE Character(6) VARCHAR2(6) NOT NULL < Minimum Selling Price
36 HOLD_MIN_QTY Character(6) VARCHAR2(6) NOT NULL Less Than Minimum Quantity
37 HOLD_SCN_LN_AMT Character(6) VARCHAR2(6) NOT NULL 11092001 YB 8.4 ADDED LABEL ID (9461701)
38 HOLD_SCN_MAX_QTY Character(6) VARCHAR2(6) NOT NULL 11092001 YB 8.4 ADDED LABELID(9461701)
39 HOLD_SCN_MIN_QTY Character(6) VARCHAR2(6) NOT NULL 11092001 YB 8.4 ADDED LABELID(9461701)
40 HOLD_CREDIT_CRD Character(6) VARCHAR2(6) NOT NULL Credit Card Hold
41 HOLD_VMI Character(6) VARCHAR2(6) NOT NULL Supplier Managed Inventory
42 HOLD_CUST_PICKUP Character(6) VARCHAR2(6) NOT NULL Customer Pick Up
43 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
44 RUN_OM_BACKGRND Character(1) VARCHAR2(1) NOT NULL Run Order Completion

Y/N Table Edit

45 RUN_OM_PRICING Character(1) VARCHAR2(1) NOT NULL Run Repricing

Y/N Table Edit

46 RUN_OMCREDIT Character(1) VARCHAR2(1) NOT NULL Run Credit Checking

Y/N Table Edit

47 RUN_OMDEMAND Character(1) VARCHAR2(1) NOT NULL Run Populate Demand

Y/N Table Edit

48 RUN_OMHOLD Character(1) VARCHAR2(1) NOT NULL Run Hold Checking

Y/N Table Edit

49 RUN_RESERVATIONS Character(1) VARCHAR2(1) NOT NULL Run Reservations Job

Y/N Table Edit

50 RUN_DELIVERIES Character(1) VARCHAR2(1) NOT NULL Manage Deliveries

Y/N Table Edit

51 RUN_FREIGHT Character(1) VARCHAR2(1) NOT NULL Perform Freight

Y/N Table Edit

52 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
53 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
54 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
55 PROCESS_INSTANCE2 Number(10,0) DECIMAL(10) NOT NULL Process Instance
56 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
57 HOLD_COUNT Number(4,0) SMALLINT NOT NULL Number of Holds
58 HOLD_COUNT_MAX Number(4,0) SMALLINT NOT NULL Number of Holds
59 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
60 OM_FLAG Character(1) VARCHAR2(1) NOT NULL OM Work Flag
61 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
62 FLAG4 Character(1) VARCHAR2(1) NOT NULL Flag4
63 UPS_FLAG1 Character(1) VARCHAR2(1) NOT NULL Flag
64 UPS_FLAG2 Character(1) VARCHAR2(1) NOT NULL Flag
65 UPS_FLAG3 Character(1) VARCHAR2(1) NOT NULL Flag
66 SQL_WHERE_001 Character(254) VARCHAR2(254) NOT NULL
67 SQL_WHERE_002 Character(254) VARCHAR2(254) NOT NULL
68 SQL_TABLES Character(254) VARCHAR2(254) NOT NULL SQL Tables
69 HOLD_REQD Character(1) VARCHAR2(1) NOT NULL Hold Processing Required
70 SCM_FSS_OPTION Character(1) VARCHAR2(1) NOT NULL 02/14/06 EGS: Created
1=Enable at Install
2=Enable at Business Unit
3=No Validation
71 FIRST_MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Report First Online Match Only
72 BU_FSS_FLG Character(1) VARCHAR2(1) NOT NULL 02/15/06 EGS: Created
73 HOLD_CUST_FSS Character(6) VARCHAR2(6) NOT NULL 02/15/06 EGS: Created
74 HOLD_ORD_FSS Character(6) VARCHAR2(6) NOT NULL 02/15/06 EGS: Created
75 SQL_WHERE_003 Long Character(4000) CLOB
76 HOLD_COUNTRY_SHIP Character(6) VARCHAR2(6) NOT NULL No VAT Country Ship From