Table layouts

Categories

NameTypeDescription
categoryTextName in breadcrumb format.

Custom

NameTypeDescription
sectionIntegerSection number: 0=order header, 1=detail line
seqIntegerOrder in which control appears within section.
typeIntegerControl type: 0=header, 1=spinner, 2=checkbox, 3=text.
nameTextThe name of the control, as shown to the user.
valsTextAny additional values. For spinners, this is a list of options, separated by commas.

Customers

NameTypeDescription
customerIdTextUnique id of customer.
employeeIdLongEmployee who sells to customer.
priceListByteInteger between 0 and 4.
taxCodeTextCan be left blank.
nameTextName of customer.
addressTextStreet address.
cityText 
regionText 
postalCodeTextPost code or zip code.
countryText 
latitudeLongObsolete.
longitudeLongObsolete.
contactTextName of contact.
contactTitleTextJob title of contact.
phoneTextPhone number.
emailTextEmail address.
notesMemoNotes about the order.
discountDoubleDefault value for new orders.
colourByteObsolete.
dirtyBooleanSet when record is uploaded.

Employees

NameTypeDescription
employeeIdLongUnique id of employee.
nameTextName of employee.
passwordTextPassword for web server.
restrictedBooleanCannot change company data.

Order Details

NameTypeDescription
employeeIdLongEmployee who created the order.
orderIdLongUnique id of order.
productIdTextUnique id of product.
unitPriceCurrencyUnit price.
quantityDouble 
discountDouble 
taxCodeTexttax code.
taxRateDoubletax rate.
customTextObsolete.

Orders

NameTypeDescription
employeeIdLongEmployee who created the order .
orderIdLongUnique id of order
customerIdTextUnique id of customer.
orderDateTextDate of order.
requiredDateTextDate when order is required.
shipperTextDelivery method.
freightCurrencyDelivery charge.
shipNameTextName of recipient.
shipAddressTextDelivery address.
shipCityText 
shipRegionText 
shipPostalCodeText 
shipCountryText 
notesMemo 
stampTextSet when order was uploaded.
customTextObsolete.
typeByte0=invoice, 1=credit note, 2=quote.
dirtyBooleanSet when record is uploaded.
latitudeLongObsolete.
longitudeLongObsolete.

Products

NameTypeDescription
productIdTextUnique id of product.
nameTextName of product.
categoryTextProduct category.
barcodeText 
priceCurrencyMain price.
price1CurrencyAlternative prices.
price2Currency 
price3Currency 
price4Currency 
taxCodeTextTax code.
discontinuedBooleanProduct is not available.
notesMemo 
bandingTextPrice banding, e.g. 1-10-100.
stockDoubleCurrent stock level.

Shippers

NameTypeDescription
shipperTextName of shipping method.

Special Prices

NameTypeDescription
customerIdTextUnique id of customer.
productIdTextUnique id of product.
priceDoubleSpecial price.
descriptionTextReason for awarding special price.

Tax Rates

NameTypeDescription
codeTextCode printed on invoices.
descriptionTextDescription of tax rate.
rateDoubleRate as percentage.
seqLongSequence in which rate appears.

Author: Philip Sheard

Philip Sheard has been working in IT for over 40 years, and on this project for the last 20. His current skills include Java, Android, Objective-C, iOS, PHP, MySQL, ASP.Net, SQL Server, HTML, CSS, Apache and WordPress.