Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

GENERIC_ORDER

Col #

Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

CODE

VARCHAR2

80

N

  
3

IS_OPEN

NUMBER

22

N

  
4

STATUS_ID

NUMBER

22

N

  
5

ORDER_NUMBER

VARCHAR2

80

N

  
6

ORDER_DATE

DATE

7

N

  
7

TOTAL_EXCL_VAT

NUMBER

22

N

  
8

TOTAL_VAT

NUMBER

22

N

  
9

PARAMETERS

VARCHAR2

2000

Y

  
10

RESPONSE_PARAMETERS

VARCHAR2

2000

Y

  
11

DELIVERY_ADDRESS_ID

NUMBER

22

N

 Reference to ADDRESS
12

ACCOUNT_ID

NUMBER

22

N

 Reference to ACCOUNT
13

BILLING_GROUP_ID

NUMBER

22

Y

 Reference to BILLING_GROUP
14

INVOICE_ID

NUMBER

22

Y

 Reference to INVOICE
15

WORKFLOW_ID

NUMBER

22

Y

 Reference to WF_WORKFLOW
16

PARTNER_CODE

VARCHAR2

200

Y

  
17

RESULT_COMMENT

VARCHAR2

2000

Y

  

All Sales Orders
  • No labels