PRODCTLG_CSTLST

(SQL Table)
Index Back

PRODCTL_CSTLST

Product Catalog Customer List

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
3 EFFDT Date(10) DATE Effective Date
4 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
5 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.
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
7 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
8 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.
9 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID