ENT_TYPRSN_VW (SQL View)	Index Back
Entry Type, Entry Reason View

ENT_TYPRSN_VW

(SQL View)

Entry Type, Entry Reason View

SELECT DISTINCT B.ENTRY_TYPE , A.DESCR FROM PS_ENTRY_TYPE_TBL A , PS_ENTRY_REASN_TBL B WHERE A.SETID = B.SETID AND A.ENTRY_TYPE = B.ENTRY_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table: ENTRY_TYPE_TBL

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction. Prompt Table: ENTRY_TYPE_TBL
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description