SESSION_DETAIL_LINE

Owned by Søren Duusgaard (Deactivated)
Last updated: 20.09.2017

Groups

SESSION_DETAIL_LINE

Column NameData TypeField LengthNot Null?Data Def.Comments

ID

NUMBER

22

N

 Primary key

SESSION_ID

VARCHAR2

100

N

  

REQUEST_TYPE

VARCHAR2

4

N

  

BILLING_RECORD_ID

NUMBER

22

N

  

ACCOUNT_ID

NUMBER

22

N

  

SERVICE_ID

NUMBER

22

N

  

CHARGE_ITEM_ID

NUMBER

22

N

  

SUM_QUANTITY

NUMBER

22

N

  

SUM_TIME

NUMBER

22

N

  

TOTAL_EXCL_VAT

NUMBER

22

N

  

TOTAL_VAT

NUMBER

22

N

  

DESCRIPTION

VARCHAR2

400

Y

  

CHARGE_DATE

DATE

7

Y

  

LEVEL1

VARCHAR2

400

Y

  

LEVEL2

VARCHAR2

400

Y

  

LEVEL3

VARCHAR2

400

Y

  

LEVEL4

VARCHAR2

400

Y

  

LEVEL5

VARCHAR2

400

Y

  

SUBSCRIPTION_ID

NUMBER

22

Y

  

BILLING_GROUP_ID

NUMBER

22

Y

  

CALLER

VARCHAR2

80

Y

  

VAT_METHOD_NAME

VARCHAR2

320

Y

  

CURRENCY_CODE

VARCHAR2

12

Y

  

CHARGED_UNITS

NUMBER

22

Y

  

CHARGED_UNIT_TYPE

VARCHAR2

60

Y

  

INVOICE_LINE_ID

NUMBER

22

Y

  

FINANCE_CODE_BILL_GROUP

NUMBER

22

Y

  

FINANCE_CODE_PRODUCT

NUMBER

22

Y

  

FINANCE_CODE_PRICEPLAN

NUMBER

22

Y

  

FINANCE_CODE_ACCOUNT

NUMBER

22

Y

  

FINANCE_CODE_NUMBERPLAN

NUMBER

22

Y

  

FINANCE_CODE_PLAN_ELEMENT

NUMBER

22

Y

  

FINANCE_CODE_CHARGE_ITEM

NUMBER

22

Y

  

FINANCE_CODE_DAY_CHARGE

NUMBER

22

Y

  

FINANCE_CODE_TIME_CHARGE

NUMBER

22

Y

  

FINANCE_CODE_BILLING_RECORD

NUMBER

22

Y

 Â