IU_INTER_PR1_VW

(SQL View)
Index Back

Inter Unit Activity

METHOD = PAIRS

SELECT FP.IU_FROM_GLBU , TP.IU_TO_GLBU , FP.IU_TRAN_CD , FP.ACT_BAL_GRP , FP.IU_ENTRY_TYPE , FP.ACCOUNT , FP.AFFILIATE , TP.IU_ENTRY_TYPE , TP.ACCOUNT , TP.AFFILIATE FROM PS_IU_INTER_PR_CF FP , PS_IU_INTER_PR_CF TP WHERE FP.IU_FROM_GLBU = TP.IU_FROM_GLBU AND FP.IU_TO_GLBU = TP.IU_TO_GLBU AND FP.IU_TRAN_CD = TP.IU_TRAN_CD AND FP.ACT_BAL_GRP = TP.ACT_BAL_GRP AND FP.IU_ENTRY_TYPE = 'IURC' AND TP.IU_ENTRY_TYPE = 'IUPY'

# 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