IU_INTER_PRGNVW

(SQL View)

SELECT A.IU_FROM_GLBU , A.IU_TO_GLBU , A.IU_TRAN_CD , A.ACT_BAL_GRP FROM PS_IU_INTER_PR_GRP A WHERE EXISTS ( SELECT 'X' FROM PS_ACT_BAL_GRP B WHERE A.ACT_BAL_GRP = B.ACT_BAL_GRP AND B.DEFAULT_FLAG = 'N' AND B.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IU_FROM_GLBU Character(5) VARCHAR2(5) NOT NULL From GL Business Unit

2 IU_TO_GLBU Character(5) VARCHAR2(5) NOT NULL To GL Business Unit

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

4 ACT_BAL_GRP Character(10) VARCHAR2(10) NOT NULL Account Balancing Group
Prompt Table: ACT_BAL_GRP_VW2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IU_FROM_GLBU	Character(5)	VARCHAR2(5) NOT NULL	From GL Business Unit
2	IU_TO_GLBU	Character(5)	VARCHAR2(5) NOT NULL	To GL Business Unit
3	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.
4	ACT_BAL_GRP	Character(10)	VARCHAR2(10) NOT NULL	Account Balancing Group Prompt Table: ACT_BAL_GRP_VW2