RUN_OM_SCON(SQL Table) |
Index Back |
|---|---|
OM Create SO from Contract |
| # | 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: SCN_HDR_CUST_VW |
| 6 | DFLT_ORD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Default Order Status
O=Open P=Pending Default Value: O |
| 7 | ORDER_GRP | Character(6) | VARCHAR2(6) NOT NULL |
Order Group
Prompt Table: ORD_GROUP |
| 8 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL |
Source Code
Prompt Table: ORD_SOURCE_CD |
| 9 | CREATE_SINGLE_SO | Character(1) | VARCHAR2(1) NOT NULL |
Order Creation
M=Single Ord for Multi Contract S=Single Ord for Each Contract Default Value: M |
| 10 | THRU_DATE | Date(10) | DATE NOT NULL | Through Date |
| 11 | END_TM | Time(15) | TIMESTAMP | End Time |
| 12 | THRU_DTTM | DateTime(26) | TIMESTAMP | Thru Datetime |
| 13 | ORDER_DATE | Date(10) | DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Default Value: %date |