home *** CD-ROM | disk | FTP | other *** search

---

/ PC Pro 1998 October / DPPCPRO1098.ISO / Setup / DATABASE.PAK / EXPDBFLD.DB (.txt)

< prev

next >

Wrap

Paradox Database Table  |  1995-12-04  |  36.0 KB  |  338 rows

---

#	DBAlias,A,30	Table,A,8	SortOrder,S,2	FieldMap,A,25	FCode,A,1	FCodeInfo,A,30	Protected,L,1
1	DB_AddressBook	ADDRESS	1	Address Rec ID	K		1
2	DB_AddressBook	ADDRESS	2	First Name	I		1
3	DB_AddressBook	ADDRESS	3	Middle Name
4	DB_AddressBook	ADDRESS	4	Last Name	I		1
5	DB_AddressBook	ADDRESS	5	Title			1
6	DB_AddressBook	ADDRESS	6	Street
7	DB_AddressBook	ADDRESS	7	City
8	DB_AddressBook	ADDRESS	8	State/Prov
9	DB_AddressBook	ADDRESS	9	Zip/Postal Code
10	DB_AddressBook	ADDRESS	10	Business or Personal
11	DB_AddressBook	ADDRESS	11	Phone
12	DB_AddressBook	ADDRESS	12	Phone Extension
13	DB_AddressBook	ADDRESS	13	Fax Number
14	DB_AddressBook	ADDRESS	14	Notes
15	DB_AddressBook	ADDRESS	15	Email Address
16	DB_AddressBook	ADDRESS	16	Department
17	DB_AddressBook	ADDRESS	17	Company Name
18	DB_AddressBook	ADDRESS	18	Country
19	DB_CheckBook	CHECKBK	1	Checkbk Rec ID	K		1
20	DB_CheckBook	CHECKBK	2	Register Date	I	D	1
21	DB_CheckBook	CHECKBK	3	Reference Ck#	I		1
22	DB_CheckBook	CHECKBK	4	Payee	I		1
23	DB_CheckBook	CHECKBK	5	Notes
24	DB_CheckBook	CHECKBK	6	Category	I		1
25	DB_CheckBook	CHECKBK	7	Decrease Amount			1
26	DB_CheckBook	CHECKBK	8	Increase Amount			1
27	DB_CheckBook	CHECKBK	9	Cleared	I	D	1
28	DB_Contacts	COMPANY	1	Company Rec ID	K		1
29	DB_Contacts	COMPANY	2	Company Name	I		1
30	DB_Contacts	COMPANY	3	Department	I
31	DB_Contacts	COMPANY	4	Address
32	DB_Contacts	COMPANY	5	Secondary Address
33	DB_Contacts	COMPANY	6	City			1
34	DB_Contacts	COMPANY	7	State/Prov			1
35	DB_Contacts	COMPANY	8	Zip/Postal Code			1
36	DB_Contacts	COMPANY	9	Country			1
37	DB_Contacts	CONTADDR	1	Address Rec ID	K		1
38	DB_Contacts	CONTADDR	2	People Rec ID_FK	R	PEOPLE	1
39	DB_Contacts	CONTADDR	3	Type	I		1
40	DB_Contacts	CONTADDR	4	Address
41	DB_Contacts	CONTADDR	5	Secondary Address
42	DB_Contacts	CONTADDR	6	City
43	DB_Contacts	CONTADDR	7	State/Prov
44	DB_Contacts	CONTADDR	8	Zip/Postal Code
45	DB_Contacts	CONTADDR	9	Country
46	DB_Contacts	E-MAIL	1	E-mail Rec ID	K		1
47	DB_Contacts	E-MAIL	2	People Rec ID_FK	R	PEOPLE	1
48	DB_Contacts	E-MAIL	3	Type	I		1
49	DB_Contacts	E-MAIL	4	Address
50	DB_Contacts	PEOPLE	1	People Rec ID	K		1
51	DB_Contacts	PEOPLE	2	Company Rec ID_FK	I		1
52	DB_Contacts	PEOPLE	3	Last Name	I		1
53	DB_Contacts	PEOPLE	4	Middle Initial
54	DB_Contacts	PEOPLE	5	First Name			1
55	DB_Contacts	PEOPLE	6	Honorific
56	DB_Contacts	PEOPLE	7	Salutation
57	DB_Contacts	PEOPLE	8	Title
58	DB_Contacts	PEOPLE	9	Notes			1
59	DB_Contacts	PHONE	1	Phone Rec ID	K		1
60	DB_Contacts	PHONE	2	People Rec ID_FK	R	PEOPLE	1
61	DB_Contacts	PHONE	3	Type	I
62	DB_Contacts	PHONE	4	Phone Number			1
63	DB_Contacts	PHONE	5	Phone Extension
64	DB_Contacts	TASKS	1	Tasks Rec ID	K		1
65	DB_Contacts	TASKS	2	People Rec ID_FK	R	PEOPLE	1
66	DB_Contacts	TASKS	3	Due Date
67	DB_Contacts	TASKS	4	Description
68	DB_Contacts	TASKS	5	Status
69	DB_Contacts	TASKS	6	Notes			1
70	DB_HomeAssets	INSURE	1	Insure Rec ID	K		1
71	DB_HomeAssets	INSURE	2	Agent Name	I
72	DB_HomeAssets	INSURE	3	Company	I
73	DB_HomeAssets	INSURE	4	Address
74	DB_HomeAssets	INSURE	5	City
75	DB_HomeAssets	INSURE	6	State/Prov
76	DB_HomeAssets	INSURE	7	Zip/Postal Code
77	DB_HomeAssets	INSURE	8	Work Telephone
78	DB_HomeAssets	INSURE	9	Fax Number
79	DB_HomeAssets	INSURE	10	Email
80	DB_HomeAssets	INSURE	11	Policy Number
81	DB_HomeAssets	INSURE	12	Policy Type
82	DB_HomeAssets	ITEMS	1	Items Rec ID	K		1
83	DB_HomeAssets	ITEMS	2	Item Name	I
84	DB_HomeAssets	ITEMS	3	Description
85	DB_HomeAssets	ITEMS	4	Serial Number
86	DB_HomeAssets	ITEMS	5	Warranty Period
87	DB_HomeAssets	ITEMS	6	Warranty Description
88	DB_HomeAssets	ITEMS	7	Start Date
89	DB_HomeAssets	ITEMS	8	End Date
90	DB_HomeAssets	ITEMS	9	Purchase Price
91	DB_HomeAssets	ITEMS	10	Replacement Price
92	DB_HomeAssets	ITEMS	11	Purchase Date
93	DB_HomeAssets	ITEMS	12	Purchased From
94	DB_HomeAssets	ITEMS	13	Manufacturer
95	DB_HomeAssets	ITEMS	14	Room Rec ID_FK	R	ROOM	1
96	DB_HomeAssets	ROOM	1	Room Rec ID	K		1
97	DB_HomeAssets	ROOM	2	Room			1
98	DB_JobCosting	BILLING	1	Billing Rec ID	K		1
99	DB_JobCosting	BILLING	2	Project Rec ID_FK	R	PROJECT	1
100	DB_JobCosting	BILLING	3	Invoice Number
101	DB_JobCosting	BILLING	4	Invoice Date
102	DB_JobCosting	BILLING	5	Amount Invoiced			1
103	DB_JobCosting	BILLING	6	Amount Paid			1
104	DB_JobCosting	BILLING	7	Date Paid
105	DB_JobCosting	CLIENT	1	Client Rec ID	K		1
106	DB_JobCosting	CLIENT	2	Last Name			1
107	DB_JobCosting	CLIENT	3	First Name			1
108	DB_JobCosting	CLIENT	4	Account Number
109	DB_JobCosting	CLIENT	5	Company
110	DB_JobCosting	CLIENT	6	Address
111	DB_JobCosting	CLIENT	7	City
112	DB_JobCosting	CLIENT	8	State/Prov
113	DB_JobCosting	CLIENT	9	Zip/Postal Code
114	DB_JobCosting	CLIENT	10	Bill To Address
115	DB_JobCosting	CLIENT	11	Bill to City
116	DB_JobCosting	CLIENT	12	Bill to State/Prov
117	DB_JobCosting	CLIENT	13	Bill to Zip/Postal Code
118	DB_JobCosting	CLIENT	14	Work Telephone
119	DB_JobCosting	CLIENT	15	Phone Extension
120	DB_JobCosting	CLIENT	16	Home Phone
121	DB_JobCosting	CLIENT	17	Fax Number
122	DB_JobCosting	EMPLOYEE	1	Employee Rec ID	K		1
123	DB_JobCosting	EMPLOYEE	2	First Name			1
124	DB_JobCosting	EMPLOYEE	3	Last Name			1
125	DB_JobCosting	EMPLOYEE	4	Social Security Number
126	DB_JobCosting	EMPLOYEE	5	Title
127	DB_JobCosting	EMPLOYEE	6	Hourly Wage			1
128	DB_JobCosting	EMPLOYEE	7	Address
129	DB_JobCosting	EMPLOYEE	8	City
130	DB_JobCosting	EMPLOYEE	9	State/Prov
131	DB_JobCosting	EMPLOYEE	10	Zip/Postal Code
132	DB_JobCosting	EMPLOYEE	11	Phone
133	DB_JobCosting	EMPLOYEE	12	Employee Notes			1
134	DB_JobCosting	LABOR	1	Labor Rec ID	K		1
135	DB_JobCosting	LABOR	2	Project Rec ID_FK	R	PROJECT	1
136	DB_JobCosting	LABOR	3	Employee Rec ID_FK	L	EMPLOYEE	1
137	DB_JobCosting	LABOR	4	Type
138	DB_JobCosting	LABOR	5	Hourly Wage			1
139	DB_JobCosting	LABOR	6	Estimated Hours			1
140	DB_JobCosting	LABOR	7	Actual Hours			1
141	DB_JobCosting	LABOR	8	Labor Notes			1
142	DB_JobCosting	MATERIAL	1	Material Rec ID	K		1
143	DB_JobCosting	MATERIAL	2	Project Rec ID_FK	R	PROJECT	1
144	DB_JobCosting	MATERIAL	3	Item Name
145	DB_JobCosting	MATERIAL	4	Estimated Quantity			1
146	DB_JobCosting	MATERIAL	5	Actual Quantity			1
147	DB_JobCosting	MATERIAL	6	Unit of Measure
148	DB_JobCosting	MATERIAL	7	Estimated Unit Cost			1
149	DB_JobCosting	MATERIAL	8	Actual Unit Cost			1
150	DB_JobCosting	PROJECT	1	Project Rec ID	K		1
151	DB_JobCosting	PROJECT	2	Client Rec ID_FK	L	CLIENT	1
152	DB_JobCosting	PROJECT	3	Project Title
153	DB_JobCosting	PROJECT	4	Phone
154	DB_JobCosting	PROJECT	5	Start Date
155	DB_JobCosting	PROJECT	6	Address
156	DB_JobCosting	PROJECT	7	City
157	DB_JobCosting	PROJECT	8	State/Prov
158	DB_JobCosting	PROJECT	9	Zip/Postal Code
159	DB_JobCosting	PROJECT	10	Purchase Order No
160	DB_JobCosting	PROJECT	11	Estimated Finish Date
161	DB_JobCosting	PROJECT	12	Actual Finish Date
162	DB_JobCosting	PROJECT	13	Profit Margin			1
163	DB_JobCosting	PROJECT	14	Project Notes			1
164	DB_Music	ALBUMS	1	Albums Rec ID	K		1
165	DB_Music	ALBUMS	2	Groups Rec ID_FK	I		1
166	DB_Music	ALBUMS	3	Group Name
167	DB_Music	ALBUMS	4	Album Title
168	DB_Music	ALBUMS	5	Cover
169	DB_Music	ALBUMS	6	Producer
170	DB_Music	ALBUMS	7	Record Label
171	DB_Music	ALBUMS	8	Year Released
172	DB_Music	ALBUMS	9	Style
173	DB_Music	ALBUMS	10	Medium
174	DB_Music	TRACKS	1	Tracks Rec ID	K		1
175	DB_Music	TRACKS	2	Albums Rec ID_FK	R	ALBUMS	1
176	DB_Music	TRACKS	3	Track
177	DB_Music	TRACKS	4	Song Title
178	DB_Music	TRACKS	5	Lyrics
179	DB_Music	TRACKS	6	Duration
180	DB_Music	TRACKS	7	Sound Bite
181	DB_OrderInventory	BCKORDR	1	Stock Rec ID_FK	K		1
182	DB_OrderInventory	BCKORDR	2	Part Name			1
183	DB_OrderInventory	BCKORDR	3	Qty on Order			1
184	DB_OrderInventory	BCKORDR	4	Qty on Hand			1
185	DB_OrderInventory	BCKORDR	5	Qty Back Ordered			1
186	DB_OrderInventory	CROSSREF	1	Crossref Rec ID	K		1
187	DB_OrderInventory	CROSSREF	2	Stock Rec ID_FK	Q	STOCK	1
188	DB_OrderInventory	CROSSREF	3	Vendors Rec ID_FK	Q	VENDORS	1
189	DB_OrderInventory	CROSSREF	4	Vendor Part Number
190	DB_OrderInventory	CROSSREF	5	Part Price
191	DB_OrderInventory	CUSTOMER	1	Cust Rec ID	K		1
192	DB_OrderInventory	CUSTOMER	2	First Name	I		1
193	DB_OrderInventory	CUSTOMER	3	Last Name	I		1
194	DB_OrderInventory	CUSTOMER	4	Company Name			1
195	DB_OrderInventory	CUSTOMER	5	Department			1
196	DB_OrderInventory	CUSTOMER	6	Street			1
197	DB_OrderInventory	CUSTOMER	7	City			1
198	DB_OrderInventory	CUSTOMER	8	State/Prov	I		1
199	DB_OrderInventory	CUSTOMER	9	Zip/Postal Code	I		1
200	DB_OrderInventory	CUSTOMER	10	Phone Number
201	DB_OrderInventory	CUSTOMER	11	Phone Extension
202	DB_OrderInventory	CUSTOMER	12	Fax Number
203	DB_OrderInventory	CUSTOMER	13	Ship First Name			1
204	DB_OrderInventory	CUSTOMER	14	Ship Last Name			1
205	DB_OrderInventory	CUSTOMER	15	Ship Company Name			1
206	DB_OrderInventory	CUSTOMER	16	Ship Department			1
207	DB_OrderInventory	CUSTOMER	17	Ship Street			1
208	DB_OrderInventory	CUSTOMER	18	Ship City			1
209	DB_OrderInventory	CUSTOMER	19	Ship State/Prov			1
210	DB_OrderInventory	CUSTOMER	20	Ship Zip/Postal Code			1
211	DB_OrderInventory	CUSTOMER	21	Tax Rate			1
212	DB_OrderInventory	GROUP	1	Group Rec ID	K		1
213	DB_OrderInventory	GROUP	2	Group Name	I	U	1
214	DB_OrderInventory	GROUP	3	Group Description
215	DB_OrderInventory	LINEITEM	1	LineItem Rec ID	K		1
216	DB_OrderInventory	LINEITEM	2	Order Rec ID_FK	Q	ORDERS	1
217	DB_OrderInventory	LINEITEM	3	Stock Rec ID_FK	Q	STOCK	1
218	DB_OrderInventory	LINEITEM	4	Quantity			1
219	DB_OrderInventory	LINEITEM	5	Unit Price			1
220	DB_OrderInventory	LINEITEM	6	Taxable			1
221	DB_OrderInventory	LOCATION	1	Location Rec ID	K		1
222	DB_OrderInventory	LOCATION	2	Bin ID	I	U	1
223	DB_OrderInventory	LOCATION	3	Location Description
224	DB_OrderInventory	ORDERS	1	Order Rec ID	K		1
225	DB_OrderInventory	ORDERS	2	Cust Rec ID_FK	Q	CUSTOMER	1
226	DB_OrderInventory	ORDERS	3	Ship First Name			1
227	DB_OrderInventory	ORDERS	4	Ship Last Name			1
228	DB_OrderInventory	ORDERS	5	Ship Company Name			1
229	DB_OrderInventory	ORDERS	6	Ship Department			1
230	DB_OrderInventory	ORDERS	7	Ship Street	I		1
231	DB_OrderInventory	ORDERS	8	Ship City	I		1
232	DB_OrderInventory	ORDERS	9	Ship State/Prov	I		1
233	DB_OrderInventory	ORDERS	10	Ship Zip/Postal Code	I		1
234	DB_OrderInventory	ORDERS	11	Order Date			1
235	DB_OrderInventory	ORDERS	12	Bill Date
236	DB_OrderInventory	ORDERS	13	Ship Date			1
237	DB_OrderInventory	ORDERS	14	Ship VIA
238	DB_OrderInventory	ORDERS	15	Tax Rate	I		1
239	DB_OrderInventory	ORDERS	16	Terms	I		1
240	DB_OrderInventory	ORDERS	17	Customer PO	I		1
241	DB_OrderInventory	ORDERS	18	Payment Method	I		1
242	DB_OrderInventory	ORDERS	19	Notes
243	DB_OrderInventory	PAYMENTS	1	Payment Rec ID	K		1
244	DB_OrderInventory	PAYMENTS	2	Order Rec ID_FK	Q	ORDERS	1
245	DB_OrderInventory	PAYMENTS	3	Payment Number			1
246	DB_OrderInventory	PAYMENTS	4	Receipt Number
247	DB_OrderInventory	PAYMENTS	5	Check / PO Number
248	DB_OrderInventory	PAYMENTS	6	Payment Date
249	DB_OrderInventory	PAYMENTS	7	Amount			1
250	DB_OrderInventory	STCKHIST	1	Stckhist Rec ID	K		1
251	DB_OrderInventory	STCKHIST	2	Stock Rec ID_FK	I		1
252	DB_OrderInventory	STCKHIST	3	Transact Rec ID_FK	Q	TRANSACT	1
253	DB_OrderInventory	STCKHIST	4	Transaction Qty
254	DB_OrderInventory	STCKHIST	5	Transaction U/M
255	DB_OrderInventory	STCKHIST	6	Transaction Date
256	DB_OrderInventory	STCKHIST	7	Document ID
257	DB_OrderInventory	STOCK	1	Stock Rec ID	K		1
258	DB_OrderInventory	STOCK	2	Part Name	I	U	1
259	DB_OrderInventory	STOCK	3	Description
260	DB_OrderInventory	STOCK	4	Vendors Rec ID_FK	Q	VENDORS	1
261	DB_OrderInventory	STOCK	5	Qty Minimum
262	DB_OrderInventory	STOCK	6	Unit of Measure
263	DB_OrderInventory	STOCK	7	Qty Per Unit
264	DB_OrderInventory	STOCK	8	Group Rec ID_FK	Q	GROUP	1
265	DB_OrderInventory	STOCK	9	Selling Price
266	DB_OrderInventory	STOCK	10	Qty on Order
267	DB_OrderInventory	STOCK	11	Qty on Hand
268	DB_OrderInventory	STOCK	12	Location Rec ID_FK	Q	LOCATION	1
269	DB_OrderInventory	STOCK	13	Notes
270	DB_OrderInventory	TRANSACT	1	Transact Rec ID	K		1
271	DB_OrderInventory	TRANSACT	2	Transaction	I	U	1
272	DB_OrderInventory	TRANSACT	3	Transaction Description			1
273	DB_OrderInventory	VENDORS	1	Vendors Rec ID	K		1
274	DB_OrderInventory	VENDORS	2	Vendor Name	I		1
275	DB_OrderInventory	VENDORS	3	Contact
276	DB_OrderInventory	VENDORS	4	Address
277	DB_OrderInventory	VENDORS	5	Department
278	DB_OrderInventory	VENDORS	6	City
279	DB_OrderInventory	VENDORS	7	State/Prov
280	DB_OrderInventory	VENDORS	8	Zip
281	DB_OrderInventory	VENDORS	9	Phone
282	DB_OrderInventory	VENDORS	10	Fax
283	DB_OrderInventory	VENDORS	11	E-Mail
284	DB_OrderInventory	VENDORS	12	URL Address
285	DB_Video	HISTORY	1	History Rec ID	K		1
286	DB_Video	HISTORY	2	Customer Rec ID_FK	Q	VID_CUST	1
287	DB_Video	HISTORY	3	Rentals Rec ID_FK	Q	RENTALS	1
288	DB_Video	HISTORY	4	Inventory Rec ID_FK	Q	INVNTORY	1
289	DB_Video	HISTORY	5	Return Date	I		1
290	DB_Video	HISTORY	6	Late Fee Paid			1
291	DB_Video	HISTORY	7	Selected			1
292	DB_Video	INVNTORY	1	Inventory Rec ID	K		1
293	DB_Video	INVNTORY	2	Titles Rec ID_FK	Q	TITLES	1
294	DB_Video	INVNTORY	3	Media Type
295	DB_Video	INVNTORY	4	Checked Out			1
296	DB_Video	INVNTORY	5	Sold			1
297	DB_Video	INVNTORY	6	Date Purchased
298	DB_Video	INVNTORY	7	Number of Rentals
299	DB_Video	INVOICE	1	Customer Rec ID	K		1
300	DB_Video	INVOICE	2	Borrow Date			1
301	DB_Video	INVOICE	3	Due Date			1
302	DB_Video	INVOICE	4	Video Title			1
303	DB_Video	INVOICE	5	WholeName			1
304	DB_Video	LATEVID	1	Inventory Rec ID			1
305	DB_Video	LATEVID	2	Phone Number			1
306	DB_Video	LATEVID	3	Borrow Date			1
307	DB_Video	LATEVID	4	Video Title			1
308	DB_Video	LATEVID	5	WholeName			1
309	DB_Video	LATEVID	6	DaysLate			1
310	DB_Video	RENTALS	1	Rentals Rec ID	K		1
311	DB_Video	RENTALS	2	Customer Rec ID_FK	Q	VID_CUST	1
312	DB_Video	RENTALS	3	Renters Rec ID_FK	Q	RENTERS	1
313	DB_Video	RENTALS	4	Borrow Date			1
314	DB_Video	RENTALS	5	Due Date			1
315	DB_Video	RENTALS	6	All Checked In
316	DB_Video	RENTERS	1	Renters Rec ID	K		1
317	DB_Video	RENTERS	2	Customer Rec ID_FK	Q	VID_CUST	1
318	DB_Video	RENTERS	3	Renter			1
319	DB_Video	TITLES	1	Titles Rec ID	K		1
320	DB_Video	TITLES	2	Video Title			1
321	DB_Video	TITLES	3	Video Type
322	DB_Video	TITLES	4	Year
323	DB_Video	TITLES	5	Comments
324	DB_Video	VID_CUST	1	Customer Rec ID	K		1
325	DB_Video	VID_CUST	2	Total Late Fee
326	DB_Video	VID_CUST	3	Last Name			1
327	DB_Video	VID_CUST	4	First Name			1
328	DB_Video	VID_CUST	5	Address
329	DB_Video	VID_CUST	6	City
330	DB_Video	VID_CUST	7	State/Prov
331	DB_Video	VID_CUST	8	Zip Code
332	DB_Video	VID_CUST	9	Phone Number
333	DB_Video	VID_CUST	10	Fax Number
334	DB_Video	VID_CUST	11	Credit Card Type			1
335	DB_Video	VID_CUST	12	Credit Card Number
336	DB_Video	VID_CUST	13	Date Entered
337	DB_Video	VID_CUST	14	Additional Names