RUN_OM_HOLD

(SQL Table)
Index Back

OM Auto Hold Processing

Date Initials Issue Description 120701 dms ADA 508 Set default for business unit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_OM_NONVW

5 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW

6 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: %EDITTABLE

7 ORDER_NO_TO Character(10) VARCHAR2(10) NOT NULL To Order No

Prompt Table: %EDITTABLE

8 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

Prompt Table: OMH_SRC_PR_VW

9 RUN_OM_BACKGRND Character(1) VARCHAR2(1) NOT NULL Run Order Completion

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

17 HOLD_REQD Character(1) VARCHAR2(1) NOT NULL Hold Processing Required

Y/N Table Edit

Default Value: N