| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 IU_SELECT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
IU Pairs Maintenance Export Selection ID
|
| 2 |
IU_FROM_CONDTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
InterUnit Query Criteria condition type for IU From GL Business Unit
EQU=equal to
EQU-=not equal to
LIK=like
LIK-=not like
LIS=in list
LIS-=not in list
Default Value: EQU
|
| 3 |
IU_FROM_GLBU |
Character(5) |
VARCHAR2(5) NOT NULL |
From GL Business Unit
Prompt Table:
SP_BU_IUF_NONVW
|
| 4 |
IU_FROM_LIST |
Character(254) |
VARCHAR2(254) NOT NULL |
In List Members
|
| 5 |
IU_TO_CONDTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
InterUnit Query Criteria condition type for IU To GL Business Unit
EQU=equal to
EQU-=not equal to
LIK=like
LIK-=not like
LIS=in list
LIS-=not in list
Default Value: EQU
|
| 6 |
IU_TO_GLBU |
Character(5) |
VARCHAR2(5) NOT NULL |
To GL Business Unit
Prompt Table:
SP_BU_IUT_NONVW
|
| 7 |
IU_TO_LIST |
Character(254) |
VARCHAR2(254) NOT NULL |
In List Members
|
| 8 |
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.
Prompt Table:
IU_TRAN_CD_TBL
|
| 9 |
IU_TRAN_CONDTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
InterUnit Query Criteria condition type for Transaction Code
EQU=equal to
EQU-=not equal to
LIK=like
LIK-=not like
LIS=in list
LIS-=not in list
Default Value: EQU
|
| 10 |
IU_TRAN_LIST |
Character(254) |
VARCHAR2(254) NOT NULL |
In List Members
|
| 11 |
ACT_BAL_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Balancing Group
Prompt Table:
ACT_BAL_GRP
|
| 12 |
IU_BGRP_CONDTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
InterUnit Query Criteria condition type for
Account Balancing Group
EQU=equal to
EQU-=not equal to
LIK=like
LIK-=not like
LIS=in list
LIS-=not in list
Default Value: EQU
|
| 13 |
IU_BGRP_LIST |
Character(254) |
VARCHAR2(254) NOT NULL |
In List Members
|
| 14 |
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
Prompt Table:
IU_PR_ENTTYP_VW
|
| 15 |
IU_ENTRY_CONDTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
InterUnit Query Criteria condition type for
Entry Types
EQU=equal to
EQU-=not equal to
LIK=like
LIK-=not like
LIS=in list
LIS-=not in list
Default Value: EQU
|
| 16 |
IU_ENTRY_LIST |
Character(254) |
VARCHAR2(254) NOT NULL |
InterUnit Pairs Mass Maintenance In List selections for Entry Types
|
| 17 |
CF_SELECT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include ChartField Values
Y/N Table Edit
Default Value: Y
|
| 18 |
IU_EXPORT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
IU Pairs Maintenance Export to Excel Flag
|
| 19 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 20 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|