Table-name: ACCOUNTS.dbf		General Ledger Account ID and Description
Table-name: BROWSE_TRACKING.dbf		Detailed website activity table
Table-name: CALLTYP.dbf		Call or visit options
Table-name: CATEGORY.dbf		Category information
Table-name: COLOUR.dbf		Impression colours of products refers to Product-table
Table-name: COMPANY.dbf		Information of each company. For multiple administrations with 1 production-system
Table-name: COMPLNT.dbf		Complaint options to comply with ISO regulations
Table-name: CONTRACT.dbf		Contractprice
Table-name: CURRENCY.dbf		Currency options with ID's and currency rates
Table-name: CUSCALL.dbf		Call or visit registration
Table-name: CUSSERV.dbf		Complaint registration with follow-up specifications; to comply with ISO regulations
Table-name: CUSTDATA.dbf		Customer data export file
Table-name: CUSTGRP.dbf		Default information and properties of groups of customers
Table-name: CUSTOMER.dbf		Customer-data
Table-name: DISCOUNT.dbf		Discount information and percentages
Table-name: HISTORY.dbf		During an invoice-run conversion data is stored in this table.
Table-name: HISTTOT.dbf		intermetiate history table
Table-name: INVADDR.dbf		Table with invoice-to addresses
Table-name: INVDATA.dbf		Invoice-data for export into accounting. Emptied after each accounting-export
Table-name: INVDATAL.dbf		Compressed invoice information as Invdata-table. Data are kept forever
Table-name: INVOICE.dbf		Contains ALL invoice details
Table-name: KEYWORDS_INDEX.dbf		Keywords-table for faster search via web-site
Table-name: KNOWLEDGEBASE.dbf
Table-name: LANGUAGE.dbf		Multi language table
Table-name: LANGUAGE_GLOBAL.dbf		Multi language table
Table-name: LASER.dbf		List of available lasers and ID-codes
Table-name: LASERSET.dbf		Contains settings, properties per laser-engraver
Table-name: MOUNT.dbf		Mount options
Table-name: NOTES.dbf		Table with pre-defined notes. Only for SOSET typeset Quick
Table-name: ORDITEM*.dbf		Table with Order items
Table-name: ORDMAIN*.dbf		Table with order headers. (Only one per order)
Table-name: PAGE.dbf		Page information, during a PageWizard routine SOSET stores page-layout-specs in this table
Table-name: PAYMENT.dbf		Payments are stored in this table
Table-name: PAYTYPES.dbf		Ways of payment
Table-name: PRINTSET.dbf		Contains different production-categories. This table controls output and sort-order by stamp-category
Table-name: PRODGRP.dbf		Product groups, refer to Accounts-table
Table-name: PRODUCT.dbf		This table contains the information of all products you want to do Typesetting
Table-name: PUR_ITEM.dbf		Purchase orderitem table
Table-name: PUR_MAIN.dbf		Purchase order header table
Table-name: PUR_PROD.dbf		Purchase product table with vendor and product details
Table-name: QJOB.dbf		Temporary table with texts. Only for SOSET typeset Quick
Table-name: RANDOMSSS.dbf		List of random codes
Table-name: RECLAIM.dbf		Order redo and complaints registration to comply with ISO regulations
Table-name: REGION.dbf		shipment regions for freight specifications
Table-name: SHIPPER.dbf		Shipment options and specifications
Table-name: SHORTCUT.dbf		Typeset shortcut definitions
Table-name: SHPADDR.dbf		Table with ship-to addresses
Table-name: STAMP*.dbf		This table contains actual stamp-data
Table-name: STAMP_TEMPLATE.dbf		This table contains actual stamp template data
Table-name: SYSTEM.dbf		MAY NOT BE EDITED!! This table contains system information;default values for all users
Table-name: TAX.dbf		Different tax-options with percentages
Table-name: TERMS.dbf		Payment terms
Table-name: TRACKING.dbf		Website activity table
Table-name: USER.dbf		User, salesman and remote customer information
Table-name: VENDOR.dbf		Vendor table

01 Structure of Database Table: ACCOUNTS.dbf
General Ledger Account ID and Description
Index:	1 accid on field(s) accountid 2 accdesc on field(s) upper(acc_desc) + accountid 3 prodidac on field(s) prodgrpid + accountid

 

No	Fieldname	Type	Length	Decimals	Description
7	ACCIDREM	C	10	0	GL-account-id-number of remote site in multi cie environment
1	ACCOUNTID	C	10	0	GL-account-id-number
5	ACC_DESC	C	40	0	description
2	ACC_STATIS	C	5	0	additional id-number e.g. as statistical number
4	ACC_TYPE	C	15	0	debet or credit
3	PRODGRPID	C	2	0	product group id refers to prodgrp table
6	SALES	L	1	0	is this a sales account? True or False / Yes or No

02 Structure of Database Table: CALLTYP.dbf
Call or visit options
Index:	1 callid on field(s) callid

 

No	Fieldname	Type	Length	Decimals	Description
1	CALLID	C	2	0	Call or Visit ID
2	DESC	C	30	0	Call or Visit description

03 Structure of Database Table: CATEGORY.dbf; in combination with memo-file: CATEGORY.fpt
Category information
Index:	1 catid on field(s) id 2 endcat on field(s) endcat

 

No	Fieldname	Type	Length	Decimals	Description
2	CATEGORY	C	60	0	Category description
5	CATIMP	C	150	0	Contains the category image
6	CATTXT	M	4	0	Contains the category description
3	ENDCAT	C	1	0	0: No end category; 1: End category
1	ID	C	20	0	Category ID
4	TYPESET	L	1	0	0: No Typeset category (stock); 1: Typeset category

04 Structure of Database Table: COLOUR.dbf
Impression colours of products refers to Product-table
Index:	1 colourid on field(s) colourid 2 rgb on field(s) ltrim(str(rgb, 16, 0))

 

No	Fieldname	Type	Length	Decimals	Description
2	COLOUR	C	10	0	Colour name
1	COLOURID	C	2	0	Inkpad or impression colour
3	RGB	N	16	0	RGB-colour number for filtered output per required colour, default is -1

05 Structure of Database Table: COMPANY.dbf
Information of each company. For multiple administrations with 1 production-system
Index:	1 company on field(s) companyid

 

No	Fieldname	Type	Length	Decimals	Description
11	ACCOUNTID	C	30	0	General company Account ID debtors
3	ADDRESS1	C	30	0	Company address
5	CITY	C	30	0	Company city
2	COMPANY	C	30	0	Company name
1	COMPANYID	C	6	0	Company identifier
6	COUNTRY	C	30	0	Company country
19	CUSTID	C	6	0	Customer ID number
12	DATAPATH	C	64	0	Company SOSET tables directory; in multi-company relative path
25	DUNS	C	10	0	Dun & Bradstreet registration number
8	EMAIL	C	30	0	Company e-mail
9	FAX	C	30	0	Company faxnumber
14	FOOTERLOGO	C	50	0	Company default document footer
21	FOOTEROPOS	C	50	0	Footer file for printing via OPOS printer
16	FOOTERXPOS	N	6	0	Company default document footer X-position in MM from left side
13	HEADERLOGO	C	50	0	Company default document header
20	HEADEROPOS	C	50	0	Header file for printing via OPOS printer
15	HEADERXPOS	N	6	0	Company default document header X-position in MM from left side
18	HOSTPROD	L	1	0	DO NOT USE only for backwards compatibility
27	INVOICENO	C	6	0	Next invoicenumber
17	LOCALPROD	L	1	0	Switch for local production: typeset-data NOT exported
24	MAINCOMP	L	1	0	TRUE: To identify that this is the main company
7	PHONE	C	30	0	Company phone
4	POSTAL	C	30	0	Company postal code
22	SHIPHERE	L	1	0	TRUE: Only ship orders in this company; Used during export of orders. Imported orders get the NOSHPORDER flag
23	SYNCHRON	L	1	0	TRUE: Create synchronization tables
10	VATID	C	30	0	Company Vat-id
26	WEBCUSTGRP	C	10	0	CustomerGroup for web-order-customers

06 Structure of Database Table: COMPLNT.dbf
Complaint options to comply with ISO regulations
Index:	1 complid on field(s) complntid

 

No	Fieldname	Type	Length	Decimals	Description
1	COMPLNTID	C	2	0	Complaint ID
2	DESC	C	30	0	Complaint description

07 Structure of Database Table: CONTRACT.dbf
Contractprice
Index:	1 custid on field(s) custid + upper(prodid) 2 prodid on field(s) upper(prodid) + custid

 

No	Fieldname	Type	Length	Decimals	Description
1	CUSTID	C	6	0	Customer ID number
8	DISCOUNT	L	1	0	TRUE if discount is applicalble on contractprice
2	PRODID	C	12	0	Conttractprices's product ID
3	UNITPRICE1	N	10	2	Gros Price 1; always in company default currency
4	UNITPRICE2	N	10	2	Gros Price 2; in currency 2
5	UNITPRICE3	N	10	2	Gros Price 3; in currency 3
6	UNITPRICE4	N	10	2	Gros Price 4; in currency 4
7	UNITPRICE5	N	10	2	Gros Price 5; in currency 5

08 Structure of Database Table: CURRENCY.dbf
Currency options with ID's and currency rates
Index:	1 currenid on field(s) id

 

No	Fieldname	Type	Length	Decimals	Description
6	COUNTRY	C	20	0	Country
2	CURRENCY	C	20	0	Currency name
10	DCN_CODE	C	2	0	DCN code
9	EBS_CODE	C	3	0	EBS code
7	EMUMEMBER	L	1	0	Switch for member of European Monetair Union (Euro)
1	ID	C	2	0	Currency ID
8	ISO_CODE	C	10	0	Iso Code
5	PER	N	8	0	rate is specified per ... units
4	RATE	N	10	6	Rate
3	SYMBOL	C	10	0	Output-Symbol

09 Structure of Database Table: CUSCALL.dbf; in combination with memo-file: CUSCALL.fpt
Call or visit registration
Index:	1 datein on field(s) str(99999999 - val(dtos(date_in))) + custid 2 custid on field(s) custid + str(99999999 - val(dtos(date_in))) 3 custid2 on field(s) custid + dtos(date_in)

 

No	Fieldname	Type	Length	Decimals	Description
8	ACTIONBY	C	2	0	Action by user (refers to User-table)
1	CALLID	C	2	0	Call or Visit ID refers to Calltyp table
3	CURRENT	L	1	0	Current customer True or False / Yes or No
2	CUSTID	C	10	0	Customer ID number
13	CUSTOMERID	C	6	0	Customer-number
9	DATE_ACT	D	8	0	Date of action
4	DATE_IN	D	8	0	Date entered
12	DOCUMENT	C	50	0	related document in
6	DONEBYID	C	2	0	Entered by user (refers to User-table)
7	INFO	M	4	0	Information memofiled
11	SATISLEVEL	N	1	0	Satisfaction level 1-5
10	TIME_ACT	C	8	0	Time of action
5	TIME_IN	C	8	0	Time entered

10 Structure of Database Table: CUSSERV.dbf; in combination with memo-file: CUSSERV.fpt
Complaint registration with follow-up specifications; to comply with ISO regulations
Index:	1 datein on field(s) dtos(date_in) + custid 2 custid on field(s) custid + str(99999999 - val(dtos(date_in))) + str(999999 - val(substr(time_in, 1, 2) + substr(time_in, 4, 2) + substr(time_in, 7, 2))) 3 custid2 on field(s) custid + dtos(date_in) 4 complid on field(s) complntid + dtos(date_in) + custid 5 takenby on field(s) takenbyid 6 datein2 on field(s) str(99999999 - val(dtos(date_in))) + str(999999 - val(substr(time_in, 1, 2) + substr(time_in, 4, 2) + substr(time_in, 7, 2)))

 

No	Fieldname	Type	Length	Decimals	Description
7	ACTIONBY	C	2	0	Action taken by user (refers to user table)
1	COMPLNTID	C	2	0	Complaint ID; refers to Complnt table
2	CUSTID	C	10	0	Customer ID number
8	DATE_ACT	D	8	0	Date action
3	DATE_IN	D	8	0	Date entered
10	DOCUMENT	C	50	0	path+filename of related document
6	INFO	M	4	0	Information
5	TAKENBYID	C	2	0	Entered by user (refers to user-table)
9	TIME_ACT	C	8	0	Time action
4	TIME_IN	C	8	0	Time entered

11 Structure of Database Table: CUSTDATA.dbf

Customer data export file

 

No	Fieldname	Type	Length	Decimals	Description
1	COMPANYID	C	6	0	ID from Company.dbf
21	CONTACT	C	40	0	Contactperson
2	CUSTID	C	6	0	Customer ID number
25	FAXNO	C	40	0	Faxnumber
13	FINANEXP	C	40	0	Posting accountnumber
23	FIRSTORDER	D	8	0	Date of first order
7	GROUPID	C	10	0	CustomergroupID
8	INVCUSTID	C	6	0	Invoice to customerID
22	INVOICETO	N	1	0	1=invoice to InvCustID; 0=to CustID
31	MLADDRESS	C	40	0	Mail-address
29	MLCITY	C	40	0	Mail-city
27	MLCOUNTRY	C	50	0	Mail-country
30	MLPOSTAL	C	15	0	Mail-postal code
28	MLSTATE	C	40	0	Mail-state
4	NAME1	C	40	0	Name of customer
5	NAME2	C	40	0	Name2 of customer
19	PAYTYPENO	C	30	0	Type of payment
26	PHONENO	C	40	0	Phonenumber
20	SALESMANID	C	2	0	Salesman identifier
6	SEARCHNAME	C	6	0	Search expression
14	STRADDRESS	C	40	0	Address
16	STRCITY	C	40	0	City
18	STRCOUNTRY	C	40	0	Country
15	STRPOSTAL	C	15	0	Postal code
17	STRSTATE	C	40	0	State
9	TAX1	C	2	0	Tax option 1
10	TAX2	C	2	0	TaxID2 refers to Tax-table
11	TAX3	C	2	0	Tax option 3
24	TERMID	C	2	0	Payment/delivery term ID (refers to Terms table)
3	TYPE	C	1	0	Type of customerdata; 1=New; 2=Edited
12	VATCODE	C	15	0	VAT-identifier from Tax-table

