GL_IU_TR_MAP_LN (SQL View)	Index Back
Transaction Mapping - RLR Map Transaction Codes to System Transaction GLJ

GL_IU_TR_MAP_LN

(SQL View)

Transaction Mapping - RLR

Map Transaction Codes to System Transaction GLJ

SELECT A.IU_SYS_TRAN_CD , A.IU_TRAN_CD , B.LANGUAGE_CD , B.DESCR FROM PS_IU_TRAN_MAP_TBL A , PS_IU_TRAN_CD_LNG B WHERE A.IU_TRAN_CD = B.IU_TRAN_CD AND A.IU_SYS_TRAN_CD = 'GLJ'

Related Language Record for GL_IU_TR_MAP_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description