OM_ORDCOPY_AET(SQL Table) |
Index Back |
|---|---|
Sales Order Copy State RecordState record used by AE program OM_ORD_COPY. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_OM_NONVW |
| 6 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 7 | BU_PC_SQL | Character(40) | VARCHAR2(40) NOT NULL | BU_PC Sql |
| 8 | BU_SECURITY | Character(1) | VARCHAR2(1) NOT NULL | Business Unit Security |
| 9 | CB_PROCESS | Character(1) | VARCHAR2(1) NOT NULL | Process Claimback |
| 10 | COPY_ENTIRE_QUOTE | Character(1) | VARCHAR2(1) NOT NULL | Copy Entire Quote |
| 11 | DATE_STAMP | Date(10) | DATE | Date Stamp |
| 12 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 13 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 14 | DELIVERY_ID_LAST | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 15 | EDITTABLE9 | Character(15) | VARCHAR2(15) NOT NULL | Ninth Edit Table |
| 16 | EDIT_ACTIVITY | Character(15) | VARCHAR2(15) NOT NULL | Activity Edit Table |
| 17 | EDIT_BU_PC | Character(15) | VARCHAR2(15) NOT NULL | Common PC Business Unit field. |
| 18 | EDIT_RES_CAT | Character(15) | VARCHAR2(15) NOT NULL | Category Edit Table |
| 19 | EDIT_RES_SUB | Character(15) | VARCHAR2(15) NOT NULL | SubCategory Edit Table |
| 20 | HEADER_FLG | Character(1) | VARCHAR2(1) NOT NULL | Header Flag |
| 21 | IBU_EDITTBL_KIT | Character(15) | VARCHAR2(15) NOT NULL | Ninth Edit Table |
| 22 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OM Work Flag |
| 23 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 24 | ORDER_DATE | Date(10) | DATE | Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 25 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 26 | 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 |
| 27 | ORDER_NO_TO | Character(10) | VARCHAR2(10) NOT NULL | To Order No |
| 28 | ORDER_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Order Type
QUO=Sales Quote SO=Sales Order |
| 29 | ORDER_TYPE_CD_TO | Character(3) | VARCHAR2(3) NOT NULL |
Copy to Order Type
QUO=Sales Quote SO=Sales Order |
| 30 | ORDER_GRP | Character(6) | VARCHAR2(6) NOT NULL | Order Group |
| 31 | RUN_OM_BACKGRND | Character(1) | VARCHAR2(1) NOT NULL |
Run Order Completion
Y/N Table Edit |
| 32 | RUN_OM_PRICING | Character(1) | VARCHAR2(1) NOT NULL |
Run Repricing
Y/N Table Edit |
| 33 | RUN_OMCREDIT | Character(1) | VARCHAR2(1) NOT NULL |
Run Credit Checking
Y/N Table Edit |
| 34 | RUN_OMDEMAND | Character(1) | VARCHAR2(1) NOT NULL |
Run Populate Demand
Y/N Table Edit |
| 35 | RUN_OMHOLD | Character(1) | VARCHAR2(1) NOT NULL |
Run Hold Checking
Y/N Table Edit |
| 36 | RUN_RESERVATIONS | Character(1) | VARCHAR2(1) NOT NULL |
Run Reservations Job
Y/N Table Edit |
| 37 | RUN_DELIVERIES | Character(1) | VARCHAR2(1) NOT NULL |
Manage Deliveries
Y/N Table Edit |
| 38 | RUN_FREIGHT | Character(1) | VARCHAR2(1) NOT NULL |
Perform Freight
Y/N Table Edit |
| 39 | REQ_ARRIVAL_DTTM | DateTime(26) | TIMESTAMP | Requested Arrival |
| 40 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 41 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 42 | SCHED_SHIP_DATE | Date(10) | DATE | Scheduled Ship Date |
| 43 | SECURITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security N=No Security O=User ID Level Security |
| 44 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 45 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 46 | SETID_BROKER | Character(5) | VARCHAR2(5) NOT NULL | Broker Setid |
| 47 | SETID_CARRIER | Character(5) | VARCHAR2(5) NOT NULL | Carrier Setid |
| 48 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 49 | SETID_CUST_BILL | Character(5) | VARCHAR2(5) NOT NULL | Bill-to Cust setid |
| 50 | SETID_CUST_GRP | Character(5) | VARCHAR2(5) NOT NULL | Customer Group SetID |
| 51 | SETID_CUST_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Customer Item Nbr Setid |
| 52 | SETID_CUST_SHIPTO | Character(5) | VARCHAR2(5) NOT NULL | Shipto Cust SetID |
| 53 | SETID_DS_NETDET | Character(5) | VARCHAR2(5) NOT NULL | ds netdet |
| 54 | SETID_DST_RULE | Character(5) | VARCHAR2(5) NOT NULL | Distribution Sets Setid |
| 55 | SETID_FRT_TERMS | Character(5) | VARCHAR2(5) NOT NULL | Freight Terms SETID |
| 56 | SETID_ORD_GRP | Character(5) | VARCHAR2(5) NOT NULL | Order Group Setid |
| 57 | SETID_PAYTRMS | Character(5) | VARCHAR2(5) NOT NULL | Payment Terms Setid |
| 58 | SETID_PROD_GRP | Character(5) | VARCHAR2(5) NOT NULL | Product Group SetID |
| 59 | SETID_PRODUCT | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 60 | SETID_REGION | Character(5) | VARCHAR2(5) NOT NULL | Region SetID |
| 61 | SETID_RESOURCE | Character(5) | VARCHAR2(5) NOT NULL | Resource SetID |
| 62 | SETID_SECURITY | Character(1) | VARCHAR2(1) NOT NULL | TableSet ID Security |
| 63 | SETID_SHIP_METHOD | Character(5) | VARCHAR2(5) NOT NULL | Ship Method SetID |
| 64 | SETID_SHP_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | Ship Priority Setid |
| 65 | SETID_TAX_CD | Character(5) | VARCHAR2(5) NOT NULL | Setid Tax Code |
| 66 | SETID_UOM | Character(5) | VARCHAR2(5) NOT NULL | UOM Setid |
| 67 | WHERE_LONG | Long Character | CLOB | Where Clause |