IU_TRAN_DFLT_VW (SQL View)	Index Back
Transaction Mapping Map Transaction Codes to System Transactions

IU_TRAN_DFLT_VW

(SQL View)

Transaction Mapping

Map Transaction Codes to System Transactions

SELECT %subrec(iu_tran_dflt_vw,a) FROM PS_IU_TRAN_MAP_TBL a WHERE default_flag='Y'

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