CP_OPTD_COPY_VW

(SQL View)
 Index Back

CP Option Detail Copy View

CP Option Detail Copy View

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 PS_CP_OPT_DETL A , PS_ORD_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ORDER_NO = B.ORDER_NO AND A.ORDER_INT_LINE_NO = B.ORDER_INT_LINE_NO AND A.CP_MODE = 'S' AND B.ORD_LINE_STATUS IN ('O', 'C', 'P')

  • Parent record: CP_OPT_HDR

    • # 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