ARFO_ONA_CGR_VW

(SQL View)
 Index Back

On-acount customer group

On-acount customer group

SELECT B.OPRID , A.SETID ,A.CUST_ID ,A.CUST_GRP_TYPE ,A.CUSTOMER_GROUP FROM PS_CUST_CGRP_LNK A ,PS_ARFO_PFON_CSTGR B WHERE A.SETID=B.SETID AND A.CUST_GRP_TYPE=B.CUST_GRP_TYPE AND A.CUSTOMER_GROUP=B.CUSTOMER_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: ARFO_PRF_ONACCT.OPRID

2 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

Prompt Table: SP_SETCU_NONVW

3 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: AR_CUSTSCHC_VW

4 CUST_GRP_TYPE Character(4) VARCHAR2(4) NOT NULL Customer Group Type
ACCT=Accounting
ALOC=Allocation Group
BO=Backorder/Reservations
CDT=Canceled Debt Reporting
CLMB=Claimback Contract
COLL=Collection
DD=Direct Debit
DRFT=Draft
FCST=Forecasting
FRT=Freight
PBIL=Pay/Bill Management
PRC=Pricing
PRUL=Pricing Arbitration Plan
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources Of Supply
TAX=Tax
TRPT=Transportation

Prompt Table: CUST_GRP_VW1

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

Prompt Table: CUST_GRP_VW