RUN_OM_ORDCOPY

(SQL Table)
Index Back

OM Electronic Commerce

OM Electronic Commerce Date Initials Issue Description 031501 mv SP2 (DI-EDWONG-14) Add SOURCE_CD

# 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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_OM_NONVW

5 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
6 ORDER_NO_TO Character(10) VARCHAR2(10) NOT NULL To Order No
7 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
8 ORDER_TYPE_CD_TO Character(3) VARCHAR2(3) NOT NULL Copy to Order Type
QUO=Sales Quote
SO=Sales Order
9 COPY_ENTIRE_QUOTE Character(1) VARCHAR2(1) NOT NULL Copy Entire Quote
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

18 WHERE_LONG Long Character CLOB Where Clause