|
As is customary in Database applications, AL-Desk uses an SQL Database with fully normalized tables. Thus Web Methods that Get data consist of the "Thing" or "Noun" type Data and an Integer value or "Code" that uniquely identifies that item. Puts involve Verbs or transactions performed on the nouns.
Noun
|
Integer Code Field
|
Locations
|
Code
|
Categories
|
Code
|
Products
|
Code
|
Vendors
|
Code
|
Rates
|
Code
includes reference to
Location Code as Location
Category Code as Category
Vendor Code as Vendor
Product Code as Product
|
Availability
|
Category Code
Location Code
Vendor Code
Product Code
|
Client
|
Code
|
WebuserCode
|
WebuserCode
|
All Transactions required a WebuserCode for Security
Verbs
|
Associated Integer Code Fields
|
Insert a Client
|
Client Code
WebUserCode
|
Create a Voucher
|
Client Code
WebUserCode
|
Log a Payment
|
Client Code
WebuserCode
|
|
|
|
|
|
|
|