CUST_CGRP_LNK

(SQL Table)
Index Back

Customer Cust-Group Link

Date Init. Issue # Description 08/14/01 JJM DI-EDWONG-17 Inverted CUST_ID, SETID in index

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 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.
3 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
4 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

Prompt Table: %EDITTABLE

5 DEFAULT_TAX_GRP Character(1) VARCHAR2(1) NOT NULL Default Tax Group

Y/N Table Edit

Default Value: N

6 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
7 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.
8 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID