Groups
GENERIC_ORDER
Col # | Column Name | Data Type | Field Length | Not 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 | ||
18 | CA_EXTERNAL_REF | VARCHAR2 | 400 | Y |
All Sales Orders