AR_GL_ACCT_VW (SQL View)	Index Back
GL Accounts for Open Item Key

AR_GL_ACCT_VW

(SQL View)

GL Accounts for Open Item Key

SELECT a.setid , a.account , a.open_item , a.open_item_descr , a.open_item_edit_rec , a.open_item_edit_fld , a.open_item_prompt , a.open_item_tol_amt FROM PS_GL_ACCOUNT_TBL a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 OPEN_ITEM Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) to activate processing for tracking debits and credits that post to a general ledger account. Accounts that are not OpenItem track only net posted amounts.

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

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

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

7 OPEN_ITEM_PROMPT Character(15) VARCHAR2(15) NOT NULL Open Item Prompt Table

8 OPEN_ITEM_TOL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the limit amount that determines when OpenItem entries can be closed. You can manually close (delete) OpenItem rows if the balance of the OpenItem account is less than or equal to the specified tolerance.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
3	OPEN_ITEM	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) to activate processing for tracking debits and credits that post to a general ledger account. Accounts that are not OpenItem track only net posted amounts.
4	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.
5	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.
6	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.
7	OPEN_ITEM_PROMPT	Character(15)	VARCHAR2(15) NOT NULL	Open Item Prompt Table
8	OPEN_ITEM_TOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the limit amount that determines when OpenItem entries can be closed. You can manually close (delete) OpenItem rows if the balance of the OpenItem account is less than or equal to the specified tolerance.