CHARGE_ITEM

Owned by Daniel Hostrup Eriksen
Last updated: 05.07.2024 by Jason Reast-JonesVersion comment

Groups

CHARGE_ITEM

Col #

Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N


Primary key
2

CHARGE_ITEM_GROUP_ID

NUMBER

22

Y


Reference to CHARGE_ITEM_GROUP
3

DESCRIPTION

VARCHAR2

120

Y



4

VALUE_TYPE

VARCHAR2

10

Y



5

VALUE

 FLOAT

22

Y



6

VAT

 FLOAT

22

Y



7

GL_CODE

 VARCHAR2

128

Y



8

SUM_PATTERN

VARCHAR2

50

Y



9

GENERATE_ZERO_DETAIL_LINE

CHAR

1

Y



10

GL_ID

 NUMBER

22

Y


Reference to GL_TRANSACTIONMATRIX
11

METHOD

VARCHAR2

400

Y



12

SERVICE_CODE

VARCHAR2

400

Y



13

SERVICE_KEY

VARCHAR2

400

Y



14

ABSOLUTE_MATCH

NUMBER

22

Y



15

SERVICE_KEY_BNUMBER_METHOD_ID

NUMBER

22

Y



16

VAT_METHOD_NAME

VARCHAR2

80

Y


Reference to VAT_METHOD
17

TAX_TRANSACTION_TYPE_ID

NUMBER

22

Y


Reference to TAX_TRANSACTION_TYPE

Definition of all Charge Items