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%

INVOICE_FLOW_STEP

Col #

Column NameData TypeData LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

CODE

VARCHAR2

250

Y

  
3

INVOICE_FLOW_STEP_DEF_ID

NUMBER

22

N

 Reference to INVOICE_FLOW_STEP_DEF4

STATUS_ID

NUMBER

22

N

  
5

CREATED_BY

VARCHAR2

250

N

  
6

CREATE_DATE

DATE

7

N

  7

START_AFTER

DATE

7

N

  
PREVIOUS_START_AFTERDATE  8 With Vs. 10

COMPLETE_DATE

DATE

7

Y

  
9

OUTCOME

VARCHAR2

250

Y

  
10

NAME

VARCHAR2

250

Y

  11

DESCRIPTION

VARCHAR2

250

Y

  12

INVOICE_FLOW_ID

NUMBER

22

N

 Reference to INVOICE_FLOW13

INVOICE_FLOW_DEF_ID

NUMBER

22

N

 Reference to INVOICE_FLOW_DEF14

PROCESSED_BY

VARCHAR2

250

Y

  15

SCHEDULED

DATE

7

Y

  
Column
width33%

Contains all Dunning Flow Steps