OPENITM_AP_SEC

(SQL View)

SELECT DISTINCT business_unit , OPEN_ITEM_KEY , jrnl_ln_ref , txn_currency_cd , account FROM PS_DISTRIB_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_AP_NONVW

2 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key

3 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.

4 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

5 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: GL_ACCOUNT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AP_NONVW
2	OPEN_ITEM_KEY	Character(30)	VARCHAR2(30) NOT NULL	Open Item Key
3	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
4	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
5	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_TBL