12 Structure of Database Table: CUSTGRP.dbf; in combination with memo-file: CUSTGRP.fpt
Default information and properties of groups of customers
Index:	1 cgid on field(s) custgrpid 2 taxarea on field(s) iif(useforweb,1,0)

 

No	Fieldname	Type	Length	Decimals	Description
50	ADDRESS	C	40	0	Address
42	ASN	L	1	0	Advanced Shipping Notice switch. Generated after ship run
52	CITY	C	40	0	City
9	CONTACT	C	40	0	contactperson of the Customer Group
39	COPYYR8	N	12	2	DO NOT USE only for backwards compatibility
55	COUNTRY	C	3	0	Country ID (UN-abbreviations)
46	CPYCURID	L	1	0	Switch if currencyID must be copied to customer
59	CPYTAX	L	1	0	Switch if taxID must be copied to customer
44	CURRENCYID	C	2	0	CurrencyID of customergroup
2	CUSTGRP	C	40	0	Customer Group description
1	CUSTGRPID	C	10	0	Customer Group ID
57	CUSTID	C	6	0	Customer ID number
10	DISCOUNTID	C	6	0	Discount ID refers to ID in Discount-table
19	DISKINV	L	1	0	Switch for Invoicedata to file for digital invoicing
3	FIRSTORDER	D	8	0	First order date of any member of this Customer Group
13	FREIGHT	N	1	0	Charge for freight cost 1=... 2=...
35	FRIST	N	1	0	Only for use in Netherlands
7	INFO	M	4	0	default orderinfo for all orders for any member of this Customer Group
36	INFOINTERN	M	4	0	Internal information appears only on screens and internal documents
58	INVFORMAT	N	2	0
18	INVFREQ	N	2	0	Default invoice frequency for all members of this customer group
47	INVMAIN	L	1	0	TRUE: Only invoice orders in main company
48	INVMAINCID	C	6	0	Only invoice in this Main companyID
4	LASTORDER	D	8	0	Last order date of any member of this Customer Group
43	NOCPYDISID	L	1	0	True/False FALSE -> Copy discountID to customer
17	NO_PRICE	L	1	0	Switch for printing price and discount n shipping document
11	ORDERTYPE	N	2	0	Default ordertype for all orders for this customer-group 1=... 2=...
45	ORD_FORGN	L	1	0	True or False / Yes or No; TRUE if customer has foreign currency
8	OUR_MAN	C	40	0	Contact to customer group (refers to user-table)
51	POSTAL	C	15	0	Postal Code
14	PRICELIST	N	2	0	Default pricelist number from product-table
37	PRNT2INV	L	1	0	True or False / Yes or No
38	PROOFPRINT	L	1	0	True or False / Yes or No
12	QDISCOUNT	L	1	0	Switch for quantity discount for the whole group
16	QUALCHECK	L	1	0	Switch for qualitycheck during shipment
5	REF_1	C	40	0	default reference for all orders for any member of this Customer Group
6	REF_2	C	40	0	default reference for all orders for any member of this Customer Group
54	REGION	C	40	0	Region (from Region table)
40	RUSH	N	1	0	Rush code for this customergroup
25	SALES_YR0	N	12	2	Total of net-sales of this customer group in year 0 (e.g. 2000; 2010)
26	SALES_YR1	N	12	2	Total of net-sales of this customer group in year 1
27	SALES_YR2	N	12	2	Total of net-sales of this customer group in year 2
28	SALES_YR3	N	12	2	Total of net-sales of this customer group in year 3
29	SALES_YR4	N	12	2	Total of net-sales of this customer group in year 4
30	SALES_YR5	N	12	2	Total of net-sales of this customer group in year 5
31	SALES_YR6	N	12	2	Total of net-sales of this customer group in year 6
32	SALES_YR7	N	12	2	Total of net-sales of this customer group in year 7
33	SALES_YR8	N	12	2	Total of net-sales of this customer group in year 8
34	SALES_YR9	N	12	2	Total of net-sales of this customer group in year 9
24	SHPTERMID	C	2	0	Delivery term ID of
53	STATE	C	40	0	Send statement for each order? True or False / Yes or No
15	STATEMENT	L	1	0	Send statement for each order? True or False / Yes or No
41	SUM_INV	L	1	0	True or False / Yes or No
20	TAX1	C	2	0	Tax1 ID (refers to Tax-table)
21	TAX2	C	2	0	Tax2 ID (refers to Tax-table)
22	TAX3	C	2	0	Tax3 ID (refers to Tax-table)
23	TERMID	C	2	0	Payment/delivery term ID (refers to Terms table)
56	USEFORWEB	L	1	0	This profile may be used for SOSET-vt-Web orders
49	WEBFILTER	N	2	0	WebfilterID

13 Structure of Database Table: CUSTOMER.dbf; in combination with memo-file: CUSTOMER.fpt
Customer-data
Index:	1 custidc on field(s) custid 2 srchname on field(s) searchname 3 srchcity on field(s) searchcity 4 groupid on field(s) groupid 5 firsdate on field(s) firstorder 6 lastdate on field(s) lastorder 7 postal on field(s) strpostal 8 vattype on field(s) vattype 9 pabno on field(s) pabno 10 email on field(s) upper(email) 11 ipaddress on field(s) ipaddress

 

No	Fieldname	Type	Length	Decimals	Description
117	ASN	L	1	0	Advanced Shipping Notice switch. Generated after ship run
131	AUTOPUR	L	1	0	preparation of purchase via SOSET-purchase from sales-order
74	BANKCODE	C	10	0	DO NOT USE only for backwards compatibility
142	BANKINFO	C	40	0	Bankname
137	CARDID	C	5	0	CVV code on back creditcard 3 pos
91	CASHREGIST	L	1	0	switch for Is this customer a batch cash-resgiter account?
133	CCDD	C	6	0	Creditcard exp date
134	CCID	C	2	0	Type of Creditcard
136	CCNAME	C	25	0	Name on Creditcard
135	CCNO	C	30	0	Creditcard number
51	CHAMBERREG	C	25	0	Chamber of commerce registration number
89	CHKSHIP	L	1	0	Switch Do you want to check shipment during order-entry?
63	COLORID	C	2	0	Default inkpad colout
85	COMPANYID	C	6	0	Company ID
15	CONTACT	C	40	0	Contact person
80	COPYCUSTGR	L	1	0	Automatic copying of settings from CustomerGroup T/F or Y/N
53	CREDLIMIT	N	10	0	Credit limit
1	CUSTID	C	6	0	Customer ID number
62	DISCOUNTID	C	6	0	Discount ID, refers to Discount-table
79	DISKINV	L	1	0	Digital Invoice information generation: T/F or Y/N
18	EMAIL	C	60	0	E-mail address (eg used for automatic send of proof)
88	EMB_COUNT	N	3	0	Embargo counter
17	FAXNO	C	40	0	Fax number (eg used for automatic send of proof)
132	FINCUSTID	C	6	0	CustomerID to which postings will be done in GL
84	FINEXPCOD	N	1	0	Optional Financial export code
25	FIRSTORDER	D	8	0	Only for NL-market
123	FOOTERLOGO	C	50	0	path+filename for Footerimage
121	FOOTEROPOS	C	50	0	path+filename for Footertext for POS printer
125	FOOTERXPOS	N	6	0	X Position for footer on output
76	FREIGHT	N	1	0	Charge for freight cost
108	FREIGHTLIM	L	1	0	Switch for freight limit as specified in global prefs.
2	GROUPID	C	10	0	Customer Group ID refers to CustGrp table
122	HEADERLOGO	C	50	0	path+filename for Headerimage
120	HEADEROPOS	C	50	0	path+filename for Headertext for POS printer
124	HEADERXPOS	N	6	0	X Position for header on output
60	HISTORY	M	4	0	Customer-History information
115	HOLDDATE	D	8	0	Date of last credit-hold
143	IBANNO	C	40	0	IBAN number
107	IMPORTANT	C	40	0	Important info field; pops up during view, edit and order-entry
104	INFOINTERN	M	4	0	Internal information. Only on screens and internals documents
66	INVCUSTID	C	6	0	Invoice to this customerID
90	INVDISC	L	1	0	Invoice discount True or False/ Yes or No
23	INVDISCOUN	N	2	0	Invoice discount percentage
140	INVEMAIL	C	60	0	Emailaddress for digital invoice forwarding
141	INVFORMAT	N	2	0	Format of invoice. 1:regular mail; 2:email; 3:both
78	INVFREQ	N	2	0	Invoice frequency
65	INVOICETO	N	1	0	Invoice to another customer 1=Yes; 0=No
118	INVPERCUST	L	1	0	Invoice split by customer during batch invoices
139	IPADDRESS	C	15	0	Ip-number of customer
59	LANGUAGE	C	12	0	DO NOT USE only for backwards compatibility
26	LASTORDER	D	8	0	Last orde date
127	MARGEBOT	N	6	0	distance text from bottom
126	MARGETOP	N	6	0	distance text from top
6	MLADDRESS	C	75	0	Mail address
8	MLCITY	C	40	0	City of mailing address
9	MLCOUNTRY	C	40	0	Country of mailing address
7	MLPOSTAL	C	15	0	Postal code of of mailing address
102	MLSTATE	C	40	0	State/province of mailing address
56	MODIFIED	M	4	0	Customer data modified date
57	MOUNTID	C	2	0	Mount type, refers to Mount table
4	NAME1	C	40	0	Name of customer
5	NAME2	C	40	0	Name of customer
138	NOMAILING	L	1	0	Indicates if customer wants mailings from you
19	NOTE	M	4	0	Customer information
77	NO_PRICE	L	1	0	No price on external forms. True or False/ Yes or No
54	NTERM	N	4	0	DO NOT USE only for backwards compatibility
24	ORDERTYPE	N	2	0	OrderType
114	ORDERVAL	N	10	0	Total Net Order value
106	ORD_FORGN	L	1	0	True or False / Yes or No
129	OVERRULE	L	1	0	Switch for custom header/footer on order only instead of default
130	OVRUL_PACK	L	1	0	Switch for custom header/footer on packling list only instead of default
113	PABNO	C	6	0	Pre Assigned Boxnumber
119	PASSWD	C	15	0	web-site password for customer
16	PHONENO	C	40	0	Phone number
128	PREPRINTED	L	1	0	Use preprinted forms. True or False / Yes or No
22	PRICELIST	N	2	0	Pricelist (1-5) refers to UnitPrice1-5 in Product table
110	PROOFPRINT	L	1	0	Automatic generation of proofprint True or False / Yes or No
61	QDISCOUNT	L	1	0	Switch for quantity discount from global prefs table.
75	QUALCHECK	L	1	0	Switch for quality control marker at packing slip.
14	REGION	C	40	0	Region. State, Province
111	RUSH	N	1	0	Rush code
39	SALELAST01	N	19	2	Total of net-sales of this customer in month 01 of last year
40	SALELAST02	N	19	2	Total of net-sales of this customer in month 02 of last year
41	SALELAST03	N	19	2	Total of net-sales of this customer in month 03 of last year
42	SALELAST04	N	19	2	Total of net-sales of this customer in month 04 of last year
43	SALELAST05	N	19	2	Total of net-sales of this customer in month 05 of last year
44	SALELAST06	N	19	2	Total of net-sales of this customer in month 06 of last year
45	SALELAST07	N	19	2	Total of net-sales of this customer in month 07 of last year
46	SALELAST08	N	19	2	Total of net-sales of this customer in month 08 of last year
47	SALELAST09	N	19	2	Total of net-sales of this customer in month 09 of last year
48	SALELAST10	N	19	2	Total of net-sales of this customer in month 10 of last year
49	SALELAST11	N	19	2	Total of net-sales of this customer in month 11 of last year
50	SALELAST12	N	19	2	Total of net-sales of this customer in month 12 of last year
58	SALESMANID	C	2	0	Salesman-number, refers to User-table
92	SALES_YR0	N	12	2	Total of net-sales of this customer in year 00
93	SALES_YR1	N	12	2	Total of net-sales of this customer in year 01
94	SALES_YR2	N	12	2	Total of net-sales of this customer in year 02
95	SALES_YR3	N	12	2	Total of net-sales of this customer in year 03
96	SALES_YR4	N	12	2	Total of net-sales of this customer in year 04
97	SALES_YR5	N	12	2	Total of net-sales of this customer in year 05
98	SALES_YR6	N	12	2	Total of net-sales of this customer in year 06
99	SALES_YR7	N	12	2	Total of net-sales of this customer in year 07
100	SALES_YR8	N	12	2	Total of net-sales of this customer in year 08
101	SALES_YR9	N	12	2	Total of net-sales of this customer in year 09
27	SALETHIS01	N	19	2	Total of net-sales of this customer in month 01 of this year
28	SALETHIS02	N	19	2	Total of net-sales of this customer in month 02 of this year
29	SALETHIS03	N	19	2	Total of net-sales of this customer in month 03 of this year
30	SALETHIS04	N	19	2	Total of net-sales of this customer in month 04 of this year
31	SALETHIS05	N	19	2	Total of net-sales of this customer in month 05 of this year
32	SALETHIS06	N	19	2	Total of net-sales of this customer in month 06 of this year
33	SALETHIS07	N	19	2	Total of net-sales of this customer in month 07 of this year
34	SALETHIS08	N	19	2	Total of net-sales of this customer in month 08 of this year
35	SALETHIS09	N	19	2	Total of net-sales of this customer in month 09 of this year
36	SALETHIS10	N	19	2	Total of net-sales of this customer in month 10 of this year
37	SALETHIS11	N	19	2	Total of net-sales of this customer in month 11 of this year
38	SALETHIS12	N	19	2	Total of net-sales of this customer in month 12 of this year
64	SEARCHCITY	C	6	0	Search field
3	SEARCHNAME	C	6	0	Search field
67	SHIPDAY1	L	1	0	True or False / Yes or No
68	SHIPDAY2	L	1	0	True or False / Yes or No
69	SHIPDAY3	L	1	0	True or False / Yes or No
70	SHIPDAY4	L	1	0	True or False / Yes or No
71	SHIPDAY5	L	1	0	True or False / Yes or No
72	SHIPDAY6	L	1	0	True or False / Yes or No
73	SHIPDAY7	L	1	0	True or False / Yes or No
55	SHIPPERID	C	2	0	Way of shipment refers to shipper table
87	SHPTERMID	C	2	0	Delivery term ID
21	STATEMENT	L	1	0	True or False / Yes or No
20	STATUS	N	2	0	Financial status: embargo, credit hold, definit etc.
10	STRADDRESS	C	75	0	Company address streetname
12	STRCITY	C	40	0	Company address city
13	STRCOUNTRY	C	40	0	Company address country
11	STRPOSTAL	C	15	0	Company address postal code
103	STRSTATE	C	40	0	Company address state
112	SUM_INV	L	1	0	Summarized invoice or detailed? True or False / Yes or No
81	TAX1	C	2	0	TaxID1 refers to Tax-table
82	TAX2	C	2	0	TaxID2 refers to Tax-table
83	TAX3	C	2	0	TaxID3 refers to Tax-table
86	TERMID	C	2	0	Payment/delivery term ID (refers to Terms table)
105	VALUTAID	N	3	0	Currency ID
52	VATCODE	C	15	0	VAT-code
109	VATTYPE	C	2	0	0: Default; 1: Normal; 2: ICT; 3: Export outside EU
116	VISITED	D	8	0	Last visit date

