Table 22-5 lists the types of table provided as the sample database. Table 22-6 shows the column attributes of the tables.
All the tables presented here have the FIX attribute. If you execute the SPsetup.bat file without customizing it, these tables are stored in user RDAREA RDDATA10 and their indexes in user RDAREA RDINDX10.
Table 22-5 Tables provided as sample database
Table name | Contents | Number of rows |
---|---|---|
CUSTOM | Customer master | 100 |
GOODS | Product master | 100 |
VENDOR | Vendor master | 50 |
TAKEODR | Orders received | Data loading not applicable |
STOCK | Stock | 100 |
WAREHUS | Warehousing | Data loading not applicable |
SHIPMNT | Shipments | Data loading not applicable |
SENDODR | Orders placed | Data loading not applicable |
LAYIN | Purchasing | Data loading not applicable |
Table 22-6 Column attributes and indexes of the tables
Table name | Column name | Column attribute | Index name |
---|---|---|---|
CUSTOM | CUSTOM_CD | CHAR(5) | UNIQUE CLUSTER KEY CUSTOMX |
CUSTOM_NAME | CHAR(30) | ||
TELNO | CHAR(12) | ||
ZIPCD | CHAR(3) | ||
ADDRESS | CHAR(30) | ||
GOODS | PRODUCT_CD | CHAR(6) | UNIQUE CLUSTER KEY GOODSX |
PRODUCT_NAME | CHAR(30) | ||
PRICE | DECIMAL(7,0) | ||
VENDOR_CD | CHAR(5) | ||
VENDOR | VENDOR_CD | CHAR(5) | UNIQUE CLUSTER KEY VENDORX |
VENDOR_NAME | CHAR(30) | ||
TELNO | CHAR(12) | ||
ZIPCD | CHAR(3) | ||
ADDRESS | CHAR(30) | ||
TAKEODR | ORDER_ACCEPTED_CD | CHAR(7) | CLUSTER KEY |
CUSTOM_CD | CHAR(5) | ||
PRODUCT_CD | CHAR(6) | ||
QUANTITY | DECIMAL(7,0) | ||
RESERVED_QUANTITY | DECIMAL(7,0) | ||
SURPLUS | DECIMAL(7,0) | ||
ORDER_ACCEPTED_DATE | CHAR(6) | ||
DELIVERY_DATE | CHAR(6) | ||
STOCK | PRODUCT_CD | CHAR(6) | |
STOCK | DECIMAL(7,0) | ||
RESERVED_QUANTITY | DECIMAL(7,0) | ||
ORDER | DECIMAL(7,0) | ||
VENDOR_CD | CHAR(5) | ||
WAREHUS | PRODUCT_CD | CHAR(6) | |
WAREHOUSE | DECIMAL(7,0) | ||
LAY_IN_NO | INTEGER | ||
WAREHOUSE_DATE | CHAR(6) | ||
SHIPMNT | PRODUCT_CD | CHAR(6) | |
SHIPMENT | DECIMAL(7,0) | ||
ORDER_ACCEPTED_CD | CHAR(7) | ||
ORDER_ACCEPTED_DATE | CHAR(6) | ||
SENDODR | ORDER_NO | INTEGER | CLUSTER KEY SENDODRX |
VENDOR_CD | CHAR(5) | ||
PRODUCT_CD | CHAR(6) | ||
ORDER_QUANTITY | DECIMAL(7,0) | ||
ORDER_DATE | CHAR(6) | ||
DELIVERY_DATE | CHAR(6) | ||
LAYIN | LAY_IN_NO | INTEGER | CLUSTER KEY LAYINX |
VENDOR_CD | CHAR(5) | ||
PRODUCT_CD | CHAR(6) | ||
LAY_IN_QUANTITY | DECIMAL(7,0) | ||
LAY_IN_DATE | CHAR(6) |