Data Tables
Personnel
Field
Name
|
Data
type
|
Size
|
Description
|
Identification
|
|||
Name
|
|||
Address
|
|||
Gender
|
|||
Age
|
|||
Email-address
|
|||
TelephoneNo
|
|||
WorkArea
|
Shoe file
The information below details Martin’s Shoes sales
information.
Field
Name
|
Data
Type
|
Size
|
Description
|
ShoesID
|
|||
BatchNo
|
|||
Stock
|
|||
ReorderQty
|
|||
Rate
|
|||
Size
|
|||
Color
|
|||
Category
|
Order file
The order file consists of information about each order. The
information listed below is received from sales.
Field
Name
|
Data
Type
|
Size
|
Description
|
Bill file
This file will store the invoice information of the
particular order.
Fieldname
|
DataType
|
Size
|
Description
|
Clearing file
Field
Name
|
DataType
|
Size
|
Description
|
OrderNo
|
|||
Amount
|