SCE_IDSEQNBRDefault Value: 0
RTBL_ELEMENTVERSION_NUMDefault Value: 0
LEVEL_NUMBUSINESS_UNITRTBL_ELEMENT_TYPEA=Allocation
C=Close Ledgers
J=Journal
M=Multi-currency
U=User Defined
N=No
Y=Yes
RTBL_EXCLUDE_BU(SQL Table) |
Index Back |
|---|---|
RTBL exclude business unitsRTBL exclude business units |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 2 | SEQNBR |
Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 0 |
| 3 | RTBL_ELEMENT |
Character(30) | VARCHAR2(30) NOT NULL | Element name to identify (in peoplesoft) an element along with its label. |
| 4 | VERSION_NUM |
Number(3,0) | SMALLINT NOT NULL |
Version Number
Default Value: 0 |
| 5 | LEVEL_NUM |
Number(3,0) | SMALLINT NOT NULL | Level |
| 6 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | RTBL_ELEMENT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Element name to identify (in peoplesoft) an element along with its label.
A=Allocation C=Close Ledgers J=Journal M=Multi-currency U=User Defined |
| 8 | EXCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Exclude
N=No Y=Yes |