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%

VOUCHER_LOG

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

CHANGE_DATE

DATE

7

Y

  
3

OPERATOR

VARCHAR2

50

Y

  
4

VOUCHER_ID

NUMBER

22

Y

  
5

CODE

VARCHAR2

80

Y

  
6

KEYWORD

VARCHAR2

100

Y

  
7

STATUS_ID

NUMBER

22

Y

  
8

AMOUNT

NUMBER

22

Y

  
9

CREATE_DATE

DATE

7

Y

  
10

ASSIGN_DATE

DATE

7

Y

  
11

CREDITED_DATE

DATE

7

Y

  
12

SUBSCRIPTION_ID

NUMBER

22

Y

  
13

START_DATE

DATE

7

Y

  
14

END_DATE

DATE

7

Y

  
15

ASSIGNED_BY

VARCHAR2

80

Y

  
16

RETAILER

VARCHAR2

80

Y

  
17

PARTNER

VARCHAR2

80

Y

  
18

BATCH

VARCHAR2

80

Y

  
19

PRICE_CODE

VARCHAR2

80

Y

  
20

VOUCHER_FILE_ID

NUMBER

22

Y

  
21

ACTION

VARCHAR2

20

Y

  
22

EXPORTED

NUMBER

22

Y

  
23

CREATED_BY

VARCHAR2

50

Y

  
Column
width33%

...