CP_OPT_D_VW

(SQL View)
 Index Back

CP Option Detail

CP Option Detail

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

  • 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
    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 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description field.