| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
Prompt Table:
IU_SYS_TRAN_TBL
|
| 2 |
UPG_IU_TRAN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Action
C=Create
U=Use
Default Value: C
|
| 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 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
UPG_IU_INTER_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
InterUnit Setup Source
AMU=Assets Business Unit
APP=Proc Acctg Cntrl - Payment
APV=Proc Acctg Cntrl - Voucher
BII=Billing InterUnit Controls
GLU=General Ledger Bus Unit
INS=Inventory Shipment on Behalf
INT=Inventory InterUnit Transfer
INX=Inventory Expense Issue
NON=None
TRI=Treasury Internal Banks
|
| 6 |
UPG_IU_INTRA_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
IntraUnit Setup Source
AMU=Assets Business Unit
ARA=Receivables Options IntraUnit
BII=Billing InterUnit Controls
BNP=Bank Account - Non-Pooled
GMA=Grants F&A IntraUnit Accounts
INA=Inventory IntraUnit Accounts
INT=Inventory InterUnit Transfers
NON=None
|