RMA_ORDGRP_VW (SQL View)	Index Back
Order Group view 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.

RMA_ORDGRP_VW

(SQL View)

Order Group view

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.

SELECT SETID , ORDER_GRP , EFFDT , DESCR , APPROVAL_FLAG , BCKORDR_CNCL_FLAG , CREDIT_CHECK , DESCRSHORT , DISCOUNT_PCT , EFF_STATUS , FREIGHT_TERMS , ORDER_FLOW_ID , PRICE_PROGRAM , PAYMENT_METHOD , PYMNT_TERMS_CD , SHIP_PARTIAL_FLAG , SHIP_PARTIAL_ORD , SHIP_PRIOR_FLAG , SHIP_PRIORITY_ID , SHIP_TYPE_ID , 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
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
Y/N Table Edit
Default Value: N

7 CREDIT_CHECK Character(1) VARCHAR2(1) NOT NULL Credit Check
N=Credit Check No
Y=Credit Check Yes
Y/N Table Edit
Default Value: Y

8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

9 DISCOUNT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Discount Percentage

10 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

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

12 ORDER_FLOW_ID Character(5) VARCHAR2(5) NOT NULL Order Flow

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

14 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

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

16 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes
Y/N Table Edit
Default Value: N

17 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
N=Partial Order No
Y=Partial Order Yes
Default Value: N

18 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes
Y/N Table Edit
Default Value: N

19 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code

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

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

#	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 Y/N Table Edit Default Value: N
7	CREDIT_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Credit Check N=Credit Check No Y=Credit Check Yes Y/N Table Edit Default Value: Y
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
9	DISCOUNT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Discount Percentage
10	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
11	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
12	ORDER_FLOW_ID	Character(5)	VARCHAR2(5) NOT NULL	Order Flow
13	PRICE_PROGRAM	Character(10)	VARCHAR2(10) NOT NULL	Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
14	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
15	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.
16	SHIP_PARTIAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Schedules N=Ship Partial No Y=Ship Partial Yes Y/N Table Edit Default Value: N
17	SHIP_PARTIAL_ORD	Character(1)	VARCHAR2(1) NOT NULL	Partial Order N=Partial Order No Y=Partial Order Yes Default Value: N
18	SHIP_PRIOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Ship Prior to Request Date N=Ship Prior No Y=Ship Prior Yes Y/N Table Edit Default Value: N
19	SHIP_PRIORITY_ID	Character(6)	VARCHAR2(6) NOT NULL	Shipping Priority Code
20	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
21	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code