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%

BATCH_FILE_LINE

Col #

Column Name

Data Type

Field Length

Not Null?

Data Def.

Comments

1

ID

NUMBER

22

N

 Primary key
2

STATUS_ID

NUMBER

22

Y

  
3

BATCH_FILE_ID

NUMBER

22

Y

  
4

START_DATE

DATE

7

Y

  
5

HOOKPOINT_KEY

VARCHAR2

4000

Y

  
6

FILENAME

VARCHAR2

200

Y

  
7

COMMENTS

VARCHAR2

4000

Y

  
8

PHONE_NUMBER

VARCHAR2

80

Y

  
9

LINE_IN_FILE

NUMBER

22

Y

  
10STATIC_KEYVARCHAR2200  

Added workflow-reference.
With vers. 10.2

11DYNAMIC_KEYVARCHAR2200  

Added workflow-reference.
With vers. 10.2

12WORKFLOW_IDNUMBER   Added workflow-reference.
With vers. 10.2
Column
width33%

Contains individual file lines created by a file processor engine.