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

GL_IU_TR_DFT_VW

(SQL View)

Transaction Mapping

Map Transaction Codes to System Transaction 'GLJ'

SELECT %subrec(GL_IU_TR_DFT_VW, A) FROM PS_IU_TRAN_MAP_TBL A WHERE A.DEFAULT_FLAG='Y' AND A.IU_SYS_TRAN_CD = 'GLJ'

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

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