RUN_OM_DEMAND

(SQL Table)
Index Back

OM Demand Interface

Date Init. Issue # Description 120701 dms ADA 508 Set default for business unit 052504 twh F-KNANN-V59N4 Fulfillment Redesign

# 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_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

Prompt Table: SP_BU_OM_NONVW

5 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SP_BUIN_NONVW

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: OMD_SRC_PR_VW

9 RESTART_PI Number(10,0) DECIMAL(10) NOT NULL Restart Process Instance

Prompt Table: OMBI_PRC_VW

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit