GL_IU_TR_MAP_VW (SQL View)	Index Back
Transaction Mapping Map Transaction Codes to System Transaction GLJ

GL_IU_TR_MAP_VW

(SQL View)

Transaction Mapping

Map Transaction Codes to System Transaction GLJ

SELECT A.IU_SYS_TRAN_CD , A.IU_TRAN_CD , B.DESCR , A.DEFAULT_FLAG FROM PS_IU_TRAN_MAP_TBL A , PS_IU_TRAN_CD_TBL B WHERE A.IU_TRAN_CD = B.IU_TRAN_CD AND A.IU_SYS_TRAN_CD = 'GLJ'

Related Language Record: GL_IU_TR_MAP_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IU_SYS_TRAN_CD Character(8) VARCHAR2(8) NOT NULL System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.

2 IU_TRAN_CD Character(8) VARCHAR2(8) NOT NULL Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.

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

4 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IU_SYS_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
2	IU_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Default