VED_VDS_OPIT_VW (SQL View)	Index Back
Vchr Edit VDS Open Item View

VED_VDS_OPIT_VW

(SQL View)

Vchr Edit VDS Open Item View

SELECT A.BUSINESS_UNIT , B.ACCOUNT , B.OPEN_ITEM_DESCR , B.OPEN_ITEM_EDIT_REC , B.OPEN_ITEM_EDIT_FLD FROM PS_BUS_UNIT_TBL_GL A , PS_GL_ACCOUNT_TBL B WHERE B.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'FS_05' AND I.RECNAME = 'GL_ACCOUNT_TBL') AND B.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_GL_ACCOUNT_TBL J WHERE J.SETID = B.SETID AND J.ACCOUNT = B.ACCOUNT AND J.EFFDT <= %CurrentDateIn AND J.EFF_STATUS = 'A') AND B.OPEN_ITEM = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

3 OPEN_ITEM_DESCR Character(10) VARCHAR2(10) NOT NULL Describes the OpenItem key that must be specified in the reference field on journal entry panels when an open item account number is used. It appears on prompt lists, reports, and online inquiries related to an open item account in the general ledger.

4 OPEN_ITEM_EDIT_REC Character(15) VARCHAR2(15) NOT NULL Specifies the name of the prompt table you want to use to validate the OpenItem search key, and applies only to OpenItem accounts in the general ledger.

5 OPEN_ITEM_EDIT_FLD Character(18) VARCHAR2(18) NOT NULL Specifies the name of the field in the OpenItem Edit Record (OPEN_ITEM_EDIT_REC) to use for validating the OpenItem search key, and applies only to OpenItem accounts in the general ledger.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
2	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
3	OPEN_ITEM_DESCR	Character(10)	VARCHAR2(10) NOT NULL	Describes the OpenItem key that must be specified in the reference field on journal entry panels when an open item account number is used. It appears on prompt lists, reports, and online inquiries related to an open item account in the general ledger.
4	OPEN_ITEM_EDIT_REC	Character(15)	VARCHAR2(15) NOT NULL	Specifies the name of the prompt table you want to use to validate the OpenItem search key, and applies only to OpenItem accounts in the general ledger.
5	OPEN_ITEM_EDIT_FLD	Character(18)	VARCHAR2(18) NOT NULL	Specifies the name of the field in the OpenItem Edit Record (OPEN_ITEM_EDIT_REC) to use for validating the OpenItem search key, and applies only to OpenItem accounts in the general ledger.