| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
LEDGER_GROUP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Ledger Group SETID
|
| 3 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 4 |
STRUCTURE |
Number(3,0) |
SMALLINT NOT NULL |
Fusion COA Structure Number
|
| 5 |
STRUCTURE_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Used in Fusion Key Flexfields
|
| 6 |
STRUCTURE_INS_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Fusion COA Structure Inst Code
|
| 7 |
GROUP_SETID_COMBO |
Character(30) |
VARCHAR2(30) NOT NULL |
Ledger Group SETID Combination
|
| 8 |
CONCAT_SEGMENTS |
Long Character(1000) |
VARCHAR2(1000) |
COA Concatenated Segments
|