/* Generated by oahelper on Thu Dec 30 13:12:59 2004 */ ENVIRONMENT "ORDERS_ENV" DATABASE "orders" TYPE ODBC PHYSICAL "ORDERS_SSV" USERCLASS "DEFAULT" USER "" PASSWORD "" INDEXPREFIX "idx/orders" TABLE "ACTIVITY" TYPE RELATIONAL PHYSICAL "ORDERS.dbo.ACTIVITY" FOREIGN KEY "CUSTOMER_NO" REFERENCES "CUSTOMERS"("CUSTOMER_NO") COLUMN "CUSTOMER_NO" PHYSICAL "CUSTOMER_NO" DATATYPE INTEGER COLUMN "DATE_TICKLER" PHYSICAL "DATE_TICKLER" DATATYPE ODBC DATETIME COLUMN "TICKLER" PHYSICAL "TICKLER" DATATYPE CHAR(2) COLUMN "INITIALS" PHYSICAL "INITIALS" DATATYPE CHAR(4) COLUMN "ACTION_INFO" PHYSICAL "ACTION_INFO" DATATYPE C STRING(60) COLUMN "REDEF_ROWID" PHYSICAL "REDEF_ROWID" DATATYPE INTEGER USAGE AUTO ROWID TABLE "CUST_NOTES" TYPE RELATIONAL PHYSICAL "ORDERS.dbo.CUST_NOTES" FOREIGN KEY "CUSTOMER_NO" REFERENCES "CUSTOMERS"("CUSTOMER_NO") COLUMN "CUSTOMER_NO" PHYSICAL "CUSTOMER_NO" DATATYPE INTEGER COLUMN "DATE_ENTERED" PHYSICAL "DATE_ENTERED" DATATYPE ODBC DATETIME COLUMN "ENTERED_BY" PHYSICAL "ENTERED_BY" DATATYPE CHAR(4) COLUMN "DESC_LINES" PHYSICAL "DESC_LINES" DATATYPE C STRING(350) COLUMN "REDEF_ROWID" PHYSICAL "REDEF_ROWID" DATATYPE INTEGER USAGE AUTO ROWID TABLE "CUSTOMERS" TYPE RELATIONAL PHYSICAL "ORDERS.dbo.CUSTOMERS" PRIMARY KEY "CUSTOMER_NO" COLUMN "CUSTOMER_NO" PHYSICAL "CUSTOMER_NO" DATATYPE INTEGER USAGE AUTO ROWID COLUMN "COMPANY" PHYSICAL "COMPANY" DATATYPE C STRING(40) COLUMN "CONTACT" PHYSICAL "CONTACT" DATATYPE C STRING(24) COLUMN "TITLE" PHYSICAL "TITLE" DATATYPE C STRING(30) COLUMN "SALUTATION" PHYSICAL "SALUTATION" DATATYPE C STRING(24) COLUMN "ADDRESS1" PHYSICAL "ADDRESS1" DATATYPE C STRING(30) COLUMN "ADDRESS2" PHYSICAL "ADDRESS2" DATATYPE C STRING(30) COLUMN "CITY" PHYSICAL "CITY" DATATYPE C STRING(20) COLUMN "STATE" PHYSICAL "STATE" DATATYPE CHAR(2) COLUMN "POSTAL_CODE" PHYSICAL "POSTAL_CODE" DATATYPE C STRING(10) COLUMN "COUNTRY" PHYSICAL "COUNTRY" DATATYPE C STRING(20) COLUMN "PHONE_NO" PHYSICAL "PHONE_NO" DATATYPE C STRING(18) COLUMN "FAX_NO" PHYSICAL "FAX_NO" DATATYPE C STRING(20) COLUMN "AKA_COMPANY" PHYSICAL "AKA_COMPANY" DATATYPE C STRING(20) COLUMN "COMMENTS" PHYSICAL "COMMENTS" DATATYPE C STRING(60) COLUMN "LICENSEE" PHYSICAL "LICENSEE" DATATYPE INTEGER TABLE "INVENTORY" TYPE RELATIONAL PHYSICAL "ORDERS.dbo.INVENTORY" COLUMN "PRODUCT_NO" PHYSICAL "PRODUCT_NO" DATATYPE CHAR(12) COLUMN "INV_DATE" PHYSICAL "INV_DATE" DATATYPE ODBC DATETIME COLUMN "INV_QTY" PHYSICAL "INV_QTY" DATATYPE SMALLINT COLUMN "INV_COST" PHYSICAL "INV_COST" DATATYPE INTEGER COLUMN "INV_LOC" PHYSICAL "INV_LOC" DATATYPE C STRING(16) COLUMN "REDEF_ROWID" PHYSICAL "REDEF_ROWID" DATATYPE INTEGER USAGE AUTO ROWID TABLE "ORDERS" TYPE RELATIONAL PHYSICAL "ORDERS.dbo.ORDERS" FOREIGN KEY "CUSTOMER_NO" REFERENCES "CUSTOMERS"("CUSTOMER_NO") FOREIGN KEY "PRODUCT_NO" REFERENCES "PRODUCTS"("PRODUCT_NO") COLUMN "CUSTOMER_NO" PHYSICAL "CUSTOMER_NO" DATATYPE INTEGER COLUMN "PRODUCT_NO" PHYSICAL "PRODUCT_NO" DATATYPE CHAR(12) COLUMN "ORDER_DATE" PHYSICAL "ORDER_DATE" DATATYPE ODBC DATETIME COLUMN "STATUS" PHYSICAL "STATUS" DATATYPE CHAR(4) COLUMN "QUANTITY" PHYSICAL "QUANTITY" DATATYPE INTEGER COLUMN "AMOUNT" PHYSICAL "AMOUNT" DATATYPE INTEGER COLUMN "REDEF_ROWID" PHYSICAL "REDEF_ROWID" DATATYPE INTEGER USAGE AUTO ROWID TABLE "PRODUCTS" TYPE RELATIONAL PHYSICAL "ORDERS.dbo.PRODUCTS" PRIMARY KEY "PRODUCT_NO" COLUMN "PRODUCT_NO" PHYSICAL "PRODUCT_NO" DATATYPE CHAR(12) USAGE ROWID COLUMN "PRODUCT_CLASS" PHYSICAL "PRODUCT_CLASS" DATATYPE C STRING(20) COLUMN "PRODUCT_NAME" PHYSICAL "PRODUCT_NAME" DATATYPE C STRING(40) COLUMN "SALES_PRICE" PHYSICAL "SALES_PRICE" DATATYPE INTEGER COLUMN "PRODUCT_COST" PHYSICAL "PRODUCT_COST" DATATYPE INTEGER TABLE ODXAIM_ODXREQUESTS TYPE RELATIONAL COLUMN "REQUEST_SEQUENCE" DATATYPE INTEGER USAGE ROWID COLUMN "REQUEST" DATATYPE CHAR(32) COLUMN "REQUEST_TIMESTAMP" DATATYPE CHAR(32) COLUMN "TABLENAME" DATATYPE CHAR(32) COLUMN "NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "NEW_NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "TRANSACTION_DATA" DATATYPE C STRING(4000) TABLE ODXAIM_ODXLOG TYPE RELATIONAL COLUMN "REQUEST_SEQUENCE" DATATYPE INTEGER USAGE ROWID COLUMN "EVENT_TIMESTAMP" DATATYPE CHAR(32) COLUMN "REQUEST_TIMESTAMP" DATATYPE CHAR(32) COLUMN "TABLENAME" DATATYPE CHAR(32) COLUMN "NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "REQUEST" DATATYPE CHAR(32) COLUMN "ERROR_NO" DATATYPE INTEGER COLUMN "ERROR_MSG" DATATYPE C STRING(1024) TABLE ODXAIM_ACTIVITY TYPE RELATIONAL COLUMN "REQ_AUTO_ID" DATATYPE INTEGER USAGE ROWID COLUMN "REQUEST_SEQUENCE" DATATYPE INTEGER COLUMN "REQUEST" DATATYPE CHAR(32) COLUMN "REQUEST_TIMESTAMP" DATATYPE CHAR(32) COLUMN "TABLENAME" DATATYPE CHAR(32) COLUMN "NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "NEW_NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "CUSTOMER_NO" DATATYPE INTEGER COLUMN "DATE_TICKLER" DATATYPE ODBC DATETIME COLUMN "TICKLER" DATATYPE CHARACTER(2) COLUMN "INITIALS" DATATYPE CHARACTER(4) COLUMN "ACTION_INFO" DATATYPE C STRING(60) TABLE ODXAIM_CUST_NOTES TYPE RELATIONAL COLUMN "REQ_AUTO_ID" DATATYPE INTEGER USAGE ROWID COLUMN "REQUEST_SEQUENCE" DATATYPE INTEGER COLUMN "REQUEST" DATATYPE CHAR(32) COLUMN "REQUEST_TIMESTAMP" DATATYPE CHAR(32) COLUMN "TABLENAME" DATATYPE CHAR(32) COLUMN "NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "NEW_NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "CUSTOMER_NO" DATATYPE INTEGER COLUMN "DATE_ENTERED" DATATYPE ODBC DATETIME COLUMN "DESC_LINES" DATATYPE C STRING(350) TABLE ODXAIM_CUSTOMERS TYPE RELATIONAL COLUMN "REQ_AUTO_ID" DATATYPE INTEGER USAGE ROWID COLUMN "REQUEST_SEQUENCE" DATATYPE INTEGER COLUMN "REQUEST" DATATYPE CHAR(32) COLUMN "REQUEST_TIMESTAMP" DATATYPE CHAR(32) COLUMN "TABLENAME" DATATYPE CHAR(32) COLUMN "NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "NEW_NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "CUSTOMER_NO" DATATYPE INTEGER COLUMN "COMPANY" DATATYPE C STRING(40) COLUMN "CONTACT" DATATYPE C STRING(24) COLUMN "CITY" DATATYPE C STRING(20) COLUMN "STATE" DATATYPE CHARACTER(2) COLUMN "POSTAL_CODE" DATATYPE C STRING(10) COLUMN "PHONE_NO" DATATYPE C STRING(18) COLUMN "AKA_COMPANY" DATATYPE C STRING(20) COLUMN "COMMENTS" DATATYPE C STRING(60) TABLE ODXAIM_INVENTORY TYPE RELATIONAL COLUMN "REQ_AUTO_ID" DATATYPE INTEGER USAGE ROWID COLUMN "REQUEST_SEQUENCE" DATATYPE INTEGER COLUMN "REQUEST" DATATYPE CHAR(32) COLUMN "REQUEST_TIMESTAMP" DATATYPE CHAR(32) COLUMN "TABLENAME" DATATYPE CHAR(32) COLUMN "NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "NEW_NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "PRODUCT_NO" DATATYPE CHARACTER(12) COLUMN "INV_DATE" DATATYPE ODBC DATETIME COLUMN "INV_QTY" DATATYPE SMALLINT COLUMN "INV_COST" DATATYPE INTEGER COLUMN "INV_LOC" DATATYPE C STRING(16) TABLE ODXAIM_ORDERS TYPE RELATIONAL COLUMN "REQ_AUTO_ID" DATATYPE INTEGER USAGE ROWID COLUMN "REQUEST_SEQUENCE" DATATYPE INTEGER COLUMN "REQUEST" DATATYPE CHAR(32) COLUMN "REQUEST_TIMESTAMP" DATATYPE CHAR(32) COLUMN "TABLENAME" DATATYPE CHAR(32) COLUMN "NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "NEW_NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "CUSTOMER_NO" DATATYPE INTEGER COLUMN "PRODUCT_NO" DATATYPE CHARACTER(12) COLUMN "ORDER_DATE" DATATYPE ODBC DATETIME COLUMN "STATUS" DATATYPE CHARACTER(4) COLUMN "QUANTITY" DATATYPE INTEGER COLUMN "AMOUNT" DATATYPE INTEGER TABLE ODXAIM_PRODUCTS TYPE RELATIONAL COLUMN "REQ_AUTO_ID" DATATYPE INTEGER USAGE ROWID COLUMN "REQUEST_SEQUENCE" DATATYPE INTEGER COLUMN "REQUEST" DATATYPE CHAR(32) COLUMN "REQUEST_TIMESTAMP" DATATYPE CHAR(32) COLUMN "TABLENAME" DATATYPE CHAR(32) COLUMN "NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "NEW_NATIVE_ROWID" DATATYPE CHAR(32) COLUMN "PRODUCT_NO" DATATYPE CHARACTER(12) COLUMN "PRODUCT_CLASS" DATATYPE C STRING(20) COLUMN "PRODUCT_NAME" DATATYPE C STRING(40) COLUMN "SALES_PRICE" DATATYPE INTEGER COLUMN "PRODUCT_COST" DATATYPE INTEGER INDEX "CUSTOM_CUSTOM_PK" TYPE NATIVE SORTED AS "CUSTOMERS.CUSTOMER_NO" UNIQUE INDEX "PRODUC_PRODUC_PK" TYPE NATIVE SORTED AS "PRODUCTS.PRODUCT_NO" UNIQUE