Orders - Installation and Build Script

The following is the installation and build script combined into a single file, for the Orders sample database. This script is shipped with the sample database in every server software installation.

orders.env
I
CUSTOMERS
COMPANY;G1;SX;KW
CONTACT;G1;SX;KW
AKA_COMPANY;SX;KW
CITY;G2;KW
STATE;G2;CI
POSTAL_CODE;G2;KW
AREA_CODE!
PHONE_NO,1,3
PH_ZP2
PHONE2
/
COMMENTS;KW
/
ACTIVITY
CUSTOMER_NO;kw
/
DATE_TICKLER;G3;KW
TICKLER;G3;KW
INITIALS;G3;KW
ACTION_INFO;KW
/
CUST_NOTES
CUSTOMER_NO;kw
/
DATE_ENTERED
DESC_LINES1;G4;RC;KW
DESC_LINES2;G4;RC;KW
DESC_LINES3;G4;RC;KW
DESC_LINES4;G4;RC;KW
DESC_LINES5;G4;RC;KW
/
ORDERS
CUSTOMER_NO;kw
/
CUSTOMER_NO
PRODUCT_NO;KW
ORDER_DATE
STATUS;kw
QUANTITY
/
PRODUCTS
PRODUCT_NO;KW
PRODUCT_CLASS;KW
PRODUCT_NAME;KW
/
INVENTORY
/
PRODUCT_NO
INV_QTY
INV_DATE
INV_LOC;KW
INV_COST
/
/
CUSTOMERS
CUSTOMER_NO
COMPANY
STATE_ZIP!
STATE
POSTAL_CODE
/
/
PRODUCTS
PRODUCT_NO
PRODUCT_NAME
CLASSNAME_AG!
PRODUCT_CLASS
PRODUCT_NAME
SALES_PRICE
PRODUCT_COST
/
/
ORDERS
CUSTPROD_AG!
CUSTOMER_NO
PRODUCT_NO
QUANTITY
AMOUNT
/
PRODSTAT_AG!
PRODUCT_NO
STATUS
QUANTITY
AMOUNT
/
PRODCLAS_AG!
PRODUCT_NO
STATUS
QUANTITY
AMOUNT
/
ORDDATE_AG!
ORDER_DATE
QUANTITY
AMOUNT
/
/
INVENTORY
PRODUCT_NO
LOCPROD_AG!
INV_LOC
PRODUCT_NO
INV_QTY
INV_COST
/
PRODDATELOC_AG!
PRODUCT_NO
INV_DATE
INV_LOC
INV_QTY
INV_COST
/
/
ACTIVITY
FOLLOW_UP!
INITIALS
TICKLER
DATE_TICKLER
/
/
/
B
CUSTOMERS
B
PRODUCTS
B
INVENTORY
B
CUSTOMERS;CUSTOMER_NO
B
CUSTOMERS;COMPANY
B
CUSTOMERS;STATE_ZIP
B
PRODUCTS;PRODUCT_NO
B
PRODUCTS;PRODUCT_NAME
B
PRODUCTS;CLASSNAME_AG
B
INVENTORY;PRODUCT_NO
B
INVENTORY;LOCPROD_AG
B
INVENTORY;PRODDATELOC_AG
B
ORDERS;CUSTPROD_AG
B
ORDERS;PRODSTAT_AG
B
ORDERS;PRODCLAS_AG
B
ORDERS;ORDDATE_AG
B
ACTIVITY;FOLLOW_UP
QUIT

Top