OMBCK_DST_RLSET (SQL View)	Index Back
Dist Rule/Set View OM

OMBCK_DST_RLSET

(SQL View)

Dist Rule/Set View OM

SELECT DISTINCT s.business_unit , r.dst_rule_cd , r.sequence_nbr , s.distrib_set_id , s.doc_type_om , s.effdt , s.product_id , s.product_group , s.cust_id , s.customer_group , s.region_cd , s.order_grp , s.business_unit_in , s.distrib_type , s.eff_status , t.seq_num FROM ps_dst_set_om_acct t , ps_dst_set_om s , PS_DST_RULE_SEQ_OM r , ps_set_cntrl_rec sc WHERE s.dst_rl_combo_cd = r.dst_rl_combo_cd AND t.business_unit = s.business_unit AND sc.setcntrlvalue = t.business_unit AND sc.recname = 'DST_RULE_SEQ_OM' AND sc.setid = r.setid AND t.distrib_set_id = s.distrib_set_id AND t.effdt = s.effdt AND t.doc_type_om = s.doc_type_om

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 DST_RULE_CD Character(10) VARCHAR2(10) NOT NULL Dist Rule Code

3 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

4 DISTRIB_SET_ID Character(10) VARCHAR2(10) NOT NULL Distribution Set ID

5 DOC_TYPE_OM Character(1) VARCHAR2(1) NOT NULL Document Type
B=Claimback Contract
C=Contract
O=Sales Order
R=Return Material Authorization

6 EFFDT Date(10) DATE Effective Date

7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

8 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group

9 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

10 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

11 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

12 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group

13 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

14 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

16 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	DST_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Dist Rule Code
3	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
4	DISTRIB_SET_ID	Character(10)	VARCHAR2(10) NOT NULL	Distribution Set ID
5	DOC_TYPE_OM	Character(1)	VARCHAR2(1) NOT NULL	Document Type B=Claimback Contract C=Contract O=Sales Order R=Return Material Authorization
6	EFFDT	Date(10)	DATE	Effective Date
7	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
8	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
9	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
10	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
11	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
12	ORDER_GRP	Character(6)	VARCHAR2(6) NOT NULL	Order Group
13	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
14	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
15	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
16	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence