RTBL_STEP_CHK_H(SQL Table) |
Index Back |
|---|---|
RTBL step checkpoint ArchiveRTBL step checkpoint Archive |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 3 | RTBL_SCENARIO |
Character(18) | VARCHAR2(18) NOT NULL | Scenario Name |
| 4 | RTBL_ELEMENT |
Character(30) | VARCHAR2(30) NOT NULL | Element name to identify (in peoplesoft) an element along with its label. |
| 5 | VERSION_GRP |
Number(3,0) | SMALLINT NOT NULL | Group Version |
| 6 | 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 |
| 7 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 8 | CLOSING_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Closing Type
I=Interim Y=Year End |
| 9 | SEQUENCE_NBR_6 |
Number(6,0) | INTEGER NOT NULL | Sequence |
| 10 | RTBL_STEP |
Character(30) | VARCHAR2(30) NOT NULL | Element name to identify (in peoplesoft) an element along with its label. |
| 11 | BUSINESS_UNIT_IU |
Character(5) | VARCHAR2(5) NOT NULL | Specifies the Business Unit for which InterUnit activity is being generated. |
| 12 | JOURNAL_DATE |
Date(10) | DATE | Specifies the date the journal was created. |
| 13 | VERSION_NUM | Number(3,0) | SMALLINT NOT NULL | Version Number |
| 14 | RTBL_CHECKPOINT | Character(1) | VARCHAR2(1) NOT NULL | Checkpoint |