CP_ORD_HEADER

(SQL Table)
Index Back

Config Direct Order Header

Config Direct Order Header

  • Parent Record Of CP_ORD_LINE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BUMGOP_NONVW

    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

    Default Value: NEXT

    3 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: M

    4 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.