DR_ENTRTYP_D_VW (SQL View)	Index Back
Entry Types by Sub Event

DR_ENTRTYP_D_VW

(SQL View)

Entry Types by Sub Event

SELECT DISTINCT R.SETID , D.DRAFT_TYPE , D.DRAFT_BUSN_EVENT , A.ENTRY_TYPE , A.EFFDT , A.EFF_STATUS , E.DESCR , D.ENTRY_USE_ID , D.DRAFT_SUB_EVENT FROM PS_DR_ENTRYSUB_TBL D , PS_AUTO_ENTRY_TBL A , PS_ENTRY_TYPE_TBL E , PS_SET_CNTRL_REC R WHERE A.SETID=R.SETID AND R.RECNAME IN ('AUTO_ENTRY_TBL','DR_ENTRYSUB_TBL') AND A.ENTRY_USE_ID = D.ENTRY_USE_ID AND E.SETID = A.SETID AND E.ENTRY_TYPE = A.ENTRY_TYPE AND D.DRAFT_POST_ACTION = 'A' AND %EffdtCheck(AUTO_ENTRY_TBL B, A, %CurrentDateIn)

Related Language Record: DR_ENTYP_S_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DRAFT_TYPE Character(10) VARCHAR2(10) NOT NULL A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).

3 DRAFT_BUSN_EVENT Character(2) VARCHAR2(2) NOT NULL Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft.

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

5 EFFDT Date(10) DATE Effective Date

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

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

8 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.

9 DRAFT_SUB_EVENT Character(2) VARCHAR2(2) NOT NULL Defines specific types of activity that can be performed at the Draft Business Event. For example in the process of approving a Draft you can specify that you are paying an item putting an amount on acccount etc.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DRAFT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
3	DRAFT_BUSN_EVENT	Character(2)	VARCHAR2(2) NOT NULL	Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft.
4	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.
5	EFFDT	Date(10)	DATE	Effective Date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
9	DRAFT_SUB_EVENT	Character(2)	VARCHAR2(2) NOT NULL	Defines specific types of activity that can be performed at the Draft Business Event. For example in the process of approving a Draft you can specify that you are paying an item putting an amount on acccount etc.