RTBL_ELEM_VW(SQL View) |
Index Back |
|---|---|
RTBL Element ViewRTBL Element View |
| SELECT SCE_ID , SEQNBR , RTBL_ELEMENT , VERSION_NUM , LEVEL_NUM , EFFDT_TARG , ROW_NUMBER_5 , LEVEL1 , LEVEL2 , LEVEL3 , LEVEL4 , LEVEL5 , LEVEL6 , LEVEL7 , LEVEL8 , LEVEL9 , RTBL_SCENARIO , RTBL_ELEMENT_TYPE , SETID , DESCR , RTBL_CHECKPOINT , CONTINUE_WITH_GRP , STATUS , EXCLUDE , ASOFDATE , BUSINESS_UNIT_IU , JOURNAL_DATE , CLOSING_TYPE , LEDGER_GROUP , LEDGER , DEPLOYED FROM ( SELECT A.SCE_ID , A.SEQNBR , A.RTBL_ELEMENT , A.VERSION_NUM , A.LEVEL_NUM , A.EFFDT_TARG , A.ROW_NUMBER_5 , A.LEVEL1 , A.LEVEL2 , A.LEVEL3 , A.LEVEL4 , A.LEVEL5 , A.LEVEL6 , A.LEVEL7 , A.LEVEL8 , A.LEVEL9 , A.RTBL_SCENARIO , A.RTBL_ELEMENT_TYPE , A.SETID , A.DESCR , A.RTBL_CHECKPOINT , A.CONTINUE_WITH_GRP , A.STATUS , A.EXCLUDE , A.ASOFDATE , A.BUSINESS_UNIT_IU , A.JOURNAL_DATE , A.CLOSING_TYPE , A.LEDGER_GROUP , A.LEDGER , (CASE WHEN (A.RTBL_ELEMENT_TYPE = 'U' OR a.version_num = 0 ) THEN 'N' ELSE GRP.DEPLOYED END) AS DEPLOYED FROM PS_RTBL_ELEMENT A LEFT OUTER JOIN PS_RTBL_ELEMGRP_VW GRP ON A.setid = GRP.SETID AND a.rtbl_element = GRP.rtbl_element AND a.version_num = grp.version_num AND a.closing_type = grp.closing_type AND A.rtbl_element_type = grp.rtbl_element_type WHERE a.rtbl_element_type IN ('M','C','A','U') UNION SELECT X.SCE_ID , X.SEQNBR , X.RTBL_ELEMENT , X.VERSION_NUM , X.LEVEL_NUM , X.EFFDT_TARG ,X.ROW_NUMBER_5 , X.LEVEL1 , X.LEVEL2 , X.LEVEL3 , X.LEVEL4 , X.LEVEL5 , X.LEVEL6 , X.LEVEL7 , X.LEVEL8 , X.LEVEL9 , X.RTBL_SCENARIO , X.RTBL_ELEMENT_TYPE , X.SETID , X.DESCR ,C.RTBL_CHECKPOINT , X.CONTINUE_WITH_GRP , X.STATUS , X.EXCLUDE , X.ASOFDATE , X.BUSINESS_UNIT_IU , X.JOURNAL_DATE , X.CLOSING_TYPE , X.LEDGER_GROUP , X.LEDGER , X.DEPLOYED FROM ( SELECT A.SCE_ID , A.SEQNBR , A.RTBL_ELEMENT , A.VERSION_NUM , A.LEVEL_NUM , A.EFFDT_TARG , A.ROW_NUMBER_5 , A.LEVEL1 , A.LEVEL2 , A.LEVEL3 , A.LEVEL4 , A.LEVEL5 , A.LEVEL6 , A.LEVEL7 , A.LEVEL8 , A.LEVEL9 , A.RTBL_SCENARIO , A.RTBL_ELEMENT_TYPE , A.SETID , HDR.DESCR254 AS DESCR , A.CONTINUE_WITH_GRP , A.STATUS , A.EXCLUDE , A.ASOFDATE , A.BUSINESS_UNIT_IU , A.JOURNAL_DATE , A.CLOSING_TYPE , A.LEDGER_GROUP , A.LEDGER ,'N' AS DEPLOYED FROM PS_RTBL_ELEMENT A , PS_JRNL_HEADER HDR WHERE A.BUSINESS_UNIT_IU = HDR.business_unit AND A.rtbl_element = HDR.JOURNAL_ID AND A.journal_date = HDR.JOURNAL_DATE AND A.RTBL_ELEMENT_TYPE = 'J' ) X LEFT OUTER JOIN PS_RTBL_STEP_CHKPT C ON X.SCE_ID = C.SCE_ID AND X.SETID = C.SETID AND X.RTBL_ELEMENT = C.RTBL_STEP AND X.VERSION_NUM = C.VERSION_NUM AND X.RTBL_ELEMENT = C.RTBL_ELEMENT AND X.VERSION_NUM = C.VERSION_GRP AND X.RTBL_ELEMENT_TYPE = C.RTBL_ELEMENT_TYPE AND X.CLOSING_TYPE = C.CLOSING_TYPE AND X.BUSINESS_UNIT_IU = C.BUSINESS_UNIT_IU AND X.JOURNAL_DATE = C.JOURNAL_DATE UNION SELECT X.SCE_ID , X.SEQNBR , X.RTBL_ELEMENT , X.VERSION_NUM , X.LEVEL_NUM , X.EFFDT_TARG ,X.ROW_NUMBER_5 , X.LEVEL1 , X.LEVEL2 , 0 AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 , X.RTBL_SCENARIO , X.RTBL_ELEMENT_TYPE , X.SETID , X.DESCR ,C.RTBL_CHECKPOINT , X.CONTINUE_WITH_GRP , X.STATUS , X.EXCLUDE , X.ASOFDATE , X.BUSINESS_UNIT_IU , X.JOURNAL_DATE , X.CLOSING_TYPE , X.LEDGER_GROUP , X.LEDGER , X.DEPLOYED FROM ( SELECT A.SCE_ID , 0 AS SEQNBR , B.PROCESS_STEP AS RTBL_ELEMENT , B.PROCESS_GROUP AS PROCESS_GROUP , B.VERSION_NUM AS VERSION_NUM , A.VERSION_NUM AS VERSION_GRP , 2 AS LEVEL_NUM , A.EFFDT_TARG , A.ROW_NUMBER_5 , A.LEVEL1 , B.SEQUENCE_NBR_6 AS LEVEL2 , 0 AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 , A.RTBL_SCENARIO , A.RTBL_ELEMENT_TYPE , A.SETID , E.DESCR , B.CONTINUE_WITH_GRP , A.STATUS , A.EXCLUDE , A.ASOFDATE , ' ' AS BUSINESS_UNIT_IU , A.JOURNAL_DATE , A.CLOSING_TYPE , ' ' AS LEDGER_GROUP , ' ' AS LEDGER , E.DEPLOYED FROM PS_RTBL_ELEMENT A , PS_ALLOC_GRSTP_TBL B , PS_ALLOC_STEP_TBL E , PS_RTBL_SCENARIO SCE WHERE A.RTBL_ELEMENT = B.PROCESS_GROUP AND A.VERSION_NUM = B.VERSION_GRP AND A.SETID = B.SETID AND A.SCE_ID = SCE.SCE_ID AND A.RTBL_ELEMENT_TYPE = 'A' AND B.SETID = E.SETID AND B.PROCESS_STEP = E.PROCESS_STEP AND B.VERSION_NUM = E.VERSION_NUM AND ( ( E.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_ALLOC_STEP_TBL F WHERE F.SETID = E.SETID AND F.PROCESS_STEP = E.PROCESS_STEP AND F.VERSION_NUM = E.VERSION_NUM AND F.EFFDT <= A.EFFDT_TARG ) AND B.VERSION_GRP = 0) OR ( E.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_ALLOC_STEP_TBL F WHERE F.SETID = E.SETID AND F.PROCESS_STEP = E.PROCESS_STEP AND F.VERSION_NUM = E.VERSION_NUM AND F.EFFDT <= B.EFFDT ) AND B.VERSION_GRP >0) ) AND ((B.VERSION_GRP > 0) OR (B.EFFDT = A.EFFDT_TARG)) ) X LEFT OUTER JOIN PS_RTBL_STEP_CHKPT C ON X.SCE_ID = C.SCE_ID AND X.SETID = C.SETID AND X.RTBL_ELEMENT = C.RTBL_STEP AND X.VERSION_NUM = C.VERSION_NUM AND X.PROCESS_GROUP = C.RTBL_ELEMENT AND X.VERSION_GRP = C.VERSION_GRP AND X.RTBL_ELEMENT_TYPE = C.RTBL_ELEMENT_TYPE AND X.CLOSING_TYPE = C.CLOSING_TYPE UNION SELECT X.SCE_ID , X.SEQNBR , X.RTBL_ELEMENT , X.VERSION_NUM , X.LEVEL_NUM , X.EFFDT_TARG ,X.ROW_NUMBER_5 , X.LEVEL1 , X.LEVEL2 , 0 AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 , X.RTBL_SCENARIO , X.RTBL_ELEMENT_TYPE , X.SETID , X.DESCR ,C.RTBL_CHECKPOINT , X.CONTINUE_WITH_GRP , X.STATUS , X.EXCLUDE , X.ASOFDATE , X.BUSINESS_UNIT_IU , X.JOURNAL_DATE , X.CLOSING_TYPE , X.LEDGER_GROUP , X.LEDGER , X.DEPLOYED FROM ( SELECT A.SCE_ID , 0 AS SEQNBR , B.CLOSING_SET AS RTBL_ELEMENT , B.CLOSE_GRP_ID AS PROCESS_GROUP , B.VERSION_NUM AS VERSION_NUM , A.VERSION_NUM AS VERSION_GRP , 2 AS LEVEL_NUM , A.EFFDT_TARG , A.ROW_NUMBER_5 , A.LEVEL1 , B.CLOSE_STEP AS LEVEL2 , 0 AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 , A.RTBL_SCENARIO , A.RTBL_ELEMENT_TYPE , A.SETID , E.DESCR , 'N' AS CONTINUE_WITH_GRP , A.STATUS , A.EXCLUDE , A.ASOFDATE , ' ' AS BUSINESS_UNIT_IU , A.JOURNAL_DATE , A.CLOSING_TYPE , ' ' AS LEDGER_GROUP , ' ' AS LEDGER , E.DEPLOYED FROM PS_RTBL_ELEMENT A , PS_CLOSE_GRP_STEP B , PS_CLOSE_DEFN_TBL E , PS_RTBL_SCENARIO SCE WHERE A.RTBL_ELEMENT = B.CLOSE_GRP_ID AND A.VERSION_NUM = B.VERSION_GRP AND A.SETID = B.SETID AND A.CLOSING_TYPE = B.CLOSING_TYPE AND A.SCE_ID = SCE.SCE_ID AND A.RTBL_ELEMENT_TYPE = 'C' AND B.SETID = E.SETID AND B.CLOSING_SET = E.CLOSING_SET AND B.VERSION_NUM = E.VERSION_NUM AND B.CLOSING_TYPE = E.CLOSING_TYPE AND E.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_CLOSE_DEFN_TBL F WHERE F.SETID = E.SETID AND F.CLOSING_SET = E.CLOSING_SET AND F.VERSION_NUM = E.VERSION_NUM AND F.CLOSING_TYPE = E.CLOSING_TYPE) ) X LEFT OUTER JOIN PS_RTBL_STEP_CHKPT C ON X.SCE_ID = C.SCE_ID AND X.SETID = C.SETID AND X.RTBL_ELEMENT = C.RTBL_STEP AND X.VERSION_NUM = C.VERSION_NUM AND X.PROCESS_GROUP = C.RTBL_ELEMENT AND X.VERSION_GRP = C.VERSION_GRP AND X.RTBL_ELEMENT_TYPE = C.RTBL_ELEMENT_TYPE AND X.CLOSING_TYPE = C.CLOSING_TYPE UNION SELECT X.SCE_ID , X.SEQNBR , X.RTBL_ELEMENT , X.VERSION_NUM , X.LEVEL_NUM , X.EFFDT_TARG , X.ROW_NUMBER_5 , X.LEVEL1 , X.LEVEL2 , X.LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 , X.RTBL_SCENARIO , X.RTBL_ELEMENT_TYPE , X.SETID , X.DESCR , C.RTBL_CHECKPOINT , X.CONTINUE_WITH_GRP , X.STATUS , X.EXCLUDE , X.ASOFDATE , X.BUSINESS_UNIT_IU , X.JOURNAL_DATE , X.CLOSING_TYPE , X.LEDGER_GROUP , X.LEDGER , X.DEPLOYED FROM ( SELECT sce.SCE_ID , 0 AS SEQNBR , S.TRANS_RULE AS RTBL_ELEMENT , B.PROCESS_GROUP AS PROCESS_GROUP , S.VERSION_RULE AS VERSION_NUM , A.VERSION_NUM AS VERSION_GRP , 3 AS LEVEL_NUM , A.EFFDT_TARG , A.ROW_NUMBER_5 , A.LEVEL1 , B.SEQUENCE_NBR_6 AS LEVEL2 , ROW_NUMBER() OVER ( partition BY A.LEVEL1 , B.SEQUENCE_NBR_6 ORDER BY A.LEVEL1 , B.SEQUENCE_NBR_6) AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 , A.RTBL_SCENARIO , A.RTBL_ELEMENT_TYPE , A.SETID , E.DESCR , 'N' AS CONTINUE_WITH_GRP , A.STATUS , A.EXCLUDE , A.ASOFDATE , ' ' AS BUSINESS_UNIT_IU , A.JOURNAL_DATE , A.CLOSING_TYPE , ' ' AS LEDGER_GROUP , ' ' AS LEDGER , E.DEPLOYED FROM PS_RTBL_ELEMENT A , PS_CURR_GRSTP_TBL B , PS_CURR_STEP_TBL BB , PS_CURR_STPRL_TBL S , PS_CURR_RULE_TBL E , PS_RTBL_SCENARIO SCE WHERE A.RTBL_ELEMENT = B.PROCESS_GROUP AND A.VERSION_NUM = B.VERSION_GRP AND A.SETID = B.SETID AND A.RTBL_ELEMENT_TYPE = 'M' AND a.sce_id = sce.sce_id AND B.SETID = BB.SETID AND B.CURR_STEP = BB.CURR_STEP AND B.VERSION_NUM = BB.VERSION_NUM AND BB.STEP_TYPE = 'T' AND( (BB.VERSION_NUM = 0 AND BB.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_CURR_STEP_TBL B_ED WHERE BB.SETID = B_ED.SETID AND BB.CURR_STEP = B_ED.CURR_STEP AND BB.VERSION_NUM = B_ED.VERSION_NUM AND B_ED.EFFDT <= SCE.ASOFDATE2 ) ) OR BB.VERSION_NUM >0) AND BB.SETID = S.SETID AND BB.CURR_STEP = S.CURR_STEP AND BB.VERSION_NUM = S.VERSION_NUM AND B.SETID = S.SETID AND B.CURR_STEP = S.CURR_STEP AND B.VERSION_NUM = S.VERSION_NUM AND( (S.VERSION_NUM = 0 AND S.EFFDT = ( SELECT MAX(S_ED.EFFDT) FROM PS_CURR_STPRL_TBL S_ED WHERE S.SETID = S_ED.SETID AND S.CURR_STEP = S_ED.CURR_STEP AND S.VERSION_NUM = S_ED.VERSION_NUM AND S_ED.EFFDT <= BB.EFFDT ) ) OR S.VERSION_NUM > 0 ) AND S.SETID = E.SETID AND S.TRANS_RULE = E.TRANS_RULE AND S.VERSION_RULE = E.VERSION_RULE AND ((E.VERSION_RULE = 0 AND E.EFFDT = ( SELECT MAX(E_ED.EFFDT) FROM PS_CURR_RULE_TBL E_ED WHERE E.SETID = E_ED.SETID AND E.TRANS_RULE = E_ED.TRANS_RULE AND E.VERSION_RULE = E_ED.VERSION_RULE AND E_ED.EFFDT <= S.EFFDT )) OR E.VERSION_RULE > 0 ) ) X LEFT OUTER JOIN PS_RTBL_STEP_CHKPT C ON X.SCE_ID = C.SCE_ID AND X.SETID = C.SETID AND X.RTBL_ELEMENT = C.RTBL_STEP AND X.VERSION_NUM = C.VERSION_NUM AND X.PROCESS_GROUP = C.RTBL_ELEMENT AND X.VERSION_GRP = C.VERSION_GRP AND X.RTBL_ELEMENT_TYPE = C.RTBL_ELEMENT_TYPE AND X.CLOSING_TYPE = C.CLOSING_TYPE UNION SELECT X.SCE_ID , X.SEQNBR , X.RTBL_ELEMENT , X.VERSION_NUM , X.LEVEL_NUM , X.EFFDT_TARG , X.ROW_NUMBER_5 , X.LEVEL1 , X.LEVEL2 , 0 AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 , X.RTBL_SCENARIO , X.RTBL_ELEMENT_TYPE , X.SETID , X.DESCR , C.RTBL_CHECKPOINT , X.CONTINUE_WITH_GRP , X.STATUS , X.EXCLUDE , X.ASOFDATE , X.BUSINESS_UNIT_IU , X.JOURNAL_DATE , X.CLOSING_TYPE , X.LEDGER_GROUP , X.LEDGER , X.DEPLOYED FROM ( SELECT SCE.SCE_ID , 0 AS SEQNBR , BB.CURR_STEP AS RTBL_ELEMENT , B.PROCESS_GROUP AS PROCESS_GROUP , BB.VERSION_NUM , A.VERSION_NUM AS VERSION_GRP , 2 AS LEVEL_NUM , A.EFFDT_TARG , A.ROW_NUMBER_5 , A.LEVEL1 , B.SEQUENCE_NBR_6 AS LEVEL2 , 0 AS LEVEL3 , 0 AS LEVEL4 , 0 AS LEVEL5 , 0 AS LEVEL6 , 0 AS LEVEL7 , 0 AS LEVEL8 , 0 AS LEVEL9 , A.RTBL_SCENARIO , A.RTBL_ELEMENT_TYPE , A.SETID , BB.DESCR , B.CONTINUE_WITH_GRP , A.STATUS , A.EXCLUDE , A.ASOFDATE , ' ' AS BUSINESS_UNIT_IU , A.JOURNAL_DATE , A.CLOSING_TYPE , ' ' AS LEDGER_GROUP , ' ' AS LEDGER , BB.DEPLOYED FROM PS_RTBL_ELEMENT A , PS_CURR_GRSTP_TBL B , PS_CURR_STEP_TBL BB , PS_RTBL_SCENARIO SCE WHERE A.RTBL_ELEMENT = B.PROCESS_GROUP AND A.VERSION_NUM = B.VERSION_GRP AND A.SETID = B.SETID AND A.RTBL_ELEMENT_TYPE = 'M' AND A.SCE_ID = SCE.SCE_ID AND B.SETID = BB.SETID AND B.CURR_STEP = BB.CURR_STEP AND B.VERSION_NUM = BB.VERSION_NUM AND ( (BB.VERSION_NUM = 0 AND BB.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_CURR_STEP_TBL B_ED WHERE BB.SETID = B_ED.SETID AND BB.CURR_STEP = B_ED.CURR_STEP AND BB.VERSION_NUM = B_ED.VERSION_NUM AND B_ED.EFFDT <= SCE.ASOFDATE2 ) ) OR BB.VERSION_NUM >0) ) X LEFT OUTER JOIN PS_RTBL_STEP_CHKPT C ON X.SCE_ID = C.SCE_ID AND X.SETID = C.SETID AND X.RTBL_ELEMENT = C.RTBL_STEP AND X.VERSION_NUM = C.VERSION_NUM AND X.PROCESS_GROUP = C.RTBL_ELEMENT AND X.VERSION_GRP = C.VERSION_GRP AND X.RTBL_ELEMENT_TYPE = C.RTBL_ELEMENT_TYPE AND X.CLOSING_TYPE = C.CLOSING_TYPE ) |
| # | 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 | EFFDT_TARG | Date(10) | DATE | New Effective Date |
| 7 | ROW_NUMBER_5 | Number(5,0) | INTEGER NOT NULL | Row Number |
| 8 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 9 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
| 10 | LEVEL3 | Number(5,0) | INTEGER NOT NULL | Level 3 |
| 11 | LEVEL4 | Number(5,0) | INTEGER NOT NULL | Level 4 |
| 12 | LEVEL5 | Number(5,0) | INTEGER NOT NULL | Level 5 |
| 13 | LEVEL6 | Number(5,0) | INTEGER NOT NULL | Level 6 |
| 14 | LEVEL7 | Number(5,0) | INTEGER NOT NULL | Level 7 |
| 15 | LEVEL8 | Number(5,0) | INTEGER NOT NULL | Level 8 |
| 16 | LEVEL9 | Number(5,0) | INTEGER NOT NULL | Level 9 |
| 17 | RTBL_SCENARIO | Character(18) | VARCHAR2(18) NOT NULL | Scenario Name |
| 18 | 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 |
| 19 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 20 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 21 | RTBL_CHECKPOINT | Character(1) | VARCHAR2(1) NOT NULL |
Checkpoint
Y/N Table Edit |
| 22 | CONTINUE_WITH_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Continue Processing the Group
Y/N Table Edit |
| 23 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 24 | EXCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Exclude
N=No Y=Yes |
| 25 | ASOFDATE | Date(10) | DATE | As of Date |
| 26 | BUSINESS_UNIT_IU | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Business Unit for which InterUnit activity is being generated. |
| 27 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 28 | CLOSING_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Closing Type
I=Interim Y=Year End |
| 29 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: SP_BULGRP_NONVW |
| 30 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: LED_GRP_LED_TBL |
| 31 | DEPLOYED | Character(1) | VARCHAR2(1) NOT NULL |
Identify whether an element has been deployed or not.
N=No Y=Yes |