IU_METHODD=Direct
I=Indirect
P=Pairs
BUSINESS_UNITC=Create
U=Use
Default Value: C
Prompt Table: SP_SETID_NONVW
C=Create
U=Use
Default Value: C
C=Create
U=Use
Default Value: C
UPG_IU_BU_OPT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IU_METHOD |
Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Method
D=Direct I=Indirect P=Pairs |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | UPG_IU_SETID_OPT | Character(1) | VARCHAR2(1) NOT NULL |
SetID Action
C=Create U=Use Default Value: C |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | UPG_IU_INTER_OPT | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Action
C=Create U=Use Default Value: C |
| 7 | IU_INTER_TMPLT_CD | Character(5) | VARCHAR2(5) NOT NULL | Key to the interunit template record. Assigned to a GLBU on the GL business unit table. |
| 8 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 9 | UPG_IU_INTRA_OPT | Character(1) | VARCHAR2(1) NOT NULL |
IntraUnit Action
C=Create U=Use Default Value: C |
| 10 | IU_INTRA_TMPLT_CD | Character(5) | VARCHAR2(5) NOT NULL | Key field for IntraUnit Template |
| 11 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |