IU_INTER_PR1_VW(SQL View) |
Index Back |
---|---|
Inter Unit ActivityMETHOD = 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 |