PRODCTLG_CUST (SQL Table)	Index Back
Prod Catlg cust-catalog link This record is used to attach a Product Catalog to a Sold-To Customer.

PRODCTLG_CUST

(SQL Table)

Prod Catlg cust-catalog link

This record is used to attach a Product Catalog to a Sold-To Customer.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
Prompt Table: PRODCTLG_TBL

4 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

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

6 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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	CATALOG_NBR	Character(18)	VARCHAR2(18) NOT NULL	Catalog Number Prompt Table: PRODCTLG_TBL
4	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
5	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.
6	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID