INVOICE_DETAIL_LINE

Owned by Daniel Hostrup Eriksen
Last updated: 27.06.2014 by Former user (Deleted)

Groups

INVOICE_DETAIL_LINE

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

ID

NUMBER

22

N

 Primary key
2

BILLING_RECORD_ID

NUMBER

22

N

 Reference to object creating this record (billing record, account payment, etc.)
3

INVOICE_LINE_ID

NUMBER

22

N

  
4

ACCOUNT_ID

NUMBER

22

N

 Reference to ACCOUNT
5

SERVICE_ID

NUMBER

22

N

 Reference to SERVICE
6

CHARGE_ITEM_ID

NUMBER

22

N

 Reference to CHARGE_ITEM
7

SUM_QUANTITY

NUMBER

22

N

  
8

SUM_TIME

NUMBER

22

N

  
9

TOTAL_EXCL_VAT

NUMBER

22

N

  
10

TOTAL_VAT

NUMBER

22

N

  
11

DESCRIPTION

VARCHAR2

100

Y

  
12

CHARGE_DATE

DATE

7

Y

  
13

LEVEL1

VARCHAR2

100

Y

  
14

LEVEL2

VARCHAR2

100

Y

  
15

LEVEL3

VARCHAR2

100

Y

  
16

LEVEL4

VARCHAR2

100

Y

  
17

LEVEL5

VARCHAR2

100

Y

  
18

INVOICE_ID

NUMBER

22

Y

 Reference to INVOICE
19

SUBSCRIPTION_ID

NUMBER

22

Y

 Reference to SUBSCRIPTION
20

BILLING_GROUP_ID

NUMBER

22

Y

 Reference to BILLING_GROUP
21

CALLER

VARCHAR2

20

Y

  
22

FINANCE_CODE_ACCOUNT

NUMBER

22

Y

  
23

FINANCE_CODE_BILL_GROUP

NUMBER

22

Y

  
24

FINANCE_CODE_PRODUCT

NUMBER

22

Y

  
25

FINANCE_CODE_PRICEPLAN

NUMBER

22

Y

  
26

FINANCE_CODE_NUMBERPLAN

NUMBER

22

Y

  
27

FINANCE_CODE_PLAN_ELEMENT

NUMBER

22

Y

  
28

FINANCE_CODE_CHARGE_ITEM

NUMBER

22

Y

  
29

FINANCE_CODE_DAY_CHARGE

NUMBER

22

Y

  
30

FINANCE_CODE_TIME_CHARGE

NUMBER

22

Y

  
31

FINANCE_CODE_BILLING_RECORD

NUMBER

22

Y

  
32

BRAND_ID

NUMBER

22

Y

 Not used in application
33

VAT_METHOD_NAME

VARCHAR2

80

Y

  
34

CURRENCY_CODE

VARCHAR2

12

Y

  
35

CHARGED_UNITS

NUMBER

22

Y

  
36

CHARGED_UNIT_TYPE

VARCHAR2

60

Y

  

Contains all Credit and Debit Items charged in the system