GL_TRANSACTIONMATRIX

Owned by Daniel Hostrup Eriksen
Last updated: 27.06.2014 by Former user (Deleted)

Groups

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

  

Definition of all GL Codes