Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Add reference notes

...

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

  
Reference to VAT_METHOD
17

TAX_TRANSACTION_TYPE_ID

NUMBER

22

Y

 
 Reference to TAX_TRANSACTION_TYPE



Column
width33%

Definition of all Charge Items


...