Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

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%

GL_TRANSACTIONMATRIX

Col #

Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

  
2

DESCRIPTION

VARCHAR2

32

Y

  
3

DEBET_ACCOUNT

VARCHAR2

16

Y

  
4

CREDIT_ACCOUNT

VARCHAR2

16

Y

  
5

DEBET_CASE_ID

VARCHAR2

16

Y

  
6

CREDIT_CASE_ID

VARCHAR2

16

Y

  
7

DEBET_TEXT

VARCHAR2

32

Y

  
8

CREDIT_TEXT

VARCHAR2

32

Y

  
9

VAT_DEBET_ACCOUNT

VARCHAR2

16

Y

  
10

VAT_CREDIT_ACCOUNT

VARCHAR2

16

Y

  
11

VAT_DEBET_TEXT

VARCHAR2

32

Y

  
12

VAT_CREDIT_TEXT

VARCHAR2

32

Y

  
13

GL_GROUP_ID

NUMBER

22

Y

  
14

GL_ID

NUMBER

22

Y

 Primary key
15

ADD_TO_INVOICE

VARCHAR2

4

Y

  
Column
width33%

Definition of all GL Codes