DR_ENTYP_S_LVW

(SQL View)

SELECT DISTINCT R.SETID , D.DRAFT_TYPE , D.DRAFT_BUSN_EVENT , A.ENTRY_TYPE , A.EFFDT , E.LANGUAGE_CD , E.DESCR FROM PS_DR_ENTRYSUB_TBL D , PS_AUTO_ENTRY_TBL A , PS_ENTRY_TY_TBL_LG 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'

Related Language Record for DR_ENTRTYP_D_VW DR_ENTRTYP_S_VW

# 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
Default Value: %date

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	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 Default Value: %date
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description