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%

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

  
17

TAX_TRANSACTION_TYPE_ID

NUMBER

22

Y

  
Column
width33%

Definition of all Charge Items