INVOICE

1

ID

NUMBER

N

Primary key

2

START_DATE

DATE

Y

3

END_DATE

DATE

Y

4

STATUS_ID

NUMBER

Y

5

ACCOUNT_ID

NUMBER

Y

Reference to ACCOUNT (redundant, from BILLING_GROUP_ID)

6

BILLING_GROUP_ID

NUMBER

Y

Reference to BILLING_GROUP

7

IS_OPEN

CHAR

Y

8

TOTAL_EXCL_VAT

NUMBER

Y

9

TOTAL_VAT

NUMBER

Y

10

PERIOD_TEXT

VARCHAR2

Y

11

INVOICE_NUMBER

VARCHAR2

Y

12

XML_FILE_NAME

VARCHAR2

Y

13

XSL_STYLE_SHEET

VARCHAR2

Y

14

XML_INVOICE_BATCH_ID

VARCHAR2

Y

15

PAYED_AMOUNT

NUMBER

Y

16

DUE_DATE

DATE

Y

17

LAST_ALLOWED_CHARGE_DATE

DATE

Y

18

INVOICE_TYPE_ID

NUMBER

Y

19

INVOICE_SCHEDULE_ID

NUMBER

Y

Reference to INVOICE_SCHEDULE

20

INVOICE_FILE_LOCATION

VARCHAR2

Y

21

INVOICE_FILE_NAME

VARCHAR2

Y

22

SEQUENCE

NUMBER

Y

23

CLOSE_DATE

DATE

Y

24

BATCH_ID

NUMBER

Y

Reference to INVOICE_BATCH

25

PAYMENT_TYPE_ID

NUMBER

Y

26

INVOICE_STATE

VARCHAR2

Y

27

LIFECYCLE_STATE

NUMBER

Y

28

IS_SUSPENDED

CHAR

Y

29

DATE_LAST_STEP

DATE

Y

30

LAST_STEP_ID

NUMBER

Y

31

SUSPEND_REASON_ID

NUMBER

Y

32

HAS_PAYMENT_PLAN

CHAR

Y

33

SUSPEND_DATE

DATE

Y

34

CREDIT_FORWARDED

NUMBER

Y