There are over 170 base tables in strokeone
Click to expand this section to see more details.
Name | FMP ID | Fields | Records |
JobLine |
138 |
154 |
2,428,967 |
JobLineStatus |
228 |
89 |
2,423,024 |
ItemLocationHistory |
317 |
12 |
1,910,031 |
ItemMovement |
307 |
12 |
1,872,804 |
PurchaseOrderLineHistory |
223 |
10 |
990,525 |
InvoiceLine |
160 |
35 |
752,455 |
JobLineGroupLabelLine |
280 |
8 |
714,727 |
JobLineToolingLine |
236 |
30 |
679,944 |
ItemStock |
222 |
31 |
657,395 |
Item |
152 |
201 |
657,263 |
ItemDesign |
294 |
10 |
637,186 |
PurchaseOrderLine |
221 |
38 |
604,972 |
JobLineGroupJobLine |
232 |
9 |
587,750 |
JobLineImage |
161 |
12 |
587,271 |
PurchaseOrderBucket |
190 |
17 |
479,836 |
JobLineGroup |
189 |
193 |
371,940 |
DesignImage |
163 |
10 |
325,423 |
JobLineDesign |
224 |
35 |
321,129 |
JobLineSchedule |
168 |
121 |
304,772 |
ItemContainer |
247 |
4 |
278,115 |
JobLabel |
271 |
8 |
235,386 |
JobFile |
180 |
10 |
226,006 |
ItemSupplier |
225 |
6 |
152,971 |
CompanyAPIImportLine |
333 |
10 |
152,653 |
ItemSku |
206 |
10 |
142,438 |
PurchaseOrderDelivery |
227 |
31 |
135,941 |
JobStatus |
229 |
49 |
133,644 |
Job |
136 |
147 |
133,473 |
Invoice |
159 |
71 |
129,611 |
PurchaseOrderFile |
270 |
7 |
124,960 |
PurchaseOrder |
220 |
105 |
123,924 |
VendorSiteBasketLine |
287 |
5 |
119,297 |
InvoicePayment |
185 |
12 |
112,998 |
ToolingLine |
165 |
20 |
110,468 |
CompanyAPIImport |
332 |
23 |
97,278 |
PurchaseOrderDeliveryFile |
272 |
8 |
91,001 |
JobLineGroupSignature |
291 |
11 |
88,915 |
JobLineGroupAPIExport |
347 |
23 |
85,953 |
PurchaseOrderGoodsInLabel |
264 |
8 |
83,348 |
EnquiryQuoteLine |
158 |
65 |
73,160 |
Design |
162 |
65 |
71,640 |
JobPODLabel |
352 |
10 |
68,325 |
ItemImport |
311 |
17 |
54,732 |
EnquiryLine |
170 |
62 |
45,159 |
ItemLocation |
181 |
32 |
40,593 |
Tooling |
164 |
55 |
37,259 |
ItemFamilyImage |
283 |
16 |
34,142 |
MatrixItem |
325 |
14 |
31,289 |
EnquiryFile |
171 |
11 |
19,515 |
ItemCost |
207 |
9 |
19,416 |
CompanyAPISKU |
339 |
14 |
16,086 |
EnquiryQuote |
157 |
39 |
15,280 |
Payment |
187 |
16 |
14,367 |
StaffTask |
146 |
20 |
13,468 |
VendorSiteBasket |
286 |
25 |
12,992 |
Location |
182 |
52 |
12,564 |
ProductionMaintenanceSchedule |
192 |
30 |
12,347 |
CompanyCategory |
134 |
9 |
12,067 |
ItemBoM |
241 |
9 |
10,254 |
Enquiry |
166 |
59 |
9,790 |
DesignGroupList |
335 |
9 |
7,155 |
MatrixProduction |
324 |
16 |
7,024 |
DesignGroup |
334 |
17 |
6,221 |
CompanyContact |
135 |
41 |
5,469 |
StaffTaskHistory |
239 |
8 |
4,929 |
ItemBlankStyle |
253 |
5 |
4,609 |
StaffTaskModule |
238 |
27 |
4,048 |
JobLineMistake |
249 |
34 |
3,758 |
StaffAbsence |
143 |
22 |
3,643 |
StaffDiscipline |
210 |
30 |
3,203 |
MatrixFulfilment |
328 |
36 |
2,668 |
CompanyContactCorrespondence |
215 |
25 |
2,488 |
Company |
133 |
130 |
2,339 |
ProductionMaintenance |
191 |
28 |
1,819 |
StaffFile |
174 |
10 |
1,622 |
TrainingTaskModule |
209 |
17 |
1,585 |
Maintenance |
346 |
38 |
1,559 |
VirtualListSingleWindow |
263 |
13 |
1,500 |
StaffDisciplineFile |
211 |
12 |
1,406 |
ItemBlankColour |
254 |
5 |
1,285 |
TrainingTaskFile |
208 |
7 |
1,199 |
JobLineMistakeFile |
250 |
12 |
1,015 |
VirtualList |
202 |
41 |
1,000 |
JobLineGroupCollection |
321 |
15 |
878 |
ItemBlankType |
252 |
12 |
839 |
ItemBlankBrandMatrixItem |
345 |
8 |
759 |
StaffMeetingFile |
244 |
8 |
754 |
TrainingTask |
151 |
26 |
695 |
ItemBlankBrand |
251 |
5 |
686 |
StaffModule |
176 |
22 |
592 |
Staff |
142 |
39 |
581 |
StaffMeetingActionPoint |
275 |
15 |
518 |
StaffDetail |
145 |
80 |
517 |
ItemBlankSize |
256 |
9 |
464 |
Venue |
226 |
28 |
299 |
StaffHolidayEntitlement |
199 |
21 |
278 |
ItemFile |
155 |
11 |
230 |
JobLineSpreadsheetImport |
308 |
11 |
203 |
ItemBlankTrim |
255 |
5 |
197 |
ItemContactsAccess |
296 |
4 |
164 |
DesignAlteration |
237 |
19 |
162 |
PostageCountry |
337 |
8 |
153 |
TrainingModuleProductionShift |
231 |
9 |
138 |
StaffDepartmentPosition |
234 |
5 |
130 |
CompanyAPIIntegration |
292 |
46 |
123 |
DesignPeripheral |
322 |
4 |
120 |
CompanyUnassignedArt |
288 |
16 |
101 |
ProductionMaintenanceFile |
194 |
12 |
100 |
PaymentRefund |
279 |
14 |
88 |
Matrix |
218 |
15 |
88 |
TrainingModule |
150 |
30 |
84 |
PostalStateCode |
354 |
6 |
83 |
CompanyAPIProcessline |
312 |
14 |
81 |
MatrixArtwork |
320 |
9 |
78 |
StaffReview |
173 |
26 |
77 |
CompanyVenueRecipient |
298 |
8 |
75 |
JobLineMistakeStaffDepartment |
274 |
10 |
69 |
ProductionMachine |
140 |
23 |
69 |
VenueRecipient |
262 |
13 |
68 |
ItemPeripheralType |
261 |
5 |
64 |
PostalServiceRegion |
340 |
7 |
62 |
ItemPeripheralSize |
265 |
5 |
57 |
ItemMerchandiseType |
290 |
5 |
54 |
CompanyFile |
177 |
8 |
51 |
JobNote |
179 |
6 |
47 |
MatrixGroupProduction |
323 |
9 |
43 |
StaffMeeting |
245 |
27 |
42 |
ItemPeripheralColour |
266 |
5 |
37 |
StaffSubDepartment |
144 |
11 |
36 |
MatrixGroup |
219 |
12 |
35 |
FramesCollection |
306 |
12 |
33 |
CompanyContactFile |
178 |
7 |
30 |
StaffNote |
175 |
6 |
29 |
CompanyNote |
184 |
7 |
29 |
PurchaseOrderBucketType |
258 |
10 |
26 |
Manifest |
349 |
8 |
25 |
StaffDepartment |
195 |
10 |
25 |
StaffReviewFile |
313 |
13 |
21 |
ItemBlankSizeType |
278 |
7 |
21 |
MatrixGroupArtwork |
319 |
8 |
19 |
MatrixGroupItem |
326 |
8 |
19 |
MatrixGroupFulfilment |
327 |
7 |
17 |
PostalDelivery |
336 |
3 |
16 |
PostalServiceCode |
338 |
4 |
13 |
ItemMerchandiseColour |
289 |
5 |
10 |
PostalPackage |
331 |
3 |
10 |
StaffMeetingActionPointFile |
277 |
11 |
9 |
ValueList_StaffDepartment_Process |
284 |
2 |
7 |
PostalService |
330 |
12 |
6 |
ItemInkType |
273 |
5 |
6 |
BarcodeCommands |
350 |
3 |
6 |
StaffQualification |
216 |
13 |
5 |
PostalDestination |
329 |
4 |
5 |
PostalVolume |
341 |
17 |
4 |
InkSetItem |
305 |
8 |
4 |
ValueList_Company_SupplierType_DST |
285 |
2 |
4 |
DigitalCost |
348 |
9 |
4 |
PostalPriceStructure |
344 |
3 |
3 |
StaffQualificationType |
217 |
13 |
3 |
SystemVATRate |
200 |
9 |
2 |
StaffHolidaySchedule |
193 |
9 |
2 |
ProductionShift |
141 |
6 |
2 |
Accident |
314 |
18 |
2 |
SystemPref |
149 |
170 |
1 |
SystemGlobalWebDirect |
260 |
95 |
1 |
InkSet |
304 |
8 |
1 |
ApprovalTokens |
297 |
9 |
1 |
StaffOvertime |
172 |
10 |
1 |
StartUp |
318 |
- |
- |
CompanyVenue |
299 |
4 |
- |
StaffItem |
183 |
12 |
- |
SystemTransactions |
309 |
5 |
- |
DesignNote |
235 |
11 |
- |
EnquiryQuoteFile |
169 |
11 |
- |
ItemStatusQueue |
276 |
17 |
- |
AccidentFile |
316 |
6 |
- |
PostageCode |
315 |
4 |
- |