Versions Compared

Old Version 2

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

Saved on

compared with

New Version Current

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%

INVOICE_MAIN

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

ID

NUMBER

22

N

 Primary key
2

START_DATE

DATE

7

Y

  
3

END_DATE

DATE

7

Y

  
4

STATUS_ID

NUMBER

22

Y

  
5

ACCOUNT_ID

NUMBER

22

Y

  
6

BILLING_GROUP_ID

NUMBER

22

Y

  
7

IS_OPEN

CHAR

1

Y

  
8

TOTAL_EXCL_VAT

NUMBER

22

Y

  
9

TOTAL_VAT

NUMBER

22

Y

  
10

PERIOD_TEXT

VARCHAR2

100

Y

  
11

INVOICE_NUMBER

VARCHAR2

250

Y

  
12

XML_FILE_NAME

VARCHAR2

250

Y

  
13

XSL_STYLE_SHEET

VARCHAR2

250

Y

  
14

XML_INVOICE_BATCH_ID

VARCHAR2

250

Y

  
15

PAYED_AMOUNT

NUMBER

22

Y

  
16

DUE_DATE

DATE

7

Y

  
17

LAST_ALLOWED_CHARGE_DATE

DATE

7

Y

  
18

INVOICE_TYPE_ID

NUMBER

22

Y

  
19

INVOICE_SCHEDULE_ID

NUMBER

22

Y

  
20

INVOICE_FILE_LOCATION

VARCHAR2

1000

Y

  
21

INVOICE_FILE_NAME

VARCHAR2

100

Y

  
22

SEQUENCE

NUMBER

22

Y

  
23

CLOSE_DATE

DATE

7

Y

  
24

BATCH_ID

NUMBER

22

Y

  
25

PAYMENT_TYPE_ID

NUMBER

22

Y

  
26

INVOICE_STATE

VARCHAR2

20

Y

  
27

LIFECYCLE_STATE

NUMBER

22

Y

  
28

IS_SUSPENDED

CHAR

1

Y

  
29

DATE_LAST_STEP

DATE

7

Y

  
30

LAST_STEP_ID

NUMBER

22

Y

  
31

SUSPEND_REASON_ID

NUMBER

22

Y

  
32

HAS_PAYMENT_PLAN

CHAR

1

Y

  
33

SUSPEND_DATE

DATE

7

Y

  
34

CREDIT_FORWARDED

NUMBER

22

Y

  
35

TOTAL_TRAFFIC_EXCL_VAT

NUMBER

22

Y

  
36

TOTAL_TRAFFIC_VAT

NUMBER

22

Y

  
37

INVOICE_DETAIL_FILE_LOCATION

VARCHAR2

1000

Y

  
38

INVOICE_DETAIL_FILE_NAME

VARCHAR2

100

Y

  
39

DELIVERY_IDENTIFIER

VARCHAR2

100

Y

  
40

INVOICE_FLOW_ID

NUMBER

22

Y

  
41

BG_INVOICE_TYPE_ID

NUMBER

22

Y

  
42

MAX_AGGREGATED_DETAIL_LINE_ID

NUMBER

22

Y

  
42

MAX_INVOICE_DETAIL_LINE_ID

NUMBER

22

Y

  
43

IS_LOCKED

VARCHAR2

4

Y

  
44

PAYMENT_REFERENCE

VARCHAR2

160

Y

  
45

IS_ANONYMIZED

CHAR

4

Y

  
46

NUMBER_OF_LINES

NUMBER

22

Y

  
47

DUNNING_BALANCE

NUMBER

22

Y

  
48

DUNNING_DATE

DATE

7

Y

  
49

IS_PUBLISHED

CHAR

4

Y

  
Column
width33%

...