Table 22-4 lists the types of table provided as the sample database. Table 22-5 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-4 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-5 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)