ORD_GROUP

(SQL Table)
Index Back

Order Group Table

This table holds information which may categorize the contents of a sales order or quotation. It also holds information that could be used as defaults on orders when the information is absent from the customer record or not entered by the user. Note: Any field changes made to this record should also be made to record OMB_OGRP_TAO

  • 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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %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

    Default Value: N

    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

    Prompt Table: BI_TYPE_EF_VW

    8 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL

    Prompt Table: EOEP_ARB_PR_VW

    9 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
    N=No Preferred Carrier
    Y=Preferred Carrier
    10 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

    Prompt Table: CARRIER_ID

    11 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

    Prompt Table: CARRIER_ID

    12 CREDIT_CHECK Character(1) VARCHAR2(1) NOT NULL Credit Check
    N=Credit Check No
    Y=Credit Check Yes

    Default Value: Y

    13 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
    N=Deliveries Not Restricted
    Y=Deliveries Restricted to Order
    14 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    15 DISCOUNT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Discount Percentage
    16 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    17 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    18 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    19 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
    01=Order Value
    02=Weight
    03=Volume
    04=Order Quantity

    Default Value: 04

    20 ORDER_FLOW_ID Character(5) VARCHAR2(5) NOT NULL Order Flow
    21 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

    Prompt Table: OM_PAY_MTHD_VW

    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.

    Prompt Table: AR_TRMS_VW

    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

    Prompt Table: SHIP_PRIORITY

    27 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority

    Prompt Table: SHIP_PRIORITY

    28 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD

    29 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

    Prompt Table: SHIP_METHOD

    30 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
    N=No
    Y=Yes

    Default Value: N

    31 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

    Prompt Table: ORDSRCCD_ADD_VW

    32 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.
    33 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    34 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added