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%

SIMCARD_FILE_FORMAT

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

ID

NUMBER

22

N

 Primary key
2

NAME

VARCHAR2

100

Y

  3

DESCRIPTION

VARCHAR2

300

Y

  
4

SEPARATOR

VARCHAR2

2

Y

  5

HEADER_RECORDS

NUMBER

22

Y

  6

TRAILER_RECORDS

NUMBER

22

Y

  7

SIMCARD_TYPE

VARCHAR2

100

Y

  8

NETWORK_ID

NUMBER

22

Y

  
9

A_NUMBER_GROUP_ID

NUMBER

22

Y

  
10

WRAPPER

VARCHAR2

1

Y

  11

SETUP_ACCOUNTS

VARCHAR2

1

Y

  
12

PRODUCT_ID

NUMBER

22

Y

  13

RATE_PLAN_ID

NUMBER

22

Y

  14

ALERT_GROUP_ID

NUMBER

22

Y

  15

BILLING_ALERT_GROUP_ID

NUMBER

22

Y

  16

ICC_PREFIX

VARCHAR2

8

Y

  
17

GSM_PREFIX

VARCHAR2

4

Y

  
18

LOCATION

VARCHAR2

100

Y

  
19

SIM_TYPE_ID

NUMBER

22

Y

  20

BRAND_ID

NUMBER

22

Y

  
21

PRODUCT_CONFIG_ID

NUMBER

22

Y

  22

BILLING_GROUP_CODE

VARCHAR2

100

Y

  
SIMCARD_GROUP_IDNUMBER   With 10.3.1
Column
width33%