Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

NUMBER_PLAN

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

DESCRIPTION

VARCHAR2

120

Y

  
3

STATUS_ID

NUMBER

22

Y

  
4

ROOT_ELEMENT_ID

NUMBER

22

Y

  Refers to PLAN_ELEMENTS.ID
5

BNUMBER_METHOD

VARCHAR2

100

Y

  
6

PLAN_TYPE_ID

NUMBER

22

Y

  
7

RATING_METHOD

VARCHAR2

100

Y

  
8

FINANCE_CODE

NUMBER

22

Y

  
9

PERIODIC_RATING_CLASS_ENABLED

CHAR

1

Y

  
10

PERIODIC_BNUMBER_ENABLED

CHAR

1

Y

  
11

RATING_METHOD_PROFILE_TYPE_ID

NUMBER22y With 9.9 - Support for rating method profile type
Column
width33%

...