Versions Compared

Old Version 1

changes.mady.by.user Søren Duusgaard

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard

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%

INVOICE_AGGREGATE_LINES

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

ID

NUMBER

22

N

  
2

INVOICE_ID

NUMBER

22

Y

  
3

SUBSCRIPTION_ID

NUMBER

22

Y

  
4

CALLER

VARCHAR2

20

Y

  
5

SORT_SEQUENCE

NUMBER

22

Y

  
6

INVOICE_LEVEL

NUMBER

22

Y

  
7

DESCRIPTION

VARCHAR2

100

Y

  
8

NBR_OF_CALLS

NUMBER

22

Y

  
9

TOTAL_TIME

NUMBER

22

Y

  
10

EX_VAT

NUMBER

22

Y

  
11

VAT

NUMBER

22

Y

  
12

TOTAL_NO_VAT

NUMBER

22

Y

  
13

USAGE_TYPE

VARCHAR2

10

Y

  
14

CHARGE_ITEM_ID

NUMBER

22

Y

  
15

CATEGORY

VARCHAR2

20

Y

  
16

VAT_METHOD_NAME

VARCHAR2

80

Y

  
17

BONUS

NUMBER

22

Y

  
18

BONUS_VAT

NUMBER

22

Y

  
19

CHARGED_UNITS

NUMBER

22

Y

  
20

CHARGED_UNIT_TYPE

VARCHAR2

60

Y

  
Column
width33%