IU_INTER_CF3_VW (SQL View)	Index Back
Inter Unit Activity METHOD = DIRECT, LEGAL ENTITY = Y (INTRA-ENTITY VIEW)

IU_INTER_CF3_VW

(SQL View)

Inter Unit Activity

METHOD = DIRECT, LEGAL ENTITY = Y (INTRA-ENTITY VIEW)

SELECT FB.BUSINESS_UNIT , TB.BUSINESS_UNIT , FT.IU_TRAN_CD , FT.ACT_BAL_GRP , FT.IU_ENTRY_TYPE , FT.ACCOUNT , FT.AFFILIATE , TT.IU_ENTRY_TYPE , TT.ACCOUNT , TT.AFFILIATE FROM PS_BUS_UNIT_TBL_GL FB , PS_SET_CNTRL_REC FS , PS_IU_INTER_CF FT , PS_BUS_UNIT_TBL_GL TB , PS_SET_CNTRL_REC TS , PS_IU_INTER_CF TT WHERE FS.SETCNTRLVALUE = FB.BUSINESS_UNIT AND FS.RECNAME = 'IU_INTER_CF' AND FT.SETID = FS.SETID AND FT.IU_INTER_TMPLT_CD = FB.IU_INTER_TMPLT_CD AND TS.SETCNTRLVALUE = TB.BUSINESS_UNIT AND TS.RECNAME = 'IU_INTER_CF' AND TT.SETID = TS.SETID AND TT.IU_INTER_TMPLT_CD = TB.IU_INTER_TMPLT_CD AND FT.IU_TRAN_CD = TT.IU_TRAN_CD AND FT.ACT_BAL_GRP = TT.ACT_BAL_GRP AND FT.IU_ENTRY_TYPE = 'AERC' AND TT.IU_ENTRY_TYPE = 'AEPY' AND FB.BUSINESS_UNIT <> TB.BUSINESS_UNIT AND FB.IU_LEGAL_ENT_BU = TB.IU_LEGAL_ENT_BU

# 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

5 IU_ENTRY_TYPE Character(4) VARCHAR2(4) NOT NULL Entry Type
AEAP=IntraEntity Accrued Payable
AECG=IntraEntity Cost of Goods
AECS=IntraEntity Customer Shipments
AEEX=IntraEntity Expense
AEPY=IntraEntity Payable
AERC=IntraEntity Receivable
AERV=IntraEntity Revenue
AETR=IntraEntity In Transit
AUEX=IntraUnit Expense
AUPY=IntraUnit Payable
AURC=IntraUnit Receivable
AURV=IntraUnit Revenue
AUTR=IntraUnit In Transit
IEAP=InterEntity Accrued Payable
IECG=InterEntity Cost of Goods
IECS=InterEntity Customer Shipments
IEEX=InterEntity Expense
IEPY=InterEntity Payable
IERC=InterEntity Receivable
IERV=InterEntity Revenue
IETR=InterEntity In Transit
IUAP=InterUnit Accrued Payable
IUCG=InterUnit Cost of Goods
IUCS=InterUnit Customer Shipments
IUEX=InterUnit Expense
IUPY=InterUnit Payable
IURC=InterUnit Receivable
IURV=InterUnit Revenue
IUTR=InterUnit In Transit

6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

7 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

8 IU_ENTRY_TYPE_2 Character(4) VARCHAR2(4) NOT NULL Entry Type
AEAP=IntraEntity Accrued Payable
AECC=IntraEntity Cost of Goods
AECS=IntraEntity Customer Shipments
AEEX=IntraEntity Expense
AEPY=IntraEntity Payable
AERC=IntraEntity Receivable
AERV=IntraEntity Revenue
AETR=IntraEntity In Transit
AUEX=IntraUnit Expense
AUPY=IntraUnit Payable
AURC=IntraUnit Receivable
AURV=IntraUnit Revenue
AUTR=IntraUnit In Transit
IEAP=InterEntity Accrued Payable
IECG=InterEntity Cost of Goods
IECS=InterEntity Customer Shipments
IEEX=InterEntity Expense
IEPY=InterEntity Payable
IERC=InterEntity Receivable
IERV=InterEntity Revenue
IETR=InterEntity In Transit
IUAP=InterUnit Accrued Payable
IUCG=InterUnit Cost Of Goods
IUCS=InterUnit Customer Shipments
IUEX=InterUnit Expense
IUPY=InterUnit Payable
IURC=InterUnit Receivable
IURV=InterUnit Revenue
IUTR=InterUnit In Transit

9 ACCOUNT_2 Character(10) VARCHAR2(10) NOT NULL Account

10 AFFILIATE_2 Character(5) VARCHAR2(5) NOT NULL Affiliate

#	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
5	IU_ENTRY_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Entry Type AEAP=IntraEntity Accrued Payable AECG=IntraEntity Cost of Goods AECS=IntraEntity Customer Shipments AEEX=IntraEntity Expense AEPY=IntraEntity Payable AERC=IntraEntity Receivable AERV=IntraEntity Revenue AETR=IntraEntity In Transit AUEX=IntraUnit Expense AUPY=IntraUnit Payable AURC=IntraUnit Receivable AURV=IntraUnit Revenue AUTR=IntraUnit In Transit IEAP=InterEntity Accrued Payable IECG=InterEntity Cost of Goods IECS=InterEntity Customer Shipments IEEX=InterEntity Expense IEPY=InterEntity Payable IERC=InterEntity Receivable IERV=InterEntity Revenue IETR=InterEntity In Transit IUAP=InterUnit Accrued Payable IUCG=InterUnit Cost of Goods IUCS=InterUnit Customer Shipments IUEX=InterUnit Expense IUPY=InterUnit Payable IURC=InterUnit Receivable IURV=InterUnit Revenue IUTR=InterUnit In Transit
6	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
7	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
8	IU_ENTRY_TYPE_2	Character(4)	VARCHAR2(4) NOT NULL	Entry Type AEAP=IntraEntity Accrued Payable AECC=IntraEntity Cost of Goods AECS=IntraEntity Customer Shipments AEEX=IntraEntity Expense AEPY=IntraEntity Payable AERC=IntraEntity Receivable AERV=IntraEntity Revenue AETR=IntraEntity In Transit AUEX=IntraUnit Expense AUPY=IntraUnit Payable AURC=IntraUnit Receivable AURV=IntraUnit Revenue AUTR=IntraUnit In Transit IEAP=InterEntity Accrued Payable IECG=InterEntity Cost of Goods IECS=InterEntity Customer Shipments IEEX=InterEntity Expense IEPY=InterEntity Payable IERC=InterEntity Receivable IERV=InterEntity Revenue IETR=InterEntity In Transit IUAP=InterUnit Accrued Payable IUCG=InterUnit Cost Of Goods IUCS=InterUnit Customer Shipments IUEX=InterUnit Expense IUPY=InterUnit Payable IURC=InterUnit Receivable IURV=InterUnit Revenue IUTR=InterUnit In Transit
9	ACCOUNT_2	Character(10)	VARCHAR2(10) NOT NULL	Account
10	AFFILIATE_2	Character(5)	VARCHAR2(5) NOT NULL	Affiliate