📥 Export to Excel (CSV) ⚙ Advanced filters

customfield

36 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: activeFlag, customFieldTypeId, description, listId, required, sortOrder, tableId

id ▼ accessRight activeFlag customFieldTypeId description listId name required sortOrder tableId
2 _binary _binary  1     ID _binary 1 -2003201472
3 _binary _binary  2     Date _binary 2 -2003201472
4 _binary _binary  1     ID _binary 1 -1200586080
7 _binary _binary 1 DO NOT USE - Methid to approve vendor   Approval Method _binary 7 -850561568
8 _binary _binary  2 Date vendor needs to be re-approved   Re-Approval Date _binary 5 -850561568
9 _binary _binary 1 DO NOT USE - Method used to reapprove vendor   Re-approval Method _binary 8 -850561568
10 _binary _binary  6 BOM was reviewed and approved by Engineering   Reviewed by Engineering _binary 1 1705436292
11 _binary _binary  2 Customer Request Date   CRD _binary 1 1002104832
12 _binary _binary  2 Original Promise Date   OPD _binary 2 1002104832
13 _binary _binary 1 12/10/25 Marked in active by ER   Innofiber Rev _binary 3 -2003201472
14 _binary _binary  1     Revision Level _binary 2 -1200586080
15 _binary _binary  6 Is this Reach Compliant   Reach Compliant _binary 5 -2003201472
16 _binary _binary  6 Is this ROHS Compliant   ROHS Compliant _binary 6 -2003201472
17 _binary _binary  7 Select Methods from List used to approved vendors 3 Supplier Approval Method _binary 3 -850561568
18 _binary _binary  7 Methods used when Supplier Re-approval is required 3 Supplier Re-Approval Method _binary 4 -850561568
19 _binary _binary  7   4 Tier Level Assignment _binary 2 -850561568
20 _binary _binary  7 Supplier Score Rating 5 Supplier Performance _binary 6 -850561568
21 _binary _binary  5 Supplier ID Number   Supplier ID _binary  1 -850561568
22 _binary _binary  1     Need REACH and RoHs Certification _binary 1 397076832
23 _binary _binary  1     Need REACH Certification With Shipment _binary 2 397076832
24 _binary _binary  1     Need RoHs Certification with Shipment _binary 3 397076832
26 _binary _binary  1 Customer Revision   Cust Rev _binary 4 -2003201472
27 _binary _binary  1 Customer Revision   Cust Rev _binary  1 97022306
28 _binary _binary  1 Customer Revision   Cust Rev _binary 3 1002104832
29 _binary _binary 1     Vendor Notes _binary 3 -1200586080
30 _binary _binary  9     Operator _binary 1 -1031383360
31 _binary _binary  9 Record tool numbers that were used on the jobs.   Tool Number _binary 2 -1031383360
33 _binary _binary  6 Check box if this is a commissioned sales order   Commission? _binary 1 1012013120
34 _binary _binary  1 Enter in project number   Project Number _binary 4 397076832
35 _binary _binary  1 Enter in project number   Project Number _binary 2 1012013120
37 _binary _binary  4 Lead Time   Vendor Lead Time _binary 7 -2003201472
38 _binary _binary  3     Budget Amount _binary 3 1012013120
39 _binary _binary  1 Used for lot #'s or release numbers customers ask to have on their invoices or parts   Ref # _binary 4 1002104832
40 _binary _binary  1 Imput as CARRIER NAME: TRACKING NUMBER   Freight Tracking Number _binary 5 397076832
41 _binary _binary  1     Project Number _binary 1 -217859456
42 _binary _binary  7 Make/Buy 6 Make/Buy _binary 8 -2003201472

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "customfield" (
 "id" INTEGERNOT NULL ,
 "accessRight" INTEGER NOT NULL,
 "activeFlag" INTEGER NOT NULL,
 "customFieldTypeId" INTEGERNOT NULL,
 "description" TEXT DEFAULT NULL,
 "listId" INTEGERDEFAULT NULL,
 "name" TEXT NOT NULL,
 "required" INTEGER NOT NULL,
 "sortOrder" INTEGERNOT NULL,
 "tableId" INTEGERNOT NULL,
 PRIMARY KEY ("id")
);