14 Structure of Database Table: DISCOUNT.dbf
Discount information and percentages
Index:	1 cdidpgid on field(s) discountid + prodgrpid

 

No	Fieldname	Type	Length	Decimals	Description
2	DISCDESC	C	25	0	Discount description
4	DISCOUNT1	N	2	0	Discount percentage 1
5	DISCOUNT2	N	2	0	Discount percentage 2
1	DISCOUNTID	C	6	0	Discount ID
3	PRODGRPID	C	2	0	Product group ID refers to ProdGrp table

15 Structure of Database Table: HISTORY.dbf
During an invoice-run conversion data is stored in this table.
Index:	1 histcust on field(s) substr(dtos(invdate), 1, 6) + prodgrpid + custid 2 histgrp on field(s) substr(dtos(invdate), 1, 6) + prodgrpid + custgrpid + custid 3 histman on field(s) substr(dtos(invdate), 1, 6) + prodgrpid + salesmanid 4 histcgrp on field(s) custgrpid + substr(dtos(invdate), 1, 6) + prodgrpid 5 ordcust on field(s) substr(dtos(invdate), 1, 6) + prodgrpid + ordcustid 6 histgrp2 on field(s) substr(dtos(invdate), 1, 6) + prodgrpid + custgrpid + ordcustid

 

No	Fieldname	Type	Length	Decimals	Description
7	ACCOUNTTYP	C	1	0	Accounttyp (sales; credit/debet)
12	COMPANYID	C	6	0	CompanyID from companytable
2	CUSTGRPID	C	10	0	Customer Group ID refers to CustGrp table
1	CUSTID	C	6	0	Customer ID number
8	EXPORT	L	1	0	Exported to abroad? True or False / Yes or No
11	INVCUSTID	C	6	0	Invoiced to customer ID
4	INVDATE	D	8	0	Invoice date
5	INVVALUE	N	19	2	Total Net Invoice value in default currency
10	ORDCUSTID	C	6	0	Ordered by CustomerID
3	PRODGRPID	C	2	0	product group ID refers to ProdGrp table
6	QUANTITY	N	10	0	Quantity in units
9	SALESMANID	C	10	0	Salesman-number, refers to User-table

16 Structure of Database Table: HISTTOT.dbf
intermetiate history table
Index:	1 histdate on field(s) substr(dtos(invdate), 1, 6) + prodgrpid

 

No	Fieldname	Type	Length	Decimals	Description
7	ACCOUNTTYP	C	1	0	Accounttyp (sales; credit/debet)
12	COMPANYID	C	6	0	CompanyID from companytable
2	CUSTGRPID	C	10	0	Customer Group ID refers to CustGrp table
1	CUSTID	C	6	0	Customer ID number
8	EXPORT	L	1	0	Exported to abroad? True or False / Yes or No
11	INVCUSTID	C	6	0	Invoiced to customer ID
4	INVDATE	D	8	0	Invoice date
5	INVVALUE	N	19	2	Total Net Invoice value in default currency
10	ORDCUSTID	C	6	0	Ordered by CustomerID
3	PRODGRPID	C	2	0	product group ID refers to ProdGrp table
6	QUANTITY	N	10	0	Quantity in units
9	SALESMANID	C	10	0	Salesman-number, refers to User-table

17 Structure of Database Table: INVADDR.dbf
Table with invoice-to addresses
Index:	1 cidinv on field(s) custid

 

No	Fieldname	Type	Length	Decimals	Description
1	CUSTID	C	6	0	Customer ID number
4	INVADDRESS	C	75	0	Invoice address
6	INVCITY	C	40	0	City of Invoice address
7	INVCOUNTRY	C	40	0	Country of Invoice address
2	INVNAME1	C	40	0	Invoice name
3	INVNAME2	C	40	0	Invoice name
5	INVPOSTAL	C	15	0	Postal code of Invoice address
10	INVSTATE	C	40	0	State of Invoice address
8	NEW_CUSTID	C	6	0	DO NOT USE only for backwards compatibility
9	OLD_CUSTID	C	6	0	DO NOT USE only for backwards compatibility

09 Structure of Database Table: INVDATA.dbf(Note: temporary file. Same structure as INVDATAL.dbf!)

Invoice information for export into accounting. This table will be empty after each accounting-export session.

20 Structure of Database Table: INVOICE.dbf
Contains ALL invoice details
Index:	1 invno on field(s) invoiceno + dtos(paydate) 2 invcust on field(s) invcustid + str(99999999 - val(dtos(invdate))) + invoiceno + dtos(paydate)

 

No	Fieldname	Type	Length	Decimals	Description
8	BALANCE	N	15	2	NOT USED YET
12	CURRENCYID	C	2	0	Currency Identifier
4	DUEDATE	D	8	0	Due date
15	FOR_VAL	N	15	2	Total payment in specified foreign value
1	INVCUSTID	C	6	0	Invoice to Customer-number
3	INVDATE	D	8	0	Invoice date
2	INVOICENO	C	6	0	Invoice number
5	INVVALUE	N	15	2	Total Net Invoice value in default currency
7	OUTSTAND	N	15	2	Outstanding
9	PAYDATE	D	8	0	Date of payment
11	PAYDESCR	C	25	0	Description of payment
10	PAYTYPEID	C	2	0	Payment ID refers to PayTypes table
13	PER	N	8	0	unit of currency
14	RATE	N	10	6	Rate of currency at moment of payment
6	VALUEPAID	N	15	2	Amount paid in default currency

52 Structure of Database Table: KEYWORDS_INDEX.dbf
Keywords-table for faster search via web-site
Index:	1 keyword on field(s) upper(keyword + keywordid + site) 2 keywordid on field(s) upper(keywordid) 3 crawldate on field(s) dtos(crawldate)

 

No	Fieldname	Type	Length	Decimals	Description
4	CRAWLDATE	D	8	0
6	INFO	C	100	0
1	KEYWORD	C	25	0
2	KEYWORDID	C	100	0
3	PROPS	N	2	0
5	SITE	C	50	0

53 Structure of Database Table: KNOWLEDGEBASE.dbf; in combination with memo-file: KNOWLEDGEBASE.fpt
Index:	1 searchkey on field(s) upper(left(searchkey1, 40)) 2 articleid on field(s) articleid + upper(left(searchkey1, 40))

 

No	Fieldname	Type	Length	Decimals	Description
1	ARTICLEID	C	10	0
10	DURATION	C	10	0
9	ENTRYDD	D	8	0
12	LEVEL	N	2	0
6	REMARKS	M	4	0
7	REPORTEDBY	C	25	0
5	RESOLUTION	M	4	0
2	SEARCHKEY1	C	100	0
3	SEARCHKEY2	C	100	0
4	SYMPTOMS	M	4	0
8	TAKENBY	C	25	0
11	TYPE	C	25	0

21 Structure of Database Table: LANGUAGE.dbf; in combination with memo-file: LANGUAGE.fpt
Multi language table
Index:	1 def_lng on field(s) upper(def_lng)

 

No	Fieldname	Type	Length	Decimals	Description
1	DEF_LNG	C	150	0	Default text from product or category information
2	LANGUAGES	M	4	0	Memo field with translated texts

22 Structure of Database Table: LANGUAGE_GLOBAL.dbf; in combination with memo-file: LANGUAGE_GLOBAL.fpt
Multi language table
Index:	1 def_lng on field(s) upper(def_lng)

 

No	Fieldname	Type	Length	Decimals	Description
1	DEF_LNG	C	150	0	Default text from product or category information
2	LANGUAGES	M	4	0

23 Structure of Database Table: LASER.dbf
List of available lasers and ID-codes
Index:	1 laserid on field(s) laserid

 

No	Fieldname	Type	Length	Decimals	Description
2	LASER	C	40	0	Description of laser
1	LASERID	C	2	0	Laser ID
3	LASERPORT	C	40	0	Output Port of laser (only LMI)
5	LASERTYPE	N	2	0	Brand of laser
4	PRINTER	C	100	0	Brand of output-device

24 Structure of Database Table: LASERSET.dbf
Contains settings, properties per laser-engraver
Index:	1 prtlasid on field(s) prtsetid + laserid

 

No	Fieldname	Type	Length	Decimals	Description
8	LASERFILE	C	100	0	lasersettings file
1	LASERID	C	2	0	Laser ID
2	PRTSETID	C	2	0	Refers to PrintSet table
3	R_POWER	N	3	0	engraving Power for raster
4	R_SPEED	N	3	0	engraving Speed for raster
5	V_POWER	N	3	0	engraving Power for cutting
7	V_PULSE	N	3	0	Perforation frequency. Must be >0
6	V_SPEED	N	3	0	engraving Speed for cutting

25 Structure of Database Table: MOUNT.dbf
Mount options
Index:	1 mountid on field(s) mountid

 

No	Fieldname	Type	Length	Decimals	Description
2	MOUNT	C	50	0	Mount description
1	MOUNTID	C	2	0	Mount ID

26 Structure of Database Table: NOTES.dbf; in combination with memo-file: NOTES.fpt
Table with pre-defined notes. Only for SOSET typeset Quick
Index:	1 noteid on field(s) noteid + language

 

No	Fieldname	Type	Length	Decimals	Description
3	DESCR	C	40	0	Quick only! Note text
2	LANGUAGE	C	3	0	Quick only!Language code
4	NOTE	M	10	0	Quick only!Note description
1	NOTEID	C	2	0	Quick only!Note ID

27 Structure of Database Table: ORDITEM.dbf
Table with Order items
Index:	1 ordoi on field(s) orderno 2 orditmoi on field(s) orderno + itemno 3 ordaccid on field(s) orderno + substr(str(val(accountid) + 10000000000, 11, 0), 2, 10) 4 account1 on field(s) substr(str(val(accountid) + 10000000000, 11, 0), 2, 10) + dtos(orderdate) + custid 5 prodgrp1 on field(s) prodgrpid + dtos(orderdate) + custid 6 account2 on field(s) substr(str(val(accountid) + 10000000000, 11, 0), 2, 10) + dtos(shipdate) + custid 7 prodgrp2 on field(s) prodgrpid + dtos(shipdate) + custid 8 account3 on field(s) substr(str(val(accountid) + 10000000000, 11, 0), 2, 10) + custid 9 prodgrp3 on field(s) prodgrpid + custid 10 remakor on field(s) dtos(orderdate) + remaketype 11 boxno on field(s) boxno + custid + orderno + itemno 12 desc2 on field(s) upper(desc2) + str(99999999 - val(dtos(orderdate))) + orderno

 

No	Fieldname	Type	Length	Decimals	Description
16	ACCOUNTID	C	10	0	GL-account-id-number
30	ARCHIVED	L	1	0	True or False / Yes or No
27	ATTACHMENT	L	1	0	True or False / Yes or No
4	BOXNO	C	6	0	Shipping-box-number
23	COLORID	C	2	0	Color ID
26	CUSCUSGRP	C	10	0	customergroupID of customer
25	CUSTGRPID	C	10	0	custgrpID of product belonging to a non default customergrp
3	CUSTID	C	6	0	Customer ID number
37	DATEIDP	C	5	0	Date Identifier for special accounts only
14	DESC1	C	30	0	Description 1
15	DESC2	C	30	0	Description 2
9	DISCOUNT1	N	2	0	Discount 1
10	DISCOUNT2	N	2	0	Discount 2
11	DISCOUNT3	N	2	0	Quantity Discount
31	FOR_PRICE	N	10	2	Foreign price
21	FREIGHT	L	1	0	True or False / Yes or No
2	ITEMNO	C	3	0	Item no
36	LINKTO	C	12	0	Contains the the two itemno's the item is linked to; use with pad change
28	LOCALPROD	L	1	0	True or False / Yes or No
24	MOUNTID	C	2	0	Mount type, refers to Mount table
6	ORDERDATE	D	8	0	Order date
1	ORDERNO	C	8	0	Order-number
32	PACKCOST	L	1	0	True or False / Yes or No
35	PADCHANGE	L	1	0	Pad change; TRUE when order item is used for pad change
17	PRODGRPID	C	2	0	Product group ID
5	PRODID	C	12	0	Product code, refers to Product table
8	QUANTITY	N	10	0	Quantity ordered
33	REMAKETYPE	C	2	0	Remake type
12	SALEPRICE	N	10	2	NOT USED
13	SALESTAX	N	2	0	NOT USED
19	SHIPBOX	C	6	0	NOT USED
7	SHIPDATE	D	8	0	Shipment date
18	STATISID	C	10	0	NOT USED
22	STATUS	N	2	0	Used for partly in box status (19)
38	STOCKTYPE	N	2	0	0=real inventoryproduct (cannot be typeset!) 1=real typeset 2=inventoryproduct on website, production via typeset 3=inventoryproduct on website, production via typeset from logo
29	TAX	L	1	0	True or False / Yes or No
34	UNITPRICE	N	15	7	Unitprice of product
20	WEIGHT	N	10	0	Weight of product

28 Structure of Database Table: ORDMAIN.dbf; in combination with memo-file: ORDMAIN.fpt
Table with order headers. (Only one per order)
Index:	1 ordmain on field(s) orderno 2 invno1 on field(s) invno + orderno 3 invno2 on field(s) invno + ordstatus + str(ordertype, 2, 0) + str(frist, 1, 0) + str(invoiceto, 1, 0) + invcustid + custid 4 invrun1 on field(s) invrunno + invno + ordstatus + str(ordertype, 2, 0) + str(frist, 1, 0) + str(invoiceto, 1, 0) + invcustid + custid 5 custidom on field(s) custid + str(99999999 - val(dtos(orderdate))) + orderno 6 ordstid on field(s) ordstatus + shipperid + custid + str(shipmentto, 1, 0) + shpaddrid 7 ordcust on field(s) ordstatus + custid + dtos(shipdate) 8 ordcust2 on field(s) ordstatus + custid + str(ordertype, 2, 0) + str(frist, 1, 0) + str(invoiceto, 1, 0) + invcustid 9 stattype on field(s) ordstatus + str(ordertype, 2, 0) + str(frist, 1, 0) + str(invoiceto,1, 0) + invcustid + custid 10 ordref1 on field(s) upper(ref1) 11 shipdate on field(s) dtos(shipdate) 12 downpay on field(s) paytypeid + orderno 13 orddate on field(s) dtos(orderdate) 14 export on field(s) exportchar + shpaddrid 15 custdate on field(s) custid + dtos(orderdate) + orderno 16 custord on field(s) custid + orderno

 

No	Fieldname	Type	Length	Decimals	Description
51	ARCHIVED	L	1	0	True or False / Yes or No
35	ARCHIVELOC	C	12	0	Archive location
58	ASNNO	C	30	0	Advanced shipping notice number
72	AUTOPUR	L	1	0	preparation of purchase via SOSET-purchase of products from sales-order
29	BILLSTATUS	C	2	0	0: Default;1: Ready to invoice; 2: Invoiced
27	BILLTO	C	6	0	DO NOT USE only for backwards compatibility
67	CLAIMID	C	3	0	Claim identifier refers to Reclaim-table
39	COMPANYID	C	6	0	Comapny ID
24	CONTACT	C	30	0	NOT USED
52	CUR2DEFAUL	L	1	0	True or False / Yes or No
53	CURRENCYID	N	3	0	Currency ID
2	CUSTID	C	6	0	Customer ID number
63	CUS_DEPAR	C	30	0	Customer department
61	CUS_ORDNO	C	30	0	Customer orderno
62	CUS_PRODCD	C	30	0	Customer product code
65	CUS_PURCH	C	30	0	Customer purchased by
64	CUS_WAREHS	C	30	0	Customer warehouse ID
44	DOWNPAY	L	1	0	True or False / Yes or No
46	DOWNPAYVAL	N	10	2	DO NOT USE only for backwards compatibility
48	EDITDATE	D	8	0	Last edit date
49	EDITTIME	C	10	0	Last edit time
3	EMPLOYEEID	C	6	0	Employee ID
50	EXPORTCHAR	C	1	0	TRUE if order has been exported; FALSE otherwise
11	FREIGHT	N	10	2	Charge for freight cost
47	FRIST	N	1	0	For internal use 0: No frist;1: frist
70	HISTORY	M	4	0	History
14	INFOEXTERN	M	4	0	External info
15	INFOINTERN	M	4	0	Internal info
26	INVADDRES	C	6	0	NOT USED
33	INVCUSTID	C	6	0	CustomerID who receives the invoice
22	INVDATE	D	8	0	Invoice date
43	INVFREQ	N	2	0	Invoice frequency
21	INVNO	C	6	0	Invoice number
32	INVOICETO	N	1	0	0: invoice to current customer;1: inv to other customer;2: inv to spec address
69	INVPERCUST	L	1	0	Splitted invoices during batch-invoicing
38	INVRUNNO	C	6	0	Invoice runnumber
57	LABELNO	C	6	0	Labelno generated during shipmentrun
19	LINKPURCH	C	15	0	DO NOT USE only for backwards compatibility
18	LINKSALES	C	10	0	DO NOT USE only for backwards compatibility
23	NETTOTAL	N	10	2	Net total
60	NOMAIL	L	1	0	Is product PTT "belstuk"
71	NOSHPORDER	L	1	0	TRUE; order must be excluded from shipmentrun
56	NOTAX	L	1	0	True or False / Yes or No
34	NO_PRICE	L	1	0	True or False / Yes or No
4	ORDERDATE	D	8	0	Order date
1	ORDERNO	C	8	0	Order-number
13	ORDERTYPE	N	2	0	0, 1: batch invoicing; 2, 3: direct inv;4, 5, 6: shipment inv;7, 8: cash order
28	ORDSTATUS	C	2	0	Order status
9	ORG_SHIPID	C	2	0	Original shipperid (before shipment run)
45	PAYTYPEID	C	2	0	Payment type ID
55	PER	N	8	0	Per value of foreign currency
66	PROOFPRINT	L	1	0	Automatic generation of proof. True or False / Yes or No
36	QUALCHECK	L	1	0	True or False / Yes or No
54	RATE	N	10	6	Rate of foreign currency
16	REF1	C	40	0	Reference 1
17	REF2	C	40	0	Reference 2
31	RUSH	N	1	0	Rush code: 0: No rush; 1: Rush; 2: Rush 48h; 3: Rush 24h
12	SALESMANID	C	10	0	Salesman-number, refers to User-table
5	SHIPADDRES	C	6	0	NOT USED
6	SHIPDATE	D	8	0	Shipment date
59	SHIPMENTNO	C	8	0	NOT USED
10	SHIPMENTTO	N	1	0	0: Mail address; 1: Main address; 2: Mail address other customer; 3: Main address other customer; 4: Special shipaddress
7	SHIPPERID	C	2	0	ShipperID (Way of shipment)
42	SHPADDRID	C	19	0	ID linked to shpaddr.dbf
8	SHPCUSTID	C	6	0	Customer ID of shipment
41	SHPTERMID	C	2	0	Delivery termID
30	STATEMENT	L	1	0	True or False / Yes or No
74	TAXRATE1	N	5	2	fixed taxrate after invoicing
75	TAXRATE2	N	5	2	fixed taxrate after invoicing
76	TAXRATE3	N	5	2	fixed taxrate after invoicing
40	TERMID	C	2	0	Payment/delivery term ID (refers to Terms table)
20	TERMS	C	40	0	DO NOT USE only for backwards compatibility
68	TIME_ENTER	C	10	0	Time order has been entered
25	TOTALWEIGH	N	10	0	DO NOT USE only for backwards compatibility
37	TRACKNO	C	30	0	Tracking no assigned during shipmentrun
73	WWWORDER	L	1	0	Web order (TRUE if order is entered via the web)

29 Structure of Database Table: PAGE.dbf
Page information, during a PageWizard routine SOSET stores page-layout-specs in this table
Index:	1 pageno on field(s) pageno 2 pagordno on field(s) orderno + pageno

 

No	Fieldname	Type	Length	Decimals	Description
5	DESCRIPT	L	1	0	True or False / Yes or No
6	LASERCUT	L	1	0	True or False / Yes or No
8	NUMBER	C	6	0	Numbering number: 0: No numbering
7	NUMBERING	L	1	0	True or False / Yes or No
10	ORDERNO	C	8	0	Order-number
11	PAGENO	C	11	0	Page number
1	PARTNO	C	3	0	Part number
9	PRINTSETID	C	2	0	Product category, refers to PrintSet table
4	ROTATED	L	1	0	True or False / Yes or No
2	XPOS	N	6	0	X position
3	YPOS	N	6	0	Y position

30 Structure of Database Table: PAYMENT.dbf
Payments are stored in this table
Index:	1 orddate on field(s) dtos(paydate) + paytypeid 2 ordno on field(s) orderno + paytypeid 3 paytype on field(s) paytypeid + dtos(paydate) 4 date on field(s) dtos(paydate) 5 ccno on field(s) ccno

 

No	Fieldname	Type	Length	Decimals	Description
7	BALANCE	N	10	2	DO NOT USE only for backwards compatibility
17	CARDID	C	10	0	CVV code (from backside of card)
18	CCDD	C	5	0	Card's expiration date
14	CCID	C	2	0	Credit card type
15	CCNAME	C	25	0	Cardholders name
16	CCNO	C	30	0	Credit card number
10	CURRENCYID	C	2	0	Currency Identifier
1	CUSTID	C	6	0	Customer ID number
8	DESCRIPT	C	35	0	Description of payment
13	FOR_VAL	N	10	2	Total payment in specified foreign value
9	INVOICENO	C	6	0	Invoice Number
2	ORDERNO	C	8	0	Order-number
3	PAYDATE	D	8	0	Day of payment
6	PAYTIME	C	10	0	payment Time registration
5	PAYTYPEID	C	2	0	Way of payment; refers to paytypes table
11	PER	N	8	0	unit of currency
12	RATE	N	10	6	Rate of currency at moment of payment
4	VALUEPAID	N	10	2	Amount paid in company default currency

31 Structure of Database Table: PAYTYPES.dbf
Ways of payment
Index:	1 paytypid on field(s) paytypeid

 

No	Fieldname	Type	Length	Decimals	Description
3	CASH	L	1	0	switch for is this way of payment icash register for cash-control?
2	PAYTYPE	C	30	0	Description of way of payment
1	PAYTYPEID	C	2	0	Way of Payment ID
5	TYPE	N	2	0	1=force credit card ;2=reserved for special; 3=no credit card
4	USEFORWEB	L	1	0	If true the option is shown at web-site
6	WEBLOGO	C	25	0	Image shown on web-site

32 Structure of Database Table: PRINTSET.dbf
Contains different production-categories. This table controls output and sort-order by stamp-category
Index:	1 prtsetid on field(s) prtsetid 2 prtgrpid on field(s) prtgrpid

 

