OMEC_OPTH_VW

(SQL View)
 Index Back

OMEC CP Option Header

This view is based on the cp option header and is used in app engine OM_EC Date Initials Issue # Description -------- ---------- ------------------------------- -------------------------------------------------- 010505 sfc F-KNANN-V59N4 Created

SELECT A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.CP_MODE , A.CP_COMP_SEQ , A.PARENT_ITEM_ID , A.BUSINESS_UNIT_IN , A.PRDN_AREA_CODE , A.INV_ITEM_ID , A.PRODUCT_ID , A.CONFIG_CODE , A.CP_TEMPLATE_ID , A.COMP_OCCUR , A.MFG_PURCH_FLG , A.MFG_PROCESS_FLG , A.PO_DISTRIB_STATUS , A.PRODUCTION_ID , A.BUSINESS_UNIT_PO , A.REQ_ID , A.REQ_LINE_NBR , A.REQ_SCHED_NBR , A.QTY_REQ , A.PRICE_REQ , A.SCHED_ARRV_DTTM , A.QTY_PER , A.QTY_CODE , A.OPTIONAL_SHIP , A.UNIT_OF_MEASURE , A.PROCESS_INSTANCE , A.LASTUPDDTTM , ' ' FROM %Table(CP_OPT_HDR) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

2 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
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 CP_MODE Character(1) VARCHAR2(1) NOT NULL Rule Processing Modes Field
A=CRM Internal
C=Model Tester
M=Direct Production Order
R=Direct Requisition Order
S=Sales Order
W=CRM External

Default Value: S

5 CP_COMP_SEQ Number(3,0) SMALLINT NOT NULL Component Sequence Field
6 PARENT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Parent Item ID
7 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
8 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
11 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
12 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
13 COMP_OCCUR Character(2) VARCHAR2(2) NOT NULL Component Occurance
14 MFG_PURCH_FLG Character(1) VARCHAR2(1) NOT NULL Manufacture or Purchase Flag

Default Value: N

15 MFG_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Manufacture Process Flag
B=Before PID
C=Costing Error
E=Configuration Error
I=In Process
T=Complete PID

Default Value: N

16 PO_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PO Distribution Status
0=Non-PO
1=Active
2=In-process
3=Error
4=Processed
5=Modified
17 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
18 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
19 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
20 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
21 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
22 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
23 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
24 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
25 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
26 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
27 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without
28 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
29 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
30 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
31 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values