ORDENT_ORDGP_VW

(SQL View)
 Index Back

Order entry view on order grp

Order group view for order entry.

SELECT setid , order_grp , effdt , descr , approval_flag , bckordr_cncl_flag , bill_type_id , price_program , carrier_id , carrier_id_exp , credit_check , del_ord_restricted , descrshort , discount_pct , eff_status , freight_terms , freight_terms_exp , frt_chrg_method , order_flow_id , payment_method , pref_carrier_flag , pymnt_terms_cd , ship_partial_flag , ship_partial_ord , ship_prior_flag , ship_priority_id , ship_priority_exp , ship_type_id , ship_type_id_exp , single_ship_flag , source_cd FROM PS_ORD_GROUP

  • Related Language Record: ORD_GROUP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 APPROVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Item Definition Approved
    A=Approved
    D=Denied
    P=Pending

    Y/N Table Edit

    6 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
    N=Cancel Backorder No
    Y=Cancel Backorder Yes
    7 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
    8 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
    9 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    10 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
    11 CREDIT_CHECK Character(1) VARCHAR2(1) NOT NULL Credit Check
    N=Credit Check No
    Y=Credit Check Yes

    Y/N Table Edit

    12 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
    N=Deliveries Not Restricted
    Y=Deliveries Restricted to Order
    13 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    14 DISCOUNT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Discount Percentage
    15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    16 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    17 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
    18 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
    01=Order Value
    02=Weight
    03=Volume
    04=Order Quantity

    Default Value: 01

    19 ORDER_FLOW_ID Character(5) VARCHAR2(5) NOT NULL Order Flow
    20 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
    ACH=ACH
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DD=Direct Debit
    DR=Draft
    EC=Electronic Check
    EFT=Electronic Fund Transfer
    GE=Giro - EFT
    PL=PayPal
    WIR=Wire Report
    21 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
    N=No Preferred Carrier
    Y=Preferred Carrier
    22 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
    23 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
    N=Ship Partial No
    Y=Ship Partial Yes
    24 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
    N=Partial Order No
    Y=Partial Order Yes
    25 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
    N=Ship Prior No
    Y=Ship Prior Yes
    26 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
    27 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
    28 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    29 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
    30 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
    N=No
    Y=Yes
    31 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code