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%

INVOICE

Col #

Column Name

Data Type

Field Length

Not 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

 Reference to ACCOUNT (redundant, from BILLING_GROUP_ID)

6

BILLING_GROUP_ID

NUMBER

22

Y

 Reference to BILLING_GROUP

7

IS_OPEN

VARCHAR2

CHAR4

Y

  

8

TOTAL_EXCL_VAT

NUMBER

22

Y

  

9

TOTAL_VAT

NUMBER

22

Y

  

10

PERIOD_TEXT

VARCHAR2

400

Y

  

11

INVOICE_NUMBER

VARCHAR2

1000

Y

  

12

XML_FILE_NAME

VARCHAR2

1000

Y

  

13

XSL_STYLE_SHEET

VARCHAR2

1000

Y

  

14

XML_INVOICE_BATCH_ID

VARCHAR2

1000

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

 Reference to INVOICE_SCHEDULE

20

INVOICE_FILE_LOCATION

VARCHAR2

4000

Y

  

21

INVOICE_FILE_NAME

VARCHAR2

400

Y

  

22

SEQUENCE

NUMBER

22

Y

  

23

CLOSE_DATE

DATE

7

Y

  

24

BATCH_ID

NUMBER

22

Y

 Reference to INVOICE_BATCH

25

PAYMENT_TYPE_ID

NUMBER

22

Y

  

26

INVOICE_STATE

VARCHAR2

80

Y

  

27

LIFECYCLE_STATE

NUMBER

22

Y

  

28

IS_SUSPENDED

VARCHAR2

CHAR4

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

VARCHAR2

CHAR4

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

4000

Y

  

38

INVOICE_DETAIL_FILE_NAME

VARCHAR2

400

Y

  

39

DELIVERY_IDENTIFIER

VARCHAR2

400

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

  

43

MAX_INVOICE_DETAIL_LINE_ID

NUMBER

22

Y

  

44

IS_LOCKED

VARCHAR2

4

Y

  

45

PAYMENT_REFERENCE

VARCHAR2

160

Y

  

46

IS_ANONYMIZED

CHAR

4

Y

  

47

NUMBER_OF_LINES

NUMBER

22

Y

  

48

DUNNING_BALANCE

NUMBER

22

Y

  

49

DUNNING_DATE

DATE

7

Y

  

50

IS_PUBLISHED

CHAR

4

Y

  
Column
width33%

Contains all Invoices.

Note

This is a VIEW-representation of tables INVOICE_MAIN and INVOICE-BALANCE.