OMEC_CP_OPTD_VW

(SQL View)
 Index Back

CP Option Detail

CP Option Detail 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.OPTION_NAME , A.OPTION_VALUE , A.OPTION_DESC , A.SETID , A.CUST_ID , A.VAR_TYPE , A.VAR_LENGTH , A.VAR_DECIMAL , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_OMEC_CP_OPT_DET A

  • Parent record: CP_OPT_HDR

    • # 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 OPTION_NAME Character(18) VARCHAR2(18) NOT NULL Option Name
    8 OPTION_VALUE Character(18) VARCHAR2(18) NOT NULL Option Value
    9 OPTION_DESC Character(25) VARCHAR2(25) NOT NULL Description
    10 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    11 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

    12 VAR_TYPE Character(1) VARCHAR2(1) NOT NULL Variable Type
    C=Character
    N=Numeric
    13 VAR_LENGTH Number(2,0) SMALLINT NOT NULL Variable Length
    14 VAR_DECIMAL Number(1,0) SMALLINT NOT NULL Varaible Decimal Field
    15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    16 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
    17 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Default Value: N