GENERIC_ORDER

Col #	Column Name	Data Type	Field Length	Not Null?	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