Versions Compared

Old Version 3

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version 4

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

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%

SESSION_DETAIL_LINE

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

ID

NUMBER

22

N

 Primary key
2

SESSION_ID

VARCHAR2

100

N

  
3

REQUEST_TYPE

VARCHAR2

4

N

  
4

BILLING_RECORD_ID

NUMBER

22

N

  
5

ACCOUNT_ID

NUMBER

22

N

  
6

SERVICE_ID

NUMBER

22

N

  
7

CHARGE_ITEM_ID

NUMBER

22

N

  
8

SUM_QUANTITY

NUMBER

22

N

  
9

SUM_TIME

NUMBER

22

N

  
10

TOTAL_EXCL_VAT

NUMBER

22

N

  
11

TOTAL_VAT

NUMBER

22

N

  
12

DESCRIPTION

VARCHAR2

400

Y

  
13

CHARGE_DATE

DATE

7

Y

  
14

LEVEL1

VARCHAR2

400

Y

  
15

LEVEL2

VARCHAR2

400

Y

  
16

LEVEL3

VARCHAR2

400

Y

  
17

LEVEL4

VARCHAR2

400

Y

  
18

LEVEL5

VARCHAR2

400

Y

  
19

SUBSCRIPTION_ID

NUMBER

22

Y

  
20

BILLING_GROUP_ID

NUMBER

22

Y

  
21

CALLER

VARCHAR2

80

Y

  
22

VAT_METHOD_NAME

VARCHAR2

320

Y

  
23

CURRENCY_CODE

VARCHAR2

12

Y

  
24

CHARGED_UNITS

NUMBER

22

Y

  
25

CHARGED_UNIT_TYPE

VARCHAR2

60

Y

  
26

INVOICE_LINE_ID

NUMBER

22

Y

  
27

FINANCE_CODE_BILL_GROUP

NUMBER

22

Y

  
28

FINANCE_CODE_PRODUCT

NUMBER

22

Y

  
29

FINANCE_CODE_PRICEPLAN

NUMBER

22

Y

  
30

FINANCE_CODE_ACCOUNT

NUMBER

22

Y

  
31

FINANCE_CODE_NUMBERPLAN

NUMBER

22

Y

  
32

FINANCE_CODE_PLAN_ELEMENT

NUMBER

22

Y

  
33

FINANCE_CODE_CHARGE_ITEM

NUMBER

22

Y

  
34

FINANCE_CODE_DAY_CHARGE

NUMBER

22

Y

  
35

FINANCE_CODE_TIME_CHARGE

NUMBER

22

Y

  
36

FINANCE_CODE_BILLING_RECORD

NUMBER

22

Y

  
Column
width33%