Versions Compared

Version Old Version 2 New Version 3
Changes made by

Former user

Søren Duusgaard (Deactivated)

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%

INVOICE_PAYMENTS

Col #

Column Name

Data Type

Field Length

Not Null?

Data Def.

Comments

1

ID

NUMBER

22

N

 

Primary key

2

INVOICE_ID

NUMBER

22

Y

 

Reference to INVOICE

3

PAYMENT_DATE

DATE

7

Y

 

 

4

PAYMENT_SOURCE

VARCHAR2

100

Y

 

 

5

AMOUNT_PAYED

NUMBER

22

Y

 

 

6

REFERENCE

VARCHAR2

100

Y

 

 

7

BALANCING_OBJECT_ID

NUMBER

22

Y

 

Reference to ACCOUNT_PAYMENT (and others)

8

PAYMENT_TYPE_ID

NUMBER

22

Y

 

 

9BALANCING_OBJECT_CLASS_NAMEVARCHAR24000Y  
Column
width33%

Contains all payments of Invoices