OMEC_OPTD_VW

(SQL View)
 Index Back

OMEC CP Option Detail

This view is based on the cp option detail 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.OPTION_NAME , A.OPTION_VALUE , A.OPTION_DESC , A.VAR_TYPE , A.VAR_LENGTH , A.VAR_DECIMAL , ' ' FROM %Table(CP_OPT_DETL) 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 OPTION_NAME Character(18) VARCHAR2(18) NOT NULL Option Name
7 OPTION_VALUE Character(18) VARCHAR2(18) NOT NULL Option Value
8 OPTION_DESC Character(25) VARCHAR2(25) NOT NULL Description
9 VAR_TYPE Character(1) VARCHAR2(1) NOT NULL Variable Type
C=Character
N=Numeric
10 VAR_LENGTH Number(2,0) SMALLINT NOT NULL Variable Length
11 VAR_DECIMAL Number(1,0) SMALLINT NOT NULL Varaible Decimal Field
12 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