RUN_OM_EC(SQL Table) |
Index Back |
|---|---|
OM Electronic CommerceOM 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
Prompt Table: SP_BU_OM_NONVW |
| 5 | EIP_PROGRAM |
Character(10) | VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync Prompt Table: OMEC_PROG_VW |
| 6 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
Prompt Table: %EDITTABLE |
| 7 | SOURCE_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Source Code
Prompt Table: ORD_SOURCE_CD |
| 8 | DELETE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Deletion Flag
Default Value: N |
| 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 |