SCE_IDSEQNBRDefault Value: 0
RTBL_ELEMENTVERSION_NUMLEVEL1LEVEL2LEVEL3I=Interim
Y=Year End
A=Allocation
C=Close Ledgers
J=Journal
M=Multi-currency
U=User Defined
N=No
Y=Yes
Y/N Table Edit
RTBL_MGR_ELEM(SQL Table) |
Index Back |
|---|
| # | 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 |
| 5 | LEVEL1 |
Number(5,0) | INTEGER NOT NULL | Level 1 |
| 6 | LEVEL2 |
Number(5,0) | INTEGER NOT NULL | Level 2 |
| 7 | LEVEL3 |
Number(5,0) | INTEGER NOT NULL | Level 3 |
| 8 | CLOSING_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Closing Type
I=Interim Y=Year End |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | 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 |
| 11 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 12 | SELECT_CB | Character(1) | VARCHAR2(1) NOT NULL |
Select Check Box
N=No Y=Yes Y/N Table Edit |
| 13 | ROW_NUMBER_5 | Number(5,0) | INTEGER NOT NULL | Row Number |
| 14 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Level |
| 15 | ASOFDATE | Date(10) | DATE | As of Date |