Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.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%

GENERIC_ORDER_LINE

Col #

Column NameData Type Not Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

GENERIC_ORDER_ID

NUMBER

22

N

 Reference to GENERIC_ORDER
3

STATUS_ID

NUMBER

22

N

  
4

ORDER_LINE_NUMBER

VARCHAR2

80

N

  
5

TYPE

VARCHAR2

80

N

  
6

PRODUCT_NUMBER

VARCHAR2

200

N

  
7

DESCRIPTION

VARCHAR2

400

N

  
8

PARAMETERS

VARCHAR2

2000

Y

  
9

TOTAL_EXCL_VAT

NUMBER

22

N

  
10

TOTAL_VAT

NUMBER

22

N

  
11

RESPONSE_PARAMETERS

VARCHAR2

2000

Y

  
12

SUBSCRIPTION_ID

NUMBER

22

Y

 Reference to SUBSCRIPTION
13

WORKFLOW_ID

NUMBER

22

Y

 Reference to WF_WORKFLOW14

CA_EXTERNAL_REF

VARCHAR2

400

Y

  
Column
width33%

All Sales Order Lines