OMEC_CP_OPTH_VW

(SQL View)
 Index Back

CP Option Header

CP Option Header Date Initials Issue Description 031501 dms SP2 (DI-EDWONG-14) CRM Integration

SELECT A.SOURCE_CD , A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.CP_MODE , A.CP_COMP_SEQ , A.SETID , A.CUST_ID , 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 , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_OMEC_CP_OPT_HDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

3 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
4 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
5 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

6 CP_COMP_SEQ Number(3,0) SMALLINT NOT NULL Component Sequence Field
7 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: CUST_AL_A2_SRCH

9 PARENT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Parent Item ID
10 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
11 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
13 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
14 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
15 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
16 COMP_OCCUR Character(2) VARCHAR2(2) NOT NULL Component Occurance
17 MFG_PURCH_FLG Character(1) VARCHAR2(1) NOT NULL Manufacture or Purchase Flag

Default Value: N

18 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

19 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
20 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
21 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
22 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
23 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
24 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
25 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
26 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
27 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
28 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
29 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
30 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without
31 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
32 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
33 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.
34 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
35 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag