22.2 Table definition information

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 nameContentsNumber of rows
CUSTOMCustomer master100
GOODSProduct master100
VENDORVendor master50
TAKEODROrders receivedData loading not applicable
STOCKStock100
WAREHUSWarehousingData loading not applicable
SHIPMNTShipmentsData loading not applicable
SENDODROrders placedData loading not applicable
LAYINPurchasingData loading not applicable

Table 22-6 Column attributes and indexes of the tables

Table nameColumn nameColumn attributeIndex name
CUSTOMCUSTOM_CDCHAR(5)UNIQUE CLUSTER
KEY CUSTOMX
CUSTOM_NAMECHAR(30)
TELNOCHAR(12)
ZIPCDCHAR(3)
ADDRESSCHAR(30)
GOODSPRODUCT_CDCHAR(6)UNIQUE CLUSTER
KEY GOODSX
PRODUCT_NAMECHAR(30)
PRICEDECIMAL(7,0)
VENDOR_CDCHAR(5)
VENDORVENDOR_CDCHAR(5)UNIQUE CLUSTER
KEY VENDORX
VENDOR_NAMECHAR(30)
TELNOCHAR(12)
ZIPCDCHAR(3)
ADDRESSCHAR(30)
TAKEODRORDER_ACCEPTED_CDCHAR(7)CLUSTER KEY
CUSTOM_CDCHAR(5)
PRODUCT_CDCHAR(6)
QUANTITYDECIMAL(7,0)
RESERVED_QUANTITYDECIMAL(7,0)
SURPLUSDECIMAL(7,0)
ORDER_ACCEPTED_DATECHAR(6)
DELIVERY_DATECHAR(6)
STOCKPRODUCT_CDCHAR(6)
STOCKDECIMAL(7,0)
RESERVED_QUANTITYDECIMAL(7,0)
ORDERDECIMAL(7,0)
VENDOR_CDCHAR(5)
WAREHUSPRODUCT_CDCHAR(6)
WAREHOUSEDECIMAL(7,0)
LAY_IN_NOINTEGER
WAREHOUSE_DATECHAR(6)
SHIPMNTPRODUCT_CDCHAR(6)
SHIPMENTDECIMAL(7,0)
ORDER_ACCEPTED_CDCHAR(7)
ORDER_ACCEPTED_DATECHAR(6)
SENDODRORDER_NOINTEGERCLUSTER KEY
SENDODRX
VENDOR_CDCHAR(5)
PRODUCT_CDCHAR(6)
ORDER_QUANTITYDECIMAL(7,0)
ORDER_DATECHAR(6)
DELIVERY_DATECHAR(6)
LAYINLAY_IN_NOINTEGERCLUSTER KEY
LAYINX
VENDOR_CDCHAR(5)
PRODUCT_CDCHAR(6)
LAY_IN_QUANTITYDECIMAL(7,0)
LAY_IN_DATECHAR(6)