DST_SET_OM_A_VW

(SQL View)
 Index Back

Dist Code Matrix Sets


select d.business_unit, d.distrib_set_id, d.effdt, d.doc_type_om, d.product_id, d.product_group, d.cust_id, d.customer_group, d.region_cd, d.order_grp, d.business_unit_in, d.distrib_type, d.eff_status, d.dst_rl_combo_cd, p.dst_id_dis, p.dst_pct_dis, p.dst_id_rev, p.dst_pct_rev, p.dst_id_sur, p.dst_pct_sur from PS_DST_SET_OM d, PS_DST_SET_OM_ACCT p where d.business_unit = p.business_unit and d.distrib_set_id = p.distrib_set_id and d.effdt = p.effdt and d.doc_type_om = p.doc_type_om

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

Prompt Table: SP_BU_OM_NONVW

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

Default Value: NEXT

Prompt Table: DST_SET_OM

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

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

Default Value: O

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

Prompt Table: PROD_ITEM

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

Prompt Table: PRODGP_ACCT_VW

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

Prompt Table: CUSTOMER

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

Prompt Table: CUSTGP_ACCT_VW

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

Prompt Table: REGNCD_ACCT_VW

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

Prompt Table: ORD_GROUP

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

Prompt Table: SP_BUIN_NONVW

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

Prompt Table: CM_DISTR_TYPE

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

Default Value: A

14 DST_RL_COMBO_CD Character(10) VARCHAR2(10) NOT NULL Dst Rule Combo Code
15 DST_ID_DIS Character(10) VARCHAR2(10) NOT NULL Discount Distribution Code

Prompt Table: DSTCD_DIS_OM_VW

16 DST_PCT_DIS Signed Number(7,2) DECIMAL(5,2) NOT NULL Discount Dist Percentage
17 DST_ID_REV Character(10) VARCHAR2(10) NOT NULL Revenue Dist Code

Prompt Table: DSTCD_REV_OM_VW

18 DST_PCT_REV Signed Number(7,2) DECIMAL(5,2) NOT NULL Revenue Dist Percentage
19 DST_ID_SUR Character(10) VARCHAR2(10) NOT NULL Surcharge Distribution Code

Prompt Table: DSTCD_SUR_OM_VW

20 DST_PCT_SUR Signed Number(7,2) DECIMAL(5,2) NOT NULL Surcharge Dist Percentage