ORD_GROUP(SQL Table) |
Index Back |
---|---|
Order Group TableThis 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 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
|
2 | Character(6) | VARCHAR2(6) NOT NULL | Order Group | |
3 | 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 |