No	Fieldname	Type	Length	Decimals	Description
96	ADV_CROP	L	1	0	1:Print advanced cropmarks; 0: No printing of advanced cropmarks
97	ADV_WEBTP	L	1	0	Advanced typesetoptions on website
100	BGIMG	C	100	0	Background image for business-cards, nameplates etc.
49	CENTERMOLD	L	1	0	Center mold-print on layout True or False / Yes or No
103	CUTGAP	N	4	0	Gap between laser-cutting-lines (will keep corners)
48	CUTMARKS	L	1	0	Print cutting marks True or False / Yes or No
98	CUTTINGID	N	1	0	Lasercuttingtype: 0=no cutting 1=cutting with product-sizes 2=straight contourcutting (size=max size of text/logo) 3=advanced cutting; will cut out exactly around logo and text.
50	CUT_DIST	N	6	0	Distance from cutting-line to image
53	DELTAX	N	6	0	Movement on X-axis if Field FixedPos=True
54	DELTAY	N	6	0	Movement on Y-axis if Field FixedPos=True
16	D_POWER0	N	3	0	DO NOT USE only for backwards compatibility
17	D_POWER1	N	3	0	DO NOT USE only for backwards compatibility
26	D_POWER10	N	3	0	DO NOT USE only for backwards compatibility
27	D_POWER11	N	3	0	DO NOT USE only for backwards compatibility
28	D_POWER12	N	3	0	DO NOT USE only for backwards compatibility
29	D_POWER13	N	3	0	DO NOT USE only for backwards compatibility
30	D_POWER14	N	3	0	DO NOT USE only for backwards compatibility
31	D_POWER15	N	3	0	DO NOT USE only for backwards compatibility
32	D_POWER16	N	3	0	DO NOT USE only for backwards compatibility
33	D_POWER17	N	3	0	DO NOT USE only for backwards compatibility
34	D_POWER18	N	3	0	DO NOT USE only for backwards compatibility
35	D_POWER19	N	3	0	DO NOT USE only for backwards compatibility
18	D_POWER2	N	3	0	DO NOT USE only for backwards compatibility
36	D_POWER20	N	3	0	DO NOT USE only for backwards compatibility
37	D_POWER21	N	3	0	DO NOT USE only for backwards compatibility
38	D_POWER22	N	3	0	DO NOT USE only for backwards compatibility
39	D_POWER23	N	3	0	DO NOT USE only for backwards compatibility
40	D_POWER24	N	3	0	DO NOT USE only for backwards compatibility
41	D_POWER25	N	3	0	DO NOT USE only for backwards compatibility
19	D_POWER3	N	3	0	DO NOT USE only for backwards compatibility
20	D_POWER4	N	3	0	DO NOT USE only for backwards compatibility
21	D_POWER5	N	3	0	DO NOT USE only for backwards compatibility
22	D_POWER6	N	3	0	DO NOT USE only for backwards compatibility
23	D_POWER7	N	3	0	DO NOT USE only for backwards compatibility
24	D_POWER8	N	3	0	DO NOT USE only for backwards compatibility
25	D_POWER9	N	3	0	DO NOT USE only for backwards compatibility
43	FIXEDPOS	L	1	0	Switch for fixed positioning instead of automatic.
55	MARGIN	N	6	0	margin on layout (4 sides)
42	MAXDIST	N	2	0	Steps for laser-engraving
57	MOLDHEIGHT	N	6	0	Height of Mold (UseMold MUST be True!)
56	MOLDWIDTH	N	6	0	Width of Mold (UseMold MUST be True!)
91	PIXELS	N	3	0	For seal-engraving: determines difference between die and counter
46	PRINTMOLD	L	1	0	Switch for printing outlines of mold on output
102	PRTGRPID	C	25	0	To enable finishing-options per product. Eg: TypeID [NAMEPLATE] 4 holes etc.
2	PRTSET	C	50	0	description
1	PRTSETID	C	3	0	PrintSet ID production category idientifier
3	R_POWER0	N	3	0	DO NOT USE only for backwards compatibility
4	R_POWER1	N	3	0	DO NOT USE only for backwards compatibility
13	R_POWER10	N	3	0	DO NOT USE only for backwards compatibility
14	R_POWER11	N	3	0	DO NOT USE only for backwards compatibility
15	R_POWER12	N	3	0	DO NOT USE only for backwards compatibility
5	R_POWER2	N	3	0	DO NOT USE only for backwards compatibility
6	R_POWER3	N	3	0	DO NOT USE only for backwards compatibility
7	R_POWER4	N	3	0	DO NOT USE only for backwards compatibility
8	R_POWER5	N	3	0	DO NOT USE only for backwards compatibility
9	R_POWER6	N	3	0	DO NOT USE only for backwards compatibility
10	R_POWER7	N	3	0	DO NOT USE only for backwards compatibility
11	R_POWER8	N	3	0	DO NOT USE only for backwards compatibility
12	R_POWER9	N	3	0	DO NOT USE only for backwards compatibility
92	SCALE	N	3	0	DO NOT USE only for backwards compatibility
93	SCALEX	N	3	0	Scale percentage for ouput
94	SCALEY	N	3	0	Scale percentage for ouput
58	SEPARATOR	N	6	0	Space between products on layout
51	STARTX	N	6	0	Start printing X-position if Field FixedPos=True
52	STARTY	N	6	0	Start printing Y-position if Field FixedPos=True
99	TEXTRGB	N	16	0	Text-colour (in RGB) e.g. for nameplates white with blue engraving material
44	TITLE	L	1	0	Print tile on output True or False / Yes or No
101	TYPEID	N	3	0	0=stamp 1=seal 2=sign 3=business card
45	USEMOLD	L	1	0	Use the mold as specified True or False / Yes or No
95	VULCANISE	L	1	0	True or False / Yes or No
47	XCOUNTER	N	3	0	DO NOT USE only for backwards compatibility
59	XPOS1	N	6	0	Position of separator line on screen to simplify layout
60	XPOS2	N	6	0	Position of separator line on screen to simplify layout
61	XPOS3	N	6	0	Position of separator line on screen to simplify layout
62	XPOS4	N	6	0	Position of separator line on screen to simplify layout
63	XPOS5	N	6	0	Position of separator line on screen to simplify layout
64	XPOS6	N	6	0	Position of separator line on screen to simplify layout
65	XPOS7	N	6	0	Position of separator line on screen to simplify layout
66	XPOS8	N	6	0	Position of separator line on screen to simplify layout
75	XWIDTH1	N	6	0	Space between sheets in multiple layout
76	XWIDTH2	N	6	0	Space between sheets in multiple layout
77	XWIDTH3	N	6	0	Space between sheets in multiple layout
78	XWIDTH4	N	6	0	Space between sheets in multiple layout
79	XWIDTH5	N	6	0	Space between sheets in multiple layout
80	XWIDTH6	N	6	0	Space between sheets in multiple layout
81	XWIDTH7	N	6	0	Space between sheets in multiple layout
82	XWIDTH8	N	6	0	Space between sheets in multiple layout
67	YPOS1	N	6	0	Position of separator line on screen to simplify layout
68	YPOS2	N	6	0	Position of separator line on screen to simplify layout
69	YPOS3	N	6	0	Position of separator line on screen to simplify layout
70	YPOS4	N	6	0	Position of separator line on screen to simplify layout
71	YPOS5	N	6	0	Position of separator line on screen to simplify layout
72	YPOS6	N	6	0	Position of separator line on screen to simplify layout
73	YPOS7	N	6	0	Position of separator line on screen to simplify layout
74	YPOS8	N	6	0	Position of separator line on screen to simplify layout
83	YWIDTH1	N	6	0	Space between sheets in multiple layout
84	YWIDTH2	N	6	0	Space between sheets in multiple layout
85	YWIDTH3	N	6	0	Space between sheets in multiple layout
86	YWIDTH4	N	6	0	Space between sheets in multiple layout
87	YWIDTH5	N	6	0	Space between sheets in multiple layout
88	YWIDTH6	N	6	0	Space between sheets in multiple layout
89	YWIDTH7	N	6	0	Space between sheets in multiple layout
90	YWIDTH8	N	6	0	Space between sheets in multiple layout

33 Structure of Database Table: PRODGRP.dbf
Product groups, refer to Accounts-table
Index:	1 prdgrpid on field(s) prodgrpid

 

No	Fieldname	Type	Length	Decimals	Description
2	PRODGRP	C	20	0	Product category description
1	PRODGRPID	C	2	0	Product category ID

34 Structure of Database Table: PRODUCT.dbf; in combination with memo-file: PRODUCT.fpt
This table contains the information of all products you want to do Typesetting
Index:	1 prodid on field(s) upper(prodid) 2 custprod on field(s) custgrpid + upper(prodid) 3 prodsrch on field(s) searchkey 4 prodbar on field(s) barcode 5 cat1 on field(s) cat1 + prodid + str(cut_width, 6) 6 cat2 on field(s) cat2 + prodid + str(cut_width, 6) 7 cat3 on field(s) cat3 + prodid + str(cut_width, 6) 8 cat4 on field(s) cat4 + prodid + str(cut_width, 6) 9 cat5 on field(s) cat5 + prodid + str(cut_width, 6) 10 purchid on field(s) upper(purchaseid) 11 barsss on field(s) barsss 12 cusprod on field(s) cusprodid 13 catpage on field(s) cat_page + prodid 14 package on field(s) upper(packageset) + prodid

 

No	Fieldname	Type	Length	Decimals	Description
24	ACCOUNTID	C	10	0	GL-account-id-number
36	BANDHEIGHT	N	6	0	heigth of band-area
33	BANDUPPERX	N	6	0	X-co-ordinate of band-area
34	BANDUPPERY	N	6	0	Y-co-ordinate of band-area
35	BANDWIDTH	N	6	0	width of band-area
32	BAND_ID	N	1	0	0=no band; 1-date-band
3	BARCODE	C	20	0	Sales Barcode
78	BARSSS	C	5	0	Contains the internal barcode number; for generating quick barcodes
72	CAT1	C	20	0	Product category, refers to Prodgrp table
73	CAT2	C	20	0	Product category, refers to Prodgrp table
74	CAT3	C	20	0	Product category, refers to Prodgrp table
75	CAT4	C	20	0	Product category, refers to Prodgrp table
76	CAT5	C	20	0	Product category, refers to Prodgrp table
41	CAT_CODE	C	20	0	Optional. Refers to code in Catalog-table
40	CAT_PAGE	C	5	0	Optional. Refers to page in Catalog
23	COLOUR	L	1	0	Colour-inkpad switch (this activates colour dialog)
82	COPYRIGHT	C	30	0	Copyright notice of product image
66	CURRENCY2	N	3	0	Currency identifier for field UnitPrice2; ref to currency table
67	CURRENCY3	N	3	0	Currency identifier for field UnitPrice3; ref to currency table
68	CURRENCY4	N	3	0	Currency identifier for field UnitPrice4; ref to currency table
69	CURRENCY5	N	3	0	Currency identifier for field UnitPrice5; ref to currency table
81	CUSPRODID	C	30	0	Contains the customer productid
37	CUSTGRPID	C	10	0	ref to CustGrp table. If specified, product only for this CustGrp
39	CUT_HEIGHT	N	6	0	Gros height of the product (supplier sizes)
38	CUT_WIDTH	N	6	0	Gros width of the product (supplier sizes)
11	DISCONTINU	L	1	0	True or False / Yes or No
42	DISCOUNT	L	1	0	True or False / Yes or No
29	FIRSTORDER	D	8	0	First date this product has been ordered
26	FREIGHT	L	1	0	Switch for automatic charge for freight-costs
28	HISTORY	M	4	0	Historical info about changes etc.
80	IMPRIMGLO	C	150	0	Contains the product impression
27	LASTORDER	D	8	0	Last date this product has been ordered
31	MOUNT	L	1	0	Mount-options? True or False / Yes or No
84	MULTICOLOR	L	1	0	triggers multi-color option for web-typeset
70	NOMAIL	L	1	0	Handle as NON PO-box item True or False / Yes or No
83	PACKAGESET	C	25	0	Contains ProdID of package, as being part of that package
71	PACKCOST	L	1	0	Charge for packaging costs True or False / Yes or No
65	PRICELEVEL	C	10	0	Pricelevel optional to query pricelevels
7	PRINTSETID	C	2	0	Product category, refers to PrintSet table
21	PRODDEPTH	N	5	0	Depth of the product (Future Calculating size of package)
8	PRODDISCOU	C	2	0	DO NOT USE only for backwards compatibility.
20	PRODHEIGHT	N	6	0	DO NOT USE only for backwards compatibility
1	PRODID	C	12	0	Product code, refers to Product table
79	PRODIMGLO	C	150	0	Contains the product image
4	PRODNAME	C	30	0	Product description fixed; canNOT be edited during order entry
5	PRODNAME2	C	30	0	Product description can be edited during order entry
22	PRODSHAPE	N	1	0	Shape of impression: 0=straight; 1=round, 2=oval
18	PRODWEIGHT	N	5	0	Net weight of the product for automatic shipping charge
19	PRODWIDTH	N	6	0	DO NOT USE only for backwards compatibility
63	PRTGRPID	C	2	0	Product category. Refers to PrintSet-table for technical reasons
10	PURCHASEID	C	12	0	Refers to Pur_prod table with vendor-product information
30	QDISCOUNT	L	1	0	Switch to take quantity discount from System-table
77	REALQUAN	N	10	0	Real quantity; quantity will be multiplied with realquan in typeset
43	SALES_YR0	N	12	2	Total of net-sales of this product in year 0 (e.g. 2000;2010)
44	SALES_YR1	N	12	2	Total of net-sales of this product in year 1
45	SALES_YR2	N	12	2	Total of net-sales of this product in year 2
46	SALES_YR3	N	12	2	Total of net-sales of this product in year 3
47	SALES_YR4	N	12	2	Total of net-sales of this product in year 4
48	SALES_YR5	N	12	2	Total of net-sales of this product in year 5
49	SALES_YR6	N	12	2	Total of net-sales of this product in year 6
50	SALES_YR7	N	12	2	Total of net-sales of this product in year 7
51	SALES_YR8	N	12	2	Total of net-sales of this product in year 8
52	SALES_YR9	N	12	2	Total of net-sales of this product in year 9
6	SCREENINFO	C	30	0	Additional field for some extra info. Not in orderscreen visual
2	SEARCHKEY	C	12	0	Searchtext
25	STATISTID	C	10	0	Can be optionally used
85	STOCKTYPE	N	2	0	0=real inventoryproduct (cannot be typeset!) 1=real typeset 2=inventoryproduct on website, production via typeset 3=inventoryproduct on website, production via typeset from logo
9	SUPPLIERID	C	10	0	DO NOT USE only for backwards compatibility. Instead use same field in PUR_PROD table.
64	TAX	L	1	0	Taxable product? True or False / Yes or No
17	UNIT	C	10	0	NOT USED
12	UNITPRICE1	N	10	2	Gros Price 1; always in company default currency
13	UNITPRICE2	N	10	2	Gros Price 2; in currency as specified in field Currency2
14	UNITPRICE3	N	10	2	Gros Price 3; in currency as specified in field Currency3
15	UNITPRICE4	N	10	2	Gros Price 4; in currency as specified in field Currency4
16	UNITPRICE5	N	10	2	Gros Price 5; in currency as specified in field Currency5
53	UNITS_YR0	N	12	0	Total of units of this product in year 0
54	UNITS_YR1	N	12	0	Total of units of this product in year 1
55	UNITS_YR2	N	12	0	Total of units of this product in year 2
56	UNITS_YR3	N	12	0	Total of units of this product in year 3
57	UNITS_YR4	N	12	0	Total of units of this product in year 4
58	UNITS_YR5	N	12	0	Total of units of this product in year 5
59	UNITS_YR6	N	12	0	Total of units of this product in year 6
60	UNITS_YR7	N	12	0	Total of units of this product in year 7
61	UNITS_YR8	N	12	0	Total of units of this product in year 8
62	UNITS_YR9	N	12	0	Total of units of this product in year 9

35 Structure of Database Table: PUR_ITEM.dbf
Purchase orderitem table
Index:	1 orderno on field(s) orderno + itemno

 

No	Fieldname	Type	Length	Decimals	Description
14	DELIVERED	N	10	0	Quantity delivered
7	DESC_1	C	30	0	Description 1
8	DESC_2	C	30	0	Description 2
11	FACTOR1	N	4	2	NOT IN USE ANYMORE (exchange rate)
12	FACTOR2	N	6	4	Discount factor
19	FOR_PRICE	N	10	2	Price in foreign currency
4	INVOICENO	C	6	0	Invoice number
2	ITEMNO	C	3	0	Item-number
22	LINK_SALES	C	11	0	ProdId of sales-Product table
16	L_STATUS	N	2	0	Delivery status
20	NO_BARCODE	N	3	0	Amount of bar-code labels for warehouse
1	ORDERNO	C	8	0	OrderID
9	PRICEC	C	30	0	Price description
5	PRODID	C	12	0	Purchase productID
6	QUANTITY	N	10	0	Quantity ordered
21	REMARKSID	C	2	0	ISO-9002 related registration/complaints
15	SALES_ORD	N	10	0	Link to sales order
13	STATUS	C	2	0	Item status
3	SUPPLIERID	C	10	0	SupplierID
10	UNITPRICE1	N	15	7	Price in basic currency
18	UNITS	C	10	0	Unit description
17	WEIGHT	N	8	0	Weight of item

36 Structure of Database Table: PUR_MAIN.dbf; in combination with memo-file: PUR_MAIN.fpt
Purchase order header table
Index:	1 orderno on field(s) orderno 2 dstatus on field(s) lstaat + orderno 3 ref1 on field(s) ref_1 4 supplier on field(s) supplierid 5 orderdd on field(s) dtos(orderdate)

 

No	Fieldname	Type	Length	Decimals	Description
21	CUR2DEFAUL	L	1	0	Foreign or basic currency
22	CURRENCYID	C	3	0	CurrencyID
7	DELIV_DATE	D	8	0	Delivery date
5	EMPLOYEEID	C	2	0	EmployeeID
15	FSTAAT	C	2	0	Invoice status
18	INFO_1	M	4	0	Product-specific information for buyer
19	INFO_2	M	4	0	Product-specific information for buyer
3	INVOICENO	C	6	0	InvoiceID
13	LINK_PURCH	C	10	0	Link to other purchase order
12	LINK_SALES	C	10	0	Link to sales order
14	LSTAAT	C	2	0	Order status
16	MED_1	C	30	0	Product-specific Information for vendor
17	MED_2	C	30	0	Product-specific Information for vendor
6	ORDERDATE	D	8	0	Order date
1	ORDERNO	C	8	0	OrderID
20	PAYMENT	C	30	0	Way of payment
24	PER	N	8	0	Currency Per
23	RATE	N	10	6	Currency Rate
9	REF_1	C	40	0	Reference 1
10	REF_2	C	40	0	Reference 2
4	RUSH	N	1	0	RushID
11	SEARCHREF	C	6	0	Key to search by reference
8	SHIPPERID	C	2	0	ShipperID
2	SUPPLIERID	C	10	0	SupplierID

37 Structure of Database Table: PUR_PROD.dbf; in combination with memo-file: PUR_PROD.fpt
Purchase product table with vendor and product details
Index:	1 purchid on field(s) upper(purchaseid) 2 search on field(s) searchkey 3 supplid on field(s) supplierid + purchaseid 4 account on field(s) paccountid 5 vendpid on field(s) vendprodid 6 barcode on field(s) barcode

 

No	Fieldname	Type	Length	Decimals	Description
26	AUTO	L	1	0	True or False / Yes or No
40	BARCODE	C	20	0	Barcode of product
41	BAR_SALES	C	20	0	Barcode of sales product
51	BUY_YR0	N	12	0	Total of net-purchase of this product in year 0 (e.g. 2000; 2010)
52	BUY_YR1	N	12	0	Total of net-purchase of this product in year 1
53	BUY_YR2	N	12	0	Total of net-purchase of this product in year 2
54	BUY_YR3	N	12	0	Total of net-purchase of this product in year 3
55	BUY_YR4	N	12	0	Total of net-purchase of this product in year 4
56	BUY_YR5	N	12	0	Total of net-purchase of this product in year 5
57	BUY_YR6	N	12	0	Total of net-purchase of this product in year 6
58	BUY_YR7	N	12	0	Total of net-purchase of this product in year 7
59	BUY_YR8	N	12	0	Total of net-purchase of this product in year 8
60	BUY_YR9	N	12	0	Total of net-purchase of this product in year 9
33	COLOUR	L	1	0	True or False / Yes or No
71	CURRENCY2	N	3	0	Currency identifier for field UnitPrice2; ref to currency table
72	CURRENCY3	N	3	0	Currency identifier for field UnitPrice3; ref to currency table
73	CURRENCY4	N	3	0	Currency identifier for field UnitPrice4; ref to currency table
74	CURRENCY5	N	3	0	Currency identifier for field UnitPrice5; ref to currency table
43	CYCLECOUNT	D	8	0	Last date of counting the stock
23	DATE	D	8	0	Record creation-date
47	DISCONTINU	L	1	0	Product still available? True or False / Yes or No
18	FACTOR1	N	5	3	NOT IN USE ANYMORE (exchange rate)
19	FACTOR2	N	5	3	Discount
48	FIRSTORDER	D	8	0	Date when product was first ordered
50	HISTORY	M	4	0	History
27	INSTOCK	N	10	0	Quantity in stock
49	LASTORDER	D	8	0	Date when product was last ordered
20	MEMO_1	C	30	0	Info
21	MEMO_2	C	30	0	Info
42	METHOD	C	20	0	How to take inventory
31	MINPURCHAS	N	10	0	Miniumum purchase quantity
17	NET	N	10	2	NOT IN USE ANYMORE (netto price)
6	NOTE1	C	30	0	Note
7	NOTE2	C	30	0	Note
76	OLDCYCLE	D	8	0	For temp-use with cycle-count report
8	OLDINV	C	8	0	Number of find fysical invoice
75	OLDSTOCK	N	10	0	For temp-use with cycle-count report
30	ONORDER	N	10	0	Quantity that is on order
45	PACCOUNTID	C	10	0	Account ID
10	PRICEC	C	30	0	Price description
11	PRICEN	N	10	2	NOT IN USE ANYMORE (netto price)
9	PRICE_DD	D	8	0	Date of price description
38	PRODDEPTH	N	10	0	Product depth
37	PRODHEIGHT	N	10	0	Product height
2	PRODNAME	C	30	0	Product Name
3	PRODNAME2	C	30	0	Product Name 2
39	PRODSHAPE	N	1	0	Product shape
35	PRODWEIGHT	N	10	0	Product weight
36	PRODWIDTH	N	10	0	Product width
46	PSTATISTID	C	10	0	Statist ID
1	PURCHASEID	C	12	0	ProductID
22	QUANTITY	N	10	0	Temp used for inventory calculation
29	REORDERLEV	N	10	0	Reorder level (Instock < reorderlevel needs updating of in stock
4	SEARCHKEY	C	12	0	SearchKey for product
25	STATUS	C	2	0	not in use
5	SUPPLIERID	C	10	0	supplier ID form vendor
34	UNIT	C	20	0	Each, Weight: grams etc
12	UNITPRICE1	N	10	2	Product price in bacis currency
13	UNITPRICE2	N	10	2	Product price in euro currency
14	UNITPRICE3	N	10	2	Product price in user defined currency
15	UNITPRICE4	N	10	2	Product price in user defined currency
16	UNITPRICE5	N	10	2	Product price in user defined currency
61	UNITS_YR0	N	12	0	Total of units of this product in year 0
62	UNITS_YR1	N	12	0	Total of units of this product in year 1
63	UNITS_YR2	N	12	0	Total of units of this product in year 2
64	UNITS_YR3	N	12	0	Total of units of this product in year 3
65	UNITS_YR4	N	12	0	Total of units of this product in year 4
66	UNITS_YR5	N	12	0	Total of units of this product in year 5
67	UNITS_YR6	N	12	0	Total of units of this product in year 6
68	UNITS_YR7	N	12	0	Total of units of this product in year 7
69	UNITS_YR8	N	12	0	Total of units of this product in year 8
70	UNITS_YR9	N	12	0	Total of units of this product in year 9
32	USER	C	6	0	SOSET UserId from User-table
24	VALUE	N	13	0	Temp used for inventory calculation
44	VENDPRODID	C	20	0	Product ID of vendor
28	WAREHOUSID	C	10	0	Warehouse ID

38 Structure of Database Table: QJOB.dbf; in combination with memo-file: QJOB.fpt
Temporary table with texts. Only for SOSET typeset Quick
Index:	1 qjobord on field(s) orderno + partno 2 zipcity on field(s) upper(zipcity) + upper(postal) 3 jobstat on field(s) statusid 4 usercorr on field(s) userid + dtos(date_in) + statusid 5 runno on field(s) runno 6 datein on field(s) dtos(date_in) 7 dateout on field(s) dtos(date_out) 8 incode on field(s) incode

 

No	Fieldname	Type	Length	Decimals	Description
50	ADDRESS	C	100	0	Address
15	ALIGN1	C	1	0	Alignment for line 1: 0: Left; 1: Center; 2: Right; 3: Justified
24	ALIGN10	C	1	0	Alignment for line 10: 0: Left; 1: Center; 2: Right; 3: Justified
75	ALIGN11	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
76	ALIGN12	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
77	ALIGN13	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
78	ALIGN14	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
79	ALIGN15	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
80	ALIGN16	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
81	ALIGN17	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
82	ALIGN18	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
83	ALIGN19	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
16	ALIGN2	C	1	0	Alignment for line 2 0: Left; 1: Center; 2: Right; 3: Justified
84	ALIGN20	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
85	ALIGN21	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
86	ALIGN22	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
87	ALIGN23	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
88	ALIGN24	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
89	ALIGN25	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
130	ALIGN26	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
131	ALIGN27	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
132	ALIGN28	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
133	ALIGN29	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
17	ALIGN3	C	1	0	Alignment for line 3 0: Left; 1: Center; 2: Right; 3: Justified
134	ALIGN30	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
135	ALIGN31	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
136	ALIGN32	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
137	ALIGN33	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
138	ALIGN34	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
139	ALIGN35	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
140	ALIGN36	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
141	ALIGN37	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
142	ALIGN38	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
143	ALIGN39	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
18	ALIGN4	C	1	0	Alignment for line 4 0: Left; 1: Center; 2: Right; 3: Justified
144	ALIGN40	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
145	ALIGN41	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
146	ALIGN42	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
147	ALIGN43	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
148	ALIGN44	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
149	ALIGN45	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
150	ALIGN46	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
151	ALIGN47	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
152	ALIGN48	C	1	0	Alignment for corresponding line : 0: Lft; 1: Cnt; 2: Rght; 3: Just
153	ALIGN49	C	1	0	Alignment for line 10: 0: Left; 1: Center; 2: Right; 3: Justified
19	ALIGN5	C	1	0	Alignment for line 5 0: Left; 1: Center; 2: Right; 3: Justified
154	ALIGN50	C	1	0	Alignment for line 10: 0: Left; 1: Center; 2: Right; 3: Justified
20	ALIGN6	C	1	0	Alignment for line 6 0: Left; 1: Center; 2: Right; 3: Justified
21	ALIGN7	C	1	0	Alignment for line 7 0: Left; 1: Center; 2: Right; 3: Justified
22	ALIGN8	C	1	0	Alignment for line 8: 0: Left; 1: Center; 2: Right; 3: Justified
23	ALIGN9	C	1	0	Alignment for line 9: 0: Left; 1: Center; 2: Right; 3: Justified
27	COLUMN	C	3	0	NOT USED
52	COUNTRY	C	100	0	Contry
4	DATE_IN	D	8	0	Date entered
6	DATE_OUT	D	8	0	Shipment date
58	DAYSIN	N	3	0	Number of days in (Shipment date - date entered)
180	EMAIL	C	30	0	E-mail address
11	EXAMPLEID	C	11	0	Example ID: OrderNo+PartNo of template
13	EXPAND	L	1	0	True or False / Yes or No
12	FRAME	L	1	0	True or False / Yes or No
55	HEIGHT	N	6	0	Height
57	HISTORY	M	4	0	History
59	INCODE	C	20	0	VoucherID
25	LANGUAGE	C	3	0	LanguageID
49	NAME	C	100	0	Name
5	NLINES	N	2	0	Number of lines
2	ORDERNO	C	8	0	Order-number
3	PARTNO	C	3	0	Part number
182	POSTAL	C	15	0	Postal code of ship-to address
10	PRINTSETID	C	2	0	Product category, refers to PrintSet table
53	PRODID	C	12	0	Product code, refers to Product table
28	QUANTITY	N	10	0	Quantity
56	REMAKETYPE	C	2	0	Remaketype ID
26	RUNNO	C	6	0	Runnumber
39	SEGMENT1	C	100	0	Text segment 1
48	SEGMENT10	C	100	0	Text segment 10
60	SEGMENT11	C	100	0	Text segment
61	SEGMENT12	C	100	0	Text segment
62	SEGMENT13	C	100	0	Text segment
63	SEGMENT14	C	100	0	Text segment
64	SEGMENT15	C	100	0	Text segment
65	SEGMENT16	C	100	0	Text segment
66	SEGMENT17	C	100	0	Text segment
67	SEGMENT18	C	100	0	Text segment
68	SEGMENT19	C	100	0	Text segment
40	SEGMENT2	C	100	0	Text segment 2
69	SEGMENT20	C	100	0	Text segment
70	SEGMENT21	C	100	0	Text segment
71	SEGMENT22	C	100	0	Text segment
72	SEGMENT23	C	100	0	Text segment
73	SEGMENT24	C	100	0	Text segment
74	SEGMENT25	C	100	0	Text segment
105	SEGMENT26	C	100	0	Text segment
106	SEGMENT27	C	100	0	Text segment
107	SEGMENT28	C	100	0	Text segment
108	SEGMENT29	C	100	0	Text segment
41	SEGMENT3	C	100	0	Text segment 3
109	SEGMENT30	C	100	0	Text segment
110	SEGMENT31	C	100	0	Text segment
111	SEGMENT32	C	100	0	Text segment
112	SEGMENT33	C	100	0	Text segment
113	SEGMENT34	C	100	0	Text segment
114	SEGMENT35	C	100	0	Text segment
115	SEGMENT36	C	100	0	Text segment
116	SEGMENT37	C	100	0	Text segment
117	SEGMENT38	C	100	0	Text segment
118	SEGMENT39	C	100	0	Text segment
42	SEGMENT4	C	100	0	Text segment 4
119	SEGMENT40	C	100	0	Text segment
120	SEGMENT41	C	100	0	Text segment
121	SEGMENT42	C	100	0	Text segment
122	SEGMENT43	C	100	0	Text segment
123	SEGMENT44	C	100	0	Text segment
124	SEGMENT45	C	100	0	Text segment
125	SEGMENT46	C	100	0	Text segment
126	SEGMENT47	C	100	0	Text segment
127	SEGMENT48	C	100	0	Text segment
128	SEGMENT49	C	100	0	Text segment
43	SEGMENT5	C	100	0	Text segment 5
129	SEGMENT50	C	100	0	Text segment
44	SEGMENT6	C	100	0	Text segment 6
45	SEGMENT7	C	100	0	Text segment 7
46	SEGMENT8	C	100	0	Text segment 8
47	SEGMENT9	C	100	0	Text segment 9
9	SHAPE	C	1	0	NOT USED
183	STATE	C	40	0	State of ship-to address
14	STATUSID	C	2	0	StatusID
1	TEMPLATE	C	6	0	Template name
7	TIME	N	8	0	NOT USED
8	USERID	C	2	0	User-number, refers to User-table
29	VALUE1	C	1	0	Font value for line 1: 0: Main font; 1: Sub font; 2; Regular font
38	VALUE10	C	1	0	Font value for line 10: 0: Main font; 1: Sub font; 2; Regular font
90	VALUE11	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
91	VALUE12	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
92	VALUE13	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
93	VALUE14	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
94	VALUE15	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
95	VALUE16	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
96	VALUE17	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
97	VALUE18	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
98	VALUE19	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
30	VALUE2	C	1	0	Font value for line 2: 0: Main font; 1: Sub font; 2; Regular font
99	VALUE20	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
100	VALUE21	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
101	VALUE22	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
102	VALUE23	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
103	VALUE24	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
104	VALUE25	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
155	VALUE26	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
156	VALUE27	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
157	VALUE28	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
158	VALUE29	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
31	VALUE3	C	1	0	Font value for line 3: 0: Main font; 1: Sub font; 2; Regular font
159	VALUE30	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
160	VALUE31	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
161	VALUE32	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
162	VALUE33	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
163	VALUE34	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
164	VALUE35	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
165	VALUE36	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
166	VALUE37	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
167	VALUE38	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
168	VALUE39	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
32	VALUE4	C	1	0	Font value for line 4: 0: Main font; 1: Sub font; 2; Regular font
169	VALUE40	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
170	VALUE41	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
171	VALUE42	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
172	VALUE43	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
173	VALUE44	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
174	VALUE45	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
175	VALUE46	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
176	VALUE47	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
177	VALUE48	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
178	VALUE49	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
33	VALUE5	C	1	0	Font value for line 5: 0: Main font; 1: Sub font; 2; Regular font
179	VALUE50	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
34	VALUE6	C	1	0	Font value for line 6: 0: Main font; 1: Sub font; 2; Regular font
35	VALUE7	C	1	0	Font value for line 7: 0: Main font; 1: Sub font; 2; Regular font
36	VALUE8	C	1	0	Font value for line 8: 0: Main font; 1: Sub font; 2; Regular font
37	VALUE9	C	1	0	Font value for line 9: 0: Main font; 1: Sub font; 2; Regular font
54	WIDTH	N	6	0	Width
181	WWWORDER	L	1	0	Weborder (TRUE if order is entered via the web)
51	ZIPCITY	C	100	0	Zip + city

39 Structure of Database Table: RANDOMSSS.dbf
List of random codes
Index:	1 incode on field(s) incode

 

No	Fieldname	Type	Length	Decimals	Description
4	DATECREATE	D	8	0	Creation-date of internet-code
5	DATEIN	D	8	0	Date on which the code has been used
2	INCODE	C	20	0	Randomly generated code contains prodid; Namosys Quick only!
8	ORDERNO	C	8	0	Orderno
9	PARTNO	C	3	0	partno (orderno+partno is key to stamp table)
7	PRINTED	L	1	0	Set .T. if bar-codes have been printed
10	PRODID	C	12	0	Internal productid (= barsss field in product table)
1	RANDT	N	12	0	Value of the code
6	TIMEIN	C	8	0	Time on which the code has been used
3	USED	L	1	0	web-(in)code has been used

40 Structure of Database Table: RECLAIM.dbf
Order redo and complaints registration to comply with ISO regulations
Index:	1 claimid on field(s) claimid

 

No	Fieldname	Type	Length	Decimals	Description
2	CLAIM	C	40	0	Claim description
1	CLAIMID	C	3	0	Claim ID

41 Structure of Database Table: REGION.dbf
shipment regions for freight specifications
Index:	1 region on field(s) upper(region)

 

No	Fieldname	Type	Length	Decimals	Description
1	REGION	C	40	0	Region name

42 Structure of Database Table: SHIPPER.dbf
Shipment options and specifications
Index:	1 shipid on field(s) shipperid + upper(region) 2 shpprior on field(s) priority 3 region on field(s) upper(region) + shipperid

 

No	Fieldname	Type	Length	Decimals	Description
4	ACCOUNTID	C	15	0	GL-account-id-number
18	AGREEMENT	C	10	0	For internal use
5	BARCODENO	C	25	0	Next barcode no for shipment
7	BESTWAY	L	1	0	True or False / Yes or No
8	CALCVALUE	L	1	0	True or False / Yes or No
9	CALCVOLUME	L	1	0	True or False / Yes or No
10	CALCWEIGHT	L	1	0	True or False / Yes or No
15	CHANGEADDR	L	1	0	True or False / Yes or No
29	CHARGE0	N	15	2	Shipment cost value
30	CHARGE1	N	15	2	Shipment cost value
39	CHARGE10	N	15	2	Shipment cost value
31	CHARGE2	N	15	2	Shipment cost value
32	CHARGE3	N	15	2	Shipment cost value
33	CHARGE4	N	15	2	Shipment cost value
34	CHARGE5	N	15	2	Shipment cost value
35	CHARGE6	N	15	2	Shipment cost value
36	CHARGE7	N	15	2	Shipment cost value
37	CHARGE8	N	15	2	Shipment cost value
38	CHARGE9	N	15	2	Shipment cost value
3	CONTACT	C	40	0	Contact
6	FREIGHT	L	1	0	True or False / Yes or No
16	GENDLOOS	L	1	0	True or False / Yes or No
12	MINVALUE	N	10	0	Minimum value
13	MINVOLUME	N	10	0	Minimum volume
14	MINWEIGHT	N	10	0	Minimum weight
19	NETWEIGH1	N	9	0	Weight 1 for calculating cost
28	NETWEIGH10	N	9	0	Weight 10 for calculating cost
20	NETWEIGH2	N	9	0	Weight 2 for calculating cost
21	NETWEIGH3	N	9	0	Weight 3 for calculating cost
22	NETWEIGH4	N	9	0	Weight 4 for calculating cost
23	NETWEIGH5	N	9	0	Weight 5 for calculating cost
24	NETWEIGH6	N	9	0	Weight 6 for calculating cost
25	NETWEIGH7	N	9	0	Weight 7 for calculating cost
26	NETWEIGH8	N	9	0	Weight 8 for calculating cost
27	NETWEIGH9	N	9	0	Weight 9 for calculating cost
44	PRE_BARCOD	C	15	0	Prefix of barcode
11	PRIORITY	C	2	0	Priority
17	PTT	L	1	0	True or False / Yes or No
42	REGION	C	40	0	Region for which charge is calculated
41	SAVE_INFO	L	1	0	True or False / Yes or No
2	SHIPPER	C	40	0	Shipper
1	SHIPPERID	C	2	0	ShipperID
40	SHP_IMG	C	50	0	Image on shipment label
43	URL	C	30	0	URL for retrieving shipping-information
45	USEFORWEB	L	1	0	If true the option will be shown in the web-site

43 Structure of Database Table: SHORTCUT.dbf
Typeset shortcut definitions
Index:	1 shortcut on field(s) shortcut

 

No	Fieldname	Type	Length	Decimals	Description
2	REPLACEBY	C	25	0	Result
1	SHORTCUT	C	6	0	Key-combination

44 Structure of Database Table: SHPADDR.dbf
Table with ship-to addresses
Index:	1 cidshp on field(s) custid 2 ordnoshp on field(s) orderno 3 cidname on field(s) custid + substr(shpname1, 1, 6) 4 shppost on field(s) shppostal + shpname1 5 shpname on field(s) shpname1 + shpcity

 

No	Fieldname	Type	Length	Decimals	Description
3	CUSTID	C	6	0	Customer ID number
10	NEW_CUSTID	C	6	0	DO NOT USE only for backwards compatibility
11	OLD_CUSTID	C	6	0	DO NOT USE only for backwards compatibility
2	ORDERNO	C	8	0	Order-number
6	SHPADDRESS	C	75	0	Address
1	SHPADDRID	N	19	0	Shipaddress ID for linking order to shpaddr table
8	SHPCITY	C	40	0	City
9	SHPCOUNTRY	C	40	0	Country
4	SHPNAME1	C	40	0	Name 1
5	SHPNAME2	C	40	0	Name 2
7	SHPPOSTAL	C	15	0	Postal code
12	SHPSTATE	C	40	0	State

45 Structure of Database Table: STAMP.dbf; in combination with memo-file: STAMP.fpt
This table contains actual stamp-data
Index:	1 orderno on field(s) orderno + partno + str(99999999 - val(dtos(date))) 2 print on field(s) statusid + printsetid + colourid + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 3 print_nc on field(s) statusid + printsetid + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 4 prt_r on field(s) statusid + printsetid + colourid + str(3 - rushcode, 1) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 5 prt_r_nc on field(s) statusid + printsetid + str(3 - rushcode, 1) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 6 entered on field(s) statusid + userid 7 corprod on field(s) statusid + upper(prodid) + orderno + partno 8 search1 on field(s) upper(searchkey1) + str(99999999 - val(dtos(date))) 9 search2 on field(s) upper(searchkey2) + str(99999999 - val(dtos(date))) 10 custid on field(s) upper(custid) + str(99999999 - val(dtos(date))) 11 custinfo on field(s) upper(substr(custinfo, 1, 12)) + str(99999999 - val(dtos(date))) 12 ship on field(s) statusid + custid + orderno + partno 13 extrunno on field(s) substr(extrunno, 1, 6) 14 remakeid on field(s) dtos(date) + remaketype 15 quick on field(s) statusid + upper(searchkey1) 16 prtv on field(s) statusid + printsetid + colourid + str(quantity - nprinted) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 17 prtncv on field(s) statusid + printsetid + str(quantity - nprinted) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 18 prtrv on field(s) statusid + printsetid + colourid + str(quantity - nprinted) + str(3 - rushcode, 1) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 19 prtrncv on field(s) statusid + printsetid + str(quantity - nprinted) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 20 statprod on field(s) statusid + custgrpid + upper(prodid) 21 incode on field(s) incode

 

No	Fieldname	Type	Length	Decimals	Description
51	ARCHIVED	L	1	0	True or False / Yes or No
40	ATTACHMENT	L	1	0	True or False / Yes or No
42	BMAINFONT	L	1	0	True or False / Yes or No
18	BOXNO	C	6	0	Shipping-box-number
46	BREGFONT	L	1	0	True or False / Yes or No
44	BSUBMFONT	L	1	0	True or False / Yes or No
9	COLOURID	C	2	0	Inkpad or impression colour, refers to Colour tabl
53	CUSTGRPID	C	10	0	Customer group ID
4	CUSTID	C	6	0	Customer ID number
5	CUSTINFO	C	50	0	Customer info
27	CUT	L	1	0	True or False / Yes or No
39	CUTDIST	N	5	0	Lasercutting
31	CUTHEIGHT	N	6	0	Lasercutting
28	CUTLEFT	N	6	0	Lasercutting
29	CUTTOP	N	6	0	Lasercutting
30	CUTWIDTH	N	6	0	Lasercutting
10	DATE	D	8	0	Date entered
11	DATE_OUT	D	8	0	Shipment date
34	DAYSIN	N	3	0	Days in (Shipment date - date entered)
25	END_NUM	C	6	0	End of numbering range
22	EXPORTED	L	1	0	True or False / Yes or No
35	EXTRUNNO	C	10	0	Runnumber
7	HEIGHT	N	6	0	DO NOT USE only for backwards compatibility
37	HISTORY	M	4	0	History
48	HOLDMEMO	M	4	0	Memo for additional info
43	IMAINFONT	N	2	0	Main font index for quick
56	INCODE	C	20	0	VoucherID
47	IREGFONT	N	2	0	Regular font index for quick
45	ISUBMFONT	N	2	0	Sub font index for quick
49	LINKTO	C	12	0	Orderno+Partno of counter seal; LINKTO start with an O for identifying original stamp
16	MOUNTID	C	2	0	Mount type, refers to Mount table
55	NPRINTED	N	10	0	Number of printed stamps
19	NUMBERING	L	1	0	True or False / Yes or No
50	OLEDOC	C	75	0	Name of oledocument
1	ORDERNO	C	8	0	Order-number
23	PAGEWIZARD	L	1	0	True or False / Yes or No
2	PARTNO	C	3	0	Partnumber
14	PRINTSETID	C	2	0	Product category, refers to PrintSet table
38	PRODID	C	12	0	Product code, refers to Product table
52	PRODTYPE	C	2	0	Sub production status
54	QUANTITY	N	10	0	Quantity
36	REMAKETYPE	C	2	0	Remaketype ID
41	RUSHCODE	N	1	0	Rush code: 0: No rush; 1: Rush; 2: Rush 48h; 3: Rush 24h
57	SEALPOS	C	3	0	Seal position
12	SEARCHKEY1	C	6	0	Searchkey 1
13	SEARCHKEY2	C	6	0	Searchkey 2
33	SECONDSSET	N	5	0	Seconds stamp is being edited
8	SHAPE	N	1	0	Shape:0: Straight; 1: Round; 2: Oval
17	STAMPDEF	M	4	0	Stamp definition
3	STAMPNO	C	3	0	Stamp number
59	STAMPPROPS	N	2	0	for future use
24	START_NUM	C	6	0	Start number of numbering range
15	STATUSID	C	2	0	StatusID
26	STEP_NUM	N	3	0	Steps in numbering
60	STOCKTYPE	N	2	0	0=real inventoryproduct (cannot be typeset!) 1=real typeset 2=inventoryproduct on website, production via typeset 3=inventoryproduct on website, production via typeset from logo
32	USERID	C	2	0	User-number, refers to User-table
21	VERSION_ID	N	3	1	Version of stamp definition
20	VIA_LASER	L	1	0	True or False / Yes or No
6	WIDTH	N	6	0	DO NOT USE only for backwards compatibility
58	WWWORDER	L	1	0	Web order (TRUE if order is entered via the web)

51 Structure of Database Table: STAMP_TEMPLATE.dbf; in combination with memo-file: STAMP_TEMPLATE.fpt
This table contains actual stamp template data
Index:	1 orderno on field(s) orderno + partno + str(99999999 - val(dtos(date))) 2 print on field(s) statusid + printsetid + colourid + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 3 print_nc on field(s) statusid + printsetid + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 4 prt_r on field(s) statusid + printsetid + colourid + str(3 - rushcode, 1) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 5 prt_r_nc on field(s) statusid + printsetid + str(3 - rushcode, 1) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 6 entered on field(s) statusid + userid 7 corprod on field(s) statusid + upper(prodid) + orderno + partno 8 search1 on field(s) upper(searchkey1) + str(99999999 - val(dtos(date))) 9 search2 on field(s) upper(searchkey2) + str(99999999 - val(dtos(date))) 10 custid on field(s) upper(custid) + str(99999999 - val(dtos(date))) 11 custinfo on field(s) upper(substr(custinfo, 1, 12)) + str(99999999 - val(dtos(date))) 12 ship on field(s) statusid + custid + orderno + partno 13 extrunno on field(s) substr(extrunno, 1, 6) 14 remakeid on field(s) dtos(date) + remaketype 15 quick on field(s) statusid + upper(searchkey1) 16 prtv on field(s) statusid + printsetid + colourid + str(quantity - nprinted) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 17 prtncv on field(s) statusid + printsetid + str(quantity - nprinted) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 18 prtrv on field(s) statusid + printsetid + colourid + str(quantity - nprinted) + str(3 - rushcode, 1) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 19 prtrncv on field(s) statusid + printsetid + str(quantity - nprinted) + str(999999 - width, 6, 0) + str(999999 - height, 6, 0) 20 statprod on field(s) statusid + custgrpid + upper(prodid) 21 incode on field(s) incode

 

No	Fieldname	Type	Length	Decimals	Description
51	ARCHIVED	L	1	0	True or False / Yes or No
40	ATTACHMENT	L	1	0	True or False / Yes or No
42	BMAINFONT	L	1	0	True or False / Yes or No
18	BOXNO	C	6	0	Shipping-box-number
46	BREGFONT	L	1	0	True or False / Yes or No
44	BSUBMFONT	L	1	0	True or False / Yes or No
9	COLOURID	C	2	0	Inkpad or impression colour, refers to Colour tabl
53	CUSTGRPID	C	10	0	Customer group ID
4	CUSTID	C	6	0	Customer ID number
5	CUSTINFO	C	50	0	Customer info
27	CUT	L	1	0	True or False / Yes or No
39	CUTDIST	N	5	0	Lasercutting
31	CUTHEIGHT	N	6	0	Lasercutting
28	CUTLEFT	N	6	0	Lasercutting
29	CUTTOP	N	6	0	Lasercutting
30	CUTWIDTH	N	6	0	Lasercutting
10	DATE	D	8	0	Date entered
11	DATE_OUT	D	8	0	Shipment date
34	DAYSIN	N	3	0	Days in (Shipment date - date entered)
25	END_NUM	C	6	0	End of numbering range
22	EXPORTED	L	1	0	True or False / Yes or No
35	EXTRUNNO	C	10	0	Runnumber
7	HEIGHT	N	6	0	DO NOT USE only for backwards compatibility
37	HISTORY	M	4	0	History
48	HOLDMEMO	M	4	0	Memo for additional info
43	IMAINFONT	N	2	0	Main font index for quick
56	INCODE	C	20	0	VoucherID
47	IREGFONT	N	2	0	Regular font index for quick
45	ISUBMFONT	N	2	0	Sub font index for quick
49	LINKTO	C	12	0	Orderno+Partno of counter seal; LINKTO start with an O for identifying original stamp
16	MOUNTID	C	2	0	Mount type, refers to Mount table
55	NPRINTED	N	10	0	Number of printed stamps
19	NUMBERING	L	1	0	True or False / Yes or No
50	OLEDOC	C	75	0	Name of oledocument
1	ORDERNO	C	8	0	Order-number
23	PAGEWIZARD	L	1	0	True or False / Yes or No
2	PARTNO	C	3	0	Partnumber
14	PRINTSETID	C	2	0	Product category, refers to PrintSet table
38	PRODID	C	12	0	Product code, refers to Product table
52	PRODTYPE	C	2	0	Sub production status
54	QUANTITY	N	10	0	Quantity
36	REMAKETYPE	C	2	0	Remaketype ID
41	RUSHCODE	N	1	0	Rush code: 0: No rush; 1: Rush; 2: Rush 48h; 3: Rush 24h
57	SEALPOS	C	3	0	Seal position
12	SEARCHKEY1	C	6	0	Searchkey 1
13	SEARCHKEY2	C	6	0	Searchkey 2
33	SECONDSSET	N	5	0	Seconds stamp is being edited
8	SHAPE	N	1	0	Shape:0: Straight; 1: Round; 2: Oval
17	STAMPDEF	M	4	0	Stamp definition
3	STAMPNO	C	3	0	Stamp number
59	STAMPPROPS	N	2	0	for future use
24	START_NUM	C	6	0	Start number of numbering range
15	STATUSID	C	2	0	StatusID
26	STEP_NUM	N	3	0	Steps in numbering
60	STOCKTYPE	N	2	0	0=real inventoryproduct (cannot be typeset!) 1=real typeset 2=inventoryproduct on website, production via typeset 3=inventoryproduct on website, production via typeset from logo
32	USERID	C	2	0	User-number, refers to User-table
21	VERSION_ID	N	3	1	Version of stamp definition
20	VIA_LASER	L	1	0	True or False / Yes or No
6	WIDTH	N	6	0	DO NOT USE only for backwards compatibility
58	WWWORDER	L	1	0	Web order (TRUE if order is entered via the web)

46 Structure of Database Table: SYSTEM.dbf
MAY NOT BE EDITED!! This table contains system information;default values for all users
Index:	1 param on field(s) parameter

 

No	Fieldname	Type	Length	Decimals	Description
3	COMMENT	C	30	0	Comment
1	PARAMETER	C	50	0	Parameter
2	VALUE	C	100	0	Value

47 Structure of Database Table: TAX.dbf
Different tax-options with percentages
Index:	1 taxid on field(s) taxid

 

No	Fieldname	Type	Length	Decimals	Description
3	ACCOUNTID	C	10	0	GL-account-id-number (refers to Account table)
6	OLDTAXRAT1	N	5	0	Old taxrate of order (see also Ordmain::oldtaxID)
7	OLDTAXRAT2	N	5	0	Old taxrate of order (see also Ordmain::oldtaxID)
1	TAXID	C	2	0	Tax ID
2	TAXNAME	C	20	0	Tax description
5	TAXOVERTAX	L	1	0	1 (TRUE): Calculate tax over tax
4	TAXRATE	N	5	2	Tax percentage

48 Structure of Database Table: TERMS.dbf
Payment terms
Index:	1 termid on field(s) termid

 

No	Fieldname	Type	Length	Decimals	Description
5	DUEDAYS	N	3	0	Due days payment term
3	FINANEXP	C	40	0	Optional: Financial export code
6	PERC	N	5	2	Percentage payment term
1	TERMID	C	2	0	Payment/delivery term ID (refers to Terms table)
2	TERMS	C	40	0	Term description
4	TERMTYPE	N	1	0	Term type: delivery of payment

49 Structure of Database Table: USER.dbf; in combination with memo-file: USER.fpt
User, salesman and remote customer information
Index:	1 userid on field(s) userid 2 user on field(s) user

 

No	Fieldname	Type	Length	Decimals	Description
3	CODE	C	4	0	Internal access code (this is NOT pincode!)
16	EXPIRED	L	1	0	Switch for User access has been expired?
22	IP	C	15	0	IP-number of customer
8	LASTDATE	D	8	0	Login date
14	LASTITEM	C	3	0	Do NOT edit! For internal use only!
15	LASTORDER	C	8	0	Do NOT edit! For internal use only!
9	LASTTIME	C	8	0	Login Time
4	LEVEL	N	1	0	Access level (refer to readme info about pincode levels)
10	MAIL	M	4	0	Mail description
11	MESSAGE	L	1	0	Mail? True or False / Yes or No
7	NAMOSYS	L	1	0	Currently in NamoSys? True or False / Yes or No
18	ORDER	L	1	0	True or False / Yes or No
6	PAGEWIZARD	L	1	0	Currently in PageWizard? True or False / Yes or No
21	PURCHASE	L	1	0	True or False / Yes or No
12	REMCUST	L	1	0	Is user a remote customer? True or False / Yes or No
13	REMCUSTID	C	6	0	Customer ID of remote customer?
20	REMOTEHIGH	C	8	0	orderno range of remote user (between REMOTEHIGH and REMOTELOW!)
19	REMOTELOW	C	8	0	OrderNo range of remote user
17	SALESMAN	L	1	0	Is user a salesman? True or False / Yes or No
5	TYPESET	L	1	0	Currenlt in typeset? True or False / Yes or No
2	USER	C	20	0	Name of SOSET user
1	USERID	C	2	0	User-number, refers to User-table

50 Structure of Database Table: VENDOR.dbf
Vendor table
Index:	1 supplidc on field(s) supplierid 2 srchname on field(s) searchname 3 srchcity on field(s) searchcity 4 postal on field(s) mlpostal 5 supplidn on field(s) val(supplierid)

 

No	Fieldname	Type	Length	Decimals	Description
25	BANK	C	40	0	Supplier's bank
23	BANKACC	C	25	0	Supplier bankaccount
26	BANKADDR	C	40	0	Supplier's bank address
27	BANKCITY	C	40	0	Supplier's bank city
19	CONTACT	C	40	0	Supplier contact person
29	CURRENCYID	N	3	0	Supplier's currencyID
28	DATE	D	8	0	Supplier record creation date
36	DISC	L	1	0	Discount
11	EMAIL	C	40	0	Supplier E-mail
21	FAXNO	C	40	0	Fax number of Vendor
24	GIRONO	C	25	0	Supplier giro number
37	KLAAR	L	1	0	not in use
17	MEMO1	C	30	0	Supplier memo 1
18	MEMO2	C	30	0	Supplier memo 2
6	MLADDRESS	C	40	0	Supplier mail address
8	MLCITY	C	40	0	Supplier mail city
10	MLCOUNTRY	C	40	0	Supplier mail country
7	MLPOSTAL	C	15	0	Supplier mail postal
9	MLSTATE	C	40	0	Supplier mail state
4	NAME1	C	40	0	Supplier name
5	NAME2	C	40	0	Supplier name 2
31	OLDFAXNO	C	40	0	Fax number of Vendor
30	OLDPHONENO	C	40	0	Supplier oldphone number
32	ORD_FORGN	L	1	0	basic currency boolean
20	PHONENO	C	40	0	Supplier phone number
3	SEARCHCITY	C	6	0	Supplier searchname
2	SEARCHNAME	C	6	0	Supplier Searchname
22	STATUS	C	40	0	Supplier status
12	STRADDRESS	C	40	0	Supplier main address
14	STRCITY	C	40	0	Supplier main city
16	STRCOUNTRY	C	40	0	Supplier main country
13	STRPOSTAL	C	15	0	Supplier main postal
15	STRSTATE	C	40	0	Supplier main state
1	SUPPLIERID	C	10	0	SupplierID
33	TAX1	C	3	0	Supplier's taxID 1
34	TAX2	C	3	0	Supplier's taxID 2
35	TAX3	C	3	0	Supplier's taxID 3
38	VALUTAID	N	3	0	currencyid from currency-table

 

Contact us in case you have any question or comment via our email