CUST_PRENOTE (SQL Table)	Index Back
Customer - Prenote History History of prenote status changes

CUST_PRENOTE

(SQL Table)

Customer - Prenote History

History of prenote status changes

Parent record: CUSTOMER

# 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.
Prompt Table: CUSTOMER

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 PRENOTE_DTTM DateTime(26) TIMESTAMP Datetime of the change of status of the Prenote

5 PRENOTE_DATE Date(10) DATE Prenotification Date

6 UPDATED_BY Character(4) VARCHAR2(4) NOT NULL This field describes how the Prenote Status was updated.
BANK=Receive Bank EFT File process
CRDD=Create Direct Debits process
DDWS=Direct Debit Worksheet
FEFT=Format EFT File process
FGDS=Financial Gateway - Dispatched
FGPD=Financial Gateway - Paid
FGRJ=Financial Gateway - Rejected
FGWY=Financial Gateway
USER=User

7 PRENOTE_STATUS Character(1) VARCHAR2(1) NOT NULL Prenotification Status
C=Confirmed
N=New
P=Pending
R=Rejected
S=Submitted

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

9 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

#	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. Prompt Table: CUSTOMER
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	PRENOTE_DTTM	DateTime(26)	TIMESTAMP	Datetime of the change of status of the Prenote
5	PRENOTE_DATE	Date(10)	DATE	Prenotification Date
6	UPDATED_BY	Character(4)	VARCHAR2(4) NOT NULL	This field describes how the Prenote Status was updated. BANK=Receive Bank EFT File process CRDD=Create Direct Debits process DDWS=Direct Debit Worksheet FEFT=Format EFT File process FGDS=Financial Gateway - Dispatched FGPD=Financial Gateway - Paid FGRJ=Financial Gateway - Rejected FGWY=Financial Gateway USER=User
7	PRENOTE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Status C=Confirmed N=New P=Pending R=Rejected S=Submitted
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code