PCTLG_CGRP_LNK (SQL Table)	Index Back
Product Catalog/Cust Grp link Product Catalog/Customer Group link.

PCTLG_CGRP_LNK

(SQL Table)

Product Catalog/Cust Grp link

Product Catalog/Customer Group link.

# 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 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

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 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
Prompt Table: PRODCTLG_TBL

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

#	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	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	CATALOG_NBR	Character(18)	VARCHAR2(18) NOT NULL	Catalog Number Prompt Table: PRODCTLG_TBL
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive