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

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
1	ID	C	20	0	Category ID
2	CATEGORY	C	60	0	Category description
3	ENDCAT	C	1	0	0: No end category; 1: End category
4	TYPESET	L	1	0	0: No Typeset category (stock); 1: Typeset category
5	CATIMP	C	150	0	Contains the category image
6	CATTXT	M	4	0	Contains the category description

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
1	COLOURID	C	2	0	Inkpad or impression colour
2	COLOUR	C	10	0	Colour name
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
1	COMPANYID	C	6	0	Company identifier
2	COMPANY	C	30	0	Company name
3	ADDRESS1	C	30	0	Company address
4	POSTAL	C	30	0	Company postal code
5	CITY	C	30	0	Company city
6	COUNTRY	C	30	0	Company country
7	PHONE	C	30	0	Company phone
8	EMAIL	C	30	0	Company e-mail
9	FAX	C	30	0	Company faxnumber
10	VATID	C	30	0	Company Vat-id
11	ACCOUNTID	C	30	0	General company Account ID debtors
12	DATAPATH	C	64	0	Company SOSET tables directory; in multi-company relative path
13	HEADERLOGO	C	50	0	Company default document header
14	FOOTERLOGO	C	50	0	Company default document footer
15	HEADERXPOS	N	6	0	Company default document header X-position in MM from left side
16	FOOTERXPOS	N	6	0	Company default document footer X-position in MM from left side
17	LOCALPROD	L	1	0	Switch for local production: typeset-data NOT exported
18	HOSTPROD	L	1	0	DO NOT USE only for backwards compatibility
19	CUSTID	C	6	0	Customer ID number
20	HEADEROPOS	C	50	0	Header file for printing via OPOS printer
21	FOOTEROPOS	C	50	0	Footer file for printing via OPOS printer
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
24	MAINCOMP	L	1	0	TRUE: To identify that this is the main company
25	DUNS	C	10	0	Dun & Bradstreet registration number
26	WEBCUSTGRP	C	10	0	CustomerGroup for web-order-customers
27	INVOICENO	C	6	0	Next invoicenumber

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
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
8	DISCOUNT	L	1	0	TRUE if discount is applicalble on contractprice

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

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

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

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

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

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
1	CUSTID	C	6	0	Customer ID number
2	GROUPID	C	10	0	Customer Group ID refers to CustGrp table
3	SEARCHNAME	C	6	0	Search field
4	NAME1	C	40	0	Name of customer
5	NAME2	C	40	0	Name of customer
6	MLADDRESS	C	75	0	Mail address
7	MLPOSTAL	C	15	0	Postal code of of mailing address
8	MLCITY	C	40	0	City of mailing address
9	MLCOUNTRY	C	40	0	Country of mailing address
10	STRADDRESS	C	75	0	Company address streetname
11	STRPOSTAL	C	15	0	Company address postal code
12	STRCITY	C	40	0	Company address city
13	STRCOUNTRY	C	40	0	Company address country
14	REGION	C	40	0	Region. State, Province
15	CONTACT	C	40	0	Contact person
16	PHONENO	C	40	0	Phone number
17	FAXNO	C	40	0	Fax number (eg used for automatic send of proof)
18	EMAIL	C	60	0	E-mail address (eg used for automatic send of proof)
19	NOTE	M	4	0	Customer information
20	STATUS	N	2	0	Financial status: embargo, credit hold, definit etc.
21	STATEMENT	L	1	0	True or False / Yes or No
22	PRICELIST	N	2	0	Pricelist (1-5) refers to UnitPrice1-5 in Product table
23	INVDISCOUN	N	2	0	Invoice discount percentage
24	ORDERTYPE	N	2	0	OrderType
25	FIRSTORDER	D	8	0	Only for NL-market
26	LASTORDER	D	8	0	Last orde date
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
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
51	CHAMBERREG	C	25	0	Chamber of commerce registration number
52	VATCODE	C	15	0	VAT-code
53	CREDLIMIT	N	10	0	Credit limit
54	NTERM	N	4	0	DO NOT USE only for backwards compatibility
55	SHIPPERID	C	2	0	Way of shipment refers to shipper table
56	MODIFIED	M	4	0	Customer data modified date
57	MOUNTID	C	2	0	Mount type, refers to Mount table
58	SALESMANID	C	2	0	Salesman-number, refers to User-table
59	LANGUAGE	C	12	0	DO NOT USE only for backwards compatibility
60	HISTORY	M	4	0	Customer-History information
61	QDISCOUNT	L	1	0	Switch for quantity discount from global prefs table.
62	DISCOUNTID	C	6	0	Discount ID, refers to Discount-table
63	COLORID	C	2	0	Default inkpad colout
64	SEARCHCITY	C	6	0	Search field
65	INVOICETO	N	1	0	Invoice to another customer 1=Yes; 0=No
66	INVCUSTID	C	6	0	Invoice to this customerID
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
74	BANKCODE	C	10	0	DO NOT USE only for backwards compatibility
75	QUALCHECK	L	1	0	Switch for quality control marker at packing slip.
76	FREIGHT	N	1	0	Charge for freight cost
77	NO_PRICE	L	1	0	No price on external forms. True or False/ Yes or No
78	INVFREQ	N	2	0	Invoice frequency
79	DISKINV	L	1	0	Digital Invoice information generation: T/F or Y/N
80	COPYCUSTGR	L	1	0	Automatic copying of settings from CustomerGroup T/F or Y/N
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
84	FINEXPCOD	N	1	0	Optional Financial export code
85	COMPANYID	C	6	0	Company ID
86	TERMID	C	2	0	Payment/delivery term ID (refers to Terms table)
87	SHPTERMID	C	2	0	Delivery term ID
88	EMB_COUNT	N	3	0	Embargo counter
89	CHKSHIP	L	1	0	Switch Do you want to check shipment during order-entry?
90	INVDISC	L	1	0	Invoice discount True or False/ Yes or No
91	CASHREGIST	L	1	0	switch for Is this customer a batch cash-resgiter account?
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
102	MLSTATE	C	40	0	State/province of mailing address
103	STRSTATE	C	40	0	Company address state
104	INFOINTERN	M	4	0	Internal information. Only on screens and internals documents
105	VALUTAID	N	3	0	Currency ID
106	ORD_FORGN	L	1	0	True or False / Yes or No
107	IMPORTANT	C	40	0	Important info field; pops up during view, edit and order-entry
108	FREIGHTLIM	L	1	0	Switch for freight limit as specified in global prefs.
109	VATTYPE	C	2	0	0: Default; 1: Normal; 2: ICT; 3: Export outside EU
110	PROOFPRINT	L	1	0	Automatic generation of proofprint True or False / Yes or No
111	RUSH	N	1	0	Rush code
112	SUM_INV	L	1	0	Summarized invoice or detailed? True or False / Yes or No
113	PABNO	C	6	0	Pre Assigned Boxnumber
114	ORDERVAL	N	10	0	Total Net Order value
115	HOLDDATE	D	8	0	Date of last credit-hold
116	VISITED	D	8	0	Last visit date
117	ASN	L	1	0	Advanced Shipping Notice switch. Generated after ship run
118	INVPERCUST	L	1	0	Invoice split by customer during batch invoices
119	PASSWD	C	15	0	web-site password for customer
120	HEADEROPOS	C	50	0	path+filename for Headertext for POS printer
121	FOOTEROPOS	C	50	0	path+filename for Footertext for POS printer
122	HEADERLOGO	C	50	0	path+filename for Headerimage
123	FOOTERLOGO	C	50	0	path+filename for Footerimage
124	HEADERXPOS	N	6	0	X Position for header on output
125	FOOTERXPOS	N	6	0	X Position for footer on output
126	MARGETOP	N	6	0	distance text from top
127	MARGEBOT	N	6	0	distance text from bottom
128	PREPRINTED	L	1	0	Use preprinted forms. 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
131	AUTOPUR	L	1	0	preparation of purchase via SOSET-purchase from sales-order
132	FINCUSTID	C	6	0	CustomerID to which postings will be done in GL
133	CCDD	C	6	0	Creditcard exp date
134	CCID	C	2	0	Type of Creditcard
135	CCNO	C	30	0	Creditcard number
136	CCNAME	C	25	0	Name on Creditcard
137	CARDID	C	5	0	CVV code on back creditcard 3 pos
138	NOMAILING	L	1	0	Indicates if customer wants mailings from you
139	IPADDRESS	C	15	0	Ip-number of customer
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
142	BANKINFO	C	40	0	Bankname
143	IBANNO	C	40	0	IBAN number

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
1	DISCOUNTID	C	6	0	Discount ID
2	DISCDESC	C	25	0	Discount description
3	PRODGRPID	C	2	0	Product group ID refers to ProdGrp table
4	DISCOUNT1	N	2	0	Discount percentage 1
5	DISCOUNT2	N	2	0	Discount percentage 2

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

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

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
2	INVNAME1	C	40	0	Invoice name
3	INVNAME2	C	40	0	Invoice name
4	INVADDRESS	C	75	0	Invoice address
5	INVPOSTAL	C	15	0	Postal code of Invoice address
6	INVCITY	C	40	0	City of Invoice address
7	INVCOUNTRY	C	40	0	Country 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
10	INVSTATE	C	40	0	State of Invoice address

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

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
1	KEYWORD	C	25	0
2	KEYWORDID	C	100	0
3	PROPS	N	2	0
4	CRAWLDATE	D	8	0
5	SITE	C	50	0
6	INFO	C	100	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
2	SEARCHKEY1	C	100	0
3	SEARCHKEY2	C	100	0
4	SYMPTOMS	M	4	0
5	RESOLUTION	M	4	0
6	REMARKS	M	4	0
7	REPORTEDBY	C	25	0
8	TAKENBY	C	25	0
9	ENTRYDD	D	8	0
10	DURATION	C	10	0
11	TYPE	C	25	0
12	LEVEL	N	2	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
1	LASERID	C	2	0	Laser ID
2	LASER	C	40	0	Description of laser
3	LASERPORT	C	40	0	Output Port of laser (only LMI)
4	PRINTER	C	100	0	Brand of output-device
5	LASERTYPE	N	2	0	Brand of laser

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
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
6	V_SPEED	N	3	0	engraving Speed for cutting
7	V_PULSE	N	3	0	Perforation frequency. Must be >0
8	LASERFILE	C	100	0	lasersettings file

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

 

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

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
1	NOTEID	C	2	0	Quick only!Note ID
2	LANGUAGE	C	3	0	Quick only!Language code
3	DESCR	C	40	0	Quick only! Note text
4	NOTE	M	10	0	Quick only!Note description

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

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

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

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

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

 

No	Fieldname	Type	Length	Decimals	Description
1	PAYTYPEID	C	2	0	Way of Payment ID
2	PAYTYPE	C	30	0	Description of way of payment
3	CASH	L	1	0	switch for is this way of payment icash register for cash-control?
4	USEFORWEB	L	1	0	If true the option is shown at web-site
5	TYPE	N	2	0	1=force credit card ;2=reserved for special; 3=no credit card
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
1	PRTSETID	C	3	0	PrintSet ID production category idientifier
2	PRTSET	C	50	0	description
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
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
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
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
18	D_POWER2	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
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
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
42	MAXDIST	N	2	0	Steps for laser-engraving
43	FIXEDPOS	L	1	0	Switch for fixed positioning instead of automatic.
44	TITLE	L	1	0	Print tile on output True or False / Yes or No
45	USEMOLD	L	1	0	Use the mold as specified True or False / Yes or No
46	PRINTMOLD	L	1	0	Switch for printing outlines of mold on output
47	XCOUNTER	N	3	0	DO NOT USE only for backwards compatibility
48	CUTMARKS	L	1	0	Print cutting marks True or False / Yes or No
49	CENTERMOLD	L	1	0	Center mold-print on layout True or False / Yes or No
50	CUT_DIST	N	6	0	Distance from cutting-line to image
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
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
55	MARGIN	N	6	0	margin on layout (4 sides)
56	MOLDWIDTH	N	6	0	Width of Mold (UseMold MUST be True!)
57	MOLDHEIGHT	N	6	0	Height of Mold (UseMold MUST be True!)
58	SEPARATOR	N	6	0	Space between products on layout
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
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
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
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
91	PIXELS	N	3	0	For seal-engraving: determines difference between die and counter
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
95	VULCANISE	L	1	0	True or False / Yes or No
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
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.
99	TEXTRGB	N	16	0	Text-colour (in RGB) e.g. for nameplates white with blue engraving material
100	BGIMG	C	100	0	Background image for business-cards, nameplates etc.
101	TYPEID	N	3	0	0=stamp 1=seal 2=sign 3=business card
102	PRTGRPID	C	25	0	To enable finishing-options per product. Eg: TypeID [NAMEPLATE] 4 holes etc.
103	CUTGAP	N	4	0	Gap between laser-cutting-lines (will keep corners)

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
1	PRODGRPID	C	2	0	Product category ID
2	PRODGRP	C	20	0	Product category description

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
1	PRODID	C	12	0	Product code, refers to Product table
2	SEARCHKEY	C	12	0	Searchtext
3	BARCODE	C	20	0	Sales Barcode
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
6	SCREENINFO	C	30	0	Additional field for some extra info. Not in orderscreen visual
7	PRINTSETID	C	2	0	Product category, refers to PrintSet table
8	PRODDISCOU	C	2	0	DO NOT USE only for backwards compatibility.
9	SUPPLIERID	C	10	0	DO NOT USE only for backwards compatibility. Instead use same field in PUR_PROD table.
10	PURCHASEID	C	12	0	Refers to Pur_prod table with vendor-product information
11	DISCONTINU	L	1	0	True or False / Yes or No
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
17	UNIT	C	10	0	NOT USED
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
20	PRODHEIGHT	N	6	0	DO NOT USE only for backwards compatibility
21	PRODDEPTH	N	5	0	Depth of the product (Future Calculating size of package)
22	PRODSHAPE	N	1	0	Shape of impression: 0=straight; 1=round, 2=oval
23	COLOUR	L	1	0	Colour-inkpad switch (this activates colour dialog)
24	ACCOUNTID	C	10	0	GL-account-id-number
25	STATISTID	C	10	0	Can be optionally used
26	FREIGHT	L	1	0	Switch for automatic charge for freight-costs
27	LASTORDER	D	8	0	Last date this product has been ordered
28	HISTORY	M	4	0	Historical info about changes etc.
29	FIRSTORDER	D	8	0	First date this product has been ordered
30	QDISCOUNT	L	1	0	Switch to take quantity discount from System-table
31	MOUNT	L	1	0	Mount-options? True or False / Yes or No
32	BAND_ID	N	1	0	0=no band; 1-date-band
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
36	BANDHEIGHT	N	6	0	heigth of band-area
37	CUSTGRPID	C	10	0	ref to CustGrp table. If specified, product only for this CustGrp
38	CUT_WIDTH	N	6	0	Gros width of the product (supplier sizes)
39	CUT_HEIGHT	N	6	0	Gros height of the product (supplier sizes)
40	CAT_PAGE	C	5	0	Optional. Refers to page in Catalog
41	CAT_CODE	C	20	0	Optional. Refers to code in Catalog-table
42	DISCOUNT	L	1	0	True or False / Yes or No
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
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
63	PRTGRPID	C	2	0	Product category. Refers to PrintSet-table for technical reasons
64	TAX	L	1	0	Taxable product? True or False / Yes or No
65	PRICELEVEL	C	10	0	Pricelevel optional to query pricelevels
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
70	NOMAIL	L	1	0	Handle as NON PO-box item True or False / Yes or No
71	PACKCOST	L	1	0	Charge for packaging costs True or False / Yes or No
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
77	REALQUAN	N	10	0	Real quantity; quantity will be multiplied with realquan in typeset
78	BARSSS	C	5	0	Contains the internal barcode number; for generating quick barcodes
79	PRODIMGLO	C	150	0	Contains the product image
80	IMPRIMGLO	C	150	0	Contains the product impression
81	CUSPRODID	C	30	0	Contains the customer productid
82	COPYRIGHT	C	30	0	Copyright notice of product image
83	PACKAGESET	C	25	0	Contains ProdID of package, as being part of that package
84	MULTICOLOR	L	1	0	triggers multi-color option for web-typeset
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

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

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

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
1	PURCHASEID	C	12	0	ProductID
2	PRODNAME	C	30	0	Product Name
3	PRODNAME2	C	30	0	Product Name 2
4	SEARCHKEY	C	12	0	SearchKey for product
5	SUPPLIERID	C	10	0	supplier ID form vendor
6	NOTE1	C	30	0	Note
7	NOTE2	C	30	0	Note
8	OLDINV	C	8	0	Number of find fysical invoice
9	PRICE_DD	D	8	0	Date of price description
10	PRICEC	C	30	0	Price description
11	PRICEN	N	10	2	NOT IN USE ANYMORE (netto price)
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
17	NET	N	10	2	NOT IN USE ANYMORE (netto price)
18	FACTOR1	N	5	3	NOT IN USE ANYMORE (exchange rate)
19	FACTOR2	N	5	3	Discount
20	MEMO_1	C	30	0	Info
21	MEMO_2	C	30	0	Info
22	QUANTITY	N	10	0	Temp used for inventory calculation
23	DATE	D	8	0	Record creation-date
24	VALUE	N	13	0	Temp used for inventory calculation
25	STATUS	C	2	0	not in use
26	AUTO	L	1	0	True or False / Yes or No
27	INSTOCK	N	10	0	Quantity in stock
28	WAREHOUSID	C	10	0	Warehouse ID
29	REORDERLEV	N	10	0	Reorder level (Instock < reorderlevel needs updating of in stock
30	ONORDER	N	10	0	Quantity that is on order
31	MINPURCHAS	N	10	0	Miniumum purchase quantity
32	USER	C	6	0	SOSET UserId from User-table
33	COLOUR	L	1	0	True or False / Yes or No
34	UNIT	C	20	0	Each, Weight: grams etc
35	PRODWEIGHT	N	10	0	Product weight
36	PRODWIDTH	N	10	0	Product width
37	PRODHEIGHT	N	10	0	Product height
38	PRODDEPTH	N	10	0	Product depth
39	PRODSHAPE	N	1	0	Product shape
40	BARCODE	C	20	0	Barcode of product
41	BAR_SALES	C	20	0	Barcode of sales product
42	METHOD	C	20	0	How to take inventory
43	CYCLECOUNT	D	8	0	Last date of counting the stock
44	VENDPRODID	C	20	0	Product ID of vendor
45	PACCOUNTID	C	10	0	Account ID
46	PSTATISTID	C	10	0	Statist ID
47	DISCONTINU	L	1	0	Product still available? True or False / Yes or No
48	FIRSTORDER	D	8	0	Date when product was first ordered
49	LASTORDER	D	8	0	Date when product was last ordered
50	HISTORY	M	4	0	History
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
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
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
75	OLDSTOCK	N	10	0	For temp-use with cycle-count report
76	OLDCYCLE	D	8	0	For temp-use with cycle-count report

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
1	TEMPLATE	C	6	0	Template name
2	ORDERNO	C	8	0	Order-number
3	PARTNO	C	3	0	Part number
4	DATE_IN	D	8	0	Date entered
5	NLINES	N	2	0	Number of lines
6	DATE_OUT	D	8	0	Shipment date
7	TIME	N	8	0	NOT USED
8	USERID	C	2	0	User-number, refers to User-table
9	SHAPE	C	1	0	NOT USED
10	PRINTSETID	C	2	0	Product category, refers to PrintSet table
11	EXAMPLEID	C	11	0	Example ID: OrderNo+PartNo of template
12	FRAME	L	1	0	True or False / Yes or No
13	EXPAND	L	1	0	True or False / Yes or No
14	STATUSID	C	2	0	StatusID
15	ALIGN1	C	1	0	Alignment for line 1: 0: Left; 1: Center; 2: Right; 3: Justified
16	ALIGN2	C	1	0	Alignment for line 2 0: Left; 1: Center; 2: Right; 3: Justified
17	ALIGN3	C	1	0	Alignment for line 3 0: Left; 1: Center; 2: Right; 3: Justified
18	ALIGN4	C	1	0	Alignment for line 4 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
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
24	ALIGN10	C	1	0	Alignment for line 10: 0: Left; 1: Center; 2: Right; 3: Justified
25	LANGUAGE	C	3	0	LanguageID
26	RUNNO	C	6	0	Runnumber
27	COLUMN	C	3	0	NOT USED
28	QUANTITY	N	10	0	Quantity
29	VALUE1	C	1	0	Font value for line 1: 0: Main font; 1: Sub font; 2; Regular font
30	VALUE2	C	1	0	Font value for line 2: 0: Main font; 1: Sub font; 2; Regular font
31	VALUE3	C	1	0	Font value for line 3: 0: Main font; 1: Sub font; 2; Regular font
32	VALUE4	C	1	0	Font value for line 4: 0: Main font; 1: Sub font; 2; Regular font
33	VALUE5	C	1	0	Font value for line 5: 0: Main font; 1: Sub font; 2; Regular font
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
38	VALUE10	C	1	0	Font value for line 10: 0: Main font; 1: Sub font; 2; Regular font
39	SEGMENT1	C	100	0	Text segment 1
40	SEGMENT2	C	100	0	Text segment 2
41	SEGMENT3	C	100	0	Text segment 3
42	SEGMENT4	C	100	0	Text segment 4
43	SEGMENT5	C	100	0	Text segment 5
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
48	SEGMENT10	C	100	0	Text segment 10
49	NAME	C	100	0	Name
50	ADDRESS	C	100	0	Address
51	ZIPCITY	C	100	0	Zip + city
52	COUNTRY	C	100	0	Contry
53	PRODID	C	12	0	Product code, refers to Product table
54	WIDTH	N	6	0	Width
55	HEIGHT	N	6	0	Height
56	REMAKETYPE	C	2	0	Remaketype ID
57	HISTORY	M	4	0	History
58	DAYSIN	N	3	0	Number of days in (Shipment date - date entered)
59	INCODE	C	20	0	VoucherID
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
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
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
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
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
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
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
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
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
129	SEGMENT50	C	100	0	Text segment
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
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
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
154	ALIGN50	C	1	0	Alignment for line 10: 0: Left; 1: Center; 2: Right; 3: Justified
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
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
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
179	VALUE50	C	1	0	Font value for corresponding line: 0: Main; 1: Sub; 2; Regular
180	EMAIL	C	30	0	E-mail address
181	WWWORDER	L	1	0	Weborder (TRUE if order is entered via the web)
182	POSTAL	C	15	0	Postal code of ship-to address
183	STATE	C	40	0	State of ship-to address

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

 

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

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
1	CLAIMID	C	3	0	Claim ID
2	CLAIM	C	40	0	Claim description

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
1	SHIPPERID	C	2	0	ShipperID
2	SHIPPER	C	40	0	Shipper
3	CONTACT	C	40	0	Contact
4	ACCOUNTID	C	15	0	GL-account-id-number
5	BARCODENO	C	25	0	Next barcode no for shipment
6	FREIGHT	L	1	0	True or False / Yes or No
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
11	PRIORITY	C	2	0	Priority
12	MINVALUE	N	10	0	Minimum value
13	MINVOLUME	N	10	0	Minimum volume
14	MINWEIGHT	N	10	0	Minimum weight
15	CHANGEADDR	L	1	0	True or False / Yes or No
16	GENDLOOS	L	1	0	True or False / Yes or No
17	PTT	L	1	0	True or False / Yes or No
18	AGREEMENT	C	10	0	For internal use
19	NETWEIGH1	N	9	0	Weight 1 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
28	NETWEIGH10	N	9	0	Weight 10 for calculating cost
29	CHARGE0	N	15	2	Shipment cost value
30	CHARGE1	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
39	CHARGE10	N	15	2	Shipment cost value
40	SHP_IMG	C	50	0	Image on shipment label
41	SAVE_INFO	L	1	0	True or False / Yes or No
42	REGION	C	40	0	Region for which charge is calculated
43	URL	C	30	0	URL for retrieving shipping-information
44	PRE_BARCOD	C	15	0	Prefix of barcode
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
1	SHORTCUT	C	6	0	Key-combination
2	REPLACEBY	C	25	0	Result

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

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

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
1	PARAMETER	C	50	0	Parameter
2	VALUE	C	100	0	Value
3	COMMENT	C	30	0	Comment

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
1	TAXID	C	2	0	Tax ID
2	TAXNAME	C	20	0	Tax description
3	ACCOUNTID	C	10	0	GL-account-id-number (refers to Account table)
4	TAXRATE	N	5	2	Tax percentage
5	TAXOVERTAX	L	1	0	1 (TRUE): Calculate tax over tax
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)

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

 

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

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

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

 

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