RTBL_ELEMBU_VW

(SQL View)
 Index Back

SELECT A.SCE_ID , B.BUSINESS_UNIT_IU , B.JOURNAL_DATE , B.SEQNBR , B.RTBL_ELEMENT , B.VERSION_NUM , A.PROCESS , B.EXCLUDE , B.RTBL_CHECKPOINT , B.RTBL_ELEMENT_TYPE FROM PS_RTBL_BU A , PS_RTBL_ELEMENT B WHERE A.SCE_ID = B.SCE_ID AND A.PROCESS = 'Y' AND A.EXCLUDE = 'N' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT_IU

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
2 BUSINESS_UNIT_IU Character(5) VARCHAR2(5) NOT NULL Specifies the Business Unit for which InterUnit activity is being generated.
3 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
4 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
5 RTBL_ELEMENT Character(30) VARCHAR2(30) NOT NULL Element name to identify (in peoplesoft) an element along with its label.
6 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
7 PROCESS Character(1) VARCHAR2(1) NOT NULL Process
N=No
Y=Yes
8 EXCLUDE Character(1) VARCHAR2(1) NOT NULL Exclude
N=No
Y=Yes

Y/N Table Edit

9 RTBL_CHECKPOINT Character(1) VARCHAR2(1) NOT NULL Checkpoint
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